OBJECTIVE:

Five years of Experience in SQL Development, Data Warehousing, Reporting and Business Intelligence solutions using SQL Server 2005/ 2008/ 2008 R 2/ 2012/ 2014. Excellent Experience working with T - SQL and building OLTP/OLAP databases through conceptual Entity Relationship Diagrams and Erwin. Experience in Microsoft SQL Server BI Studio, SSAS, SSIS and SSRS. My domain expertise covers Health Care, Banking, Retail, Finance Industries, and Consulting Domain.

SUMMARY:

• Extensive experience in disciplined Software Development Life Cycle (SDLC) methodologies and gathering business requirements.
• An expert in data analysis, data designing, data mapping, data quality, business and MDR (Minimum data requirements) gathering, Technical Specification writing, project management.
• Involved in accommodating and facilitating Joint Application Development (JAD) sessions, documenting, analyzing and synthesizing the results as part of business requirements.
• Well versed with Enterprise Data Modeling (Dimensional & Relational) involving Normalization, Star-Schema, Snowflake Schema, Fact and Dimension tables using Data Modeling Tools like Erwin 7.0 and MS Visio.
• Experienced in Database Architecture design based on functional and system design requirements of the client using RDBMS concepts and constructs.
• Adept in T-SQL programming and immense experience in creating database objects such as Tables, Constraints, Indexes, Views, Indexed Views and Cursors in support of the enterprise applications.
• Created complex Stored Procedures, Triggers and User Defined Functions to manage incoming data, perform Data Profiling, implemented compliance business logic, Back-Up the databases as well as to support existing applications.
• Experience in optimizing various database objects and T-SQL queries using appropriate joins, index fragmentation and partitioning.
• Extensive hands-on experience in writing complex T-SQL scripts that would perform various types of ETL operations and optimized them to the fullest depth using Microsoft best coding practices.
• Applied security measures at server and database level by creating logins & users (user-roles); encrypted sensitive data using symmetric and asymmetric keys and automated administrative tasks using SQL Server Agent.
• Monitored and Tuned SQL Server performance and created baselines using log-file viewer, activity monitoring system, DBCC utilities (database consistency checks), SQL profiler and Database Tuning Advisor (DTA).
• Assisted in High availability Solutions like Log Shipping and Mirroring based on the organizations functional and financial constraints.
• Worked on all phases of Data Warehouse / Data Mart development lifecycle (using Kimball/Inman Methodologies) from capturing requirements to design, development, implementation and maintenance.
• Involved in High Level Design of ETL Packages using SSIS for integrating data and populating Data-Warehouses / Data-Marts using OLE DB connections from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by making use of various transformations such as Fuzzy Lookup, Fuzzy Grouping, Data Conversion, Conditional Split, Lookup, Bulk Insert, Merge and Union all.
• Created complex ETL strategies that included auditing, transactions, checkpoints, custom loggings (using Event Handlers) and handled processing errors.
• Created Master-Child Packages and managed deploying complex packages from development to production environment using proper SSIS Package configurations.
• Proficient in using Report Manager for setting up roles, security and subscriptions (email/shared directory) on the reports; enabling caching and snapshot to improve the response time and reduce traffic to the report server.
• Supported the migration of data from Heterogeneous Sources and different formats to relational data warehouses, staging databases using Stored Procedures Created Parameterized Reports, Sub Reports, Drill Through, Drill down Reports in SSRS and Ad-hoc Reports using Report Builder.
• Utilized Report Manager to secure the reports with windows user groups and roles for individual reports and also reports folders.
• Hands on experience working on different type of report subscriptions and report caching.
• Hands on experience of report deployment using SharePoint 2010 and using dashboard.
• Thorough knowledge of creating tabular and matrix reports of all types using a relational data source and also using query builder to create a cube based report.
• Worked extensively with canned reports and also report models to make use of user defined ad-hoc reporting.
• Experience creating reports which provide a visually appealing and descriptive representation of information utilizing conditional formatting.
• Experience in creating Scorecard and Dashboard using Microsoft Performance point Service and Tableau Desktop for better and efficient Business Analysis.
• Creation of metrics, attributes, filters, reports, and dashboards. Created advanced chart types, visualizations and complex calculations to manipulate the data. Act as a Point of Contact in Data Interoperability, Analytics and BI and Production Support issue resolution.
• Designed, developed and supported BI solutions, Involved in Debugging and monitoring, and troubleshooting issues/tickets. Implemented advanced geographic mapping techniques and use custom images and geo coding to build spatial visualizations of non-geographic data.
• Transformed Tableau into a managed service offering for consumption across Corporate Treasury and Corporate Investments.

