Description :

1. Created documents for technical & business user requirements during requirements gathering sessions.
2. Designed Logical and Physical models of Relational Database.
3. Built strong relationships with key business and technology partners inside and outside the platform and infrastructure team.
4. Worked on aggregate dimensions, late arriving facts and dimensions, staging tables and ODS.
5. Partnered with finance, MIS teams and accounting to ensure the consistency and accuracy of data and reporting.
6. Worked in data mapping, enabling the extract, transform and loading of the data into target tables.
7. Data mapping documents between Legacy, Production, and User Interface Systems were developed.
8. Created Entity-relationship diagrams, Function relationship diagrams, data flow diagrams and enforced all referential integrity constraints using Oracle Designer.

Experience

7-10 Years

Level

Management

Education

B.Sc. CS

Description :

1. Created Business Process Models from the requirement specifications.
2. Worked on developing Tables, Views, Indexes, Stored Procedures, Triggers, Queries, and Macros using MS SQL Server and Oracle databases.
3. Involved in Partitioning tables that have bulk inserts, deletes and updates to improve the performance.
4. Extracted data from xml and flat files using SSIS.
5. Generated parameterized/Drilldown, Drill through & Cascaded reports using SSRS and Crystal Reports.
6. Implemented ETL processes using SSIS, enhancing data integration efficiency by 25%.
7. Designed and maintained data models, supporting business intelligence initiatives and reporting accuracy.

Experience

7-10 Years

Level

Management

Education

B.Sc. Computer Science

Description :

1. Responsibilities: Interacted with the Business Users and Supervisors to gather business requirements.
2. Converted the User Requirements into Business Requirements Document, Functional and Technical Requirements Documents Created Business Process Models from the requirement specifications.
3. Worked on developing Tables, Views, Indexes, Stored Procedures, Triggers, Queries, and Macros using MS SQL Server 2005, and MS Access databases Involved in Partitioning tables that have bulk inserts, deletes and updates to improve the performance.
4. Extracted data from xml and flat files using SSIS Generated parameterized/Drilldown, Drill through & Cascaded reports using SSRS.
5. Created, maintained, modified, and optimized SQL Server databases, database security and auditing Designed, programmed, deployed and tested the requested Reports.
6. Designed ER diagrams (Physical and Logical using Erwin) and mapping the data into database objects.
7. Developed Data Flow Diagrams, illustrating the flow of data from the legacy systems into the Application database Tables, along with checkpoints for testing verification.

Experience

7-10 Years

Level

Management

Education

B.Sc. CS

Description :

1. Responsibilities: Developed, monitored and deployed SSIS packages and Responsible for Scheduling Jobs, Alerting and Maintaining SSIS Packages.
2. Worked on Data migration using SSIS from Flat Files.
3. Worked on ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load and Analyzed the Project requirement and preparing the documentation for the ETL Package Flow.
4. Created Jobs in SSIS and was responsible for ETL Job Scheduled to run daily, weekly and monthly.
5. Solved the issues associated with ETL Data Warehouse Failure.
6. Designed and developed efficient SSIS packages for processing fact and dimension tables using transformations like lookup, merge, merge join, script component and slowly changing dimension.
7. Created Stored Procedures and handling the Query Performance Issues.

Experience

2-5 Years

Level

Executive

Education

BSc CS

Description :

1. Design and implementation of Security Model, policies and procedures.
2. Query Optimization using Query Analyzer, Profiler, Show plan, Index Tuning and Stats Time Tool.
3. Created Snapshot Replication for the Development and Testing Databases across different Servers.
4. Regular responsibilities for updating staging and dimensional databases as well as rebuilding the dimensions and cubes on Analysis Services (SSAS).
5. Automated data migration processes using PL/SQL, reducing manual effort by 40% and minimizing errors.
6. Conducted performance tuning of existing PL/SQL code, achieving a 20% reduction in execution time for key reports.
7. Created and maintained comprehensive documentation for PL/SQL procedures, improving team knowledge sharing and onboarding.

Experience

2-5 Years

Level

Executive

Education

BSc CS

Description :

