We provide IT Staff Augmentation Services!

Ms Sql/bi Developer Resume Profile

Woonsocket, RI

PROFFESIONAL SUMMARY

  • Over 7 years of experience on use and development of MS SQL Server 2000/2005/2008 databases Technologies including DTS, SSIS, SSRS, SQL server Profiler, SQL Server Agents.
  • Actively Involved in software development, designing and implementing Web based and Stand alone software application with major focus on Data Warehousing and Database Applications.
  • Created packages using Integration Services SSIS for data extraction from Flat Files, Excel Files, OLE DB source, XML source, ADO NET source, Raw File Source to Flat Files, Excel Files, OLE DB Destination ADO NET Destination.
  • Knowledge in developing ETL program for supporting Data Extraction, transformations and loading using Informatica Power Center.
  • Involved in Huge data migrations, transfers using utilities like Data Transformation Services DTS , and SSIS, Bulk Copy Program BCP and Bulk Insert.
  • Experience in Developing and Extending SSAS Cubes,Dimensions and data source viewsSSAS-Data Mining Models and Deploying, Processing SSAS objects.
  • Experienced in developing Custom Report and different types of Chat Reports, Tablix Reports, Tabular Reports, Matrix Reports and distributed reports in multiple formats using SQL Server Reporting Services SSRS .
  • Expert in designing Star Schema and snowflake schema with Facts, Dimensions, Measures and Cubes.
  • Hands-on experience across all stages of Software Development Life Cycle SDLC including business requirement analysis, data mapping, build, unit testing, data validation, systems integration and user acceptance testing.
  • Complete knowledge on Data modeling, ETL and BI.
  • Experienced in working on different data bases like Oracle, DB2, MS SQL Server Teradata.
  • Ability to meet deadlines and handle pressure in coordinating multiple tasks in a work environment.
  • Proven knowledge and experience with all aspects of data management, including reporting, data analysis, analytics, and data modeling concepts and techniques.
  • Solid experience in implementing data warehouse and data mart solutions.
  • Strong analytical and communication skills and ability to effectively communicate with all levels of management and staff.
  • Microsoft certified training in SQLSERVER 2008 SSIS/SSRS/SSAS

Technical Skills:

ETL/Reporting Tools

SSIS, SSRS, SSAS 2005/2008/2012, Qlikview, Informatica

Data Modeling

Erwin, Microsoft Visio, IBM Rational Rose.

RDBMS

ORACLE 10g/9i/8i, SQLServer 2008/2005/2000, Teradata, DB2

Operating Systems

Windows 2003/2000/98, Linux Red Hat 7.x, 8.x

Languages

COBOL, C, C , Java, SQL, PL/SQL, T-SQL, UML, XML

Web Technologies

ASP.NET, VB.NET, C .NET, JavaScript, HTML.

PROFESSIONAL EXPERIENCE

Confidential

Role:MS SQL/BI Developer

Confidential retailer and health care company. CVS Health operates over 7,700 CVS Pharmacy and Longs Drugs stores, a pharmacy benefit manager, mail order and specialty pharmacies, a retail-based health clinic subsidiary, MinuteClinic, and an online pharmacy, CVS.com. This project involves designingETL packages,moving data into dimension and fact tables, and generate real time dashboard reports which helps to see latest results and suggestions for the HR and Finance departments.

Responsibilities:

  • Worked as part of a team for gathering and analyzing Business Requirements
  • Participated actively in designing the system database structure.
  • Performed performance tuning of stored procedures using SQL Server Profiler
  • Involved in the development of custom stored procedures, functions.
  • Involved in the optimization of SQL queries which resulted in substantial performance improvement for the conversion processes.
  • Created permanent tables, temporary tables, table variables, indexes, procedures, views and triggers for automating tasks in T-SQL.
  • Developed SSIS packages to Extract, Transform and load data to Data warehouse with different control flow options and data flow transformations such as conditional split, multicast, Union all, for each loop, send mail and derived column.
  • Designed the ETL processes to load data into the target database using SQL Server Integration Services SSIS from various sources.
  • Designed Data-Mart for Prescription using Relational Model and wrote SSIS Packages to extract data from the old PDX system and load it into the new data mart of SQL Server 2012
  • Designed SSISETLpackages to migrate the data from PDX files to the StagingArea in SQL server 2008.
  • Developed SSISETL Packages for migrating data from Staging Area of SQL Server 2005 to SQL Server 2012.
  • Implemented the Master Child Package Model for easier maintenance and better performance of SSISETLPackages.
  • Created the packageconfigurations using XML configuration file and Parent Package Variables.
  • Installed and administered Microsoft SQL Server 2008/05, SQL Server Integration Services 2008/05, SQL Server Reporting Services2008/05, and Team Foundation Server 2008/2005.
  • Built Reports in SSRS for errors generated in SSIS Packages.
  • Saved the SSISETLPackages and Reports in SourceSafe.
  • Designed, coded and implemented ad hoc reports using existing report models in SSRS.
  • Generated Reports using Data Source Views in Report Builder 2.0
  • Developed Reports Using SSRS on statistical data during migration of data.
  • Created Drill Down, Drill through, linked and sub reports using SSRS 2008.
  • Used MDX queries for pre calculated measures.
  • Created report Model on SSAS Cubes as well as changing default configuration on existing Cubes.
  • Used Profiler, Index Wizard and Performance Monitor for performance tuning on SQL Server.
  • Used UML for Design and Documentation.

Environment: SQL Server 2012/08/05,T-SQL,Windows XP/2007,Visual Studio 2008/05, Report Builder 2.0, SQL Profiler, Erwin, SQL Server Reporting services, SQL Server Analysis Services, Visio.

