PROFESSIONAL SUMMARY:

• Over 7 years of in - depth experience in Software Design, database design, development, administration and maintenance of SQL Server 2016,2017, 2014/2012/2008/2008 R2/2005/2000 large scale databases.
• Excellent experience level skills in Objects creation such as Tables and Views, Table Normalization, User created Data Types, user functions, views, user profiles, data dictionaries, data integrity, Performance tuning, Indexes and appropriate Triggers to facilitate efficient data manipulation and data consistency.
• Excellent experience in writing T-SQL queries, creating clustered and non-clustered Index, working on DTS, Data Cleansing and Data Migration.
• Extensive experience in Microsoft stack of BI solutions - SSRS, SSIS with MS SQL 2012/2008/2005.
• Proficiency in creating diverse types of Reports such as Cross-Tab, Drill-down, Summary, Parameterized, Sub reports and formatting them using SSRS.
• Strong Knowledge in Enhancing and Deploying the SSIS Packages from Development Server to Production Server.
• Excellent experience in Designing, Maintaining and tuning various RDBMS like T-SQL & MS SQL Server.
• Experience in Extraction & Migration of Data from heterogeneous data sources like Excel, MS Access, Oracle, DB2 to MS SQL Server by using Import Export Wizard, DTS SSIS, BCP & Bulk Insert utilities,
• Experience in transforming unstructured data from various data sources using SSIS Transformations like Conditional Split, Data conversion, Lookup, Merge Join and Sort and Derived Column for cleaning bad data, validating data.
• Used change data capture (CDC) control task that makes efficient data loading (incremental load after initial loading of data).
• Created SSIS packages using package logging, Breakpoints, Checkpoints and Event handling to fix the errors.
• Knowledge in migrating DTS packages, reports and analysis services projects from SQL Server 2000/2008/2012 to SQL Server 2005/2008/2012/2014.
• Highly experienced in database server performance tuning and optimization of Complex SQL queries.
• Launching the report builder for AD HOC reports.
• Complete knowledge in optimization tools such as Index tuning wizard, SQL Profiler and Windows Performance Monitor for monitoring and tuning MS SQL Server Performance.
• Performed DBA tasks using Enterprise Manager and Query Analyzer.
• Accomplished in creating Packages, scheduling Jobs and sending Alerts using SQL Mail
• Extensive experience in Capacity Planning, Disaster Recovery, Troubleshooting, Backup and Restore procedures.
• Worked closely with development and Technical Support team to resolve Visual Basic .Net issues.
• An excellent team player& technically strong person who has capability to work with business users, project managers, team leads and architects, thus maintaining healthy environment in the project
• 24x7 Production Database on Call Support.

PROFESSIONAL EXPERIENCE:

SQL Developer / Analyst

Confidential Maryland

Responsibilities:

• Involve in all phases of data warehouse development viz. Requirements analysis, application design, development (including ETL and database), code migration, testing, and implementation in Production environment, Production support and on call support for night jobs and weekend support.
• Involved in hard Coding and data analysis of Complex Queries, stored procedures, Batch Scripts, Triggers, and Functions using T-SQL.
• Conduct data analysis to support customer requests including reconciliation of submissions
• Analyze system problems, determine root cause, initiate corrective action, and provide follow up to ensure that correction is made.
• Provide Production Support in terms of incident management: identifying issues, reporting incidents, escalations, troubleshooting, problem resolution in a timely manner, and post implementation reviews
• Ensure data quality by writing and executing procedures for cross checking totals and identifying data anomalies. Triage data related issues.
• Create different sql scripts to address Issues and resolve client incident issues with in set service agreement.
• Create Complex Stored Procedures, Triggers, Views, Cursor, Constraints,user and system functions and decision making statements on database objects to address diffrnet issues and monitore those identified issues.
• Identifies, automates and implements business process efficiencies using SSIS and SSRS BI solutions.
• Designed new ETL packages dealing with different data sources (SQL Server, CSV, Flat Files etc.) and loaded the data into target data destination by performing different kinds of transformations using SQL Server Integration Services (SSIS) and upgrade different existing Pckages.
• Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.Enhanced the functionality in database and data warehousing.

SQL/ETL developer

Confidential, MA

Responsibilities:

