Resume

Sign in

Sql Server Data

Location:
Alpharetta, Georgia, United States
Posted:
October 17, 2018

Contact this candidate

Resume:

Hope Ugboke

ac7eu2@r.postjobfree.com

+*-******-****

Professional Summary

Certified Microsoft BI developer with over 6+ years of extensive experience in database design, development and administration with MS SQL Server versions 2016/2012/2008 R2/2008/2005 using SSIS SSRS at Healthcare, Mortgage and Retail companies.

Business Intelligence experience in Development, Client Analysis, Database Design, Reporting and Presentation using SQL Server 2008R2/2012/2014, SSIS, SSAS and SSRS.

Expertise in Power BI and Tabulae development.

Excellent backend skills in creating SQL objects such as Tables, Complex Stored Procedures, Effective Functions, Views, Indexes, Triggers, Rules and SQL Performance Tuning to facilitate efficient data manipulation and consistency.

Strong experience in client interaction and understanding business applications, Optimization and Tuning.

In-depth technical knowledge with sharp analytical skills to analyze complex business problems and develop, deploy Information Technology solutions that enhance efficiency and productivity.

Technical experience with design and hands-on programming on diverse technology platforms including RDBMS, Cube design & development, ETL engines, BI Scorecards and dashboards.

Experience in Project Management and Software Development lifecycle including analysis of business function, software design, specifications and software development, testing and documentation, and planning for redesign or transition to another platform.

Expert in Data Extraction, Transformation and Loading (ETL) using SQL Server Integration Services (SSIS), DTS, Bulk Insert, BCP and Error Handling in SSIS

Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduled DTS and SSIS Packages.

Developed Multi-dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).

Good understanding of SQL Server Reporting Services (SSRS) with Report authoring, Report management, Report delivery and Report security.

Experienced in Database Installation, Configuration, Maintenance, Monitoring, Backup and Disaster Recovery procedure and Replication.

Strong troubleshooting and problem solving skills. Strong ability to prioritize multiple tasks. Excellent communication skills, proactive, self-managing and teamwork spirits.

Well-organized, goal-oriented, highly motivated effective team member with excellent analytical, troubleshooting, and problem solving skills.

technical skills

Platforms

Windows (2000, XP, Vista,7,8), MS SQL Server 2016/ 2012/2008 R2/2008, MS Access.

Languages

T-SQL, XML, Visual Basic.

Applications / BI Tools

Microsoft Data Transformation Services (DTS), SQL Server Integration (SSIS), SQL Server Reporting (SSRS), SQL Server Analysis (SSAS), SQL Server Business Intelligence Development Studio (BIDS), MS Access, SQL SERVER, MS Visio, SQL Profiler, Query Optimizer, DTS Designer, SQL Server Agent, MS Excel.

Work Flow Tools

MS Visio Visual Source Safe (VSS), Team Foundation Server 2010 (TFS).

Miscellaneous

Visible Analysis and Troubleshooting.

Communication Skills

Education and training

Microsoft Certified Technology Specialist (MCTS): SQL Server 2008 Business Intelligence

Implementation and Maintenance.

Professional Experience

ROCKET MORTGAGE

07/15 – 09/18

SQL Server SSIS/SSRS Developer

Designed and created an ETL solution for the Housing applications received. Numerous reports were also created in order to meet the client’s need.

Key Responsibilities:

Gathered requirements from the user community, write Functional Design Specifications and design documents for development..

Designed, Implemented and maintained Database Schema, Entity relationship diagrams, Data modeling, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Schemas, Functions, Views, Rules, Defaults and complex SQL statement.

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

