SUMMARY OF QUALIFICATION

• Applications Architect with more than 9 years of experience in Software Development and Technical Consulting
• SpecializeinData warehouse applications ( ETL and Reporting)
• Understanding of Pharmaceutical safety systems and different life cycles of software development project

Languages : Perl, SQL, PL/SQL 
ETL Tools : Informatica 5.1/6.2/ 8.1, BO Data Integrator 6.5/ XI R2 Data Services, SSIS
Reporting Tools : Business Objects XI R2/R3 Universe Designer, Webi, Xcelsius and Desktop Intelligence, Cognos 8 Framework Manager, and Report Studio
Data Modelling Tools : Erwin 3.5 and 4.1
RDBMS : Oracle, SQL Server

EXPERIENCE 

Confidential, Applications Architect, New York Jun 2004 - Present

Daiichi ARISg Safety Reporting
The client had an Adverse Event Management System (ARISg) that required a flexible reporting infrastructure and custom reports for Signal Detection and other analysis to meet regulatory requirements, and system management reports to monitor operational processes. Intrasphere was involved in the multi phase project to assess the current state reporting architecture, perform a gap analysis against the reporting requirements and implement the recommended approach. The technologies used in the project were Business Objects XI R2/R3, Business Objects Data Services.

• Proposed options and recommendations for architectures and approaches
• Architected the reporting solution involving the Adverse Event Management System (ARISg).
• Designed & Developed reporting modules using Business Object Universe and Webi using the ARISg database
• Designed & developed the security module using Business Objects CMC.
• Define Business Objects XI R 3 installation and configuration scripts, and advise client and other vendors during execution
• AE data profiling and data analysis in ARISg database.
• Proof of concept using Business Objects Universe, Webi, Desktop Intelligence, Xcelcius and BO Data Integrator XI

Confidential,Argus Insight Safety Reporting
This initiative involves creating set of Cognos Reports for the Argus safety system. The technologies used in the project were Cognos 8 and Oracle SQL.

• Designed & Developed Cognos Reports using Report studio and Framework Manager
• Data Profiling and Data Analysis in Argus Insight databases
• Design migration strategy for the Cognos Reports
• Created template for the installation qualification (IQ) scripts for the Report migration
• Review IQ/OQ scripts

Confidential,
This initiative involved creating global clinical operations reporting metrics system using the Microsoft set of Business Intelligence (BI) tools. The solution consists of the clinical data marts which is populated from various Oracle source systems and excel spreadsheets. The data mart is used by the SSAS cubes and the Microsoft office tools. The technologies used in the project were SQL Server 2005, SQL Server Integration Services, SQL Server Analysis (SSAS) and Oracle SQL

• Technical project lead, QA of technical deliverables, hands-on report developer
• Worked closely with the senior executive management to validate and refine the user and functional requirements
• Developed series of prototype for the solution
• Proposed options and recommendations for architectures and approachesEstimated work effort and participated in project planning
• Managed the development team
• Transition Activities

Confidential,
This initiative involves migration of the data warehouse and datamart for the adverse event system Arisg from one client to another. The technologies used in the project were Informatica PowerCenter 8.1 and Oracle PL/SQL.

• Coordinated with various technical groups, including the development team, Corporate IT, and external technology vendors
• Prepared migration and test strategy
• Analyzed and modified the necessary changes in the Informatica ETL process.
• Estimated work effort and participated in project planning
• Prepared and maintained the technical documentation for the project
• Managed the development team consisting of DBA and PL/SQL developers

MPI - ERS 
This initiative involves defining and building tools around end-to-end reporting system for a Pre-Clinical trial system. The technologies used in the project were Business Objects Data Integrator XI and Oracle 10g PL/SQL

• Estimate work effort and participate in project planning
• Designed and Developed the ETL module using Business Objects Data Integrator XI and Oracle 10g PL/SQL and Provantis Pre-Clinical SystemDesigned and Developed the framework for report formatter using PL/SQL
• Integration of various ETL modules into one system
• Prepared and Maintained the technical documentation for the project
• BO report development

Pfizer- Pfizer Capacity Database (CDB) 
This initiative involved defining and building tools around end-to-end application performance and capacity management. The client engaged Intrasphere to design, build, test, and deploy the Capacity Database (CDB) as a tool to integrate key infrastructure source systems to provide for performance and utilization reporting. The technologies used in the project were Informatica 6.2, Business Objects and Oracle 9i.

• Manage the ETL track involved in building the Capacity Database (CDB)
• Estimate work effort and participate in project planning
• Prepare and Maintain technical documentation for the project
• Participated in BO Universe design and development

Pfizer-CIT Datamart
Project involves creation of a consolidated Data Mart and Business Objects analysis & reporting tool to support IT operations. The technologies used in the project were Business Objects Data Integrator 6.5 and Oracle 9i.

• Designed and Developed the mapping in Business Objects Data Integrator 6.5 and Oracle9i to populate the consolidated Data mart
• Preparined and Maintainined the technical documentation for the project
• DBA activities
• Developed and run demos

Pfizer-Medical Data Mart (MDM)
Project involves creation of a Data Mart and Business Intelligence application to support the analysis and reporting of clinical trial financials, schedule and resource data for PGP Medical Teams and Development Operations. The technologies used in the project were Informatica 6.2, Business Objects and Oracle 9i.

• Lead the ETL track involved in Design and Development of mapping in Informatica 6.2 and Oracle9i to populate the Data mart from Datawarehouse
• Standardize the methodology for the global distributed development for the ETL component
• Installation and setup of Informatica Powercenter in Windows environment
• Standardize the build and release process
• Involved in the building the BO Universe classes and objects

UBS  Centralized Accounting Logic (CAL) 
Centralized Accounting Logic, CAL, is an initiative undertaken by the Global General Ledger (GGL) a division of UBS investment bank. The project aims to leverage the advances in ETL tools technologies to significantly reduce the trading feeds processing. The technologies used in the project were Informatica 6.2 and Oracle 9i

• Development of Informatica mappings using predefined flows to reduce the trading feeds processing
• DBA and QA activities

Cingular - Sales Portal

• Managed the four-member team for implementation of Database Layer track

Nissan - Nissan Z & Nissan Spanish 
This initiative involved enhancing the existing Nissan USA site to support Spanish content.

• Team Lead for the three member infrastructure team
• PL-SQL coding to migrate translated Spanish data into various environments.
• DBA activities and managing build & release process
• Assessment involving Informatica 5.1
• Partner communication

• Part of development team for implementation of Content Display system using Interwoven and Perl. Franklin Templeton - Enterprise Integration The project involved enterprise application integration and creation of Global Database to reduce the duplication of data and business processes. The technologies used in the project were Informatica 5.1 and Oracle 8i.
• Part of five-member design team for requirement gathering and database design
• Part of development team for implementing ETL mappings in Informatica Powercenter 5.1
• Part of client side UAT team for issue resolution and interacting with third parties

• Part of two member CES (content entry system) team to design CES using Vignette and ASP for CSAA
• Designed and implemented ETL Engine for the web site using Perl.
• Designed and implemented data transfer using Replication on SQL Server 7.0

LLOYDS

• Implemented Content Display and Content Entry Module using TCL in Vignette 5.6

Bachelors of Technology