SUMMARY:

• Certified ETL/Business Intelligence specialist with more than 15 years of field experience has diverse technical expertise in design, development and implementation of Business Intelligence solutions. Extensive background and skills in SQL Server integration, Reporting and analysis services, Informatica,
• Datastage, Talend, web Development using .Net, SharePoint, Extension working experience with retail sales, finance, mortgage and apparel industry clients, accurately assess technical problems and successfully transform ideas into appropriate, workable solutions, capable of managing and document the full application development lifecycle. Good communicative team leader, who motivate and mentors’ people at all level of technical expertise.
• Over 14 years of experience in building and maintaining enterprise data warehouse, involved in implementing end to end warehouse lifecycle including requirement analysis, dimensional data modeling, ETL framework Design and development, Business Intelligence and reporting solution design and development using IBM Infosphere DataStage 9.1, SSIS, SSAS, SSRS Informatica 9.5.1, QlikView, Talend 63.1 and 7.2, Control, AutoSys
• Experience in .NET technologies, Windows Applications, Web Applications, Web Services, using C# .NET, ASP .NET, ADO .NET, .NET Framework 1.1, 2.0, 3.5, WPF, WCF.
• Extensive working experience in IBM InfoSphere Information Server suite Components
• Extensive experience inETLmethodology for performingData Profiling, Data Migration, Extraction, Transformation and Loading using Talend and designed data conversions from wide variety of source systems includingOracle, DB2, SQL server, Hive, andflat files, XML
• Debugging ETL jobs errors, ETL Sanity and production Deployment in TAC - TalendAdministrator ConsoleusingSVN.
• Experienced in ETL methodology for performingData Migration, Data Profiling, Extraction, Transformation and Loadingusing Talend and designed data conversions from large variety of source systems including Oracle …DB2, SQL server, and non-relational sources like flat files, XML
• Lead the effort to established the process, methodologies and standards at all phases of DataStage ETLs development.
• Experiences on Designedtables, indexes and constraintsusingTOADand loaded data into the database using SQL*Loader.
• Managed onsite and offshore teams. Responsible for project planning, task estimation, task assignment, resource allocation and successful execution of project life cycle.
• Extensive knowledge with Dimensional Data Modeling, Star Schema/Snowflakes Schema, Fact and Dimension tables. Knowledge of building of Operational Data Stores (ODS), Data Marts, and Enterprise Data Warehouses.
• Expertise in Configuration, Performance Tuning, and Installation of SQL Server Databases & Integration of various data sources like Oracle, MS SQL Server, and Excel, XML and Flat files.
• Extensive experience with databases (MS SQL Server 2016/2012/2008/2005/2000, Oracle 9i/10g,) along-with PL/SQL, performance tuning of SQL Server using Profiler, Execution Plans, various indexes and join types.
• Extensive knowledge in Retail, Apparel Supply Chain, Mortgage Domain, Title and Default Services.
• Experienced on designingETLprocess usingInformaticaTool to load from Sources to Targets through data Transformations.
• Experienced with Relational and Non-Relational databases such as Oracle, DB2 Blue, SQL Server, Netezza, Mango DB
• Worked with design patterns such as Singleton, Façade, Factory, Mediator etc.
• Working experience in Unix /Linux environment to provide the Unix /Linux Application support
• Working experience in Water Fall and agile project management approaches
• Worked with business and IT to convert complex business scenarios into technical solutions.
• Responsible for client relationship, team mentoring and functional / technical leadership for BI and Data teams.
• Ability to prioritize and execute tasks in a high-pressure environment
• Ability to quickly analyze and come up with an efficient industry standard solution for a given problem
• Reliable, proactive, responsible, hardworking and good team player

TECHNICAL SKILLS:

