TECHNICAL SKILLS

• SQL
• T - SQL
• PL/SQL
• Progress / Open Edge ABL
• Java
• Objective C
• Visual Basic
• C++
• Microsoft SQL Server Management Studio
• Python
• SSRS
• Tableau
• Power BI
• QlikView
• QlikSense
• Confluence
• Jira
• Github
• Splunk
• Azure database environment
• Microsoft Visual Studio
• QAD ERP Software
• MFG / PRO
• Xima Chronicall
• SSAS
• SSIS
• Pentaho
• Management Reporter
• Carelogic Qualifacts
• Actuate Reporting
• Crystal Reports
• Actuate Reporting Tool
• Infor ERP Syteline
• Business Intelligence Studio
• Eclipse
• SAS & R
• GitHub
• Splunk
• Microsoft office.

PROFESSIONAL EXPERIENCE

SQL Database Administrator

Confidential - Mount Prospect, IL

Responsibilities:

• Created, tested, documented stored procedures, queries, triggers, views, functions and packages using SQL, Python, T - SQL, PL/SQL in Azure database environment.
• Created and maintained complex reports using SQL Server Reporting Services (SSRS), Crystal Reports and Syteline.
• Worked and supported with ERP and Business Analysts on project - logs.
• Developed, maintained ongoing support of all business related systems.
• Accomplished systems requirements by developing and maintaining Business Applications.
• Worked with ERP troubleshooting, requirements gathering, design, write and test applications; problem reporting.
• Managed ticketing queue for errors, issues and enhancement requests. This includes providing access, creating and maintaining reports, creating and maintaining workflows and other efficiencies.
• Used SQL Profiler for troubleshooting, monitoring, optimizing of SQL Server and SQL code
• Created and modified ERP user forms in Infor ERP Syteline as required to provide enhanced functionality.
• Extensive knowledge and experience in producing tables, reports and handling large databases to perform data manipulations
• Coordinated with third party support to install, diagnose, repair, maintain and upgrade computer environment
• Coordinated with third - party vendors for hardware, software, and telecom needs to ensure optimal network and related systems performance in a timely and accurate fashion.
• Analyzed data discrepancies, anomalies, and other reporting related issues
• Provided impact analysis and corrections after consulting business partners.
• Responsible for SQL backups, maintenance and recovery.
• Created and maintained Excel Data pivots using ODBC.
• Maintained an accurate and up - to - date inventory of departmental hardware and software
• Completed all tasks assigned and followed up with requester to ensure user satisfaction

Data Engineer

Confidential - Schaumburg, IL

Responsibilities:

• Created and tested stored procedures, queries, triggers, views, functions and packages using SQL, Python, T - SQL, PL/SQL in Azure database environment.
• Created reports using Tableau, SQL Server Reporting Services (SSRS) Power BI and QlikView.
• Utilized Jira, Splunk and GitHub system.
• Worked closely with other departments to gather and document functional technical report requirements for new reports.
• Translated changes to reporting solutions using database structures and collaborated on priority initiatives.
• Analyzed data sets and provided the team suggestions and solutions.
• Drafted communications and other documentations related to the functional support of reports, reporting sources, and application systems.
• Worked with ETL process within Azure databases.
• Managed and oversaw all data science database objects, tables, views and procedures.
• Maintained deep understanding of organizational data to provide guidance as needed.
• Oversaw and directed data governance, data availability, usability, consistency, data integrity and data security processes with the team.
• Queried data sources for use in models, reports, analysis, and business decisions.
• Worked closely with users to ensure that reports meet the business need. combine
• Diagnosed and resolve production problems for reports and applications. Captured, analyze and monitor enhancement requests for reporting and application systems.
• Maintained open and clear communication with IT, product team and technical team members to effectively specify project scopes, manage issues and communicate timelines and project status.
• Designed, developed and re - engineered highly complex application components.
• Integrated software packages on multiple platforms.
• Analyzed business requirements and translate them into technical objectives.
• Created web reports and deployed these reports in the production environment.
• Resolved application and technical problems of the highest complexity.

Programmer Analyst / Developer

Confidential - Wheeling, IL

Responsibilities:

• Understanding of business operations and business systems in QAD, Supply Chain solutions, EDI, Supplier Portals, CRM and BI.
• Determined technical and business process solutions and implemented them in conjunction with other IT staff and the business.
• Participated in Progress 4GL development activities that included requirement gathering and analysis, designing programs as well as performing software testing and debugging in compliance with established application development standards
• Developed scripts for the testing in progress coding of proposed scenarios as well as any reported problems.
• Created, Maintained and supported QAD application software and other interfaces around QAD.
• Designed, developed and maintained customized modules and design specs based on user requirements.
• Participated on ERP upgrades and implementations of added functionality.
• Provided business continuity and disaster recovery support if needed.
• Continued company provided training in QAD and Progress 4GL.
• Created SQL Databases and imported form and reports from Microsoft Access and created SSRS reports.
• Developed, maintained ongoing support of all business related systems.
• Accomplished systems requirements by developing and maintaining Business Applications.
• Included ERP troubleshooting; requirements gathering, design, write and test applications; problem reporting.
• Provided detailed specification and followed standard programming procedures.
• Worked with OLTP & OLAP environment, ETL, Data Mining, QA and development databases in SQL Server
• Collaborated with staff on solutions to integrate with Microsoft’s Business Intelligence Systems and input data to the Data Warehouse
• Supported existing applications within the Business Intelligence System and Data Warehousing technical stacks.

