SUMMARY

• More than 6 years of experiencein Software Development Life Cycle Phases like Analysis, Design, Development, Documentation, Deployment and System Support.
• Involved in business to develop Entity Relationship/data models, requirements document, and ETL specifications.
• Excellent Experience in all aspects of Data Warehousing(usedKimball’s approach) including project planning,requirement gathering,data modeling,development,deployment,maintenance and enhancement.
• Experienced in migrating database system from SQL server 2005 to SQL server 2012.
• Experienced inETL design, developmentandimplementation.
• Hands - on working experience with analyzing query plans, using extended Stored Procedures
• Proficient in working with SQL statements to extract data from data tables and verify the output data of the reports. Good at Creating tables, Sub queries, Correlated Sub queries, Joins, Views, Indexes, SQL Functions, Set Operators and other Functionalities.
• Adept in RDBMS concepts and constructs along with Objects creation such as Database, Table, Normalization, UDF, User Defined Data Type, Indexes, SPROC, Views, Cursors and Triggers.
• Experienced in generating dashboard reports in integration with SharePoint 2010.
• Expert in T-SQL Programming, query optimization and performance tuning.
• Experienced in using ETL tools to design SQL Server Integration services (SSIS) packages for Data Management applications.
• Expert in using transformations like Aggregate, Multicast, Data conversion, Merge Join etc.
• Involved in Data Modeling using Erwin 7.0/6.5 and Unified Modeling Language (UML) 2.5/2.0 tools.
• Extensive experience and proficiency on the design, construction and implementation of Business Intelligence tools (Star Schema, Data-Warehouses, OLAP cubes, Partitioning and Aggregations), ETL Process (Data Extraction, Transformation layer) with DTS/SSIS, Data Cleansing, MSSQL Databases, Analysis Services (SSAS), Reporting Services (SSRS), and MDX ad-hoc Reporting.
• Experienced in SQL Server 2005 OLAP database development including KPIs, Data mining, working with slowly changing dimensions.
• Developed reports on SSAS & SSRS on SQL Server (2005/2008/2012 ). Sound Experience and understanding of SSAS, OLAP cube and Architecture.
• Developed Drill through and Drill down reports using SQL Server Reporting Services (SSRS).
• Expert inPerformance Tuning and Optimization ofSQL Server.
• Experienced in creating Jobs, Alerts, SQL Mail Agent, Scheduling DTS packages.
• Excellent analytical and communication skills to present points precisely and solve problems efficiently.
• Detail-oriented multi-tasking with strong technical concepts and organizational abilities.

TECHNICAL SKILLS

• MS DOS
• UNIX
• Windows XP/Vista/7
• MS SQL Server 2012/2008/2005
• SQL Profiler
• SQL Server Management Studio
• Microsoft Dynamics GP
• Microsoft Dynamics CRM 2011
• OLAP
• Data Transformation Services (DTS)
• SQL Server Integration Services (SSIS)
• SQL Server Analysis Services (SSAS)
• SQL Server Data Tools (SSDT)
• PowerPivot
• PerformancePoint Server
• Import/Export Data
• Bulk Insert
• BCP
• C
• C++
• Visual Basic 6.0
• PL/SQL
• T-SQL
• HTML
• XML
• VB.Net
• OLAP
• SQL Server Reporting Services (SSRS)
• MS-Excel (2007/2012)
• Adobe Photoshop.

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, Georgia

MS SQL SSIS/SSRS/SSAS Developer

Responsibilities:

• Designing the ETL architecture for incremental load to keep old and new applications in sync.
• Worked with Change Data Capture (CDC) tasks in SSIS packages to achieve incremental loads.
• Design and implement staging, landing and archive layers to bridge the gap between applications and improve performance for incremental load.
• SSIS packages design for data migration from scratch including package configurations and error handling.
• Complex SQL queries and store procedures to perform data transformations as per mapping documentation
• Infrastructural design to create a testing environment along with replication implementation to separate read and write operations
• Implemented SQL 2012 Always On availability cluster nodes for disaster recovery purposes.
• Performed regular backups and restores of databases to refresh seed data in other environments.
• Extensively worked on SQL queries performance tuning for existing store procedures in seed/full data loads.
• Involved in Technical Design Specification Documentations and Data Dictionaries.
• Designed dashboards, scorecards, API’s against OLAP cubes in PowerPivot and PowerView of SharePoint 2013.
• Worked on SSRS for various reports including, drilldown, drillthrough, graphical reports and metadata reports
• Designed SSAS cubes for dimensional models along with defining hierarchies when necessary.
• Written some C# coding for automatic loading of metadata to SQL tables and mapping documents.

Confidential, Atlanta, GA

Data Warehouse/ETL Developer

Responsibilities:

• Worked on dimensional modeling for the DataMart architectural design with Star schema and Snowflake schema.
• High level architectural design to create semantic layer to pull data from legacy source system to Staging and them to Data Warehouse
• Worked on ER\Studio to create logical and Dimensional Modeling.
• Created SSIS packages from scratch to transfer data from source to Data Warehouse with all required transformations applied.
• Worked on newly added SSIS 2012 configuration model and created Integration Services Catalogs with parameters from SSIS packages.
• Implemented auditing and error handling for all the developed SSIS packages.
• SSIS packages are designed to handle both manual and incremental loads with proper partitions and schema variations.
• Designed SSIS packages from scratch to transfer data from legacy source system to Data Marts.
• Designed SSAS cubes for all the developed DataMart models and identify measures with proper aggregate functions applied.
• Created SSRS reports on top of cubes with MDX queries.
• Created dashboards in PowerPivot integrating multiple sources like excel cubes and SQL tables.
• Worked on several PerformancePoint reports with multiple parameters as inputs.
• Created technical documentation for DataMart Design, ETL and cube processing.
• Maintained security roles and groups for staging and production to restrict access to the reports as per assigned group member.
• Extensively worked on performance tuning for report queries and ETL.
• Worked on C# code whenever customization needed for ETL and reports.

