SUMMARY

• 5 years of professional IT consulting experience in analysis, design, development, testing and maintenance of business intelligence, analytics and data warehouse systems. Hands on experience include developing Data Warehouses/Data Marts/ODS in Retail, Finance and Insurance.
• Experienced in Ab Initio (GDE 1.15/2.5, Co>Op Sys 2.15/3.2) SAS and Hubble tools.
• Data Extraction from various data sources, Mapping, Transformation and Loading between Source and Target Databases in a complex, high - volume environment.
• Experience in working with various heterogeneous Source Systems like Mainframe OLTP, Oracle, MS SQL Server, DB2 and Flat files.
• Excellent understanding of Software Development Life Cycle and Test Methodologies from project definition to post-deployment documentation
• Developed several AbInitio graphs for transferring, loading, cleaning and populating various Data marts for both ODS and DSS instances on UNIX platform.
• Implemented whole life cycle of testing methodologies starting from planning, creating, executing, reporting and tracking the defects.
• Experience in new AbInitio features like Component Folding, Parameter Definition Language (PDL), Continuous flows, Queues, publisher and subscriber components.
• Extensive experience in running various kinds of tests such as System,Regression, Functional, Backend, User Acceptance Test (UAT) for Web (N-Tier) and Client/Server Applications.
• Proficient in using automation tools such as Quick test pro, Winrunner.
• Extensive experience in writing SQL/PL-SQL functions, packages, procedures and SQL scripts
• Expert in testing database applications of RDBMS in ORACLE, SQL Server and MS Access.
• Ability to interact with developers, Business users, vendors and product analysts regarding requirements, testing status and defect tracking.
• Self-starter and team player, problem solving skills, interpersonal skills and a good aptitude for learning.

TECHNICAL SKILLS

BI Tools: AbInitio(GDE 1.15/2.5, Co>Op sys 2.15/3.2), QTP9.0

Languages: SQL, C, C++, Visual Basic, Base SAS, SAS/SQL

Packages: MS Office

Databases: SQL Server 200, Oracle, DB2, MS Access

Front End Tools: Oracle Developer 2000

Versioning Tools: Clear Case, MS Visual Source Safe, CVS

Other Tools: Rational Clear Quest, Remedy, Data Stage

Operating Systems: Windows 95/98/2000/NT/XP, MS-DOS, MVS,UNIX

PROFESSIONAL EXPERIENCE

Confidential

Data Analyst

Responsibilities:

• Understand the business requirements, prepared the Physical design, High level designs and technical specifications.
• Conducted thorough data analysis and identified the gaps for further discussion with business users. Estimated the effort and provided the ETA for the reports.
• AbInitio graphs were developed based on the requirements. Extracted data from Oracle, DB2 and flat files and transformed the data. Final output was loaded into the data to Oracle database.
• Hubble report transporter was set up to read the tables and generate the reports.
• Prepared design documents and written test cases.
• AbInitio graphs were enhanced based on the change request.
• Supported all the reports in AbInitio and Hubble report.
• Conducted unit and system testing.
• SAS tool was used for basic statistical analysis. Helped in enhancing the SAS SQL code for generating the reports.
• Also helped the business users in pulling the huge amount of data from various databases for strategic business analysis.

Environment: PLSQL, Windows XP\Vista, Oracle 10g, DB2, SAS, Ab Initio (GDE 1.14Co>Op Sys 2.14/3.2) Shell Scripts.

Confidential

AbInitio Developer

Responsibilities:

• Understand the business requirements, prepared the Physical design, High level designs and technical specifications.
• Using different databases (Data Warehouse, Marketing System, and Forecasting databases) prepared the input tables.
• Selecting different components from component organizer like JOIN, REFORMATE, F ILTER BY EXPRESSION,ROLLUP,GATHER and doing different joins for preparing the output data files, after applying various business rules and set the parameter RUN DAY.
• Preparing the plan and writing the wrapper script to run the graphs.
• With the support of AbIntio architecture team moved .mp files, .ksh files, plan, script into production. Ran the scripts and executed graphs in production.
• Created DBCR for new tables and indexes in development and production databases.
• Testing and validating the output data based on the requirement.
• Helped the analytical team in data mining activities.

Environment: Ab Initio (GDE 1.14Co>Op Sys 2.14/3.2) Shell Scripts, SQL

Confidential

ETL Developer/Tester

Responsibilities:

• Analyzed Business requirements, prepared the Physical design, High level designs and technical specifications.
• Developed several graphs using Transform, Translate and validate components
• Created Unix scripts.
• Process raw hardware component usage records: aggregate and rollup data to data mart for management review and planning.
• Updated numerous SQL scripts, making appropriate DDL changes and completed unit and system test.
• Worked on improving the performance of Ab Initio graphs by using Various Ab Initio performance techniques like using lookup Tables, In-Memory Joins and rollups to speed up various Ab Initio Graphs.
• Created an archive process that archives the data files and FTP to the remote server.
• Developed several SQL scripts to validate data from the graphs
• Created a shell script that checks the corruption of data file prior to the load.
• Created unit test plans to unit test the code prior to the handover process to QA.
• Performed migration documentation to move project from dev environment to all testing phases through UAT phase, and also supported the client to made sure that, code was delivered with in time and satisfied with the expectations.

Environment: Ab Initio (GDE 1.14Co>Op Sys 2.14, Shell Scripts, SQL, Qc.

Confidential

ETL Developer/Tester

Responsibilities:

• Developed Ab Initio graphs to support the data transformation process.
• Developed graphs to load tables using Output Table and Update table components
• Involved in all phases of the ETL process, which includes requirement analysis, Source-Target Mapping document and ETL process design.
• Transformed data using complex business process rules.
• Designed and Developed Ab Initio Graphs based on the Business Requirements.
• Responsible for the Validation of the different sources by using Ab Initio Functions.
• Responsible for creating test cases to make sure the data originating from source makes it to the target in the proper format. Performed Component testing of AbInitio graphs and fixed the defects found.
• Developed Ab Initio graphs for Data validation using validate components like compare records, compute checksum etc.
• Populating the database, exporting and importing data.
• Business analysis user requirements for the ad-hoc reports and reports show Month-To-Date, Year-To-Date Data, reports from Archive Database and Data Warehouse Reports.
• Created Partitions on tables and Indexes as part of performance improvement.
• Managing tables, indexes, constraints, types, views, synonyms and sequences.
• Control Files for moving data from Flat Files (Fixed Record Length) to Staging Area Tables.
• Creating Korn Shell Scripts which act as a wrapper for various tasks like - for executing the SQL*Loader command lines, for refreshing and for updating the Fact and the dimension tables with the data from the Staging Area Tables
• Used End script for performing operations after the execution of graph.

Environment: Ab Initio (Co>Op 2.14, GDE 1.14), Plan IT, Oracle 9i, DB2 UDB, Windows NT/2000, UNIX (K-shell), Qc.

Confidential

Asst. System Engineer

Responsibilities:

• Responsible for defining, preparing, executing, and reporting of SDLC solution test and verification activities. This includes testing of software and data quality assurance in preparation for release to the customer.
• Extensively utilized SQL and Oracle PL/SQL to effectively assure data quality
• Developed software to query for data loaded into Oracle databases as a part of testing the Extract, Transform, and Load (ETL) software
• Coordinated with Development team to reproduce issues discovered
• Provided feedback to Requirements team regarding testability of the use-cases and supplemental requirements
• Provided support to the users in development of acceptance test plans/approaches

Environment: Windows, Quality Center, C, Oracle, UNIX, Clear Quest.