Eric Gotkowski Email & Phone Number

Austin, Texas Area

St. Louis Park, Mn

---Context--- >> Wells Fargo was undergoing a retirement of a legacy Home Equity management system and consolidation into their central workflow tool for Home Mortgage. >> The team was in need of a data analyst to support the data mapping effort and champion tasks related to ETL work in migrating the legacy data.---Responsibilities--- >> Authored and maintained data mapping specification document, defining data sources, transformations, and target locations. >> Conducted data analysis activities, in SQL Server and DB2 databases, necessary in preparing for and executing ETL work for the migration. >> Developed logic to convert 2.4M records of home equity collateral data into 120 different asset types leveraging a keyword analysis of user entered collateral description data.---Results--- >> Produced data mapping specification and detailed design document for data migration effort. >> Executed key word analysis on collateral to further define collateral types and separate assets and documents. >> Provided production support for data team during cutover, ensuring successful migration of legacy data.

St. Louis Park, Mn

---Context--- >> Project team at MoneyGram was managing the release of new consumer facing documentation to govern currency transfers across several regions. >> In their current state they were attempting to manage the release through excel tables. >> The number of document types, systems, status values, and other parameters quickly overwhelmed their current methods, and the team was in need of a long term release tracking solution that could expand with the needs of the project.---Responsibilities--- >> Collected data requirements focusing on what inferences the team was hoping to make from the status data, the need for a simplified user interface for entering and updating data, and the ability to generate reports to be shared across a wide audience. >> Constructed database models, GUI wireframes, and hosted demonstration sessions to test the performance of various elements. >> Charged with taking MS Access database with front end GUI from design to build to launch in order to meet project team’s needs.---Results--- >> Built a relational database connecting data for all forms of documents, status tracking, and regional reporting >> Designed an easy to use GUI for the database that enabled users of all skill levels to update, search for, report on, and maintain data as needed. >> Trained project team on functionality of MS Access tool, and conducted a successful handoff such that the project team was able to carry the tool forward and continue to modify to their needs

Eagan, Mn

---Context--->> Based on large, fast company growth and increasing complexities of the PBM market Prime’s legacy estimating and business case development process was inefficient and inaccurate.>> Charged with institutionalizing a mature Enterprise Analysis process to enable Prime to be more effective at business need analysis, solution design, and investment decisions.>> Over 18 months the process evolved through several design iterations culminating in the version 3 release.---Responsibilities--->> Designed, implemented, and standardized processes to develop business cases for strategic roadmap initiatives used for informing capital budget committee investment decisions on future projects or programs.>> Developed and trained teams on toolsets that enable estimation of roadmap level efforts at consistent quality and levels of accuracy.>> Authored and maintained core toolset for visualizing data and informing decisions necessary for effective business case development>> Managed the continuous improvement lifecycle of Enterprise Analysis enabling the client to achieve a mature process of business case development and investment decision making.---Results--->> Standardized Enterprise Analysis processes around core competencies of business need analysis, business solution analysis, and investment analysis.>> Trained a team of 35 business architects, solution architects, and enterprise architects on each release, institutionalizing the process.>> Over 18 months delivered >75 business cases valued at more than $100M in roadmap spend.

Minneapolis, Mn

---Context--->> As a class action lawsuit data management company Rust handles cases with millions of records of sensitive, personal information from claimants from diverse data sources and levels of structure>> The data analysis team was charged with designing and leading ETL processes for each case.>> Once standardized, data was used to determine claimant eligibility, calculate eligible payout, and produce payments to claimants in the form of checks.---Responsibilities--->> Developed strategies and lead data analysis activities to cleanse, migrate, and process large amounts of personal information and sensitive data in accordance to class action settlement agreements.>> Coordinated data mining activities across functional teams to produce deliverables used by counsel in class action lawsuits.---Results--->> Routinely managed data mining and analysis for projects with values exceeding $1M.>> Maintained a successful record of accomplishing complex data loads of unstructured data in accordance with aggressive timelines set forth by counsel.

Brooklyn Park, Mn

---Context--->> During Target’s Canada expansion there were a number of data design requirements specific to the expansion into Quebec.>> The SAP data management team was charged with developing specialized data mapping protocols to import legacy data from the Quebec retail stores into their global SAP system.---Responsibilities--->> Designed, developed, and implemented data mapping program to produce SAP load files.>> Served as Test Lead for ongoing SAP enhancement rollout at major retail client during international expansion.>> Designed and organized test scenarios to fulfill data requirements of new article management system, and comply with international, province specific regulations set forth in Canada expansion.---Results--->> Final deliverable implemented as Taget’s core inventory management processes for creating/managing articles across stores nationally.>> Managed off-shore and local test teams to complete designed test scenarios with aggressive timelines and meet specified gate criteria.

Maplewood, Minnesota

---Context--->> 3M was experiencing conflicts integrating its growing list of independent IT systems across its many manufacturing and distribution facilities located across the globe.>> In an effort to standardize, legacy systems were being retired and SAP implemented, and legacy data needed to be migrated and standardized across their global facilities. ---Responsibilities--->> Developed SAP line designs to create current client manufacturing process in the SAP system.>> Maintained strict quality and data integrity rules related to the movement of goods across the production floor and warehouse tracking systems.>> Identified, tracked, and resolved data issues related to production reporting, material movements, inventory management, warehouse management, and inbound/outbound deliveries to production.---Results--->> Successfully functioned as an SAP site lead for healthcare manufacturing facility in Canada. >> Enabled successful continuing production and shipment of goods through strict data quality practices and operational best practices.

