SUMMARY

• 13 Years of experience in Technical Solution, Business Intelligence, Data warehouse and Data Analytics. Experience in end - to-end execution of Business Intelligence & Data warehouse application with various execution methodologies. Has facility to provide road map and capacity to build Go-To Market strategies with thought leadership. MCP certified
• ETL Development: Expertise in architect, design, development, testing, implementation and maintenance of data warehouse solutions using ETL tool SSIS 2008/2012/2016 , SSRS and SSAS.
• Implemented ETL solutions with Data profiling, Data Cleansing on Historical data, logging, Error Handling, SCD Type1/Type2, Lookups, Data Reconciliation, Aggregations & various transformations.
• Implemented ETL automation, Restart ability using Checkpoints, Archiving, Auditing, performance tuning & Reliability of ETL loading TB of data, building large scale Data Warehouses and data marts.
• Experience in Handling BLOB files from AZURE BLOB and load into SQL database using SSIS Azure File System Tasks
• Experience in creating Scripts using Windows Power Shell and Azure Power Shell
• Having experience in working in different databases SQL Server 2005/2008R2/2012/2016, Teradata and HIVE QL.
• Worked in various domains SUPPLY CHAIN, CRM, SALES and FINANCE domains.
• Sound understanding on Dimension modeling (Kimball Methodology), Star schema, Snowflake schema, MDX queries, SQL Profiler
• Having experience in executing the Projects using SDLC cycle and Agile Process
• Experience in creating reports in Power BI utilizing the SSAS Tabular via Analysis connector.
• Experience in T-SQL programming like creating complex Stored Procedures, Views and functions
• Experience in Physical Model and Logical Model by using Microsoft Visio.
• Proficient with SQL Enterprise Manager, SQL Query Analyzer, scheduling jobs with SQL Server Agent
• Expertise in query performance using execution plans for complex queries in SQL Server.
• Experience in creating ad-hoc reports by using Report Builder in SSRS.
• Having knowledge in data modeling using tool like Erwin.
• Having experience as a developer in Microsoft .NET technologies using Visual Studio.NET, C#, ASP.NET, ADO.NET
• Working in SCRUM & Agile Development methodology
• Good experience in handling multiple projects with Offshore - Onshore model and efforts estimation for the DW and BI applications.
• Quick learner and excellent team player, ability to meet tight deadlines and work under pressure.

TECHNICAL SKILLS

Programming Languages: C#, VB.NET

Scripts: PowerShell

Querying Language: T-SQL, MDX

Web Technologies: ASP.NET, ADO.NET, HTML, DHTML, CSS, JavaScript, XML

Tools: & Utilities Visual Studio, SQL Server Management Studio

Database: MS SQL Server2005/2008/R2/2012/2016, Teradata, HIVE, Oracle

Version Control: Microsoft VSS, Team Foundation Server(TFS), SVN

BI: MSBI Stack (SSIS,SSRS, SSAS), Power BI

Designing Tools: Microsoft Visio

Operating Systems: Windows 9x/2000/XP, Windows 7,UNIX, Windows 10

Others: HP QC10, ALM

PROFESSIONAL EXPERIENCE:

Confidential, CO

MSBI Architect

Responsibilities:

• Understand the existing multi-hop manual process and automate the process flow using SSIS (SQL server 2016) ETL and T-SQL.
• Design of SSIS packages to fetch data from on premise to AZURE BLOB and vice versa.
• Load the multisource data from on-prem databases to Azure Blob using Azure blob storage service in JSON format.
• Created a Generic package for SDP Automation which load data from Different Opco’s into Database using Dynamic SQL.
• Processing of large size of files (around 7GB) files from different sources using SSIS packages
• Creating reusable ETL control parts and package templates to utilize them across other point of sale automation systems on various Line of Business across the organization.
• Implement table partitioning to avoid table level locking issues when different operating company’s data process is initiated at the same time by locking at partition level.
• Use of SSIS 2016 Azure components to Upload or Download files.
• Performance Tuning of Existing SSIS Packages.
• Created complex Stored Procedures using T-SQL and called them in SSIS packages
• Experience in creating reports in Power BI utilizing the SSAS Tabular via Analysis connector.
• Used SSIS Advanced components like scripting, Email, Event handling etc. While building SSIS Packages
• Created and Managed OLAP Cubes using SSAS
• Involved in creating calculated members, named set, advanced KPI’S for the SSAS cubes.
• Creating Linked Services, Data Sets, and Pipelines for Azure Blob storage and maintaining them
• Experience in creating Executive Dashboards in PowerBI.com using Tiles from reports.
• Experience in connecting MicrosoftPowerBIDesktop to various data sources.
• Experience in creating Datasets using different data sources like Microsoft SQL Server, Microsoft Azure, and Excel.
• Experience on implementing Data security (row level security) on Dataset and Reports.
• Experience in Uploading Power BI reports to Power BI online version and implement security and audit.

