Data Sql Server
Resume:
KENNETH OMURWA
FORT WORTH, TX
*********@*****.***
PROFESSIONAL SUMMAR
Over 5 years of IT with professional experience in Software Development, Client Analysis, Database Design and Presentation using SQL Server 2016/2014/2012
Strong experience in using the Microsoft Suite (Management Studio, Business Intelligence Development Studio) (SQL) Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS)
Excellent backend skills in creating SQL objects such as Tables, Complex Stored Procedures, Effective Functions, Views, Indexes, Triggers, Rules and SQL Performance Tuning to facilitate efficient data manipulation and consistency.
Proficient in using SQL Profiler, Execution Plan and Performance Monitor. Skilled in performing Backups and Recovery, Replication, Security management and Jobs.
Experience in logical and physical Dimensional Modeling, ER Modeling, Star Schema / Snowflake Schema, Fact and Dimensional tables and Operational Data Store (ODS).
Database development experience with Microsoft SQL Server in OLTP/OLAP environments using integration services (SSIS) for ETL (Extraction, Transformation and Loading).
Experience in transforming unstructured data from various data sources using SSIS Transformations like Conditional Split, Lookup, Merge Join and Sort and Derived Column for cleaning bad data, validating data
Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
Complete understanding of software development life cycle (SDLC) including requirement analysis, requirement gathering, design, development, implementation and testing and deployment experience.
Strong analytical and problem-solving skills, Ability to work to deadlines, Results oriented Flexible, and Adaptable.
Ability to handle multiple tasks and demonstrates initiative and adaptability and capable of handling responsibilities independently as well as a proactive team member.
Quick learner who strives for new technical knowledge.
EDUCATION AND TRAINING
Diploma in Structure, Marketing and Management of Travel &Tourism products - Bournemouth, UK
Diploma in Linguistics (German) – Goethe institute – Nairobi, Kenya
Associates degree in Business administration – Wake Technical Community College- Raleigh, NC
All-Lines adjusters license- State of Texas
Member of SQL PASS
Microsoft Certified Professional: SQL Server 2012/2014 Business Intelligence
Implementation and Maintenance.
CERTIFICATION
Microsoft Certified SQL Business Intelligence Developer.
TECHNICAL SKILLS
Operating Systems
Windows Server 2008/2003/XP/Vista, Windows 7/8/10
Database Tools
SQL Server Management Studio(SSMS), SQL Profiler, Query Analyzer, DTS Designer
BI Tools
SQL Server Business Intelligence Development Studio, ER Studio, Visual Studio 2010
Languages
T-SQL
OLAP Tools
SSAS, SSRS
ETL Tools
SQL Server Integration Services(SSIS), DTS, SQL Server Import/Export Wizard
Report Tools
SQL Server Reporting Services (SSRS)
Data Modeling
SQL Server Analysis Services (SSAS)
Job Scheduler
SQL Server Agent
Office Tools
MS Word, PowerPoint, MS Excel
PROFESSIONAL EXPERIENCE
GENUENT @SIGNIFY HEALTH Dallas, TX 08/2018 -12/2018
SQL Server Developer
Offered solutions to the issues with the Data mappings, reviewed and amended the mappings according to the business needs and Data specifications, met with the Business as well as other Stakeholders to gather the requirements and created an ETL solution.
Responsibilities
Created different Database objects such as Tables, Views, User Defined Functions, Joins as well as Complex Stored Procedures.
Created mappings for Tables according to specifications per the Business needs.
Auditing, Validation and Error handling of Data.
Scheduled Reports to run daily and weekly.
Reviewed and fine-tuned stored procedure6+s and optimized the queries.
Involved in Testing and Debugging the Stored Procedures and T-SQL.
Troubleshooting of failed packages.
Checking for consistency and integrity between tables.
Processed the BI teams Data requests.
LSP PRODUCTS GROUP Dallas, TX 08/2015 -08/2018
SQL Server SSIS/SSRS/SSAS ETL Developer
Gathered business requirements and mapped customer needs. Designed and created an ETL solution for their Orders received. Responsible for the designing of several Integration packages and supported documentation. Provided system and user level support of multi-user applications and software tools including installation, configuration and maintenance of these applications.
Responsibilities
Defined data sources, data source views, dimensions, measures, hierarchies, attributes, calculations, KPI’s, perspectives and roles.
Involved in creation of fact and dimension tables in the OLAP database and created cubes using MS SQL Server Analysis Services (SSAS).
Identified and modified the Key Performance Indicators (KPIs), measures in co-ordinance with the requirement.
Implement Star and/or Snowflake schemas while designing relational database and data warehouse as per business and report requirements.
Developed complex SSAS cubes with fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
Created Views to reduce database complexities.
Reviewed and fine-tuned stored procedures and optimized the queries.
Analyzed source data to determine the data model and ETL solution that will meet business requirements.
Built the SSIS packages to load the Data into Staging, ODS and dimensional model.
Created packages included a variety of transformations, Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion.
Designed reports using table filters, single value parameters, multi value parameters, Dynamic, dependent parameters and cascading parameters.
Created complex ad-hoc reports, sub reports, linked reports, charts, drill through/drilldown reports and created large number of report models for users to create their own reports.
Created report snapshots to improve the performance of SSRS.
Involved in Testing and Debugging the Stored Procedures and T-SQL.
Designed and developed tabular, matrix, gauges, chart, drill down reports as well as interactive reports according to business requirements.
Created report email subscription using data driven and time driven report subscriptions.
Scheduled the reports to run on daily and weekly basis in report manager then email them to managers and analysts to review in excel spread-sheet.
Environment: SQL Server 2016, Visual studio 2015, BIDS
NATIONAL STAR MORTGAGE Dallas TX 02/2013- 07/2015
SQL Server SSIS/SSRS ETL Developer
Designed and created several Integration packages and business-related data marts. Processed departmental data requests and created applications to provide customer data reports. Identified opportunities for business automation and drove process improvements
Responsibilities
Experienced all facets of SDLC including requirements gathering, designing, coding, testing and deployment.
Designed data structure with multiple facts and dimension tables to hold the source data to be used for building new reports with SSRS.
Implemented a full software life cycle of the data warehouse
Overall database design, such as creating normalized databases, authentication, query tuning, assigning proper indexes.
Designed, Implemented and maintained Database Schema, Entity relationship diagrams, Data modeling, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Schemas, Functions, Views, Rules, Defaults and complex SQL statement.
Designed enterprise reports using SQL server reporting services (SSRS) and excel pivot tables based on OLAP cubes which make use of multiple value section in parameters pick list, cascading and dynamics reports.
Configured packages with package logging, error logging and event handling to redirect error rows and fix the errors in SSIS.
Applied various data transformations like SCD (Slowly Changing Dimension) to maintain the history of the data, aggregate, multicasting, conditional split and derived column.
Involved in performing incremental loads while transferring data from OLTP to data warehouse using different data flow and control flow tasks in SSIS.
Worked with many complex SQL queries using joins and date functions to generate various reports.
Involved in creating sub reports on dashboard, linked reports, charts, snapshot reports, drill through, and report models drill down reports using cubes.
Worked on parameters to generate cascaded parameterized reports along with that extensively used global variables, expressions and functions.
Deployed reports to report manager and troubleshooting for any error occur in execution.
Environment: SQL Server 2016, Visual studio 2015, BIDS
Contact this candidate