Uploaded File
no photo
Osei
SQL/SSRS/SSIS/Developer
Florida City, FL
Available immediately
Actively seeking
no photo
Osei
14
views
SQL/SSRS/SSIS/Developer
0
Recommendations
Average rating
14
Profile views
Business Intelligence Data Validation OLTP Stored Procedure Data Marts Visual Studio Data Replication Data Warehousing Data Conversion SQL
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
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
Business Intelligence
2018
Data Validation
2018
OLTP
2018
Stored Procedure
2018
Data Marts
2018
Education and Certifications
Preferences
Availability:Immediately
Willing to relocate?:No
Prepared to Travel:100%
Employment Type:Any
Security Clearance:No clearance
Citizenship:Green Card