SUMMARY

• Having more than 9 years of IT experience in Healthcare and Banking domains with Ab Initio, designing and building Data warehouses using ETL technologies.
• Experienced in interacting with business analysts. IT leads and developers in analyzing business requirements and translating requirements into functional and technical design specifications.
• Experienced in all phases of SDLC (Analysis, Design, Development, Testing and Deployment).
• Good understanding of Ab Initio XML functions and shell scripting.
• Have clear understanding of Business Intelligence and Data Warehousing Concepts with emphasis on ETL Life Cycle Development.
• Involved in ETL Architecture and Ab Initio Data Modeling and EME repository management.
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate - wide-ETL Solution using Ab Initio.
• Expertise in new development as well as support, maintenance or enhancement of existing applications.
• Hands on experience in analysis, architecture and Ab Initio Administration, including documentation and deployment and testing.
• Expertise in Ab Initio including developing graphs using mfs/conditional dmls.
• Expertise with all the components in the GDE in Ab Initio developing, executing, testing and maintaining the graphs in Ab Initio.
• Experience in working with UNIX.
• Expertise in doing Unit Testing, Integration Testing, System Testing and Data Validation.
• Experience in working with Oracle using SQL.
• Well experienced in doing Error Handling and Troubleshooting using various log files.
• Team player and self-starter, capable of working independently and motivate a team of professional.
• Good understanding of business processes in industry and ability to analyze the process and map it to the requirements and software packages available.
• Ability to understand long-term project development issues at all levels, from interpersonal relationships to the details of coding scripts with strong analytical, organizational, presentation and problem solving skills.

TECHNICAL SKILLS

Data Warehousing Tools: Ab initio 1.13,1.15, 3.0, ACE/BRE

Databases: Oracle,DB2,Netezza,Microsoft SQL Server

Repository: Enterprise meta environment (EME) data storage system

Operating Systems: Unix and Windows 2000/XP

Oracle tools: SQL Developer

Testing tools: Manual Testing

Programming Languages: C, C++,Java

Scheduling Tools: Control-M, Tidal,Autosys

Other Tools: Winscp, Filezilla, Putty, Quality Center, Citrix

PROFESSIONAL EXPERIENCE

Confidential

Ab Initio Consultant

Environment: Ab Initio, ACE/BRE, UNIX, Oracle, Netezza, VMware, Java, Filezilla, Microsoft SQL Server

Responsibilities:

• Writing high level data mapping requirement specifications according to standard templates, using natural language simply, clearly, unambiguously, and concisely.
• Decomposing high-level business and user requirements into high level and detail level design documents, specified in an appropriate level of detail suitable for developer to build the code.
• Leading data requirements analysis and verification, ensuring concise, comprehensible, traceable, feasible, unambiguous, and verifiable data mapping and modeling documents that they confirm to standards.
• Performed data and quality analysis including data mapping reviews, data validation and remediation, alert validation and issue impact analysis
• Source new data feeds and map them into existing infrastructure and platforms.
• Write use cases, perform system testing and assist business users in testing. Work closely with QA on establishing test plans and execute test cases.
• Responsible for creating data flow diagrams, updating the project plan, writing use cases.
• Responsible for reviewing the HLD, DLD design documents, test plan and scripts and approve them.
• Have a strong understanding of the project.
• Developed ETL graphs with Ab Initio tool and mappings using ACE/BRE.
• Closely involved in production implementation and check outs.

Confidential, Salt lake city

Ab Initio Consultant

Environment: Ab Initio 1.13, UNIX, DB2, Quality Center

Responsibilities:

• Complete responsibility of design and implementation of SCM Project as per the requirements.
• Coordinate and Support development teams for all ETL related issues.
• Administration responsibilities included creating database connection, cleaning log files, repository backups, domain backups, creating folders, users.
• Identified the roles and created Administrator, Developer, Production Support groups.
• Responsible for creating users and assigning respective groups to the users using scripts (Used command line utility).
• Worked closely with ETL developers, project managers, and database administrators.
• Used command line to create folders, users, export folders and also create backups.
• Worked extensively in tuning the current ETL processes for better performance by implementing database partitioning and increasing block size, data cache size, sequence buffer length and target based commit interval and SQL overrides.
• Developed graphs using Ab Initio tool.
• Issues Resolution and Troubleshooting.
• New Features training to developers of various projects.
• Experienced in working with Ab Initio technical support on all Service requests.
• Worked on testing the ETL objects.
• Worked with Production support team in resolving operational issues.

Confidential

AbInitio Developer

Environment: Ab Initio 1.15, UNIX, Oracle, Citrix

Responsibilities:

• The project involved extracting data from various sources, transforming the data from these files before loading the data into target (warehouse) Oracle tables.
• Profiled the various source systems and came up with a detailed source-to-target mapping document that served as the blueprint for ETL work.
• Created mappings using transformations.
• Worked closely with the project team to formulate and implement a flexible system design that meets functional requirements.
• Designed and developed mapping, transformation logic and processes in Ab Initio for implementing business rules and standardization of source data from multiple systems into the data warehouse.
• Responsible for developing, support and maintenance for the ETL processes using Ab Initio
• Used the concept of vectors in development of graphs.
• Generated DB configuration files for source tables using dbconfig and modified them according to the requirements.

Confidential

Ab Initio Developer

Environment: Ab Initio 1.13, UNIX, Oracle

Responsibilities:

• Attended multiple meetings and played a key role to provide input and answer feasibility questions during requirements gatherings and development periods.
• The project involved extracting data from various sources, transforming the data from these files before loading the data into target (warehouse) Oracle tables.
• Designed and developed mapping, transformation logic and processes in Ab Initio for implementing business rules and standardization of source data from multiple systems into the data warehouse.
• Responsible for developing, support and maintenance for the ETL processes using Ab Initio.
• Extensively used Ab Initio to load data from Flat files to Oracle, Oracle to Flat Files & Oracle to Oracle.
• Created reusable transformations.
• Used sandbox parameters to check in and check out of graphs from repository Systems.
• Generated DB configuration files for source tables using dbconfig and modified them according to the requirements.
• Created sub graphs to impose application/business restrictions.
• Involved in using EME (Ab Initio metadata repository).
• Created error table to handle error records.
• Used Debugger to debug mappings by creating breakpoints to gain troubleshooting information about data and error conditions.
• Performance tuned the workflows by identifying the bottlenecks in targets, sources, mappings, sessions and workflows and eliminated them.
• Used Partitioning to improve session performance.
• Performed Unit Testing and System Integration Testing.

Confidential

Ab Initio Developer

Environment: Ab Initio 1.13, UNIX, Oracle

Responsibilities:

• Involved in fixing production problems.
• Remedies for the Tickets and submitting QAR.
• Communicating with on-site co-coordinator to get the requirements.
• Done appropriate unit-level testing of work products and the management of the review process for the Ab Initio deliverables.
• Created reusable transformations.
• Used sandbox parameters to check in and check out of graphs from repository Systems.
• Created sub graphs to impose application/business restrictions.
• Involved in using EME (Ab Initio metadata repository).
• Documenting the Technical Manuals.
• Created error table to handle error records.
• Used Debugger to debug mappings by creating breakpoints to gain troubleshooting information about data and error conditions.
• Performed Unit Testing.