SUMMARY:

• Over 8 years of experience in software development, designing and implementation, System architecture, Project Management and acting as a key collaborator between/across work streams, to ensure consistency in approach, assumptions and objectives.
• 4+ years of experience in requirement specification gathering, analysis, design, development, testing, debugging and maintenance in Informatica Power Center 8.6.1, UNIX, DB2.
• 4 years of experience in mainframe Z - OS based systems using COBOL, JCL, Easytrieve, IMS DB/DC, VSAM and Change man.
• Managed Projects and led teams at offshore and at the client location and have delivered excellent results based on the client needs.
• Developed heavily parallel CPU bound ETL process jobs using Informatica in dynamic, continuous and high-volume environment.
• Coded well-tuned, modular SQL and UNIX Shell scripts for high volume data warehouse instances.
• Hands on experience in end-to-end Data warehousing routines, which includes writing custom scripts and following standard testing life cycle procedures.
• Extensive knowledge in managing cross-functional issues based on experience and lessons learned from previous projects; address issues and manage the day-to-day resolution process for production and other issues.
• Participated in all aspects of software development life cycle (Waterfall Model & Agile) and have the ability to work successfully as part of small to medium sized team or independently and in an onsite-offshore model.
• Excellent Exposure to Banking - Customer Information Systems and Mergers & Aquisitions.
• Highly motivated team player with excellent analytical & problem solving skills possessing ability to effectively communicate with higher management and stake holders.

TECHNICAL SKILLS:

Programming Languages: Informatica Power Center 8.6.1, Unix Shell Scripting, COBOLEasytrieve, JCL.

OS: UNIX, Z-OS, OS-390.

Online Interfaces: CICSDATABASES: DB2

Tools: PACBASE, Elips, Changeman, SARS reporting, Expediter, Zeke.

PROFESSIONAL EXPERIENCE

System & Data Architect

Confidential, Chicago, IL

Responsibilities:

• Involved in discussions with other SMEs (Subject Matter Experts), in designing and architecting the new system with DB2 as the target database.
• Architected the data migration process and played a major role in designing the End to End batch process flow.
• Involved in Reverse Engineering to obtain requirements from the Legacy systems and enabled Development providing estimates and by approving and signing of the Design and Code after a thorough review.
• Lead and managed a team of 14 resources and guided the team to complete tasks as per the client requirements.
• Involved in creating the initial setup of the project with Common Project Creation, providing necessary technical assistance to other developers, re-writing/upgrading the existing ETL processes with new releases.
• Involved in Design/Development/Tuning/Testing modular Informatica mapping for Extract, Transform and Load process in high volume environment.
• Developed various, optimal and generic, Informatica mapping to extract, transform and load data from external vendors and multiple sources; which run on a daily basis loading deltas and as well as complete refresh.
• Extensively used the Informatica transformations like Sorter, Aggregator, Normalizer, Ranker, Joiner, Look-up, update strategy, etc. Used Informatica features like Debugger, Versioning mapplets and Pushdown optimization to enhance performance.
• Took the mentor role for the new joiners in the project and helped them in induction and orientation by conducting KT sessions.

Technical Project lead, Subject Matter Expert.

Confidential, Columbus Ohio

Responsibilities:

• Worked closely with Business team to gather requirements and create mapping documents between the source and the target system.
• Arranged for detailed discussion meetings with Business Analysts and Subject Matter Experts to identify, discuss and resolve issues with the conversion process and to gradually create the high level architecture and design.
• Architected the Conversion process and designed the End to End batch process flow once the data model was finalized by the data modeling team.
• Enabled Development providing estimates and by approving and signing of the Design and Code after a thorough review.
• Involved in Fine tuning the Batch process by making use of the right components at the right places, Fine tuning SQL Queries and making use of the Pushdown optimization in Informatica.
• Developed various, optimal and generic, Informatica mapping to extract, transform and load data from external vendors and multiple sources; which run on a daily basis loading deltas and as well as complete refresh.
• Extensively used the Informatica components like Sorter, Aggregator, Normalizer, Ranker, Joiner, Look-up, update strategy, etc. Used Informatica features like Debugger, Versioning and Pushdown optimization to enhance performance.
• Change management standards, Issue resolution process, Database change requests were strictly followed during various phases of environment i.e. development, testing and production environments.

Sr. Informatica Developer, Subject Matter Expert

Confidential

Responsibilities:

• Planned and provided project cost and the time estimates for the end to end Project completion.
• Designed, developed and tested the efficiency of using Informatica in the then existing Legacy environment.
• Lead and managed a team of 3 resources and guided the team to complete tasks as per the client requirements

Informatica Developer

Confidential

Responsibilities:

• Involved in business requirements discussions with the end-users and onsite associates.
• Involved in the high level data movement design and detail level data movement design and analyzing source-to-target mapping rules.
• Developed several Informatica mapping for extracting, transforming, cleansing and loading the various Data warehouse tables based on the business requirements.
• Extensively used Sorter, Aggregator, Normalizer, Ranker, Joiner, Look-up, update strategy, etc. Used Informatica features like Debugger, Versioning and Pushdown optimization to enhance performance.
• Worked on improving the performance of Informatica mapping by using Various Informatica performance technique's like using Pushdown optimization etc.
• Used Parameters/variables in the Informatica mapping, which comprises of specific locations of the files to be used as source and target.
• Creating Sessions, reusable Worklets and Batches in Workflow Manager and Scheduled the batches and sessions at specified frequency.
• Used Debugger wizard to remove bottlenecks at source level, transformation level, and target level for the optimum usage of sources, transformations and target loads.
• Captured data error records corrected and loaded into target system.
• Implemented efficient and effective performance tuning procedures.

Mainframe COBOL Developer

Confidential, Columbus Ohio

Responsibilities:

• Responsible for attending all project meetings, environment setup based of application requirements.
• Providing requirements analysis, support for testing, coordination of deployment process, analysis of defects and modifications to existing applications.
• Providing timely and accurate documentation.
• Responsible for data gathering, writing queries and running reports for supervisor or others in the department.

Confidential

Responsibilities:

• Responsible for attending all project meetings, environment setup based off of application requirements.
• Providing requirements analysis, support for testing, coordination of deployment process, analysis of defects and modifications to existing applications.
• Providing timely and accurate documentation.
• Responsible for data gathering, writing queries and running reports for supervisor or others in the department.