Jeffrey A. Lipe

**** ******** ***** • Kernersville, NC 27284 • 336-***-**** • adu55z@r.postjobfree.com

Profile

I have had the privilege to act in such roles that require that their employee act as a strategic thinker and effective communicator using data to figure out market potential and business trends for organizations. I am a collaborative, integrative and critical thinker always striving for innovative ways to solve complex business performance problems. I have over 15 years of experience mining strategic and financial data in complex environments to assist in determining the behavior and habits of customers. In my career I have been able to operate within different business units and teams across multiple different platforms in developing reports and applications.

Qualifications

Data Mining / Methodology

SSRS

ASP.NET / VB Development

SQL Server

Requirement Gathering/Collaboration

T-SQL / PL SQL

Vision Studio / BIDS

Full Life Cycle Development

Data Modeling

SSIS

BI Development

Web Development

Professional Experience

Market America Greensboro, NC January 2018 - Present

BI SQL Developer / DW Developer

Build an understanding of the business and how it maps to databases, then develop processes, reports or tools to extract the data needed.

Developed several Tableau reports for Marketing and placed them on our Tableau Server.

Use MS SQL/SSIS/SSRS and Excel technologies to maintain and improve business reporting and analytics.

Develop and maintain the existing vault of T-SQL Queries and stored procedures.

Work with other SQL developers to develop and extend data warehouse modeling to provide flexible and efficient access to information.

Lead projects to improve report development/deployment workflows.

Work with business users and business analysts to identify information needs and design effective reporting and information delivery.

Build, test and deployment of MSBI components across multiple environments.

Build new Power BI reports based on user and departmental requirements.

Assist in the development of the company’s dashboards for customers and owners.

Performance tuning of T-SQL Queries, stored procedures, SSIS packages, SSRS reports and SSAS databases.

Management and monitoring of SSIS, SSRS, SSAS environments.

Trained others on the team on how the data flows from the production database to reports.

Carolina Donor Services Winston-Salem, NC May 2016 – December 2017

BI Report Developer

Built highly visible reports for all NC hospitals to see on organ and tissue transplantation.

Assisted in building system that sent data from Winston Salem to Greeneville.

Built drill through reports by organ transplanted which allowed the necessary departments to start sending out sympathy cards.

Assisted on any web changes done to the site that incorporated reporting.

Krispy Kreme Doughnut Corp Winston-Salem, NC February 2007 - April 2016 Programmer Analyst / BI Developer

Created highly visible SSRS reports that provided financial results of the company on both the wholesale and retail ends of the business.

Trained team members on how to develop reports and maintain them through the organizations reporting server.

Developed and maintained VB and ASP .net applications that provided the organization an avenue to insert general ledger data

Assisted in the maintenance of a SSAS cube that provided the Marketing department a decision making tool for future marketing strategies.

Jeffrey A. Lipe

1777 Eastover Drive • Kernersville, NC 27284 • 336-***-**** • adu55z@r.postjobfree.com

Created an SSIS package that imports transactional data from the company’s POS system into a relational database that multiple SSRS reports used on a daily basis.

Acted as the primary support of the company’s reporting infrastructure with such roles as developer to the report server administrator.

Acted as the SME in Joint Application Design (JAD) sessions with Research Analyst to identify business rules and requirements and document them in a format that can be reviewed and understood by both business and technical people.

Analyzed the effectiveness of current systems and procedures within the organization to help achieve the long and short term goals set in each department.

Collaborated with multiple departments in the efforts to create multidimensional web based applications used in all areas of the organization.

Used Agile software development methodology in defining the problem, gathering requirements, development iterations, business modeling and communicating with the technical team for development of the system.

Analyzed the department’s business requirements to determine the proper database design and application type needed based on the needs of the end users.

Constantly stayed on top of the most recent data mining and reporting solutions to better serve the organization’s demands.

Designed and developed ETL/SSIS packages that extracted data from various sources to import into a SQL server database for the use of applications and reporting environments.

Extracted data from the organizations Iseries / AS400 in order for reports to be built in SSRS to reflect the wholesale sales for the previous day.

Key Accomplishments

August 2008

