SUMMARY

• Hands on exposure on ETL, ELT, Reporting and data modeling architectures,
• Trained on Business Objects, Cognos,
• Trained on SYBASE IQ by SYBASE IQ Corporation,
• Planning and implementing projects and Working in a fast - paced environment while solving crises,
• Designed the data modeling for party gaming using the data modeling tool Unica,
• Writing the functional and technical specification documents for various Projects includes finance, manufacturing insurance and reinsurance domains.
• Sound knowledge of various data warehousing modeling techniques like Inman and Ralph Kimball's approaches.
• Extensive experience in ETL design, Trouble Shooting and Debugging.
• Strong Working Experience in RDBMS like Oracle, SQL Server and TERADATA RDBMS.
• Designed the business objects universe to satisfy the end user requirements for Adhoc reporting.
• Well-developed Interpersonal and Communication skills with good Documentation and Presentation skills.
• Possesses strong Commitment and excellent Analytical, and efficient Problem Solving skills, currently leading a team of 8 members at Offshore and 3 members onsite team
• Expertise in all phases of SDLC (System Analysis, Design, Development, Testing, Deployment, support, documentation & Configuration Management).
• Reputation for strong organizational skills, excellent communication skills, dedicated teamwork, attention to details, ability to work under pressure to balance competing priorities and meet deadlines.
• Extensive experience in the design, development, and implementation of data warehousing applications using Data Warehousing Technologies and Ab Initio
• Expertise in the Transformation processes using Ab Initio
• Exposure on Ab Initio Data Profiler, Conduct>IT, PLANS, PSETS
• Exposure on Ab Initio Metadata hub
• Prepared HLD and LLD documents as per the requirement
• Exposure on shell scripting.
• Assisted in development of ETL architectural standards.
• Performed Abinitio data quality checks for the source and target tables
• Provided technical support in all phases on enterprise architect life cycle.
• Participated in requirements gathering and refining discussions.
• Participated in development of code management procedures and testing methodologies.
• Participated in design review sessions.
• Maintained documentations for error recovery procedures.
• Sound knowledge of data modeling tools
• Strong knowledge of Operation Data Stores and Data Marts
• Good understanding of Business intelligence, ETL, data architecture, Ab Initio architecture
• Ability to coordinate with QA team to develop test plan
• Ability to provide support in each phase of full life cycle of data warehouse environments
• Involved in analyzing physical and logical data models.
• Maintained and upgraded data warehouse environment as per business needs.
• Reviewed ETL designs and codes and recommended changes if any.
• Developed and enforced best practices for ETL architecture.
• Provided an architecture solution that is reusable, maintainable and scalable.
• Assisted in development of project plan and schedules.
• Worked with Project Managers in project estimation, development and implementations.
• Proficient in the preparation, execution, and review of test cases
• Possess excellent analytical and interpersonal skills

TECHNICAL SKILLS

Operating Systems: UNIX

Languages: SQL and PL/SQL

DBMS: Oracle 9i/8i/10g and SQL Server 2005, Teradata

ETL Tools: Ab Initio, Co-operating System: 3.x, and GDE version: 3.04

Reporting Tools: Crystal Reports 9/XI, Business Explorer (BEx) and Business Objects

Scheduling Tools: Control-M, Autosys, SAM, Event Engine

Other Tools: Text pad, Edit Plus, SSH Tectia Client, HPSM, QC, Putty

MANAGERIAL KEY SKILLS:

• Meetings & Reviews
• Proposals & Presentations
• Audits & Compliances
• Reporting & Documentation
• Knowledge Management

PROFESSIONAL EXPERIENCE

Ab Initio Architect/Lead

Confidential, Phoenix, AZ

Responsibilities:

• Worked on ‘xml’ to ‘dat’ file conversion and made the process generic to read the data.
• Implemented new business rules as per the business requirement in GNICS.
• Worked on end to end process as part of development.
• Co-ordinated offshore and CDQA for defect fixes.
• Implemented new validation rules and made the process generic to SFTP the file.
• Involved in all design approaches.
• Involved in putting major points at project performance.

Environment: Abinitio 3.x, UNIX, Control-M, db2

Ab Initio Lead

Confidential, Greenford, UK

Responsibilities:

• Involved in the requirements gathering with key stakeholders to understand the scope
• Given high level design for the complete data mart (Existing Teradata piece)
• Converted Teradata Bteq scripts to Abinitio graphs
• Involved at new data mart design, Tables creation, constraints and indexes build.
• Analyzed CPU cost, skew I/O structure for the new data mart and given the comparison
• Unit test cases preparation and interaction with SIT team
• Created Control-M jobs for the proof of concept

Environment: Abinitio 3.x, Unix, Control-M, Teradata, SQL Server

Ab Initio Lead

Confidential, Slough, UK

Responsibilities:

• Working on different modules in O2 Agile process as Abinitio onshore lead.
• Involved in different critical modules for estimations and high level designs.
• Understood client frame work very quickly and involved in various work around.
• POC for code reviews, defect resolutions and warranty support.
• Involved in all phases like development, design, mapping logic (business rule updates, UTR preparation, QV movement, defect resolutions and production movement).
• Used Meta Data Hub for data lineage checks across multiple modules

Environment: Abinitio 3.x, Abinitio MDH, UNIX, Teradata, Control-M

Ab Initio Developer,

KeyBank, Cleveland, OH

Responsibilities:

• Working on different modules like Pershing, CRR (Credit Risk Reporting), Sourcing, SFD.
• Involved in Design estimation for all the mappings across all the modules.
• Owned single project and involved in all phases like development, design, mapping logic (business rule updates, UTR preparation and QV movement).
• Interacted with business on daily basis to get clarifications on queries.
• Code reviews, Design finalize Code movement to QV, Review deliverable documents.
• Performed data quality checks on the load ready files and Target tables.
• Exposure on different sources like Mainframes, Oracle, MSSQL and Teradata.
• Involved in TWS job creation for job level
• Used PDL rules for optimizing graph code and performance.

Environment: Abinitio 3.x, UNIX, Mainframes, TWS, Cognos

Abinitio Lead

Confidential,Phoenix, AZ

Responsibilities:

• Point of contact for 10 members.
• Involve in daily status calls with Architects and offshore members.
• Took responsibilities in delivering major number of feeds.
• Insisting team in major analysis and design.
• Prepared run book for easy access to team members for frequent failures in Development.
• Responsible for defect fix and defect resolution (QC).

Environment: Abinitio, Teradata, Event Engine, Putty, MDF

Ab Initio L3 Support

Confidential, Richmond

Responsibilities:

• Currently handling team size of 10 members for 8 applications as a SPOC for L3 area.
• Responsible for Incident response and resolution with in the SLA
• Responsible for Daily report to Client higher management.
• Weekly WSR report preparation; MSR report preparation.
• Incidents assigning to team members.
• Daily catch up calls with Offshore counter parts.
• Across all Bio-groups, Steady state tracker preparation.
• Value ads given to client from L3 area to reduce incidents in few bio-groups.
• Involved in monthly stand up calls with senior managers.
• Helped Dev Team in preparing PSETS, DML's, XFR's for few graphs as a adhoc requests.

Environment: Ab Initio(1.15), Oracle11i, Teradata, HPSM, QC, Tectia client(unix), Control-M

Ab Initio L1 & L2 Support

Confidential, Tampa, USA

Responsibilities:

• Handled team size of 15 members and 6 Applications as a Offshore Lead (SPOC). Team co-ordination, issues escalations and proper handling the situations.
• Actively involving in all the Team meetings, Weekly meetings and monthly meetings. Prepared and maintaining ETL production support tips document for all the Applications Flexible and can stretch long hours in office/meetings if required when situation demands Developed graphs and helped onsite team members Technical assistance to team in Coding, Creation of Test cases and Reviews before delivering it to onsite.
• Debugging and resolving all types of severity issues in job abends on time to meet the SLA’s. Research and identify the root cause of suspected or reported production problems and to offer various solutions to the client that meet both the business needs and support the target architecture of the applications.

Environment: Ab Initio(3.02), Oracle11i, QC, Tectia client(unix), SAM

Ab Initio Developer

Confidential,

Responsibilities:

• Understanding Given Business Requirements from Functional Specifications
• Developing Ab Initio graphs as per Technical Design Document and AICC ( Ab Initio Competency Centre) Development Standards
• Unit Testing of Developed Graphs, and Unit Test Documentation.

Environment: Ab Initio, Oracle10g, Putty(Unix), Autosys

Ab Initio developer

Confidential, Northbrook, IL

Responsibilities:

• Developed packages using MS-DTS tool to create source files for Ab Initio process
• Designed and developed graphs using Ab Initio
• Worked on various components like Partition, Transform, Database and Dataset Components.
• Developed complex generic and conditionalised Ab Initio graphs with emphasis on optimizing performance
• Developed Ab Initio graphs using various Ab Initio functions like is valid, is blank, is error, is defined, string *, and date functions
• Involved in check-in and check-out of the Project
• Involved in Migrated codes to QC Environment
• Participated in code and design reviews to enforce standards
• Involved in unit test case preparation, test cases review, testing and testing review
• Prepared documentation

Environment: Ab Initio, DTS, MS-SQL Server, Oracle 9i Client, and Win -XP

Ab Initio developer

Confidential,Northbrook, IL

Responsibilities:

• Interacted with client and gathered requirements
• Prepared Mapping documents, design documents like HLD and LLD
• Involved in design the graphs for TRAD (Traditional Life)
• Participated in code and design reviews to enforce standards

Environment: Ab Initio, Oracle 9i Client, and Win XP

Ab Initio developer

Confidential,Northbrook, IL

Responsibilities:

• Involved in Code Review to standardize the Ab Initio graphs
• Prepared Mapping documents, design documents like HLD and LLD
• Designed and developed graphs using Ab Initio
• Involved in Production support activities
• Involved in unit testing, Integration testing, reviewing and test case preparations
• Participated in code and design reviews to enforce standards

Environment: Ab Initio, Crystal Reports XI R2, Crystal Enterprise and SAP R/3

Ab Initio developer

Confidential, Northbrook, IL

Responsibilities:

• Extensively used calculations, variables, filters, conditions, sorting, alerts for creating reports
• Created complex reports by writing Stored Procedures and views to supply data for crystal reports
• Developed materialized view and summary tables necessary for Structured Reporting
• Used Crystal Management Console of Crystal Enterprise to maintain reports scheduling tasks
• Created the reports on the web using Web intelligence
• Unit testing, review, test case preparation and data driven testing of the universes and reports
• Designed and developed Crystal Reports which included standard reports, and cross-tab reports

Environment: Ab Initio, Crystal Reports 10, Business Explorer (BeX), Reflection and SAP B/W