Data Warehouse Developer Resume
SUMMARY
A senior professional, with 15+ years of experience in progressively more responsible and challenging projects and positions. Proven record of managing, developing and delivering Stand-alone and Enterprise wide software solutions. Innovative problem solver, ability to see the business and technical sides of the problem. Exceptional combination of technical and leadership acumen with strong interpersonal skills
PROFESSIONAL HIGHLIGHTS
- Developed and deployed AA (Auto Attendance) a .Net application globally to record ILT (Instructor-led Training) completions and marks for an Enterprise LMS, using a proximity scanner and saving Pfizer$800K per year in operational costs
- Built Audit tracking with reporting capabilities on a non compliant version of LMS (Learning Management System) rendering it audit compliant and sustaining the influx of $1.5 million per year in project funding
- Managed decommissioning of legacy LMS systems globally and large-scale migrations of learning data from Pfizer acquisitions, including Wyeth & King Pharmaceuticals
- Member of Microsoft's largest known Enterprise Project Management (EPM) Implementation team
CAREER SUMMARY
Manager
Confidential, Feb'08 ~ Jan'12
Responsible for managing all technical aspects of ELS's seven applications includingTotalLMS(called P2L/Power2Learn internally) a validated COTS LMS application with 190K+ active users spread across 60 Pfizer sites worldwide. Oversaw application installations, upgrades, database and server capacity planning, deployment and maintenance of inbound and outbound interfaces, content management, application support and error resolution.
- Created HLDS (Historical Learning Data System) with over 500K+ Active and Inactive users which serves as a repository for complaint learning data retention with Legal and Audit compliance reporting capability
- As part of Enterprise wide ATS (Adapting To Scale) initiative led the team that successfully decommissioned 14 legacy LMS systems globally by migrating over 30 million+ learning completions and 450K+ learning activities from other internal LMSs and Pfizer acquisitions, including Wyeth and King Pharmaceuticals
- Developed and deployed globally a .Net application - LARS (Learning Administration Request System) to enable users to request application data entry and reporting services from CLASS (Centralized Learning Administration Shared Service)
- Deployed BOXcelcius Manager Dashboard to 21K Pfizer managers across 60 countries providing Learning compliance metrics, KPIs (Key performance Indicators) across all levels of functional manager hierarchies, Business Units, Countries and Priorities
- Proactively managed systems development, implementation and risk via the use of SDLC
- Provided delivery management to ensure customer satisfaction and reference-ability
- Collaborated with global partners, stakeholders, L & D (Learning and Development) managers cutting across functional & organizational hierarchies to define Catalogs, naming conventions for learning activities, configuring the LMS application, eliciting reporting needs etc.
- Hired, mentored & led high performance Onsite and Offshore technical teams
- Managed SLAs to ensure Vendor compliance, delivery of hotfixes, application upgrades, ongoing support etc.
Business Solutions Architect/Technical Lead
Confidential, Mar'05 ~ Feb'08
Analyzed technology and business challenges and provided enterprise solutions. Converted key strategic objectives into governable and actionable designs and roadmaps. Consolidated processes to reduce operational costs by 15%. Set up onsite/offshore delivery model for the ETL development team. Developed a comprehensive reporting solution to replace out of the box COTS reporting solution
Developed Inbound and Out bound interfacesto capture user demographics from authoritative sources into and out of the application maintaining 99.9% application and reportinguptime
Drafted SOW, outsourcingSLA with Metrics definitions and Operating Principles for outsourced development/QA work
Mitigated failures dynamically to ensure continuous operation of application for all customers, while running 10 dependent jobs across disparate sources on a nightly basis
Implemented downstream views to support 12+ major applications including Career development, Sales Force Training and Software access management across Pfizer
Integrated Learning Kiosks setup across various Pfizer locations to record completions automatically into the LMS on a daily basis
Designed and developed a DWBI solution for the ELS that included building a Data Mart and the supporting ETL feeds. Oversaw the development of the BO (Business Objects) Universe along with 10 validated and 17 non-validated reports with ad-hoc reporting capability
Senior Consultant/Global Data Manager
Confidential, Dec'03 ~Mar'05
Built BI reports to support operational and decision support systems used by Management. Managed a team of 6 developers to successfully build and maintain Project Portfolio Reporting Data mart. Operational-level responsibility for information management activities relating to the capture, maintenance, and dissemination of data. Led the APV (Artemis ProjectView) Enterprise data definitions standards working group to setup Enterprise - Quality data definitions consistent with business processes
Developed OLAP Cubes in EPM to report on Projects, Milestones & Resource convergence
Migrated data from APV into EPM (Enterprise Project Management)
Developed SOPs (Standard Operating Procedures) for data handling and archiving
Data warehouse Developer
Confidential, Mar'00 ~ Nov'03
Structured the POS (Parts ordering System) data warehouse for rapid online queries and summaries. Developed Logical and Physical data models to capture current/future state data elements. Performed archiving, analytics delivery and data improvement procedures
Remodeled the reporting data mart to increase productivity by 25%. Conducted performance tuning of SQL procedures and ETL feeds.
Trained end users to use full client BO for analysis and reporting
Developed complex reports using multiple data providers, user defined objects, aggregate aware objects, charts, and synchronized queries.
Positions held prior to 2000 -
Software Developer Web Developer Programmer Analyst
Commonwealth Bank of Australia, Australia Cybernath Inc, Australia Turnkey Software Solutions, India
TECHINCAL PROFICIENCIES
TotalLMS * Informatica * Oracle* SAP Business Objects * Crystal Reports * SQL Server Reporting Services Tools * Cognos *
SQL Server * SharePoint * Erwin * Visual Basic * ASP.NET * PL/SQL * C * C++ * HTML * UNIX
Bachelor's degree in Electronics and Communications Engineering
Diploma in Systems Management