PROFESSIONAL SUMMARY:

• Extensive 8 years of experience in Database development for both OLTP (Batch Processing, Online Processing) & OLAP Systems (SSRS, SSIS, SSAS) using MSSQL Server 2005/2008R 2/2012/2014.
• Experience 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, Ad hoc queries, heavy stored procedures, Batch Scripts, Triggers, and Functions using T - SQL.
• Thorough knowledge of addressing Performance Issues and Involved in query tuning, Index tuning, Data Profiling and other database related activities.
• 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 and SSIS.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Experience in Designing Data mart and Data Warehouse using Star Schema and Snowflake Schema for implementing Decision Support Systems.
• Experience in creating datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
• Provided Ad-hoc queries and Reports for Companywide users pulling data from Multi-terabyte data warehousing systems.
• Extensive experience in Enterprise Data Management (MDM, BI/ETL) as a developer, business Intelligence.
• Design and develop ETL solutions for Data Warehouse. Implement Master Data Services (MDS) on SQL Server 2012.
• Developed reports & Dash board by using excel services and business Intelligence.
• Design and create dash board reports which illustrate the data in tabular(power BI) format and well formatted charts.
• Excellent communication and interpersonal skills and has ability to handle multiple tasks; can take initiative to handle responsibilities independently as well as a proactive member of a team.

TECHNICAL SKILLS:

MS SQL Server Integration Services 2012/R2/2008/2005, SQL, SSIS, C#, VB.net, ADO.NET, T-SQL, Crystal Reports9.0, Data Modeling, Visual Basic, ASP.Net, Microsoft Visio, Scripting tuning HTML, XHTML, XML, CSS, JavaScript, AJAX, OLAP, OLTP, IBM, UNIX scripts, Dash-board using Crystal Reports, MDX, DAX and SQL, MDM, MDS, MS SQL Server 2005/2008/2008 R2/2012, Oracle 10g, MS Access, MS DOS, SQL, complex database structures and maps,WinNT/2000/2003/XP, PowerShell, Arc-GIS, MapPoint 2010, Erwin.

PROFESSIONAL EXPERIENCE:

Confidential, Arlington, VA

SQL/SSIS Developer

Responsibilities:

• Involved in designing, developing, debugging and testing of reports in SQL Server Reporting Services (SSRS).
• Write Complex Queries, stored procedures, Batch Scripts, Triggers, indexes and Functions using T-SQL for SQL Server 2012/2014.
• Wrote stored procedures and User Define scalar Functions (UDFs) to be used in the SSIS packages and SQL scripts.
• Created packages with different control flow options and data flow transformations such as Conditional Split, Multicast, Union all and Derived Column etc.
• 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 different kinds of transformations using SSIS/DTS packages
• Developed SSIS packages to Extract, Transform and Load (ETL) data into the data warehouse database from SQL Server 2012/2014 MS Excel and Flat files.
• Used various transforms in SSIS to load data from flat files to the SQL databases.
• Created ETL packages using SSIS to extract data from relational database and then transform and load into the data mart.
• Developed SSIS packages to Extract, Transform and Load (ETL) data into the data warehouse database from heterogeneous databases/data sources.
• Prepared Visio diagrams/documents to track and implement the blueprint of the ETL dataflow/process implementation from Initial phase, Ongoing, Deployment to Production Environment.
• Created SSIS packages to mitigate into the data warehouse database from heterogeneous databases/data sources.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Created SSIS packages for Data Conversion using data conversion transformation.
• Used Visual Team Foundation server for version control, source control and reporting.
• Designed and created Report templates, bar graphs and pie charts based on the financial data using SSRS 2012
• Created reports in SSRS with different type of properties like chart controls, filters, Interactive Sorting, SQL parameters etc.
• Developed various types of reports like Drill down, Drill through and parameterized reports using SQL Server Reporting Services.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Developed mapping spreadsheets for (ETL) team with source to target data mapping with physical naming standards, data types, volumetric, domain definitions, and corporate meta-data definitions.
• Created SSIS packages for File Transfer from one location to the other using FTP task with Master SSIS Package to run all other packages.
• Participated in Databases Architecture and data modeling design.
• Inspected the reports and fixed bugs in stored procedures and also tuned Reporting Services to the T-SQL.