Environment: SQL Server 2016, SSIS 2016, C#, Visual Studio 2015, Windows 10, Power Shell Scripts, Microsoft AZURE, Power BI and SSAS

Confidential, IL

MSBI Lead Developer

Responsibilities:

• Design of SSIS packages from the existing BizTalk flow.
• Extract data from ASIA PACIFIC Markets using POWER SHELL Scripts
• Process around 60k files from different Markets daily using SSIS packages
• Extract data from REST web services and process in SSIS packages
• Created complex ETL packages with different data sources and then loaded the data into destination tables by performing different kinds of transformations using SSIS (CSV, Pipe delimited, XML, Excel etc.)
• Generating Output .dat files from the SSIS packages and send to stake holders
• Creating schedules for POWER SHELL scripts using windows task scheduler
• Deploying SSIS packages in AWS Cloud environment (EC2 Instance) and scheduling jobs using SQL Agent
• Performance Tuning of Existing SSIS Packages.
• Created complex Stored Procedures using T-SQL and called them in SSIS packages
• Support to Production team as needed.
• Develop and maintain the daily/weekly status report and provide the same to Higher Management
• Used SSIS Advanced components like scripting, Email, Event handling etc. While building SSIS Packages

Environment: SQL Server 2014, SSIS 2012, C#, Visual Studio 2012, Windows 10, Power Shell Scripts, XML, REST Web services, AWS EC2 Instance

Confidential, MO

MSBI Lead Developer

Responsibilities:

• Created ETL packages with different data sources and then loaded the data into destination tables by performing different kinds of transformations using SSIS (CSV, Pipe delimited, and Excel etc.)
• Integrate with SAP BW using WCF LOB Adapter and BizTalk Adapter to fetch data using SSIS and load in SQL tables
• Implemented ETL automation by scheduling SQL Server jobs using SQL Server Agent, Restart ability using Checkpoints, Archiving, Auditing, performance tuning and Reliability of SSIS Packages loading TB of data.
• Used SSIS Advanced components like scripting, Email, Event handling etc. While building SSIS Packages
• Created and Managed OLAP Cubes using SSAS
• Leading offshore team of size 4
• Review the Test Cases with Business and suggest the changes in the test case preparation.
• Derived output files using the SSIS packages as per the specification.
• Performance Tuning of Existing SSIS Packages.
• Responsible for Scheduling and Maintains the Jobs in SQLAgent.
• Created Power BI reports & effective dashboards after gathering and translating end user requirements.
• Experience in creating calculated measures and columns with DAX in MSPowerBIDesktop.
• Experience in connecting MicrosoftPowerBIDesktop to various data sources.
• Publishing Power BI Desktop reports to Power BI Services.
• Develop and maintain the daily/weekly status report and provide the same to Higher Management

Environment: SQL Server 2012, SSIS, C#, Visual Studio, Windows 7, SAP BW, SAP BO, Power BI and SSAS

Confidential, GA

Project Lead

Responsibilities:

