SUMMARY

• Highly motivated Business Intelligence Professional with 7 years experience in Data Warehouse design and implementation using Ab Initio.
• Solid experience in developing ETL applications using Ab Initio, including high level and detailed design, implementation, documentation, and deployment.
• Skilled in writing wrapper scripts for ETL applications according to requirements.
• Worked with design and deployment phase of ETL process and prepared the company’s standard documentation at functional, technical and design level.
• Worked with Ab Initio EME and CVS for version control, dependency analysis and migration process from development to testing to production environment.
• Experience in integration of various data sources (SQL Server, Oracle, flat files) into data staging area.
• Good experience with Data Migration, Data Transformation and Data Loading into various databases using Ab Initio.
• Demonstrated team work skills as well as the ability toaccomplish tasksunder minimal direction and supervision.
• Served as quality assurance and control to ensure that the final product meets all business requirements.
• Worked as a liaison between the Developers and Clients and resolving conflicts between user and technical development teams.
• Worked closely with testers to perform various testing operations such as black box, white box, and component and load testing, etc.
• Strong analytical and problem - solving skills.
• Enthusiastic and dedicated person who can accurately perform challenging tasks.
• Self-motivated, fast learner, responsible.
• Very good team player with excellent communication skills and work ethic.

TECHNICAL SKILLS

ETL Tools: Ab Initio, SSIS

Languages: C/C++, Java, Korn Shell, Perl, HTML, JavaScript, PHP, PL/SQL, Pascal

Operating Systems: UNIX, MS DOS, Windows, Mac OS

Databases: SQL Server 2005/2008, Oracle, MySQL, Netezza

Job schedulers: Appworx, Autosys

PROFESSIONAL EXPERIENCE

Confidential

Ab Initio Developer

Responsibilities:

• Responsible for defining business rules of the project, gathering business requirements, doing gap analysis and documenting them.
• Created high level and detailed designs according to business requirements.
• Designing and implementing Ab Initio graphs to create flat files containing student information including medical and dental profiles, enrollment, behavior, daily attendance, specialized student services, transportation, student marks, demographics, etc.
• Created test plans, used generate record component for generating test data sets.
• Implemented graphs with complex transformations for Summer School Eligibility Project.
• Partitioning to run the application on multiple processors.
• On-call nightly production supportOne of IMPACT ‘s initiatives was to bring students’ tests details into its operational data store (ODS). These test records include all the students from all grades and cover all different type of tests they take.
• Test subject area of ODS was modeled as a combination of highly de-normalized tables to accommodate all types of tests taken by the students in the CPS through all grade levels.
• Developed a common set of graphs to accommodate all test formats, whose structure changes each year. This was achieved by writing a set of abinitio graphs with complex embedded parameters whose values would be set based on config files of the graph. Ultimately ETL would run for each test solely based on these config files.

Confidential, Deerfield, IL

Ab Initio Developer

Responsibilities:

• Interviewing business area experts, asking detailed questions and carefully recording the requirements in a format that can be reviewed and understood by both business and technical people.
• Developed data migration Perl Scripts which prepare environment variables to be used in the AI graphs such as a list of tables to be unloaded from Production environment to development server and loaded in different databases according to requirements.
• Implemented complex business logic for calculation of two new metrics Last Saved Sales Dollars Change and Last Saved Profit Dollars change.
• Involved in development and testing of Business Planning Seeding module. The goal of this module is to provide a systemized tool to forecast Sales metrics for each planning year using the existing sales and profit data from Fact tables.
• Changed business logic for addition of new metrics in Key Investment module, which is used for planning and tracking a custom group of items being sold during specific seasons as Christmas, Easter, etc. The two years sales history data is transformed into an actual and used to populate different metrics as Sales, Profit Margin retail price, etc.
• Performance tuning of graphs, for example using partition components, reducing unnecessary components, using lookups instead of join, etc.
• Centralized Pricing Initiative (CPI) Project is used to provide automation of the pricing process of items with centralized control yet providing sufficient flexibility to the users at corporate and store levels in diverse geographical and economical zones in US and Puerto Rico. It also provides the vital marketing statistics, which is used to assess current marketing strategies and plan the future ones.
• Implemented AI graphs which extract specific items from the database according to business requirements. The output is used for Business Objects report displaying the impact of these items on the sales.
• Understand and articulate business requirements from user interviews, and workshops and then convert requirements into technical specifications.
• Changed business logic for addition of emergency price indicator and effective date change for some items. Responsibilities included Impact Analysis, testing and code migration.
• Created a Perl script to update test environment with the latest production data. The graphs called are using .abinitiorc file and are repartitioning multi-files with different keys from 10 ways parallel in Production to 4 ways parallel in UAT environment.
• Changed business logic for establishing WIC (item number) to CM (category manager) relationship which involved extracting fields from DW database and populating them into CPI database.

Confidential

Oracle Developer

Responsibilities:

• Developed PL/SQL Business Functions, procedures and packages for data models to create reports from J2ee web Application.
• Involved in Gathering the Requirements for creating data models for data analysis and reporting
• Designing Tables, Constraints, Views, and Indexes etc. in coordination with the application development team.
• Involved in developing ETL Process to Load the Data from the Mainframe Production Databases to the Oracle Database models.
• Involved in writing Test plans for PL/ SQL Stored Procedures and Functions.
• Involved in Unit Testing and System integration.
• Involved in developing UNIX shell scripts required for maintaining the data Models and processing job.
• Involved in Developing and maintaining control files for SQL* Loader to load data from flat file into database tables.
• Writing scripts for Data Staging, Loading and cleanup process.
• Involved in Writing Oracle Application Program Interfaces(APIs) and Performance tuning.
• Created Materialized Views and partitioning tables for performance reasons.
• Involved in testing PL/ SQL programs, UNIX shell scripts required for maintaining the data Models.
• Involved in resolving Java user interface production issues.
• Involved in quality assurance of data, automation of processes, programming for data manipulation validation of programming, and presentation of results.
• Preparing documentation for requirements, design, install and Unit testing.
• Tuning of stored procedures & developed business logic in database layer using PL/SQL.

Confidential

Database Developer

Responsibilities:

• Responsible for designing and developing Schemas using Entity Relationships, Data Modeling, Normalizing the relations, creating Tables, Views, Indexes, Sequences and coding.
• Developed several forms and reports in the process. Also converted several standalone procedures/functions in PL/SQL to packaged procedure for code reusability, modularity and control.
• Designed tables, indexes and constraints using SQL*Plus and loaded data into the database using SQL*Loader.
• Established connectivity between the HTML forms and the Oracle database
• Helped the set up and configuration of Oracle 7.x - 8.x database to work with internet applications.
• Developed Stored Procedures and functions to accomplish several computations.