SUMMARY

• MS SQL Server Developer wif Over 8+ years of strong experience in Semiconductor, Banking, Finance and Healthcare domains wif expertise in MS SQL Server 2012/2008R 2/2008/2005/2000 suite of products like SSRS, SSAS, and SSIS. Strong leadership, communication, problem - solving and multitasking abilities.
• Extensive experience in Data Modeling, Database Design, Programming, Development and Implementation of Client-Server Applications & Database systems using MSSQL
• Experience wif all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Expertise in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), Data Transfer Services (DTS), Bulk Insert and BCP.
• Experience in SQL Server DTS and SSIS (Integration Services) package design, development, and deployment using SQL 2012 advanced features in Control flow, data flow, Error Handling and event handling.
• Highly proficient in teh use of T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Defined Functions, Relational Database models and Data integrity, and SQL joins.
• Experience in end-user reporting definition, development and platform support using SQL Server Reporting Services (SSRS) and Tableau.
• Experienced in normalizing databases for OLTP environments and de-normalizing tables for use in OLAP environments.
• Strong noledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, dimensional modeling and reporting tools, worked wif high volume databases wif partitioned data.
• Highly experienced in optimizing MOLAP Cubes by partitioning them, Designing Aggregations, implementing Hierarchies and Calculated Members.
• Expert in Creating and Deploying SSRS Reports on teh portal for user accessibility.
• Extensive experience in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting teh data, defining data source and subtotals for teh reports using SSRS 2012/2008/2005.
• Expert in using tools like MS SQL Profiler, Index Tuning Wizard, Windows performance for monitoring and tuning SQL Server performance.

TECHNICAL SKILLS

• MS SQL Server 2012/2008R2/2008/2005
• MS SQL Server Analysis Services (SSAS)
• MS SQL Server Integration Service (SSIS)
• MS SQL Reporting Services (SSRS)
• Microsoft Access 2007/2003/8.0
• Microsoft Excel
• Outlook
• MS SQL Profiler
• SQL Query Analyzer
• MS SQL Server Index Tuning Wizard
• Erwin Data Modeler 7.1/5/4
• VB6
• Microsoft Products MS Word
• MS Excel
• TFS/VSS
• MS Access
• MS Power Point
• T-SQL
• PL-SQL
• HTML
• XML

PROFESSIONAL EXPERIENCE

Confidential, Boise, ID

MS SQL Server Developer/SSIS/SSRS Developer

Responsibilities:

• Created jobs on daily basis and schedule on every minute to update recent data by using Active batch.
• Team member of agile project and responsible for project planning for monthly sprints, Participated in story building for monthly sprints.
• Working internally wif teh engineering team to analyze teh prioritized item and determine teh best solution for deliverable or roadblocks if any.
• Created Dynamic SSIS packages using complex expressions, variables and control flow components such as For Each Loop, For Loop Container to loop over teh directory to load inbound files coming daily.
• Developed and deployed SSIS packages for ETL from various sources to staging and from staging to production using Data Conversion, Derive Column, Script Task, Condition Split, for each loop container and more. Performed ETL mappings using SSIS and MS SQL Server.
• Created SSIS package configurations for executing in different environments.
• Developed and maintained data transfers packages using SSIS, also Maintained/modified/automated teh jobs running on Servers.
• Also worked fine tuning ETL workflows for overall data transfer from teh OLTP to OLAP wif teh help of SSIS
• Responsible for creating database objects like table, Views, Store Procedure, Functions etc. using T-SQL to store data and to maintain database efficiently.
• Created/Updated database objects like tables, views, stored procedures, function, packages.
• Successfully designed/modified complex reports like cascading parameters, Drill-Through Reports, Parameterized Reports and Report Models and ad hoc reports using SQL Server Reporting Services (SSRS) based on client requirement.
• Highly involved in developing new Reporting Database, deprecating teh current Reporting database. Developed custom functions, store procedure to keep new Reporting database in sync.
• Highly involved in modifying and debugging existing SSRS reports and SSIS package as per business requirement.
• Mostly involved in Report analysis and impact due to business logic change. Worked wif business to understand upcoming changes and lockdown request.
• Gatheird requirement from Business and handled Ad Hoc Report request.
• Documented all work, so user can easily understand teh flow of process.

