SUMMARY:

• Over 11 years of industry specializing in SQL Server, SSAS, SSRS, SSIS and Power BI visualization tool
• Experience in supporting Microsoft Azure systems including SQL Server hosted on Azure Virtual Machine (IaaS),Azure SQL Databases (DBaaS) and Azure DataLake.
• Implementing High Availability (HA) technologies which include Log shipping, Database Mirroring and replication.
• Experience across entire Microsoft BI suite of products including SQL Server, SSIS, SSAS, SSRS and Power BI SDLC from prototyping to deployment.
• Excellent experience in writing T SQL Queries using various objects like views, tables, Joins, Sub Queries, triggers, stored procedures, and other advanced SQL concepts.
• Worked experience on develops and maintains JAVA, TIBCO and SQL applications.
• Ability to create SSIS Packages using various Transformation like Lookup, Derived Columns, Conditional Split, Data Conversion, Aggregate, Merge, Merge Join, Sort, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheet, Flat file, MS Access and CSV files to data warehouse
• Expert in analyzing, designing, developing, installing, configuring and deploying MS SQL Server suite of products with Business Intelligence in SQL Server Integration Services.
• Have excellent skills in Data Warehouse, Relational and Multi - Dimensional databases, Data Migration, System Data Integration, Reporting, Analysis and Software Development and Data Management.
• Extensive experience with Data Extraction, Loading, and Transformation (ELT) from disparate Data sources like Multiple Relational Databases like MS SQL Server, MS Access, flat files, and Worked on integrating data using Azure Data factory(ADF) to load the data into Destination.
• Skilled in error and event handling, precedence Constraints, Break Points, Check points and Logging.
• Excellent experience in In-Place and Side-by- side Upgrades from MS SQL Server to MS SQL Server 2008/2008R 2/2012/2014/2016.
• Experience in importing/exporting data between different sources like Oracle/Access/Excel etc. using SSIS/DTS utility.
• Created user accounts, modified and deleted according to the environment using user administration in Active Directory.
• Experience in creating scheduling Jobs, sending Alerts.
• Experience in generating Drill through and Drill down reports with Drop down menu option using SSRS 2012 and Power BI.
• Experience in ETL processes involving migrations and in sync processes between two databases.
• Experience in Microsoft Visual C# in script component of SSIS.
• Experience in creating configuration files to deploy the SSIS packages across all environments using project deployment method.
• Experience in creating the multidimensional and tabular models using SSAS.
• Experience writing a MDX and DAX code for SSAS and Power BI.
• Experience in writing Development test cases, Unit test plans and Unit testing.
• Extensive experience with relational database Netezza Performance Server
• Experience in DBA activities such as backups, recovery, restore, replication and Linked servers etc.
• Extensively knowledge on Azure Datalake.
• Extensive Unix Shell Scripting knowledge.
• Extensive and working on PowerShell Scripting knowledge.
• Worked directly with end users and other developers to define requirements, review design, develop and test assigned components.
• Having experience in leading team and possess excellent communication and interpersonal skills, ability to quickly grasp new concepts, both technical and business related and utilize as needed.
• Working experience with Agile planning under TFS environment.

TECHNICAL SKILLS:

ETL Tools: MS SQL Server Integration Services (SSIS 2008,2010,2012,2016),Informatica 7.1, 8.6,9.1,10.1,Stambia

RDBMS: Netezza Performance Server, Oracle 8.x/9.x, Sql Server 2005/2008/2012/2014/2016, Oracle 11.2

Languages: Java, SQL, PL/SQL, Unix,C#,U-Sql,T-Sql

OS: UNIX, Windows XP/Vista, Windows 7,Windows 10

Version Control: CVS,SVN,TFS

Reporting Tools: SSRS,Microsoft Power BI,ZAP BI

Tools: Erwin 3.x, Toad, DBVisualizer,Putty,Winscp,DAX Studio

Scripting: Shell,HTML,Power Shell, DAX,MDX

Cloud: Microsoft Azure,Aure Sql Database,Azure Datawarehouse,AAD(Azure Active Directory),ADF(Azure Data Factory V2),Azure DataLake,Power BI Embeded,Azure Analysis Services,Logic App,Azure Blob Storage

PROFESSIONAL EXPERIENCE:

Confidential, Richmond, VA

Lead SSAS/Power BI/ETL Developer

Roles & Responsibilities

