Description :

1. Working with client/business analysts to define data requirements for enterprise analytical reporting needs.
2. Designing and developing the automated routines (scripts etc.) to facilitate the application development and deployment process.
3. Maintaining DB schema and code change management using TFS and Redgates SQL compare.
4. Maintaining the product application data which is critical in product lifecycle and efficiently implementing the data migration in each release.
5. Implementing the heartbeat product role-based security which defines access to each individual functionality based on their role-based permissions.
6. Involving in database design, application development of health benefits functionality and developed mission-critical benefits eligibility exception report.
7. Developing SQL routines for complex, enterprise-level application development tasks involving hierarchical tree structures.

Experience

10+ Years

Level

Management

Education

M.S.

Description :

Experience

5-7 Years

Level

Executive

Education

DTS

Description :

1. Involving in all phases of SDLC, and gathering business requirements from business people.
2. Converting Data Transformation Services (DTS) application to SQL Server Integrated Services (SSIS) as assigned.
3. Developing DTS packages to extract, transform and load into the campaign database from OLTP database using SQL server integration services (SSIS).
4. Created ETL metadata reports using SSRS, reports including execution times for the SSIS packages, failure reports with the error description.
5. Designed SSIS packages to extract, transfer, load (ETL) existing data into SQL server from different environments.
6. Creating complex stored procedures using a linked server, CTE, temp table, SQL joins, ranking functions and dynamic SQL and responsible for performing t-SQL tuning, multi-tasking and optimizing queries which takes longer time in execution with SQL server 2008/2012.
7. Performing documentation for all kinds of reports and DTS and SSIS packages.

Experience

7-10 Years

Level

Senior

Education

B.Sc. CS

Description :

1. Worked extensively with SSIS to import, export and transform the data between the linked servers.
2. Involving in business analysis and technical design sessions with business and technical staff to develop entity-relationship/data models, requirements document, and ETL specifications.
3. Creating the database objects like procedures, functions, packages, triggers, indexes, and views using t-SQL in development and production environment for SQL server 2005.
4. Using DDL and DML for writing triggers, stored procedures, and data manipulation.
5. Creating database and database objects like tables, stored procedures, views, triggers, rules, defaults, user-defined data types, and functions.
6. Involving in unit testing, user acceptance testing to check whether the data is loading into the target, which was extracted from different source systems according to the user requirements.
7. Generated database SQL scripts and deployed databases including installation and configuration.

Experience

10+ Years

Level

Management

Education

B.Sc. CS

Description :

1. Working on various possible performance-related issues including database tuning with the sole intention of achieving faster response times and better throughput. 
2. Migrated DTS packages from SQL Server 2000 to SQL server 2012 as SSIS packages.
3. Experience in working on cube structure optimization for MDX query performance in analysis services 2008.
4. Excellent report creation skills using Microsoft SQL server 2012/2008r2 reporting services (SSRS) with proficiency in using report designer as well as report builder.
5. Created SQL server reports based on the requirements using SSRS 2008.
6. Worked on the reports module of the project as a developer on ms SQL server 2012 (using SSRS, t-SQL, scripts, stored procedures, and views).
7. Developed complex stored procedures, views, and temporary tables as per the requirement.

Experience

2-5 Years

Level

Junior

Education

B.S. in CS

Description :

1. Designing and developing the SSIS packages, stored procedures, configuration files, tables, views, indexes.
2. Used SSIS to extract data from enterprise data warehouse, Oracle added multiple transformations to transform the data and finally loaded into the DB2 database.
3. Using table difference, upsets, lookups, and conditional splits for finding deltas.
4. Used SQL Bi-Xpress for managing, auditing and notification frameworks.
5. Creating the SSIS jobs for monitoring the jobs that depend on daily loads and loading db2 database tables using SQL server agent.
6. Automating tasks using active x script (similar to VB Script). Be able to implement failure alerts using email in SSIS.
7. Involving in object-oriented design (UML, activity diagrams, use cases, and object modeling).
8. Involved to develop the VB script, C#, and ASP.Net, VB.Net and dot Net framework creation in SSAS and SSIS.

Experience

10+ Years

Level

Management

Education

B.S. in CS

Description :

1. Performed server installation and configuration using SQL server 2012.
2. Maintaining the database schema in source code control (MS team suite database edition preferred).
3. Developing the SQL programs and involved in optimize stored procedures and queries for faster retrieval and server efficiency SSAS and SSIS.
4. Using the quality center (defect tracking tool) for bug fixing and resolution details.
5. Involving in mock testing and unit testing and integration testing in SSIS, SSAS.
6. Creating the automated stored procedures for day end operations using SQL server agent and CTE.
7. Coordinating with the front-end for implementing logic in stored procedures and functions.

Experience

7-10 Years

Level

Senior

Education

B.Sc. CS

Description :

1. Creating the SSIS packages to load the data into SQL table using lookup transformation, conditional split, data conversion, derived column, join, merge join, slowly changing dimension.
2. Working with SSIS packages involved FTP tasks, fuzzy grouping, merge and merge join.
3. Using SQL Server package configuration technique to make dynamic configurations.
4. Generating the periodic reports based on the statistical analysis of the data using SQL server reporting services (SSRS).
5. Involving in creating calculated members, named set, advanced KPIs for the SSAS cubes.
6. Designing cubes with star schema using SQL server analysis services 2008 (SSAS).
7. Creating several dashboards and scorecards with key performance indicators (KPI) in SQL server 2005 analysis services (SSAS).

