SUMMARY:

Confidential is a database and BI developer with 7 years of consulting experience. As a database and BI developer, he has worked with many technologies including SQL Server, T - SQL, SSIS, SSAS, SSRS, and Power BI. Confidential has worked on projects across multiple industries with many Fortune 500 companies. He has worked on Business Intelligence, large data integration, and data analysis projects primarily in agile environments.

TECHNICAL SKILLS:

• T-SQL
• Microsoft SQL Server - Database Engine
• Microsoft SQL Server - Integration Services
• Microsoft SQL Server - Analysis Services
• Microsoft SQL Server - Reporting Services
• Power BI
• PowerPivot
• Data Analysis Expressions (DAX)
• Microsoft Project
• Microsoft Project Server
• Microsoft Office

PROFESSIONAL EXPERIENCE:

Confidential

Business Technology Analyst

Relevant Skills and Technologies: Requirements Elicitation, Requirements Analysis, Requirements Gathering, and Requirements Management, Mobile Technology on iOS and Android, JIRA

Responsibilities:

• Working in an agile environment Confidential worked closely with the client and lead Confidential to elicit, gather, and refine requirements for both the mobile app and dashboard.
• He also assisted in testing the mobile app and dashboard and working with the technical team to create and resolve defects.

Confidential

Technology Analyst

Relevant Skills and Technologies: Azure, Power BI, Requirements Analysis

Responsibilities:

• Confidential worked closely with the technical team to deliver technical documentation for an Azure solution providing details around the architecture, services, data logic, and data flow.
• Additionally, he was responsible for compiling and delivering all the solution source code.

Confidential

Database and Reporting Developer

Relevant Skills and Technologies: T-SQL and SSRS

Responsibilities:

• Confidential worked closely with product and industry SMEs to elicit, gather, and implement requirements for database and reporting (SSRS) solutions.
• He was responsible for developing and refactoring SQL Server stored procedures and functions and SQL Server Reporting solutions.
• Additionally, he performed in-depth data analysis for product testing leveraging SQL Server and Excel.

Confidential

ETL Developer

Relevant Skills and Technologies: SSIS, T-SQL, SSRS, Oracle 11g, Excel 2013

Responsibilities:

• As a part of an agile team Confidential developed robust SSIS packages working directly with the client and key stakeholders to elicit and gather requirements.
• He leveraged T-SQL and PL/SQL to analyze data and develop ETL solutions.
• He also implemented error handling and logging and an email alert solution.
• Confidential was also responsible for developing SSRS reports according to client requirements.
• In addition to these responsibilities, Confidential reported project status and updates to Confidential leadership.

Confidential

Business Analyst and Solution Developer

Relevant Skills and Technologies: Confidential Server, C#, Excel 2013

Responsibilities:

• Confidential provided analysis between the technical and business teams in an agile environment.
• He provided functional and technical specifications for build activities and worked between the business and technical teams to further clarify requirements.
• He also worked as a liaison between the testing and build teams on identifying and resolving defects.
• Leveraging C# he developed a complex flat file parser for multiple file formats coming from a third-party vendor.
• Confidential also developed and distributed a small .NET program to check for services running on user's local machine.

Confidential

Business Analyst

Responsibilities:

• Confidential provided requirements for the Company’s new HR product platform built on Confidential .
• He worked directly with the client product team, product stakeholders, and Confidential Architect to elicit, gather, and analyze requirements on the Sitecore platform.

Confidential

Technical Business Analyst

Relevant Skills and Technologies: Application requirement elicitation, gathering, organizing, and refinement. Windows 10

Responsibilities:

• Confidential performed analysis on application inventory for an enterprise wide application migration from Windows 7 to the Windows 10 platform.
• He performed extensive research on application vendors as a part of the application rationalization effort.
• Also, he met with key application stakeholders and SMEs to gather critical application information and migration strategy requirements.

Confidential

Confidential Business Analyst

Relevant Skills and Technologies: Middleware solution requirement elicitation, gathering, organizing, and refinement.

Responsibilities:

• Confidential built many client relationships and worked closely with different stakeholders across the business to elicit and gather thorough requirements.
• Confidential was responsible for representing his team during the daily SCRUM. He worked closely with the Confidential developers to articulate and clarify technical requirements.
• Confidential was tasked with delivering Interface Functional Specifications and gaining approval from all key stakeholders before final PMO approval.
• Confidential was also responsible for eliciting and gathering data mapping and data transformation requirements from the source application SMEs and ETRM teams and synthesizing this information.

Confidential

BI Developer

Relevant Skills and Technologies: SQL Server 2012, SQL Server Analysis Services 2012, SQL Server Integration Services 2012, T-SQL, SharePoint 2013, Datazen, Excel 2013

Responsibilities:

• Confidential was primarily responsible for delivering different reporting solutions using different tools including SharePoint Excel Services, PowerView, Excel, and Datazen.
• Confidential worked on two different SCRUM teams during the project. He developed several SSAS tabular models to support these reporting solutions and complex T-SQL source queries.
• Confidential was tasked with developing a creative SharePoint dashboard comprising of KPIs and charts with interactive drilldown functionality.
• The dashboard was hosted in Excel Services on SharePoint 2013 and linked to Power View reports.

Confidential

ETL and SQL Developer

Relevant Skills and Technologies: SSIS, T-SQL

Responsibilities:

• Confidential worked as an ETL Developer primarily responsible for developing ETL packages with SQL Server Integration Services 2012.
• Confidential assisted in requirement gathering and implementing the logic for the SSIS packages.
• He was tasked with developing as well as thoroughly testing the ETL packages. Working closely with the ETL solution architect, Confidential assisted in designing and implementing a reusable ETL framework and package logic.
• Additionally, he designed and developed a set of packages which facilitated in the end to end package testing that the team could leverage for more efficient ETL testing.

Confidential

Technical Business Analyst

Relevant Skills and Technologies: Solution requirement elicitation, gathering, organizing, and refinement.

Responsibilities:

• Confidential worked with a large Multinational Food and Beverage Company as a technical business analyst alongside the lead Application Architect.
• The Confidential led team worked across all geographies and divisions on a global implementation of Confidential, an Confidential owned integrated sales platform.
• Confidential assisted in eliciting and gathering requirements for both testing, support, and support transition of the Confidential solution.
• He served as a technical writer writing technical documentation and providing technical architecture diagrams.

Confidential

Data and Business Analyst

Relevant Skills and Technologies: SQL Server 2012, T-SQL, Excel 2013

Responsibilities:

• Confidential played a critical role as part of a data migration team responsible for data migration activities from a Siebel legacy system to the SaaS based solution Medidata.
• He elicited and gathered complex business requirements for data migration identifying specific data to be migrated as well as any necessary transformations.
• Confidential developed T-SQL queries to perform in-depth data analysis and report his findings.