Chris M Steigerwald Email & Phone Number

• Created use cases and negative test scenarios. Tested big data sets with SQL and Excel. Created and maintained business requirement and technical mapping documents for ETL developers and Database Architect. Conducted.
• Legacy Root Cause Analysis: Analyzed and enhanced hard coded legacy rules to meet business requirements allowing IBM to meet contractual obligations with software partners.
• Requirement Analysis: Transformed complex requirements into targeted unit test cases to significantly reduce developer rework.
• System Analysis: Traced data from BI reports through ETL back to API and source systems to correct legacy data issues resulting in 98% reporting accuracy across multiple subject areas.
• Big Data Set Analysis: Tested and analyzed over 100 subject areas in a star and snowflake schema database with SQL on data sets with millions of records.

• Supported over a dozen clients across multiple verticals. Designed and executed project test plans and test cases. Created ROM estimates, delivery timelines and SDLC requirements traceability. Consulted on.
• Systems Process Analysis: Streamlined end-to-end process functionality leading to less complex QA scenarios and efficient production automation.
• Leadership: Lead a QA contractor team by setting and reviewing daily targets for defect reporting, test cases and test results condensing QA timelines to guarantee project deadlines.
• Root Cause Analysis: Resolved priority escalations on recurring incidents for time-critical project enhancements improving client retention and reducing contractual penalties.
• Process Improvement: Created agile test packages in waterfall process by grouping related requirements enabling junior analysts to accurately test with a very little ramp up time.
• Change Management: Deployed Informatica workflows and components (dev/qa/stg/prod) during heavy build cycles minimizing development cycle lag.

• Performed source file audit and analysis, created Informatica processes loading data into a temporary database structure to support marketing and customer engagement campaigns in interim while the final solution was in.
• Data Migration and Consolidation: Migrated go live data, part of 24/7 team that ran file audit, data cleansing scripts, running final Informatica workflows and monitoring.
• Process Improvement: Created multi-step job stream in Tidal to automate SFTP processing leading to 25% reduction in required FTEs.
• Process Design: Implemented production schedule to streamline file load process and enabled Unica campaign extracts to reach 99% on-time delivery target.
• Cost Reduction: Created confirmation and failure messaging within Informatica to efficiently manage file load progress and reduce production support FTEs.
• Data Integration: Developed Informatica mappings and workflows for complex CDI processes requiring third party data attributes to facilitate improved customer engagement.

Promoted to Senior Information Analyst in July 2009.

• Developed growth reporting of 1500 Yellow Page directories’ revenue, approx $500M, for 200 plus advertising agencies.
• Yellow Page Association Excellence Award for Innovation – Silver (2006 and 2007).
• Coordinated cross-functional processes or projects. Wrote requirements, assisted IT in programming of website database tools by providing proof of concept samples and testing.
• Improved efficiency by replacing MS Access and COGNOS Impromptu reporting with PL/SQL query scripts. Trained support group to use scripts.
• Last Special Project – requirements and data extraction to support Salesforce/Bluewolf CRM implementation.

Wrote product and incentive documents for publication to website. Responded to escalations from Client Help Desk. Created COGNOS Impromptu reporting, determined processes, wrote training documents to assist in Incentive system migration.

Irving, TX

 Billing Analyst and Claims Negotiator – created interim claims tracking solution during merger with Bell Atlantic. Book Close Clerk – essentially final QC of phone books from all over the country Order Processing Analyst – validating and processing of electronically transmitted listings and advertisements for phone books.

Applied Information Technology-Telecommunications

Education record