Development Platforms: Visual Studio 2008/2005, SharePoint Portal Server 2007, MS Project Professional/Enterprise, Internet Information Server,, Erwin, Power Designer, MS Visio, VSS, Test Director (6.0, 7.2), Toad 9.0, MS Office (WinWord, Excel, PowerPoint, Outlook), InfoPath 2007, SQL Server SSIS, SSAS (Tabular and Multidimensions) and SSRS, Share Point Designer 2007,IBM DB2 Content Manager, Developer 9 Oracle Forms, Oracle Reports, Crystal Reports, Visual Source Safe, SVN, Test Director InfoSphere Business Glossary, IBM InfoSphere Blueprint Director, IBM InfoSphere Data Architect, IBM InfoSphere Fast-track, IBM InfoSphere DataStage 9.1 and 11.3,I nformatica 9.5.1, Control M, Talend,AutoSys, PowerBI, Azure Data factory

Database Development: Oracle 8, 9i, 10g (SQL, PL/SQL), SQL Server 2008/2005/2012/2016, MDX Access. Netezza, DB2 Blue

Operating Systems: Windows, IOS, UNIX

PROFESSIONAL EXPERIENCE:

Confidential, Irving, TX

Senior ETL Developer/Lead

Responsibilities:

• Design ETL solution for MH Conversion by using informatica cloud.
• Coordinates with various business groups whose support needed to build
• I have involved in implementing the end-to-end ETL life cycle.
• Read and understand existing system to build new transforms design
• Requirement analysis and client meetings.
• Informatica ETL Framework design and development
• Team members code reviews and provide guidelines to overcome issue.
• Performed the sanity check after QA migration.
• Coordinated with ETL testing to fixing the defects
• Progress monitoring and offshore team member

Tools: Informatica power center 9.1,10.4 and 10.5, Duck Creak, SQL Server, Oracle, AutoSys

Confidential - Richardson, TX

Technology Lead/ETL Developer

Responsibilities:

• Design ETL solution for Wealth Management by using informatica.
• Coordinates with various business groups whose support needed to build Data Warehouse. Align Data Warehouse projects with business strategy.
• Involved in designing the dimensional models like star schema and snowflake schema

Tools: Informatica power center 10.2 and 10.5, Informatica MDM, SQL Server, Oracle, AutoSys

Confidential

Senior ETL Developer

Responsibilities:

• Coordinates with various business groups whose support needed to build Data Warehouse. Align Data Warehouse projects with business strategy.
• Involved in designing the dimensional models like star schema and snowflake schema
• Provide Technical / Functional support to Onsite and Offshore Team.
• Analyze to business requirements and implement in Microsoft BI Stack
• Communicate with Business Users, gather business requirements, and set business users expectations.
• Understand manually work of Business Analysts and the design efficient solution so that they can view reports in more easy way
• Build and maintained complex business logic in Multidimensional Expressional (MDX) queries that helps performance point dashboards to show role movement in Wealth Management.

Tools: IBM Azure Data Factory, Microsoft stack SSIS SSRS SSAS, Informatica power center 10.2, Informatica IICS, SQL Server, Oracle, AutoSys

Confidential - Irving TX

ETL Lead Developer

Responsibilities:

• Design ETL solution for PLS, GNMA, Freddie and Cirrus projects using Talend 7.2
• Design ETL solution for the various project including IVR, WIR, GNMA and FNMA using DataStage 9.1 using DataStage, SSIS
• Coordinates with various business groups whose support needed to build Data Warehouse. Align Data Warehouse projects with business strategy.
• Involved in designing the dimensional models like star schema and snowflake schema
• Created complex mappings in Talend 6.2 and 7.2 usingtMap, tJoin, tReplicate, tParallelize, tFixedFlowInput, tAggregateRow, tFilterRow, tIterateToFlow, tFlowToIterate, tDie, tWarn, tLogCatcher, tHiveIput, tHiveOutputetc.tFileInputDelimated,tFileXMLtXMLMap
• Designed ETL process using Talend Tool to load from Sources to Targets through data Transformations.
• Developed jobs in Talend Enterprise edition from stage to source, intermediate, conversion and target.
• Experienced in working with Tac (Talend administration Console).
• Designed the Talend ETL flow to load the data into hive tables and create the Talend jobs to load the data into Oracle and Hive tables.
• Working with high volume of data and tracking the performance analysis on Talend job runs and session.
• Used Talend reusable components like routines, context variable and global Map variables. implemented Data Integration and migration process with Talend Big Data Integration Suite 6.5 as part of migration fromSSISto Talend, with destination database fromSQLtoazure SQL Server and new applications development in ETL.
• Used Talend reusable components like routines, context variable and global Map variables.
• Monitored and supported the Talend jobs scheduled through Talend Admin Center (TAC)
• Provide Technical / Functional support to Onsite and Offshore Team.
• Analyze Nationstar business requirements and implement in DataStage and Microsoft BI Stack
• Communicate with Business Users, gather business requirements, and set business users expectations.
• Design SSAS Cubes for numerous Reverse mortgage/Forward Mortgage scenarios.
• Understand manually work of Business Analysts and the design efficient solution so that they can view reports in more easy way
• Build and maintained complex business logic in Multidimensional Expressional (MDX) queries that helps performance point dashboards to show role movement in Reverse Mortgage.
• Design summary charts through which executives can take a business decision in more quick way
• Provide Weekly Trend/ Monthly Trend Charts on Critical KPIs.
• Performance tuning of already developed reports and dashboards.
• Maintain Dynamic SSAS Partitions that helps better cube processing time with wider data window.
• Design and developed reporting solution for IVR using SSIS, SSAS Tabular and Power BI
• Provide support to Daily Cube Processing / Data mart loading jobs.
• Decide the use of every component of BI Stack for efficient use.
• DataStage Migration from 9.1 to 11.3
• Coordination with data modeling team to design physical and logical models
• Design and implement end-to-end data solutions (storage, integration, processing, visualization) in Azure
• Architect & implement medium to large scale BI solutions on Azure using Azure Data Platform services (Azure Data Lake, Data Factory, Data Lake Analytics, Azure SQL DW)
• Develop dashboards and visualizations to help business users analyze data as well as providing data insight to upper management with a focus on Microsoft products like SQL Server Reporting Services (SSRS) and Power BI.

Tools: IBM Infosphere Data Stage 9.1 and 11.7, Informatica power center 10.2,SQL Server 2008/2016 SSIS SSAS, Power BI and SSRS, Netezza DB, Control M, Talend 6.3.1,7.2, Azure Data factory, Kafca Realtime streaming, AutoSys, Hive, Spark, Python, Microstrategy 10.4

Confidential - Cranbury, NJ

ETL/BI Architect

Responsibilities:

• I have involved in implementing the end to end ETL life cycle.
• Read and understand existing system to build new transforms design
• Requirement analysis and client meetings.
• Translating the requirement into design (HLD, LLD)
• Create the source to target mapping sheet templates
• Informatica ETL Framework design and development including SCD 0, 1, 2 mapping temples
• Design the temples using Microsoft architect for Visio to generate the informatica mapping that have the similar structure
• Team members code reviews and provide guidelines to overcome issue.
• Performed the sanity check after QA migration.
• Coordinated with ETL testing to fixing the defects
• Progress monitoring and offshore team member

Tools: Informatica Power center, SQL Server 2008, Oracle 9i

Confidential

Development lead and solution architect

Responsibilities:

• Manage onsite and offshore teams. Responsible for project planning, task estimation, task assignment, resource allocation and successful execution of project life cycle.
• Establishing the ETL development process, Design ETL Framework, Error Handling framework, Data Validation framework, Data Reconciliation framework, IBM DataStage Best Practices, ETL Migration and deployment process.
• Error logging and handling Framework design and development
• Design and Development of Complex Data stage ETL packages to extract, transform and load data into SQL Server based OLAP data warehouse from OLTP database. Read data from flat files using ETL Packages and load into data warehouse after applying required business rules.

