SUMMARY

• An accomplished SQL Server and MSBI developer, having 7 years of industrial experience in designing, developing and implementing database solutions of SQL Server in Financial, Retail Domains.
• Extensive experience in Database Design, Data Modeling, T - SQL Development, Developing and Implementing ETL Packages using SSIS and Complex Reports using SSRS.
• Expertise in firing T-SQL queries, dynamic-queries, sub-queries and complex joins for generating complex stored procedures and cursors.
• Knowledge of DB high availability concepts like MS SQL Clustering, replication and log shipping, DB Mirroring.
• Experience in query optimization, running DB Consistency Checks using DBCC commands.
• Expertise in troubleshooting SQL issues by using SQL Profiler.
• Expertise in creating SSIS packages to Extract, Transform and load ( ETL ) data from Excel, Database, XML File and Flat file source by using different SSIS transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension, Merge Join and Union all.
• Experience in integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data)
• Organized the task flow using For-Each Loop Container, Sequence Container, Script task, Expressions, Execute SQL task, Variables, Send Mail Task, Package Execution task to achieve business needs.
• Experience in creating package configurations like XML, SQL Server Configurations and Logging using text, XML and Windows event log.
• Expertise in Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Thorough understanding of Kimball's' theory, KPIs and Perspectives, SQL Server 2008 Architecture.
• Experience in developing Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Created Ad-Hoc Reports, Summary Reports, Sub Reports, and Drill-down Reports using SSRS.
• Expertise in creating various types of reports using Cascading parameters, Complex drill down and drill through reports and charts in SQL Server Reporting Services (SSRS) based on relational and OLTP databases.
• Experienced in maintaining and supporting operational reports, dashboards, and scorecards using Microsoft Power BI (Power Pivot, T-SQL, Excel pivot tables).
• Created presentations in concise & well-researched manner on development and implementation of new Dashboards.
• Worked on functional requirements sessions with diverse business and technology stakeholders on data modeling, integration, and configuration for data warehouse with automated and manual field data collection systems.
• Experience in importing and exporting data using Sqoop from HDFS to Relational Database Systems and vice-versa.
• Exceptional written and verbal communication skills.
• Involved in Review of the current and planned master data management initiatives and setup. Tested, Cleaned, and Standardized Metadata to meet the business standards.
• Defined best practices for Tableau report development and effectively used data blending feature in tableau.
• Generated the test plan specifying an overview of testing approach, testing strategy, roles, responsibilities and its scope.
• Results oriented, self-starter looking for challenges, ability to rapidly learn and apply new technologies and good interpersonal skills.

TECHNICAL SKILLS

Databases: Oracle 9i, 10g, SQL Server 2008, MySQL, Teradata V12, 13, 15

SQL Server Tools: SSMS, Configuration Manager, Enterprise Manager, Query Analyzer Profiler, DTS, SISS, SSAS, SSRS, Database Tuning Advisor, BI tools (Report Studio, Analysis Studio, Query Studio).

ETL Tools: SSIS, Informatica, SSRS, Database Tuning Advisor, BI tools (Report, Analysis, Query), Programming T-SQL, PL/SQL, Dynamic SQL, MDX

Tools: MS Visio, MS Project, MS Office, TOAD, JIRA and SQL Navigator

Operating Systems: Unix, Solaris 8/9

PROFESSIONAL EXPERIENCE

Confidential, Reston VA

Sr ETL SSIS Developer

Responsibilities:

• Involved in a team of developers that successfully completed a complex data conversion project that was designed to migrate millions of records to a new system (QNXT).
• Responsible for fixing hundreds of critical defects addressed during data conversion.
• Updated mapping tables related to assigned functional areas as directed by the Business Analysts.
• Created and modified tables, views and indexes; PL/SQL stored procedures, functions and triggers per business requirement.
• Executed SQL conversion pre-validation and post-validation scripts to avoid data loss.
• Created business reports by joining multiple tables from multiples database using complex SQL queries.
• Responsible for debugging, troubleshooting, and tuning PL/SQL stored procedures, functions, and Complex SQL.
• Actively involved in creating SSIS packages to transform data from OLTP database to a data warehouse.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Created checkpoints, configuration files in SSIS packages and Deployed SSIS packages with minimal changes using XML configuration file.
• Involved in SSAS Cubes design by creating KPI, Actions and Perspective from huge dataset using SQL Server Analysis Services (SSAS).

