SUMMARY:

Over 12+ years of Information / Data Management (Integration/Business Intelligence/ETL) Implementation experience of which she has been a Manager for 3 years with a verifiable track record of managing complex IT projects. Provide technical expertise in the area of business intelligence and data integration software development. Practiced clarifying business requirements, performing gap analysis between goals and existing procedures/skills sets and designing process and system improvements to increase productivity and reduce costs. Strong technical understanding of ETL Architecture & Design, data modeling, design and architecture principles and techniques across master data and OLAP / OLTP architectures. Delivered a portfolio of data management / BI projects on time, within budget, while meeting expectations. Planned, directed and coordinated project execution activities in a distributed organization structure according to an established SDLC. Established and managed project financials. Verified project goals are accomplished and in line with business objectives.

TECHNICAL SKILLS:

Data Modelling Tool: Erwin r7.1 - 9.6

OLAP Tools: Microsoft Analysis Services, Business Objects, Microstrategy

ETL Tools: IBM Infosphere Enterprise Edition DataStage v 9.2/9.1/8.7, IBM InfoSphere Information Analysis v 9.1, IBM InfoSphere Quality Stage v 9.1

ERP/CRM: SAP BW, SAP Hana, PeopleSoft Financials v 9.2

MDM: IBM Initiate MDM Server v11

Programming Languages: SQL, Shell Script

Database Tools: Microsoft SQL Server 2000/2005/2008 , DB2, Oracle 12c/10g/9i, Mainframes, Natezza

Utility Tool: Toad, SQL Developer, TSO, Brio, SquirrelSQL

Packages: Microsoft Project 2010, Visio, Microsoft Office Suite

Operating Systems: Microsoft Windows 2000/XP/Vista/7 and UNIX/LINUX

PROFESSIONAL EXPERIENCE:

Confidential

Project Manager

Responsibilities:

• Responsible to drive the process to deliver effective business intelligence solutions for updating existing data marts by working closely with business owners, architects, data modelers, developers and quality assurance for enhanced reporting needs.
• Acted as Scrum Master for the reporting teams with a focus on guiding the teams towards consolidating existing monthly reports of 6 business units from approx. 168 reports to 109 reports.
• Assisted with prioritization and resolution of source data, data Lineage, conversions & transformation, aggregations & roll up for new and existing data/reports.
• Assisted with internal and external communication, improved transparency, and radiated information.
• Engaged with other Scrum Masters to increase the effectiveness of the application of Scrum in the organization.
• Worked with the entire business intelligence team and stakeholders to prioritize, plan and execute on the project roadmap for the analytics platform.
• Developed comprehensive project plan consisting of milestones, detailed deliverables, resource estimates, and schedules for each major phase of a project.
• Proactively identified, communicated and managed project risks and issues. Escalated to leadership and project sponsors as appropriate
• Interfaced with Program Management Office to ensure project goals and requirements are being met
• Analyzed scheduling, estimating, costing needs and determined resources needed to meet the objectives.
• Lead the team in the analysis of the as - is and to-be reports and data marts, problem-solving and the build of the same.

Confidential

Tech/Data Manager

Responsibilities:

• Performed IT project planning, including identifying and developing goals, strategy, staffing, scheduling, identifications of risks, contingency plans, allocation of available resources, and deliverables in sprints.
• Reported progress to all stakeholders through Sprint Burn-Down Reports, Iteration Burn-Down Reports, and velocity target updates.
• Prioritized, rationalized, and consolidated retiring various financial systems such as the legacy AS/400 system and Hyperion Systems and transferring the data into SAP R/3 and SAP BW that brought about standardization.
• Applied agile methodology to close the information gaps between the New Integrated Data Store (IDS) and the old data warehouse in terms of information content. This way the new IDS contain sufficient data to source Mede Analytics reporting and analytics for Group Reporting and for Predictive Modeling.
• Managed the client requirements, issues, & communications throughout project life cycle and rollout.
• Developed Costs Benefit Analysis for data/integration/support initiatives.
• Educated upper management to gain adoption of Data Warehouse and Integration strategies for the data integration and data warehouse program.
• Managed the data mapping requirements analysis for the high-level data requirements.
• Managed ETL Developers, BA’s, and Testing teams.
• Interfaced with the Data Architects/Data Modelers/Data Governance teams to ensure the data warehouse and integration strategies meet company standards.
• Ensure that the data warehouse model and data integration strategy meshes with the overall organizational model and support the attainment of the organizational goals.
• Lead the ETL design and implementation of a IDS and Data Integrations solutions to meet the needs of the business.

Confidential

Business Intelligence and Data Warehouse Manager

Responsibilities:

