PROFESSIONAL SUMMARY:

• 20+ years experienced Data warehouse specialist and a multi role SDLC player
• Experienced in Analysis, Architecture, Design, Development, Testing, Deployment and Support of large Data Warehouse projects in multi terabytes range in the Financial Industry
• 13+ years of excellent work base experience on ETL Process using Confidential
• Skills in framework design, performance tuning of graphs
• Expertise in Teradata and Oracle
• 20+ years of excellent work base experience on UNIX O/S and UNIX Korn Shell Programming
• 16+ years of excellent work base experience on ETL Process Design, Development and implementation
• 15+ years of strong experience on Conceptual, Logical & Physical Design process, Data Mapping, Impact Analysis and Root Cause Analysis
• Strong experience on conducting Review Meetings and Process Documentations
• 10+ years of experience on Abinitio Enterprise Metadata Environment ( EME )
• Excellent work base experience on OLTP/ALTP/OLAP application development using Oracle ( PL/SQL Functions, Procedure and packages)
• 15+ years of strong experience on design, development and maintenance of STAR, SNOWFLAKE schemas, Fact Tables, Dimensional Tables ( Type 1, Type 2, Type 3), and Surrogate Keys etc.
• Strong Communication, Team Management and Client interaction skills
• Ability to handle multiple projects
• Skills in Big data and Hadoop

TECHNICAL SKILLS:

Operating Systems: Ab Inito Co>Op 2.11 /2.13 / 2.14 / 2.15/ 3. x, Sun SolarisHP - UX 11, UNIX, AIX, Linux Redhat: HardwareSun Sparc Stations, Sun Solaris, HP Servers

Database: Oracle7.x, Oracle 8.x, Oracle 9.x, Oracle 10g, Teradata V2R6, Teradata 12:

Languages: Unix KShell, SQL, PL/SQL, Pro*C, C, Java: Applications /

Packages: All Fusion Harvest Change Manager, Clear Case Version ControlControl -M, Autosys, SQL Navigator, TOAD, BTEQ, MLoad, FastLoad, FastExport, TPump, OLELoad and Parallel Transporter

ETL / BI Tools: Confidential GDE 1.11, 2.11, 2.13, 2.14, 2.15, 3.x, Data Profiler, Confidential EME,BRE,ACE, Conduct >IT, Express>IT, Business Objects (5.1)

PROFESSIONAL EXPERIENCE:

Confidential, NJ

Architect/ Tech Lead Consultant

Environment: Co>Op 3.1.5.5 / GDE 3.1.7.4 ), Conduct>IT, ACE, BRE, Ops Console, Oracle 11 G R2, UNIX

• Provided architectural framework for high visibility, very critical time bound compliance global project
• Provided architectural diagrams and technical documents for the project
• Interacted with clients senior management and stake holders on various aspects of the project
• Selected appropriate tools and techniques for the project
• Guided BSA in gathering requirements and finalizing file layouts to match the target data model
• Interacted with data modelers, DBAs and various testing teams
• Estimated the file system and table spaces requirement
• Assisted ETL application development and led the 20+ member data acquisition development team
• Provided guidance for resolving various technical challenges during the project
• Co-ordinated on-site and off-shore development activities
• Developed of critical components and common graphs
• Used PDL and meta programming extensively
• Provided research and analysis skills for root cause analysis for defects and for accommodating new requirements
• Supported the team in deploying the code base in multiple test environments
• Developed and tested ACE templates for Deposits, Adjustments and Corrections product processors

Confidential, Herndon, VA

Sr. Confidential Consultant

Environment: Co>Op 3.0.5.3/ GDE 3.1.1 ), Oracle, Unix

• Designed and developed ETL applications for Confidential Credit Data Repository
• Developed Metadata Layer for Credit Data Repository ( CDR ) and National Underwriting Center (NUCDM )
• Framework design / development, Application re-engineering, end-to-end ETL design.
• Dynamic, metadata driven ETL application development using PDL and Metaprogramming
• ETL / Confidential process optimization
• Manage defect, implement enhancements and perform SDLC procedures and standards
• Requirement analysis, Data analysis

Confidential, Jersey City, NJ

Sr. Confidential Consultant

Environment: Co>Op 3.0.5.3 / GDE 3.1.1), Continuous Flows, XML data processing

• Worked with “ Confidential Corporation Team” as an Confidential technical resource
• Design and develop dynamic, re-usable, complex Confidential applications for money transfer functionality
• Handled reformatting having 1000s of lines of code for data in various formats like XML and IDOC for highly complex business rules
• Co-ordinated on-site and offshore development activities managed deployments in various test environments

Confidential, Richmond, VA

Sr. Confidential Lead Consultant

Environment: Co>Op 1.15,2.10.15,2.14 / GDE 1.10.9.3,1.14.27,2.15.8 ), Oracle, PL/SQL,SQL Loader, Teradata, UNIX ( Kshell ), Linux, Control-M

• Designed, Developed and implemented dozens of applications in credit card, bank, mortgage and auto finance
• Handled financial, customer contact, customer profile, enterprise customer view projects
• Part of Helix (UNISYS billing system to TSYS migration), Chevy Chase and other Bank integration projects
• Chevy Chase Bank Integration DW projects - Lead role in designing the solution for many projects. Played the key role in supporting QA during mock testing phases. Performance tuned many graphs during the conversion process.
• Involved in converting many applications from forklift to the Bank Data Warehouse.
• Designed and developed ‘Return Check processing’, ‘BILLPAY’, ’Equipment Leasing’, ‘COAF Campaign’,’AML’
• Worked on ‘Customer Profile’ project for creating a consolidated view of the customer pulling information from various databases. It involved creating lot of complex BTEQ SQL scripts to consolidate customer information about payment, charge off, bank footprint etc.
• Participated in a lead role for Customer contact DW applications during Helix project 2004-2006 . Provided support during mock testing and implementation.
• Assisted the team in adopting systematic development of the projects by deciding on the load tools and wrapper templates, estimation of file system space and table spaces.
• Provided solution for various technical issues during development, implementation and maintenance of the projects
• Participated in code reviews.
• Conversion of existing data into the new environment was a challenge due to the huge volume of data needs to be processed in various implementations. Played a key role in coordinating the whole team and suggesting various solutions during the time critical implementations.
• Provided support for DW applications during periodic Teradata upgrades
• Confidential Lead ETL Consultant for the project ‘Next Generation Banking Project’ 2003-2004 for 10+ member development team. Work involved dealing with business customer, managing the development resources and dealing with NCR Teradata DBAs, Confidential and Confidential leadership.
• Prepared functional and technical documents for projects
• Mentoring junior team members
• Coded extensively in PL/SQL and korn shell for the projects in collections group.
• Saved lot of time and effort by automating testing process for the periodic changes to the decision engine. This involved extensive korn shell script coding.

Confidential, Charlotte, NC

ETL Architect / Tech Lead

Environment: AIX, Teradata V2R5, Confidential GDE 1.14.13.3 and Co>op 2.13.1, EME, Shell scripting, BTEQ, All Fusion Harvest Change Manager, Autosys

• Designed and developed for ETL jobs using Confidential for customer master functionality
• Provided architectural and technical design documents
• Single point of contact for solving environment issues and coordinating with DBAs and EME admins
• Led the 10+ member ETL team
• Participated in code reviews
• Responsible for scheduling the jobs in autosys
• Coordinated the migration of the projects into testing and production. Responsible for packaging the sandboxes and migrating into test for all test cycles for all EME projects
• Mentoring junior team members