PROFESSIONAL SUMMARY:

• 10 years of total IT experience with vast exposure in Data warehousing technology, ETL Design and Development, Quality Assurance and Application Value Management.
• Major domain experience areas: Health care, Media and Entertainment, Retail and Telecom and Pharmaceutical
• Expertise on tools like Informatica 9.x, Toad for Oracle SQL, SQL Assistant for Teradata, HIVE and HBASE for Hadoop, Putty Vi Editor Commands, WINSCP and COREFTP, HPQC and also Job scheduler Control - M.
• Very good experience on End-To-End Planning, Estimates, Architecture/Design and Development phases of SDLC.
• Extensively worked on databases like Oracle, Teradata and SQL. Written complex queries to achieve and implement business logics.
• Experience in tuning existing complex queries contributing to performance improvement activity.
• Strong experience in Project Requirement Gathering - having vast exposure on both Waterfall Model (around 4 years) and also on agile methodology (2 years).
• Extensively involved in Data Analysis, ETL Solution Designing and perform unit testing. My ETL Solutions involved exploring the capabilities of Informatica Tool like:
• XML - reading XML sources as source level objects (both normalized and de-normalized), also worked on XML mid-stream operator (XML Parser) to parse the XML data and finally have experience on XML targets/generators as well.
• Worked on Power Exchange CDC to implement Near Real Time capabilities.
• Have exposure working on LDAP processing the Employee ID and managing them in a secured environment.
• Stepping into many roles during Project Build Phase:
• ETL Technical Team Lead, Project Module Lead
• Business Analyst, ETL Designer, ETL Developer,
• Quality Defect Analyst
• Expertise in leading teams and delivering the milestones as per schedules.
• Excellent communication skills in handling with all the stake holders and clients by properly articulating and presenting the problem/solution options available.
• Have strong delivery lead skills and a good team player, problem solver and quick learner. Have strong analytical skills with proficiency in debugging, problem solving.

TECHNICAL SKILLS:

DBMS/RDBMS: Oracle 11g/10g/9i, Teradata and DB2

ETL Tools: Informatica, HIVE, Talend.

Scheduling Tool: Control M

XML Technologies: XML, XSD, SOAP and WSDL

Source/Target Types Handled: Database Tables, Flat Files, Fixed Width Files, XMLs, XSDs, CDC, SFTP, CSV Files, Web Services, Queues and Topics, LDAP and many more.

Defect/Bug Tracking: HPQC, JIRA

Other tools: RSA, Putty, WinSCP, FileZilla, Soap UI, MS Visio, Great BI

O/S & Environment: Windows XP, UNIX, Linux

PROFESSIONAL EXPERIENCE:

Business Analyst

Confidential

Responsibilities:

• I have effectively worked on various project phases in both Fixed Bid and Embedded types of projects. Most of my IT industry projects followed Waterfall Model and have good experience and hold on the SDLC.
• Driven the projects end-to-end flowing through all the phases technically and also with good management skills.
• Extensively worked on Sprints spread across many Iterations in Agile Project (T Mobile and Confidential & Confidential in CapGemini). Used JIRA tool and Rally to break the activities into small work packages to facilitate task delegation to the team members.
• Effectively monitored the tasks that were carry forwarded from previous sprints to further until its completion. Ensured the story points in the JIRA tasks and Rally Tasks are in sync with the summarized effort numbers.
• Weekly monitored and generated reports out of the tasks completed and reviewed it with the management for feedbacks and comments.
• Involved in driving initial meetings and discussions in order to understand the basic needs/objectives of the project. Scheduled meetings with Stakeholders, Clients, End Users, Customers, and Business Analysts etc to gather requirements.
• I have hosted war room sessions to discuss, identify and decide the roles and responsibilities of each stakeholders. Also to timely follow-up for the action items and have them tracked effectively until completion.
• Identified the team or people behind the information sources and to consolidate all the project requirements. I have identified the potential assumptions and have them verified against each requirement KPIs.
• Categorized as Technical and Business requirements, noted them and analyzed in terms of requirement gathering. First step I have gathered the Business needs of the Project, Reason behind the project, and Main objective of the project.
• To relate and connect the Business needs to the technical aspects available to our capabilities. Initiated and conducted technical POCs related to the decisions made during the meetings and provide supporting documents for review. Submit various proposals based on the prior experiences considering the cost and efforts involved.
• To make sure we have all the necessary inputs for our Ball Park estimations supporting effort figures closely to the actuals. Ensure there are no blockages or any technical hick-ups related to configurations and accesses/licenses.
• Maintain and manage all the project related documents in the SharePoint and have them officially approved initiating an approval through SharePoint workflow. Walk through the BRD document back to the Clients or with the Authors to ensure and confirm our understandings are as per their expectations. I have identified the risks and also have them noted with mitigations to be further agreed and signed by Stakeholders.
• To review and to work on the peer comments to have discussions finalizing the ETL Solution (both technical and business related). Proactively ensure if there are any data volumetric challenges and consider them as an input to the design phase.
• Addressed various kind of issues during data analysis phase - Integrity Issues, Data Issues, Process Improvements, Access Issues, and Data Security Issues etc. To note down all the risk factors along with their mitigations and have them validated in advance.
• Collate and integrate the ETL Solution proposed and have them reviewed and approved by the management and architects. Ensure we have all the necessary details and points in BRD Document and have it reviewed. Also to conduct POC (Proof of Concept) for any kind new technical approach or solutions provided.
• To check the new capabilities of a Tool or an Application in order to have it used during the requirement implementation (Build Phase). Prior concluding on a particular technical approach, ensure that we have put all necessary efforts in exploring all possible options available. To document the need and the reason behind the architectural decisions made and also to support the design proposals.