Confidential, Somerset, NJ

SQL Server/BI Developer

Responsibilities:

• Played key role in gathering requirements for better understanding of business rules to successfully implement the project design.
• Developed SSIS packages to transfer data from OLTP systems to DataMart on hourly basis.
• Worked on customizing default Microsoft Dynamics GP reports with SSRS.
• Worked on Erwin Tool to create logical and Dimensional Modeling.
• Perfectly introduced and implemented Always On Availability Groups for the replication nodes and was successful in keeping the transactional system up and running in case of failover.
• Actively participated in the knowledge transfer sessions with Dynamics CRM 2011 integration into the system.
• Worked on creating necessary workflows and run the background plug-ins within Dynamics CRM to obtain required views.
• Constructed and deployed OLAP cubes under Visual Studio Analysis Services project.
• Worked on designing reports against OLAP cubes in PerformancePoint Server and deployed them to the SharePoint Site.
• Also worked on SSRS design for various reports including, drilldown, drillthrough, dynamic cascade, graphical reports and dashboards.
• Written complex MDX queries and constructed named query dimensions with calculated members as per requirements for the reports.
• Responsible for complex store procedures, CTE’s, adhoc queries with dynamic SQL.
• Extensively worked on performance tuning to render faster results for the reports.
• Involved in disaster recovery plan design for the failover situations.
• Developed and executed several SQL server jobs as part of database maintenance using SQL Job Agent.
• Done lot of database documentation including ER diagrams for databases and also data dictionary with each column definition granularity.
• Worked on designing graphical reports with Performance Point Server.

Confidential - Nashville, TN

SQL Server BI Developer

Responsibilities:

• Designed the Data Warehouse architecture using Kimball approach for the purpose of data analysis and reporting.
• Designed and developed SSIS packages for day to day data transfer between transactional systems to Data Warehouse.
• Involved in Analyzing, designing, building &, testing of OLAP Cubes using SQL server Analysis services (SSAS) through MDX queries
• Identified and defined Fact and Dimension relationships for OLAP cubes in SSAS.
• Responsible for the designing the advance SQL queries, complex store procedures, nested cursors, triggers and views.
• Worked closely with Business Analysts and Test team to analyze the requirements and construct the regression test cases.
• Performed various error handling techniques and logging methodologies for existing SSIS packages.
• Developed SSRS reports like drill down, drill through, dynamic cascade reports using SSRS in Visual Studio 2010 with rdlc files being generated at the end.
• Worked on different issues that arises out of report rendering formats like ‘Excel’, ‘PDF’, ‘Microsoft Word’ and ‘HTML’.
• Performed few administrative tasks like database maintenance, backup and restore.
• Developed and executed several SQL server jobs as part of database maintenance using SQL Job Agent.
• Done lot of database documentation including ER diagrams for databases and also data dictionary with each column definition granularity.
• Also generated dashboard reports against OLAP cubes using Pyramid, Excel, Cognos..
• Developed SSRS report models and deployed them to the reporting Server for the user access reporting(ad-hoc reporting using Report builder 3.0)
• Worked on complex store procedures to get the underlying data of each report as per the filtering criteria of the users.
• Done lot of performance tuning for the tore procedures and SQL queries to improve the performance of report generation.
• Implemented high level security for each report access.

Confidential - Tacoma, WA

SQL Server Developer

Responsibilities:

• Install, load,monitor and troubleshootSQL Server 2008 databases.
• Developed logical database for staging area and converted into physical database using Erwin.
• Designed star schemas and snow flake schemas for the data warehouse with Enterprise Architect.
• Developed SSIS packages for data transfer between OLTP system to staging area and processed data to the data warehouse.
• Developed an installer and a user access administration tool for the eAudit Advanced Reporting System.
• Developed a scrubbing utility to protect sensitive information of client’s being displayed on reports.
• Worked on creating technical architecture documentation and green charts.
• Experienced in developing a dynamic SSIS packages as per the ad-hoc request.
• Implemented performance improvement techniques for the existing SSIS packages by introducing multi-core processing.
• Create, maintain, and update seed files and installation scripts for Linux installs.
• Worked on complex queries involving CTE’s and nested cursors.
• Implemented the conversion of few existing Crystal reports to SSRS reports.
• Developed a one click deployment service for uploading all RDL files to the report server at once.
• Generated reports which identify the performance efficiency of every report and also dashboard report showing usability metrics of all reports.
• Worked on Report Builder 3.0 which comes with SQL Server 2008 R2 for the ad-hoc reporting providing flexibility for the users to create their own reports.
• Created generic SSIS packages involving files with c# as scripting language.
• Designed extensive error handling and logging capabilities for the SSIS packages to ensure safety.
• Successfully deployed SSIS packages with defined security.
• Wrote complex T-SQL queries and Stored Procedures for generating reports.
• Scheduled reports with daily, weekly email subscriptions for reports on desired format.
• Designed and developed various parameterized reports, bar charts, pie charts, drill down to the bar charts and drill throw reports.
• Developed scheduled jobs to run the ETL on nightly basis for more than a Terabyte of Data
• Performance tuning of sql queries and store procedures using SQL profiler and index tuning wizard.