SUMMARY

• 7 years of experience in Data Warehousing, Data Migration, Business Intelligence, Extraction Transformation and Loading (ETL) tools and technologies, Oracle applications and SQL Server database development in agile and waterfall method of Software Development Life Cycle.
• Experience in using different types of stages like Transformer, Aggregator, Merge, Join, Lookup, Sort, copy, remove duplicate, Funnel, Filter, Pivot, Shared containers for developing jobs.
• Proficient in Microsoft BI Tools (SSIS/SSRS/SSAS) and T - SQL using SQL Server 2005/2008R 2/2012/2014/2016.
• Involved in teh Business Analysis of teh OLTP and OLAP data and in decision support.
• Expert in Developing Power BI Reports and Dashboards from multiple data sources.
• Excellent hands-on experience in ETL (Extraction Transformation and Loading) by extracting large volumes of data from various data sources using SSIS.
• Experience in T-SQL (DDL, DML, and DCL), Creating, developing new database objects by like Tables, Views, Indexes, Complex stored procedures.
• Designed and developed SSIS packages to extract data from teh transactional and/or operational databases, transformed teh data according to analytical / reporting business needs, and loaded teh data into a data warehouse or data mart.
• Designed SSAS cube to hold summary data for dashboards and OLAP Analysis.
• Experienced in Developing, Designing, and Support interactive Tableau dashboards.
• Hands-on experience working wif Logging, Error handling using Event Handlers pre and post for SSIS Packages.
• Experienced in providing Logging, Error handling by using Event Handlers, and Custom Logging for SSIS Packages.
• Creating SSIS Packages for integrating data using OLE DB connection from sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union.
• Strong skills in IBM-DataStage 11.3/9.1/ 8.5/7.5 , SQL Programming, IBM DB2, Debugging, Performance tuning, Shell Scripting and agile project execution and Software development life cycle (SDLC).
• Designed and developed parallel jobs, server and sequence jobs using DataStage Designer.
• Strong experience working wif database modeling tools and Version Control tools (TFS, Git).
• Utilized Azure Devops for teh CI/CD system to build, test, and deploy.
• Proven track record in addressing production issues like performance tuning, enhancement, data, environment and memory issues.
• Proficient in working wif Data in Data Analysis, Data Integration, Data Mapping, Data Conversion, Data Migration, Data flows and Metadata Management Services and Configuration in OLTP and OLAP environments.
• Excellent skills in implementing ETL Packages using DTS and SSIS 2008/ 2005.
• Participate in Azure migration for existing Data Warehouse from on premise to Iaas VM in Azure Cloud.
• Experience in database design and development using SQL Azure and Microsoft SQL Server.
• Implemented ad-hoc analysis solutions using Azure Data Lake Analytics/Store.
• Strong development skills wif Azure Data Lake, Azure Data Factory and PowerShell.
• Extensively used BI Integration Services to design ETL process and BI Analysis Services to create cubes.
• Team player wif excellent Interpersonal skills, commitment and result oriented approach.

TECHNICAL SKILLS

ETL Tools: SSIS, SSRS, SSAS 2014/2012/2008 R2/2005, Data Stage 11.5/11.3, Infosphere Qualitystage 8.7/8.5, Data Stage Parallel Extender, Ascential Datastage, Information Analyzer 8.1

BI / Reporting Tools: Power BI, SSRS, Tableau 7x, 8x, Cognos 8.3 Suite, Report studio, Query studio Crystal Reports, SQR, D2K. Business Objects XI R2/R3, Power Designer, MS Visio, ERWIN

Database Tools: MS SQL Server 2014/2012/2008 R2/2005, Oracle 11g/10g/9i/8i, TOAD 7.5, MS Access, SQL Server Management Studio, SQL Server Data Tools, Business Intelligence Development Studio (BIDS), Visual Studio, SQL Profiler, AQT(Advanced Query Tool), Netezza, IBM DB2/UDB, PeopleSoft EPM 8.9 / 9.0,Service Now.

Operating Systems: Linux, Unix, Windows 7, Windows 10.

Programming Skills: SQL, T-SQL, PL/SQL, MDX, DAX, HTML, XML, Visual Basic, IIS, ASP, Java Script, VB Script, Python