TECHNICAL SKILLS:

DATABASES: Microsoft SQL Server 2005, 2008, 2008 R2, 2012, 2014

DATABASE TOOLS: Management Studio, SQL Profiler, DTA, ER-Win, Visio

DATABASE LANGUAGES: SQL, T-SQL

BUISNESS INTELLIGENCE: BIDS, SSIS, SSAS, SSRS, Tableau, Performance Point, TFS, Informatica

DATABASE MODELING: ER-Diagrams, Dimensional Diagrams, Star & Snowflake Schemas

PROFESSIONAL EXPERIENCE:

SSRS/BI Developer/Analyst

Confidential, Phoenix, AZ

Responsibilities:

• Extracted data from internal data warehouse system to SSRS
• Developed Dashboard and scorecards
• Tracked trouble ticket request for request made by end users
• Created ad-hoc reports
• Modified SP's and formulated basic coding and scripting to be utilized for reports within the organization
• Analyzed data models, data relationships, and dependencies for greatest optimization
• Designed and developed stored procedures, queries and views necessary to support SSRS reports
• Performed functional and performance QA testing
• Designed and developed all web-based application components
• Fully serviced SQL Manager Services Intranet and Content Management Services
• Executed prescribed goals for internal development and future web applications
• Developed operations software applications.
• Managed project milestone delivery in coordination with other company employees
• Kept up-to-date documentation for all developed applications

SQL/ BI Developer

Confidential, Phoenix, AZ

Environment:, Languages, Tools and Technology: SQL Server 2008R2/2012, SSIS, SSRS, TSQL, Erwin, BIDS, DTA, TFS, SharePoint, Tableau, Power BI, Informatica

Responsibilities:

• Interacted and coordinated with many departments to gather requirements and to assure satisfactory data content, quality, data integrity, and receipt of desired information from JRD sessions and following the JAD methodology.
• Conducted review Meetings for common understanding with business, development and test Teams.
• Data warehouse design using Top-down and bottom-up and Data Mart design using Star Schema and Snow-Flake schema.
• Responsible for making weekly backup databases by using SQL Server 2008 and restore these databases in different server.
• Responsible for data analysis, data designing, data mapping, data quality, business and MDR (Minimum data requirements) gathering, Technical Specification writing, project management.
• Created and refined the performance of various SQL scripts and stored procedures by using UDFs, CTEs and System stored procedures along with usage of tools like SQL Profiler and Database Tuning Advisor.
• Created complex stored procedures to perform Index maintenance, data profiling, metadata search, critical staging procedures for loading data marts and reporting database.
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Used SSIS to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Used C#.Net to write Script in SSIS tasks like Script Task and Script Component.
• Written Code in C#.Net to make Web Application and connect with Backend (SQL Server).
• Implemented Master/Child Packages so only the Master Package has to be scheduled which will in turn fire the other packages.
• Created Sequence in SQL Server 2012 to insert same identity value in multiple dimension tables as per the business rules.
• Created SSISDB catalog with SQL Server 2012 to support SSIS package deployments in SSMS with Environment variables respective to each environment.
• Involved in debugging of packages with help of Breakpoints, Checkpoints, Event Handlers and Loggings.
• Handled Performance Tuning and Optimization on SSIS, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.
• Automated the ETL process by scheduling SSIS package execution by creating jobs.
• Developed SQL-based test and audit scripts to validate SSIS packages and data loads, SSRS reports and report stored procedures.
• Created complex SSAS cubes with multiple fact measure groups and multiple dimension hierarchies based on the OLAP Reporting needs.
• Designed and implemented Tabular model using SSDT 2012 and enrich the model by adding relationships, calculated columns, measures, KPIs, and hierarchies.
• Created tabular models and reports that retrieve data and aggregates directly from a relational database system, using Direct Query mode.
• Partitioned the Tabular models for optimized processing and secured to the row-level by using role based security.
• Worked with Windows Presentation foundation (WPF).
• Created several reports using SSRS like drill through reports, linked and sub reports.
• Managed very large reports that return a large volume of records and optimized their performance using techniques like cascading parameters and filters.
• Generated reports using SSRS and Excel Spreadsheets with Power pivots and deployed them in SharePoint integrated mode.
• Used Power View and created various analytical reports and Dashboards from Tabular Models to help managers to identify critical KPIs and facilitate strategic planning in the organization.
• Deployed SSRS reports to the reporting server in SharePoint Integrated mode and assisted in troubleshooting deployment problems.

