PROFESSIONAL SUMMARY:

• MS SQL Server Developer with 7+ years of strong experience in Health Care, Insurance, Retail, Finance and Banking domains.
• Highly proficient in operating MS SQL Server 2014/2012/2008 R2/2008/2005 suite of products like SSIS, SSRS, SSAS and Power BI SDLC from prototyping to deployment.
• Conversant with all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development, Testing and Implementation.
• Area of experience includes Data Modelling, ETL, Data Warehousing, Business Intelligence, OLAP Cubes, Reports and Data Visualizations.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling / Kimball Methodologies for OLAP.
• Hands on experience on MDX, T - SQL, PL SQL, Power Pivot and Power View reports. Proven ability to identify business needs and develop valuable solutions to drive accuracy and process efficiency.
• Hands on experience in Logical and Physical Database design & development, Normalization and Data modeling using Erwin data model.
• Hands on experience with Data Marts, Dimensional Modeling, ER Modeling, Star Schema / Snowflake Schema, FACT and Dimensional tables and Operational Data Store (ODS) involved in Business Analysis of the OLTP and OLAP data in decision support.
• Proficient in using T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Functions, User profiles, Relational Database Models and Data Integrity, SQL joins and Query Writing.
• Expert in Developing SSIS Packages to Extract, Transform and Load (ETL) data into the Data warehouse from Heterogeneous databases such as Oracle, DB2, Sybase and MS Access.
• Proficient in creating, analyzing and testing of OLAP cubes in SQL Server analysis services (SSAS) using MDX.
• Proficient in developing visualizations with Tableau 10.x/9.x/8.x and deploying those visualizations to Tableau Server.
• Involved in the creation of large and complex data sets and evaluated them.
• Strong ability in generating drill down reports and writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS 2008/2005.
• Proficient in using tools like MS SQL Profiler, Database Engine Tuning Advisor, Windows performance for monitoring and tuning SQL Server performance.
• Knowledge in Data Governance and the processes including data stewardship, data quality, master data management and use cases.
• Conversant in Database Installation, Capacity Planning, Implementing Backup and Recovery Strategy for application and database.
• Experience of ERP system implementation, ERP system troubleshooting, ERP system customizes reports develop.
• Extensively involved in writing SQL queries (Subqueries and Join conditions), co-related subqueries, inline views and PL/SQL programming.
• Experience in .NET/C# application development environment to use SQL Server Databases.
• Experience in writing JavaScript, VBScript and batch files using DOS Commands.
• Strong leadership, communication, problem-solving and multi-tasking abilities.

TECHNICAL SKILLS:

Database: MySQL, SQL Server 2005/2008/2008 R2/2012, 2014,2016, Oracle, DB2, Microsoft Access

ETL Tools: SSIS, Informatica, Talend, SAP - Business Warehouse, Power Query.

Data Modelling: Erwin, TOAD data modeler

BI/Reporting: Microsoft BI (SSIS, SSAS, SSRS), Self-service BI (Power Pivot, Power View, Power Query), DAX Studio, (Report Studio, Query Studio, Analysis Studio, Metric Studio), BIDS, Tableau, Power BI reporting tool.

Programming Language: SQL, T-SQL, PL/SQL, MDX, C, VB Script, C#, VB.NET, Shell Scripting, JavaScript, Java. Classic ASP, Asp.net, .Net framework.

Operating System: Windows 10, Windows 7, Windows XP, Windows 2000, Windows 95/98, MS DOS.

PROFESSIONAL EXPERIENCE:

Confidential, Jacksonville, FL

Data Analyst/MSBI Developer

Responsibilities:

• Analyze marketing, sales, and operation data based on financial modeling and recommend next actions to improve ROI based on the data analyzed. Prepare trending reports and continually improve analytics dashboards in place today.
• Build data models and that show trends, ROAS (Return on Ad Spend) performance trending, lead projection forecasting. Use existing company technology while integrating new technology to optimize efficiency and increase ROI.
• Use data to better understand target market, segment audiences, run queries and perform analysis to support decision-making process.
• Create monthly, weekly and daily reporting dashboards on marketing-generated leads. Make recommendations to adjust tactics for future campaigns to meet lead and pipeline development goals.
• Establish and report on KPIs across all online and offline marketing channels.
• Participate in the creation and execution of marketing campaigns, track the success of campaigns, conduct ROI analysis and present findings to senior leadership.
• Coordinate with Marketing and Finance departments on budget vs. actual spend reporting.
• Effectively manage multiple projects varying in scope and deliverables while remaining focused in a fast-paced environment to ensure the target delivery or time-sensitive projects are met.
• Experience building automated Extract Transform and Load (ETL) systems to process incoming data sources.
• Implemented ETL to migrate the data from azure database for Dynamics CRM 365 application to SQL Server using Kingsway soft tool.
• Support end user reporting tools such as Microsoft Power BI, SSRS, Domo.
• Create and manage analytical tools that transform operational data into actionable business intelligence.
• Perform detailed data exploration and validation from a variety of sources.
• Used Red gate tool for comparing the scripts in the production environment with the backup to ensure no errors in the deployment.
• Coordinated with the change advisory board (CAB) for accessing the risks and consequences of requested changes and the implemented change does not cause service interruption.
• Collaborate with other departments to solve problems and identify trends and opportunities.