Confidential, Chicago, IL

MS SQL Server Developer/SSIS/SSRS Developer

Responsibilities:

• Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling teh packages.
• Created jobs on daily basis and schedule on every minute to update recent data by using SQL Server Agent jobs.
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column in SSIS.
• Developed and deployed data transfers packages using SSIS, also maintained teh jobs running on Servers.
• Involved in integration of teh front end wif teh SQL Server backend.
• Established Inner Join, Outer Join and created Indexes whenever necessary.
• Involved in unit testing of Store Procedure and UI as per requirement on different .Performed T-SQL tuning and optimization of queries for reports dat take longer execution time using MS SQL Profiler and Database Engine Tuning Advisor
• Designed and developed reports process to ensure timely delivery of accurate city of Chicago data to business needs.
• Used C# to send email in HTML Format using Script Task in SSIS.
• Coordinating change management and release management procedures in collaboration wif teh Business service manager.
• As teh Report developer of small team, I was responsible for design, development and delivery of ECM Solution and various web based reports application for City of Chicago.
• Developed complex Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports, Matrix reports and linked reports using SSRS.
• Responsible for Deployment of teh report using SSRS and used Report Subscription (Data Driven and Standard) to publish reports.
• Documented all work, so user can easily understand teh flow of process.

Confidential, Marshalltown, IA

MS SQL Server/SSRS/SSIS Developer/DBA

Responsibilities:

• Worked in teh Agile methodology using Scrum which TEMPhas its primary focus on teh management part of teh software development, dividing teh whole development period into small iterations (of thirty days) called "sprints."
• Installing and configuring, upgrading theSQLServer Databases, Monitoring and Performances.
• Develops automated procedures to produce client data files on schedule using Microsoft Integration Services (SSIS).
• Developed and deployed SSIS packages for ETL fromOLTP and various sources to staging and staging toData warehouseusingLookup, Fuzzy Lookup, Derived Columns, Condition Split, Term, Slowly Changing Dimensionand more. Performed ETL mappings using MS SQL Server IntegrationServices.
• Created VB.Net Script for Data Flow and Error Handling using Script component in SSIS.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from teh database.
• Developed and delivered dynamic reporting solutions using MS SQL Server 2008 Reporting Services (SSRS).
• Maintaining database environments, backup and recovery, database security, tuning, administration and also involvement in teh design and development of new databases.
• Installing and maintaining theSQLServer Databases, monitoringSQLagent jobs, assisting development teams wif data cleansing, migration wif reviewing, building, testing and maintaining database structures and SQLscripts.
• Created trace in SQL Profiler and used Data base engine tuning advisor for Performance tuning on stored procedures and Scripts.
• Documented all teh new procedures, troubleshooting issues and solutions, Enhancement and changes in Daily and monthly running processes, and maintain teh database for future reference.

Confidential, Charlotte, NC

MS SQL Server Developer/SSIS/SSRS/SSAS Developer

Responsibilities:

• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple homogeneous and heterogeneous information sources (CSV, Excel, Oracle db, and SQL 2008).
• Extract and Transform data into Staging Servers named as WHSStaging Server for historical data and TStaging Server for load increment.
• Performed Loading operation of historical data using full load and incremental load into Enterprise Data Warehouse.
• Created SSIS packages to Extract, Transform and load data using different transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension, Merge Join and Union all.
• Developed Custom Logging so user can no when a row is inserted in custom logging table by every SSIS package dat executes.
• Used For-Each Loop Container, Sequence Container, Script task, Expressions, Execute SQL task, Send Mail Task, Package Execution task to achieve business needs.
• Scheduled and maintain packages by daily, weekly and monthly using SQL Server Agent in SSMS.
• Developed complex Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports, Matrix reports and linked reports using SSRS.
• Generated SSRS report form SSAS OLAP Cube.
• Wrote complex Expressions and Calculations for SSRS reports wif Conditional Formatting.
• Created Project Expense Statements in all Data marts and other Financial Reports using SSRS. Developed yearly and quarterly company expense reports.
• Responsible for Deployment of teh report using SSRS and used Report Subscription (Data Driven and Standard) to publish reports.
• Used Visual Source Safe tool for Version Control.
• Tuned SQL query for better performance using SQL Profiler.
• Documented all work, so user can easily understand teh flow of process.