Data Analyst

• Analysis of functional and non-functional categorized data elements for data profiling and mapping from source to target data environment. Developed working documents to support findings and assign specific tasks
• Worked on claims data and extracted data from various sources such as flat files, Oracle and Mainframes.
• Worked with data investigation, discovery and mapping tools to scan every single data record from many sources.
• Performed data analysis and data profiling using complex SQL on various sources systems including DB2 and Teradata.
• Metrics reporting, data mining and trends in helpdesk environment using Access
• Performing data management projects and fulfilling ad-hoc requests according to user specifications by utilizing data management software programs and tools like MS Access, Excel and SQL
• Written SQL scripts to test the mappings and Developed Traceability Matrix of Business Requirements mapped to Test Scripts to ensure any Change Control in requirements leads to test case update.
• Worked with end users to gain an understanding of information and core data concepts behind their business.
• Assisted in defining business requirements for the IT team and created BRD and functional specifications documents along with mapping documents to assist the developers in their coding.
• Identify & record defects with required information for issue to be reproduced by development team.
• Designed and developed database models for the operational data store, data warehouse, and federated databases to support client enterprise Information Management Strategy.
• Flexible to work late hours to coordinate with offshore team.
• Analysis of functional and non-functional categorized data elements for data profiling and mapping from source to target data environment. Developed working documents to support findings and assign specific tasks
• Involved with data profiling for multiple sources and answered complex business questions by providing data to business users.
• Worked with data investigation, discovery and mapping tools to scan every single data record from many sources.
• Performed data mining on Claims data using very complex SQL queries and discovered claims pattern.
• Created DML code and statements for underlying & impacting databases.
• Perform data reconciliation between integrated systems.
• Metrics reporting, data mining and trends in helpdesk environment using Access
• Extensively used MS Access to pull the data from various data bases and integrate the data.

Tableau

Responsibilities:

Environment: Tableau Desktop 8.2., 9.0

Responsibilities:

• Understand the Requirements and Functionality of the application from specifications.
• Designed, developed, tested, and maintained Tableau functional reports based on user requirements.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameters using Tableau.
• Worked closely with Business users. Interacted with ETL developers, Project Managers, and members of the QA teams.
• Converted existing BO reports to tableau dashboards
• Created different KPI using calculated key figures and parameters
• Developed Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart.
• Developed donut charts and implemented complex features in charts like creating bar charts in tooltip.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics and table calculations.
• Hands on building Groups, hierarchies, Sets to create detail level summary reports and Dashboard using KPI's
• Strong Dashboard design experience and passionate practitioner of effective data visualization. Familiarity with best practices around visualization and design.
• Provided Production support to Tableau users and Wrote Custom SQL to support business requirements.
• Utilized Tableau server to publish and share the reports with the business users.
• Also involved in administration tasks such as Setting permissions, managing ownerships and providing access to the users and adding them to the specific group.
• Distributed Tableau reports using techniques like Packaged Workbooks, PDF to different user community.

