Uploaded File
add photo
Osei
oseitutu.afranie@gmail.com
510-213-0587
6831 PERSHING ST
Florida City, FL 33034
SQL/SSRS/SSIS/Developer
15 years experience W2
0
Recommendations
Average rating
138
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
SQL/SSRS/SSIS/Developer
Information Technology
Apr 2016 - present
  • Create new SSIS package to extract date from legacy to SQL Server Objects using Business Intelligence Development Studio Data Tool and Visual studio 2012.
  • Defined Check constraints, Business Rules, Indexes, and Views.
  • Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
  • Responsible for creating the reports basing on the requirements using SSIS in visual studio 2012.
  • Developed SSIS Templates which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Dev, Test and Production Environments.
  • Involved in extracting the data using SSIS from OLTP to OLAP.
  • Executing data validation stored procedures in SSIS packages in Business Intelligence Development Studio (BIDS).
  • Involved in Deployment and Administration on SSIS packages with Business Intelligence development studio.
  • Developed, monitored and deployed SSIS packages.
  • Performance tuning of Stored Procedures and T-SQL Queries.
  • Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
  • Used Execution Plan, SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
  • Performed data conversion from flat file into a normalized database structure.
  • Involved in System Study analysis for logical/physical data model there by defining strategy for implementing Star Schema with Fact and Dimension tables.
SQL Visual Studio Data Marts Stored Procedure SQL Server ETL SSIS SSRS T-SQL Business Intelligence Data Conversion Data Validation Data Warehousing OLTP Performance Tuning
Remove Skill
SQL/SSRS/SSIS/Developer
Information Technology
Nov 2015 - Apr 2016

Waddell & Reed is among the most enduring asset management and financial planning firms in the nation, providing proven investment and planning services to individuals and institutional investors.

  • Involved in analyzing and designing disaster recovery / replication strategies with business managers to meet the business requirements.
  • Generated Cross-Tab, Drill-down, Drill-through and Sub-Report using RDL. Promoted RDLs to Reporting Service Server. Wrote the queries for the drill down reports.
  • Identified and defined the Datasets for the report generation.
  • Developed Report Models using report builder and distributed reports in multiple formats using SQL Server 2012 Reporting Services (SSRS) in Data tools (Visual Studio).
  • Formatted the reports using the Global variables and expressions.
  • Successfully extracted transformed and load data into data warehouse.
  • Designed, deployed, and maintained of various SSRS Reports in SQL Server 2012.
  • Created SSIS packages to migrate data from different data sources to data warehouse.
  • Successfully extracted transformed and load data into data warehouse.
  • Created packages by testing and cleaning the Standardized Data by using tools in Data Flow Transformations (Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split and more) for existing/new packages and huge CSV file import from different data sources and other ongoing tasks for mapping.
  • Used Sharepoint to get all documents required for project and implementation steps.
  • Presentation of application to Users and management.
  • Involved in the installations and implementation of Application Projects.
SQL SQL Server SSIS SSRS Data Conversion Data Replication Asset Management Project Management Data Warehousing Disaster Recovery Database Design MS SharePoint
Remove Skill
SQL Server Developer/Report Writer
Information Technology
Jan 2015 - Oct 2015
SQL Server SQL
Remove Skill
SQL/SSIS/SSAS/SSRS Developer
Information Technology
May 2013 - Dec 2014

