SUMMARY:

• Highly proficient in Crystal Reports development and writing SQL scripts using Sybase, MySQL, T - SQL, Microsoft SQL and PL/SQL Oracle.
• Very experienced in SQL Query report writing, data collection, validation, consolidation and cleansing.
• Strong background with relational data modeling, manipulation, management & reporting.
• Primary emphasis over the years has been with business systems analysis, development and implementing business applications.
• Extensive experience as a Software/Hardware Technical Liaison, diagnosing/troubleshooting issues and either fixing the problem or reporting them to the appropriate party.
• Solid background/understanding of Sales & Marketing software systems, with emphasis on distribution channel business systems.
• Extensive management skills, demonstrated proficiency in leading medium to large scale projects with experience working on many sizes/types of teams and mentoring others.
• Excel at problem solving & analytical thinking, consistently resolving issues and defects.
• Ability to work effectively within a geographically distributed team, working with Technical, Sales Staff and customers worldwide.
• Excellent oral & written communication skills, strong organizational and technical skills, strong sense of ownership, work ethic, direction & judgment, accessibility and vision.

PROFESSIONAL EXPERIENCE:

Confidential, Green Bay, WI

Crystal Reports Developer/Crystal Server Administrator/Business Analyst

Responsibilities:

• Brought in on urgent requirement to replace former Crystal resource that was let go. Member of the Business Intelligence team in Information Services Department. Confidential had approx. 2,000 Crystal Reports and thousands of recurring scheduled jobs running on the server, responsible for most of the domestic reporting for Oracle systems for home office & multiple plants domestically.
• Primary (sole) Support resource for Crystal Reports for the company. Go-to guy for all things related to Crystal at Confidential . Managed daily HEAT tickets for support, ongoing system maintenance & enhancements to Crystal Reports and SQL code. Worked with business (Finance, Customer Service, Production Management, Logistics, etc.) to improve processes.
• Administrator for Crystal (CMC) Central Management Console. Responsible for daily monitoring and working with Company IT Helpdesk on Support issues. Trouble shooting failed Crystal report scheduled job instances, fixing bugs & optimizing problem reports & SQL, scheduling new jobs, modifying scheduled jobs and on-going maintenance.
• The company decided not to upgrade from Crystal 2008 and launched a Crystal to OBIEE (Oracle Business Intelligence Enterprise Edition) Migration Project in 2016. All Crystal Reports are either being deleted or converted/developed/migrated “like-for-like” to BI Publisher Reports. This is huge effort, very costly and taking a long time. I am a vital contributor to the project, which is nearing the end.
• Responsible for writing design documents for hundreds of Crystal Reports to be migrated into BI Publisher. Worked with dozens of BIP developers at the company worldwide, project managers, business owners & testers to ensure the newly developed BIP reports match Crystal reports.
• Company also upgraded from UC4 to Automic. I learned the process in a few weeks time and setup hundreds of the new BI Publisher reports in OBIEE custom scheduling tables (writing SQL scripts & executing via FlexDeploy tool). Setup (Automic) jobs & schedule object tasks that launch BIP reports on recurring schedules. Having a good understanding of both the Crystal side and OBIEE side has been a bonus. I have been able to produce great results in a very timely manner.

Confidential, Vancouver, WA

Crystal Reports/PLSQL Developer

Responsibilities:

• Worked with DBA in modifying Oracle PL/SQL scripts to use relational database model for tables, views & overall improved reporting performance. Several reports required dozens of database table/view joins to retrieve the correct data.
• Sole development resource on Canadian Forestry Site Project to re-write/convert several dozen reports to SAP Crystal Reports 2013.
• With all the changes, report performance was drastically optimized. Users & Management were very pleased with results.
• Lots of requirements gathering, daily coordination on project timeline/status, and testing/data validation with the users and DBA.
• Wrote specifications & documented reports in new system. Gathered metadata definitions & added optional display page to each report.
• Developed new report standards with guidance from management. Used Crystal sub-report links for standardized report headings, logos, titles & labels that pulled data into reports from database properties table.
• With a limited budget for the project, had to be extremely aggressive & efficient in meeting numerous deadlines & timelines for requirements gathering/analysis, various design/development stages & UAT/testing phases.

Confidential, Alpharetta, GA

Crystal Reports/PLSQL Developer

Responsibilities:

• Performed Oracle PL/SQL developer role in Analysis, Design and Implementation of Business Applications.
• Agile environment, assigned to multiple Agile Scrum teams with development primarily Java, Crystal Reports, Oracle PL/SQL backend & other layers.
• Primary developer emphasis was on Standard Reports of the “ Confidential Workforce Now” product, as well as support of “Pay eXpert” product.
• Support & new development included 150+ Worldwide Standard Reports impacting thousands of worldwide customers in Production environment. As well as many reports in the various stages of development/testing/QA for enhancements and defect/bug fixes.
• There was a lot of “support liaison” work involved in this role. It included working with the DB team, various infrastructure groups, product owners, testers & QA personnel, corporate helpdesk personnel, managers & other developers.
• Had to become very familiar with full stack of technologies & layers involved with reporting -- from end-to-end.
• There were numerous logs to review in Splunk tool, to see when/where/why the report completed in Error.
• Lots of multi-tasking involved. A typical day would include receiving several emails & being assigned to new problem tickets from the U.S. overnight India Reports team regarding new Production report issues.
• U.S. based team basically consisted of my boss (the Manager of Application & Development) and myself.
• Had to utilize good prioritization, punctuality, multi-tasking and lots of troubleshooting focus (with little to no supervision/direction).
• On a typical day, besides troubleshooting environment related issues for Standard Reports, attended phone/Skype bridge/online working sessions on a regular basis, multiple daily meetings & daily Agile Scrum Team “Stand-Up” meetings.
• Also, could not let my normal development project tasks & deadlines slip for upcoming software patch & major releases.
• Confidential developers adhered to release, project & development deadlines and worked with the Agile methodologies using the Rally tool -- i.e. User Stories, Defects, Sprints & Releases concepts.
• Became U.S. “point man” in managing software open ticket queue in CA Service Desk Manager tool to track Problem Detail tickets.
• When arriving at Confidential, there were 80+ open problem tickets (along with nearly 400 open software defects). Was instrumental in getting this ticket count down to 0 tickets at one point in 2016 before leaving the company in May. A goal of less than 10 open problem tickets was set, to keep the queue at a manageable number. Was personally instrumental in this becoming the “norm.”
• Had to always be aware of the “hot” tickets, track & manage open problem tickets and communicate and give status/feedback to managers and the team when escalation occurred.
• “Triaged”/reproduced report issues from end-to-end in Production & QA environments, and used knowledge/judgment to transfer tickets into a Rally system software defect for the Agile Scrum Master to rank/assign.
• As a motivated self-starter, also took it upon myself to learn new tasks on personal time.
• Learned to export the client’s database from Production & to import (using Unix/Bash script) the client’s database into QA environment for troubleshooting, reproducing issue & ultimately a resolution.
• Were many report troubleshooting tasks involved to decipher and fix reporting issues. This included running Crystal Reports with the client’s exact parameters to reproduce the error if possible, reading log files (Splunk), tracing errors & knowing when to involve other personnel/teams (Java developers, Configuration Management, Database, Web Tier, etc.) to resolve the issue.
• Accessed Crystal Server console regularly to read error logs, manually publish new Crystal template versions & troubleshoot/fix issues.
• Heavily involved in a project to convert many “Standard” reports for clients to “Partner” reports. A Partner may have several Clients, so the data would need to be retrieved & reported for all Clients.
• Became the “go-to-guy” on the team for converting the Crystal report templates, modifying SQL scripts & testing based on the new proof of concept for “Partner” report framework.
• Created a Reports troubleshooting knowledge base using the Confluence team collaboration software internal website. Common “issues/problems” were logged with a problem, investigative steps involved and a solution. This was a great tool for current & future use, when similar/same problems “popped up” again.
• Was very little support, development & report issues troubleshooting documentation when starting at Confidential . Documentation that existed was mostly outdated, or in old emails that people had saved. As with the Reports troubleshooting knowledge base, also started a Standard Reports Development Team Support & Training page on the team’s internal Confluence website. Much of the information available was gathered then compiled into single, concise documents and web pages, with troubleshooting steps. This became a great tool for support & also for onboarding new developers.

Confidential, Boise, ID

Business Analyst/Crystal Reports Developer

Responsibilities:

• Led migration of reports for several customers/accounts from legacy system (BRIO) to Business Objects.
• Had interactions with multiple HP accounts to understand current and future reporting needs/requirements.
• Ensured that each account's reporting solution was migrated & that all requirements were met successfully in the new environment.
• Assisted in account-specific reporting & down-stream systems, and provided gap analysis to SRA & helped resolve gaps.
• Documented scope, performed gap analysis & resolved the gaps identified and raised awareness on risks to perform risk mitigation.
• Extracted, transformed, and loaded (ETL) data into useable format for the new customer reporting data warehousing system.
• Conducted report analysis, design, configuration and customization in the Business Objects Infoview environment.
• Executed report migration activities and supported both Customer Acceptance Testing activities (CAT) and Move to Production activities.
• Using hard deadlines, performed thousands of hours of Crystal Reports development, troubleshooting & testing to meet customer needs.
• Development Web Intelligence (WEBI) reports in Business Objects environment for ad-hoc reporting.
• Worked with the testers using HP ALM tool to test the reports & complete the end user acceptance.
• Followed Quality Management System (QMS) to ensure consistency & improvement of working processes.
• Environment was self-directed a lot of the time. Strong teamwork & individual initiative was required.
• All of this, while working in an international virtual environment (sometimes, English not being the first language).

Confidential, Boise, ID

Software Engineer

Responsibilities:

• Highly proficient in business systems analysis & development, and in writing/modifying SQL scripts, stored procedures & triggers in Sybase, T-SQL, Microsoft SQL, MySQL and Oracle PL/SQL.
• 15+ years working on Sales & Marketing IT Team as business analyst & developer. A solid contributor over the years. Supported Sales & Marketing end users & offices 24x7 worldwide.
• Lead Analyst/Developer on numerous medium to large scale (and special) projects. This included multiple Legacy-to-ERP Migration Projects, Y2K Project & T-SQL/Microsoft SQL Migration Project.
• Several year’s solid experience as Technical Developer/Liaison -- working to resolve critical production issues, identifying/fixing the problem, reporting issues/roadblocks, troubleshooting software problems & working with other teams to apply S/W patches & upgrades.
• Technical Developer/Liaison activities included 24x7 interactions with multiple groups & teams, including several Third Party Software vendors’ technical teams & support staffs, Confidential ’s internal end-customers & testing teams and multiple internal software/hardware infrastructure groups & other software developers.
• Selected as a charter member to Confidential ’s SAP Technical Team in 1998, with primary focus on legacy data conversions to SAP. ABAP developer from 1998 until 2008, with emphasis on SD-OM module of SAP.
• Migrated/re-wrote many legacy reports to new reports using Crystal Reports. Reports were launched from a Visual Basic app. menu.
• Lots of development & daily software support for numerous client-server applications, external to SAP system.