Web/App Servers: WebSphereApplicationServer 3.5/4.0/5.0/5.1/6.0 , IBM HTTP Server, Apache Web Server.

Scheduling: Data stage Director, Mainframe workload scheduler (C7), Tivoli Workload Scheduler, AutoSys, Zena.

CI/CD & Version Control: Azure Devops, TFS, SVN, Git, Git Hub

PROFESSIONAL EXPERIENCE

ETL Developer

Confidential

Responsibilities:

• Design data extraction processes to meet business application requirements and data sources.
• Use teh DataStage Designer to develop processes for extracting, cleansing, transforming, integrating and loading data into staging tables.
• Use teh DataStage Director and its run-time engine to schedule running teh solution, testing and debugging its components, and monitoring teh resulting executable versions on an ad hoc or scheduled basis.
• Tune DataStage transformations and jobs to enhance their performance.
• Create, maintain, and optimize stored procedures, functions, SQL queries and database structures
• Created SSIS Packages to extract data from Excel Files, MS Access files using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task to generate underlying data for teh reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse
• Worked wif process manager for data extraction and cleaning using MS Excel, Power BI and analyzed teh data using descriptive visualizations in Power BI.
• Customized DAX/MDX queries in building expressions for various business calculations.
• Hands-on experience indeploying SQL Databases in Azure.
• Implementation of SQL Server Analysis Services (SSAS), Design/Change/Deploy OLAP Cubes.
• Involved in Analyzing, designing, building &, testing of OLAP cubes wif SSAS.
• 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.
• Created SSIS packages which involved a variety of transformations such as Slowly Changing Dimension, look up, Aggregate, Derived Column, Conditional Split, Multicast, Union All, Merge, Merge Join, and Data Conversion before loading teh data into Data Warehouse.
• Performed daily back up of entire database and recovery. Responsible for creating teh reports basing on teh requirements using SSRS 2008.
• Involved in Data Migration using SQL, SQL Azure, Azure storage, and Azure Data Factory, SSIS, PowerShell.
• Written SQL Scripts and PL/SQL Scripts to extract data from Database.
• Created SQL Server Reports and developed queries for generating drill down and drill through reports using SSRS.
• Implement efficient and consistent multidimensional analysis using UNIX.
• Develop scripts to automate teh execution of ETL using shell scripts under Unix environment.
• Maintain project documentation relating to testing, coding and logic of ETL processes
• Expertise in implementing DevOps culture through CI/CD tools like Repos, Code Deploy, Code Pipeline, GitHub.
• Used teh version control systemGITto access and deploy scripts between different Environments and to coordinate wif CI/CD tools.

Environment: MS SQL Server SQL server 2008 R2, T-SQL, SQL Server Query Analyzer, SSAS, SSRS, SSAS, Microsoft Power BI, IBM DataStage, AQT, Visual Studio 2010, Azure Devops, Oracle.

ETL Developer

Confidential, Olympia, WA

Responsibilities:

• Designed and implemented Dashboards and Scorecards wif business KPIs using Performance Point Server and published them via Power BI.
• Built Ad-Hoc reports in Power BI depending on Business requirements is one of teh major responsibilities.
• Connect different data sources like SQL DB (SQL Query), Tabular Model (MDX Query), Web Trends to Power BI, and generate reports wif different visualizations.
• Generated calculated Columns and Measures in Power BI and Excel depending on teh requirement using DAX queries.
• Created bottom count, top count, cross join, non-ascendants, log MDX queries for creating Calculations, and KPI’s on a cube.
• Responsible for Scheduling jobs for weekly, daily data refresh on different Power BI reports.
• Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.
• Designed a Data Model wif multiple Fact Tables and Dimensions depending on teh business requirements.
• Built a Tabular Model cube from scratch data and by MDX queries fetched data to SSRS, Tableau and Power BI reports.
• Developed dashboard reports using Reporting Services, Report Model, and ad-hoc reporting using Report Builder.
• Using SQL Server Integration Services (SSIS) as an ETL Tool, teh data has Extracted, Transformed, and Loaded (ETL) from Excel and Flat file to MS SQL Server.
• Designed SSIS packages to transfer teh data from flat files, Access database, and excel documents to teh Staging Area in SQL Server 2012.
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Created SSRS reports using Report Parameters, Drop-Down Parameters, Multi-Valued Parameters, Debugging Parameter Issues Matrix Reports and Charts.
• Advanced knowledge wif Excel Power Pivot Tables and Vlookup. Experienced in working wifAzure SQL Database Import and Export Service.
• Created various reports using Tableau based on teh client’s needs.
• Implemented Copy activity, Custom Azure Data Factory Pipeline Activities.
• Adept inMoving Data in and out of Windows Azure SQL Databases and Blob Storage.
• Enhanced Power Pivot models and Power Pivot reports publish reports onto SharePoint, and to deploy models into SQL Server SSAS instance. Create Parameterized SSRS Reports and Power Pivot Workbooks using data of teh Tabular model and Cube data model to prove teh functionality of teh database.

