SUMMARY:

• Enterprising IT professional with over 10 years of experience across ETL Architecture, Data Analytics and Project Management
• Hands - on experience in working on AWS concepts and technology to manage emerging new trends in Cloud and AIA space
• Successfully used Pentaho and Informatica PowerCenter as ETL Tool and Power BI/Qlikview for analytical and reporting needs
• Mapped clients’ requirements through gap analysis; analysed workflow to design solutions spanning proof of concept, presentation, product design and development
• Excellence in evolving technology, communicating data findings to key stakeholders to help the organization meet business challenges
• In-depth knowledge of SDLC for data warehouse projects; successfully executed several data warehousing projects
• Extensive project management experience, proficient in gathering requirements , developing, implementing solutions, partnering closely with stakeholders to achieve higher levels of efficiency and effectiveness
• Experience in managing complete Data Warehouse Development Lifecycle including Enterprise Architecture, Data Analysis, Database Design, Database Performance Tuning & Optimization, and Data Warehouse Optimization
• R ich experience in managerial activities entailing rendering technical leadership & guidance to the team members, planning, scheduling tasks, and holding discussions with different functions & management for reviews and analysis

SOFT SKILLS:

• Communicator Innovator
• Thinker
• Collaborator Intuitive

IT SKILLS:

• Informatica PowerCenter, Pentaho, Netezza, SQL Server, Oracle, AWS Redshift
• Waterfall
• Agile
• Unix
• Powershell

KEY SKILLS:

• Business Intelligence Solutions/ Analytics
• Data Warehousing/ Reporting
• IT Project Management & Execution
• Application Roadmap
• Service Delivery & Implementation
• Gap Analysis
• Process Improvement/ Automation
• ETL Architecture
• Stakeholder Management
• Performance Tuning
• Team Management

WORK EXPERIENCE:

Confidential, New York

ETL Lead/Architect

Technologies: SQL Server, PowerShell, AWS, Pentaho

Responsibilities:

• Developing presentation and presenting the same to the business users about the Energy Consumption reports and their changes as required
• Steering the implementation of ETL to extract and transform data from text files, SQL Server 2017 instances
• Participating in project planning sessions with Project Managers, Business Analysts and Team Members to analyse business requirements and outline the proposed solution
• Driving effective use of joins and sub-queries to simplify complex queries involving multiple tables
• Directing full development cycle of planning, analysis, design, development, testing, and implementation using data mining and data analysis tools
• Finding new process, determining gaps in existing process and implementing new processes; participating in design reviews and contributing in allocation of functionality to specific system components
• Ensuring that the project delivery team structure is adequate and enforces compliance, best practices, approach & direction for the technical aspects of the organization's practice; providing technical leadership
• Simulating, designing, developing & deploying computationally complex and practical data; building and delivering comprehensive data strategy roadmaps; ensuring final deliverables are of the highest quality
• Spearheaded system design and development to understand energy consumption and factors affecting the same
• Proactively participated in gathering requirements to develop C3IoT Project and in designing Physical and Logical of Data Warehouse
• Directed transformations using Pentaho Suite Community Edition to transform data into canonical format
• Developed and established the parent & child hierarchy for the given data

Confidential, New York

BI/ETL Developer

Technologies Used: Informatica PowerCenter, Qlikview, Control M, SQL Server, PowerShell, AWS Redshift, Netezza

Responsibilities:

• Developed and implemented various interfaces using Informatica to extract data from multiple sources into HealthShare built to implement Health Information Exchange (HIE)
• Successfully extracted data from AWS Redshift; worked on Waterfall and Agile methodologies
• Integrated data sources and databases with QlikView; designed and developed data models
• Drafted data queries and reports using WellView, QlikView, Visual Studio, SQL Server Management Studio, SSRS, and Excel; drafted custom queries/reports designed for quality verification and information sharing
• Evaluated underlying data for potential discrepancies, investigated errors, and performed data cleanup
• Spearheaded the development of ETL programs using Informatica to implement the business requirements
• Rendered production support to resolve ongoing issues and troubleshot the problems, as needed
• Directed the usage of debugger for identifying bugs in existing mappings by analysing data flow & transformations

Confidential, California

ETL Lead Developer

Technologies Used: Oracle, Informatica, UNIX, BMC, Putty, Toad, SQL Developer

Responsibilities:

• Developed and executed interfaces using Informatica to extract data from sources into new financial application
• Evaluated the source data coming from various source systems like Oracle, SQL Server and Flat Files
• Led the development of ETLs through Informatica Power Center 9.x extracting data from Oracle/Flat Files
• Managed the development of Shell Scripts in UNIX encompassing PARAM files creation, file transfer
• Successfully scheduled and automated the jobs through BMC; performed UT/IT and coordinated UAT activities
• Administered performance tuning operations in ETL - Informatica and Oracle stored procedures/queries

Confidential, California

Informatica ETL Developer

Technologies Used: Informatica 9.5, 9.0, UNIX and Netezza, Putty, Aginity, Autosys

Responsibilities:

• Successfully developed various ETL to load data into data warehouse using transformations like Sorter, Aggregator, Expression, Joiner, Update Strategy and Lookup
• Managed and troubleshot Informatica related issues and rendered proactive solutions
• Led the optimization of Informatica workflow to enhance performance while ensuring all round compliance
• Drafted UNIX Shell Scripts, facts and dimension objects in data marts to support various Business Teams
• Developed stored procedures and queries in Netezza using the client tool “Aginity”
• Directed the deployment of several enhancements in parallel with Informatica Production Support

Confidential

Informatica ETL Developer

Technologies Used: Informatica, SQL Server, UNIX

Responsibilities:

• Analysed customer requirements and provided development of ETLs by conversion to technical requirements
• Ensured all time data availability to downstream applications by providing support to all the existing interfaces