• Identify and collect the data that resides in various internal and potentially external sources to make that data available for reporting and analysis.
• Involved in System Study analysis for logical/physical data model there by defining strategy for implementing Star Schema with Fact and Dimension tables.
• Integration of Diferent Source data in Staging Area by using ETL process like Data Merging, Data
• Cleansing and Data Aggregation.
• Creating the diferent types of SSIS packages to extract data from legacy to SQL Server Objects.using Business Intelligence Development Studio (BIDS) and Visual studio 2015.
• Deploy the SSAS tabular models into Azure Sql server analysis services.
• Created the matrix and Tablix SSRS reports and publish them into SharePoint and Power BI Report Server.
• Azure analysis service log’s loaded into Azure Sql database from Azure Blob storage using Azure Data Factory.
• Migrated few of the SSRS and Excel reports to Power BI using Power BI Pro license.
• Designing and developing data warehouses, data marts and business intelligence using multi- dimensional models such as star schemas and snow flake schema for developing cubes using MDX and DAX
• Work directly with customer to gather the requirements and convert / code them in SSAS Tabular.
• Created the Complex Excel reports using SSAS tabular models and Marco’s in Excels.
• Using Excel pivot tables to manipulate large amounts of data in order to perform data analysis, position involved extensive routine operational reporting.
• Supporting for ongoing agile development team that works on Sales and Marketing priorities for a major consumer goods manufacturer,
• Conducted Power BI, Visualization and Dash-boarding training for groups of users.
• Worked with the technical lead and the developers to create templates for code migration and code review documents.
• Deploying the code from Development to Test and productions and tracking the Version controls using the TFS(Team Foundation servers).

Environment: Sql Server 2016/2014, Power BI Desktop, Power BI Service, AZURE Sql Datawarehouse’s Database,Azure Data Factory V2,DAX,MDX,Excel 2016,SSAS 2016,SSRS,SSIS

Confidential, NJ

Lead Power BI/ETL Developer

Roles & Responsibilities:

• Responsible for Leading the Microsoft Business Intelligence solutions utilizing Power BI, Informatica 10.1, Oracle 11g,Azure Sql.
• Gathered and documented business requirements for analytical reports.
• Participated in requirements meetings and data mapping sessions to understand business needs.
• Responsible for Administration and Configuration and optimization of BI components of our BI environments for Power Bi
• Supported creation of Azure Sql Database environment and BI Architecture
• Developed mappings that 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 the mappings
• Created Post UNIX scripts to perform operations like gunzip, remove and touch files.
• Developed the sql scripts, Procedures and views for reporting needed.
• Created the User Groups in AAD(Azure Active Directory) and provided the Power BI Reports access to users.
• Created the Power BI reports and embedded those reports into applications and SharePoint online.
• Integrated Custom Visuals like Word Cloud, Chiclet Slicer, Funnel chart, Timeline Slicer, Gantt chart and more based on business requirements using Power BI desktop.
• Created the security model (Row Level Security) in Power BI to restricted the access based on Region and Role of the user.
• Created the complex calculation columns and measures using the DAX language.
• Created the App Workspaces to share the reports and dashboards to users and organization.
• Created the Power Bi Enterprise Gateways and scheduling those datasets to load the data from Oracle On-premises to Cloud.
• Used the Microsoft API’s for Text Analytics and sentiment analysis and language conversion in Power BI.
• Created interactive dashboards by using Power BI.
• Created the content packs and publish in our Organization.
• Created complex reports such as Gauges, Matrix, Charts, Sub reports and Dashboards using Power BI.

Environment: Informatica 9/10.1, Oracle 11g,Power BI Desktop, Power BI Service, Power Bi Report ManagerDAX, Azure Sql Database.

Confidential, Gilbarco,NC

Lead MSBI/Power BI Consultant

• Responsible for Leading the Microsoft Business Intelligence solutions utilizing MS SQL Server 2014, SSIS, SSAS, Power BI, MS Azure
• Gathered and documented business requirements for analytical reports.
• Participated in requirements meetings and data mapping sessions to understand business needs.
• Responsible for Administration and Configuration and optimization of BI components of our BI environments, (Power BI, SSIS, SSAS )
• Supported creation of Azure Data warehouse environment and BI Architecture
• Migrated the Sql server databases to Azure Data warehouse.
• Developed complex Sql Stored Procedures and views to load the data into Fact tables.
• Designed SSIS packages to export and import data from SQL Server to MS Access, Oracle10g, text files and Excel files.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Experienced in working with Star Schema and Snow Flake Schema to develop Tabular model using MS SQL Server Analysis Services (SSAS).
• Utilized DAX queries to design and develop the SSAS Tabular models, KPIs, calculated members as well as hierarchies.
• Used Query Analyzer, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
• Installation and Configuration of the Virual machine to load the data from On-premises sql server to Azure Data ware house.
• Create the Data lake Store and Azure Storage to store the structured and un structured data and set up the firewall rules to specific users to access the data.
• Designed and configured Azure Virtual Networks (VNets), subnets, Azure network settings, DHCP address blocks, DNS settings, security policies and routing.
• Implemented high availability with Azure Classic and Azure Resource Manager deployment models
• Created the User Groups in AAD(Azure Active Directory) and provided the Power BI Reports access to users.
• Created the Power BI reports and embedded those reports into applications.
• Integrated Custom Visuals based on business requirements using Power BI desktop.
• Created the App Workspaces to share the reports and dashboards to users and organization.
• Installation of the Power Bi Gateways and scheduling those datasets to load the data from On-premises to Azure DW.
• Created interactive dashboards by using Power BI.
• Created the content packs and publish in our Organization.
• Connected to the On-Premises Analysis services tabular(SSAS) and generated the Power Bi reports.
• Created complex reports such as Gauges, Matrix, Charts, Sub reports and Dashboards using Power BI.
• Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.
• Created few of the POC’s using MSDN subscriptions in both on premise / in the cloud using: PowerBI, SQL Server 2012, 2014, 2016, Azure Data Factory, Azure SQL Server, Azure Data Warehouse, SSIS, SSAS, SSRS and Power BI Report Server. Several reports were built in MS Excel pivot tables (Power Pivot), PowerBI, and Power BI Reporting Services.