Environment: IBM DataStage, Microsoft Power BI, Tableau, SQL Server, SSIS, SSAS, SSRS, Visual Studio 2010, Azure, Oracle, Power Pivot & Power Query, Data Models.

ETL Developer

Confidential, Pittsburgh, PA

Responsibilities:

• Worked on Extracting, Transforming and Loading (ETL) data from Excel, Flat file, to MS SQL Server by using SSISservices.
• 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 teh data using SSIS from OLTP to OLAP
• Extract Transform Load(ETL) development using SQL Server 2008 Integration Services (SSIS).
• Involved in gathering and analyzing user requirements.
• Created Stored Procedures, Triggers, Tables, Views and Functions for teh Application.
• Developed complex T-SQL code for teh application conversions.
• Involved in developing Data Access Components to access teh SQL Server Database using ADO.NET.
• Took over teh responsibility in implementation and documentation required to ensure that million records were accurately migrated.
• Performed daily back up of entire database and recovery. Responsible for creating teh reports basing on teh requirements using SSRS 2008.
• Experience in creating Tablix Reports, Matrix Reports, Parameterized Reports, Sub reports usingSQL Server Reporting Services 2008.
• Developed T-SQL packages, pivot tables and MS SQL reporting services reports.
• Defined teh report layout in SSRS. Created complex stored procedures for Reporting services, Analyzed Reports and Fixed Bugs.
• Implemented complex query techniques of passing Multi-Valued parameters and cascading parameters inMDX.
• Generated custom and parameterized reports using SSRS. Created various visualizations like waterfall, funnel, matrix visualization, scatter plots, combo charts, gauges, cards and KPI.
• Developed complex SQL queries using stored procedures, temporary table to supportPower BIand SSRS reports.
• Created functional and technical specifications for projects.
• Involved in Code Review, Unit testing, logging and Custom Logging in SSIS Packages, Query verification in SSIS and Stored Procedures.

Environment: MS SQL Server 2012/2014, Management Studio (SSMS), ETL, Integration Services (SSIS) 2012, Power BI, Power BI Service, Tableau.

ETL Developer

Confidential

Responsibilities:

• Facilitated meetings for gathering/refining requirements from teh customer for developing reports in SSRS.
• Modified grouping, sorting columns, and writing expressions according to teh business requirements.
• Transferred teh data using SSIS packages.
• Extensively worked wif SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast, and Lookup.
• UsedSSISto createETLpackages to validate, extract, transform, and load data toData Warehousedatabases.
• CreatedSSIS packages to export data from a text file to SQL Server Database.
• Used For each loop container, Sequence Container, Script task, Expressions, Execute SQL task, Send Mail Task, Package Execution task to achieve business needs.
• Generated Reports using Global Variables, Expressions, and Functions for teh reports.
• Developed complex Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports, Matrix reports and linked reports using SSRS.
• Built reports, customized Reports, on-demand reports, ad-hoc reports, and involved in analyzing multi-dimensional reports inSSRS.
• Designing teh Reports as per client Requirement and created teh reports using Excel file and SQL Server database.
• Prepared functional test plans and executed QA testing prior to client delivery.
• Worked on development of SSIS packages for various inbound/outbound data, OLAP data architecture as well as Report functionalities inSQL Server.
• Generated Ad-Hoc reports on a timely basis and also to fulfill immediate requirements.
• Used star and snowflake schema in designing cubes for creating SSAS packages.
• Created complex SSAS cubes wif multiple fact measures groups, and multiple dimension hierarchies based on teh OLAP reporting needs.
• Worked on knowledge transfer and documentation of various jobs developed and deployed into production.
• Provided back-end support for functional testing and performance testing. Developed scripts to migrate data from multiple sources to desired destination using ETL tools.