SQL/ BI Developer

Confidential, Bethesda, MD

Environment:, Languages, Tools and Technology: SQL Server 2008R2/2012, SSIS, SSRS, TSQL, Erwin, BIDS, DTA, TFS, SharePoint, Tableau, Power BI, Informatica

Responsibilities:

• Interacted and coordinated with many departments to gather requirements and to assure satisfactory data content, quality, data integrity, and receipt of desired information from JRD sessions and following the JAD methodology.
• Conducted review Meetings for common understanding with business, development and test Teams.
• Data warehouse design using Top-down and bottom-up and Data Mart design using Star Schema and Snow-Flake schema.
• Responsible for making weekly backup databases by using SQL Server 2008 and restore these databases in different server.
• Responsible for data analysis, data designing, data mapping, data quality, business and MDR (Minimum data requirements) gathering, Technical Specification writing, project management.
• Created and refined the performance of various SQL scripts and stored procedures by using UDFs, CTEs and System stored procedures along with usage of tools like SQL Profiler and Database Tuning Advisor.
• Created complex stored procedures to perform Index maintenance, data profiling, metadata search, critical staging procedures for loading data marts and reporting database.
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Used SSIS to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Used C#.Net to write Script in SSIS tasks like Script Task and Script Component.
• Written Code in C#.Net to make Web Application and connect with Backend (SQL Server).
• Implemented Master/Child Packages so only the Master Package has to be scheduled which will in turn fire the other packages.
• Created Sequence in SQL Server 2012 to insert same identity value in multiple dimension tables as per the business rules.
• Created SSISDB catalog with SQL Server 2012 to support SSIS package deployments in SSMS with Environment variables respective to each environment.
• Involved in debugging of packages with help of Breakpoints, Checkpoints, Event Handlers and Loggings.
• Handled Performance Tuning and Optimization on SSIS, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.
• Automated the ETL process by scheduling SSIS package execution by creating jobs.
• Developed SQL-based test and audit scripts to validate SSIS packages and data loads, SSRS reports and report stored procedures.
• Created complex SSAS cubes with multiple fact measure groups and multiple dimension hierarchies based on the OLAP Reporting needs.
• Designed and implemented Tabular model using SSDT 2012 and enrich the model by adding relationships, calculated columns, measures, KPIs, and hierarchies.
• Created tabular models and reports that retrieve data and aggregates directly from a relational database system, using Direct Query mode.
• Partitioned the Tabular models for optimized processing and secured to the row-level by using role based security.
• Worked with Windows Presentation foundation (WPF).
• Created several reports using SSRS like drill through reports, linked and sub reports.
• Managed very large reports that return a large volume of records and optimized their performance using techniques like cascading parameters and filters.
• Generated reports using SSRS and Excel Spreadsheets with Power pivots and deployed them in SharePoint integrated mode.
• Used Power View and created various analytical reports and Dashboards from Tabular Models to help managers to identify critical KPIs and facilitate strategic planning in the organization.
• Deployed SSRS reports to the reporting server in SharePoint Integrated mode and assisted in troubleshooting deployment problems.

SQL/SSRS Developer

Confidential, Saint Louis, MO

Environment:, Languages, Tools and Technology: SQL Server 2005, SSIS, SSRS, BIDS, SharePoint 2010, Erwin

Responsibilities:

• Gathered system requirements through end-user collaboration.
• Designed, developed and implemented ETL framework using SSIS, stored procedures, functions for extractions into SQL Server 2005.
• Implemented the developed database into SQL Server 2005 using T-SQL.
• Facilitated data retrieval and manipulation through implementation of Views, Procedures, Triggers and Cursors.
• Analyzed and tuned complex Queries/Stored Procedures in SQL Server 2005 for faster execution and developed database structures.
• Imported data from MS Excel and Text Files to SQL server 2005 using SSIS.
• Provided back-end support for functional testing and performance testing
• Drafted all system documentation along with user manual, flowcharts, and source code.
• Data Migration with MS Access, Excel and Text files and scheduling tasks using SSIS.