Data Analyst Developer/ETL Developer

VALENTINE OBIORA P: 469-***-**** Create New Email ID

DATABASE / SQL

Specializes in: DATABASE DEVELOPER/DATA ANALYST

SQL T-SQL Power BI SSAS SSRS SQL Server 2012/2014 Teradata Hive SSRS 2008/2008R2 SSIS(ETL) Microsoft Visual Studio MS Project Microsoft Office Suit Erwin Power Bi Microsoft office 360

Summary

I have experience in Microsoft platform using different tools such as SQL, Hadoop, Teradata, Hive,SSIS (ETL), SSRS, . I am a highly motivated Information Technology professional with vast experience in the following areas.

●Data quality and Data Management.

●ETL (Extract, Transform, and Load) solution using SQL Server Integration

●Services (SSIS).

●Develop and design analytical Database and Data Modeling skills.

●knowledge in database maintenance, SQL query optimization & performance tuning using performance tools like SQL Profiler, Index Tuning Wizard, and Database Engine Tuning

●Build different T-SQL queries, Stored Procedures and used them in customized SSIS packages.

●Build reports to retrieve data using Stored Procedures that accept multiple parameters Advisor.

●utilizing the SDLC and an expert in building effective, productive, working relationships with demonstrated ability to incorporate technology routinely into instructional responsibilities either in-person or remotely.

●I am energetic, a self-starter with an excellent analytical perspective focused on providing solutions to address business problems. I demonstrate leadership abilities and I work well in a team to accomplish tasks/projects according to requirement on a timely basis.

Area of Strength

●Languages:

Power BI, SQL, T-SQL,, SSAS, SSRS, SSIS,

●Databases:

SQL Server 2012/2014

●Application Tools

●BIG DATA

Power BI, Management Studio, TeraData, SSRS 2008/2008R2, SSIS(ETL), Microsoft Visual Studio, MS Project, Microsoft Office Suit, Erwin,, Microsoft office 360HADOOP, Apache Spark & Scala, MongoDB,

●Operating Systems

Windows7, XP/2000, UNIX

Education:

Bachelor of Science in Computer Science, University of Lagos.

Work Experience

SQL Database Developer/Data Analyst Dec 2018 – Present

AT&T

●Create reports based on specifications with charts and figures. Created report templates.

●Creates dashboards using powerBi

●Audits data reports using Data Lake -Data Management DL-DM

●Follow up with data quality alert and analyses the root cause of anomaly

●Creates trouble tickets for anomalies and follow up

●Updating schema for the team library in Wiki

●Collects and documents metadata for all the schema for the library

●Creates daily tasks for analysts using Jira

●Gets OSLA approved for the assigned schema

●Design and implement reporting solution architecture

●Wrote SQL queries for data manipulation to meet data specifications for reports.

●Develops stored procedures, queries, views and Parameters necessary to support SSRS reports

●Deployed complex reports in SSRS server and converted reports from Microsoft MS to SSRS.

●Analyzing and profiling data returned for data integrity and business decisions

●Responsible for migrating legacy reports to a new platform by rebuilding them to meet current business requirements.

●Building new reports for the company’s business unit using Power BI and trained staff on the proper use of Power BI

●Splitting and joining old report and updating complex report queries

●Conduct scrum meetings for ongoing projects

●Utilize SSIS in ETL data extraction, transformation, and loading.

Data Analyst/ SQL Database Developer April 2016 – to Nov 2018 AXXESS Solutions,

●Create reports based on specifications with charts and figures. Created report templates with PowerBI.

●Creates Dashboards using PowerBI

●Design and implement reporting solution architecture

●Wrote SQL queries for data manipulation to meet data specifications for reports.

●Develops stored procedures, queries, views and Parameters necessary to support SSRS reports

●Deployed complex reports in SSRS server and converted reports from Microsoft MS to SSRS.

●Analyzing and profiling data returned for data integrity and business decisions

●Responsible for migrating legacy reports to a new platform by rebuilding them to meet current business requirements.

●Building new reports for the company’s business unit using Power BI and trained staff on the proper use of Power BI

●Splitting and joining old report and updating complex report queries

●Conduct scrum meetings for ongoing projects

●Utilize SSIS in ETL data extraction, transformation, and loading.

●Developed a backup and recovery plan based on the data availability requirements of the library and on the potential impact of data loss on the business after considering and analyzing the different backup and recovery strategies.

Data Analyst/ SQL Database Developer Feb 2014 – March 2016 Hillview Group Inc, Dallas TX

●Developed cost effective software solutions for database creation, migration, replication, and recovery for clients at Hillview Inc. using Microsoft SQL platform

●Analyzed the business requirements and systematically designed a database for clients, employed best practices in creating a complete solution to meet customers requirement.

●Employing system development life cycle from the conceptual to physical phase of customers requirement.

●Creating schemas for tables, stored procedures, views, clustered and non-clustered indexes, and triggers.

●Created numerous simple to complex queries involving self joins, correlated subqueries. Tuned and optimized queries by altering database design, analyzing different query options, and indexing strategies

●Used the SQL Server Profiler tool to monitor the performance of SQL Server – particularly to analyze the performance of the stored procedures.

●Utilizing SSIS in ETL data extraction, transformation, and loading.

●Developed a backup and recovery plan based on the data availability requirements of the library and on the potential impact of data loss on the business after considering and analyzing the different backup and recovery strategies.

●Created and designed SSRS reports based on specifications with charts and figures. Created report templates.

●Design and implement reporting solution architecture

●Wrote SQL queries for data manipulation to meet data specifications for reports.

●Developed stored procedures, queries, views, and Parameters necessary to support SSRS reports

●Deploy complex reports in SSRS server and converted reports from Microsoft MS to SSRS.

●Responsible for prompt resolution to issues during UAT and QA phase. Completed report enhancements and bug solution when issues were forwarded by testers before Go-live

●Employing Service Brokers enabling HTTP support and establishing Notification Services

Data Analyst/ SQL Database Developer May 2013- Jan 2014 JSNN, Dallas Tx

●Worked as a database developer in the computational Research lab, where research data were analyzed for further implementation in GROMACS environment

●Designed database, tables, and views structure for the application.

●Developed complex T-SQL code such as Stored Procedures, functions, triggers, Indexes and for the application.

●Utilize DDL, DML, DCL, TCL in data manipulation

●Responsible for optimizing SQL queries, stored procedures to improve the performance time.

●Extract data from a data source, transform and load, using SSIS (ETL).

●Responsible for maintaining data referential integrity and backup within the centralized database.

●Used the SQL Server Profiler tool to monitor the performance of SQL Server – particularly to analyze the performance of the stored procedures.

●Developed reports on the report server for onward implementation

●Provided reports with role-based access control in SSRS. Reports had ability to be exported in Excel, PDF, and CSV. Provided Hyperlinks on reports.

Contact this candidate