PROFESSIONAL SUMMARY:

• Over 8 years of IT experience in database design and development in Microsoft SQL Server Suite of Products with expert Knowledge of Integration Services (SSIS), Analysis Services (SSAS) and Reporting Services (SSRS).
• Hands on experience in all phases of SDLC (software development life cycle) involving Requirement analysis, Software design, development, implementation, testing and maintenance.
• Experience in developing ETL architecture for building a DataWarehouse and Data Migration.
• Hands on experience with Team foundation server (TFS) as a source control tool.
• Expert in working with SSIS for creating packages to transform data from different OLEDB providers like MS Access, Flat File, Excel, Oracle, MS SQL server and Automate the ETL.
• Experience in creating and managing Error logging, Event Handlers, Package Configurations, creating Jobs using SQL Agent, setting Alerts and Scheduling SSIS Packages.
• Extensive knowledge of using System Variables and creating User - Defined Variables for SSIS Packages.
• Well versed in normalization/de-normalization techniques for optimum performance in relational database environments and building Referential Integrity Constraints.
• Good experience in building Star schema and Snowflake schema depending on the business data requirements and performing Data loads into Data warehouse and Data marts.
• Experience in SQL Server Analysis Services (SSAS) Tabular model design and development.
• Experience in creating partitions in SSAS Tabular Model using SSDT and SSMS.
• Expert in generating various types of reports like Drill down, Drill through, Parameterized, Cascading, Matrix, Ad-hoc and Sub Reports in SSRS.
• Developed reports involving sorts, filters, expressions, breaks and calculations using SSRS.
• Experience accessing web services from SSRS reports.
• Experience in building data models in Power Pivot and build pivot tables using DAX calculations.
• Exposure to Microsoft Power View and Power BI reporting tools.
• Adept in writing, testing and implementation of T-SQL (DDL, DML) queries, triggers, stored procedures, User-Defined functions, views, and Indexes.
• Efficient, in creating Sub-Queries, Joins, CTEs, Temp Tables for complex queries involving multiple tables.
• Good knowledge of Tuning SQL queries, maintaining data integrity and data consistency, Debugging and Query Optimization.
• Excellent communication, time management, interpersonal and analytical skills.

TECHNICAL SKILLS:

Database Tools: SQL Server Business Intelligence Data Tool - SSIS, SSAS, SSRS, Report Builder, Team Foundation Server(TFS), SQL Server Management Studio, SQL Developer,Rapid SQL,Toad, SQL Nexus, Sql Server Agent.

RDBMS/DBMS: MS SQL Server 2014/2012/2008/2005/2000, Oracle 10g/9i/8i, MYSQL, MS-ACCESS, Netezza, IBM DB2 v9.7, Sybase

Programming Languages: T-SQL, PL/SQL, and J2EE

Reporting Tools: SQL Server Reporting Services SSRS,, Microsoft Power Pivot, Microsoft Power View, Microsoft Power BI, MS Excel, Crystal Reports

Application Servers: Apache TomCat 8.x/7.x/6.x, WebLogic 8.1/7.1

Operating System: Windows 2014/2012/2005/2003/2000/ NT/XP

PROFESSIONAL EXPERIENCE:

Confidential, Mclean, VA

SSIS/ SSRS Developer

Responsibilities:

• Worked with business team to gather business requirements. Worked with technical team for performing data mapping of report fields.
• Responsible for creating various SSRS reports with a capability of sorting report using any of report field.
• Wrote complex T-Sql queries involving temp tables and CTE’s for implementing business rules.
• Used expressions in reports to achieve some of the business requirements such as displaying deployment environment.
• Involved in performance tuning of SQL queries.
• Performed unit testing and assisted testing team in SIT and UAT.
• Presented the reports to business users to help them understand the reports and usage of tool.
• Assisted integration team with deployment of the reports.
• Provided document for setting subscriptions for each of the reports.
• Built data model involving one to many and many to many data models using Data source (IBM DB2) and created Power Pivot tables using DAX expressions and calculations.
• Conducted workshop to business users to help them install, setup and understand the Power Pivot tool
• Built tabular model on Analysis Server using SQl server Analysis Services and created partitions using SQL Server Data Tools (SSDT) and SQL Server Management Studio (SSMS).
• Processed the tabular model and partitions from SSDT and SSMS.
• Invoked Tabular Model and processed each partition from SQL Server Integration Services SSIS.
• Created SSRS reports using Tabular Model as data source.
• Created SSIS package to test the ability of dynamic connections using .net assemblies.
• Implemented SSIS package to show the Data Movement Control concept for Confidential .
• Created SSIS package to invoke and perform dynamic processing of partitions for SSAS Tabular Model.
• Deployed the SSIS package to IS server catalog SSDB.
• Executed the package using SQL Agent and DTEXEC command.
• Created a JIL file to process the deployed SSIS package and assisted integration team in scheduling the package using Autosys scheduler.

Environment: SQL Server 2014, Windows 2014 Server, Microsoft Business Intelligence Tool SSDT, SQL server Analysis Server 2014, SQL Server Integration Services 2014, CollabNet GIT Eye, TeamForge, IBM DB2.

Confidential, Dayton, OH

SQL Server SSIS/SSRS Developer

Responsibilities:

• Gather Data Migration requirements by working side-by-side with Berry business and IT team members, including Source (“Core” and a few other Berry Legacy Systems to Target (SalesForce.com, hosted in the Cloud) mapping.
• Design and Implement Business Rules in the SSIS packages for Data Migration.
• Helped the client technical team to validate the Source extract files that were extracted from CORE oracle system for data integrity.
• Created functional specification document and technical specification document.
• Load data into SQL Server tables which are designed to mirror SFDC Objects such as Account, Contact, Lead, Opportunity, Opportunity Product, Order Line Items, Listings and Data Fulfillment Profile and also several History Objects.
• Migrated YPC (yellowpages.com) and Non-YPC data into the target system.
• Wrote SSIS packages to translate products and Canvasses from legacy system into new systems using crosswalks for both Print and Digital exposures.
• Wrote SSIS packages to load all the reference data objects such as Product, Product Pricebook Entry, Canvas, Directory, Directory Heading and Directory Section.
• Developed scripts using regular expressions to cleanse the Customer data, Contact data and Lead data and feed into a Melissa Data address standardization software Contact Zone (on Pentaho ETL platform) to standardize the address information for Data Migration into SFDC system.
• Created logging for ETL loads at package level in packages using SSIS.
• Worked on several Data Migration validation reports using SSRS and 3 main type of reports are 1.Data Migration Validation Error Report, 2.Data Migration Errors by Value Report and 3.Detailed Error Report by Column with External ID Report.

Environment: SQL Server 2012, Windows 2012 Server, Windows 2014 Server, Oracle 10g, MelissaData's Contact Zone, SQL Server Business Intelligence Development - SSIS & SSRS, SFDC.COM CRM

Confidential, Costa Mesa, CA

SQL Developer SSIS/SSRS

Responsibilities:

• Involved in enhancing System Requirement Document and also involved in development of Detail Design Document. Closely worked with Architect and Technical Manager in understanding the System Process Flow.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database
• Developed several SSIS Packages to extract, cleanse, transform, integrate and load data into SQL Server Database.
• Developed, modified, and optimized complex stored procedures to handle business rules, history data and audit analysis and also involved in performance tuning of T-SQL.
• Performed data loads from Flat files into a denormalized database structure.
• Used various SSIS tasks such as Conditional Split, Derived Column etc., which did data scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse
• Developed master SSIS packages to automate the dimension and fact loads using ExecutePackage task and packages with containers.
• Performed error logging in SSIS packages.
• Involved in Job scheduling and alerts.
• Created Parameterized reports and Linked reports using SSRS.
• Involved in Unit testing, Interacted with QA team for system/integration testing.

Environment: SQL Server 2008, Windows 2008 Server, SQL Server Business Intelligence Development - SSIS & SSRS,UNICA, MS Access 97/2000, Win 2008 and Visio 2010.

Confidential, Richmond, VA

ETL/ SQL Developer

Responsibilities:

• Involved in devolving documentation to reflect current design of SSIS ETL processes. Worked closely with Business Users in identifying the gaps between existing code and the business requirements in the ETL projects.
• Involved in Gap Analysis and requirements gathering sessions of the project with Business team, Architect, ETL team, Siebel ICM team and Reporting team.
• Worked on the existing SSIS packages for handling the changes to the source system in MMS project which extract SQL Server source data to landing, and worked on existing SSIS packages to process several types of transaction data and create XML files and also direct adds of Sales transactions in ICM project.
• Developed various T-SQL scripts for transaction processing of Sales, Credits and rebates
• Worked on Master packages to automate the process flow and performed unit testing on SSIS packages.
• Involved in developing RunBook for ETL project.
• Involved in System Testing of the project with all the teams.

Environment: SQL Server 2008, Windows 2008 Server, SQL Server Integration Services SSIS, Oracle10g, UNIX AIX 4.3, TOAD, ERWIN 4.2, Business Objects, Siebel ICM, Putty, PSFTP, Win 2008 and Visio 2010.

Confidential, Newark, DE

BI/ SQL Developer

Responsibilities:

• Processed and stored the CMS health claim data of claim types DME, Carrier, Inpatient, Outpatient and SNF in flat files.
• Worked on staging area model and implementation to store CMS claim data in relational model, worked on datawarehouse design and implementation.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Created ETL packages to populate data from the various source systems like Excel, Flat file, and Oracle data bases using SQL Server Integration Services (SSIS).
• Involved in Creating Database Objects like Tables, Stored Procedures and Views.
• Developed packages using SSIS and controlled its execution, by implementing the infrastructure that enables execution order, logging, variables, and event handling.
• Created Crystal Reports on daily, weekly and monthly basis for manger’s review.
• Involved in System Integration Testing and User Acceptance Testing.

Environment: MS SQL Server 2005, Oracle 9i/8i, Windows 95/NT/2000/2003, SQL Server Integration Services (SSIS), Crystal Reports, MS Excel and MS Access.

Confidential

Java Developer

Responsibilities:

• Worked with business experts and application development teams to understand output requirements and ensure application data and master data support those requirements
• Writing client side programming using HTML, JavaScript.
• Writing server side programming using JSP.
• Writing SQL queries to create database tables as per the requirement.
• Developed SQL queries to check the data quality.
• Reviewing the code and performing quality check.
• Involved in the testing of the system.
• Documented all work, so user can easily understand the flow of process.

Environment: HTML 5, JSP 2.0, Servlets 2.3, Struts 2.2, MySQL 5.1, JavaScipt, WebLogic Server 8.1 and Hibernate 4.0