Maplewood, Mn

---Context--->> During a global SAP implementation 3M was undertaking a massive effort to migrate and centralize their legacy data into SAP>> During this process it was the data migration team’s responsibility to coordinate actions, synchronize data loads, and resolve defects to ensure a timely execution of all migration tasks.---Responsibilities--->> Managed data dependencies across several data teams to initiate and maintain efficiency during migration tasks>> Designed cutover plans and executed mock migration events to troubleshoot for defects and coordination issues.>> Identified defects and managed their resolution across releases.---Results--->> Developed dynamic dashboards to communicate cutover progress and KPIs across functional teams.>> Managed cutover team shifts and successfully executed migration plans to ensure cutover plans were executed on schedule.

Richfield, Mn

---Context--->> Best Buy was undergoing an upgrade of their Oracle software>> During this time the Enterprise Architecture team managed dependencies among impacted projects and functional teams.---Responsibilities--->> Built and monitored metrics tracking environment, testing, development, and resource needs during the software upgrade.>> Maintained comprehensive picture of implementation timelines and where the Oracle upgrade would need to intersect these timelines.---Results--->> Managed Enterprise Architecture team deliverables and coordinated actions across functional teams to facilitate Oracle upgrade.>> Developed dynamic mapping tools leveraged for quantifying responsibilities through the upgrade process and identifying critical gaps.

Minnesota

---Context--->> US Steel was undergoing a significant manufacturing process efficiency assessment and tuning effort.>> These efforts are typically broken into phases, centering on assessment and action>> Over the course of these phases, our team would conduct statistical analyses over an area of the plant, and create an action plan to address operational units (i.e. reactors, kilns, separators) with opportunity.---Responsibilities--->> Used specialized intelligence software to harvest and visualize plant operations data, enabling teams to design effective action plans.>> Led team of engineers to implement PID controller logic and advanced regulatory control changes to process units.>> Leveraged statistical analysis to identify problem areas, target actions, and deliver value through business drivers such as energy savings and throughput increases.>> Delivered sustainability, financial benefits analysis, and monthly reports summarizing team’s efforts.---Results--- >> Delivered benefits exceeding $1M in energy savings, throughput increase, and production yield.>> Designed and facilitated training program with client to ensure best practices after transitioning.

Raleigh, North Carolina

>> Developed test scripts, test conditions, and expected results for test plans. >> Designed and implemented workflow automation tools enabling team to create and execute system test scripts, conserving a significant amount of labor costs and project time.

Chicago, Il

>> Developed user stories to define the functionality of both the Solstice Mobile app.>> Built, executed, and managed the deployment of the new solstice web page.

Contracted out to The Northern Trust as an analyst. Contributed to the Role Based Access Control (RBAC) project. By contacting managers I was able to help in establishing controlled access throughout The Northern Trust based on an individuals title. Limiting the reading, writing capabilities, controlled access and other entitlements the users were allowed to use within specific programs and applications. Using a corporate organization software SailPoint, the controlled access was organized into functional roles that were then assigned to users. The functional roles dictated which entitlements were given to users on the basis of their needs. Constructed Visual Basic algorithms to automatically format the analysis reports of the various employees’ access. Other VB macros were used to assist in consolidating reports to better communicate needed access for multiple users. The algorithms used greatly reduced turn-around time needed between receiving employees within the roles and determining their granted access.

---Context--->> Monsanto is a large manufacturer of a variety of products in the agricultural industry.>> The Muscatine, IA plant focuses on producing a number of herbicides ranging from standard chemical treatments to more exotic formulations such as RoundUp.>> Chemical engineers are responsible for maintaining their area of the process, ensuring quality production, and always seeking efficiency and improvements.---Responsibilities--->> Developed touch screen based dashboard enabling visualization of plant health data.>> Redesigned piping systems and idled pumps in pursuit of energy savings.>> Initiated alarm troubleshooting program leveraging trends analysis, statistical analysis, and graphical modeling tools---Results--->> Reduced process alarm suppression an overall 89%.>> Eliminated large amounts of paper work with an increase in communication via dashboard implementation>> Maintained quality production standards and ensured continual efficacy of herbicide production.

Conducted experiments investigating transmembrane protein folding kinetics. Wrote a C++ algorithm that analyzes transmembrane protein databases, determining which candidates are best suitable for temperature jump and fluorescence lifetime experiments. Constructed a peptide optimization program that operates off of a perceptron learning algorithm design. When algorithm was applied to the database it produced greater than a 50% hit rate in selecting protein candidates appropriate for study. The research project received first place at the Illinois State Academy of Science 100th Annual Symposium and was published in their recent transcript.

Masters, Engineering Management

Activities and Societies: Program Development Committee, Student Activities Committee, Career Development and Alumni Relations Committee.

B.S., Chemical Engineering

Activities and Societies: Lambda Chi Alpha Fraternity, University of Illinois Club Tennis, University of Illinois Ju Jutsu