Tools: IBM Infosphere DataStage 9.1, SQL Server 2008

Confidential

Team lead

Responsibilities:

• Design and Development and supervision
• Development of Complex ETL packages to extract, transform and load data into SQL Server based OLAP data warehouse from OLTP database. Read data from flat files using ETL Packages and load into data warehouse after applying required business rules.
• Support and Enhancements
• Develop SSAS MOLAP Cube on data warehouse, define relationships among Dimensions and Measures, implement time intelligence, identify business critical KPI’s and create Calculated Members, Named Sets and Script Commands on frequently used Measures to build robust Cube in BIDS. Fine tune Cube design and select optimal processing option to balance the end user query time and Cube processing time.
• Make use of MDX to retrieve data from Cube, build user friendly dashboards to present KPI’s in MOSS. Build reports in SSRS using data warehouse and Cube data.
• Daily Production support
• Progress monitoring and offshore team member

Tools: SQL Server 2012 R2, SSRS, SSIS, SSAS, Visual Studio Dot Net 2008

Confidential

Team Lead

Responsibilities:

• Design and Development and supervision
• Development of Complex PL/SQL packages to extract, transform and load data into oracle based OLAP data warehouse from OLTP database. Read data from flat files using PL/SQL procedures and load into data warehouse after applying required business rules.
• Daily Production support
• Progress monitoring and Team Member
• Customer engagement and on call production support

Tools: Oracle 10g SQL, PL/SQL, Developer9 Oracle Forms, shell scripting Oracle Reports

Confidential

Responsibilities:

• Implement and monitor transactional replication using SQL server replication agent with Oracle as publisher and SQL server as subscriber to replicate Oracle OLTP data in SQL server replica.
• Responsible for Development of complex SSIS packages to transform and load data in data warehouse from different sources (Replicated OLTP database, flat files of retail sales transactions, Oracle financial database). Improve SSIS package performance by writing efficient T/SQL stored procedures. Define strategies to populate Slowly Changing Dimensions.
• Develop SSAS MOLAP Cube on data warehouse, define relationships among Dimensions and Measures, implement time intelligence, identify business critical KPI’s and create Calculated Members, Named Sets and Script Commands on frequently used Measures to build robust Cube in BIDS. Fine tune Cube design and select optimal processing option to balance the end user query time and Cube processing time.
• Make use of MDX to retrieve data from Cube, build user friendly dashboards to present KPI’s in MOSS. Develop Pivot Charts and Reports in ProClarity. Build reports in SSRS using data warehouse and Cube data.

Tools: SQL Server Replication service, SSIS, SSAS, SSRS, MOSS, ProClarity, SQL Server, Oracle.

Confidential

Responsibilities:

• Up gradation of Servers
• Up gradation of Reports
• Up gradation of ETL/SSIS Packages
• Up gradation of Cubes
• Monitoring and Resolution of issues faced during up gradation of Server and Source Code

Tools: Windows XP Workstation, Windows Server 2008 R2, Oracle 9i, SQL Server 2008 R2, Visual Studio Dot Net 2005, SSRS, SSIS, SSAS, T.O.A.D.

Confidential, St. Louis Missouri

Responsibilities:

• Development of Reports
• Research and Development of SSRS Custom Rendering Extension
• Monitoring and Resolution of issues faced during Development of Reports

Tools: Windows XP Workstation, Windows Server 2008 R2, Oracle 9i, SQL Server 2008 R2, Visual Studio Dot Net 2008, SSRS.

Confidential

Responsibilities:

• Read and understand business needs through provided FRD
• Discuss implementation and impact with Lead and Business representative
• Development estimates, implementation and document preparation

Tools: Windows XP Workstation, Windows Server 2008 R2, ASP.NET, C# 3.0, WCF, Oracle, SharePoint