1. Design and deploy SSRS reports for visual presentation of the data Developed T-SQL codes, ETL Processes to collect/consolidate data from a variety of sources.
2. Developed parameterized dashboards and reports with SQL Server Reporting Services (SSRS).
3. Develop T-SQL code, stored procedures, views, functions, and other database objects to supply data needed for the reports.
4. Integrate data from various sources using SSIS, validate data and create reports.
5. Responsible for developing and optimizing reporting solutions using SQL Server Reporting Services (SSRS) to author, manage, and deliver dynamic, interactive, drill-down web-based reports.
6. Used tools (Excel and SQL) to analyze, query, sort and manipulate data according to defined business rules and procedures.
7. Optimized the queries which were running slowly.
8. Involved in rectifying invalid mappings, modify stored Procedures based on requirements and functions.

Experience

5-7 Years

Level

Executive

Education

B.Sc. CS

Description :

1. Created Entity-relationship diagrams ER-Diagrams, function relationship diagram, Dataflow Diagrams and enforced all referential integrity constraints.
2. Developed database objects like tables, views, stored procedures, indexes, etc.
3. Tuned SQL statements using views and stored procedures.
4. Rebuilding the indexes at regular intervals better performance.
5. Coded various stored procedures for the purpose of application development.
6. Design and implement data access stored procedures and triggers for automating tasks.
7. Extensively used joins and sub-queries to simplify complex queries involving multiple tables.

Experience

5-7 Years

Level

Consultant

Education

B.Sc. CS

Description :

1. Responsibilities: Worked in a team with DBAs in Installation, backups, and recovery.
2. Involved in table partitioning and index partitioning.
3. Enhanced existing customized reporting utility to meet evolving client needs and time constraints.
4. Involved in setting up development standards for the BI project.
5. Experience with performance tuning new and existing stored procedures.
6. Developed and modified SQL queries and stored procedures to meet business requirements.
7. Performed tests and produced results to ensure accurate compliance with project request requirements.

Experience

2-5 Years

Level

Executive

Education

BSc CS

Description :

1. Responsibilities: Supervised the activity of the Database for identifying the bottlenecks that are slowing down the performance of the data warehouse.
2. Identified and implemented the methods to fine tune the queries, procedures and functions.
3. Reviewed the executions of views and stored procedure and identified the bottle necks within the query.
4. Monitored Database and Server Resources with various tools such as Performance Monitor, SQL Profiler, Stored Procedures and Database Tuning Advisor.
5. Implemented Peer to Peer Transactional Replication within the system.
6. Creation of file groups for the existing Tempdb Database.
7. Changing collation in the existing configurations.

Experience

7-10 Years

Level

Management

Education

BSc CS

Description :

1. Installed SQL server 2008 on windows 2003 advanced servers, applied service packs and security fixes.
2. Imported Data from text files and excel spread sheet into SQL Server 2008 database using SSIS package.
3. Creating and managing schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements and converting them into technical specifications Have done migration of database SQL server 2005 to 2008 successfully.
4. Developing triggers, stored procedures and enforcing business rules via checks and constraints Performance tuning and optimization of procedures and queries.
5. Configured product meta-data tables to support client data reporting needs.
6. Performance: Analyzed database performance with SQL Profiler and Optimized indexes to significantly improve queries.
7. Written complex SQL statements using joins, sub queries and correlated sub queries.
8. Fine-tuned the logic in Procedures, Functions and Triggers for optimum performance.

Experience

0-2 Years

Level

Entry Level

Education

BSc CS

Description :

1. Participated in developing a logical model and implementing requirements on SQL Server 2000.
2. Created database Triggers to implement business requirements.
3. Created complex Stored Procedures and Functions to support the front-end application.
4. Optimize SQL queries for improved performance and availability.
5. Successfully created schema change scripts to existing objects to synchronize with changing business rules.
6. Monitored growth of database objects for capacity planning.
7. Worked with Quality assurance to develop test plans and test cases to conduct system testing.
8. Developed Bulk Insert, Moving files, back-Up, Recovery packages using Data Transformation System (DTS).

Experience

7-10 Years

Level

Consultant

Education

B.S. CS

Description :

1. Extensively involved in Gathering requirements by holding meetings with users.
2. Constructed context diagrams and data-flow diagrams based on a description of a business process.
3. Analyzing the data model and identification of heterogeneous data sources.
4. Constructed an extended entity-relationship diagram based on a narrative description of a business scenario.
5. Created Transformations using the SQL script to modify the data before loading into tables.
6. Installed and Configured MS SQL Server 2008.
7. Migrated SQL Server 2005 data bases into SQL Server 2008.
8. Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.

Experience

7-10 Years

Level

Management

Education

M.S. in CS