Dan Mccance Email & Phone Number

Warren, Mi

• Develop detailed understanding of system data and apply SQL, data engineering, and visualization skills to create intuitive Power BI and Tableau dashboards, providing more efficient and effective ways to manage issues identified during the product lifecycle.

Detroit, Mi

• Support the internal audit function, as well as all business groups within the organization, using analytics tools such as Alteryx, Microsoft PowerBI, and Tableau to streamline processes, allow for full population testing instead of sampling, and provide meaningful insights into the data through data visualizations• Combine/blend and cleanse large data sets using various ETL (Extract, Transform and Load) techniques from/to multiple disparate systems

Detroit, Mi

• Application Subject Matter Expert (SME), level 3 application support lead and lead innovation PL/SQL developer for a core global finance application on Oracle Database 12c• Mentor junior/mid-level developers to translate business requirements into application logic, provide code reviews and help them learn new skills• Manage application enterprise code vault and code version control using TortoiseSVN

Greater Detroit Area

• Conceptualize, design, develop and deploy Oracle PL/SQL functions, stored procedures, packages, programs, chains and scheduled jobs• Perform ETL (Extract, Transform and Load) operations, data analysis and correction in a distributed environment involving multiple databases and database links• Understand and modify existing code to fix issues or meet new business requirements• Perform Oracle Discoverer BI utility administration and maintenance, query/report design and development, query support and user training• Work at the client site full time, frequently meeting with the business process owners to discuss their needs with respect to existing or new database processes

Pontiac, Mi

• Conceptualize, design, develop, integrate, deploy and maintain the data layer and data components by applying specialized knowledge of information, data and database management disciplines in support of multiple clients.• Primary focus areas: Oracle database administration (DBA); application development; data modeling (ERwin); data extract, transform and load (ETL); SQL and PL/SQL programming; data warehouse project work; use of database utilities such as SQL*Plus, SQL Developer and SQL*Loader; UNIX C Shell scripting; additional experience with DB2 and SQL Server DBMS• Experience with Agile and iterative software development methodologies• CERTIFICATIONS: Oracle 11g Certified Associate (October 2013–Present)

Detroit, Mi

• Led 4 classes per week where the students worked in small groups to solve advanced problems, which the lecturers and I developed, to take the students’ understanding of the standard departmental course material to the next level

Novi, Mi

• Developed, implemented and directed a new inventory and storage process for car radios• Drastically reduced the dealership's operating costs through meticulous inspection and documentation of all inbound vehicle damage – estimated monthly savings: $800.00• Oversaw the inspection and relocation of approximately 500 vehicles purchased from a competing Chrysler dealer• Supervised car porters which included training and scheduling

Novi, Mi

• Demonstrated excellent interpersonal skills resulting in an unusually high number of return customers and referrals considering the short term the position was held

Oak Park, Mi

• Strengthened department operations which played a key role in facilitating departmental growth - tripling in size during my time at the company • Supervised up to 5 landscape construction crews with focus on quality, efficiency and safety • Developed safety standards, practices and procedures to reduce/eliminate potential hazards • Coordinated department logistics including material handling, inventory management, equipment allocation and efficient route planning • Led weekly crew safety/training meetings to provide company wide policies/procedures for installations and to ensure OSHA and MDOT compliance