Confidential, Wilmington, DE

MS SQL Server/SSIS/SSRS Developer

Responsibilities:

• Performed System Study and Requirements Analysis, prepared Data Flow Diagrams, Entity Relationship Diagrams, Data Diagrams, Table Structures.
• Enhanced teh old logical and physical database design to fit new business requirement, and implemented new design into SQL Server 2008.
• Installed SQL Server 2008 and Management tools using SQL Server Setup Program.
• Wrote T-SQL queries, Store Procedures and used them to build packages.
• Involved designing and developing packages for a Data Warehousing and Data Migrations projects using Integration services (SSIS) on different Data Sources.
• Extracted teh data from Oracle, Flat Files, Transformed (Implemented required Business Logic) and Loaded into teh target DW using SSIS (SQL Server 2008).
• Designed SSIS Packages to transfer data from various sources like XML Files, SQL Server, Excel, and Access to SQL Server.
• Handled slowly changing dimensions to maintain teh history of teh data.
• Involved in Designing and deploying cubes inSSASenvironment using Snowflake Schema Designs for teh operational data
• Identified Key Performance Indicators (KPI) and Metrics for Business needs in SSAS
• Responsible for optimizing all indexes, SQL queries, stored procedures to improve teh quality of software.

Confidential, Columbus, OH

MS SQL Server/SSIS/SSRS Developer

Responsibilities:

• Conducted detailed analysis of each Legacy source system interface wif Data warehouse (DW) including all existing Mainframe Files and Data elements to be converted from Source system to Target Pre-staging.
• Wrote Technical Design Specifications, ETL workflows and Source to Target Mapping (STTM) spreadsheets for each legacy system interface wif DW.
• Designed, developed and deployed complex SSIS packages based on STTM conversion rules for teh transformation of Pre-staging data from AS400 systems to subsequent target layers in MS SQL Server 2008.
• Responsible for creating cubes and dimensions using MS SQL Server Analysis Services (SSAS).
• Created business critical KPIs using MS SQL Server Analysis Services (SSAS) representing aggregations in several different ways - hierarchically and using custom groupings dat teh company will use to analyze performance.
• Calculated measures and dimension members using MDX, mathematical formulas and user defined functions.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008.
• Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS.
• Created reports to retrieve data using Stored Procedures dat accept parameters.
• Used SQL Server profiler for auditing and analyzing teh events which occurred during a particular time horizon and stored in script.
• Validated reports to ensure quality of data and conducted Meetings wif business users to review reports and obtain continuous feedback.

Confidential, Cincinnati, OH

MS SQL Server/SSIS/SSRS Developer

Responsibilities:

• Generated test data and tested database to meet teh functionalities/deliverables in teh project documentation and specifications.
• Converted all DTS package into SSIS by recoding and implementing new functionality in it.
• Designed SSIS Packages to transfer data between servers, load data into database, archive data file from different database
• Scheduled teh jobs to perform tasks periodically.
• Successfully transferred old data from various sources like flat files, MS Access, and Excel into MS SQL Server 2005 using SSIS Packages.
• Created complex stored procedures and functions for integrity checks of transferred data.
• Helped design and implement processes for deploying, upgrading, managing, archiving and extracting data for reporting;
• Scheduled and monitored all maintenance activities of SQL Server 2000 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.
• Used Notification services to generate error messages and send them to teh user through e-mails, pager messages, PDAs and window messengers.

Confidential

MS SQL Server Developer

Responsibilities:

• Successfully installed and configured MS SQL Server 2000.
• Upgraded teh database from MS SQL Server 7.0 to MS SQL Server 2000.
• Transferred logins and users information using teh DTS object transfer task.
• Successfully Transferred logins and passwords information using teh DTS Package transfer logins task.
• Gatheird all teh data from legacy systems and loaded them into a flat file using ETL.
• Created various DTS packages to load data from teh flat file into MS SQL Server 2000.
• Involved in BCP commands to transfer data in text files from MS SQL Server 7.0 to MS SQL Server 2000.
• Developed complex SQL queries using various Joins and Sub-queries, Views, Functions and Triggers.
• Created customized stored procedures and triggers for automating tasks.
• Optimized various SQL Server statements wif teh help of MS SQL Server Profiler.