SUMMARY

• Over 8+ years of experience in designing, developing, and implementation of system solutions wif Microsoft SQL Server 2014/2012/2008 R 2/2008/2005/2000 in OLTP and OLAP environment.
• Extensive experience wif complex queries, stored procedures, performance tuning and optimization, data profiling and analysis, developing metadata and audit control mechanisms.
• Involved in all phases of Software Development Life Cycle in Data Warehousing.
• Good understanding of warehousing concepts, staging tables, Dimensions, Facts and Star Schema.
• Strong experience wif SQL Server and T - SQL in creating tables, views, stored procedures, indexes, relational database models.
• Expert in designing, developing ETL solutions for large Data Warehouses implementations using SSIS 2014/2012/2008 R2/2005.
• Experience in migrating data from various data sources using SSIS Transformations like Conditional Split, Lookup, Merge Join and Sort and Derived Column.
• Hands on experience in Extraction, Transformation and Loading data from various data sources using MS SSIS.
• Excellent noledge of using variables and expressions in SQL Server Integration Services packages.
• Expert in automating ETL process by creating jobs using AutoSys, error reporting using Alerts, SQL Mail Agent, FTP and SMTP.
• Experience in Creating data sources and data source views (DSVs), named calculations and named queries.
• Expertise in Designing and developing reports using SSRS.
• Designed, developed, created and tested PivotTable/PivotChart reports based on OLAP cubes.
• Created Drill down, Drill through, linked and sub reports using Reporting Services.
• Experienced in developing parameterized queries for generating Tabular reports, Matrix reports.
• Experience in Formatting Report layouts using global variables, expressions and functions.
• Experience in Dimensional Data Modelling and Cube development in SQL Server 2014/2012/2010/2008/2005 Analysis Services (SSAS).
• Experience in Creating cubes, dimensions, measures, measure groups, key performance indicators (KPIs), perspectives, measure group partitions, partition aggregations, data mining models Deploying and processing SSAS objects.
• Expertise in Transforming Logical Database designs into Physical Databases.
• Possess excellent Communication skills and Leadership qualities working in a team.
• Ability and willingness to learn new technology and deliver results in a timely manner.

TECHNICAL SKILLS

Databases: MS SQL Server 2014/2012/2008 R 2/2008/2005/2000 , ORACLE, MS Access

Database Tools: MS SQL Server 2014/2012/2008 R2/2008/2005, SQL Server Integration Services, SQL Server Analysis Services, OLAP(Online Analytical Processing), Multi-dimensional Cubes and Business Intelligence & Development Studio

Languages: HTML, XML, SQL, Java Script, VB.Net, C, C++ and Java

ETL Tools: SSIS (SQL Server Integration Services), DTS

Reporting Packages: SSRS(SQL Server Reporting Services), MS Excel

Analytic Tools: SSAS (SQL Server Analysis Services), MS Excel 2010/2013, Tableau 8.3

Business Tools: MS Word, Excel, PowerPoint, Outlook

Scheduling Tools: Windows Scheduler, MS SQL Agent, AutoSys, Control M

Tools: /Methodologies: MS Visio, Erwin, MS Project, SQL Profiler, SQL*Loader, Front page

Monitoring Tools: BI xPress SE 5.7, Spotlight

Version Control: Team Foundation Server 2013/2012, Tortoise SVN

PROFESSIONAL EXPERIENCE

Confidential, Fort Lauderdale, FL

Sr. Microsoft BI Developer (SSIS)

Responsibilities:

• Confidential is leading the transition to software-defining the workplace, uniting virtualization, mobility management, and networking and SaaS solutions to enable new ways for businesses and people to work better.
• Confidential solutions power business mobility through secure, mobile workspaces dat provide people wif instant access to apps, desktops, data and communications on any device, over any network and cloud.
• Over the years at Confidential, me have worked on Simplicity, Daylight, Service BI and DW Consolidation projects.

Confidential, Fort Lauderdale, FL

Sr. Microsoft BI Developer (SSIS)

Responsibilities:

• Involved in migrating and upgrading SSIS packages from SQL Server 2005, 2008, 2008R2 and 2012 to SQL Server 2014.
• Coordinate wif SSAS developer and create required back end data, calculated metric fields and views to support building the Cube.
• Diagnosed and tuned the server optimal performance using SQL server 2012, Dynamic management views, Profiler and Index Tuning Wizards.
• Creating the test plan, test cases and carried out Unit test validations.
• Automating the validations for Cube metrics using dynamic SQL Server connections in MS Excel 2013 and also comparing the logic wif Business Matrix and BRD.
• Assisting power users to create business reports using reporting tools such as MS Excel and Tableau and conducted workshops to guide business users how to use SSAS cubes via Excel application/Management Studio.
• Knowledge on Tableau server to create parameterized reports as well as regular reports.
• Documented the definitions and applications of data mart objects and cube metrics including SQL Queries.
• Automating the process of unit test validations using MS SQL Server applications.

Environment: Microsoft SQL Server 2008, 2008R2, 2012 and 2014 Enterprise Edition, T-SQL, SQL Server Integration Services, SQL Server Analysis Services, Tableau 8.3, MS Visio, MDX, Windows server 2012R2, MS SharePoint, Salesforce application, Avaya call system, TFS 2013, MS Office 2013.

Confidential, Fort Lauderdale, FL

Sr. Microsoft BI Developer (SSIS)

Responsibilities:

• Responsible for gathering requirements from users/functional team, project manager and involved in defining the LOEs for designing the database schema, objects, and metrics based on the business needs.
• Analysing data extracted from different sources such as Salesforce application, SAP database and other legacy system, merging the existing data warehouse wif new data source and requirements given by business users.
• Designed incremental as well as full load packages for facts and dimensions wif approaches like hashbytes matching algorithm, Lookup, Temp table wif retain connection etc.,
• Implemented Type-1 and Type-2 slowly changing dimensions using HashBytes (MD5) algorithm which increased the load performance by 100 times when compared to traditional techniques.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc., to generate underlying data for the reports and to export cleansed data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Created and maintained database objects and complex stored procedures, triggers, cursors, views, user defined functions and implemented complex joins.
• 24/7 Production support for existing ETL jobs and cube packages dat currently running on the production server.
• Troubleshooting the failure reason of SSIS packages and Cubes, backtracking and providing instant solution to ensure data is always up to date in data warehouse and flowing to the downstream systems.
• Security setup such as creating different database roles to ensure different level of users have the right access to database objects.
• Implemented the integration of Task Factory components in SSIS packages and configured BI Xpress auditing.
• Evaluated and wrote many MDX queries based on Measure value in SSAS calculation.
• Assisting power users to create business reports using reporting tools such as MS Excel and Tableau and conducted workshops to guide business users how to use SSAS cubes via Excel application/Management Studio.
• Knowledge on Tableau server to create parameterized reports as well as regular reports.
• Automating the validations for Cube metrics using dynamic SQL Server connections in MS Excel 2013 and also comparing the logic wif Business Matrix and BRD.
• Documented the definitions and applications of data mart objects and cube metrics including SQL Queries.

Environment: Microsoft SQL Server 2012 Enterprise Edition, T-SQL, SQL Server Integration Services, SQL Server Analysis Services, Tableau 8.3, MS Visio, MDX, Windows server 2012R2, MS SharePoint, Salesforce application, Avaya call system, TFS 2012, MS Office 2013.

Confidential, Fort Lauderdale, FL

Sr. Microsoft BI Developer (SSIS)

Responsibilities:

• Gathering requirements from the functional team on the commissionable/compensation sales for the sales representatives.
• Data Analysis on the crediting data from the Callidus application.
• Validating the Callidus crediting application data against the Sales Interim report application from the GEOs as per the business rules to understand the credit generation for the sales reps.
• Involved in designing and developing data mart objects and views necessary for customizing the Tableau dashboard.
• Diagnosed and tuned the server optimal performance using SQL server 2012, Profiler and Index Tuning Wizards.
• Involved in creating and hosting the Tableau dashboards to QA and Production Servers.
• Involved in documenting the project closure documentation.

Environment: Microsoft SQL Server 2012 Enterprise Edition, Microsoft Visual Studio Ultimate 2013,T-SQL, SQL Server Integration Services, MS Visio, Windows server 2012R2, MS SharePoint, TFS 2012, MS Office 2013.

Confidential, Fort Lauderdale, FL

Sr. Microsoft BI Developer (SSIS)

Responsibilities:

• Involved in designing and developing the data mart based on the business requirements and provided documentation.
• Involved in identifying source side data issues and worked wif the team to resolve the issues.
• Created and maintained database objects and complex stored procedures, triggers, cursors, views, user defined functions and implemented complex joins.
• Designed and Developed ETL packages using MS SSIS 2012 and implemented Project Deployment Model wif package configurations in the environment variables referenced to the packages and jobs.
• Implemented the integration of Task Factory components in SSIS packages and configured BI xPress auditing.
• Involved in the project deployment wif QA and Prod DBAs to Production and QA servers.
• Configured the SSIS packages to send email notifications and also configured the SQL Server Agent Job Scheduling for the project to run the jobs on a given schedule.
• Created Audit packages to record the error messages and as well as timestamp gap for all the packages.
• Documented the Project Detailed Design as part of the project closure.

Environment: Microsoft SQL Server 2012 Enterprise Edition, T-SQL, SQL Server Integration Services, MS Visio, Windows server 2012R2, MS SharePoint, Avaya call system.

Confidential, Raleigh, NC

Sr. Microsoft BI Developer (SSIS)

Responsibilities:

• Involved in requirements gathering and data analysis for each source system.
• Participated in the discussions wif Business Stake Holders in understanding and validating the business needs and requirements.
• Prepared the high level and low level design documents for ETL strategies.
• Designed and Developed ETL strategies and frame work for data extraction, transformation and loading process for each subject area and prepared mapping specifications wif appropriate transformation rules.
• Designed and Developed the ETL packages using MS SSIS 2008 for each Data Mart data load process.
• Involved in identifying data and design issues and procedures to improve/maintain quality along wif data warehouse architect.
• Worked wif .Net team to integrate SSIS packages wif C# Web Applications to process and generate required files based on the user’s inputs and button clicks.
• Closely worked wif the .net team in integrating the .Net components and SSIS packages for Work Assistant (internal) application.
• Worked on data quality issues and performed the data profiling and cleansing at database and ETL level.
• Performed the performance tuning of SSIS packages.
• Involved in the development of custom stored procedures, functions, SQL, T-SQL
• Involved in testing, bug fixing and documentation for the project
• Involved in preparing Test cases, and Test scripts.
• Involved in Integration testing.
• Prepared the release notes and design, test and deployment artifacts.
• Involved in troubleshooting and fixing the production issues.
• Used TFS as a source control system, version control and change management tool.

Environment: Microsoft SQL Server 2008R2/2005, Microsoft Office 2010/2007, AutoSys, Visio, SVN subversion, SSRS/SSIS 2008R2/2005, T-SQL.

Confidential, Tampa, FL

Sr. Microsoft BI Developer (SSAS/SSRS)

Responsibilities:

• Responsible for gathering and analysing End User Requirements and System Specifications.
• Involved in identifying data and design issues and procedures to improve/maintain quality along wif data warehouse architect.
• Modelled ETL framework to automate daily data loads, setup error handling, logging, restartability and alerting.
• Wrote complex T-SQL code and Stored Procedures to load dimensions and to enable data extractions and changed data capture.
• Wrote T-SQL procedures to generate DML scripts dat modified database objects dynamically based on user inputs.
• Designed and developed and improved complex ETL structures to extract, transform and load data from multiple data sources into data warehouse and other databases based on business requirements.
• Created Stored Procedures to perform load operations to speed up the ETL processing.
• Created complex ETL strategies to extract, clean and deliver data to OLAP environment.
• Built efficient SSIS packages for processing fact and dimension tables wif complex transforms and slowly changing dimensions.
• Performed metadata validation, reconciliation and appropriate error handling in ETL processes.
• Designed and developed SSIS packages toextract the data into the system from multiple upstream data sources.
• Wrote JIL code to create AutoSys scheduling jobs for automating the ETL, Analysis Services Cube Processing.
• Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data.
• Created complex cubes using SSAS to ensure better application performance and enabled flexible reporting capabilities.
• Designed and developed Dimension tables, Fact tables and cubes.
• Designed and developed hierarchies and rollups.
• Developed SSRS reports using SQL Server/Analysis Services (SSAS) & MDX Scripts.
• Extensively Used SSIS and SSAS tocreateprocess and partition cubes.
• Optimized and redesigned existing data marts.
• Designed and Developed Cubes and Dimensions wif different Architectures and Data Sources for Business Intelligence using SQL Server.
• Created Dynamic Drill-down, Drill- through, toggle and filtering capabilities to provide insights into specific areas of interest
• Created various dynamic reports for testing purpose of the data in order to make sure if reports were correct.
• Built data marts, databases, tables, indexes, views, functions, triggers and stored procedures.
• Involved in Production Support for SSIS/SSAS/SSRS.
• Built reports using Reporting Services, automated report rendering wif RSRunner utility tool and created AutoSys jobs for scheduled deliveries.
• Used SVN Subversion tool for version control.

