SUMMARY:

• 7+ years of extensive experience in Business Intelligence, Data Analytics, Data Warehousing and providing business intelligence solutions to international financial institutions.
• Creative and self - motivated with a knack of problem solving and automation.
• Experience in developing data solutions using Microsoft Azure and Hadoop ecosystem using HDFS, Apache Ambari, Apache Hive, Apache Oozie, Apache Sqoop,
• Used Informatica BDM 10.2.x to pull Data from Hive and perform cleansing/standardization in Azure Sql Datawarehouse.
• Experience in development and implementation of data warehouses, client-server Applications & database systems using Informatica Powercenter 9.x,10.x, Informatica Developer 10.x, BASE SAS and MSBI Stack (SSIS, SSAS, SSRS, Power BI) 2016/2012/2008/2005 in different environments.
• Have very strong background in a disciplined Software Development Life Cycle (SDLC) process and excellent analytical and programming skills.
• Extensive Experience in working in Agile and RAD development environments.
• Experience in coordinating between multiple stakeholders like end users, SMEs and geographically distributed IT teams for requirement gathering and system analysis.
• Experience in due diligence of complex systems and overall architecture and impact analysis.
• Experience in creating high level and detail level design documents.
• Strong knowledge of Entity-Relationship concept, Facts and dimensions tables, slowly changing dimensions and Dimensional Modelling (Star Schema and Snow Flake Schema) and change data capture (CDC).
• Programming in SQL Server Stored Procedures, Triggers, User-defined Functions and Views, Cursors.
• Performance tuning of Stored Procedures and T-SQL Queries
• Implementing SQL Server Indexing and Query optimization using Indexes
• Experience in writing complex stored procedures to cater to reporting requirements.
• Experienced in using T-SQL in SQL Server 2012, 2008 and 2005 platform
• In-depth knowledge of Transact-SQL (DDL, DML, DCL) and design and normalization of the database tables.
• Experience in integrating data from heterogeneous sources (Excel, CSV, RDBMS, flat file, Text Format Data) by using different transformations in Informatica Powercenter and SSIS.
• Created out of the box solutions to automate Informatica ETL loads and increase reusability of code.
• Used ETL to implement client server applications to handle large volumes of data.
• Automated logging and error handling mechanism to reduce support activities.
• Performance tuning of ETL jobs.
• Expertise in Creating, Deploying and managing Reports through SQL Server Reporting Services (SSRS).
• Experience in creating several reports such as drill down reports, parameterized reports, and linked reports, sub reports, Matrix Reports and Charts using SSRS.
• Delivered SSRS reports through various mediums like web browser, email etc.
• Experience in writing custom extensions to be used as data sources in SSRS.
• Strong knowledge in Star and Snow-flake schemas and OLAP modeling which involved creating data source views with added measures, dimensions in SSAS
• Experience in Data Warehouse Modeling with SQL Server Analysis Service (SSAS).
• Worked on creation and deployment of cubes on SSAS (MDDM and Tabular) for data with pre-calculated aggregations and hierarchies.
• Extensively worked on the ETL mappings/packages, analysis and documentation of OLAP reports requirements. Solid understanding of OLAP concepts and challenges, especially with large data sets.
• Test & Deploy code across various SDLC Environments like TEST, UAT, Production
• Experience in Change Management and Release Management activities.
• Experience with scheduling Tools like Autosys.
• Hands On experience in Power BI and Qlikview.

AREA OF EXPERTISE:

Database: MS SQL Server 2005/2008/2012/2016 , Oracle 10g, Netezza, Sybase, DB2

BI Tools: Informatica Powercenter 9.x/10.x, Informatica BDM 10.2.1, MSBI(SSIS, SSAS, SSRS, Power BI), BASE SAS, Hadoop, Apache Sqoop. Apache Hive, Apache Oozie, Apache Ambari, Qlikview

Programming Languages: SQL, TSQL, PL/SQL, Unix Shell Script, Windows Batch Scripting, C, Core Java, Visual Basic

