Senior Data Analyst/Data Warehouse Analyst/Project Manager

Resilient performance-driven professional with over 10 years of progressive technical and project management experience aligning strategic initiatives to high quality relational database management systems RDMS , business intelligence and data warehouse solutions in multiple industries such as Banking, Education, Healthcare and Telecommunication.

SUMMARY OF QUALIFICATIONS

• Proficient in business requirement conceptualization, source system analysis, technical document design, data analysis, data mapping, root cause analysis and predictive analysis.
• Experienced in SDLC with both agile and waterfall project management approaches.
• Solid understanding of data modeling in OLTP ER/normalized and OLAP star and snowflake environments.
• Experienced in creating testing strategies, testing plans, test cases, overseeing the completion of UAT testing and defect management through manual and automated processes.
• Experience in creating best practiced ETL packages and SQL stored procedures to improve data integration performances.
• Proficient in designing and deploying enterprise data management and governance policies and procedures.
• Business Intelligence Reporting specialists in Business Objects with familiarity in SSRS.
• Experience in training and supporting end users, IT support staff and conducting JAD sessions and interviews.
• Proficient in gaining top management and stakeholder acceptance by articulating cost benefit analysis and ROI presentations.
• Change management advocate with excellent leadership, communication and interpersonal skills with a fervor to improve the people as well as the processes.'

PROFESSIONAL EXPERIENCE

Confidential

Database Data Warehouse QA Analyst

Responsibilities

• Evaluate business requirements and functional technical documents for completeness, interdependencies, omissions or ambiguities to ensure testing sufficiency.
• Crafted comprehensive enterprise data warehouse EDW end-to-end testing strategy, test plan, test cases and test scripts to verify and validate testing functions such as unit, functional, integration, smoke, stress and performance, regression and UAT testing.
• Deployed data investigation to determine root cause analysis and provided best practice solutions to remedy them.
• Utilized defect management best practices with developers and end-users by identifying, tracking, timely resolving and monitoring defects.
• Created advanced SQL queries to validate and profile data pertaining to the following scenarios: source to target, backend testing, ETL mapping, mapplets and reusable transformation logic validation, test case automation, expected functionality and behavior for dimension, fact and aggregate tables and to build defect/error validation tables and documentation.

Selected Accomplishments:

• Enhanced testing software DVO to integrate system tables to automate test case creations by allowing the analyst to create complete test cases for tables in one or multiple database schemas instead of creating them one at a time. This development allowed reusable test cases to be scripted and shared amongst peers, increased test case creation for parallel migration testing by 200 and increased result evaluation for quicker defect resolutions.

Data Quality Coordinator Manager Serving as Data Warehouse Lead Project Manager

Responsibilities

• Designed, implemented and managed an enterprise data management improvement strategy to improve the overall dimensions of data quality and governance while relentlessly collaborating with personnel to re-architect and improve overall data architecture.
• Measured and prepared the fitness of the data for upcoming DW/BI implementation with the creation of dynamic and ad-hoc quality assurance monitoring reports with alert notifications.
• Responsible for gathering and conceptualizing requirements through multiple JAD sessions consisting of 25-100 attendees to create technical specification to build dimensional models based on Ralph Kimball's approach. Conducted data and source system analysis on DB2/AS400 platform and 2-3 terabyte OLTP relational database system for the largest school district in the state. Created mapping documents, workflow analysis and data owner/steward identification for data to power 50-100 potential dimensions and fact tables. Collaborated with vendors to design and revise best practiced end-to-end SSIS data integration packages and TSQL stored procedures. Conducted end-to-end and UAT testing, data quality assurance, power-user and IT staff training and support.
• Oversaw the planning, organizing and controlling of 2M project constraints and personnel within budget and scope by nurturing and developing interpersonal communications efforts amongst stakeholders, vendors and internal resources. Gained stakeholder buy-in by articulating cost benefit analysis and ROI by promoting and displaying the project's worth. Identified, designated and trained data stewards and champions throughout the district by deploying a train-the-trainer program to support BI usage and understanding. Trained IT support staff for DW/BI maintenance and expansion to maximize a leaner resource model.

