CAREER PROFILE:

• About 9 years of total IT Experience with more than 7 years as ETL Developer/Lead and more than 2 years as UAM Administrator and competent in VB Script, Power Shell, MS - DOS, Oracle (11g/10g, PL/SQL)
• Sound experience on Point of Sales data and analytics
• Expertised on ETL tool ‘Informatica Power Center - 9.x,10.x’
• Expertised on Retail ETL & Analytic tool ‘Retail Velocity.’
• Proficient in Data Analytics with - Data Mapping, Cleansing, Transformations, Data Exports & Imports, Application Support, Creation of ETL specs, mapping & analysis.
• ETL Tuning based on Push Down Optimization, Partitioning, memory allocation etc.
• Strong experience with Data Warehousing concepts and standards
• Strong in Report generation, validation, analysis and maintenance.
• Good hands-on knowledge in various analytic file used like EDI-852, EDIFACT, AS2, JSON, XML etc.
• Proven in Project Management and Team Management areas.
• Savvy in Oracle Database (SQL, PL/SQL) with Stored Procedures, Tuning, Functions, Cursors, Triggers, Indexes, Views, Export/Import Utilities.
• Worked on multiple database environment like Oracle, SQL, DB2, MySQL, Teradata
• Written technical design documentation like data flow diagrams, mapping documents, etc. for application maintenance.
• Highly skilled in analyzing business requirements and converting business requirement into code.
• Extensive knowledge of creating Business Requirement and Technical Document.
• Seasoned in all phases of Software Development Life Cycle (SDLC) such as developing, testing, Migrating, Administrating and production support.
• Experienced in VB.net in developing / maintaining desktop applications.
• Excellent communication and interpersonal skills with ability to work effectively as a team and in individual ownerships.
• Worked in an Agile environment.

TECHNICAL SKILLS:

Data Base: Oracle 12c/11g/10g, SQL Server 2008 R2, Teradata, MS-Access

Programming Languages/Scripts: PL/SQL, HTML, VB .net, Power Shell, core JAVA, Excel Macros

Front End Tools: SQL Developer, SQL Navigator, Host Explorer, IBM I- Series, DB2 Connect, Toad, Putty, WinSCP

ETL Tools: Informatica Power center 9.5,10.1, Retail Velocity

Scheduling Tools: Autosys, Windows Scheduler, Informatica Scheduler, EPO

Testing Tools: Jira, Panaya

Ticketing Tools: CA Unicenter, HP - ALM

Other Utilities: MS-Office (Word / Excel / PowerPoint), MS Access

Operating systems: Windows 2000/NT/7/10,Linux and MS-DOS

PROFESSIONAL EXPERIENCE:

Confidential, Plano, TX

Responsibilities:

• Informatica map design, creation and testing using Power Center.
• Working on various architect & design levels of projects, data flow, tuning, load balancing etc
• Integrating existing system with new RMS system.
• Back feeding the data using Informatica Power Center and other necessary tools to POM.
• Staging data, doing necessary transformation and supplying the data to Supply Chain.
• Fetching and moving data from heterogeneous environment like Mainframe, Oracle, DB2 etc to Target environment.
• Working on defects, bugs, change requests, Interface Implementation
• Creating Technical Design Document, Unit Test Results, Release notes, Review status and other Project related documents. Versioning using SVN.
• Setting up team meetings, huddle calls etc

Environment: Oracle 11g PL/SQL, SQL Developer, Informatica Power Center, DB2 Connect, Host Explorer, Power Exchange, Toad, Putty, Winscp

Tools: Informatica Power Center 9.x, Velocity, SQL, Oracle, ETL tools

Confidential, Winston Salem, NC

ETL team lead

Responsibilities:

• Informatica map design, creation and testing using Power Center.
• Dimensional modelling - Star Schema, Snow Flake, Galaxy Schemas.
• Working on SCD 1, 2, 3 models.
• Dealing with heterogeneous source data. (Flat files, Oracle, SQL, DB2, XML etc.)
• Investigation of root cause and coordination during project issues.
• Design and ETL spec creation for new requirements.
• Data Validation and Analysis.
• Design, coding, unit testing of ETL packages, triggers, and stored procedures, views, SQL transactions
• ETL Tuning
• User Acceptance Testing
• Support and maintenance of different applications.
• Ensuring process compliance and identifying process improvements.
• Maintenance of POS applications
• Work on new project assignments
• Setting up team, sprint meetings, huddle calls etc

Environment: Oracle 11g PL/SQL, SQL Developer, Informatica Power Center, DB2 Connect, IBM ISeries, MS-Access, MS-Excel, Power Shell, MS DOS, Windows 7/ Server environment

Tools: Informatica Power Center 9.x, Toad, SQL Developer, SQL, Oracle, ETL tools, DB2 Connect, IBM I series navigator

