PROFESSIONAL SUMMARY:

Skilled IT Lead Developer with a successful track record of researching and solving issues and workarounds during design, application development and production support phases. Utilizes strong analytical and technical skills to develop applications in diverse environments using an assortment of development tools. Experience supervising designers, developers, and new team members. Demonstrated capabilities in data warehousing, SDLC, requirements analysis and business intelligence.

TECHNICAL SKILLS:

Software: IBM Cognos Administrator, IBM Cognos Framework Manager, IBM Cognos Report Studio, IBM Cognos Query Studio, IBM Cognos Analysis Studio, Teradata Utilities, Teradata BTEQ, Teradata Parallel Transporter, Teradata SQL, Oracle SQL, PL/SQL, Oracle SQL Developer, IBM DataStage, Java, Visual Basic, Erwin

Hardware: Windows Server 2002, 2008, 2010

Database: Teradata R15, Teradata R14, Oracle 12g, Oracle 11g

WORK EXPERIENCE:

Confidential, Troy, Michigan

Teradata ETL Developer

Responsibilities:

• Led a year - long project that redesigned a Teradata data mart used by the marketing department for customer analysis.
• Data subjects included customer and cost center hierarchies, orders, employees, invoice and imported Dun & Bradstreet data. Developed load scripts for the data mart and exports that sent weekly and quarterly extracts to a marketing services company. Conducted multiple requirement gathering sessions. Responsible for implementation, production support and all documentation related to the project.
• Designed, developed and implemented scripts to data load monthly workers’ compensation claims and workers’ compensation accrual rates into Teradata database.
• Interviewed data owners several times to collect requirements.
• Simplified the process by including logic in the scripts that replaced tasks completed in MS Access database.
• Coordinated with Origami and FTP administrator to design and implement automated transfers of data files.
• Created Cognos Query Studio report for new claims that flagged out of compliance records. Reduced time to load, review and correct claims from 5 days to 2 days.
• Developed ETL scripts using Teradata BTEQ and Teradata Parallel Transporter (TPT).
• Created test scripts and executed testing of scripts. Maintained Teradata tables, views, macros and procedures.
• Supported IBM DataStage CDC and Python scripts used to source Oracle PeopleSoft data into Teradata.
• Created and maintained over 250 weekly reports across 4 Kelly-managed vendor management systems. Data extractions included requisitions, candidates, orders, suppliers and timesheets. Coordinated with FTP administrator and Integrations Team to set up delivery of the reports through FTP and email. Researched and resolved all issues regarding undelivered reports.
• Duties included 1st level support for ETL issues and 24×7 on-call support.

Confidential

Cognos Infrastructure Support

Responsibilities:

• Supported Cognos test and production environments including scheduling, report distribution, user administration, security and backup server administrator.
• Supported user community of over 4,000 internal users and 500 external customers. Responsible for maintaining licensing compliance across multiple agreements.
• Created several Cognos SDK scripts using Java to support daily and weekly reporting. Also created scripts to execute reports based on a fiscal calendar.
• Built report intelligence and user intelligence scripts using Cognos SDK. Data extracted with the scripts were used for report impact analysis, user categorization, user access verification and licensing compliance.
• Coordinated multiple Cognos upgrades. Wrote all documentation related to the planning, testing and implementation of upgrades.
• Directed the execution of test plans and test scripts. Collaborated with Teradata DBA to conduct the performance testing of the upgraded reports on the Teradata database.
• Updated SDK script as necessary. Responsible for managing the upgrade plan and notifying management of changes.
• Communicated updates to the internal user community.
• Lead Designer on project converting custom invoice reporting from Cognos ReportNet to Cognos8.
• Updated technical specifications and supervised development of new reports and triggering process.
• Created and executed test plans. Documented work instructions and trained users.
• Duties included 2nd level support for Cognos issues, 3rd level support for reporting issues and 24×7 on-call rotation.

Cognos Lead Developer

Confidential

Responsibilities:

• Designed and developed over 30 standard Cognos Impromptu reports and 6 PowerPlay cubes for new data warehouse implementation. Responsible for gathering requirements and communicating them to the data modeler and Impromptu catalog administrator.
• Lead developer for project that implemented an external reporting portal in Cognos ReportNet. Created standard customer spend and hours reports for external users. Reviewed designs and test plans of other team members.
• Built custom invoicing reports in Cognos ReportNet to replace reports generated by mainframe jobs. Developed and maintained a weekly process that executed and distributed the reports using Cognos SDK scripts based on a fiscal calendar and other criteria. Created all work-instructions and trained users on the new process.
• Led development on a project to upgrade standard reports from Cognos Impromptu to Cognos ReportNet. Conducted meetings with several report owners to review the requirements of over 50 reports. Responsible for design, conversion and testing of reports along with reviewing documentation of other team members.
• Created step-by-step work instructions for creation of external user accounts. Included steps for creating organizational units and user accounts in Active Directory along with creating Cognos user accounts. Instructions were used to coordinate tasks across multiple teams.
• Established processes and work instructions for creation of internal user accounts in Cognos ReportNet. Instructions included tasks across multiple groups including User Administration, Teradata DBA and hotline support.
• Conducted sessions for business users to create customized Cognos Impromptu reports. Created a process to publish customized reports to Cognos Upfront including steps to secure the report.
• Led several Upfront end-user sessions during the rollout of the new data warehouse.
• Created several step-by-step solutions in case-tracking tool for common problems, requests and questions related to data warehouse and Cognos support.
• Duties included 2nd level support for data warehouse issues and 24×7 on-call rotation. Responsible for communicating outages to user community.

Confidential, Detroit, Michigan

Experienced Consultant

Responsibilities:

• Coordinated performance management project involving Confidential and a major chemical company.
• Identified and investigated 12 applications that were consuming excessive resources; assisted development teams in making appropriate changes to applications.
• Designed and created a new process which automated publishing of PowerPlay cube to a Cognos Upfront server.
• Process eliminated the manual process and saved more than ten support hours per week.
• Directed successful implementation of 17 modified PowerPlay cubes that were used for the analysis of financial data.
• Supervised developers during project. Responsible for reviewing system and application designs and test plans.
• Provided 1st level technical support of the data warehouse as well as 1st level client support for all of the Cognos tools (PowerPlay, Transformer, Access Manager, Impromptu, Enterprise Server).

Lead Designer

Confidential

Responsibilities:

• Responsible for system and application designs for new time-tracking system. Supervised developers charged with programming new applications.
• Created database schematic of more than 100 tables used across five teams during design, development and testing phases.
• Designed over 20 custom windows that provided functionality lacking in vendor software package.