SUMMARY

• 7+ years of Professional experience in performing full life cycle software development, design and implementation with focus on Data Warehousing, Business Intelligence and Database Applications and QA testing.
• 4+ years of experience in AbInitio ETL tool, Data Mapping, Transformation and Loading in a complex, high - volume environment and testing.
• Performance tuning the complex AbInitio graph, worked with tuning the memory parameter and AbInitio best practice approach to implement the ETL process
• Configured graph parameters, sandbox parameters, environment variables and EME Repository environment for Production/Development and performance tuning for load graph process.
• Expertise in creating Simple, Complex and Ad-hoc Reports and fine-tuning them.
• Experienced in Data Profiler.
• Involved in data migration programs between database like Teradata, Oracle, TIBCO,SQL Server and DB2, and PC file formats and added enhancements to existing applications according to regulatory requirements.
• Proficient with various AbInitio parallelism techniques and implemented AbInitio Graphs using Data parallelism and MFS techniques.
• Extensively involved in TERADATA Table design, index selection, Table implementations, capacity planning and Policies, procedures & guidelines that govern the Teradata environment.
• Excellent knowledge in Batch Jobs using UNIX CRON, AWK, UNIX Shell Script.
• Experience in iLog Rule Engine (Business rule Management Systems).
• Very strong in SQL including use of nested table expressions, unions, multi-table joins, scalar functions, outer joins, derived columns, and creative use of the EXISTS operator.
• Knowledge of different BI tools like Oracle Reports, Brio, Cognos.
• Good Communication Skills and Strong interpersonal skills to deal effectively with a broad range of contacts from technical staff, to clients, to management.

TECHNICAL SKILLS

Operating Systems: UNIX, AIX, Windows XP/NT, MSDOS, Sun Solaris and Linux

Languages: C, Unix Shell scripting, SQL, PL/SQL, T-SQL, Perl

Databases: Oracle 10g/11g, IBM DB2, Teradata vR6,vR12, SQL Server 2000/2005

ETL Tools: AbInitio

Packages: SQL*Loader, TOAD, PL/SQL Developer

BI Tools: Oracle Reports, Brio, Cognos

Testing Tools: Test Director, LoadRunner, ClearCase and ClearQuest

PROFESSIONAL EXPERIENCE

Confidential, Philadelphia, PA

AbInitio Developer

Responsibilities:

• Analyzed the low-level design documents and business requirements.
• Designed and developed data extract, transform and load processes (ETL) for cross sectors data files using AbInitio, Oracle and Shell scripts.
• Participated in requirements meetings with Business Users to understand and collect segmentation and project requirements and prepared technical design documents for the conceptual, logical and physical design and reviewed with the team members.
• Developed two modules, Base list creation and Customer record preprocessing.
• Managed issue resolution process to ensure all user data quality issues are proactively researched and resolved
• Wrote and updated technical and user documentation.
• Worked concertedly as a senior developer within a team to build the project and undertook responsibilities of working closely with users for requirements gathering and providing the team with detailed requirements documents.
• Coordinated with SME, Data analyst, compliance team on any data quality issues.

Environment: Ab Initio (Co>OS 2.1.16, GDE 1.1.16), Oracle 11g, Conduct It, AIX, Actimize AIS server, MQ cluster, Quick screen.

Confidential, Wilmington,DE

AbInitio developer

Responsibilities:

• Analyzed the low-level design documents and business requirements.
• Designed and developed data extract, transform and load processes (ETL) for Operational data distribution environment using AbInitio, Teradata SQL and Shell scripts.
• Participated in requirements meetings with Business Users to understand and collect segmentation and project requirements and prepared technical design documents for the conceptual, logical and physical design and reviewed with the team members.
• Collaborated with Data Warehouse, other Data Marts, Architecture, and Customer Support teams to design and develop new solutions.
• Optimized the data structures to enhance data load times.
• Managed issue resolution process to ensure all user data quality issues are proactively researched and resolved
• Created new and followed established processes to ensure quality of all deliverables
• Wrote and updated technical and user documentation.
• Worked concertedly with an offshore team to build the project and undertook responsibilities of working closely with users for requirements gathering and providing the offshore team with detailed requirements documents.
• Worked with level 3 production support team as a responsible to provide solutions for daily production incidents and data defects.
• 24x7 Production Support for ETL jobs for daily, Monthly and Weekly schedule and also worked with scheduling tools such as Control-M to schedule the ETL batch process
• Coordinated with SME, Data analyst, L2 support personnel on problem solving.

Environment: Ab Initio (Co>OS 2.1.15, GDE 1.1.15), IBM DB2, MVS, Oracle 10g, Control-M, Teradata VR12, AIX

Confidential, Foster City, CA

ETL Tester

Responsibilities:

