Etl Developer Data Analyst

PROFESSIONAL SUMMARY

Microsoft IT professional with over 5 years of work experience as a MSBI/Power BI Developer and consultant working for corporate clients. Strong experience in using the Microsoft Suite (SQL SERVER management Studio (SSMS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and Power BI.

Proficient in full system development life cycle (SDLC) with agile methodology; experience including requirements gathering, analysis, design, development, and testing.

Proficient in the SSIS/SSAS ETL Lifecycle and development

Experience in logical and physical dimensional modeling, ER modeling, star schema/snowflake schema, fact and dimensional tables and operational data store (ODS).

Proficiency in multi-task prioritization, team communication, risk identification, troubleshooting and complex problem-solving; Proactive, highly motivated, self-reliant, and goal oriented.

EDUCATION / CERTIFICATIONS

Microsoft Power BI Certification

Certificate in SQL & BI Analytics – Colaberry School of Data Analytics (TX, United States)

Bachelor’s in Chemical Engineering – Federal University of Technology (Nigeria)

SUMMARY OF TECHNICAL SKILLS

Platforms

Windows (2000, XP, Vista,7,8), MS SQL Server 2012/2014

Languages

T-SQL, Visual Basic

Applications / BI Tools

Power BI Desktop

Power BI Service

Power Bi Report Server

Power BI Mobile

DAX.

Microsoft Data Transformation Services (DTS)

SQL Server Integration (SSIS)

SQL Server Reporting (SSRS)

SQL Server Business Intelligence Development Studio (BIDS)

SharePoint Online

SharePoint 2016

Miscellaneous

Visible Analysis and Troubleshooting

PROFESSIONAL EXPERIENCE

Heritage Northrop Grumman, Peraton July 2020 - Current

Sr. Power Bi & SQL Developer

Worked on the Data Governance and Analytics (DGA) project to support the Enterprise Data Management (EDM) team under the Department of the Treasury with their PowerBI and reporting efforts to support various executive-level dashboards for various Bureaus within Treasury.

Existing dashboard analysis and issue identification; providing technical solutions to resolve data integrity and functional issues; existing dashboard enhancement and updates following the business requirements identified by the customer.

Identification of performance-related issues, implementation of solution to improve dashboard performance by 32%.

Creation of new dashboards for new executive leadership to include all layers of development – PowerBI, SSIS/SSAS development.

Technical documentation template creation and implementation for all dashboards supported by EDM; Designed and developed a lifecycle and performance improvement documents to match the workflow for DGA workflow process.

Collaborated with EDM customers, EDM team members, and Peraton team members to identity all key business requirements and determine project schedule and cadence.

Collaboration with EDM team members and Peraton team members utilizing the Subversion Control System.

ITT AEROSPACE CONTROLS September 2018 – July 2020

Power BI Developer

Worked with business teams to gain a rich understanding of their business, analytical, and reporting needs, including the identification of critical metrics.

Performed detailed data analysis to determine the structure, content, and quality of the data through examination of source systems and data samples.

Worked closely with a team of technical and non-technical staff and consultants to iterate through versions of the deliverables.

Involved in creation of various Business Intelligence/ Analytical Dashboards utilizing Power BI with global filters, calculated columns and measures using complex DAX calculations and transformations using Query Editor & Power Query Formula Language (M).

Worked extensively building Power BI Dashboards with quick insights into KPIs and Advance analysis actions, Calculations, Parameters, Maps and Scatter plots.

Used Trend Lines Statistics and Log Axes, Groups hierarchies, time intelligence to create detailed and summary level reports and Dashboards with KPIs using Power BI.

Worked on Power BI dashboards using stacked bars, bar graphs, scattered plots, waterfall charts, geographical maps, Gantt charts using show me functionality.

Publishing of various kinds of live interactive data visualization dashboard reports and workbooks from Power BI Desktop to Power BI servers.

Managed a repository of re-usable data visualization templates and views.

Supported the Business Intelligence/Analytics data analyst with the understanding of business and data requirements and iteratively designs visualizations for initial concepts and prototypes that can be presented to customers for feedback.

Conducted Training sessions for Power BI users and created the documents for end user support.

CENTER FOR FAMILY HEALTH & EDUCATION July 2017 – September 2018

SQL / ETL Developer (SSIS)

Conducted a variety of tasks and support in creating reports, requirements, communication, and other key activities.

Analyzed business requirements in collaboration with business end users and developed effective queries for retrieving and analyzing data from a variety of sources.

Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases.

Used advanced SSIS tools (Derived Columns, Conditional Split, Look-up Transformation, Aggregations, Multicasting).

Contributed to the development and modification of coding standards for the team to ensure consistency, efficiency and accuracy in reporting and data analysis.

Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for optimized performance.

Enhanced performance using optimization techniques-normalization and indexing

Wrote and reviewed functional specifications, performed unit and system tests, troubleshoot and implement logged bug fixes.

Designed and Developed Technical specifications for the packages created, for future reference as per the client’s request.

PPG AEROSPACE August 2014 - July 2017

Junior ETL Developer (SQL Server, SSIS, SSRS)

Designed and created an ETL solution to consolidate applications received from various sources.

Worked on all activities related to the development, implementation, administration and support of ETL processes.

Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases.

Performance tuning of Queries and Stored Procedures.

Performance tuning on existing ETL packages.

Designed various SSRS reports as requested by the client.

Rendered reports in different formats like pdf, excel etc. Scheduled to be executed automatically on weekly or monthly basis and managed subscriptions.

Documented all database objects, procedures, views, functions & packages for future references.

Contact this candidate