• Lead onshore/offshore team to implement the build of the Automated Financial System - AFS. In the process lead the design enhancements to the current ETL architecture, framework & Design to build an efficient data warehouse that reflected the upgrade to PeopleSoft Financials 9.2 and Oracle 11g technologies.
• Organized and facilitated Agile and Scrum meetings, which included Sprint Planning, Daily Scrums or Standups, Sprint Check-In, Sprint Review & Retrospective.
• Managed rapid development of prototypes, allowed early review by the client and helped to manage customer expectations.
• Held frequent planning and design workshops, ensured deliverables more closely to meet client expectations.
• Lead the effort to assess, define system integrations and system flows on how multiple applications would interact with each other, evaluate pros/cons and feasible implementation options.
• Lead the initial analysis to find gaps and dependencies between different systems, and communicate the changes to other businesses to eliminate/reduce the impact.
• Classified Data Elements to determine if the standards for those elements should be governed at the local or enterprise-level. To see if they are shared across applications and determining the flow of data across the application landscape.
• Managed and measured the test execution progress and metrics, identified cross-team risks and issues, and communicated them to the appropriate leads.
• Managed scope changes, CRs and design deviations found during testing and act as the liaison between Business and technical resources to define how the proposed solutions will fit into the overall deployment work plan, schedule, cross vendor dependencies and constraints.
• Manage cross vendor, cross unit ownership of deployment issues and interdependencies
• Drove technical designs to consensus and approval as a leader within company’s cross-functional technology team.
• Provided regular high-level communications to the executive staff and detailed communications to stakeholders
• Proactively engaged with other team-members and cross-functional teams to ensure all open issues are identified & resolved.

Confidential

BI Reporting Project Manager

Responsibilities:

• Lead the Analytics team of 4 in creating AS-IS documentation to illustrate the existing key data elements and data attributes required for each business functions for future state. Lead data profiling team for Information Analysis, Column / Table /Cross table, Domain & Baseline Analysis. Extending Metadata, Applying Data Rules /Metrics and Reporting / Publishing the results.
• Ensured the development teams are practicing the Agile principles. Lead the team to collect the current data issues and impacts. Outline an approach and activities for collecting data dictionary for reporting purpose. Work with Data Stewards & Custodians to set strategic direction, principles and policies for their data domain.
• Practiced release and sprint planning, daily standups & impediment removal.
• Lead technical teamwork to capture work efforts, document tasks, coordinate across teams, support creation of defining data object mappings, business / conversion rules, data governance & quality, define a data cutover plan for building Dashboards and scorecards using Microstratgy.

Confidential

Jr. Data Modeler

Responsibilities:

• As a Data Modeler was responsible for the build of Logical/Physical enterprise MDM Data Model to support the Businesses MDM effort.
• Responsible for building the Master & Reference Data - Structural data used in planning, analytical, and similar activities and also shared across functional groups.
• Build the Core Master Data - Operational entities, supporting all fundamental business activity transactions being executed on this level. The Core Master data are common and shareable within the organization.
• Analyzed & classified Conditional, Transactional and Reporting Data.
• Classified Structured Data to categorize structured data by usage, function and frequency of change, for the purpose of processing and governing them in a coordinated way.
• Classified Data Elements to determine if the standards for those elements should be governed at the local or enterprise-level. To see if they are shared across applications and determining the flow of data across the application landscape.
• Worked with Business SME's & architects to implement HIPAA 4010 in the new MMIS system & eventually move to HIPAA 5010 with AGILE methodology. In doing so worked in full HIPAA compliance lifecycle from gap analysis, mapping, implementation and testing for Medicaid Claims.
• Actively analyzed, profiled source business data (Claims, Customers, Members, Providers) and worked with Data owners/ stewards to improve and implement enterprise data by ensuring data standards and compliance were met.
• Worked with other Architects to strategize and design the data integration of multiple upstream/downstream systems for Claims, Providers, Benefits, Customers & Employers. Co-ordinated and established data governance/quality rules, assisted in building a centralized repository where all reporting data had to be brought into to enabled reporting teams to generate 1000+ reports on daily basis
• Responsible for building the Master Reference Data - Structural data used in planning, analytical, and similar activities at the corporate and regional levels, but also shared across functional groups or the whole organization.
• Build the Core Master Data - Operational entities, supporting all fundamental business activity transactions being executed on this level. The Core Master data are common and shareable within the organization.
• Assisted in designing relational 3NF physical models, data marts for representing multidimensional data.
• Worked closely with Business, Governance, BA’s, ETL developers and Business Process Analysts for process improvement, normalization/de-normalization, data extraction, data cleansing and data transformation / conversions.
• Created, documented and maintained logical and physical database models in compliance with enterprise standards and maintained corporate metadata definitions for enterprise data stores within a metadata repository.
• Established and maintained comprehensive data model documentation including detailed descriptions of business entities, data dictionaries, and data relationships.
• Assisted in the development of mapping spreadsheets for (ETL) team with source to target data mapping with physical naming standards, datatypes, volumetric, domain definitions, and corporate meta-data definitions.