Created a financial report that provided a detailed look on all areas of each store within the corporation ranging from retail sales to labor hours. The report was automated to email out every morning to upper management to give them a high level view of how the company did as a whole for the previous day and week.

June 2011

Created a standardized application that allowed for other members in the Application Development department to use when they were in need to develop a new application for other departments. This application allowed for a quicker turn around in getting their projects into production quicker while at the same time saving the I.T. department man hours needed for other issues.

September 2013

Assisted in the development of a SSIS package that migrates data from the organizations POS system into an existing legacy database so that the existing SSRS reports will be able to report off the transactional data of store sales. This saved the I.T. department the immediate need to assign a dedicated resource to migrate all reports right when the new POS system was put into place.

Voyager Expanded Learning Dallas, TX December 2003 – January 2007

Data Analyst/Report Developer

Implemented Microsoft (MS) Reporting Services and provided training for Voyager’s structured Operations team.

Installed and configured the MS Reporting Services Report Manager application for web reporting environment access.

Responsible for the development and maintenance of Data Transformation Services (DTS) packages that support data uploads to Voyager’s external clients.

Developed technical documentation and procedures to assist others in the reporting process.

Prepared reports, recommendations, and/or alternatives for improving processes in reporting systems across the organization.

Worked with Database Staff to enhance and maintain database efficiency.

Created SQL Server jobs to perform nightly database maintenance and report creation.

Developed, tested and implemented SQL functions and procedures for products used by internal business customers.

Created dynamic T-SQL to allow end user interaction using a web interface with Crystal and MS Reporting Services.

Jeffrey A. Lipe

1777 Eastover Drive • Kernersville, NC 27284 • 336-***-**** • adu55z@r.postjobfree.com

Key Accomplishments:

January 2005

Saved Voyager over $15K per year by creating DTS packages which effectively integrated client data with a third party data entry system.

July 2005

Evaluated reporting products and recommended MS Reporting Services saving over $40K per year. Converted 35 Crystal Reports to MS Reporting Services prior to migrating over to Voyager’s new data model.

November 2005

Developed a company website using MS Sharepoint to allow for document sharing and automated report subscriptions for external users. This eliminated the need to contract outside the company for assistance in statistical analysis.

Vartec Telecom Dallas, TX September 2002-November 2003

Marketing Analyst II

Developed MS Excel and Access reports for customer acquisition and attrition analysis.

Developed reporting process and procedures technical documentation.

Performed data warehouse application validation.

Analyzed, documented and converted business requirements into reports.

Enhanced existing SQL statements for extracting data and automatic report delivery.

Aegis Communications Group Irving, TX August 1998 – August 2002

Business/Systems Analyst

Acted as the primary liaison between customers, operations, and application engineers to ensure project success.

Gathered all available business requirements and converted them into system procedures and specifications.

Analyzed and designed the applications system and application specifications.

Developed test plans and cases in order to assist QA in application analysis and validation.

Created customized SQL reports for statistical analysis.

Built strong business relationships with each client in order to ensure open and honest communication.

Designed and modeled CRM application database structures.

Documented common problems and prepared process control manuals to assist in change control procedures.

Analyzed clients’ business structure to understand customer interests and improve website design and navigation.

Assisted the Engineering Department by documenting projects, processes and modifications.

Documented project specifications including systems design, system architecture, business requirements and feasibility studies.

Tech Support Engineer

Assisted in the creation of SQL online report modules.

Handled technical support calls and trained new employees for an online banking institution.

Coordinated software and hardware issues related to client requests and questions.

Worked in a team of Support Engineers to resolve customers’ technical issues.

Produced technical documents for the online knowledge database that was used to support customer issues.

Customer Representative/Fulfillment Administrator

Improved office efficiency by creating a relational database which housed client registry accounts.

Provided technical and staff support for management’s decision-making process.

Acted as liaison between the development department and the end users.

Worked directly with a medical provider to fulfill customer inquiries via phone or email.

Jeffrey A. Lipe

1777 Eastover Drive • Kernersville, NC 27284 • 336-***-**** • adu55z@r.postjobfree.com

Education

Western Carolina University Cullowhee, NC August 1993 – May 1998

B.S.B.A in Computer Information Systems

Contact this candidate