We provide IT Staff Augmentation Services!

Data Analyst/bi Analyst/developer-ssis/ssrs/sql Server Resume

Dallas, TX

SUMMARY:

  • 6+years of experience in Information Technology with solid working experience as SQL server Developer with MS BI/ SSIS, SSRS and Tableau.
  • Skilled in writing, reviewing T - SQL code and maintaining coding standards.
  • Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Cursors, Views and User Defined Functions to implement business logic.
  • Strong knowledge and experience with Relational Database Management Systems, including E/R Diagrams, Normalization, Constraints, Querying, Joins, Keys, Indexes, and Data Import/Export.
  • Extensively worked on tools like Index Tuning Wizard, SQL Profiler and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
  • Designed and Implemented Physical and logical models for databases and data warehouses.
  • Hands on experience in ETL (Extract, Transform and Load) development processes using BCP, DTS and SSIS.
  • Developed DTS packages for importing and exporting data from various databases like Oracle, DB2, MS Excel, Flat files.
  • Expert in working with SSIS for creating packages to transform data from different OLEDB Providers like SQL Server, DB2, MS Access, Flat File, Excel, Oracle and Automate the ETL. DTS packages to 2005/2008/2012 SSIS packages.
  • Expertise in creating Cross-Tab, Drill-down and Sub-Reports using RDL and promoting RDLs to Reporting Services Server.
  • Wrote and integrated stored procedures to generate the reports.
  • Created and integrated user defined functions and stored procedures for reporting purposes.
  • Generated reports that can handle dynamic grouping and dynamic sorting.
  • Skilled in defining measures and dimensions using multi-dimensional expressions (MDX), mathematical formulae and user-defined functions to in corporate business rules.
  • Created partitioning, aggregations, perspectives, security roles, KPI’s, named queries and usage based optimization and other performance techniques.
  • Strong knowledge in deploying OLAP tools, Materialized Views, and partitioning techniques for highly responsive Decision Support Systems.
  • Created dashboards with pages in different combinations of reports like Analytic Chart, Analytic Grids, Scorecards and published to SharePoint.
  • Migrated SSRS Reports to Performance Point server 2007 and published them on to SharePoint.
  • Hands on experience in SQL Server Installation, Configuration and implementation of security.
  • Prepared Test Plans and Test Strategies, Executed and reviewed the Test Cases.
  • Very good understanding of the project development life cycle, estimating project-hours, writing project Implementation plans, and preparing back up plans.
  • Self-motivated and methodical, requiring minimal direction. Possess strong communication skills.
  • Strong team player with ability to prioritize workload.

TECHNICAL SKILLS:

Programming Languages: T: SQL, PL/SQL

Databases: MS SQL Server 2012, 2008 R2/2005/, Oracle 9i, Oracle 8.0, MS Access 2003/2007/2013

Database Tools: SQL Server Enterprise Manager, T: SQL, Data Transformation Services (DTS), DBCC, BCP, SQL Server Profiler, SQL Server Query Analyzer, Import/Export tools, SQL Server Agent, SSAS, SQL Server 2005 Reporting Services (SSRS), oracle enterprise manager and TOAD. SQL Jobs, SQL Alerts and SQL Mail, SQL Server Management Studio, SQL Server Integration Services.

Reporting Tool: Tableau reporting tool, SSRS, Excel, Crystal Report, Power BI

Tools: Erwin, Microsoft Visio, DTS, SSIS, SQL Server Analysis Services, Developer 2000 (Forms 4.5, 5.0, 6i), Visual Basic 5.0, HP Quality Center, Workload Automation

Version Control: Team Foundation Server, SVN

Operating System: Windows NT//XP/VISTA/7

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

Data Analyst/BI Analyst/Developer-SSIS/SSRS/SQL Server

Responsibilities:

  • Worked on to analyze and visualize the data on day to day basis using T-SQL, SSRS, PowerBI.
  • Involved in designing of the data warehouse by creating pre-staging, staging and ODS environments and created SSIS packages to load the data to destination tables
  • Wrote queries, SSRS reports using data warehouse to analyze how our products are helping our clients to increase ROI for their business with different variables
  • Also implemented SCD Type 1 and Type 2 changes to the Dimension and Fact tables loading by using Merge and HASHBYTES
  • Implemented MS Analysis Services setup, tuning, cube partitioning, dimension design including hierarchical and slowly changing dimensions.
  • Created calculated measures and dimension members using multi dimensional expressions (MDX), mathematical formulas, and user-defined functions.
  • Created different type of reports including Conditional, Drill-down, OLAP and Sub reports using SQL Server Reporting Services (SSRS).
  • Build and design SSAS Cubes, Dimensions, Schema, Calculations, Partitions, Aggregations and deployed them using deployment wizard
  • Created SSIS Packages to handle the SSRS subscriptions from SSIS and to log all the results and error to the Sql server tables.
  • Created Dynamic ETL Packages such as Packages with the one connection manager that will loop through different server and databases that exist in that databases to calculate ROI for different versions of HCC codes depending up on the DOS Year
  • Used C# script in the packages to send the notification email, to loop through latest folder, to track the logging event and so on
  • Used transformations like Derived column, Lookups, File system Task, XML Task, Fuzzy Lookups, Conditional split, Merge Join, Union, Multicast, UnPivot and so on to load MMR and MOR files on monthly Basis from CMS
  • Validated NDC codes and drugs that exist in the current database and that is there in FDA site.
  • Created Complex Stored Procedures, Triggers, Functions, Tables, Views and other T-SQL code and SQL joins to ensure efficient data retrieval.
  • Created SQL Agent Jobs for scheduling SSIS Packages, SSRS reports and alerts.
  • Developed the reports like monthly provider capacity using NPI’s information, Care Management Report, Total Completed Evaluations by client, ROI for the Client, Total Coding by client and Deployed them in production and used the dynamic subscription to the reports
  • Deployed and scheduled Report subscriptions using SSRS and SSIS to generate all daily, weekly, monthly and quarterly Reports

