add photo
Osei
oseitutu.afranie@gmail.com
510-213-0587
6831 PERSHING ST
Florida City, FL 33034
SQL/SSRS/SSIS/Developer
17 years experience W2
0
Recommendations
Average rating
261
Profile views
Summary

  • 10 years of experience as MS SQL Developer in administration and development of database design and development in SQL Server 2012/2008R2/2008/2005/2000 system in OLTP and OLAP environment.
  • Excellent experience in SSIS, SSAS and SSRS of MS SQL Server.
  • Highly expert in translating Business System Design document into technical design document
  • Experience in installation, upgrade and configuration of Microsoft SQL Server and databases
  • In-depth knowledge of T-SQL, Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using T-SQL.
  • Proficient in writing complex T-SQL queries using Inner, Left, Right, Outer and Cross Joins.
  • Hands on Experience in Installing, Configuring, Managing, monitoring and troubleshooting SQL Server 2012/2008R2/ 2008/2005/2000.
  • Experience in scheduling SSIS packages using SQL Server Agent.
  • Strong knowledge of using variables and expressions in packages.
  • Experience in enhancing and deploying the SSIS Packages from development server to production server.
  • Excellent skills in implementing ETL Packages using DTS and SSIS 2012/2008R2/2008/ 2005.
  • Proficient in implementing all transformations available on the SSIS toolbox.
  • Expert in resolving the performance issue of SSIS packages.
  • Experience in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SQL tools (SSIS, DTS, Bulk Insert, and XML).
  • Well versed in Importing/Exporting Data from various data sources like Excel, Oracle, DB2 and Flat file using BCP, Bulk Insert & DTS utility.
  • Extensive Knowledge in SSAS storage, partitions and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
  • Good Knowledge in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2008 and in adding calculations using MDX.
  • Expert in Designing and deploying cubes in SSAS environment using Snowflake and Star Schema Designs for the operational data
  • Proficient in Creating business critical KPIs using SQL Server Analysis Services SSAS representing aggregations in several different ways - hierarchically and using custom groupings that the company will use to analyze performance.
  • Strong experiences to Design, deploy, and maintain various SSRS Reports in SQL Server 2012.
  • Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2012.
  • Extensive experience in report writing using SQL Server Reporting Services like Tabular report, Matrix report, Chart report, Pie Charts and column report.
  • Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
  • Effective communication and interpersonal skills with the ability to focus on multiple tasks in a high pressure environment.

Experience
Education
Skills
Data Replication
2016
1
Data Warehousing
2021
10
SQL
2021
10
SQL Server
2021
10
ETL
2021
8
SSIS
2021
8
SSRS
2021
8
Database Design
2016
7
Stored Procedure
2021
7
Triggers
2013
7
Windows
2014
7
Performance Tuning
2021
6
T-SQL
2021
6
Erwin Data Modler
2011
5
Project Management
2016
5
Oracle
2014
4
SSAS
2014
4
ADO.NET
2010
3
Business Intelligence
2021
3
Data Conversion
2021
3
Data Marts
2021
3
Data Validation
2021
3
Disaster Recovery
2016
3
MS SharePoint
2016
3
XML
2010
3
Asset Management
2016
2
BI Developer
2008
2
ClearCase
2014
2
ClearQuest
2014
2
Crystal Reports
2008
2
Data Mapping
2014
2
Microsoft Excel
2011
2
UNIX
2010
2
XSLT
2010
2
.NET
2008
1
ASP.NET
2008
1
Business Requirements
2014
1
C#
2008
1
Data Mining
2011
1
ETL Developer
2011
1
OLTP
2021
1
Visual Studio
2021
1
BSA
0
1
DB2
0
1
SQL Developer
0
1
System Design
0
1