SUMMARY:

• More than 8 Years of IT experience in Designing & Development, Implementation & Maintenance of Database and BI Applications using MS SQL Server2014, 2008R2 and 2005 in Development and Production Environments.
• Experienced in all the stages of Software Development Life Cycle and in the migration and up gradation of databases.
• Involved in Quality Assurance, bug fixing and testing. Prepared user manuals, presentations and trained user and operators.
• Extensively worked on OLTP Relational Schema with Normalization and OLAP Dimensional Modeling using Star and Snowflake schema.
• Experience in database design with T - SQL through conceptual Entity Relationship Diagrams and Erwin.
• Created Indexes, Views, Constraints, Stored Procedure, User-Defined functions, CTEs, and effective DDL/DML Triggers to facilitate efficient data manipulation and data consistency.
• Experience in troubleshooting SQL issues by using SQL Tools, Execution Plans, Trace, Statistics and Index Tuning Wizard.
• Experience in using Performance Monitor, SQL Profiler and optimizing the queries, tracing long running queries and deadlocks.
• Hands on experience in creating end to end ETL strategies that will include data profiling as well as extracting transforming, conforming and loading data warehouses/ data marts for reporting purpose.
• Designed SSIS packages using various Transformations such as Fuzzy Lookup, Fuzzy Grouping, Aggregate and Derived Column Transformations.
• Data Migration to MS SQL Server using SSIS in BIDS and DTS. Performance tuning and Query optimization.
• Migrated SQL Server 2008 packages to SQL Server 2012 and 2014.
• Experience in Error Handling and Debugging packages using Checkpoints, Data Viewers, Breakpoints, Event Handlers and securing packages secured packages with Encryption in conjunction with passwords.
• Created package configurations to provide an easy solution to migrating packages from different business environments.
• Used BIDS2008R2 and 2014 to create the import and export packages. I was required to send the date to different destinations for different clients like flat file, excel, SQL server table, Oracle, DB2.
• Hands-on experience of setting up schedules for push and pull delivery methods using Standard and Data Driven subscriptions in SSRS.

TECHNICAL SKILLS:

Data base: SQL Server 2005/2008, 2008 R2/2012 and 2014.

BI Tools: BIDS/SSDT, SSIS, SSAS, SSRS, Power Pivot, Power View.

Languages: T-SQL, C, C++, C#.Net.

Web Development: HTML, DHTML, XML, IIS, LINQ, Asp.Net

Operating Systems: Windows XP, Vista, 7, 8, Windows Server.

SDLC: Waterfall, Agile, Scrum.

Data Modeling: ER-Win, MS Visio.

Others: TFS, Visual studio, Code collaborator, Quality Center SharePoint Dashboard.

PROFESSIONAL EXPERIENCE:

Confidential, PA

SQL Developer

Responsibilities:

• Developed complex T-SQL code for the application conversions.
• Created new database objects like Procedures, Functions, Indexes and Views using T-SQL.
• Data Migration to MS SQL Server using SSIS in BIDS and DTS. Performance tuning and Query optimization.
• Migrated SQL Server 2008 packages to SQL Server 2012 and 2014.
• Implemented different built in transformations tasks including SCD, Aggregate, Lookups and Data Conversion to implement complete ETL strategy.
• Used various Package configurations available for SSIS Packages like XML files and SQL Server Tables.
• Designed SSIS package templates as base code for package development incorporating package configurations, connection managers and logging in it.
• Created highly complex SSIS packages using various Data transformations like conditional splitting, For Each Loop, Multi Cast, column conversion, Script Components, error handling
• Strong in database Performance Tuning, using tuning methodology, including enterprise manager, query plans, performance views, trace files and other SQL Server tools
• Automated the ETL process by scheduling SSIS package execution by creating jobs.
• Created QA (Quality Assurance) scripts and sanity checks to further test ETL packages by comparing QA output with output from ETL package.
• Tested the packages developed in DEV server to find out any bug and handled the errors encountered at the time of testing.

Environment: SQL Server 2008 R2, 2014, T-SQL, SQL Server Integration Services (SSIS), MS Excel,, Windows Server, SharePoint, Power Pivot, TFS, Visual studio, Code collaborator and Quality Center.

SQL Server Developer/ETL Developer

Responsibilities:

• Implemented the agile process in the scrum methodology and integrated all the scrum processes with our TFS environment.
• Involved in designing of Sprint stories and further down to tasks.
• Developed complex T-SQL code for the application conversions.
• Created new database objects like Procedures, Functions, Indexes and Views using T-SQL.
• Data Migration to MS SQL Server using SSIS in BIDS and DTS. Performance tuning and Query optimization.
• Migrated SQL Server 2008 packages to SQL Server 2012 and 2014.
• Created Service Broker Queue for internal or external processes to send and receive guaranteed, asynchronous messages by using extensions to Transact-SQL Data Manipulation Language (DML).
• Utilized Dynamic SQL for user customizable queries to be answered by the SQL Server.
• Data mapping between Scottrade’s back office CRI to Broad ridge back office BPS/A.
• Implemented different built in transformations tasks including SCD, Aggregate, Lookups and Data Conversion to implement complete ETL strategy.
• Used various Package configurations available for SSIS Packages like XML files and SQL Server Tables.
• Implemented the Master Child Package Technique to manage big ETL Projects efficiently.
• Involved in debugging the Packages by utilizing SSIS features like breakpoints, Data-Viewers and custom loggings.
• Designed SSIS package templates as base code for package development incorporating package configurations, connection managers and logging in it.
• Created highly complex SSIS packages using various Data transformations like conditional splitting, For Each Loop, Multi Cast, column conversion, Script Components, error handling
• Strong in database Performance Tuning, using tuning methodology, including enterprise manager, query plans, performance views, trace files and other SQL Server tools
• Migrated existing Account numbers from CRI to BPS/A and implemented a logic in our development to generate account number on daily basis to satisfy Scottrade’s new customers.
• Automated the ETL process by scheduling SSIS package execution by creating jobs.
• Created QA (Quality Assurance) scripts and sanity checks to further test ETL packages by comparing QA output with output from ETL package.
• Tested the packages developed in DEV server to find out any bug and handled the errors encountered at the time of testing.