Confidential, Winston Salem, NC

Responsibilities:

• Understanding the data model
• Developing Conceptual, Logical and Physical Data Models after analyzing the relationship between these entities
• Using different tools like DB2 connect, IBM I series navigator to create connection between different databases and create connection in Informatica connection manager.
• Developed Informatica Workflows to source data from heterogeneous databases including DB2, AS400, Oracle, SQl etc. to stage tables in the application.
• Created Tables, Indexes, View, Triggers and other required entities for proper data flow.
• Improved performance of Informatica workflows by implementing pipeline partitioning for parallel data processing.
• Exported Informatica workflows into XML file to facilitate migration to multiple environments.
• Developed Shell /batch scripts for implementing controls and another file processing.
• Scheduled the various processes in the application using Autosys scheduling tool by determining the dependencies and SLAs.
• Prepared Low Level Design (LLD) Documents
• Prepared Unit test cases and test scripts for code validation.
• Prepared Detailed Task Schedule (DTS) document which is a detailed document that shows the schedule to be followed by the various teams involved in production deployment as well as the various deployment activities.
• Performed Unit testing and supported User Acceptance Testing.
• Involved in Deployment and Release Management Activities.

Environment: Oracle 11g PL/SQL, SQL Developer, Informatica Power Center, DB2 Connect, IBM ISeries, MS-Access, MS-Excel, Power Shell, MS DOS, Windows 7/ Server environment

Tools: Informatica Power Center 8.5x, 9.5x

Confidential, Winston Salem, NC

Responsibilities:

• Helping admin in installing new Informatica server, repository and integration services in new repository.
• Assigning new Gateway and worker nodes.
• Creating grid system.
• Migrating existing mappings/source/target/session workflow etc. from existing repositories into xml and importing it in new environment.
• Test running and checking the existing workflows.
• Modifying & developing the maps/workflows having the compatibility issues.
• Switching the integration service and test running through Autosys.
• Decommissioning and switching to new environment
• Supporting and working production issues.

Environment: Oracle 11g PL/SQL, SQL Developer, Informatica Power Center, Retail Velocity, MS-Access, MS-Excel, Power Shell, MS DOS, Windows 7/ Server environment

Tools: Informatica Power Center 8.5x, SQL, Oracle, ETL tools

Confidential, Winston Salem, NC

Responsibilities:

• Developed Informatica Workflows for sourcing data from various sources to stage tables.
• Processed data using various Informatica Transformations (Source Qualifier, Joiner, Lookup, Filter, Router, Aggregator, Expression, Union, Update Strategy, Sorter, rank etc.) and loaded target tables as well as created files.
• Developed mapping parameters and variables to support SQL override.
• Created mapplets and used them in different mappings.
• Developed mappings to load into staging tables and then to Dimensions and Facts.
• Worked on different tasks in Workflows like sessions, e-mail, command, worklets.
• Scheduled Jobs in Autosys
• Prepared Unit Test Plan and Unit Test Cases for validating the code modules.
• Validated migrated components, provided deployment support and monitored jobs during production deployment.

Environment: Oracle 11g PL/SQL, SQL Developer, Informatica Power Center, Retail Velocity, MS-Access, MS-Excel, Power Shell, MS DOS, Windows 7/ Server environment

Platform: Windows, UNIX, AS400, SQL, Oracle, ETL tools

Confidential

Responsibilities:

• Performing the role of Team Lead for a team of 5 members.
• Tracking project metrics & KPIs
• Data Validation and Analysis
• Ensuring process compliance and identifying process improvements
• Validate the user details and provide access to users of the company to their respective domains.
• Providing users with new ids and grant access to various groups upon confirmation, on all three platforms (Windows, UNIX and AS400).
• Supporting customer audits and interfacing with customer at all levels as per the requirement.
• Usage of tools like HP-PPM, Zapper, SPS, TMS etc. to maintain the record and provide access to specific applications.
• Working as a central team while handling all users’ queries regarding company access.
• Ticket handling for all sorts of priorities and severities.
• Drafting and sending of Weekly Status Reports and other Client Deliverables.
• Executing user acceptance testing based upon the client demand.
• Creation and maintenance of Project Documents and other Metrics
• Clarifying/raising queries for technical questions from the team.
• On boarding new team members and mentoring them.
• Providing support to management activities which includes task allocation, project workload data analysis, timesheet data analysis, employee billing and invoicing.
• Organizing team building and other initiatives.
• Sticking to best practices and quality deliverables
• Activities for Team building/motivation.
• Technical s to the new members to the project.
• Owning and delegating tasks among the team after planning and prioritization of all the test-related tasks.
• Taking proactive measures during unplanned lags in project, which enabled the team to deliver the required artifacts within timeline.