Environment: SQL Server 2014/2016 Enterprise Edition, SSAS, SSIS,T-SQL,Power BI Desktop, Power BI Service,MDS,DQS, Azure Dataware house,Azure Sql,Azure Data Factory

Confidential, Arizona

Senior MSBI Consultant

Roles & Responsibilities:

• Create new SSIS package to extract date from legacy to SQL Server Objects using Business Intelligence Development Studio (BIDS) and Visual studio 2013.
• Responsible for Administration and Configuration and optimization of BI components of our BI environments, (Power BI, Power Pivot SSAS server, MDS, SSIS, SSAS ).
• Conducted Power BI, Visualization and Dash-boarding training for groups of users.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Generated reports using SSRS, Excel (Pivot) that could be used to send information to diverse group of users, clients, and managers.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Responsible for creating the reports basing on the requirements using SSRS 2012.
• Developed SSIS Templates which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Dev, Test and Production Environments.
• Involved in extracting the data using SSIS from OLTP to OLAP.
• Executing data validation stored procedures in SSIS packages in Business Intelligence Development Studio (BIDS).
• Involved in Deployment and Administration on SSIS packages with Business Intelligence development studio.
• Developed, monitored and deployed SSIS packages.
• Performance tuning of Stored Procedures and T-SQL Queries.
• Developed Tablix Reports, Matrix Reports, Parameterized Reports, Sub reports using SQL Server Reporting Services 2012.
• Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
• Used Execution Plan, SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
• Created Data warehouse environment for OLAP & Data mining in SSAS
• Involved in Designing, Analyzing, building and testing of OLAP cubes in SSAS and adding calculations using MDX.
• Performed data conversion from flat file into a normalized database structure.
• Involved in System Study analysis for logical/physical data model there by defining strategy for implementing Star Schema with Fact and Dimension tables.

Environment: SQL Server 2008/2012/2014 Enterprise Edition, SSAS, SSIS, T-SQL and SSRS,Power BI

Confidential

ETL/MSBI Developer.

Responsibilities:

• Involved in meetings with Business System Analysts to understand the functionality and prepared ETL Technical Specifications
• Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
• Design of Conversion, Data extraction, transformation and load.
• Developed complex T-SQL queries and designed SSIS packages to load the data into warehouse.
• Development of update strategy to keep track of historical data.
• Utilized several Transformations like Lookup, Fuzzy Lookup for implementing the Transformation Logic in the Packages.
• Created Jobs and scheduled Packages using SQL Server Management Studio for the Daily Load.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Java,TIBCO,Netezza SQL.
• Involved in the development of ETL mappings and also tuned for better performance.
• Involved in the ETL Testing.
• Created several complex mappings as per business requirements
• Loading data into tables using NZSQL.
• Involved in Deployment, Administration & Support of multiple applications across DEV/QA/Prod environment.
• Designed a document for all the pre and post deployment activities of TIBCO package in administrator.
• Reviewing and assigning the defects to appropriate team for timely fixing. Following up with various stake holders for timely defect Fixing.
• Bugs removing and Unit testing and stress testing of the developed system and writing test cases for the same. Involved in System Integration testing and user acceptance testing.

Environment : SSIS 2012,SSRS,SSAS,NETEZZA 6.2,SQL, UNIX,java,Tibco, Shell Scripting,DB Visulizer,SSIS 2008,Sql Server 2008.

Confidential

ETL Developer

Roles and Responsibilities:

• Understanding the Customer Requirements and the Technical Specifications Documents.
• Extraction of data from Different Sources like Oracle, SQL server, and Flat files.
• Integration of Different Source data in Staging Area by using ETL process like Data Merging, Data Cleansing and Data Aggregation.
• Created complex mappings using Unconnected Lookup, Sorter, Aggregator, and dynamic Lookup and Router transformations for populating target table in efficient manner.
• Design, Develop and Implementation of Informatica Mappings and Workflows.
• Creation of Mappings using Different Transformations like Source Qualifier, Joiner, Expression, Aggregator, Router, Sorter, XML, Lookup and Update Strategy Transformation.
• The four stages - from Flat Files up to the Warehouse
• Performed the Development, Unit, and System Testing
• Worked with the technical lead and the developers to create templates for code migration and code review documents.
• Efficient Documentation was generated for all mappings and workflows.
• Given support for the production team for the first 3 weeks after the code migrated to production environment.

Environment: Informatica Power Center 8.6.1, Oracle 10g, MS SQL Server 2005/2008,Unix,Toad.