Budget: 2M Staff: 6-10 User Community: 4k , of Managed Vendor Companies: 2 6-10 total employees .

Selected Accomplishments:

• Demonstrated an unyielding desire to pioneer a data quality awareness campaign showcasing the necessity of creating and deploying a highly robust data management solution. After its deployment and acceptance, potential academic and revenue related data issues were identified, monitored and resolved. As a result, a cross-functional departmental early warning system was created. Loss of revenues due to data issues were reduced and in most cases recouped and stakeholders' confidence in the data drastically improved. Success rate of these implementations lead to the appointment of PM/Data Warehouse Lead for upcoming multi-million dollar DW BI project.
• Designed and implemented a more streamlined truancy tracking and intervention solution to increase graduation rates, which increased the identification efficiency of students who needed intervention and support by 300 . Data from the system assisted in birthing a truancy center that provides education reformation for at-risk students.
• Successfully and within budget, coordinated, engineered and implemented DW/BI performance management system. Developed a more effective data integration and quality process for existing and forecasted data domains. Expanded data warehouse to capture immediate strategic changes within budget and demanding timelines. Acknowledged by management for exceeding project expectation in spite of resource, monetary and scheduling restraints.
• System implementation fostered expeditiously in predictive analysis identifying at-risk students within days of implementation. Academic improvement plans were more specific and most importantly student lives were being intervened for the betterment.
• Handpicked to lead the first multimillion-dollar K-12 longitudinal performance management DW/BI solution in the district, arguably in the state.
• Implemented mitigation plan to remedy vendor and internal resource loss during crucial deliverable by more fervently engaging, equipping and discovering untapped staff competencies creating a leaner internal resource model

Programmer Analyst

• Responsible for providing analytics to improve and streamline school-related decisions. Created, monitored and optimized data management processes by integrating Crystal Reporting with functional area-specific stored procedures, complex queries, constraints, triggers and extract transform load ETL best practices. Shadowed upper management and participated in stakeholder focus meetings to identify, extract and create conceptual and physical data improvement plans. Provided progressive system documentation and training for entry to upper level staff.
• Responsible for troubleshooting concurrency issues, reviewing and correcting database performance issues by utilizing effective index management plan, working with peers to create implement high availability systems through replication, database mirroring and virtual machine VM technologies.
• Analyzed and improved execution plans for poor performing queries/databases.
• Developed and managed database backup notification triggers for multi-terabyte databases.

Selected Accomplishments:

• Significantly and consistently reduced data errors with the design, deployment and training of in-house data management systems which reduced requests queue, optimized report distribution and improved system performance.

Business Analyst II

• Responsible for assigning workload tasks to analysts by understanding and creating cross departmental requests and relatable system and productivity impact. Produced queries and databases in Microsoft Access to provide a more effective technique to Quality Assurance QA production work completed by other analysts to reduce reoccurring cyclical issues. Documented multiple system integration workflow processes and data dependencies to strengthen and build departmental competencies.

Selected Accomplishments:

• Performed conversion tasks that reduced overhead costs by merging existing business markets.
• Increased data input, accuracy and built efficiencies by creating sophisticated automated scripts to replicate and increase workload tasks by over 200 for assigned team of 3.

System Engineer Associate

• Developed and managed PowerBuilder interfaces to improve performance for new and existing healthcare systems. Responsible for the interface architectural tasks of enhancing transactional relay, increasing and improving patient data input and processing. Responsible for developing testing scripts and migration builds into Production.

Selected Accomplishments:

• Optimized data retrieval and process performance by revamping COBOL and EZ tree extract programs and batch scripts to C/SQL on a UNIX platform.
• Provided unconditional support, training, quality assurance, development and innovativeness for clients that reassured customer skepticism. Ranked within the top 3 of colleagues during yearly evaluations.