PROFESSIONAL SUMMARY:

• Over 9+ years of progressive IT experiences in Development, Testing and Implementation of Data Warehousing projects in various financial, insurance and logistics companies on Windows environment.
• Strong Skills as a Data warehouse Consultant using ETL tools AbInitio and extensive experience in Data warehousing methodology especially Ralph Kimball methodology and Dimensional modeling using Star and Snowflake schemas
• In depth knowledge in Banking and Finance (BNFS), Insurance and Logistics domains
• Established and maintained relationship with Stake Holders, VPs, Directors, Release Managers, PMs, Data Modellers, Domain Architects, Architect Solution Groups, Portfolio Architects, Performance Engineers, Infrastructure Administrators
• Extensive experience in Delivering/Leading Releases/Projects end - to-end
• Expertise in Release Management including managerial and hands-on leadership during major project implementations, handling critical change management operations and post production validations
• Expertise with Data Integration, Data Architect, Data Modeling, Database Design, Data Warehousing, Data Migration, ETL, Data Profiling & Production Support
• Experienced in managing critical issues under stringent timelines during Production support and also entrusted as the single point of contact in a Production related High-Availability-Team
• Diagnosed production issues to ensure a timely recovery and minimal impact to our business users.
• Solid experience in the Analysis, Design and Development of Data warehousing solutions and in developing strategies for Extraction, Transformation and Loading (ETL) mechanism using Ab Initio
• Experience with Ab Initio Co-Operating System, application tuning, and debugging strategies
• Proven expertise in writing UNIX Shell Scripts including Korn Shell Scripts
• Participated in building Long Range Plans and Technical Delivery Schedule
• Ability to provide effective, efficient and low-cost solutions simultaneously on several projects
• Proven abilities in improving Application performance, capacity planning
• A self-starter with ability to work independently with well developed analytical and strategic thinking skills
• Ability to drive from concept to completion and lead multiple projects simultaneously in a fast paced environment
• Onsite working experience of 2 years
• Managed / Coordinated Confidential ’s onsite and off-shore development teams of 10-15 members

SKILLS:

Operating Systems: Windows 3.1/95/98/2000/ NT/XP, UNIX, Sun Solaris, Linux

Languages: C,C ++,Shell Scripting, SQL

Databases: Oracle 7.X/8.X/8i, IBM DB2, Microsoft Access, Teradata

ETL: Abinitio GDE version 1.14.38/1.15 , TERADATA 6.0 and DTS,SQL Server Analysis Services

Automation: Tivoli Workload Scheduler, Prognosis, Control-M

Others: Toad, AQT for DB2, PVCS, SVCS

PROFESSIONAL EXPERIENCE:

Confidential, Phoenix, AZ

Environment: DB2, Sun Solaris, Ab Initio GDE & EME, Actuate, Control-M, Visio, MQ Series, PL/SQL, Quality Centre, Jasper Soft, Dell, Stratus, Flat Files, CSV Files, XMLs

Ab Initio Technical Lead/SME

Responsibilities:

• Design new ETL workflow and/or customize/maintain existing workflows and processes.
• Implement ETL processes primary in Ab Initio.
• Propose Ab Initio features for best design, customization, and user experience.
• Develop SQL, PL/SQL programs, and scripts to support various data operations required by applications.
• Optimize performance by analyzing, ETL workflow and query patterns
• Participated in the Project Definition Phase with Business Users and Functional Owners.
• Served as Technical Expert through all the phases of SDLC
• Provide efficient and effective solutions on several projects simultaneously
• Conduct Proof-of-Concepts, provide Cost-Benefit Analysis, effort estimates/sizing
• Collaborate with other Domain Architects, DBA, Data Modellers, Support Groups and also Application Development & Test teams to ensure timely deliverables.
• Develop technical designs, transformations/mappings, maintain standards, core processes and best practices relative to architecture
• Assist in the development of data models, development of components to assure consistent, high-quality deliverables
• Evaluate system utilization related to responsiveness, processing capacity and reliability.
• Conduct knowledge-sharing sessions, quality design and code reviews
• Designed the Continuous Graphs interfacing external systems through MQ Queues & XML data
• Architecture the Merchant Certification Process by reutilizing the existing graphs with minimal changes
• Architect utilities to extract valuable technical information to provide insights on performance, volumes, statistics from Production Logs

Confidential, Memphis, TN

Environment: Ab Initio 1.15, Sun Solaris 5.8, C++, SSH Secure File Transfer 3.2.0, and TeraData, Ab Initio GDE & EME, Visio, Quality Centre

