SUMMARY

• Responsible, self - motivated and organized team player with demonstrated talent for deploying IT and organizational skills toward Analyzing, Designing, Implementing and streamlining complex IT processes for improvement opportunities
• 5+ years of program management experience in multiple software product cycle driving features from initial planning and design, to implementation and release
• Experience in working with the Business and Senior IT leadership to identify and establish information on requirements, develop and implement data warehouse strategies that utilize data marts and/or data warehouse systems to enhance and manage the business processes
• Strong creative, analytical and critical thinking abilities and Strong technical resolution skills, with large scale distributed computing systems
• Ability to lead the effort to design and build a reliable reporting, monitoring, debugging, and alerting system
• Vast experience of working in data management including data modeling, data analysis, data validation and data mapping
• Ability to write simple, clear scenarios, problem statements, requirements, proposed solutions and specifications
• Experience with Data Warehouse modeling and building data marts for reporting with good understanding of end to end ETL Process
• Experience in creating relational and dimensional Logical Data Models using ERWIN, Sybase Power Designer and ER Studio
• Extensive experience in analyzing Data and creating STMs in Data warehouse system for various reporting systems
• Very good experience using MS SQL server 2005/2008/2012 and Oracle 10g/11g as back end for IT solutions development
• Experience in loading high volume data and worked extensively with data migration/conversion, data cleansing and ETL processes
• Involved in reviewing Test Plan, Test Scripts and Test Cases based on Design document and User Requirement. Participated in User Acceptance Testing and training of end users.
• Coordinated and prioritized outstanding defects and system requests based on business requirements. Acted as a liaison between the IT team and business management team to resolve any conflicts in terms of requirements.
• Interacted with all levels of the project development team, from end users to Software Architects, Development Lead, Database Administrators and QA leads.
• Ability to collaborate effectively with a large number of partners and customers with good communication skills

TECHNICAL SKILLS

Operating Systems: MS Windows 7/8, XP, 2000 & NT, Windows Server 2007, MS DOS, Linux.

Languages: SQL, PL/SQL, Transact-SQL, Unix Shell script

Databases: MS SQL Server 2005/2008/2012 , Oracle 8/9i/10g/11g, MS-Access 2000

Tools: Erwin, ER Studio, MS VISIO, Sybase Power Designer, MS Project, MS Office, SQL Server Management Studio, TOAD.

Reporting Tools: Business Objects, Cognos

Others: Informatica Power Center, SQL*LOADER, TOAD, PVCS, CVS, OWB, FTP, Putty, Informatica Data Quality.

PROFESSIONAL EXPERIENCE

Confidential, Redmond, WA

Technical Program Manager

Responsibilities:

• Reviewing Business requirement Documents and analyzing legacy systems.
• Interacted with the SDs to analyze the business process and gathered the requirements to fulfill their work in progress Reporting and Forms/UI business needs.
• Conducting design review meetings making sure all the requirements are covered in the development project scope.
• Developed strategies for improving data comprehensiveness, richness, accuracy and freshness and platform reliability
• Applied statistical techniques to content quality and performance metrics
• Wrote requirements for the designing data marts that were used as the source for the various systems in the company.
• Prepared the High level scope and the conceptual Diagram for the requirements in scope.
• Performed analysis on a data warehouse platform for data integrity and data validation.
• Performed Data Analysis and Data validation of Partner Feed Data by using Informatica Data Quality.
• Managed dependencies across multiple internal partners
• Performed Analysis and design of implementing a Facts and Dimensions using Dimensional Data Modeling.
• Drive Technical design of features in business intelligence, monitoring and alerting
• Provided solution for design and architecture on ETL.
• Performed Data Modeling by creating logical and Physical models of the database system using Erwin/ER Studio.
• Created Data Flow Diagrams and Process flow diagrams for various load components and various other processes that required transformation.
• Prepared the Functional Requirement Documents for providing the design details on the requirements.
• Created the Auditing, Logging and the Requirement Traceability Matrix for the platform.
• Used MS Visio to represent system under development in a graphical form by defining use case diagrams, activity diagrams and workflow diagrams.
• Participated in review meetings with development, QA and data management team to communicate business requirements.
• Worked closely with quality assurance and development teams to clarify and understand the functionality to resolve issues and provide feedback in terms of the test matrices and to nail down the bugs.
• Participated in System Test reviews, development design reviews and usability studies.

