SUMMARY:

• Confidential has over 14+ years of Information / Data Management (Migration/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 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.
• Planned, directed and coordinated project execution activities for the end to end management of data lifecycle - from data acquisition (inbound), ingestion and validation, warehousing (reporting and analytics) and data distribution (outbound).
• Verified project goals are accomplished and in line with business objectives. Performed Data Quality / Governance assessments for wide range of initiatives such as data warehouse implementation, Legacy data migration and Integrating systems. 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.

• Budgeting & Planning
• Project & Delivery Methodologies
• Management of Cross-Functional Teams

• Budgeting & Planning
• Project & Delivery Methodologies
• Management of Cross-Functional Teams

FUNCTIONAL/TECHNICAL KNOWLEDGE:

• Budgeting & Planning
• Project & Delivery Methodologies
• Management of Cross-Functional Teams

• Budgeting & Planning
• Project & Delivery Methodologies
• Management of Cross-Functional Teams

• Budgeting & Planning
• Project & Delivery Methodologies
• Management of Cross-Functional Teams

• Budgeting & Planning
• Project & Delivery Methodologies
• Management of Cross-Functional Teams

• Budgeting & Planning
• Project & Delivery Methodologies
• Management of Cross-Functional Teams

• Budgeting & Planning
• Project & Delivery Methodologies
• Management of Cross-Functional Teams

TECHNICAL PROFECIENCIES:

Management: MS Project Management, Jira, LiquidPlanner

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

Operations Manager

Responsibilities:

• Huntington Learning Center provides Learning Center Service, Exam Prep Service & Subject Tutoring Services.
• Responsible for being awarded the Franchise, Site Selection, working with Schools, Vendors/merchants that are ancillary for the success of our business.
• Manage each Center Director in the region, and is responsible to set revenue, operational, and marketing goals, and to meet these goals through management and development of full-time staff within the region. (The term, region, describes the geographic area within which the Center is, or the Centers are, located.)
• Develop the business plan; and set revenue, operating, and marketing goals.
• Meet the business plan and goals through management and development of quarterly, monthly, and weekly action plans.
• Manage region and Center finances, including cash flow, payments, close outs, returned checks, and refunds and expenses related to marketing, phone, travel, inventory, and other items.

Confidential, McLean, VA

Sr. Consultant

Responsibilities:

• Responsible to drive the ETL Code Migration and the Retirement of Central Data Warehouse Table Retirement efforts via Data Governance for the Single-Family Data Delivery Services.
• Managed a 3 projects in parallel compromising of ETL developers, data governance and business analysts.
• Developed expert level understanding in Single Family Mortgage loans functionality through gap analysis, setting data governance policy and standards. Review ETL code flow and their dependency on Autosys jobs and scripts for extract, transform and load into databases.
• Evaluated new requirements & business features, provided opinion on how existing ETL code / tables should be enhanced or what new ETL code / tables capabilities need to be delivered based on retirement of existing tables.
• Contributed to new platform upgrade architecture / data model solutioning based on findings from gap analysis of existing of existing tables, ETL code and business / data analysis and needed future requirements.
• Lead issue and defect triage and resolution by leveraging understanding of the data model, upstream / downstream source & target systems and business processes. Lead the development and quality assurance resource in the investigation and resolution of issues.
• Estimated efforts and developed project plan, schedules and resource assignments for the projects, maintenance, and support.
• Responsible for ensuring timely and accurate execution of day-to-day delivery requests, prioritization of work and assignment of work to the ETL developers and analyst pools, project status monitoring and follow up.
• Responsible for planning and overseeing the technical transitions between development, testing and production.

Confidential, McLean, VA

Sr. Consultant - Agile BI 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.
• Lead 3 projects in parallel - the reporting team with a focus on guiding the teams towards consolidating existing monthly reports of 6 business units from approx. 168 reports to 109 reports.
• Lead the Business Analysts and ETL Developers with prioritization and resolution of source data, data Lineage, conversions & transformation, aggregations & roll up for new and existing data/reports.
• 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, progress tracking, monitoring change control process, testing, documentation, and schedules for each major deliverable / project within budget constraints.
• Used technical judgment to challenge proposals and propose recommendations that translate into an effective course of action, including managing project schedules, identifying risks, and clearly communicating them to project stakeholders.
• Worked closely with business, product management and leadership team across functions to define data analytics technical roadmap, align project requirements, priorities, and coordinate execution.
• 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, Marlborough, MA

Scrum 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, Mountain View, CA

Business Intelligence and Data Warehouse Manager

Responsibilities:

• Responsible for creating the project plan for Da Vinci Data Integration and SaaS Project Plan.
• 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.
• 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, Concord, CA

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 - KPI’s 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.
• Co-ordinated 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
• 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 lineage/mappings, business / conversion rules, data quality and define a data cutover plan for building Dashboards and scorecards using Microstratgy.

Confidential, Monteplier, VT

Jr. ETL Architecture Jr. Modeler

Responsibilities:

• As a Jr. 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.
• 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.
• Worked with other Architects to strategize and design the data integration of multiple upstream/downstream systems for Claims, Providers, Benefits, Customers & Employers.
• Worked closely with Business, Governance, BA’s, ETL developers and Business Process Analysts for process improvement, normalization/de-normalization.
• 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.

Confidential, Mechanicsburg, PA

ETL Lead

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.
• Assisted 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.

Confidential, Collage Park, MD

Jr. ETL 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.

Confidential, Milwaukee, WI

ETL Lead / Data Governance / Data Quality

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, NYC, NY

ETL Developer

Responsibilities:

• As an ETL 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.
• Understood business and technology processes, identified and implemented improvement initiatives, eliminating redundancies and maximized re-use of applications.
• 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.