SQL Developer

Michelle Pflug

Belton, MO ***** *******@*****.***

816-***-**** linkedin.com/in/michelle-pflug

Experienced IT Professional

Accomplished IT Professional with proficient knowledge with a wide-range of programming languages, concepts and technologies, including but not limited to: ETL, SQL, JSON, DataStage, Perl, Python, C, C++, UNIX, vi, Business Analysis, Quality Assurance Analysis, Java, JavaScript, HTML, CSS, XML, user interfaces, databases, client/server, debugging, reporting, and optimization. Proven ability to complete projects efficiently and professionally, resulting in positive impact to bottom line. Core competencies include:

Data Warehouse Architectures

Code Modification / New Programming

Report Writing / Programming

Writing Technical Design Specs

BI Architectures

Business Requirement Analysis

Target / Source Reconciliation

Strong Written Communication

PROFESSIONAL EXPERIENCE

Vista Outdoor, Overland Park, KS

2017 – 2018

Applications Developer III

Facilitated as Logility / ETL Developer responsible for development, maintenance, and support of ETL jobs to load source system data into SQL Server data warehouse for initial and daily loads,

Created mapping documents for new ERP migrations into Data Warehouse through to Logility Application.

Provided analysis on reported data issues from business users using SQL for research, resulting in information

back to the business on cause and resolution.

Operated as point of contact between the business users and the Logility Development / Support team.

Delivered planned code migration scheduling to Logility Development / Support team and all other project

related communication.

IBM, Kansas City, MO 2014 –2017

IT Specialist

Senior ETL / DataStage Developer / Lead responsible for development, maintenance, and support of ETL jobs to load source system data into DB2 warehouse for initial and daily loads, and mentor other developers, following Best Practices and Standards for the Marketing Transformation team within the CIO organization.

Utilized DataStage 8.7 to design, build, and support jobs used to populate DB2 warehouse.

Ensured proper functioning of all data warehouse operation, including but not limited to testing, migrations, job scheduling, troubleshooting, and production support.

Utilize Toad, DB2 Data Studio and Aginity to create, modify, and query DB2 and Netezza tables for loading, debugging, and data mining.

Managed Repository Metadata from DataStage Director.

Conducted 24/7 global database applications for data load and extraction of customer related data for the Marketing Transformation team. The ETL objects interact with multiple remote databases, which include DB2 and Netezza dbs.

Received IBM Digital Squad Recognition from IBM Digital Leadership team for recognition of the value our squad created across the IBM Digital organization. We successfully completed several high value projects which provided needed marketing information to the Sales teams across several product platforms in a very condensed time schedule.

Effectively developed ETL programs using sql, ksh in a DB2/Unix environment.

Develop software development lifecycle documentation.

Provided assistance to other ETL developers.

Developed project schedule and provide level of effort estimates.

Performed Unit Testing and integration providing and enhancing overall processes.

Attend cross-functional team meetings and provide information related to design and development of ETL solutions.

IBM, Kansas City, MO

2013 – 2014

ETL Specialist Mid-Level (Informix)

ETL developer responsible for supporting ETL processes for Informix data marts / data warehouses.

Developed ETL programs using sql, ksh in an Informix / Unix environment.

Developed software development lifecycle documentation.

Provided assistance to other ETL developers enhancing their knowledge and understanding.

Developed project schedule and provide level of effort estimates.

SourceHOV, Overland Park, KS

2010 – 2013

Senior Data Manager

Design, create and maintain multiple applications related to the Fastrieve Repository.

Managed 24/7 global database applications for data load and extraction of customer related data that helps transform business processes and accelerate business performance. The client base supports information intensive industries, such as Commercial, Financial, Government, Healthcare and Legal services. We utilize mainly UNIX ksh, Oracle stored procedures, and Perl, enabling internal/external users access to their data. Participated in 24x7 on call rotation.

Automated manual load processes and implement data compare processes, which provide weekly reports, utilizing Oracle PL / SQL and UNIX Shell scripting.

Gathered business requirements from end users and author technical design specifications for junior Data Management Team members and IT Support personnel for assistance in supporting implemented ETL processes.

Developed project schedule and provide level of effort estimates.

Primary DM focal for several client projects in the Commercial, Financial, Government and Healthcare industries. Manage, develop and deploy projects to ensure data accuracy. Consistently provide project solutions on time with very short development schedules, enabling projects to stay within or below budget.

IBM, Lenexa, KS & Kansas City, MO

2001 – 2010

Customer Support Data Warehouse (CSDW) BT / IT Programmer / Analyst

Designated IBM Work from Home Employee

Designed, created and maintained multiple applications related to the Customer Support Data Warehouse.

Managed 24/7 global database applications for data load and extraction of customer support entitlement related data, utilizing DataStage, UNIX ksh, DB2 stored procedures, Java and Perl, enabling internal/external users access to technical support via phone or web. Participated in 24x7 on call rotation.

Automated manual load process and implemented data compare process, which provided a weekly report, utilizing DB2 and UNIX Shell scripting. Decreased need of manual resolution methods for 95% of data issues related to entitlements.

Collected business requirements from end users and authored technical design specifications for China Development Team for Customer Contract Management System (CCMS) EMEA project, which enabled EMEA customers quicker access to support, and provided a data compare process between the data warehouse and the downstream CCMS system for the EMEA and ANZ data.

Implemented and created the Customer Quality Data Base (CQDB) Archive database structure to store historical metrics data, increasing overall performance of the CSDW database and eliminated downtime for users caused by reaching database threshold limits.

Primary IT focal for CQDB Dashboard application data contained in the Customer Support Data Warehouse. Managed, developed and deployed projects to ensure data accuracy.

Increased efficiency of the CCMS feed by developing and implementing process to archive and purge data, eliminating application downtime due to decreased server space.

Improved system control and security compliance of applications and data; identified, documented and presented flow chart, control point matrices and test results at Application System Control & Auditability certification reviews, ensuring all applications and data conform to company standards and policies, which included areas of Business Intelligence.

Received BT/IT Leadership Recognition from IBM CIO for participation in cross-organizational team source replacement project, which enabled entitlement data to reach downstream applications faster and sped up recognition of potential revenue.

Documented the CCMS feed process and trained China Development Team on support functions, decreasing response time for data issues by an average of 12 hours.

Implemented and developed, with stakeholder involvement, modifications to the CCMS feed process, increasing throughput and reducing costs.

Supported the delivery of ETL services based on Documents of Understanding (DOU) also known as Service Level Agreements, always maintaining or exceeding the level of service expectations.

E Education

Master of Information Systems Management, emphasis in E-Commerce

Keller Graduate School of Management, Kansas City, MO

Bachelor of Science (BS), Computer Information Systems

DeVry Institute of Technology, Kansas City, MO c

Technical Expertise

LANGUAGES, OS & SOFTWARE :

SQL, PL/SQL, C, C++, UNIX Shell Scripting (Korn Shell), DB2, Oracle, Informix 4GL, AIX, HP-UX, Linux, JSON, Perl, Python, Java, JavaScript, CGI, vi, XML, HTML, Word, Excel, Netezza, Logility Voyager

TOOLS & UTILITIES:

Data Studio, RapidSQL, IBM Information Server DataStage 7.5, 8.0, 8.7, Visio, CMVC, Agile Development Methodology, Oracle SQL Developer, Toad, Slack, Box, Salesforce, SugarCRM, Microsoft SQL Server 2012 and 2016, SSIS, SFTP, Tableau, Stata

Contact this candidate