EXPERIENCE SUMMARY

• 5.5 years of experience in Data Warehousing, Data Analysis, Application Design, Application Development which includes, Requirement gathering, Customization, Maintenance and Testing of various Business Applications in Data Warehouse and Training Specialist.
• Currently working for Syntel’s customer in Banking and Financial services domain.
• Expertise in managing end to end development and maintenance projects that involved activities ranging from development from start to implementation and warranty support.
• Excellent communication, analytical and reasoning skills.
• Handled end to end Projects in development, test and production support related to Ab Initio and Unix scripting.
• Expertise in developing ETL applications including designing, developing, deploying, implementing and maintaining Ab Initio applications.
• Good Exposure to UNIX and SQL languages along wif noledge in DB2, Sybase and other databases.
• Good hands - on experience using Informatica 9.1.0
• Responsibilities
• Client interaction for Requirement Gathering and Status update.
• Understanding the complete business flow and data model.
• Preparation of High level design, low level design and functional specifications documents.
• Creation of Test Plans and Test Scripts.
• Designed graphs and mappings through Ab Initio and Informatica in order to load data into the tables using transformations.
• Train new members of the team.
• Work on the Onsite-offshore model and co-ordinate application development activities wif the offshore team.
• Provide solutions to improve the efficiency and performance of existing applications.

TECHNICAL SKILLS

BI/DW: ETL layer using Ab Initio GDE 1.14, Co-op system 2.14 Informatica 9.1.0

Databases: DB2, Sybase ASE and IQ servers. Teradata

Operating Systems: UNIX (Korn shell), Sun solaris, Windows

PROFESSIONAL EXPERIENCE

Confidential

Informatica Developer

Responsibility

• Involved in gathering requirements and created design documents and mapping documents.
• Worked on Informatica Designer tools - Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformation Developer and Server Manager to create and monitor Sessions.
• Involved in the development of Informatica Mappings in order to read XML files coming in from the Source.
• Used different transformations like Source Qualifier, Expression, Joiner, Normalizer and Filter.
• Used Meta Data Framework( MDF) to run the validations checks on different fields present on the source file before loading data into the tables.
• Involved in Unit and System Testing.
• Interact wif the Business to get the Business sign-off.
• Implement the process in production and warranty support.

Confidential

Ab Initio Developer

Responsibility

• Analyzing requirements received from the client.
• Data transmission check by comparing the header data wif the actual record count and byte count present.
• Handle fix and variable length files in Ab Initio.
• Designing Ab Initio graphs and low level design components based on the requirement.
• Working on building graphs and running them in GDE.
• Used Ab Initio as ETL to pull data from the source system, transform as per the requirement and load data into the database.
• Used Lookup files for multiple sources where data size is limited.
• Created packages to increase the reusability in the project.
• Interact wif the Business to get the Business sign-off.
• Implement the process in production and warranty support.

Confidential

Ab Initio Developer

Responsibility

• Addition of Thai name fields to the Vendor Payments table
• Used Character set Windows 874, UTF8 to accommodate Thai characters into the Vendor Payments table.
• Increase the length of the name fields to accommodate Thai characters ( sinograms) into the database.
• Acquired significant noledge about different datasets in order to transform and load Thai characters into the IDN Database.
• Help team members load Japanese characters in the IDN Database.
• Implement the critical process in production.

Confidential

Ab Initio Developer

Responsibility

• 12 new tables added to the Warehouse.
• Designing High Level and Low Level documents based on the Business Requirements that use Ab Initio/Unix Applications.
• Analyze data warehouse schema and load data to fact and dimension tables present in the warehouse.
• Testing Ab Initio code for data transformations for any data issues using several Ab Initio graphs and Unix scripts independently for different FSB tables.
• Design generic components that could be used for similar requirements across different graphs.
• Test run data in QA and analyze code for any issues.
• Optimize the graphs for better performance.

Confidential

Ab Initio Developer

Responsibility

• Reduce the running time of long running graph.
• Tune Max core for optimal performance.
• Filter the data in the beginning of the graph to optimize the graph for large sets of data.
• Use Ab Initio layout instead of database default to achieve parallel load.
• Use lookups wherever joining small dataset to large dataset.
• Use MFS for large volumes of data to improve performance.
• Change the SORT data component to in memory sort for smaller data sets while joining the data.
• Create separate production like environment for Stress testing.
• Run the graphs and analyze the performance after making different changes to the graph.

Confidential

Ab Initio Developer

Responsibility

• Client interaction for requirement gathering and status update.
• Understanding the complete business flow and data model.
• Preparation of High level design, low level design and functional specifications documents.
• Creation of Test Plans and Test Scripts.
• Designed graphs and mappings through Ab Initio in order to load data into the tables using transformations.
• Designed graphs to load the data into the Aetna database after applying many transformations techniques according to the client requirements.
• Developed a wrapper script to pass table name as parameters and lrfs and dmls will be picked automatically to load data into the table.
• Designed a reusable component used to set complex history fields.
• Developed shell scripts to automate data feed from the source.
• Working on Design and development of Data Load components using Ab Initio and shell scripts. Using DB2 utilities for loading the data.
• Developed Checkout scripts to maintain consistency in the data loaded in the data warehouse and database tables.