Information Technology Software Engineer
Resume:
James Brandemuehl
N**** Lake Dr
Shawano WI *****
ad5yiw@r.postjobfree.com
An Information Technology professional with over 20 years of progressive information technology experience. Demonstrated exceptional analytical, troubleshooting, technical, communication and problem-solving skills. Strong background in dimensional modeling, data mining, design, development, research, documentation and SQL queries. Recognized for ability to analyze complex data structures and extract knowledge to provide creative solutions. Software Engineer/SQL Developer
Humana Inc. WAH
Green Bay, Wisconsin
(2015-2023)
Humana Inc. is one of the largest Insurance providers in the United States. Well-being is our core objective. We believe our role in the insurance industry is to shift perceptions and move beyond being simply a provider. To that end, we work to empower our members and help them live healthy, active and rewarding lives. Humana's diverse lines of business work to serve all types of consumers. From families to seniors to military members to self-employed individuals, there is a plan to meet many unique needs. Find out how Humana's associates and corporate leaders are committed to customer service. Our team uses innovation to deliver results to Working for the Humana At Home LOB we write software and provide services to help our members stay healthy and stay at home as long as possible.
• Designed Oracle applications from detailed business requirements.
• Wrote PL/SQL, SQL and SQLLDR control files to support Oracle applications.
• Created DOS batch jobs used in nightly processes and scheduled them to run using Windows Task Manager with dependencies considered. These jobs processed numerous incoming files both internally and 3rd party inserting the data into multiple oracle databases. These jobs also wrote outgoing files to both 3rd parties and to our EDW team.
• Used Oracles APEX application to develop applications used as the primary GUI for both our internal associates and our members.
• Designed and Created Oracle Database objects to support the APEX applications. 1
• Monitored the Oracle Databases for both performance and data integrity issues.
• Team member on a rotating on call schedule monitoring and troubleshooting our DOS batch jobs.
IT Consultant - Migration and Conversion
TEKsystems - Grand Chute, WI
Grand Chute, Wisconsin
(2013-2015)
TEKsystems is a subsidiary of Allegis Group, the largest private talent management firm in the world. Our longstanding history and industry-leading position speak to our success in providing the IT staffing solutions, IT services and talent management insight required for you to actualize ROI and sustain a truly competitive advantage in a fast-changing market. IT Contractor Community Care Connections of Wisconsin, Stevens Point, WI
Database Administrator/Developer
Data conversion specialist converting data from numerous platforms into SQL Server database structures.
Exported these structures into 3rd party applications Database Administrator/Developer
ASSOCIATED BANC-CORP - Green Bay, WI
(2011 to 2013)
Associated Banc-Corp is a regional bank holding company providing retail and commercial banking, commercial real estate lending, wealth management and specialized financial services. It is headquartered in Green Bay, Wisconsin. At March 31, 2012, it had $22 billion in assets and was the 41st-largest bank holding company in the United States. Associated Bank is a nationally chartered bank; regulated by the Office of the Comptroller of the Currency, Department of the Treasury [2] The Company has over 5,045 employees. Their focus is regional banking, with an emphasis on middle-market commercial banking in Wisconsin, Illinois, and Minnesota. Data Warehouse and Data Mart Design
Reporting to the Business Solutions Manager of Information Management, Responsible for Data Warehouse development and providing business leaders the right information at the right time.
• Gathered business requirements from all LOBS (Lines of Business) used to develop state of the art Data Ware House and Data Mart Models used in predictive analysis, data mining and day to 2
day business decision making.
• Developed data models and ETL processes to load the database objects required to meet the business needs.
• Maintained database performance and enhancement requests by developing detailed templates for business requirements (enhancements), UNIT, UAT and Performance Testing, Data Model Documentation and Data Dictionary Documentation (Meta Data).
• Researched and made recommendations for Data Modeling, ETL and Business Reporting Tools.
• As a member of the data management core team, participated in the strategy and creation of vision statements used to set the course of the future development of reporting structures and the tools to be used, providing extensibility for mergers and/or acquisitions as well as maintaining current business reporting requirements.
• As part of an emergency red line effort, programmed PLSQL procedures used to load ACTIMIZE data structures required by the federal securities commission supplying alerts for possible Anti Money Laundering (AML) and to be in compliance with the 2012 Banks Secrecy Act (BSA) reporting requirements.
• Performed multiple cross discipline tasks utilizing my experience in all phases of application development, Data Warehouse design, ETL, BI Reporting and Customer Support as a member of the Business Solutions Data Management Team.
• Technology Skills: PLSQL, InformEnt, TOAD For Oracle DBA Suite of tools, TOAD Data Modeler, Subversion, Tableau, Knowledge Share, SharePoint, SQL Developer, Power Share, Notepad++, Oracle Database, SQL Hyperion.
Lead Member Technical Staff
SCHNEIDER NATIONAL, INC
(2000 to 2010)
The largest truckload carrier and logistics provider in North America with over 21,000 employees and $3.4 billion in revenues.
Reporting to a Business Transformation Partner. Responsible for creating Oracle solutions which delivered information critical for daily decision making and forecasting to all business sectors. Data warehoue developer/designer
• Introduced advanced SQL techniques available in Oracle's 10g and 11 installations which enhanced performance by 50% in critical reporting areas. 3
• Administered Oracle's Business Intelligence Publisher (BIP) toolset implementing optimization configurations which solved existing issues and saved 25% in the development lifecycle.
• Researched reporting functionality available in Oracle's Business Intelligence Suite Enterprise Edition (OBIEE) and BIP and provided solutions for reporting gaps and unfulfilled requirements which improved report functionality.
• Designed standardized BIP templates streamlining business letter creation by line of business which reduced time required to produce external documents by 40%.
• Developed a standardized BIP reporting process following industry best practices which improved and clarified the BIP and OBIEE report development lifecycle, reducing new resource learning curves by 50%.
• Created solutions for existing issues in Oracle's toolset providing valuable reporting methods which eliminated duplicate reporting and saved 95% development time. Migration and Conversion
• Generated documentation identifying complex data flows, relationships and hierarchies which were leveraged by numerous conversion utilities, saving 20% front-end conversion and migration development time.
• Configured Siebel and EBS parameters which ensured compliance with business requirements.
• Identified Siebel and EBS Flex value functionality, designing solutions not available in out-of- the-box applications.
• Authored standardized business and technical documents modeling step-by-step migration plans that cut migration development by 25%.
Analytical Data
• Introduced dimensional data modeling which streamlined analytical reporting functionality and development.
• Created a metadata repository used by Extraction Transformation and Load (ETL) and report developers as well as end-users, resulting in increased developer productivity and end-user metric clarification which reduced support calls by 25%.
• Developed dimensional data modeling standards and best practices which saved 10% on new developer start to productivity time and provided consistent design and accurate metric values across Data Warehouse and Data
reporting capability which eliminated 10% of end-user reporting requirements. 4
• Developed and documented Erwin modeling tool standards and best practices which resulted in greater productivity and accurate development statistics leveraged by project assessment teams.
• Performed specific data analysis and SQL query development geared to solve existing business issues or to provide information required to forecast business needs and allocate resources accordingly.
• Implemented Cognos Report Suite of reporting tools resulting in streamlined end-user reporting.
• Optimized repository configurations which achieved 25% performance gains.
• Developed and implemented regression testing ensuring new implementation success.
• Developed and implemented Fine Grain Access (FGA) Security, allowing end-users a virtual private database which saved the creation of separate databases per customer.
• Technology Skills: PLSQL, Erwin, TOAD For Oracle DBA Suite of tools, Rational Rose OBIEE, ODI, Informatica, BIP, COGNOS, SQL SharePoint, SQL Developer, Business Objects, Oracle Repository Manager, Notepad++, Hyperion, CRM, Siebel, EBS. Lead Application Designer - Developer
PROVANTAGE - Green Bay, WI
Green Bay, Wisconsin
(1995 - 2000)
A comprehensive health benefit management company and full-service provider of clinical decision support services to the Health care industry. A division of Shopko Stores, Inc. Reporting to the Senior Project Manager, ProVantage Applications. Responsible for analytical requirements gathering, logical and physical database design and implementation, report repository and end-user reporting development.
• Introduced MicroStrategy Report toolset and functionality, establishing company's first web- based reporting solution.
• Developed dimensional data modeling standards and best practices documentation which became the foundation of future analytical project standards.
• Provided technical assistance to development teams, resulting in knowledge collaboration and increased productivity.
• Technology Skills: PLSQL, Erwin, TOAD For Oracle, Rational Rose, Informatica, Microstrategy, 5
SQL SharePoint, SQL Developer,, Oracle Repository Manager, Notepad Computer Programmer - Technician and Networking Specialist SILVER BAY COMPUTER TECHNOLOGY
Eagle River, Wisconsin (1994 - 1995)
An independent computer company providing customized software and networking services. Director of Product Development
Computer Programmer
PHARMACY DATA SYSTEMS - Eagle River, WI (1988 - 1994) Cranberry Farmer
1977 to 1988
Education
Associate Degree in Data Processing and Accounting Nicolet College - Rhinelander, WI
1987 to 1988
B.A. in Vocational Rehabilitation
University of Wisconsin - Menomonie, WI
1974 to 1977
Associate Degree in Transportation Distribution
Northeast Wisconsin Technical College - Green Bay WI 6
Contact this candidate