Confidential, Houston, TX

MSBI Developer

Responsibilities:

  • Involved in the business requirements gathering and analysis.
  • Created technical design document and ETL promotional document.
  • Worked with integration services for transferring and reviewing data from heterogeneous sources like (Excel, CSV, DB2, Flat file, Text Format Data, SQL Server tables and Facets systems).
  • Worked on the data issues for commercial data warehouse and DataMart.
  • Worked on SSIS to remove duplicate records with data standardization.
  • Identified various source systems for data feeds.
  • Created SSIS Package to transfer data from various locations and maintained different master packages with checkpoints and also CDC techniques, FTP/SFTP task then loaded the source data into the database.
  • Created various Jobs, Alerts and Events, Created Backups for databases and automated the process.
  • Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, Column Mapping, Data dictionary and Metadata.
  • Created various SSRS reports to analyze different subject areas especially on the data warehouse.
  • Assisted in building dimensional cubes with SQL Server Analysis Services (SSAS) and querying the data with MDX script, documented all processes and Data Flow involved in the database, using Microsoft Visual Studio and Microsoft Visio for future reference.
  • Implemented MS Analysis Services setup, tuning, cube partitioning, dimension, usage based optimization, perspectives, security roles design including hierarchical and slowly changing dimensions.
  • Expertise in creating Cross-Tab, Drill-down and Sub-Reports using RDL and promoting RDLs to Reporting Services Server.
  • Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, cursors, tables, and views and other SQL joins and statements using T-SQL for applications.
  • Managed index and optimized queries using execution plan.
  • Wrote and integrated stored procedures to generate the reports.
  • Created and integrated user defined functions and stored procedures for reporting purposes.

Confidential, Indianapolis, IN

SQL Server Developer / BI Developer

Responsibilities:

  • Involved in requirements gathering and analysis.
  • Translate business requirements into ETL design specifications.
  • Extensively involved in designing SSIS packages to export data from various source to SQL Server database and Netezza.
  • Experience in creating complex SSIS packages using proper control flow and Data flow elements with error handling.
  • Created DTS (ETL) and SSIS packages for data loads, also performed data migration and data conversion.
  • Validating the daily, weekly, monthly grain transformed data by comparing it with the source system.
  • Modifying the SSIS packages according to the Business requirements.
  • Loading data from various sources like flat files, Excel to SQL Server database using SSIS Package.
  • Coordinated with Business Users to understand business needs and implement the same into a SSAS Cube as a team.
  • Defined cubes, dimensions, user hierarchies, aggregations in an OLAP environment.
  • Assisted in building dimensional cubes with different partitions in SQL Server Analysis Services (SSAS) and querying the data with MDX script.
  • Documented all processes and Data Flow involved in the database, using Microsoft Visual Studio and Microsoft Visio for future reference.
  • Implemented MS Analysis Services tuning, cube partitioning, dimension design including user hierarchies and many to many relationships.
  • Wrote Named Queries with different sources and created the various User Hierarchies.
  • Support the Existing cubes and all its maintenance.
  • Extensive testing on the newly created Cube and also the Performance.
  • Addressing the user data issues and resolving them.
  • Coordinated with Offshore team on fixing the data issues.
  • Scheduled the jobs to process the cube using Workload Automation Job Scheduling Tool.
  • Did some testing Using HP Quality Center.
  • Implemented and maintained Cube security by creating Roles, perspectives.
  • Created Cross-Tab, Drill-down and Sub-Report using RDL. Promoted RDLs to Reporting Service Server.
  • Created couple of reports using Tableau reporting tool.
  • Developed and Deployed Reportson to the Reporting Server.
  • Involved in the Analysis of the Report Data.
  • Created and Analyzed reports on Supply chain Analytics of the Products and its Outage.

Hire Now