Confidential

ETL Architect / Lead Developer

Responsibilities:

• Designed enhancements to the current ETL architecture, framework & Design to build an efficient data warehouse that reflected the upgrade to PeopleSoft Financials 9.2 and Oracle 11g technologies.
• Analyzed source data and the forms of data - structured/unstructured, real time data requirements and its impact on ETL and Change data capture considerations for loading data into slowly changing dimension tables
• Distinguished different types of data in the business (analytical, transactional, master, etc.) and adhered to business defined rules around the data structure, storage, use & distribution.
• Participated in transaction analysis and mapping needs, system / interface analysis, and worked with developers to implement ETL design changes as needed.
• Lead in building the Data Governance Maturity Models
• Lead the team in data profiling using IBM Infosphere Information Analyzer for Information Analysis, Column / Table / Cross table, Domain & Baseline Analysis. Extending Metadata, Applying Data Rules /Metrics and Reporting / Publishing the results.
• Lead the team in the standardization & cleansing of data elements.

Confidential

Data Governance / Data Quality Lead

Responsibilities:

• Reviewed process and data quality metrics, KPIs, SLAs, and controls; take corrective actions as necessary. Reviewed and approved data change/cleansing/validation.
• Understood current data issues and impact - It included the rules, policies, roles and responsibilities of data.
• Reviewed & assisted in key decisions, critical issues & change requests, data quality metrics & outline approach and activities for deployment.
• Reviewed & assisted in resolving critical enterprise data-domain issues, such as data standards changes, Meta data standards and changes.
• Identified / build an inventory of key risk data items for a continuous improvement process - process handling of DQ anomalies, metadata - management, data profiling, clean-up and monitoring.
• Performed data profiling / quality analyses on common data elements that exist across disparate systems. Created data lineage connections between business metadata and technical metadata within Business Glossary
• Lead the team in the design and development of quality assurance standard and for Investigation of domain integrity, free form text, matching, standardizing and implementing data rules for data cleansing.
• For continuous improvement of DQ build definitions of target data quality, build an inventory analysis of data, data governance / quality requirements. Work with business representatives to understand data marts requirements and priorities and ensure that IT works is appropriately aligned.
• Lead in creating AS-IS documentation to illustrate the existing key data elements and data attributes required for each business functions for future state. Lead data profiling to set tolerance limits, quantification of the business impact by analyzing column, table /cross table, domain & baseline analysis. Extending metadata, applying data rules /metrics and reporting / publishing the results.

Confidential

ETL Lead / Architect

Responsibilities:

• Responsible for leading and developing new and modifying existing ETL jobs for the Automated Financial System (AFS.
• Designed the Datastage jobs to extract data from VSAM files and Oracle tables to do mathematical and logical calculations, Identify Loans with Outstanding Balances after Legal Maturity Date, Identify Non-Accrual Loans, Identify Prime, Identify all other Variable Rate Loans and validation of certain business logic, transformation of dates, currencies and eventually load the data into Oracle tables after which the data would be loaded into PeopleSoft tables.
• Was point of contact between functional, management and technical teams by setting up meetings to gather requirements.
• Jobs designs were done following the guidelines of modular development, establishing job boundaries, parameterize jobs, using shared containers, error and reject record handling, null handling, runtime column propagation, using job sequences, partitioning / collecting methodology and standards were implemented using IBM Enterprise Edition version 8.0.1.
• Responsible for reporting daily / weekly status of design progress and next step of actions.

Confidential

ETL Lead / Architect

Responsibilities:

• As an ETL Architect / Lead developed & modified ETL jobs and coordinated work with onshore and offshore teams for both initial as well as incremental loads in an MDM environment for the Identity class.
• Worked with Informatica and Siperian Databases to extract, transform, cleans, match and merge, and load the data from Oracle to the landing tables in the Siperian database.
• Migrated all the Informatica jobs to IBM InfoSphere Server jobs. In doing so implemented business solutions that crossed multiple environments such as development, test, stage and production.
• At all stages utilized information technology, business and industry trends, ensuring business and I/S best practices.
• Understood business and technology processes, identified and implemented improvement initiatives, eliminating redundancies and maximized re-use of applications.
• Did weekly status reports for key accomplishments for the week, next steps and concerns.
• Co-ordinate with off shore team in China with daily task’s to be performed and next course of action.
• Worked alongside Operations and QA teams to identify and corrects problems in complex test and production environments.