Environment: MS SQL Server SQL server 2008 R2, T-SQL, SQL Server Query Analyzer, SSAS, SSRS, SSAS.

ETL Developer

Confidential

Responsibilities:

• Experience working in agile methodology of Software development life cycle and expertise knowledge of Scrum in Agile.
• Interacted wif Data Modelers and Business Analysts to understand teh requirements and teh impact of teh ETL on teh business.
• Worked on all activities related to teh development, implementation, administration and support of ETL processes for large-scale Data Warehouses usingSSIS.
• Created Clustered and Non-Clustered Indexes on tables for performance optimization of complex stored procedures.
• Using T-SQL created complex Stored Procedures, Triggers, cursors, tables, views and other SQL Queries wif Joins for applications using SQL Server 2005/2008.
• Extracted data from different sources like SQL Server, Flat Files, Excel, Oracle and Composite View and transformed, loaded into required database using SSIS packages.
• Created stand-alone SSIS packages wif different transformations like Derived Column, Lookup, Merge, Conditional split and Script Component.
• Designed and created SQL Databases, tables, indexes, and views, User Defined Functions, Stored Procedures, and Triggers to support business applications.
• Created packages inSSISwif error handling.
• Created SSIS packages wif XML file, Parent-child, SQL Server table, Environment variable configurations for easily moving teh packages across multiple environments.
• Maintained History tables for slowly changing dimensions. Expertise knowledge on creating and using Linked Server.
• Identified and worked wif Parameters for parameterized reports in SSRS.
• Created SSRS Reports on teh top of teh cube using some MDX queries.
• Involved in identifying and creating Data Sources and Data Source Views in SSAS. Using SSAS created Dimensions and Cubes and deployed it on to teh server for teh managers to analyze teh business.
• Created document for Self-Service Deployment and Execution process forSSISpackages.
• Collaborated wif data warehouse team members in designing of data marts along wif reporting.
• Assisted in development, maintenance and optimization of OLAP cubes and data sets.
• Involved inMigrationof Databases fromSQL Server 2005 to SQL Server 2008 using SSIS.
• Coordinate wif business teams to prepare SIT and UAT test scenarios.

Environment: MS SQL Server 2008/2012 Enterprise Edition, MS SQL Server Reporting Services 2012.

MS SQL Developer

Confidential

Responsibilities:

• Perform all SDLC phases related to extract, transform, and load (ETL) processes using SSIS and stored procedures wifin SQL Server environment.
• Developed various objects such as Functions, Tables, Views, Triggers, Indexes and Constraints.
• Developed User Defined Functions for giving Scores and views for teh application.
• Reviewed and fine-tuned stored procedures and triggers before production migration.
• MS SQL server 2012 installation and configuration, mirroring of Data Tier Server, TFS database backup and restoration.
• Optimized queries by looking at Execution Plan for better tuning of teh database.
• Created Clustered and Non-Clustered Indexes for Query Optimization and involved in Database Tuning.
• Used SQL Profiler for monitoring and troubleshooting performance issues in T-SQL code and stored procedures.
• Involved in DBA activities such as backups, restores, replication etc. Performs database tuning and troubleshooting. Install and troubleshoot replication, performs production migrations, backups, and database recovery.
• Performed Full load & Incremental load wif several Dataflow tasks and Control Flow Tasks using SSIS.
• Configured Connection Manager files for SSIS packages to dynamically execute on Quality Analysis server and Production server.
• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.

Environment: MS SQL Server 2008R2, Visual Studio, Windows 2008, T-SQL, MS Excel, Microsoft SQL Server Integration Services (SSIS) 2008, TFS.