Used advanced SSIS tools (i.e. Derived Columns, Condition Split, Data Conversion, 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.

Designed enterprise reports using SQL server reporting services (SSRS) and excel pivot tables based on OLAP cubes which make use of multiple value section in parameters pick list, cascading and dynamics reports.

Enhanced performance using optimization techniques-normalization and indexing.

Co-ordinated with application team and developed all ETL Informatica.

Performance tuning of Queries and Stored Procedures as well as ETL packages.

Created and developed Dashboards, Tabular, Matrix reports (crosstab or pivot), Charts, Graphs, Drill Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS.

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

Environment: SQL Server 2008 R2, SQL Server 2012 and latest, MS Excel, Visual Basic, BIDS.

ALLIANCE OF DREAMS

05/13 – 06/15

SQL Server SSIS/SSRS/SSAS Developer

Designed and created several Integration packages and business-related data marts. Processed departmental data requests and created applications to provide patients data reports.

Key Responsibilities:

Database development utilizing Microsoft SQL Server OLTP/OLAP environments using integration services (SSIS) for ETL (Extraction, Transformation, and Loading). Database Administration including, backups, recovery, database maintenance.

Handled development for reporting team involving coding, security, code reviews, metadata implementation, and replication troubleshooting

Performed the extraction, presentation and analysis of health care information to develop new solution that support business needs .

Good knowledge of Data Marts, operational data store (ODS), OLAP, Star schema modelling, Snow flake modeling for fact and Dimension tables.

Created code based solution for application error involving composite key manipulation

Coded optimization objects including hierarchical flattening functions, strategic indexes, and staging tables as well as data and file partitioning.

Created Tabular, Matrix reports (crosstab or pivot), Charts and graphs as per customer requirements Using SSRS.

Worked with Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.

Worked on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS and DTS.

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

Designed SSIS Templates for developing SSIS Packages in such a way that they can be dynamically deployed into Development, Testing and Production Environments.

Configured packages with checkpoints, package logging, error logging and event handling to redirect error rows and fix the errors in SSIS.

Defined data sources, data source views, dimensions, measures, hierarchies, attributes, calculations, KPI’s, perspectives and roles.

Build the SSIS packages to load the Data into Staging, ODS and dimensional model.

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

Created XML schemas to update user tables and system objects for company data dictionary

Generated reports in various formats like Table format and Matrix format using Reporting services (SSRS) to display in a customized format as per business requirements

Served as a team member in Project Management and Software Development Life Cycle (SDLC) including analysis of business function, testing and documentation, and planning for redesign or transition to another platform.

Applied security to reports on item and folder level.

Environment: SQL Server 2008 R2/2012, Visual studio 2008/2012, Microsoft Access, BIDS.

JULIUS BERGER PLC

06/12 – 04/13

SQL Server SSIS/SSRS/SSAS Developer

Designed and created several Integration packages and business-related data marts. Processed departmental data requests and created applications to provide customer data reports. Identified opportunities for business automation and drove process improvements

Key Responsibilities:

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

Designed and developed data warehouse, data marts and business intelligence using multi-dimensional models - star schema.

Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases from various sources like Text Files, XML Files, Excel and Access.

Created packages in SSIS with error handling as well as created complex SSIS packages using various transformations and tasks like Sequence Containers, Script, For loop and For Each Loop Container, Execute SQL, Execute Package, Send Mail, File System, Conditional Split, Data Conversion, Derived Column, Look Up, Merge, Merge Join, Row Count, Sort, Union All, flat file source and destination, OLE DB source and destination, excel source and destination etc.

Design, Implement and maintain Database Schema, Entity relationship diagrams, Data modeling, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Schemas, Functions, Views, Rules, Defaults and complex SQL statement.

Created trace in SQL Profiler and used Data base engine tuning advisor for Performance tuning on stored procedures and Scripts.

Designed, developed and deployed SSRS reports that include; parameterized reports, snapshot reports cached reports, drill down reports, drill through reports, linked reports, click-through reports, Sub Reports, Gauges, Pie Chart, Bar Chart

Created and Deployed reports to Report Manager and Troubleshooting for any error occur in execution.

Scheduled the reports to run on daily and weekly basis in report manager and also email them to managers and analysts to review in excel spread-sheet.

Environment: Windows Server 2003, SQL Server 2016/2014/2012/2008/2005/2000, SSIS, SSRS, BIDS, DB2 v9.5, Excel, Notepad++, XML



Contact this candidate