Environment: MS SQL Server 2008R2, 2012 & 2014 Enterprise Edition, Microsoft Visual Studio 2012 MDX, T-SQL, Oracle PL/SQL, MS Access, MS Excel, Windows 2008 Server, Tableau, OLAP, Visual basic .NET, UNIX.

Confidential, Pittsburgh, PA

SQL/SSIS/SSRS Developer

Responsibilities:

• Involved in Planning, Defining and Designing data base using Erwin on business requirement and provided documentation.
• Designed, reviewed, and created primary objects (views, indexes, etc.) based on logical design models, user requirements and physical constraints.
• Created Stored Procedures, Triggers, Functions, Indexes, Tables, Views using T-SQL code and SQL joins for applications.
• Wrote stored procedures and User Define scalar Functions (UDFs) to be used in the SSIS packages and SQL scripts.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Used DDL and DML for writing triggers, stored procedures to check the data entry and payment verification.
• Responsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of software.
• Created SSIS Packages to transfer data from various sources like Text Files, SQL Server, Excel and Access to SQL Server.
• Developed C# scripting for packages using Scrip task
• Configured Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging in SSIS and TRY and CATCH Blocks in TSQL.
• Creating Star and Snow Flake Schema design using Visio, defining relations between tables
• Designed, modified and troubleshoot SSIS packages.
• Utilized SSIS Checkpoint, Loading Dimension with the SSIS slowly changing Dimension Wizard and used different SSIS Control Flows.
• Created ETL in DTS packages by using Data Transform Task, VBScript task, SQL task and send Email task to migrate data from different functional databases into SQL Server 2008R2/2012.
• Created notifications, alerts to let support team know in case there are any failures.
• Designed and created Report templates, bar graphs and pie charts based on the financial data using SSRS 2012
• Developed various types of reports like Drill down, Drill through and parameterized reports using SQL Server Reporting Services.
• Defined Key Performance Indicator metrics to create scorecards.
• Generated Sub-Reports, Drill down reports, Drill through reports and parameterized reports using SSRS.
• Created reports to retrieve data using Stored Procedures that accepts parameters.
• Developed complex reports using multiple data providers, user defined objects, aggregate aware objects, charts, and synchronized queries.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2012/2008.
• Scheduled Cube Processing from Staging Database Tables using SQL Server Agent.
• Used SQL Server profiler for auditing and analyzing the events, which occurred during a particular time horizon and stored in script.
• Used "SQL Profiler TSQL Duration" template for tracking execution time of TSQL Statements.

Environment: MS SQL Server 2008R2/2012, Management Studio(SSMS), ETL, ASP.NET, Crystal Reports9.0, Data Modeling, OLAP, Data warehousing SSIS, C#, VB.net T-SQL, DB2, SSAS, SSIS, SSRS 2008 R2/2012, IBM, UNIX scripts

Confidential

BI/SQL Developer

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.
• Migrated DTS objects to SQL Server Integrated Services (SSIS) environment.
• Done migration from SSIS 2008R2 to SSIS 2012.
• Worked on different sources in SSIS (XML, Flat file, Excel, OLEDB Source).
• Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.Enhanced the functionality in database and data warehousing concepts (OLAP, OLTP) Cube by creating KPI, Actions and Perspective using SQL Server Analysis Services 2008(SSAS).

Environment: MS SQL Server 2008, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS),, C#, VB.net, ADO.NET, SQL Profiler/Analyzer, Management Studio, OLAP, OLTP, Import/Export Wizard, Excel,Arc-GIS 10.0, Map Point 2010 .