BNY Mellon is a global investments company dedicated to helping clients manage and service their financial assets throughout the investment lifecycle weather clients create hold, manage, distribute or restructure their investment .As a part of development team, my role was to populate data warehouse using SQL Server Integration Service (SSIS), to design, create analyze and test cubes using SQL Server Integration Service (SSAS) and to create reports according to the business requirement using SQL Server Reporting Service (SSRS).

  • Created SSIS packages to migrate data from different data sources to data warehouse.
  • Successfully extracted transformed and load data into data warehouse.
  • Created packages by testing and cleaning the Standardized Data by using tools in Data Flow Transformations (Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split and more) for existing/new packages and huge CSV file import from different data sources and other ongoing tasks for mapping.
  • Extensively designed the packages and data mapping using Control flow task, Sequence container task, Dataflow Task, Execute SQL Task, Data conversion task, Derived Column task and Script Task in SSIS Designer.
  • Scheduled SSIS packages for running monthly and weekly feeds from various guarantors and multiple servers and resources.
  • Involved in enhancing and deploying the SSIS Packages from development server to production server.
  • Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2012 and in adding calculations using MDX
  • Involved in Designing and deploying cubes in SSAS environment using Snowflake and Star Schema Designs for the operational data.
  • Designed, deployed, and maintained of various SSRS Reports in SQL Server 2012.
  • Wrote Parameterized Queries for generating Tabular reports and Sub reports using Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS 2012.
  • Defined report layouts including report parameters and wrote queries for drill down reports using SSRS 2012.
  • Developed complex reports using multiple data providers, user defined objects, aggregate aware objects, charts, and synchronized queries.
  • Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2012.
  • Responsible for the Performance tuning of the SQL Commands with the use of the SQL Profiler and Database Engine Tuning Wizard
  • Installed and Configured SQL Server Active/Active and Active/Passive clusters. Monitored Scheduled jobs and alerts.

Environment: SQLServer2012, SQLServerBIDevelopment Studio (BIDS) 2012, SSIS, SSRS, SSAS, Oracle 9i/10g, ClearCase, Clear quest, SQL LiteSpeed, Visual SourceSafe, T-SQL, ETL, Autosys, MS Access, Windows XP/2007 Server.

