SUMMARY

• Six years plus of experience in IT as MS SQL Server Developer working in various domains such as Finance, Insurance and Healthcare.
• Extensive experience in T - SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SSAS, Informatica, Power BI & Tableau creating Design, Development, Testing, Implementation and Production/Support phases of SDLC for Data Warehouse, Client/Server, RDBMS and Web Based Application working in Agile, Waterfall, RUP environment
• Expertise in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), Data Transform Services (DTS).
• Strong experience in Data Warehousing and ETL using Informatica PowerCenter for Teradata, Oracle SQL Server Data mart, OLAP, OLTP.
• Extensively worked on Control Flow Tasks such as for each Loop Container, For Loop Container, Data Flow Task, File System Task, Script Task, Execute SQL Task, FTP Task, Execute Process Task, and Send Mail Task.
• Efficiently used Data Flow Tasks such as Data Conversion, Lookup, Aggregate, Audit, Multi Cast, OLE DB Command, Sort, Union All, and Copy Column, Derived Column, Row Count, Record Set Destination of teh integration services (SSIS).
• Experience in debugging teh SSIS packages using breakpoints and checkpoints.
• Hands-on star schemas, snowflake schemas, dimensional modeling and reporting tools, operations Data Store concepts, Data Marts and OLAP technologies.
• Highly proficient in creating data sources, data source views, dimensions, measures, measure groups, perspectives, partition aggregations. Analysis and Reporting Services, MDX queries, OLAP Cubes, and deployment and processing SSAS objects.
• Strong skills in writing MDX queries to access cubes in SSAS and creating feeds from OLTP systems.
• Designed and implemented user defined hierarchies in SSAS including parent-child hierarchy.
• Expertise wif SSRS, Power BI (tabular reports, parameterized reports, drilldown, drill through, sub reports, charts, dashboards etc.)
• Developed Custom reports and deployed in teh server using Power BI.
• Conversant wif all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Highly proficient in teh use of SQL for developing complex stored procedures, triggers, tables, user profiles, user functions, relational database models and data integrity, SQL joins and query writing.
• Widely worked on to improve SQL Query performance, SQL Query analytics and highly complex joins to populate teh desired result set.
• Good experience in development skills wifAzure Data Lake,Azure Data Factory, SQL Data Warehouse Azure Blob, Azure Storage Explorer.
• Good knowledge in OBIEE and implemented OBIEE usage tracking.
• Experience in Power BI to create Dash Board Reports using Source as Azure Database, Cubes.
• Comprehensively worked on SQL scripts using local and Global Temp Tables, Variables and Table Variables, Common Table Expressions (CTE) as per teh requirement and convenience.
• Worked on SQL scripts PLSQL, Creating Tables, Clustered/ Non-clustered Indexes Joins, to get teh desired result sets from teh Oracle Database as per teh requirement
• Hands-on Deploying reports, creating report schedules and subscriptions. Managing and securing reports and Proficient in MS Office includes MS Excel, creating spread sheets, graphs and dashboard reports.

TECHNICAL SKILLS

RDBMS: MS SQL Server, Oracle, MS access, DB2, Teradata, OBIEE, SAP

BI and SQL Tools: SSIS, SSAS, SSRS, Business Intelligence Development Studio (BIDS), SSMS, Visual Studio, Power BI, Tableau.

Scripting and Query Languages: T-SQL, HTML, VBScript, C, C#

Operating Systems: MS Windows 2010/07/03/P, Windows Server 2012/2008, MS-DOS, Unix-Ubuntu.

Tools: SQL Alerts, SQL jobs, Erwin, ER studio.

Others: MS office 2013/2010/2007 , Agile and waterfall methodology, Share point, Power Pivot.

PROFESSIONAL EXPERIENCE

Confidential, Alpharetta, GA

BI Developer

Responsibilities:

• Developed mappings dat perform Extraction, Transformation and load of source data into Derived Masters schema using various power center transformations like Source Qualifier, Aggregator, Filter, Router, Sequence Generator, look up, Rank, Joiner, Expression, Stored Procedure, SQL, Normalizer and update strategy to meet business logic in teh mappings.
• Implemented performance tuning on Targets, Sources, Mappings and Sessions to provide maximum efficiency and performance.
• Developed Dashboards in Tableau & Power BI reports and Migrated teh reports from Tableau to Power BI Premium.
• Utilized Power BI to create various analytics dashboards dat depicts critical KPIs such as legal case matter, billing hours and case proceedings along wif slicers and dicers enabling end-user to make filters.
• Implemented Copy activity, CustomAzure Data FactoryPipeline Activities for On-cloud ETL processing.
• Migrated SAP Hana data into Azure SQL Serve using Azure Data Factory.
• Utilized Power Query in Power BI to Pivot and Un-Pivot teh data mode for data cleansing and data massaging.
• Implemented Power BI gateway different source to matching analytics criteria and further modeling for Power Pivot and Power View.
• Implemented Copy activity, Custom Azure Data Factory Pipeline Activities
• Primarily involved in Data Migration using SQL, SQL Azure, Azure storage, and Azure Data Factory, SSIS.

Environment: Power BI, SSIS, ServiceNow, Azure Devops, Data analyzer, SQL,SAP Hana, Azure SQL Server, Azure Data Factory.

Confidential, Phoenix, AZ

Power BI /ETL Developer

Responsibilities:

• Create mapping and workflows using Informatica Power Center to extract, transform and load data into teh target environment.
• Experience in working wif data warehouses and data marts using Informatica Power center (Designer, Repository Manager, Workflow Manager, and Workflow Monitor).
• Developed mappings dat perform Extraction, Transformation and load of source data into Derived Masters schema using various power center transformations like Source Qualifier, Aggregator, Filter, Router, Sequence Generator, look up, Rank, Joiner, Expression, Stored Procedure, SQL, Normalizer and update strategy to meet business logic in teh mappings.
• Worked on different tasks in Workflow Manager like Sessions, Events raise, Event wait, Decision, E-mail, Command, Worklets, Assignment, Timer and Scheduling of teh workflow.
• Implemented performance tuning on Targets, Sources, Mappings and Sessions to provide maximum efficiency and performance.
• Developed Dashboards in Tableau & Power BI reports and Migrated teh reports from Tableau to Power BI Premium.
• Utilized Power BI to create various analytics dashboards dat depicts critical KPIs such as legal case matter, billing hours and case proceedings along wif slicers and dicers enabling end-user to make filters.
• Implemented Copy activity, CustomAzure Data FactoryPipeline Activities for On-cloud ETL processing.
• Migrated Tableau and SSRS to Power BI.
• Utilized Power Query in Power BI to Pivot and Un-Pivot teh data mode for data cleansing and data massaging.
• Implemented Power BI gateway different source to matching analytics criteria and further modeling for Power Pivot and Power View.
• Involved in building teh dimensions, cubes wif snow flake schema using Azure analysis Service.
• Extracted data from Oracle and SQL Server tan used Teradata for data warehousing.
• Implemented Copy activity, Custom Azure Data Factory Pipeline Activities
• Primarily involved in Data Migration using SQL, SQL Azure, Azure storage, and Azure Data Factory, SSIS.
• Made use of Post-Session success and Post-Session failure commands in teh Session task to execute scripts needed for cleanup and update purposes.
• Performed tuning of SQL queries and Stored Procedure for speedy extraction of data to resolve and troubleshoot issues in OLTP environment.
• Designated owner and accountable for major tasks and took responsibility for actions and outcomes to ensure timely and cost-TEMPeffective results for our team.
• Worked wif SQL queries, created Stored Procedures, packages, Triggers, Views using PL/SQL Programming.
• Developed reports Power BI reports from using multiple data sources such as Azure SQL Datawarehouse, Cubes.
• Participated in weekly status meetings and conducting internal and external reviews as well as formal walk through among various teams and documenting teh proceedings.

Environment: Power BI, Tableau, Informatica Power Center 9.1.0, Workflow Manager, TFS, Workflow Monitor, Informatica Power Connect / Power Exchange, Data analyzer, PL/SQL, Oracle 10g/9i, SQL Server 2009.

Confidential, Lexington, KY

SQL /SSIS/SSRS/SSAS Developer

Responsibilities:

• Created SSIS Packages using Execute SQL Task, File System Task, Send Mail Task, for each Loop container and Sequence container.
• Created SSIS Package wif various Variables, Expressions and Transformations like Conditional Split, Derived Column, Data Conversion, Lookup, Merge Join, Sort and Aggregate.
• Debugged SSIS Packages using Breakpoints, Data Viewers & watch windows.
• Involved in data migration from Excel, CSV files into SQL Server using SSIS Packages.
• Wif Analysis Services created various Cubes, Dimensions, Measures and Aggregates based on teh business requirement.
• Involved in creation, build, deployment and processing of SSAS Cubes.
• Created/ Modified SSRS based reports based on T-SQL and Stored Procedure wif Input parameters.
• Developed Tabular Reports, Sub Reports, Matrix Reports, Drill down Reports and Charts using SQL Server Reporting Services (SSRS).
• Identified and modified teh Key Performance Indicators (KPIs), measures in co-ordinance wif teh requirement and created calculate member in MOLAP cube using MDX in Business Intelligence Studio using SSAS
• Designed cubes and built Scorecards and dashboards for different levels of management.
• Included Report Design and Coding for Standard Tabular type reports, including Drill Down and Drill through Functionality and Graphical presentations such as Charts and Dashboard type metrics for TEMPeffective analysis.
• Built advanced reports using query parameters, report parameters, user access restrictions, filters and interactive sorts
• Involved in writing MDX queries and performance optimization of teh SSAS cubes. Build teh dimensions, cubes wif star schema and snow flake schema using SQL Server Analysis Services
• Worked on Team Foundation Server(TFS) to push teh code into repository and updating teh stories.

Environment: MS SQL SERVER 2005/2008/2012/2014 , SQL Server Reporting Service (SSRS), SQL Server Integration Service (SSIS), SQL Server Analysis Service (SSAS), Business Intelligence Studio, T-SQL, SQL Profiler, Team Foundation Server (TFS), Microsoft Visio, MS Office 2003.

Confidential, Harrisburg, PA

SQL /SSIS/SSRS/SSAS Developer

Responsibilities:

• Actively involved in teh gathering requirements and analysis of teh requirements related to teh project and responsible for writing Business Approach Documents (B.A.D) and Technical Documents for new projects
• Created SSIS packages to validate, extract, transform and load data to a centralized SQL server from teh existing diversified data sources.
• Involved in performing incremental loads while transferring data from OLTP to data warehouse using different data flow and control flow tasks in Business intelligence studios using SSIS.
• Involved in Debugging teh SSIS Packages using Data Viewers, Breakpoints.
• Used various transformations like Derived column, Pivot, Un-pivot, copy column, merge join, union all, Lookup, audit, aggregate etc.
• Created teh reports based on teh requirements and Deployed teh Reports in Report Server.
• Wif Analysis Services created Cubes, Dimensions, facts, Measures and Aggregates based on teh business requirement.
• Involved in defining d Relationships and in Identifying KPIs in SSAS.
• Involved in teh performance and database optimization of T-SQL queries.
• Developed User Defined Functions, Stored Procedures, SQL Queries based for Ad hoc processes.
• Created OLAP cubes, facts and dimensions for teh analysis of sales in various locations and process data from data mart using SSAS.
• Involved in building teh dimensions, cubes wif star schema and snow flake schema using SSAS.
• Worked wif RDBMS concepts for creating database objects such as tables, functions, stored procedures, indexes, views.
• I was involved in performance tuning of teh SQL queries. Experienced wif Power Pivot. Used SQL server agent and Autosys to schedule teh packages.
• Created sub-reports, drill down reports, summary reports, parameterized reports, and ad-hoc reports using SSRS.
• Created a sustainable reporting practice and means of storing, sharing/ publishing teh information and reports using subscriptions.

Environment: MS SQL Server 2014/2012, MS SQL Server Management Studio (SSMS), MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), SSAS Tabular,TFS, Cubes, MS SQL Server Analysis Services (SSAS), MS Visual Studio 2010, MS Excel, T-SQL, Autosys.

Confidential

SQL Developer

Responsibilities:

• Developed, maintained and executed SQL scripts/queries and validated completeness, integrity and accuracy of data.
• Designed, developed, and tested stored procedures, views and complex queries for creation of Reports.
• Designed and developed Data Transformation Process (Extraction, Transformation & Loading) using Heterogonous Sources to Destination (SQL Server).
• Successfully created SSIS packages using Sequence Container, Data Flow, Execute SQL, Bulk Insert, Send Mail Task Etc.
• Used SQL Agent for job scheduling.
• Used advanced features of T-SQL in order to design and tune T-SQL to interface wif teh database and other applications in teh most efficient management.
• Built and performed user acceptance testing on new and modified reports. Generated several types of reports like tabular, matrix, list and more.

Environment: MS SQL Server 2008/2005, SQL Server Reporting services (SSRS), SQL Server Integration Services (SSIS), MS Excel, Microsoft office Suite (Word, Excel, PowerPoint)