Environment: Microsoft SQL Server 2008R2/2005, Microsoft Office 2010/2007, ODBC, AutoSys, Erwin, SVN subversion, SSRS/SSIS/SSAS 2008R2/2005, T-SQL.

Confidential, Reading, PA

Sr. Microsoft BI Developer (SSIS/SSAS/SSRS)

Responsibilities:

• Responsible for gathering and analysing EndUser Requirements and System Specifications.
• Designed multi-dimensional models, including the construction of Data Views, Dimensions, and Cubes while adhering to enforced development methodologies.
• Installed and administered Microsoft SQL Server 2008R2 and Team Foundation Server 2008R2.
• Developed SSIS Packages for migrating data from Staging Area of SQL Server 2005 to SQL Server 2008R2.
• Implemented the Master Child Package Model for easier maintenance and better performance of SSIS Packages.
• Designed and developed SSIS packages toextract the data into the system from multiple data sources.
• Configured SQL mail agent for sending automatic emails when a SSIS process is failed succeeded or completed.
• Applied various data transformation tasks like Slowly Changing Dimensions, Multicasting, Conditional Split, Derived Column and other transformations available in the SSIS.
• Deployed the packages (both the methods File system & SQL Server system) to different environments (test environment, production environment).
• Created database objects like tables, views, indexes, views and stored procedures.
• Created OLAP cubes in SQL Server Analysis Services 2008R2 & 2005 for company wide use.
• Built MDX queries for Analysis Services & Reporting Services.
• Created calculated fields wif MDX code to meet additional measures needs dat are calculated from existing measures
• Designed and developed Data Marts, Databases, Indexes, Views, Aggregations, Stored Procedures, Partitions and Data Integrity.
• Developed MDX queries and utilized MDX Functions (CurrentMember, PreviousMember Lead, Lag, YTD, SUM etc.,) to generate reports and KPI’s using OLAP Cubes.
• Utilized existing indexes in ROLAP to optimize the performance of reports accessing as well as all other BI applications
• Used Temp Tables to reduce the number of rows for joins, to aggregate data from different sources for different reports
• Optimized the performance of queries wif modification in TSQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes wherever necessary
• Created Dynamic Drill-down, Drill- through, toggle and filtering capabilities to provide insights into specific areas of interest
• Created various dynamic reports for testing purpose of the data in order to make sure if reports were correct.
• Involved in testing, bug fixing and documentation for the project
• Used TFS as a source control system, version control and change management tool

Environment: Microsoft SQL Server 2008R2/2005, Microsoft Office 2010/2007, ODBC, Erwin, Team Foundation Server, Crystal Reports 10 and SSRS/SSIS/SSAS 2008R2/2005

Confidential, Whitehouse, NJ

Sr Microsoft BI Developer (SSIS/SSAS/SSRS)

Responsibilities:

• Gathered and analysed Business requirements and System Specifications.
• Defined and responsible to implement the BI security model and worked wif security admin to ensure the model is being followed.
• Installed and administered Microsoft SQL Server/SQL Server Integration Services/SQL Server Reporting Services 2008R2/2005, and Team Foundation Server
• Performed analysis to identify source and nature of data required for ETL solutions.
• Worked on SSIS to load text files to SQL Server.
• Created complex ETL strategies to extract, clean and deliver data to OLAP environment.
• Reused SSIS Packages and performed timely executions for loading the data into the Database as required.
• Performed metadata validation, reconciliation and appropriate error handling in ETL processes.
• Performed testing of ETL data flows.
• Built Reports in SSRS for errors generated in SSIS Packages
• Designed and Developed Cubes and Dimensions wif different Architectures and Data Sources for Business Intelligence using SQL Server.
• Developed a multi-dimensional database and OLAP cube using SQL server 2008R2
• Designed fact and dimension tables, Created multi-dimensional OLAP Cubes.
• Developed Reports Using SSRS on statistical data during migration of data
• Created Drill Down, Drill through, linked and sub reports using SSRS 2008R2
• Used MDX to extract data from cubes and Created MDX script for representing Cube Calculation
• Designed Dashboards and deploy them to MOSS 2007
• Developed Excel web parts for reports, KPIs and deploy to MOSS 2007.
• Deployed reports through Microsoft SharePoint Server 2007.
• Involved in the development of custom stored procedures, functions, triggers, SQL, T-SQL
• Designed, coded and implemented ad hoc reports using existing report models in SSRS
• Generated Reports using Data Source Views in Report Builder 2.0
• Performed performance tuning of stored procedures using SQL Server Profiler
• Used SQL Server Profiler, Index Wizard and Performance Monitor for performance tuning on SQL Server.
• Used UML for Design and Documentation
• Saved the SSIS Packages and Reports in Team Foundation Server