Environment: MS SQL Server 2014/2017, Windows 10, T-SQL, SSIS, TFS 2017, MY SQL Workbench, DOMO, CRM365, AZURE DevOps

Confidential, Woonsocket, RI

Sr BI Developer

Responsibilities:

• Analyzed business requirements and build logical data models that describe all the data and relationships between the data.
• Knowledge on Kimball data warehouse methodology for creating a data warehouse.
• Involved in designing and developing packages for a Data Warehousing and Data Migration projects using Integration services (SSIS) on different Data Sources.
• Extracted the data from Flat Files, transformed (Implemented required Business Logic) and Loaded into the target DW using SSIS (SQL Server 2014).
• Created SSIS Packages by using various Control Flow and Data Flow Tasks to execute SQL Task for each loop Container, Derived Column, and Data Conversion.
• Created package to transfer data between OLTP and OLAP database using Lookup, Derived Columns, Condition Split, Aggregate, Execute SQL Task, and Data Flow Task, Execute Package Task etc. to load underlying data into the tables from Text files, Excel files, CSV files and XML files.
• Utilized knowledge of ERP Systems to assist in identifying processes and constructing process flows.
• Assist data modelers in designing of dimensional model for Star schema.
• Developed complex calculated measures using Data Analysis Expression language (DAX).
• Developed Power BI reports using query logic based on business rules, and visuals selected by United stakeholders.
• Creating Power Pivot models and Power Pivot reports, publish reports on SharePoint, and deploy models into SQL Server SSAS instance.
• Merging and transforming data according to the requirements for ease of analysis in Excel by using Power Query in Power BI.
• Developed packages to handle data cleansing, loading multiple files and executing tasks multiple times (using For Each Loop).
• Enhanced and wrote triggers, existing stored procedures, views, functions, database objects to meet additional requirements of latest releases, Coding using Transact-SQL (TSQL). Created and maintained Physical Structures.
• Working with Dynamic Management Views, System Views for Indexing and other Performance Problems.
• Modified the Existing SSIS Packages and added more audits and alerts in case of package failure.
• Worked with Tabular reports, Matrix reports, Gauges & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, drill down reports as well as interactive reports according to business requirements in time restricted environment using SQL Server Reporting Services (SSRS).
• Participated in reviews of issues related to SSRS reports and work in troubleshooting those issues, fixing, testing and deploying them.
• Involved in writing the technical documentation and maintained throughout the process.
• Experience in working with the GIT source control version 2.17.2 for developing code.
• Involved in the CAB process, to ensure the change deployed will have no affect the other processes and offering the suggestions to reduce the overall company’s risk.
• Defined data repository requirements, database performance and cost, and performed backup and restored the databases using SQL Server management studio.

Environment: MS SQL Server 2014, Visual studio 2015, SQL Server Integration Services, SQL Server Reporting Services, SQL Server analysis services, OLAP, Power BI, Power Query, Power Pivot, T-SQL, VSS, MS-Access, MS Excel, Report builder, VB.NET.

Confidential, Sacramento, CA

Sr. MSBI Developer

Responsibilities:

• Conducted detailed analysis of each Legacy source system interface with enterprise Data warehouse (EDW) including all existing Mainframe Files and Data elements to be converted from Source system to Target Pre-staging.
• Worked with Business Analyst, SME’s and Data architects to understand business requirement and involved in planning, defining and designing data based on the requirements.
• Used For-Each Loop Container, Sequence Container, Script task, Expressions, Execute SQL task, Variables, Send Mail Task, Package Execution task to achieve business needs.
• Designed and developed SSIS (ETL) packages for loading data from OLTP system, DSR (Staging Database) to DW.
• Responsible for creating database objects like Table, Stored Procedures, Triggers, Functions etc using T-SQL to provide structure to store data and to maintain database efficiently.
• Developed Package Configuration by using SQL Server type for making Package dynamic.
• Created Views to reduce complexity of end user.
• Provide troubleshooting for existing ERP users using SQL queries.
• Involved in performance monitoring and tuning of TSQL queries using SQL Profiler and database engine tuning advisor.
• Created Indexes to optimize performance of TSQL queries.
• Generated multiple enterprise reports using SSRS from OLTP and OLAP, and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports etc.
• Developed reports, dashboards, and SQL queries using Tableau.
• Generated SSRS Report through SSIS Package using script component as per business requirement.
• Extensive Knowledge of SSAS storage and partitions, and Aggregations, calculation of queries with DMX, Data Mining Models, developing reports using MDX and SQL.
• Collected existing infrastructure information including Active Directory, SQL server, Reporting Server instance for implementation of MS Dynamics CRM 365 .
• Expert in automating process by creating jobs and error reporting using Alerts, SQL Mail Agent.
• Successfully tested all task in staging and stored all versions of data using team foundation server (TFS).
• Created documents for all Store Procedure, SSIS Package and SSRS Reports that I have developed.