SQL Business Requirements SQL Server Oracle ClearCase ETL SSIS SSRS SSAS T-SQL Data Conversion Data Mapping Data Warehousing ClearQuest Database Design Performance Tuning Windows
Remove Skill
SQL/SSIS/SSAS/SSRS Developer
Information Technology
Jun 2011 - Apr 2013
The World Bank is an international financial institution that provides loans to developing countries for capital programs. The main goal of the World Bank is the reduction of proverty, promotion of foreign investment, international trade and facilitation of capital investment. This project was done by building an online transaction processing system (OLTP) based on MS SQL Server 2008R2 and it's Reporting Services which would provide space for growth and standardizing its forms and templates.
• Installed SQL Server 2008R2 with the latest service packs.
• Migrated Database from SQL Server 2008 to 2008R2 by using side by side migration.
• Created tables, indexes and designing constraints.
• Wrote several SQL Scripts such as finding long running queries, blocking sessions, archiving data from production to archive server and populating reporting data.
• Used various SSIS tasks such as Conditional Split, Derived Column etc, which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Worked with ETL to implement the slowly changing transformation, to maintain Historical Data in Data warehouse.
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Enhanced and deploying the SSIS Packages from development server to production server.
• Wrote stored procedures for report generation in SQL Server2008R2.
• Created Alerts for successful or unsuccessful completion of Scheduled Jobs.
• Developed and designed cubes with calculated members, Design Dimensions and using the MDX expressions for the various calculated members, actions and KPI.
• Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large sets of data and used Multi-Dimensional Expression (MDX) to access them.
• Involved in Designing and deploying cubes in SSAS environment using Snowflake and Star Schema Designs for the operational data
• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.
• Administrated the created Reports by assigning permission to the valid user for executing the reports.
• Rendered reports, managed subscriptions, created reports with report builder, report snapshot and report Cache.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2008R2.
• Created and Maintained Database Maintenance Plans.
• Strong team player and self-motivated Environment: SQL server 2008R2, Windows XP/2007, SSIS, SSRS, SSAS, T-SQL, ETL, BIDS 2008R2, Windows 2000 Advanced Server, Microsoft Share point Portal Server, Lumigent Log Explorer, VSS, SQL Diagnostic Manager, SQL LiteSpeed, Dell Power Edge 2650, 1750, and 2600.
SQL SQL Server SSAS SSIS SSRS Stored Procedure T-SQL Triggers ETL Project Management Data Warehousing Data Validation Database Design MS SharePoint Windows
Remove Skill
SQL/SSIS/SSAS/SSRS ETL Developer
Information Technology
Jul 2010 - May 2011
UBS is a global financial services company which provides investment banking, asset management, and wealth management services for private, corporate and institutional clients worldwide. The project was to create ETL processes (SSIS) to populate summary data structures and analysis cubes and development and performance tuning of stored procedure queries to investigate data issues and to create new reports structures for business units.
• Responsible for creating logical and physical model using ERWIN.
• Built a package to transfer data between OLTP and DW databases.
• Created Views to reduce database complexities for the end users.
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2008R2.
• Developed SSIS Packages using Derived Columns, Condition Split, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Created a table to save dirty records.
• Performed SSIS tasks such as Conditional Split, Derived Column etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Used ETL to implement the slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Set up Alerts for successful or unsuccessful completion of Scheduled Jobs.
• Extensively involved in the SSAS storage and partitions and Aggregations, Calculation of queries with MDX, Data Mining Models, developing reports using MDX and T-SQL.
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 200R2 and in adding calculations using MDX.
• Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Generated Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS. Environment: SQL Server 2008R2, BIDS 2008R2, Integration Services 2008R2, Oracle 9i, Visual SourceSafe, TSQL, ETL, Autosys, Rational Clear Case, Clear quest, MS Access, Windows XP/2003 Server.
Business Intelligence Data Mining Data Validation ETL ETL Developer Oracle SQL SQL Server SSAS SSIS SSRS Stored Procedure T-SQL Triggers Asset Management Data Warehousing Erwin Data Modler ClearQuest Database Design OLTP Performance Tuning ClearCase Microsoft Excel Windows
Remove Skill
Reporter and Developer
Information Technology
Nov 2008 - Jun 2010
Guardian life ins.corp SQL Server, protects families and small businesses through innovative technology, products, and services. As a part of the team, the goal of the project was development of Billing and Customer Relationship Management system (CRMS) as well as online multi-carrier enrollment through the Enrollment program for the company. The project also involved Creating SSIS packages for transferring the data from different systems and also creating the reports using SSRS 2008.
• Worked as a developer in creating complex Stored Procedures, Triggers and Functions.
• Managed index statistics, Tables, Views, cursors and optimizing queries by using execution plan for tuning the database. Implemented different types of constraints on tables.
• Implemented Performance tuning to optimize SQL queries using query analyzer.
• Tested to optimize the procedures and triggers to be used in production.
• Involved in project planning, scheduling for database module with project managers.
• Created the reports based on the requirements using SSRS 2008.
• Used VB.NET to create user define functions in SSRS.
• Generated Cross-Tab, Drill-down, Drill-through and Sub-Report using RDL. Promoted RDLs to Reporting Service Server. Wrote the queries for the drill down reports.
• Formatted the reports using the Global variables and expressions.
• Created detailed reports for the customers to help them decide which property to purchase by showing demographic information based on various parameters.
• Authored performance based reports for the managers to show sales against various measures like Time, Area, and Price-Range.
• Identified and defined the Datasets for the report generation.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Developed, monitored and deployed SSIS packages.
• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation.
• Developed stored procedures to transform the data from enterprise data warehouse to data mart to build dimensions and load data to fact tables.
• Responsible for automation of maintenance jobs, locks and indexes configurations.
• Administered SQL Server security, SQL Server automatic e-mail notification.
• Managed SQL user logins, database user accounts, server roles, database roles and its permissions. Handled dead lock scenarios.
• Involved in analyzing and designing disaster recovery / replication strategies with business managers to meet the business requirements.
• Configured replication servers and transactional replication between production and standby server for disaster recovery. Examine two-way database replication using SQL server. Environment: MS SQL Server 2008, DTS, Windows 2003, SQL Server Management Studio, SQL Server Business Intelligence Development Studio (BIDS), SQL Server Query Analyzer, ETL, Erwin, MS Visual Source Safe FTP Communication, MS-Visual Studio, VB.NET, MS Access, Oracle 10g, UNIX, XML, XSLT, ADO.Net.
ADO.NET Oracle SQL SQL Server SSIS SSRS Stored Procedure Triggers UNIX XML XSLT Project Management ETL Business Intelligence Data Warehousing Erwin Data Modler Disaster Recovery Data Marts Windows
Remove Skill
SQL Server BI Developer
Information Technology
Mar 2007 - Oct 2008
McKesson is the largest healthcare services company which provides pharmaceuticals, medical supplies, and information technologies to customers in every segment of the industry. They work with Medicaid and Medicare, among other government programs. This is the complete solution for Mckesson which includes modules like patient registration system, doctor scheduling, lab track system, discharge system billing system and deposit system. It has a dynamic facility for adding the registration type for each patient. An advanced search facility has helped clients, patients and doctors to search their desired records easily.
• Used SSIS Packages to transfer data from different sources to SQL Server using BIDS.
• Used in designing, developing and deploying reports in MS SQL Server environment using SSRS, SSIS in BIDS.
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Used the complete data mapping for all the migrated jobs using SSIS.
• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written function, stored procedures and triggers.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and send mail task etc.
• Created many complex Stored Procedures and Triggers.
• Created packages in DTS and SSIS, for data conversion using various transformations tasks
• Built and unit tested reports using SSRS (SQL Server Reporting Services)
• Created reports that call Sub reports in SSRS.
• Developed reporting module using .NET application with set of RDL based reports using SSRS and Complex Stored Procedures.
• Maintained already present reports in Crystal Reports 2008.
• Worked with drill down, cross tab reports as well as chart control reports.
• Successfully understood and implemented the reporting requirements with less amount of supervision.
• Followed up and worked in tandem with the report requestors to sign off the reports within a stipulated amount of time.
• Worked with XML parameters while passing multi value parameters from the report to the stored procedures.
• Involved in writing SQL Scripts using T SQL to create the datasets for the reports.
• Also created stored procedures based datasets (Datasets that get data using stored procedures).
• Used Joins and sub queries concept for extracting data from multiple tables.
• Involved in writing stored procedures that are used for building consolidated datasets for better reporting needs.
• Extensively used SSIS (SQL Server Integration Services) to load data from different data sources and flat files including but not limited to text excel and comma separated files etc.
• Performing query plans and making sure each and every query is running at its maximum potential and speed. Environment: SQL Server 2005/2008 Enterprise Edition, SSIS, SSRS, T SQL, ETL, .NET Framework, C#, ASP.NET, ADO.NET, Erwin, XML, T SQL, Visual Studio, VB.NET, IDE, Windows 2000/2003 Advance Server/XP, MS Excel, MS Access, MS Visual Studio 2005/2008
.NET ASP.NET BI Developer C# Crystal Reports ETL SQL SQL Server SSIS SSRS Stored Procedure Triggers Visual Studio ADO.NET XML Data Warehousing Data Mapping Data Conversion Erwin Data Modler Database Design Microsoft Excel Windows
Remove Skill
SQL Server/BI Developer (SSIS)
Information Technology
Sep 2006 - Feb 2007
First data is a provider of electronic commerce and payment solutions. The company's portfolio includes merchant transaction processing services such as credit, debit, payroll and other prepaid card offerings. The project involves forecasting and budgeting, Claim Processes, Accounts Receipts, Payments, General Ledger, Journal Voucher, Petty Cash Voucher. The main objective was to enhance the services capabilities to the customers.
• Gathered functional requirements and written the technical specifications
• Designed logical / physical data models and defined primary key, foreign key using Erwin tool.
• Wrote T-SQL statements using DML and DDL for retrieval of the data.
• Created complex stored procedures, triggers and cursors in SQL Server.
• Developed source to target specifications.
• Generated stored procedures, functions, views and triggers.
• Developed stored procedures to transform the data from enterprise data warehouse to APT data mart to build dimensions and load data to fact tables.
• Created DTS package to schedule the jobs for batch processing.
• Performance tuning to optimize SQL queries using query analyzer.
• Created indexes, constraints and rules on database objects. Environment: MS SQL Server 2005, MS Access, DTS, Erwin 4.1, SQL Query Analyze, VB.NET, Crystal Report
SQL SQL Server Stored Procedure T-SQL Triggers Crystal Reports Data Warehousing Erwin Data Modler Database Design Performance Tuning Data Marts BI Developer
Remove Skill
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