Ab Initio Technical Lead/SME

Responsibilities:

• Design new ETL workflow and/or customize/maintain existing workflows and processes.
• Implement ETL processes primary in Ab Initio.
• Propose Ab Initio features for best design, customization, and user experience.
• Develop SQL, PL/SQL programs, and scripts to support various data operations required by applications.
• Optimize performance by analyzing, ETL workflow and query patterns
• Involved in the analysis, design, preparation of the functional specifications documents and detail design documents
• Impact analysis and estimation preparation for the enhancement to existing systems
• Utilities and core process development in Java, EJB, MQ Series, Ab Initio Graphs & DB2 Stored Procedure
• Involved in Peer reviews
• Involving in System Integration Testing, User acceptance testing, Implementation and Warranty period production support for various releases
• Develop application and database ETL code for data movement and data quality processes in support of reporting and analytic applications
• Develop the ETL designs and strategy to accommodate the high-volume, high-quality data meeting requirements

Confidential

Environment: Ab Initio, MS-SQL Server, Oracle 9i Client, Win - XP, Unix, ORDS

Ab Initio Technical Lead / SME

Responsibilities:

• Design new ETL workflow and/or customize/maintain existing workflows and processes.
• Implement ETL processes primary in Ab Initio.
• Propose Ab Initio features for best design, customization, and user experience.
• Develop SQL, PL/SQL programs, and scripts to support various data operations required by applications.
• Optimize performance by analyzing, ETL workflow and query patterns
• Interacted with the OSC desk for data analysis requirements gathering and deliverables.
• Involved in effort estimation and distribution of work to team members
• Designed and developed graphs by using Ab Initio.
• Developed complex generic and conditionalised Ab Initio graphs with emphasis on optimizing performance.
• Participated in code and design reviews to enforce the standards.
• Involved in tracking and resolving the issues.
• Involved in unit test cases preparation and testing.
• Prepared documents like design, technical and deliverable

Confidential

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

Ab Initio Senior Developer

Responsibilities:

• Design new ETL workflow and/or customize/maintain existing workflows and processes.
• Implement ETL processes primary in Ab Initio.
• Propose Ab Initio features for best design, customization, and user experience.
• Develop SQL, PL/SQL programs, and scripts to support various data operations required by applications.
• Optimize performance by analyzing, ETL workflow and query patterns
• Interacted with the OSC desk for data analysis requirements gathering and deliverables.
• Involved in effort estimation and distribution of work to team members
• Designed and developed graphs by using Ab Initio
• Developed complex generic and conditionalised Ab Initio graphs with emphasis on optimizing performance
• Developed packages by using MS-DTS tool to create source files for Ab Initio process
• Participated in code and design reviews to enforce the standards.
• Involved in tracking and resolving the issues.
• Involved in unit test cases preparation and testing.
• Prepared documents like design, technical and deliverable

Confidential

Environment: Ab Initio, Oracle 9i Client, Win - XP, Unix

Ab Initio Developer

Responsibilities:

• Design new ETL workflow and/or customize/maintain existing workflows and processes.
• Implement ETL processes primary in Ab Initio.
• Propose Ab Initio features for best design, customization, and user experience.
• Develop SQL, PL/SQL programs, and scripts to support various data operations required by applications.
• Optimize performance by analyzing, ETL workflow and query patterns
• Involved in reviewing the functional, Technical, and high level design docs
• Analyze the requirements & Document preparation
• Developed sophisticated graphs by using ETL tool Ab Initio components like Reformat, Sort, Input, Output, Normalize, Rollup etc.,
• Involved in preparing unit test cases
• Involved in unit testing
• Involved in tracking and resolving the issues.
• Involved in Unit Test Case Preparation and Testing.
• Involved in preparation documents like Design, Master Technical and Deliverable Note documents.

Confidential

Environment: Ab Initio, Oracle 9i Client, Win - XP, Unix

Ab Initio Developer

Responsibilities:

• Involved in reviewing the functional, Technical, and high level design docs
• Analyze the requirements & Document preparation
• Developed sophisticated graphs by using ETL tool Ab Initio components like Reformat, Sort, Input, Output, Normalize, Rollup etc.,
• Involved in preparing unit test cases
• Involved in unit testing
• Involved in tracking and resolving the issues.
• Involved in Unit Test Case Preparation and Testing.
• Involved in preparation documents like Design, Master Technical and Deliverable Note documents.