Resume

Sign in

Sql Server Data

Location:
Dallas, Texas, United States
Posted:
February 26, 2018

Contact this candidate

Summary of Qualifications

Over * years of experience in IT industry as a SQL server development experience.

Extensive experience in MS SQL Server 2008R2, 2012, 2014 and 2016 with Business Intelligence in SQL Server Reporting Services and SQL Server Integration Services.

Experienced in creating complex SSIS and DTS packages for ETL purposes. Data Migration, Data Conversions, Data Extraction/ Transformation/Loading (ETL) using DTS and SQL Scripts.

Created OLAP applications with OLAP services in SQL Server and built multi-dimensional cubes.

Experience with MSBI tools like SSIS,SSRS,SSAS using SQL Server and SDCL

Professional Summary

SSAS:

Designing 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.

Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.

Worked with Business analyst, Data architect and business users to understand business processes, document project requirements and translate them into functional and non-functional specifications for BI reports and applications

SSMS:

Created stored procedures, triggers, user-defined functions, views handling business logic and functionality of various modules.

Supported in creation of user logins with appropriate roles, locking the logins, monitoring user accounts and granting privileges to users.

Establishing referential integrity, data consistency, and indexing and data cleanup procedures to maintain high quality data that can be used for reporting.

SSIS

Used various SSIS Transformations such as conditional split, derived column, multicast & merge join etc. on the data retrieved, perform metta data validation checks during staging and then loaded the data.

Designed and developed SSIS Packages to download data from variety of sources like XML, Excel and OLEDB.

Used Different Packages like For Each Loop, Sequence Container, Execute SQL Task, Script Task, File System Task and Data Flow Task.

Used SSIS features like package event handlers, property expressions, and package configurations, transactions in packages, checkpoints and protection levels.

Experience in creating SSIS packages using different type's task such as bulk insert, XML, script, send mail and FTP and with error handling.

Heavily used functionalities for organizing error and event handling by giving precedence constraints, break points, check points, logging and data viewers.

SSRS

Extensively experience in Creating actionable dashboards and developing reports with drill down reports, drill through reports, parameterized reports, table reports, chart reports, matrix and sub reports.

Created interactive reports with SSRS, using the report parameters, query parameters, filters and expressions.

Created SSRS reports with complex calculation fields.

Excellent experience in performance tuning and optimization of SSRS Reports

Implementation of security in SSRS report at item level and group level with SSRS roles.

End-to-end development experience from gather requirements to deployment of SSRS reports

Implemented and configured subscriptions (both data driven, normal subscriptions) to deliver reports.

SQL

Extensive experience in using T-SQL creating tables, stored procedures, views, indexes, cursors, triggers, user defined functions, database models and data Integrity in SQL Server 2012/ 2008/2005 platforms.

Designed and developed databases with the best practices of data modeling and data normalization.

Extensive experience in performance optimization of SQL queries and stored procedures using execution plan, tuning advisor and profiling.

Extensive experience in using MSBI tools like SSIS,SSRS,SSAS using SQL Server

Education/Certifications

-Infonet University : Information Technology (IT)

-Colaberry School of Data Analytics: Certified BI/EDW Developer

-Microsoft Certified Professional (MCP)

Technical Competencies

Operating Systems

Window platform, From XP – Window 10

Database Tools

SQL Server Management Studio(SSMS), SQL Profiler, Query Analyzer, Index Tuning Wizard, Access, MySQL

GUI Tools

SQL Server Business Intelligence Development Studio, Visual Studio 2005/2008/2010

Languages

T-SQL,, XML, VB Script, HTML, C#

OLAP Tools

SSAS, SSRS, Excel

ETL Tools

SSIS, DTS, Import/Export Wizard

BI Tools

SQL Server BI Development Studio (BIDS), SQL Server Management Studio (SSMS), MS Visual Studio 2010/2008, SQL Profiler

Development Methodology

SDCL, Agile

Professional Experience

Novedea Systems, Inc. Plano, TX June 2014 - Current

SQL Server BI/SSIS/SSRS ETL Developer