Environment: SQL Server 2008 R2/2005, T-SQL, Windows XP/2003, Visual Studio 2008/2005, Report Builder 2.0, SQL Profiler, Erwin, SQL Server Reporting services, SQL Server Analysis Services, Visio, MOSS

Confidential, Anaheim, CA

SSIS/SSAS/SSRS Developer

Responsibilities:

• Responsible for gathering requirements from Business Analysts and ETL Architect to understand Source and Data warehouse data model, technical metadata and cleansing/transformation rules.
• Designed and developed and improves complex ETL structures to extract, transform and load data from multiple data sources into data warehouse and other databases based on business requirements.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP) and SSIS.
• Implemented various ETL Jobs and Tasks to support the incremental, historical data loads and transformations using SSIS.
• Used various transformations in SSIS like Lookup, Fuzzy grouping, Row count Transformations.
• Extensively Used SSIS and SSAS tocreateprocess and partition cubes.
• Used SSAS (SQL Server Analysis Services) for designing UDM including dimension and Fact Tables
• Developed reports using the Business Objects suite of reporting and developer products (XI R2 version, Dashboard Manager, Analytics, Predictive Analysis, Crystal Reports, Auditor, Designer, Live Office).
• Created complex cubes using SSAS to ensure better application performance and enabled flexible reporting capabilities.
• Designed Dashboards, Analytical Chart’s and Pivot Tables.
• Optimized and redesigned existing data marts.
• Managed existing indexes in ROLAP to optimize the performance of reports accessing it as well as all other BI applications.
• Utilized Pivot tables to provide structure to Reports in proper format like months etc.
• Created various dynamic reports by using formulas in Crystal Report 10 as part of enhancement
• Configured SQL mail agent for sending automatic emails when a SSIS process failed succeeded or completed
• Involved in testing, bug fixing and documentation for the project.

Environment: Windows XP, Microsoft SQL Server 2008/2005, SQL Enterprise Manager, Query Analyzer, Microsoft Excel, ODBC, Erwin, Visual Source Safe, Crystal Reports 10 and SSRS/SSIS/SSAS 2008/2005

Confidential

SQL Server Developer/DBA

Responsibilities:

• Gathered requirements from business users.
• Analysed the existing process and provided information and assistance to the Database Architects On physical models, and the setup and maintenance of metadata.
• Wrote functional specification documents.
• Designed data models using Erwin data modeling tool.
• Created in-depth source to target mapping document.
• Created DTS Packages to load dimensions and fact tables.
• Created indexes, constraints, views and rules on database objects.
• Performance tuned T-SQL code, Stored Procedures and DTS Packages.
• Scheduled, monitored and provided production support for DTS Packages.
• Participated in database logical design to fit new business requirement, and implemented new design into SQL Server 2000.
• Wrote Transact SQL utilities to generate table insert and update statements.
• Involved in performance tuning and monitoring of T-SQL blocks.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures.
• Worked closely wif business users in defining and documenting reporting requirements in order to design, develop and maintain SQL Server 2005 reporting services.
• Generated server side T-SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances
• Wrote T-SQL procedures to generate DML scripts dat modified database objects dynamically based on user inputs
• Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data.
• Designed and developed various Drill down, Parameterized, Sub reports and Adhoc Reports using SSRS.
• Designed and developed ETL packages for loading data into the destination tables from multiple data sources.

Environment: SQL Server 2005/2000, DTS, T-SQL, MS OLAP, CVS, Crystal Reports, C# .Net, ASP .Net, ADO .Net, ER Studio, SSIS, SSRS, Erwin.