• Working on SCRUM AGILE methodology with two week iteration.
• Performed data analysis and reported the findings to the business team.
• Involved in the complete data warehouse development life cycle. Actively supported business users for change requests.
• Experience in using JIRA for the User stories.
• Involved in Data Integration process by developing common definitions of sourced data, establishing data integration specifications.
• Developed various operational Drill-through and Drill-down reports using SSRS
• Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports.
• Used cascaded parameters to generate a report from two different Data Sets.
• Involved with Query Optimization to increase the performance of the Report.
• Analyze data sources, defining and validating data objects, identifying the relationship among data objects.
• Performance tuning of ETL packages and SQL stored procedures.
• Developed Automation Scripts to identify and extract test data for Regression Testing.
• Created complex SQL Queries/HIVE Queries, for application using T-SQL.
• Identifying the risks and timely communication of the risks and suggesting the solution without impacting the project timelines.
• Created POWER PIVOT Reports for the Business Needs
• Review the Test Cases with Business and suggest the changes in the test case preparation.
• Develop and maintain the daily/weekly status report and provide the same to Higher Management
• Monitor Job Scheduling activities and create Implementation and back out plan documents for the deployment
• Running of UNIX jobs using Shell scripting.
• Monitor the Non-Functional testing activities such as Implementation, back out, and Job Scheduling using MAESTRO CONSOLE.
• Participate in UAT with end users to provide them technical guidance and data set up needs.
• Participated in IRB reviews.
• Responsible for environment configurations, data setup and user access to the team members, preparation of test cases and application installations and testing schedules.
• Production Support and coordinating with different teams across organizations during post implementation validations.

Environment: JIRA, Teradata, UNIX, Shell Script, Hadoop, HIVE, Windows 7, SSIS 2012 and SSRS and SQL Server 2012

Confidential, GA

Project Lead

Responsibilities:

• Analyze data sources, defining and validating data objects, identifying the relationship among data objects.
• Performance tuning of ETL packages and SQL stored procedures.
• Developed Automation Scripts to identify and extract test data for Regression Testing.
• Created complex SQL Queries for application using T-SQL.
• Identifying the risks and timely communication of the risks and suggesting the solution without impacting the project timelines.
• Review the UAT test cases along with testing team with the Business users/and suggest the changes in the test case preparation.
• Develop and maintain the daily/weekly status report and provide the same to Higher Management
• Monitor Job Scheduling activities and create Implementation and back out plan documents for the deployment
• Participate in UAT with end users to provide them technical guidance and data set up needs.
• Participated in IRB reviews.
• Responsible for environment configurations, data setup and user access to the team members, preparation of test cases and application installations and testing schedules.
• Production Support and coordinating with different teams across organizations during post implementation validations.

Environment: Power Shell Script, Windows 7, SSIS 2008R2, SQL Server 2008R2, Teradata

Confidential

Sr. Software Engineer

Responsibilities:

• Participated requirements gathering meetings along with Leads
• Writing stored procedures, views, functions and sql scripts in SQL Server 2005 for enhanced functionality.
• Performed unit testing.
• Interacted with the clients on weekly basis regarding the status of the project
• Extensively involved in the design, coding, deployment and maintenance of the project.
• Provided support and enhancement according to the requirements.
• Involved in Designing Forms, Developing Middle Tier Business Logic and Database Layer.
• Developed reusable Business Logic Components used for rating the Policy Coverage’s.
• Handled the process dealt with implementation of application in client place.
• Writing stored procedures, views, functions and sql scripts in SQL Server 2005

Environment: Visual Studio, C#, Sql Server 2005, SSIS, HTML, ASP.NET and Windows

Confidential

Sr. Software Engineer

Responsibilities:

• Involved in coding, deployment and maintenance of the project.
• Provided support and enhancement according to the requirements.
• Creating of complex stored procedures and performance tuning of Procedures.
• Involved in Designing Forms, Developing Middle Tier Business Logic and Database Layer.
• Handled the process dealt with implementation of application in client place.
• Writing stored procedures, views, functions and Sql Scripts in SQL Server 2005

Environment: Visual Studio, Sql Server 2005, T-SQL, Asp.Net

Confidential

Software Engineer

Responsibilities:

• Provided support and enhancement according to the requirements.
• Involved in Designing Forms, Developing Middle Tier Business Logic and Database Layer.
• Extensively used Object Oriented Programming.
• Exceptions are handled and the user is intimated with user friendly messages.
• Developed reusable Business Logic Components used for rating the Policy Coverage’s.
• Writing stored procedures, views, functions and sql scripts in SQL Server 2005.
• Involved in UNIT Testing.

Environment: Visual Studio, Asp.Net, C#, SqlServer 2005, HTML and Windows