Confidential

Role:SSIS/SSAS/SSRS Developer

Confidential is the World's largest provider of data storage system. EMC offers data storage, information security, analytics, virtualization, cloud computing and other products and services that enable businesses to store, manage, protect and analyze the data.

Responsibilities:

  • Analyzing and understanding the existing reporting environment.
  • Implementing the new reporting requirements for the business by making use of the new database and schema changes.
  • Worked on designing the SSIS packages to transform data various sources like Text files, XML files, Excel, Flat files to SQL server.
  • Created Complex SSAS Cubes with multiple fact measure groups, and multiple hierarchies based on the OLAP reporting needs.
  • Created highly complex SSIS packages using various Data transformations like conditional splitting, Fuzzy LookUp, For Each Loop, Multi Cast, column conversion, Fuzzy Grouping, Script Components.
  • Worked on SSIS 2008 for transferring data from Heterogeneous Databases Oracle, Text format data, Excel, FoxPro to SQL Server.
  • Created XMLA script for adding members to the different roles created.
  • Created multiple partitions and aggregations for the different measure groups for improving performance of the cubes.
  • Created calculated fields with MDX Code to meet additional reporting requirements.
  • Built MDX queries for Analysis Services Reporting Services.
  • Designed, developed, created and tested PivotTable/PivotChart reports based on OLAP cubes and offline cubes.
  • Backing up and restoring the cube as when needed for migration.
  • Backed up master system databases and restoring them when necessary. Supported production environment.
  • Testing the new SSRS reports developed based on different filters and validating the outcome with the database.
  • Interacted with Business Users to help them understand how to generate reports/look at the business data with various drill down options with Excel 2003/Excel 2007 via connecting to SQL Server Analysis Services SSAS .
  • Documented all kinds of SSIS packages, Reports, Tables, and Stored Procedures for the purpose of migration to the DBA Team.
  • Ensure all code and versions are properly maintained in TFS while migration is in progress.
  • Monitoring and supporting the existing reporting environment.

Environment: SQL Server 2012, SQL Server Integration Services SSIS , Analysis Services SSAS , Reporting Services SSRS , MS Visual Studio.Net, C , SQL Profiler, MS Office Suite 2010,Windows 2003/2007 Server OS.

2011Role: SSIS/SSAS/SSRS Developer

This project aims to create rich data which is needed for the Population focus analysis. The complete data relevant to the patients, physicians from different profit and non-profit hospitals is collected and aggregated to make a rich record under single key and further the rich data is analyzed to create relevant procedures to be performed on patients and by physicians.

Responsibilities:

  • Worked with the Data Modeler in gathering the business requirements from the users.
  • Identified the schema changes according to the varied requirements to support daily business operations.
  • Worked with integration services for transferring and reviewing data from heterogeneous sources like Progress Database, Excel, CSV, flat file, Text Format Data .
  • Created the connection to source data Progress database by creating Linked Servers using ODBC drivers and OLEDB Providers to move data into Source system SQL Server database .
  • Performed Bulk data migration using DTS and SSIS from flat files.
  • Developed T-SQL queries, triggers, functions, cursors and stored procedures
  • Built MDX Multi Dimensional Expressions and DMX Data Mining Expressions for analysis and Reporting Services.
  • Designed, developed, created and tested PivotTable/PivotChart reports based on OLAP cubes and offline cubes for business analysts.
  • Designed and created Data Marts, Databases, Indexes, Views, Aggregations, Stored Procedures, Partitions and Data Integrity.
  • Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
  • Identified the Data Source and defining them to build the Data Source Views.
  • Created calculated fields with MDX code to meet additional measures needs that are calculated from existing measures.
  • Designed, developed, createdand tested PivotTable/PivotChart reports based on OLAP cubes and offline cubes for business analysts.
  • Designed and created Data Marts, Databases, Indexes, Views, Aggregations, Stored Procedures, Partitions and Data Integrity.
  • Developed Queries for generating drill down reports in SSRS 2005.
  • Generated Reports using Global Variables, Expressions and Functions for the reports.
  • Designed and implemented stylish report layouts.
  • Identified and worked with Parameters for parameterized reports in SSRS 2005.
  • Documented of all processes involved in maintaining the database for future reference.

Environment: SQL Server 2005/2008, T-SQL, Progress Database, Data Transformation Services DTS , Analysis Services SSAS , Reporting Services SSRS , Integration Services SSIS , MS Visual Studio.Net, C , VB, Microsoft Visio, SQL Profiler, Enterprise Manager, Windows 2003 Server OS.

Confidential

Role: BI Developer

Confidential multinational banking and financial services company and is the second largest in the world. The Bank provides a full range of commercial banking products and services to individuals, corporations, institutions and governments, through its personal financial services, private banking, commercial banking and corporate investment banking and markets segments.

Responsibilities:

  • Involved in the designing, development, modification and enhancing the database structures and database objects.
  • Created complex SSAScubes with multiple fact measure groups and multiple dimension hierarchies based on the OLAP Reporting needs.
  • Transferred data from various OLTP data sources, such as Oracle, MS Access, MS Excel,Flat Files, CSV files into SQL Server 2005.
  • Used SSIS to create ETL packages .dtsx files to validate, extract, transform and load data to data warehouse databases.
  • Wrote several complex stored procedures for efficient handling of the application.
  • Debugged and optimized several complex stored procedures.
  • Constructed cubes based on data volumes mostly adhering to Star Schema.
  • Identified and worked with parameters for parameterizedreports in SSRS 2005

Hire Now