Uploaded File
no photo
Osei
SQL/SSRS/SSIS/Developer
Florida City, FL
Available immediately
Actively seeking
no photo
Osei
34
views
SQL/SSRS/SSIS/Developer
0
Recommendations
Average rating
34
Profile views
OLTP Data Marts Data Replication SSRS SSIS SQL SQL Server Stored Procedure Triggers Data Warehousing
Remove Note
View Note
Recent Experience
SQL/SSRS/SSIS/Developer 04/16 - present
SQL Visual Studio Data Marts Stored Procedure SQL Server ETL SSIS SSRS T-SQL Business Intelligence Data Conversion Data Validation Data Warehousing OLTP
SQL/SSRS/SSIS/Developer 11/15 - 04/16
SQL SQL Server SSIS SSRS Data Conversion Data Replication Asset Management
SQL Server Developer/Report Writer 01/15 - 10/15
SQL Server SQL
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.

Top 5 Skills
SkillsProficiencyLast Used
OLTP
2019
Data Marts
2019
Data Replication
2016
SSRS
2019
SSIS
2019
Education and Certifications
Preferences
Availability:Immediately
Willing to relocate?:No
Prepared to Travel:100%
Employment Type:Any
Security Clearance:No clearance
Citizenship:Green Card