• Involved in designing, reviewing, and creating Views, Indexes, Stored procedure, Functions, Triggers based on logical design models, user requirements and physical constraints.
• Optimized Query Performance, Session Performance and Reliability.
• Extract, Transform and Load source data into respective target tables to build the require data marts.
• Understand user requirements and Data Model defined and developed by the business analysts and data architects.
• Created complex Stored Procedures, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards.
• Implemented different types of constraints on tables. Designed and applied entity and attributes description and definition for the models.
• Managed indexes, statistics and tuned queries by using execution plan for optimizing the performance of the databases.
• Maintained the physical database by monitoring and optimizing performance, data integrity and SQL queries for maximum efficiency using SQL Profiler.
• Created ETL process using SSIS to transfer data from heterogeneous data sources.
• Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Worked on different sources in SSIS (XML, Flat file, Excel, OLEDB Source).
• Expeiance in developed C# scripting for packages using Scrip task and when required
• Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.Enhanced the functionality in database and data warehousing .
• Managed indexes, statistics and tuned queries by using execution plan for optimizing the performance of the databases.
• Maintained the physical database by monitoring and optimizing performance, data integrity and SQL queries for maximum efficiency using SQL Profiler.
• Migrated data from IBM-DB2 to SQL Server 2008/2012/2016/2017 with SQL Server Integrated Services (SSIS).

SQL/SSIS/SSRS developer

Confidential, Madison

Responsibilities:

• Optimized schema, performance, and capacity planning of various data transformation processes related to the reports.
• Make sure that standards and best practices in database development were followed and maintained.
• Defined and designed the data sourcing and data flows, data quality analysis.
• Identified the data source and defined them to build the data source views.
• Wrote Complex Stored Procedures, Triggers, Views and Queries. Created indexes, Constraints and rules on database objects.
• Developed and deployed SSIS packages to load data from OLTP to Data Warehouse system.
• Designed ETL packages dealing with different data sources (SQL Server, CSV, Flat Files etc.) and loaded the data into target data destination by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Develop C# code in as per requirement in developing SSIS Package
• Used SQL Server Agent to automate the SSIS 2008 package execution.
• Developed stored procedures to transform the data from enterprise data warehouse to SQL server and load data to fact tables.
• Transferred data from various sources like MS Excel, MS Access, and SQL Server using SSIS2012/2014 and then created reports using this data using SSRS.
• Configured and maintained Report Manager and Report Server for SSRS.
• Identified and added the report parameters and created the reports based on the requirements using SSRS 2015.
• Worked intensively on the Crystal Management Console and produced monthly report
• Tested and managed the SSIS 2015 packages and was responsible for its security.
• Scheduled and monitored all maintenance activities of SQL Server 2016 including database consistency checks and index defragmentation.
• Set up database backup and recovery strategies.
• Designed and Implemented the Stored Procedures and Triggers for automating tasks.
• Maintained all records of project status and followed changes as per control procedures.
• Provided technical support to internal developers and external clients.
• Generated test data and tested database to meet the functionalities/deliverables in the project documentation and specifications.
• Expertise in offshore onsite model. Coordinating teams. Following up things.

MS SQL Developer / BI Developer

Confidential

Responsibilities:

• Worked closely with SME’s end users/internal customers to understand project/requirement scope and involved in providing solution to implement or support production issues.
• Reviewed and developed data models and database designs with development teams
• Created Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Developed SSIS packages to Extract, Transform and Load (ETL) data into the data warehouse database from heterogeneous databases/data sources.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing various kinds of transformations using SSIS/DTS packages.
• Designed and developed data load jobs using SSIS package and scheduled in SQL Agent.
• Wrote stored procedures and User Define Scalar and table-valued Functions (UDFs) to be used in the SSIS packages and SQL scripts.
• Developed mapping spreadsheets for (ETL) team with source to target data mapping with physical naming standards, datatypes, volumetric, domain definitions, and corporate meta-data definitions.
• Created packages with different control flow options and data flow transformations such as Conditional Split, Multicast, Union all and Derived Column etc.
• Created SSIS packages for File Transfer from one location to the other using FTP task with Master SSIS Package to run all other packages.
• Assisted in production OLAP cubes, wrote queries to produce reports using SQL Server 2005/2008R2/2012 Analysis Services (SSAS) and Reporting service (SSRS)
• Created tabular and Matrix Reports using SSRS with different type of properties like chart controls, filters, Interactive Sorting, SQL parameters etc.
• Developed several types of reports like Drill down, Drill through, sub reports and parameterized reports using SQL Server Reporting Services 2008 R2.
• Involved in designing, developing, debugging and testing of reports in SQL Server Reporting Services (SSRS).
• Implemented database standards and naming convention for the database objects and documentation of all the processes involved in maintaining the database for future reference.
• Used Bulk Copy program (BCP) to import and export substantial amounts of data in and out of SQL Server databases.
• Designed and built Star and Snowflake dimensional models creating facts, dimensions, measures, cube and established data granularity.
• Participated in Databases Architecture and data modeling design.
• Inspected the reports and fixed bugs in stored procedures and tuned Reporting Services to the T-SQL,
• Worked on Change Management Cases to resolve the production change request issues based on the Specifications provided.
• Database Administration, Production and Development Support.
• Monitoring Performance of SQL server using SQL Profiler, Query Analyzer, Database Engine Tuning Advisor (DTA) and Performance monitoring.
• Worked on Agile Methodology and Microsoft Team Foundation Server (TFS)

SQL / SSIS/SSRS Developer

Confidential, West Chester, PA

Responsibilities:

• Developed logical and physical database (using ER-win, Normalization, Dimension Modeling and Enterprise Manager).
• Optimized schema, performance, and capacity planning of various data transformation processes related to the reports.
• Make sure that standards and best practices in database development were followed and maintained.
• Defined and designed the data sourcing and data flows, data quality analysis.
• Wrote Complex Stored Procedures, Triggers, Views and Queries. Created indexes, Constraints and rules on database objects.
• Designed ETL packages dealing with different data sources (SQL Server, CSV, Flat Files etc.) and loaded the data into target data destination by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Used SQL Server Agent to automate the SSIS package execution.
• Developed stored procedures to transform the data from enterprise data warehouse to SQL server and load data to fact tables.
• Transferred data from various sources like MS Excel, MS Access, and SQL Server using SSIS2005/2008 and then created reports using this data using SSRS.
• Configured and maintained Report Manager and Report Server for SSRS.
• Identified and add report parameters and created the reports based on the requirements using SSRS 2008.
• Scheduled and monitored all maintenance activities of SQL Server 2005 including database consistency checks and index defragmentation.
• Set up database backup and recovery strategies.
• Maintained all records of project status and followed changes as per control procedures.
• Provided technical support to internal developers and external clients.
• Generated test data and tested database to meet the functionalities/deliverables in the project documentation and specifications.

SQL /SSIS/SSRS Developer

Confidential, Ethiopia

Responsibilities:

• Involved in complete SDLC life cycle.
• Extract, Transform and Load source data into respective target tables to build the required data marts.
• Understand user requirements and Data Model defined and developed by the business analysts and data architects.
• Performed DBA tasks like Backup, Restore of tables and Stored Procedures and Refreshing Database on weekly basis.
• Created complex Stored Procedures, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards.
• Implemented different types of constraints on tables.
• Designed and applied entity and attributes description and definition for the models.
• Created ETL process using SSIS to transfer data from heterogeneous data sources.
• Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Migrated DTS objects to SQL Server Integrated Services (SSIS) environment.
• Worked on different sources in SSIS (XML, Flat file, Excel, OLEDB Source).
• Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Develop/Build/Deploying all the database and ETL objects using TFS 2012.
• Responsible for gathering business requirements to create business user reports.
• Created Parameterized, Cascaded, Drill-down, Cross-tab and Drill-through Reports using SSRS2008.
• Developed optimal stored procedures and queries to create data sets for reports.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Worked on performance tuning on existing stored procedures and existing reports for the faster processing of reports.
• Performed unit and system testing, troubleshooting and bug fixing in Prod and QA environments.

Environment: MS SQL Server 2008R2 & 2012 Enterprise Edition, MDX, T-SQL, MS Access, MS Excel, & Windows 2003 server, OLAP, OLTP, .NET, ETL, SSIS, SSRS, SSAS, C#, TFS, Crystal reports, Cosmos.