Experience

10+ Years

Level

Management

Education

B.Sc. CS

Description :

1. Extensively involved in gathering business requirements as an endeavor that will facilitate the planning and the implementation phase of a data warehouse.
2. Working closely with the business owner, project manager, subject matter experts and system architecture to define business requirements and create business requirements documents for signoff and agreement.
3. Designing the logical and physical model of OLTP database using Er-win and later forward engineered the physical model to Microsoft SQL server 2008r2.
4. Creating UML diagrams - activity diagrams and sequence diagrams using Microsoft Visio.
5. Creating the requirement enhancements document and scope document for modeling integration and data models.
6. Creating Entity Relationship Diagram (ERD) to communicate and clarify the physical data models for subject matter expert and developers.
7. Managing the database maintenance plans to maintain the database consistency and effective functioning.

Experience

10+ Years

Level

Consultant

Education

B.Sc. CS

Description :

1. Designing and implementing the snapshots report, report subscription, data-driven subscription and report caching using report manager.
2. Generating SSRS reports which included various reporting features such as groups, sub-groups, adjacent-groups, group by total, group by sub-totals, grand-totals, drill-downs, drill through, sub-reports, navigation reports.
3. Creating parameterized reports like standard parameter reports, cascading parameter reports which consist of report criteria in various reports to make minimize the report execution time and to limit the no of records required.
4. Creating the linked reports, ad-hoc reports based on the requirement. Linked reports are created in the report server to reduce the repetition in the reports.
5. Creating the subscriptions to provide reports on a daily/weekly/monthly/quarterly and annual basis.
6. Creating stored procedures to validate the data coming with different data discrepancies using data conversions.
7. Creating sub-reports, bar chart, matrix reports, parameterized reports, cross-tab reports, drill down reports & summary reports for newly created markets.

Experience

2-5 Years

Level

Junior

Education

B.Sc. in CS

Description :

1. Implemented of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
2. Rebuilt / Monitored the indexes at regular intervals for better performance.
3. Recovered the databases from backup in disasters.
4. Implemented Point-In-Time Recovery solutions.
5. Performed SQL Server service pack and Windows Service pack upgrades.
6. Extensively worked on Enterprise Manager for managing the database.
7. Troubleshoot performance problems and fine-tuning of databases.
8. Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.

Experience

2-5 Years

Level

Junior

Education

BSc CS

Description :

1. Designed to make basic healthcare available in these communities.
2. Installs and Configures of SQL Server on windows OS.
3. Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user input.
4. Participates in the creating tables, indexes, constraints, triggers, procedures, views, user defined data types and user defined functions.
5. Uses SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.
6. Researches emerging application development software products, languages, and standards in support of procurement and development efforts
7. Developed and optimized SQL queries, improving data retrieval speed by 30% for critical reporting tasks.

Experience

5-7 Years

Level

Executive

Education

B.Sc. in CS

Description :

1. Catered to more than 2 million customers, Everest Bank Limited (EBL) is a name you can depend on for professionalized & efficient banking services.
2. Developed the nation corporately, agriculturally & industrially.
3. Designed and developed SSIS packages, store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance.
4. Involved in development and implementation of SSIS application solutions for various business units across the organization.
5. Modified and transferred the data using SSIS packages.
6. Developed, monitored and deployed SSIS packages.
7. Scheduled Jobs for SSIS packages, Backups and Restore databases in Dev environment for debugging purposes.
8. Created packages in SSIS with error handling as well as created complex SSIS packages using proper control flow and data flow elements.

Experience

2-5 Years

Level

Junior

Education

B.Sc. CS

Description :

1. Involved in requirements gathering and converting them into database related components Involved in installing and configuring of the SQL Server.
2. Created Tables, Views, Stored Procedures, User-defined Functions and other DML, DDL statements.
3. Extensively used Joins and Sub-Queries to simplify queries involving multiple tables.
4. Involved in the basic database backup and recovery Implemented user login and security.
5. Involved in the development, design, and testing of the system Involved in administrative tasks of managing users, logs and profiles.
6. Documented all the processes involved in maintaining MS SQL database Gathered requirements to identify and create database objects such as tables, views, triggers and indexes.
7. Involved in Normalization of the database and bringing it to 3NF.

Experience

10+ Years

Level

Senior

Education

BSc CS

Description :

1. Identifies and understands business needs during requirements gathering to effectively design, develop, test, and deploy reports or applications.
2. Stress test and optimizes the system for efficiency in a distributed database.
3. Analyzes internal processes and make recommendations for automated workflow processes with eventual implementation.
4. Proposes technical solutions, new application design, process flows.
5. Builds custom data imports as required.
6. Troubleshoots and problem solve SQL database issues.
7. Implements and tests software/server upgrades as needed to gain better functionality.
8. Proposes and implements database architectural changes to make database infrastructure highly scalable and optimized.

Experience

2-5 Years

Level

Junior

Education

B.S. in CS