Novedea Systems is located in Plano, Texas. This organization primarily operates in the Urban Planning and Consulting Services business / industry within the Engineering, Accounting, Research, and Management Services sector. This organization has been operating for approximately 13 years.

Novedea is a business intelligence consulting firm helping organizations achieve superior performance by realizing the business potential of BI technology.

Responsibilities

Gathering information about the business rules from various business process analysts and converting this into new reporting requirements.

Experienced with MSBI tools like SSIS,SSRS,SSAS using SQL Server

Designed SSIS Packages to transfer data from various sources like Text Files, XML Files, Excel and Access to SQL.

Created packages in SSIS with error handling as well as created complex SSIS packages using proper control flow and data flow elements.

Created SSRS Report Model Projects in BI studio and created, modified and managed various report models with multiple model objects, source fields and expressions.

Analyzing a huge number of existing reports so as to understand the logical and interface design changes to be applied accordingly.

Establishing referential integrity, data consistency, and indexing and data cleanup procedures to maintain high quality data that can be used for reporting.

Used SSRS to generate Sub-Reports, Drill down reports, Drill through reports and Parameterized reports.

Analyzed and designed business reports and dashboards in SSRS

Utilized and designed OLAP cubes for report, dashboard and scorecard design

Developed and designed business applications utilizing SSRS software

Designed dashboards and reports using SQL scripting, ETL process and front-end development

Evaluated current and future issues to determine complex business rules and translate into technical code

Modeled data requirements to successfully create graphs and metrics as needed for end-users

Developed new and worked on existing T-SQL stored procedures and triggers, preserve referential integrity, and implemented backup and database maintenance plans.

Designed, reviewed, and created primary objects such as views, indexes based on logical design model, physical model and user requirements.

Environment: SQL Server 2008 R2/2012, Visual Studio 2008/2010/2015, Reporting services (SSRS), Integration Services (SSIS), Analysis Services (SSAS), T-SQL, MS Access, Excel 2007,2010 and Visio.

PLAN DEVELOPMENT CONSULTANCY, Addis Ababa, Ethiopia Jan 2012 - May 2014

SQL BI/SSIS/SSRS ETL Developer

Plan Development Consultancy aspires to provide the very best development advice in the market to a wide range of clients in central and local government, development and regeneration agencies, as well as developers, investors and landowners, large and small since 1995. The network of professionals allows the consultancy firm to combine our national experience with local market knowledge to offer clients a premium service and unrivalled expertise.

Responsibilities

Gathered and analyzed business requirements

Worked with business system analyst, operational risk manager to understand the requirements clearly and to create reports.

Involved in report development, testing and deployment.

Design, build, test and debug based upon specified requirements

Created optimal tables and stored procedures for report design

Created several Excel and report builder reports for mobile services enrollment and claims projects.

Created chart reports, tabular and matrix and parameterized reports using SSRS

Worked on T-SQL programming, stored procedures and views in the process of developing reports.

Developed several detail and summary reports including line and pie charts, trend analysis reports and sub-reports according to business requirements.

Developed reports in SSRS 2008.

Extensively worked on managing ETL process by pulling large volume of data from OLTP to a staging Database using SSIS for data transformation.

Implemented Various Error handling and Event Handling Techniques in SSIS to ensure efficient package execution.

Worked on various SSIS Packages involving multiple Data flow Transformations like Lookup, Merge Join as per the requirement.

Implemented Lookup, Conditional Split and Derived Column tasks while loading Data from Staging to a Data Warehouse.

Involved in building a data-warehouse with Dimensions and Fact Tables based on the Business requirements.

Implemented different Slowly Changing Dimension methodologies to maintain and update historical data corresponding to Dimension tables in the Data warehouse.

Reviewed and fine-tuned stored procedures and macros before production migration.

Created various database objects - Tables, Indexes, Views, and Roles

Involved in regression testing, and optimization of the query.

Environment: SQL Server 2005/2008/2008 R2, Visual studio 2012, MS Access, SSRS, SSIS, T-SQL, Excel 2003, 2007 and Visio.



Contact this candidate