Technical Team Lead

Confidential

Responsibilities:

• Building HLD document having reference to many other supporting documents. To come up with the list of all the object inventories that would be used in the Project Build Phase. Include the assumptions made during the requirement phase and provide more details over it.
• Creating LLD or SSD documents considering the available information and approved documents. Provide a complete and detailed column to column mapping business logic along with pictorial representation for ease of build to the developers.
• Provide all necessary KT to the peers and to the team to kick start the development phase. Ensure we have the right and correct Object Inventory prior the development phase.
• Draw process improvement plans and have them followed during all the project phases. To provide and conduct necessary trainings and KT sessions to the team mates and junior resources on new capabilities.
• Conducted constant meetings and discussions with the Client to report and resolve the issues during Build Phase. To implement the best practices like reusability, ETL standard adherence, Peer Review, Code Migration Checklist etc.
• Include and involve testing teams during various project phases facilitating them for test case preparations. Exclusive data mocking to test and check the Ideal Case Scenarios.
• To perform negative testing and include them as part of the regular test cases.
• System configuration related best practices implementation like parameterization and comments addition etc. Timely monitor the progress of the project tasks and regular task health check and progress reports.
• Ensure we follow all the standards in terms of process in order to avoid configuration related defects (Example: To follow Code Checklist). Timely demonstrate the deliverables to the client or stakeholders in order to check if the approach followed is as per their expectations.
• Having all the Project related documents saved in the SharePoint for reference.
• Manage Technical Project Documents as assets enabling the industrialization implementation. These will or may be used for similar upcoming projects as valuable inputs.
• Cross training resources to improve them technically and also to obtain complete resource utilization. Ensure to document the 'Lessons Learnt' during the project tenure and have the document reserved as the Organization Asset for further reference.

Confidential

ETL Lead

Environment: Informatica, Oracle

Responsibilities:

• Requirements Gathering & Understanding. Experience in creating High Level Design Document, Low Level Design document.
• Validation of Reports against data in the tables. Defect Tracking & Code Drop.
• Conducted functional testing and regression testing
• Onsite/Offshore/Client Co-ordination
• Interaction with Client, Developers, Onsite Coordinator
• As a lead responsible for developing and guiding the team for ETL mappings towards data load using ETL tool Informatica Power Center
• Extensively used Informatica Client Tools: Source Analyzer, Warehouse Designer, Transformation Developer, Mapping Designer and Mapplet Designer to develop mappings.
• Developed Informatica workflows and sessions associated with the mappings using Workflow Manager.
• Extensively involved in the Design and development of ETL Process flow.
• UAT support
• Working as an Onsite coordinator to coordinate with onsite and offshore team members to assign and to finish the task as per the schedule dates.
• Updating and tracking sprint activities in Version One tool for scrum management.
• Providing projects status on daily basis, Weekly on status calls to Delivery Managers
• Prepare the lesson learned documents based on the previous defects

Confidential

ETL Lead

Environment: Informatica, Oracle

Responsibilities:

• Priority call queuing
• Priority call routing to top agents
• Priority trouble appointment scheduling
• Routing trouble calls to top field technicians
• Priority go backs.
• Customer identification as “targeted” with a long term goal of segmenting “targeted” customers in several groups with each group receiving all or some of the treatments.
• Offering “targeted” customer’s priority time slots during trouble ticket appointment scheduling.
• Building order entry controls that will provide the guardrails needed to insure accurate order entry for trouble call related tickets of “targeted” customers.
• Requirements Gathering & Understanding
• Experience in creating High Level Design Document, Low Level Design document.
• Validation of Reports against data in the tables.
• Defect Tracking & Code Drop.
• Conducted functional testing and regression testing
• Onsite/Offshore/Client Co-ordination
• Interaction with Client, Developers, Onsite Coordinator
• As a lead responsible for developing and guiding the team for ETL mappings towards data load using ETL tool Informatica Power Center 9.0.1
• Extensively used Informatica Client Tools: Source Analyzer, Warehouse Designer, Transformation Developer, Mapping Designer and Mapplet Designer to develop mappings.
• Developed Informatica workflows and sessions associated with the mappings using Workflow Manager.
• Extensively involved in the Design and development of ETL Process flow.
• UAT support
• Working as an Onsite coordinator to coordinate with onsite and offshore team members to assign and to finish the task as per the schedule dates.
• Updating and tracking sprint activities in Version One tool for scrum management.
• Providing projects status on daily basis, Weekly on status calls to Delivery Managers
• Prepare the lesson learned documents based on the previous defects