• Created test cases by going through all the documentation and the walkthroughs and detailed design documents.
• Developed the test plans and test cases.
• Developed scenarios for Regression/Functional testing, which covers more than 90% of the Critical scenarios for the application.
• Involved in analyzing the changes made from the previous release.
• Checked the code to ensure it follows all the required Standards.
• Manually executed the AI graphs/Unix scripts to ensure the expected code change is working.
• Prepared test data to make sure all the scenarios are captured and tested.
• Logged defects in CQ if needed.
• Validated the reports after execution, and comparing expected results with actual results.
• Interacted with developers to resolve for the severe priority bug issues.
• Wrote SQL scripts to verify the database updates, inserts and delete of the records and validate reports.
• Worked closely with report Developer/Admin to published test analysis report in BOXI and Micro Strategy for the management people’s review.
• Prepared the UAT reports and presented it to the Business people.
• Participated in Walkthroughs and Weekly status meetings

Environment: AbInitio GDE 1.13, Co>operating system 2.11, EME, UNIX, Shell scripts, AutoSys, IBM MVS, DB2, Micro Strategy, PL/SQL, BOXI, IBM Rational ( Clear Case, Clear Quest), RBAR, iLog rules.

Confidential, Charlotte, NC

AbInitio Developer

Responsibilities:

• Used Ab Initio GDE to generate complex graphs for the ETL process using Join, Rollup and Reformat transform components and executed using the framework defined by Level3.
• Developed and supported the extraction, transformation and load process for the Data Warehouse from heterogeneous source systems using Ab Initio.
• Involved in automating the ETL process through scheduling software and also involved in custom ETL process.
• Modified the Ab Initio components parameters, utilize data parallelism and thereby improve the overall performance to fine-tune the execution times.
• Setup Data Profiler environment and EME projects for data profiling
• Configured and created rules and generated data profiling reports.
• Created various Ab Initio Multi File Systems (MFS) environment to implement MPP standards run graphs in parallel and perform the ETL process faster.
• Creating load ready files using Ab Initio ETL tool to load into Teradata Database and Worked with implementing SQL Loading Direct/Conventional and DML approach.
• Developed complex SQL queries using complex joins, sub-queries and correlated sub-queries.
• Extensively worked under the Unix Environment using Shell Scripts.
• Involved with Mainframes in reading the input files.
• Involved in setting up the JCL’s and appropriate Parameters.
• Responsible for creating test cases to make sure the data originating from source makes it to the target in the proper format.
• Designed processes to extract and transform data from flat files and relational sources to load into relational targets Deploy and test run the graph as executable Korn shell scripts in the application system
• Developed DB2 SQL queries for ETL transactions.
• Worked with UNIX shell script to implement error handling and automating the ETL process and enhanced the ETL wrapper scripts to perform the error notification escalation process.

Environment: AbInitio (Co>OS 2.1.14, GDE 1.1.14), Mainframes, AS/400, UNIX, Oracle 10g, DB2, TIBCO, Teradata V2R6, IBM AIX 5.2.

Confidential, Dallas, TX

ETL Tester

Responsibilities:

• Involved in entire QA life cycle.
• Used Win Runner for functional testing and testing GUI.
• Performed Black box test, Regression test, User Interface test, Security test and Integration test.
• Used Test Director for reporting, tracking and verification of fixed bugs.
• Used SQL to validate the entries in the database.
• Involved in the development of test plans, test strategy, test scenarios and test cases
• Interacted with different development teams to coordinate testing.
• Performed Manual Testing for Random Testing and where Automating was costly.
• Participated in the Usability Testing.
• Performed daily Smoke Tests.
• Performed product Installation and Configuration testing.

Environment: Ab Initio (GDE 1.1.14, Co>Operating System 2.1.14), Business Objects 5.1, Erwin 5.3.2, DB2, PL/SQL, SQL, UNIX (SunOS 2.8), Shell Scripting, Windows NT 4.0, SQL Server, Oracle 9i

Confidential, Herndon,VA

ETL Tester

Responsibilities:

• Analyzed the low-level design documents and business requirements.
• Created test cases by going through all the documentation and the walkthroughs.
• Prepared test strategy, test plans for manual testing and automated testing.
• Involved in the complete life cycle of the project from requirements gathering stage until the migration to production and also provided production support to the project after that.
• Worked with the business users to gather the entire requirements of the project and prepared the Functional and Technical requirements, Conceptual design and Detailed design documents.
• Designed and deployed many AbInitio graphs both generic and custom graphs to accomplish the various tasks of the project.
• Developed graphs had within them complex transformations that manipulated the stream (denormalized) data to calculate the project requirements.
• Involved in the generation of the project database logical and physical ER diagrams using Erwin 4.0
• Project database was developed in Oracle 9i and was involved with the front end to optimize and tune their SQL queries to enhance the performance of the main user web interface.
• Created various custom UNIX K-shell wrapper scripts to run the AbInitio deployed graph shell scripts. These wrapper scripts were then scheduled as daily or weekly jobs to be run in the AutoSys scheduler.
• Wrote various Perl and Unix shell scripts to accomplish and wide variety of tasks such as parsing of XML documents, send emails with attachments, create ad hoc multifile etc.
• Created various test plans to validate the results.
• Involved in gathering the feedback from the users to develop strategies to further tweak the system to achieve better results.

Environment: AbInitio, IBM AIX 4.1, UDB DB2 8.2, Teradata, Oracle 8i, TOAD, PL/SQL.