SUMMARY:

• Highly knowledgeable, business savvy and resourceful IT Professional with extensive experience in Data Warehousing, Data Integration and ETL competencies.
• Proven expertise designing and developing Information Services Data Integration solutions. Major areas of business focus include in govt, public and private sector with key emphasis in Health care, Distribution, Finance, Telecommunications, Supply Chain, Compliance and Pension management.

TECHNICAL SKILLS:

Datawarehousing/BI: Informatica, Hyperion, SSIS, DTS, SAP BW, Microstrategy, Qlikview

Databases: Oracle, DB2/UDB, SQL - Server, Sybase, Essbase, MYSQL, IBM Netezza, EDB, Teradata Aster

ERP: SAP R3/ECC 6.0 (knowledge in SD, MM & PI)

Project Management: MS Project, RPM (Rational), Clarity/Portlets, Open Office

DB modeling: Power designer, Visio, ERWin, Deft tool n MAC, Designer 2000.

Web Languages: HTML, JSP, Java,.NET

Source Management: Visual Source safe, CVS, SVN

Management Tools: MS Office, MS Visio, MS SharePoint, Google Office, WorkFront

Other DB Clients: AQT,TOAD, SQL Navigator, PL/SQL editor

Methodologies: Client/Server Architecture, Waterfall, Agile, Scrum

PROFESSIONAL EXPERIENCE:

Confidential

Datawarehouse Architect/ETL Developer

Responsibilities:

• Working on multiple DW/BI projects with Fed, USAID in managing their supply chain and health care areas.
• Design ETL framework for healthcare supply chain & Develop Datawarehouse/ETL solutions on SQL Server, Aster, Postgres, Informatica, and Microstrategy.
• Architect the cloud environment for setting up of Linux and Windows VM’s.
• Project management and coordination activities between multiple geo-locations.
• Setting up & monitoring cloud environment scanning and auditing.
• Worked with third party API’s to fetch data from databases to web interfaces/applications.
• Involved in Requirement gathering, Analysis, data modeling & design.
• Created a strong focus on testing (unit, regression), design and architecture reviews leading to a significant improvement in the quality of deliverables.
• Managing version control/FTP/security/auditing on Virtual machines
• Installation, Configuration & Administration of Informatica (multiple versions)
• Used Perl/Linux as scripting language
• Working with an Agile, scrum methodology to ensure delivery of high quality work with every 2 weeks iteration.

Confidential

ETL Solution Architect

Responsibilities:

• Project & Delivery management of BI solution for Confidential ’s divisional unit using Agile methodology.
• Design database and dashboard architecture along with analytical and reporting teams
• Formulate the solutions structure that balances the goals of the business requirements and the constraints on the project.
• Coordinate with IT & business and work develop test and QA plans.
• Define data model/data warehouse standards and templates.
• Developing and maintaining detailed project plans.
• Offshore development management, mentoring,, coordination with all levels of technical & management staff

Confidential

Project Manager

Responsibilities:

• Project/Delivery management of the trade fails system using Agile methodology.
• Managing Global teams in Tokyo, Singapore, London, India and NY.
• Design, Development and implementation of the customized solutions for settlement and clearance of trades.
• Working with the Architecture and Functional teams on technical and functional requirements.
• Defining test unit cases with development teams.
• Management presentations
• Offshore development management, mentoring,, coordination with all levels of technical & management staff
• Direct reporting to Director, VP in PMO.

Confidential

Senior Project Manager

Responsibilities:

• Delivery management of the customized solution in Pension Management.
• Successful implementation of Pension management solution at Motion pictures, Hollywood.
• Worked with onshore & offshore teams on design, development and implementation of the product.
• Worked with the Architecture group on the upgrade of the product framework and making sure all the development teams based in India and US are well trained on these.
• Leading data conversion activities.
• Introduced and implemented Agile Methodologies such as Scrum and Test Driven Development (TDD)
• Implementing COE for IT development group.

Confidential

Application Architect

Responsibilities:

• Architected Interfaces/Conversions between Legacy Mainframe and SAP.
• Worked with Integration and BI team to review SAP interfaces and conversions.
• Managed onshore and offshore Data Integration and Business Intelligence teams to support organization’s Enterprise Data warehouse activities in Informatica and Microstrategy.
• Architected, designed ETL methodologies and COE processes in the organization.
• Won VIA monthly s three times and got nominated for yearly VIA reward multiple times.

Confidential

Project Lead

Responsibilities:

• Worked on global trade solutions with commercial and government organizations.
• Designed international trade and export compliance solutions.
• Implemented compliance related software’s at various client sites
• Designed ETL (Informatica) Architecture & Processes to support enterprise wide Datawarehouse.
• Designed & implemented RFC interfaces between R/3 and external applications.
• Supported onshore/offshore database operations.