Environment: SQL Server 2008 R2, 2014, T-SQL, SQL Server Integration Services (SSIS), MS Excel,, Windows Server, SharePoint, Power Pivot, TFS, Visual studio, Code collaborator and Quality Center.

SQL Server Developer

Responsibilities:

• Created complex stored procedures to perform Index maintenance, data profiling, metadata search, critical staging procedures for loading data marts and reporting database.
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Used SSIS to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Used C#.Net to write Script in SSIS tasks like Script Task and Script Component.
• Written Code in C#.Net to make Web Application and connect with Backend (SQL Server).
• Implemented Master/Child Packages so only the Master Package has to be scheduled which will in turn fire the other packages.
• Created Sequence in SQL Server 2012 to insert same identity value in multiple dimension tables as per the business rules.
• Created SSISDB catalog with SQL Server 2012 to support SSIS package deployments in SSMS with Environment variables respective to each environment.
• Involved in debugging of packages with help of Breakpoints, Checkpoints, Event Handlers and Loggings.
• Handled Performance Tuning and Optimization on SSIS, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.
• Automated the ETL process by scheduling SSIS package execution by creating jobs.

Environment: SQL Server 2008R2/2012, SQL Server Agent, SQL Server Integration Services (SSIS), SharePoint, TFS, Power Pivot, Windows Server.

ETL SSIS/ Data Warehouse Developer

Responsibilities:

• Implemented the agile process in the scrum methodology and integrated all the scrum processes with our TFS environment.
• Created new database objects like Procedures, Functions, Indexes and Views using T-SQL.
• Created Views for each ETL Requirement so that all the data that has already been pulled from data sources are not pulled again into the staging database.
• Managed ETL strategy to extract, clean and deliver data to OLAP environment and ensure accuracy, consistency and integrity of the data warehouse.
• Implemented different built in transformations tasks including SCD, Aggregate, Lookups and Data Conversion to implement complete ETL strategy.
• Used various Package configurations available for SSIS Packages like XML files and SQL Server Tables.
• Involved in debugging the Packages by utilizing SSIS features like breakpoints, Data-Viewers and custom loggings.
• Designed SSIS package templates as base code for package development incorporating package configurations, connection managers and logging in it.
• Tested the packages developed to find out any bug and handled the errors encountered at the time of testing.
• Created ad-hoc reports using power pivot and performance point extracting data from heterogeneous sources.
• Identified and defined the Datasets for the report generation and wrote the queries for the drill down reports, identifying and adding the report parameters.

Environment: SQL Server 2008/2008 R2, T-SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), MS Excel, Windows Server, SharePoint, Power Pivot, TFS.

ETL/Reports Developer

Responsibilities:

• Created database projects for staging database and data warehouse in visual studio 2008, to store all related objects at one centralized location.
• Designed the entire ETL process involving the access, manipulation, analysis, interpretation and presentation of information from both internal and secondary data sources to the business.
• Created complex ETL (SSIS) packages to pull data from DB2/Oracle, load monthly data from Excel to SQL server.
• Implemented error & failure handling in SSIS packages using event handlers, row redirects, check points and used loggings for monitoring the execution.
• Optimized packages by avoiding use of non-blocking transformation, executing tasks in parallel and optimizing code at source.
• Deployed SSIS packages to the production server using XML and SQL server configurations.
• Created different kind of reports like parameterized reports, drill down reports, and sub reports to support business needs and involved in report deployment and report security.
• Configured deployment of SQL Server Reporting Services to work with deployment of Microsoft SharePoint Integrated mode.
• Implemented security on reports at Server Level, Report Level and Item Level according to the hierarchy in the organization and business requirement.
• Administered interface to organize reports and data sources, schedule report execution, delivery and track report history.

Environment: SQL Server 2008, Transact-SQL, SQL Server Integration Services (SSIS), SSRS (Reporting Services), Erwin, Windows Server.

ETL/ SSIS Developer.

Responsibilities:

• Created ER diagrams and performed normalization on them to ensure faster querying.
• Wrote complex queries, stored procedures, UDFs in support of the ETL processes, front end applications and reports.
• Designed staging database as intermediate stage for population recovery Data Mart to perform various ETL data massaging operations such as data profiling, data cleansing and data verification.
• Created ETL process using SSIS for populating data store in SQL Server.
• Successfully transferred old data from various sources like flat files, MS Access, and Excel into MS SQL Server 2008R2 using SSIS.
• Filtered bad data from legacy system using Derived column, lookup, Fuzzy Lookup, Fuzzy Grouping and Conditional Split.
• Performed various transformations like conditional split, sorting and included data about the environment using the audit transformation.
• Involved in implementing proper package configuration features and finally securing the packages by using password and encryption methods.
• Implemented transactions in SSIS by appropriately setting Transaction Option property to Supported, Not-Supported and required based on the type of strategy being implemented.
• Enabled Checkpoints on already implemented transactions to optimize entire ETL strategy so as to start the package execution from latest point of failure.
• Created the design documents for the entire project including table structures and design logic of stored procedures, packages and Reports.
• Developed data access queries/programs using SQL Query to run in production on a regular basis and assists end users with development of complex Ad Hoc queries.

Environment: SQL Server 2005, T-SQL, SSIS, DTS, MS Excel, MS Access, Flat Files.