SUMMARY:

• Over 9 years of comprehensive experience in Data Warehouse/ Business Intelligence technologies helping clients align IT strategies with corporate strategic objectives across departments.
• Expertise in database design and methodology from multiple perspectives (user, designer, and developer) and hands - on experience in design, development, and implementation of Extraction, Transformation and Load (ETL) techniques.
• Excellent client-facing skills and worked on complete SDLC of the projects.
• Good experience developing SQL, PL/SQL Stored Procedures, Packages, Functions, Cursors and Triggers.
• Extensive experience in Working with Informatica Power Center involving Warehouse designer, Workflow Manager, Work flow Monitor, Repository Manager, Source Analyzer and developed Source and Target layout, Mappings, Mapplets, Worklets and Transformations.
• Extracted data from Homogenous sources, Heterogeneous sources which includes RDBMS, Flat files - Fixed Width and delimited files.
• Experience in various utilities that includes IBM DB2 Load Utility and IBM DB2 Export.
• Experience in Teradata BTEQ, FASTEXPORT, MULTI LOAD, FASTLOAD and CDC.
• Experience in Performance Tuning and Code Optimization.
• Extensively worked in UNIX to create and execute scripts and to monitor the behavior of applications running at the back end, perform and monitor load utilities, scheduling through CRON
• Expertise in Job automation tools like JAMS, Oracle scheduler and IBM Trivoli Workload scheduler
• Proven ability in PLSQL and Informatica Deployment group based code movements across Testing and Production environments
• Project Management skills including: estimating, scope management, budget management, time management, risk management, change management, issue/conflict resolution, communication management, quality management, testing plans, training plans, and team management
• Proven history and track record of completing quality projects on time of varying size, scope, complexity
• Hands on experience Reporting tools - Tableau and splunk.
• Experience in Agile methodology, with development and QA testing activities.
• Completed certification on Google Cloud Platform Fundamentals (CP100A).
• Acted as Project Lead in complex projects (onsite - offshore model) and good Team player.
• Proficient at setting priorities and meeting goals, Outstanding communication and interpersonal capabilities
• Quick learner with ability to rapidly achieve organizational integration, assimilate job requirements, employ new ideas, concepts, methods, and technologies.
• Have experience in Retails
• Have experience in Healthcare/insurance and good understanding of HIPPA 2010 files
• Received On the spot during Jun 2013 and Jan 2015 at Infosys and Received star of the Quarter award during May 2014 at TCS.

TECHNICAL SKILLS:

Languages: C, C++

Query Language: Oracle PL/SQL, Teradata, SQL

Databases: Oracle 10g/11g, SQL Server 2005/2008, DB2, MYSQL

Tools: Used: Informatica 8.5/9.1/10 Power center, SQL Developer, Toad for Oracle,Teradata SQL Assistant, Tableau, Splunk,HP Quality Center / ALMMicrostrategy reporting Tool: FTP Tools (Win SCP and File Zilla),Unix Putty, Compare tools. Jira.

PROFESSIONAL EXPERIENCE:

Confidential,Atlanta, GA.

ETL developer

Tools: Used Oracle PL/SQL, Informatica 10, Unix, STEP, CRON, JAMS and Jira.

• Interaction with the Clients and understand requirements
• Code and Functionality Walk through to Team.
• Oralce PL/SQL package development and support.
• ETL development and maintenance.
• Adhoc data analysis for business.
• Training and Mentoring to the team members
• Analysis of Change Requests and developing Requirements specification, technical specification, test plan, test evidence, component lists and design documents e.g.) to complete this ADHOC CR’s
• Establish “Best Practices” and plan for continuous improvement of processes
• Process documentation
• Documentation of issues in Jira.
• Job automation
• Preparing periodic report
• Post implementation support

Confidential,Atlanta, GA.

ETL and BI Lead

• Confidential is the world’s largest home improvement specialty retailer and the second largest retailer in the United States. They sell a range of building materials, home improvement products, and lawn and garden products, as well as provide various installation services.
• The Merch BI ETL project mainly focuses on the Sales, Inventory, finance, cost and Receipt. The ultimate benefit of this project is to
• Increase sales
• Increase margin and
• Increase revenue

Confidential

Business Analyst

• Project planning, tracking and risk management
• Define architecture and high level design
• Proposed new code changes for HIPAA 5010
• Interaction with the customer and end customers
• Training and Mentoring the team members
• Analysis of Change Requests and developing Requirements specification, technical specification, test plan, test evidence, component lists and design documents e.g.) to complete this ADHOC CR’s
• Establish “Best Practices” and plan for continuous improvement of processes
• Documentation of issues

Confidential

Developer

Tools: Used Informatica PowerCenter, B2B Data Exchange, Data Transformation and HP Parser, Oracle 10.g and FTP (fileZilla and Win SCP)

• Project planning, tracking and risk management
• Define architecture and high level design
• Interaction with the customer and end customers
• Planned and assigned assignments for the team on a scheduled basis by dividing the work load to optimize code delivery effort
• Scope and requirement analysis, estimation, and planning
• Source and target data model analysis and review
• ETL Coding and Functionality Walk through/ Peer Review
• Unit testing and Defects fixing
• Preparing periodic report
• UAT Support
• Analysis of Change Requests and developing Requirements specification, technical specification, test plan, test evidence, component lists and design documents e.g.) to complete this ADHOC CR’s
• Establish “Best Practices” and plan for continuous improvement of processes
• Documentation of issues

Confidential

Developer

Tools: Used Informatica PowerCenter, Oracle PL/SQL, Toad for Oracle and FTP (fileZilla).

• Interaction with the Clients and Onsite Coordinators to get requirements
• Coordinate and Communicate with the Onsite
• Planned and assigned assignments for the team on a scheduled basis by dividing the work load to optimize code delivery effort
• Scope and requirement analysis, estimation, and planning
• Source and target data model analysis and review
• Creating Target tables and running BTEQ script to populate them.
• ETL Coding and Functionality Walk through/ Peer Review
• Unit Testing and Defect fixing
• Training and Mentoring of the team members
• Analysis of Change Requests and developing Requirements specification, technical specification, test plan, test evidence, component lists and design documents e.g.) to complete this ADHOC CR’s
• Establish “Best Practices” and plan for continuous improvement of processes
• Documentation of issues
• Preparing periodic report
• UAT Support