Environment: MS SQL Server 2014/2012, SSIS /SSRS/SSAS, Query Analyzer, T-SQL, Windows Server 2008R2, SharePoint server, Erwin, DTS Designer, Visual Source Safe, Microsoft Visio 2007, SQL Profiler, MDX, Teradata, Microsoft Azure, SQL Profiler, MS Excel 2010, MS Word 2010, Power point 2010.

Confidential, TX

Sr SSIS Developer

Responsibilities:

• Created complex Stored Procedures and Functions to support the front-end application.
• Created database triggers to implement business requirements.
• Monitored growth of database objects for capacity planning and involved in tuning the database and T-SQL queries using Explain Plan.
• Created and managed schema objects such as tables, views, indexes, procedures, triggers and maintaining Referential Integrity.
• Created several SSIS Packages to load data from various data sources including Flat files, MS Excel, MS Access, DB2 etc. to SQL Server
• Created SSIS package to load multilevel XML data into SQL SERVER database.
• Managed indexes, statistics and tuned queries by using execution plan for optimizing the performance of the databases.
• Designed SSIS packages to export and import data from SQL Server to MS Access, text files and Excel files. Used SSIS transformation for Data Cleansing to remove unnecessary data.
• Created Complex Reports like Cascaded Reports, Drill Through, Tabular Reports, Matrix Reports, Drill-down, and Cross Tab Reports in SSRS.
• Created report models for ad-hoc reports using SSRS 2012.

Environment: SQL Server, SSIS, SSAS, SSRS Packages, DB2, SQL, Sqoop

Confidential, Detroit

Informatica Developer

Responsibilities:

• Designed and Developed Oracle PL/SQL Procedures and UNIX Shell Scripts for Data Import/Export and Data Conversions.
• Interacted with both Technical, functional and business audiences across different phases of the project life cycle.
• Used Change Data Capture to capture changes in database, used these variables in Informatica Mappings.
• Developed Informatica mappings, sessions and workflows as per the business rules and loading requirements using mapping parameters and variables.
• Used HP Quality Centre and Rational clear quest as test management tools in defining releases, documenting requirements and test cases and mapping requirements with test cases, defect reporting and analysing test results.
• Used debugger to analyse the data flow between source and target to fix the data issues.
• Developed PL/SQL procedures, functions to facilitate specific requirement.
• Implemented audit and reconcile process to ensure Data warehouse is matching with the source systems in all reporting perspectives. Worked on generating the Interface files based on the business requirements.
• Teradata utilities such as multi load, fast load, fast export and TPump to insert, update and upsert Data, extract and load Data.
• Extensively used ETL processes to load data from various source systems such as DB2, SQL Server and Flat Files, XML files into target system Teradata by applying business logic on transformation mapping for inserting and updating records when loaded.

Environment: Teradata 13, Informatica Powercenter, SQL Server2008, Oracle 9i/ 11g, DB2

Confidential

ETL Developer

Responsibilities:

• Responsible in gathering requirements and reviewing data sources form SQL server, MS Excel, for design, development, testing, and production rollover of reporting and analysis projects within Tableau server and Tableau Desktop.
• Worked as a developer in creating complex stored procedures, triggers, functions, indexes, tables, views and other T-SQL code and SQL joins for applications.
• Involved in gathering business requirement from business users and prepared BI technical specifications.
• Created various data models like Flattened, Star schema in SSAS - Tabular model / Power Pivot
• Delivered final Power BI report as internet link, embedding in Share point/Custom Application/Office Tools.
• Extensively worked on views, cursors, CTE's, schemas, permissions and performance issues with client/server database design.
• Developed, monitored and deployed SSIS packages.
• Developed SSIS packages using various transformations such as conditional splits, fuzzy look ups, aggregations and multicasting.
• Used SSIS to create ETL packages to validate, extract, transform and load data to Data Warehouse databases.
• Created a custom Content Pack in Power BI and published it across to specific use groups / entire organization.
• Implemented SQL server 2014 latest features like Project level Deployment, Project Parameterization, GUID etc.
• Worked on Data Analysis Expressions (DAX) for accessing data directly from tabular SSAS database.

Environment: MS SQL Server 2005/2008/2012 , T-SQL, SSIS 2008/2012, SSRS 2005/2008 R2/2012, visual studio., MS Excel, MS Access, Windows 7