Sign In
Looking for talent?
Check out our hiring section
Login to your account
Remember me?
Login
Forgot password?
Not a user yet?
Click here to register.
LOADING
Select Login
Uploaded File
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
Edit Skills
Non-cloudteam Skill
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