Environment: T SQL, SQL Server 2012, SSRS, SSIS, ASP.NET, C#, Dynamic CRM, Team Foundation Server (TFS), Visual Studio 2012, SQL Server Management Studio, Tableau.

Confidential

MSBI Developer

Responsibilities:

• Installed SQL Server 2012 and configured the database.
• Migrated data from Heterogeneous Data Sources (Excel, Flat file, CSV file) to centralized SQL Server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.
• Worked on Data Flow Transformations like Slowly Changing Dimension, Conditional Split, Data Conversion, Derived Column, Look-up & Script Component, Aggregate, Audit etc.
• Created packages in SSIS with error handling and Worked with different methods of logging in SSIS.
• Developed packages to handle data cleansing, loading multiple files and executing tasks multiple times (using For Each Loop).
• Designed data model from the scratch to assist the team in data collection to be used for Tableau visuals.
• Generated Tableau Dashboard with quick/context/global filters, parameters and calculated fields on Tableau reports.
• Creating new Documentation, DB Schema designing, creating new ERD's using Visio.
• Proficient in creating, analyzing and testing of OLAP cubes in SQL Server analysis services (SSAS) using MDX.
• Worked with T-SQL to create Tables, Function and Stored Procedures, sub-query, correlated sub-query, complex Stored Procedures and ad-hoc TSQL statement in GIT source control.
• Developed Query for generating drill down reports in SSRS 2012.
• Created Views and Synonym to reduce complexity of end user Responsibility for gathering/refining requirements from the customer for developing reports.
• Identified the Data Source and defining them to build the Data Source Views.
• Experience in Backup and Restore databases by SQL Server Management Studio and writing T-SQL.
• Developed entity-relationship diagram and data dictionary for project coordination; created SQL create, alter, and insert scripts.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Identified and worked with Parameters for parameterized reports in SSRS 2008.

Environment: MSSQL Server 2012, Visual studio 2014, SQL Server Integration Service, SQL Server Reporting Services, GIT Source control, Query Analyzer, Enterprise Manager, DTS Designer, SQL Profiler, Index Tuning Wizard, MS Access, MS Word, Tableau.

Confidential

MS SQL Server Developer

Responsibilities:

• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple homogeneous and heterogeneous information sources (CSV, Excel, Oracle db, and SQL 2008).
• Requirement gathering, Functional & technical specifications for end user and end client applications, Re-Engineering and capacity planning.
• Involved in database Schema design and development.
• Experience in using T-SQL for creating stored procedures, indexes and functions.
• Generated server-side T-SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.
• Creating tables, indexes and designing constraints and wrote T-SQL statements for retrieval of data and involved in performance tuning of T-SQL Queries and Stored Procedures.
• Used SSIS to create ETL packages to validate, extract, transform and load data to trouble databases, data mart databases.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Experienced in error handling and troubleshooting the scripts in failure to load the data into database.
• Created SSIS Templates for developing SSIS Packages in such a way that they can be dynamically deployed into Development, Testing and Production Environments.
• Developed DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle using SSIS.
• Created packages in SSIS with custom error handling and worked with different methods of logging in SSIS.
• Developed modules of the application in ASP.NET and involved in writing C# classes.
• Identified and Defined Key Performance Indicators (KPI) in SSAS 2005.
• Developed Sub Reports, Matrix Reports, Charts, and Drill down reports, using SQL Server Reporting Services (SSRS).
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Created reports and Dash boards using Microsoft Performance Point service.
• Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and sent the reports via email.
• Experience in using Star Team for source control. Documented all work, so user can easily understand the flow of process.

Environment: MS SQL Server 2008, SQL server Reporting Services, SQL Server Integration Services (SSIS), VSS, Microsoft Visual Studio, SQL Server Management Studio, MS Excel, T-SQL, Erwin7.2, SQL Server Profiler, Database Engine Tuning Advisor.