Business Systems Analyst

Confidential - Des Plaines, IL

Responsibilities:

• Created and tested Stored Procedures, queries, triggers, views, functions and packages using SQL, T - SQL, PL/SQL
• Created complex visualization reports using Pentaho, SQL Server Reporting Services (SSRS), Crystal Reports, SharePoint, and .Net
• Supported the development and implementation of enhancements or new releases
• Reviewed and analyzed client requests and create functional specifications of moderate to high complexity.
• Created and execute test plans, following established standards.
• Assisted in analyzing and assessing the feasibility of proposed enhancement requests for reports and application systems
• Worked closely with other departments to gather and document functional technical report requirements for new reports and translate those changes to reporting solutions using database structures
• Worked closely with users to ensure that reports meet the business need.
• Diagnosed and resolve production problems for reports and applications, including responding to problems during off - hours when required.
• Captured, analyze and monitor enhancement requests for reporting and application systems.
• Worked with the IS Support Center to ensure effective communication of issues and resolution.
• Analyzed business processes related to LSSI reporting and applications.
• Collaborated with key business owners to help prioritize enhancement requests.
• Drafted communications and other documentation related to the functional support of reports, reporting sources, and application systems.
• Worked as a team member of the Information Systems department to support current and ongoing initiatives.
• Participated in the full development life cycle for enterprise - wide reporting efforts.
• Applied LSSI's Project Management methodology to assigned projects
• Adhered to the highest degree of professional standards and strict confidentiality.
• Designed, developed and re - engineered highly complex application components.
• Integrated software packages on multiple platforms.
• Analyzed customers reporting requirements and provided best reporting solutions.
• Created web reports and deployed these reports in the production environment.
• Resolved application and technical problems of the highest complexity.
• Performed other related tasks as necessary or assigned.

SQL Developer / Report Writer / IT Specialist

Confidential - Mt. Prospect, IL

Responsibilities:

• Created, documented and tested Stored Procedures, queries, triggers, views, functions and packages using SQL, T - SQL, PL/SQL.
• Designed, implemented and evaluated custom reports in MS SQL, Crystal Reports, SSRS, VBScript Coding
• Developed and troubleshoot custom reports in Crystal Reports and SSRS
• Worked with OLTP & OLAP environment, QA and development databases in SQL Server
• Used SQL Profiler for troubleshooting, monitoring, optimizing of SQL Server and SQL code
• Created and modified ERP user forms in Infor ERP Syteline as required to enhance functionality.
• Extensive knowledge and experience in producing tables, reports and handling large databases to perform data manipulations
• Served as a desktop support for all three locations
• Coordinated with third party support to install, diagnose, repair, maintain and upgrade computer environment
• Coordinated with third–party vendors for hardware, software, and telecom needs to ensure optimal network and related systems performance in a timely and accurate fashion.
• Served as a source of technical assistance to employees for hardware, software, and telecom needs when the situation is deemed too critical or impractical to be addressed by third–party support personnel
• Analyzed data discrepancies, anomalies, and other reporting related issues
• Provided impact analysis and corrections after consulting business partners
• Maintained an accurate and up–to–date inventory of departmental hardware and software
• Completed all tasks assigned and followed up with requester to ensure user satisfaction

BI Developer

Confidential – Oakbrook, IL

Responsibilities:

• Created and tested queries and stored procedures, queries, ad hoc reports, triggers, views, functions and packages in SQL Server Management Studio
• Worked with created custom reports in SSRS, maintaining new databases, Performance tuning, deploying and scheduling reports.
• Utilized data analysis techniques and queries to provide ad–hoc reports, analysis, and datasets
• Generated custom reports utilizing SSRS and SSIS
• Worked with management to identify business cases and collaborated the development to the staff
• Collaborated staff on solutions to integrate with Microsoft’s Business Intelligence Systems and input data to the Data Warehouse
• Worked with OLTP & OLAP environment, QA and development databases in SQL Server
• Supported existing applications within the Business Intelligence System and Data Warehousing technical stacks.
• Troubleshoot data issues, validate result sets, and assist in the implementation of process improvements.
• Worked with other departments to understand business rules and interpret data Qualifications & Experience.