SUMMARY:

• 8 years’ experience in IT industry in implementation and support of Data warehouse projects. Development and support experience including:
• Excellent knowledge in data warehousing concepts and ETL framework.
• Possess knowledge on financial sector data models like BDM, IIS and Siebel marketing warehouse model.
• Worked in Waterfall and Agile methodology projects.
• Involved in all aspects of the product development lifecycle (business requirements, functional specifications, architectural specifications, development, test plans, and documentation).
• Vast experience in ETL and reporting tools like - Datastage, Informatica and OBIEE.
• Expertise in Datastage Designer and Director, Informatica mapping designer, workflow manager, workflow monitor,
• Expertise in various RDBMS like Teradata, Oracle and SQL Server.
• Worked with different source systems like Flat files, cobol files, RDBMS, Xml, Classic fed stage for power exchange Server
• Working experience in Shell scripting.
• Expertise in automating ETL jobs using Autosys and CA7 scheduling tools.
• System Analysis, documentation, creating technical and user documentation
• Leading ETL applications for Disaster recovery planning and exercise.
• Interacting with business users, business analysts, QA team and in the change Management process in SDLC process.
• Co-ordinate with vendor and BAs to support and maintenance of various applications.
• Has performed several roles like Onsite Tech Lead/Offshore lead, Sr developer and Developer.
• Managing and allocating the tasks among the team members and tracking them to closure.
• Ensures that resources assigned to the project have all the tools and information and conducting cross application KTs within teams to make sure team is up to speed.
• Facilitates project team meetings, manages agendas and meeting recaps to ensure all project tasks and goals are being accomplished as expected.
• Maintains excellent relationship with internal team members, business users, client teams, analysts and cross functional teams.
• Self-motivated and ability to work independently.
• Excellent organizational, decision-making and leadership skills.
• Excellent verbal and written communication skills.

TECHNICAL SKILLS:

ETL \RDBMS: \: Datastage 8.0/8.1/11.3, Informatica 9.1/8.6.x/\Oracle 10g, Teradata 6.2/14 and SQL server.\7.1.3.\

O/S\Languages \: Windows XP/2003 Server, LINUX and \SQL and Shell scripting\UNIX AIX.\

Tools \: Sungard OMNI, EXPAG, OBIEE, DAC, \Star Team, Autosys, CA7, TD Viewpoint, \Putty, Altova XML Spy, Sharepoint, SQl \Dveloper, Toad etc etc.

PROFESSIONAL EXPERIENCE:

Confidential

Technical Lead/Offshore Lead/Sr developer

Environment: Datastage 11.3/8.1, informatica 9.1, Teradata 14, Oracle, SQL Server, Linux and Asys

Responsibilities:

• Incident management, Problem Management, Change Management in SLA bound environment.
• Interacting with various business groups to understand their requirements and solution enhancements for existing products.
• Working on Performance tuning for long running ETLs to make sure data is available for reporting before start of business.
• Attending new work intake process and making sure all the supported applications accounted for.
• Attending design review sessions and QA assessments to make sure quality code is being delivered to production system.
• Working with Pre production teams to ensure all the test cases were covered and proper volumetric and performance analysis was done.
• Leading and planning EDM DR Exercise.
• Planning and driving new development knowledge transition to production support team.
• Driving Weekly and monthly delivery meeting with client.
• Driving break fix meeting with development, Teradata operations, QA, Autosys teams.
• Responsible for effective communication between the project team and the customer. Provide day to day direction to the project team and regular project status to the customer.
• Utilize in-depth knowledge of functional and Technical experience in Datastage, Siebel OLTP model other leading-edge products and technology in conjunction with industry and business skills to deliver solutions to customer.

Environment: Infomratica 9.1/ Datastage 11.3/8.1, Teradata 14, Oracle, Linux and Asys

Confidential

Offshore Tech Lead

Responsibilities:

• Participating in new work intake process to understand customer requirements.
• Providing estimations and cost cases to client teams and work with user community to make them understand the cost estimations and delivery timelines.
• Working with architect teams, DBAs and Developers to solution the technical design and data modeling.
• Participate in finalizing the requirement documents and technical design documents and works with onshore on project allocations and expectation setup.
• Participate in code review sessions at each checkpoint in SDLC process.
• Responsible for effective communication between the project team and the customer. Provide day to day direction to the project team and regular project status to the customer.
• Test plan preparation and to work with QA & Pre prod teams to ensure the migrations are as documented and the test cases are sufficient
• Integration testing, System testing and regression testing support.
• Performance tuning for rogue ETLs.
• Attending the code defects efficiently and provides timely solutions to the defects.
• Working with test data management teams to ensure sufficient data volumes are provided and thus testing the performance of the ETL processes.
• Making sure that the development is as per the etl best practices and naming conventions.
• Establish Quality Procedure for the team and continuously monitor and audit to ensure team meets quality goals.
• Conducting production release review meetings.
• Maintaining knowledge repository of all the documentation and making sure that they are part of new resource on boarding process.
• Running weekly and monthly delivery status meeting with client management.
• Reviewing production support documentation like run books, DOC ITS, traceability matrix and providing knowledge transfer to the support team.
• Provide warranty support until the product is stable. Break fix support if anything breaks in production.
• Working with production teams on critical/escalated issues to make sure business is well supported.

Confidential

Sr.Developer

Responsibilities:

• Work with Business Analyst in translating business requirements into Functional Requirements Document and to Technical Design Documents.
• Providing work estimations for new work intake requests.
• Utilize in-depth knowledge of functional and Technical experience in Informatica, Datastage, Siebel OLTP model other leading-edge products and technology in conjunction with industry and business skills to deliver solutions to customer.
• ETL solution overview documentation and test plan preparation.
• Develop mappings in Informatica to load the data from various sources into the Data Warehouse, using different transformations like Source Qualifier, Sorter, Expression, Lookup, unconnected Lookup, aggregate, Update Strategy, sequence generator, Joiner.
• Conducting Design review sessions with Database engineering, BAs, Prod support team and incorporating the changes.
• Unit testing and reviewing the test case results.
• Integration testing and IT environment maintenance.
• Supporting System testing and provide timely solutions to the defects raised by Quality assurance teams.
• Shell scripting, Autosys JIL and version control maintenance.
• Performance tuning of the long running ETL jobs.
• Taking care of migration documentation preparation and change management procedures.
• Preparing Production transition documentation such as Run book, DOC IT, traceability, environment matrix and
• Knowledge transfer to production support staff and providing warranty support until the new developments are stable.
• Running technical checkout and business user checkout meetings.

Environment: Informatica 9.1/8.6.1, Datastage 11.3/8.1, Teradata 14, Oracle, SQL Server, Linux and Asys

Confidential

Developer

Responsibilities:

• Work with Business Analyst in translating business requirements into Functional Requirements Document and to Technical Design Documents.
• ETL solution overview documentation and test plan preparation.
• Develop mappings in Informatica to load the data from various sources into the Data Warehouse, using different transformations like Source Qualifier, Sorter, Expression, Lookup, unconnected Lookup, aggregate, Update Strategy, sequence generator, Joiner.
• Load the data using Informatica to the staging area and load to target schema, create hierarchy builds
• Unit testing and test case preparation. Defect support and UAT support.
• Preparing JCLs and shell scripts for scheduling and file transfer/manipulation requirements.
• Performance tuning and data lineage analysis.
• Weekly status reporting to leadership team.
• Production documentation preparation.
• Knowledge transfer to production support staff.

Environment: Datastage 8.1, Oracle, UNIX AIX and Control-m

Confidential

 Developer

Responsibilities:

• Understand low level design documentation and prepare ETL mappings based on that.
• Interact with business team to convert the use cases to technical solutions.
• Design Mappings, which populate the Data into Target Star Schema on oracle.
• Optimize Query Performance, Session Performance and Reliability.
• Test case preparation and unit test execution.
• Defect support during UAT.
• Warranty support for 4 weeks.

Environment: Datastage 8.0, Oracle, Flat files, QC Explorer and UNIX