Confidential

ETL Lead

Environment: Informatica, Teradata, Hadoop

Responsibilities:

• Requirements Gathering & Understanding
• Experience in creating High Level Design Document, Low Level Design document.
• Validation of Reports against data in the tables.
• Validation of Prep Dispatch and Warehouse tables
• Defect Tracking & Code Drop.
• Conducted functional testing and regression testing
• Onsite/Offshore/Client Co-ordination
• Interaction with Client, Developers, Onsite Coordinator
• As a lead responsible for developing and guiding the team for ETL mappings towards data load using ETL tool Informatica Power Center 9.0.1
• Extensively used Informatica Client Tools: Source Analyzer, Warehouse De-signer, Transformation Developer, Mapping Designer and Mapplet Designer to develop mappings.
• Developed Informatica workflows and sessions associated with the mappings using Workflow Manager.
• Extensively involved in the Design and development of ETL Process flow.
• UAT support
• Working as an Onsite coordinator to coordinate with onsite and offshore team members to assign and to finish the task as per the schedule dates.
• Updating and tracking sprint activities in Version One tool for scrum management.
• Providing projects status on daily basis, Weekly on status calls to Delivery Managers
• Prepare the lesson learned documents based on the previous defects

Confidential

ETL Lead

Environment: Informatica, Teradata and Oracle

Responsibilities:

• Requirements Gathering & Understanding
• Delivering CSR RR intake items, Work logs for various Development and Enhancement releases.
• Development and Enhancement of Informatica mapping and B-teq scripts.
• Analysis, Planning, work distribution for the team.
• Maintaining and updating Application Knowledge Document, Knowledge Transition Plan during Initial phase of project.
• Building team, maintaining resources for the CSR project at Offshore.
• Responsible for Production failure resolution, Process and application level analysis, back tracking of data issues.
• Assisted team members by providing process, application and technical guidelines.
• Responsible for fixing Audit balancing control data issues which caused the data issues. Interaction with Client, Developers, Onsite Coordinator
• UAT support

Confidential

ETL Lead

Environment: Informatica, Teradata and Oracle

Responsibilities:

• Understand requirements associated with the application & Data Warehouse
• Determine Data Warehouse based on requirements & use cases for the application
• Work with the integration solution architects & designers to design the integration solution
• Ensure that the database designs fulfill the requirements, including data volume, frequency needs, and long-term data growth
• Review the database deliverables throughout development to ensure quality & tractability to requirements and adherence to all quality management plans & standards
• Development of new Informatica mappings and workflows
• Enhancements to the existing Informatica mappings
• Development of shell scripts
• Development of PL/SQL procedures
• Analysis and troubleshooting L3 issues
• Optimization of the code to speed up execution and completion of the loads
• Assisting fellow team members in their technical deliverables

Confidential

ETL Lead

Environment: Oracle, Informatica

Responsibilities:

• Understand requirements associated with the application & Data Warehouse
• Analysis of source files (XMLs) and developing the different hierarchies.
• Analysis of different source systems like DSET, Lasso and Phone home and prepared the mappings to load in to their respective targets.
• Determine Data Warehouse based on requirements & use cases for the Application
• Comparing XML data against XSD schema and validating them by using stored procedure
• Work with the integration solution architects & designers to design the integration solution
• Ensure that the database designs fulfill the requirements, including data volume, frequency needs, and long-term data growth
• Review the database deliverables throughout development to ensure quality & tractability to requirements and adherence to all quality management plans & standards

Confidential

ETL Lead

Environment: Oracle, Informatica

Responsibilities:

• Understanding the requirements associated with the application.
• Involved in migrating the data from landing to target.
• Involved in writing the stored procedures and packages for data migration.
• Analyzing the data and table structure, Creating a scripts for data migration from landing to staging.
• Involved in verifying the migrated data in Metasolv
• Involved in migrating different entities(Locations, Equipment, Circuits, De-sign Lines etc..) from landing to target
• Review the database deliverables throughout migration to ensure quality & tractability to requirements and adherence to all quality management plans & standards

Confidential

ETL Lead

Environment: Informatica, Oracle

Responsibilities:

• Understanding the requirements associated with the application & Data Warehouse and analyzing the same for providing complexity and estimation.
• As a lead responsible for developing and guiding the team for ETL mappings towards data load using ETL tool Informatica Power Center 9.0.1
• Extensively used Informatica Client Tools: Source Analyzer, Warehouse De-signer, Transformation Developer, Mapping Designer and Mapplet Designer to develop mappings.
• Developed Informatica workflows and sessions associated with the mappings using Workflow Manager.
• Extensively involved in the Design and development of ETL Process flow.
• Deployed the mapping to create the parameter files for each run.
• Created the shell scripts to update the files. Using that file loaded the data by chunks.
• As a lead, I managed successfully a team of two developers