PROFESSIONAL EXPERIENCE:

Confidential

Tools: Informatica BDM 10.2.1, Apache Sqoop, Apache Hive, Apache Oozie, Apache Ambari, Microsoft Azure, Microsoft Azure Sql DWH, Unix Shell Scripting, Microsoft Sql Server 2016

Responsibilities:

• Creating complex frameworks to automate data cleansing and loading to the cloud
• Implement and automate audit, balance, control and Change data capture capabilities.
• Create Unix scripts to invoke Apache Sqoop for data ingestion to Apache Hive.
• Creating Informatica BDM mappings using complex workarounds to cleanse and standardize data.
• Job scheduling in Hadoop using Apache Oozie.
• Performance tuning at application, database and informatica level.
• Documentation and creation of knowledge bases.
• Deployment/release Management activities.

Confidential

Tools: Informatica Powercenter 10.1, Sql Server 2016, Autosys

Technology Lead

Responsibilities:

• Working with Business Analysts, End Users and System SMEs for requirement gathering.
• Creation of high level and detail level designs.
• Creating complex TSQL queries and stored procedures.
• Creating informatica mappings using complex workarounds.
• Implement rule engine to automate inclusion of regional compliance needs without changing the generic framework.
• Creating a user interactive system for regional actuaries to drive rule changes.
• Performance tuning at application, database and informatica level.
• Documentation and creation of knowledge bases.
• Deployment/release Management activities.

Confidential

Tools: Informatica Powercenter 9.5, Sql Server 2008 R2, SAP, Autosys

Technology Lead

Responsibilities:

• Lead a team of size 10 through this complex program.
• Working with Business Analysts, End Users and System SMEs for requirement gathering.
• Creation of high level and detail level designs.
• Creating complex TSQL queries and stored procedures.
• Creating informatica mappings using complex workarounds.
• Implemented out of the box solutions to read dynamic file structures, rule/schema driven loads.
• Automating the error reporting framework.
• Performance tuning at database and informatica level.
• Documentation and creation of knowledge bases.
• Deployment/release Management activities.

Confidential

Tools: Informatica Powercenter 9.1, Sql Server 2008 R2, Autosys

Senior Support Engineer

Responsibilities:

• Real time, timely resolution of issues.
• Handling user queries and requests.
• Worked on enhancements in the system based on user requirements.
• Automation of multiple support activities.
• Generating ad hoc reports for end users.
• Migration of components across environments, Release Management, Configuration Management.
• Documentation and creation of knowledge bases.
• Assisting deployment of new releases.
• Disaster Recovery Management Activities.

Confidential

Tools: MSBI (SSRS, SSIS, SSAS), SQL Server 2012

Senior Systems Engineer

Responsibilities:

• Creation of functional spec and prototype.
• Design and development of SSIS packages.
• Creation of SSAS Tabular model.
• Creation of SSRS reports.
• Root cause analysis and technical resolution for production support tickets logged for reports.
• Preparation of unit test plan and unit testing.

Confidential

Tools: Base SAS, Unix, Informatica, SSRS, Sql Server 2008 R2

Senior Systems Engineer

Responsibilities:

• Impact Analysis
• High Level Architectural Design and Detailed Design.
• Build of Base SAS programs, unix scripts, Autosys Jils and changing current informatica mappings, creation of new SSRS reports for the new fund and changing few reports to reflect the change.
• Creation of unit test plan and unit testing.
• Setup of integration testing environment and creation of integration test plan.
• Root cause analysis and technical resolution for all BI related technologies. Was the SPOC for BI modules.
• Deployment Activities
• Release management and Change Management Activities.

Confidential

Tools: Sql Server 2008 R2, Sybase, DB2, Actuate BIRT, SSRS

Senior Systems Engineer

Responsibilities:

• Creation of Functional Specs and design documents
• Analysis of Actuate Reports
• Build of SSRS reports and unit testing.
• Regression Testing.
• Release Management and Deployment Activities.
• Post Production warranty support.