Environment: Erwin Data Modeler, ER Studio, MS Visio 2010, SQL Server 2008/2012, Informatica Data Quality 9.0.1, MS Project, MS Excel, MS SharePoint, MS Visual Studio 2010/2012

Confidential, Redmond, WA

Business Program Manager

Responsibilities:

• Reviewed and analyzed legacy systems and promulgated new System of Origin
• Created new canonical logical data models for key MDM data items and their relationships
• Created canonical data dictionaries of MDM data items and attributes
• Documented the new authoritative data values and CRUD matrices
• Created plan for applications to adopt new authoritative data values published from System of Record
• Created data value mappings to the authoritative data values for each adopting application
• Created data quality assessment reports in excel
• Created Data Flow/Process flow diagrams for various load components and other processes that required transformation.
• Prepared the Documents for providing the design details for data migration and conversion.
• Used MS Visio to represent system under development in a graphical form by defining use case diagrams, activity diagrams and workflow diagrams.
• Facilitate JAD sessions to understand information requirements

Environment: ER Studio, MS Visio 2010, SQL Server 2012, MS Project, MS Excel, MS SharePoint, MS Visual Studio 2010.

Confidential, Redmond, WA

Technical Program Manager

Responsibilities:

• Reviewing Business requirement Documents and analyzing legacy systems.
• Interacted with the SDs to analyze the business process and gathered the requirements to fulfill their work in progress Reporting and Forms/UI business needs.
• Conducting design review meetings making sure all the requirements are covered in the development project scope.
• Developed strategies for improving data comprehensiveness, richness, accuracy and freshness and platform reliability
• Applied statistical techniques to content quality and performance metrics
• Wrote requirements for the designing data marts that were used as the source for the various systems in the company.
• Prepared the High level scope and the conceptual Diagram for the requirements in scope.
• Performed analysis on a data warehouse platform for data integrity and data validation.
• Performed Data Analysis and Data validation of Partner Feed Data by using Informatica Data Quality.
• Managed dependencies across multiple internal partners
• Performed Analysis and design of implementing a Facts and Dimensions using Dimensional Data Modeling.
• Drive Technical design of features in business intelligence, monitoring and alerting
• Provided solution for design and architecture on ETL.
• Performed Data Modeling by creating logical and Physical models of the database system using Erwin/ER Studio.
• Created Data Flow Diagrams and Process flow diagrams for various load components and various other processes that required transformation.
• Prepared the Functional Requirement Documents for providing the design details on the requirements.
• Created the Auditing, Logging and the Requirement Traceability Matrix for the platform.
• Used MS Visio to represent system under development in a graphical form by defining use case diagrams, activity diagrams and workflow diagrams.
• Participated in review meetings with development, QA and data management team to communicate business requirements.
• Worked closely with quality assurance and development teams to clarify and understand the functionality to resolve issues and provide feedback in terms of the test matrices and to nail down the bugs.
• Participated in System Test reviews, development design reviews and usability studies.

Environment: Erwin Data Modeler, ER Studio, MS Visio 2010, SQL Server 2008/2012, Informatica Data Quality 9.0.1, MS Project, MS Excel, MS SharePoint, MS Visual Studio 2010.

Confidential, Indianapolis, IN

BI Lead

Responsibilities:

• Oversight of design implementation, providing assurance that key requirements are preserved and that gaps are understood and communicated to stakeholders as appropriate.
• Interpreted logical data models for Business users to determine common data definitions and establish referential integrity of the system.
• Worked with client staff to develop application requirements and corresponding data model to support client inventory and expansion of same to support license tracking.
• Designed and Developed database to Oracle 11g using Application Express to implement new, improved version of WDBS inventory with ability to support licensing.
• Prepared a data model using Sybase Power Designer with client team for one of their existing Database inventory system (Topology).
• Provided guidance regarding the use of data warehouse system, capability of systems to deliver information and subject matter expertise regarding current systems and emerging technology
• Analyzed and revamped the existing 3NF and Star Schema model to suit the additional and new requirements.
• Communicated with customers effectively and address or escalate their request and/or concerns in timely fashion
• Developed and implemented Exception handling Strategies in the oracle PL/SQL code.
• Oracle 11g DB Console and Explain Plan techniques used for Performance tuning.

Environment: Oracle 11g R2, TOAD 10, Sybase Power Designer 12.5, Oracle Application Express 3.2, MS Project, MS Visio, MS Visual Studio.

Confidential, Rancho Cordova, CA

System Analyst

Responsibilities:

• Interaction with business to collect and understand Requirements.
• Interpreted logical and physical data models for Business users to determine common data definitions and establish referential integrity of the system.
• Design & Architecture of reference tables to capture the data
• Responsible for Database (Oracle 10g) Query tuning and validation of Data.
• Developed and implemented Exception handling Strategies in the oracle PL/SQL code.
• Review and approve technical PL/SQL Procedure, Trigger, Function, Package creation for validating the data.
• Defined Oracle PL/SQL Best Coding Practices and Standards.
• Involved in Performance tuning of code/application by fine tuning SQL queries caching techniques.
• Debugged PL/SQL Packages, and stored procedures.
• Exposure to tool-driven and PL/SQL-coded ETL
• Use OWB tools for ETL process and Mapping, design, deployment and populating tables using OWB mapping, process flows, ETL procedures and OWB transformation.
• Execute full system, interface, and end-to-end testing and Manage defect-tracking process.

Environment: Oracle 10g/11g, TOAD 9, OWB 10, SQL Plus, PL/SQL, UNIX (Shell script), MS Project, Sarena VM, OMB+.

Confidential, Oakland CA

Data Conversion Consultant

Responsibilities:

• Developed Oracle packages, procedures, triggers, functions (PL/SQL) to ensure conformity, compliance with standards and lack of redundancy, translates business rules and functional requirements.
• Reverse engineering of legacy system DBs using Erwin.
• Created the related business process documents.
• Responsible for data quality analysis and validation of Data.
• Design & Architecture of staging tables to capture the data
• Developed and implemented Exception handling Strategies in the oracle PL/SQL code.
• Review and approve technical PL/SQL Procedure, Trigger, Function, Package creation for validating the data.
• Defined Oracle PL/SQL Best Coding Practices and Standards.
• Involved in Performance tuning of code/application by fine tuning SQL queries and creating indexes as well as caching techniques.
• Performance tuning techniques like TKPROF, SQL TRACE & Plan tables used.
• Use of OWB for EDEX (Electronic Data Exchange) between client (DIR) and state vendors.

Environment: Oracle 10g, TOAD, OWB, MySQL, SQL, Shell script, Erwin, PL/SQL,UNIX, CVS, WinSCP, Cognos.

Confidential, Chicago IL

Data Warehouse Analyst

Responsibilities:

• Performed analysis, review, and estimation of client requests; prepared and reviewed system requirements and documentation
• Produced functional specifications and led weekly meetings with developers and business units to discuss outstanding technical issues
• Wrote Functional requirements for designing data marts that were used as the source for the various reporting systems in the company.
• Used Informatica to develop ETL to extract from external data source (Oracle, Excel file)
• Conducted JAD Sessions with the subject matter experts, stakeholders and other management teams in the finalization of the User Requirement Documentation.
• Performed Data Modeling using Erwin by creating logical models of the database system.
• Performed Data Analysis and Data validation by writing complex SQL queries using TOAD against the ORACLE database.
• Worked with the DBA and developers to identify bottleneck and performance issues of the ODS population.
• Created Data Flow Diagrams and Process flow diagrams for various load components like FTP Load
• Used MS Visio to represent system under development in a graphical form by defining use case diagrams, activity diagrams and workflow diagrams.
• Conducted review meetings with development, QA and data management team to communicate business requirements.
• Code review for Data Extraction, Data Mapping and Data Conversion for various application and processes.
• Worked closely with quality assurance and development teams to clarify and understand the functionality to resolve issues and provide feedback in terms of the test matrices and to nail down the bugs.
• Engaged with onsite/off site team model to fulfill the business needs.

Environment: MS-Office, MS-Visio, Informatica, Oracle 9i/10g, Teradata, TOAD, Erwin, MS Access, MS-SQL, SQL, PL/SQL, UNIX.

Confidential

Programmer Analyst

Responsibilities:

• Involved in performance testing of new and existing process flow
• Directed management on some clinical engineering projects: e.g. clinical device and system implementation including evaluation, contract development, receipt, installation and training.
• Established departmental policies and procedures in accordance with approved recognized hospital standards.
• Design the Hospital Management System for the day to day inventory purpose.
• Acted as Direct Liaison to hospital medical staff concerning all biomedical activities.
• Planned and implemented PM and QC procedures of medical equipment.
• Took active part in training programs of equipment.
• Reported to project biomedical supervisor.

Environment: Windows 2000 Confidential Word, Confidential Project, Confidential Excel, SQL.