Data Analyst Business
Resume:
Kim Terek
Madison, Wisconsin 53719
********@*****.***
http://www.linkedin.com/in/kimterekmarketing
Professional Summary:
Provides detailed technical planning, leadership, and analytical direction. Over eighteen total career years progressive experience in large corporate and data governance with last 9 years master data analytics teams. Last 10+ years coordinating infrastructure migrations, software and server upgrade projects within IT Systems operations. Business Intelligence, MDM, and SDLC lifecycle improvement projects among large scale business data and financial operations.
Senior experience with application development, product development, interacting directly with business process owners to understand tactical and strategic plans to support business processes and operations. Full scale Analytics background and 12 years in project design and testing of main technical specs for major software and infrastructure changes. 6 years experience with various ERP, quote to cash, and enterprise systems planning, data warehousing and experience building user interfaces. AGILE & Waterfall Release Planning and Development for sprints. Creation of stories, story refinement, backlog grooming, and epics scope management against business use cases and technical requirements. Communication deliverables for data governance, management, and technical systems delivery optimization. QA and UAT testing leadership for software enhancements.
Sixteen years career experience:
Technical planning, Leadership and time management skills, Data Governance, Technical Research and Documentation, Agile/Scrum Planning, Reviews and Release Executions, QA Testing, Leadership Soft Skills in Meeting Planning, Senior Management Meeting Facilitation, communications and decision making fulfillment, Consensus Gathering, Requirements Gathering and Story Writing, UAT testing, Project Strategy, Team Mentoring, IT/IS Systems Enhancements and Project Management Support.
Demonstrated Abilities:
Recent 9 years in data management platforms design and planning. (2014- current)
Systems integrations with scalability in varying large corporate environments.
Leadership in team/task management coordination that demonstrates initiative, hard work ethic, team resolve, and diplomacy to reach resolutions for successful business decisions.
Fully established group presentation and training experience on large scale projects.
Senior Project development to include PPD, definitions, scoping, and assessing drivers, programming, and testing n(planning and executions QA and UAT test plans.
Self-starter, with limited supervision finding ways to identify and suggest process improvements. Create effective team and business procedure decisions for improved measures of success.
Experience and active leadership in Sprint planning and Sprint Scrum retrospective ceremonies.
Positions:
Technical Data Analysis/Design Consultant
Perficient, Inc St. Louis, MO (remote) January, 2023 – May, 2023
Tableau Visualization Design data object mapping documentation for full-scale Pharmaceutical Benefits Manager. Data to relate United States geographical relationship mapping of pharmaceutical drug sales activity for major PBM corporate consumption. Financial drug sales and claims processing included.
Use-case interpretation to fill in the gaps of understanding between data requirements and etl transformation rules to encapsulate differences from multiple live systems in a changeover of source of truth systems between 3rd form normal and non-form normative data environments..
Facilitated crucial business and design related discussion meetings for detailed integration plans specific to major system solutions details among multiple reporting structures and team resource decision makers.
Shift Lead / Technical Consultant IT Systems
Nike, Inc (remote contract) Beaverton, OR June 1 – August 31, 2022
Support senior leadership to manage final go-live preparations and maintain round the clock technical support services for major global implementation of SAP / S4 version for Greater China implementation.
Gather expertise in SAP product and Oracle Financials in profiles of master data analytics for Nike retail and commercial quote to cash retail modules, with IFS connectivity on shipments and Purchasing, Purchase Orders included.
Story planning, story refinement in the SAP, Salesforce, and associated systems for planning of systems changes in sprints and PI’s (product increments) during production upgrades.
Team-resident expert of the ServiceNow procedures that accumulated all final go-live defect management and established the main reporting methods for incident management of the hyper-care and post-implementation procedures among global teams assembled to monitor validation progress.
Determine priority of issues throughout a two-month execution project plan cycle, ensuring service level agreements to sustain ERP systems without loss of shipment timings and order processing speeds for successful implementation procedures and measures.
Product Delivery Management/ Business Systems Analyst VI
Federal National Mortgage Association (FNMA / Fannie Mae) January 2022 - March 2022
Prepared major EDM/MDM design of financial technical documents for securities trading measures for financial reporting transition including General Ledger (GL) data mapping updates.
SQL and Python scripting and STTM (source to target mappings).
Product Owner
Wisconsin Department of Children and Families Bureau of Administration January 2021 – September 2021
Suggest changes to development for major systems implementations of internal data systems.
Lead requirements gathering for business requirements sessions and data governance plans.
QA and UAT testing software enhancements to establish better system validations for online software modernization projects to TANF, W-2 (Welfare to Work) and various childcare programs for state workers.
Co-Design main technical procedures for interface UI changes that meet user acceptance and confirmation of required functionality. (Oracle Financials, Business Objects, Oracle JCAP Applicator)
Consultant Experienced Enterprise Data Analytics Product Owner
Milwaukee County Information Systems Department June 2020 – December 2020
Delivery Lead for new procedures solutions for advanced Data Analytics.
Established Epic JIRA, and user stories breakdown, backlog, roadmap and timelines.
Requirements planning and design for new matrixed procedures and processes for MDM data analysis tools across multi-functional department organizations.
Driving product backlog discussions, intake planning, release planning, issue escalation for resolution.
Identifying project bottlenecks and suggesting ways to remove any roadblocks to progress.
Working closely with numerous department heads to influence the direction and acceptance of solution models.
Lead Analyst / Product Delivery (Supervisory level) Data Warehouse
DXC Incorporated (permanent hire 1.5 years) March 2019 – May 2020
Project Business Analyst as well as developer and Product Owners' Lead contact for Medicaid product-related software with end to end integrations, requirements gathering, design, and testing to post-production validations.
Team mentoring of less experienced analysts to bring team collaboration to document creation. Performance management of 9 project staff members (Analysts and developers).
Established Service Now procedures for user questions and concerns during major UI adoption for state associates and from local county governments interfacing with product production in new applications.
Consultant Project Manager TASC Corporation November 2018 – January 18, 2019
Story Writing: Active Agile Sprint planning, daily reporting in Jira on story development, daily updates performed consistently for senior Project Management.
Improvements to design documentation and increased average speed of development.
Systems included: Oracle PL/SQL Developer and SSIS connections, Business Objects, ServiceNow, Tableau, and custom built application interfaces.
Business Analyst National Conference of Bar Examiners June - September 2018
Madison, WI
Suggest changes to development for vendor implementations of internal interface systems.
Led AGILE & Waterfall Release Planning and Development for data governance management.
QA and UAT testing of software enhancements to establish the first system connections for online software enhanced National Bar Exams.
Design main technical procedures for interface UI changes.
Document Oracle database connections with ERP database relationships.
Data Analyst II / EDM Product Manager Quartz Health Solutions, Inc. November 2015 – June 2018
Madison, WI (permanent hire 2.5 years)
Responsible for full scale EDW SDLC lifecycle planning, project management planning, leading development efforts, and testing of all layers of architecture within EDW changes.
Data profiling, examining all failed models of process flows, and suggesting changes to EDW governance procedure. SQL scripting for Informatica EDW environments with SAS, Oracle PL/SQL Developer and SSIS connections.
Design and development of ROI calculations (return of time/cost resource investments) for a 10-20 person team and 1-2 year resource planning cycle. Determining best timeline to measure return on planned activities for technical changes ongoing.
Consultant Senior Business Analyst (Contracts)
FIS (Fidelity National Services) July 2015 – August 2015
Kraft Foods, Inc. January 2015 – April 2015
Working for Systems Lead in IS Operations
Kraft, Inc. Northbrook, Illinois
Systems: Astute ePower System, (customer service center GUI with database back-end connections), SAS ERP, Sharepoint, JIRA for project collaboration. MS Project, Excel, Visio, MS Access
Kraft systems implementation co-delivery Lead and testing team Point of Contact for new consumer marketing database SaaS product with multivariate, real-time LDAP online extensions.
Redesigned technical interfaces and reverse engineered processes for updates.
Project management support on numerous communications and meeting interactions.
AbbVie Pharmaceuticals July 2014 – November 2014
Consultant R&D PMO Office for Separation IT Management
Working for Senior Management R&D IT Operations
Oversight to 350-systems environment/server moves for corporate split operations
Waukegan, Illinois
Systems: PM MS Project – MS Sharepoint, Oracle based platform with Oracle financial suite connections, Sharepoint administrator rights and UX tools site development with Java based developer testing
Change management for Pharmaceutical R&D systems updates on 7,000 global employee applications.
Program management and Project management for website and Infrastructure teams design/development.
Harley-Davidson Dealer Systems, Inc. April 2013 – November 2013
Systems: SAP CRM and PP, IBM MDM BI tool with connections to 5 set-data systems within HD enterprise, IFS included with financial reporting. SAP BW back-end access to historical marketing and ordering data.
Managed integration of SAP data upgrades for quality-control and designed effective technical procedures for data management system requirements, testing and validation.
Rockwell Automation, Inc August 2012 – April 2013
Systems: SAP ERP, Oracle based data management scripting functions,
Business Objects: In BO, SQL scripting, and first to design new Webbie reporting tools from SAP connections, Sharepoint database collaboration: 10,000 + weekly records scrubbing/updating
One of two employees with direct responsibility for building reporting systems process with IFS integrations for $1billion in corporate purchasing, GL, AP, AR, and production planning data of raw materials.
Finance & CRM Analyst/Team Supervisor (permanent hire 2 years) December 2009 – August 2011
Bradley Center Sports and Entertainment Corporation Venue management company
Milwaukee, Wisconsin
Integrated new Systems and procedures: Proprietary Ticketmaster system with new CRM functions and MS Access/Excel for analysis into an SAS database. Google Analytics and Suite services data systems upgrades.
Suggested and established new metrics for improved business intelligence results interpretation.
Strategic Finance Data Analyst (permanent hire 6 years) 2004 – 2009
Time Warner Cable, Wisconsin Fortune 100 company operations in the Milwaukee area
working for the Division Finance Director of Strategic Analysis
Systems in Use: ICOMs with AS/400 interface (as main ERP database access), Peoplesoft, COGNOS BI tool (first to design/match data from transactional codes in ICOMS), Tableau, and Crystal Reports, Kenexa and various other HRMS systems, ServiceNow IT servicing administration.
First use of SQL code in data extractions and reporting tools data analysis.
Created extracts from corporate mainframe system for bi-weekly SQL query reporting.
Ongoing member of technology project teams to execute upgrades and train departments of more than 400 employees, advising colleagues on new technical procedures.
Northwestern Mutual Insurance, Milwaukee, WI 2003 -2004
Insurance representative
Strong Funds (now Wells Fargo, Inc.) Nov. 1999 – Dec. 2001
Series 7 SEC licensed Broker Financial investments and trading
Education & Licenses:
Harvard University, Data Science online graduate program, courses starting January, 2022
Bellevue University, online Data Science program. Courses started as of November, 2019
Progress towards Master of Data Science, transferred schools and re-directed studies
ITIL Foundations Level Certificate Course Completed, 2019: IT Service Management
Certificate Course Completed, 2009: SQL Database Administration
University of Wisconsin- Milwaukee Continuing Education
University of Wisconsin-Madison Bachelors in Business Administration
Completed Major: Management Information Systems (MIS)
Dean’s List, Dean’s Scholarship for semester study in Business Management in France.
L’Ecole Supérieure de Commerce de Paris, #1 French graduate level business school.
Semester study in global advertising, marketing, and multinational trade
Technical Tools and System Applications Experience:
Quality Assurance environment testing with 4 years experience white-box (SQL) testing/9 total years experience black box testing, test planning, and use case writing..
Six sigma variability calculations experience in manufacturing environments. Full knowledge of black belt six sigma strategies and metrics to manage operating procedures.
10+ years with data profiling and database testing background among various multi-system stored procedures.
Development of relational database procedures, 8 years in dimensional modeling.
Researching, preparing, developing, and presenting on multi-system ERP / EDW technical process, BI tools reporting, flow diagrams, and system procedures. Writing main SQL code of design and tests.
•Technical Writing for full range end to end SQL run data systems. SQL programming and DBA skills, Microsoft and IBM Serverware, SaaS products, Teradata scripting, SharePoint, ICOMs, AS/400, PeopleSoft, Cognos, Crystal Reports, Kenexa and various HRMS systems.
• SQL Server Management Studio, SSIS package, Business Objects, COGNOS, SAP S4/HANA,
•Teradata SQL EDW, MS Server Suite BI tools, Business Objects Tableau Predictive analytics modeling, various Oracle, HP, and IBM platform solutions. SAP ERP, EDI, CRM, BW, SAP S4/HANA data ERP optimizations
•SQL and Python, and R scripting experience. SQL since 2004. Python coding beginning in 2019, R coding beginning in 2021.
•Google Analytics, MS SQL Server and Management Suite, SAS, SSRS, SSIS, and ETL’s, Visual Studio
Tableau, Business Objects, Ms Power BI, MS Project, Microstrategy, Oracle SQL Developer, Lotus Notes, Slack, MS SharePoint, Confluence, and creative publishing, Service Now IT servicing administration.
Contact this candidate