SUMMARY

• Around 9+ years of IT experience in SQL Server/Business Intelligence developer in database designing, modeling, and reporting using SQL Server, SSIS, SSRS and SSAS.
• Extensive experience in using Microsoft BI studio products like SSIS, SSAS, SSRS for implementation of ETL methodology in data extraction, transformation, and loading.
• Expert in Data Warehouse development starting from inception to implementation and ongoing support, strong understanding of BI application design and development principles.
• Highly experienced in whole cycle of DTS/SQL server integration services Packages (Developing, Deploying, Scheduling, Troubleshooting, and monitoring) for performing Data transfers and ETL Purposes across different servers.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Scheduling and Monitoring ETL Processes using DTS Exec utilities and batch files. Expertise in generating reports using SQL Server Reporting Services, Crystal Reports, and MS Excel spreadsheets and Power Pivot.
• Experience in Power BI, creating interactive visualizations, dashboards, reports based on business requirements.
• Good experience in creating pivot tables and charts in Excel using data sources (SQL Server, SSAS cubes, and Access) and power pivot.
• Excellent experience working with building OLTP/OLAP databases through conceptual Entity Relationship Models and ERWIN.
• Experienced in Enterprise Data Modeling with a solid understanding of the concepts like Star - Schema and Snowflakes Modeling.
• Involved in relational & dimensional data modeling and Forward/Reverse Engineering Data Models.
• Experience in working with backend developers, Quality Assurance and administrators in Waterfall, Scrum/Agile methodologies.

TECHNICAL SKILLS

RDBMS: SQL Server, Oracle 11g/12c, Postgres SQL, MS Access

DATABASE TOOLS: SSMS, Enterprise Manager, Profiler, Query Analyzer, Reporting Server

ETL TOOLS: SSIS, SSAS, BIDS, DTS, Azure Data factory (ADF), Power BI desktop, Visual Studio.

DATA MODELLING: VISIO, ERWIN, SAP Power Designer

REPORTING TOOLS: SSRS, POWER BI DESKTOP, TABLEAU, SAS VA, CRYSTAL REPORTS

LANGUAGES/SCRIPTING: T-SQL, PL/SQL, DAX, HTML, XML, JavaScript, Python, C#, VB.NET, PowerShell

PROJECT MANAGEMENT: TFS, GIT HUB, AZURE DEVOPS, JIRA, SHARE POINT, SFTP

OPERATING SYSTEMS: Windows XP/ 2003/2007/2010, Windows Server 2008 R2, Windows Server

PROFESSIONAL EXPERIENCE

Sr. Data Analyst/ETL Developer

Confidential

Responsibilities:

• Business Requirements gathering and translating into accurate specifications and estimates for ETL workflow components.
• Migrated data from legacy system to SQL server databases using SSIS and stored procedure to overcome the transformation constraints.
• Designed and developed various abstract classes, interfaces, classes to construct the business logic using C#, Entity Framework and SQL.
• CreatedSQL Server configurations for SSIS packages. UsedSSIS transformations to implement the Slowly Changing Transformation (SCD TYPE-1/SCD TYPE-2), Change Data Capture (CDC) to maintain Historical Data in the Data warehouse.
• Implemented Copy activity, CustomAzure Data FactoryPipeline Activities for On-cloud ETL processing
• Created SSIS packages to load data from Flat Files, Excel and XML Files to Data warehouse and Report-Data mart using Lookup, Derived Columns, Sort, Aggregate, and Pivot Transformation.
• Maintained the log and audit information in SQL tables, experience in providing logging, error handling by using event handlers for SSIS packages
• Created complex stored procedures, triggers, functions, indexes, tables, views and other T-SQL code and SQL join for applications.
• Created and executed SQL statements in both SQL production and development environments.
• Experience in working with Data Marts, Operational Data Store (ODS), MDM, OLAP, Dimensional Data Modeling, Star Schema, Snowflake schema for FACT and dimensions using SSAS.
• Developed test cases based on test matrix including test data preparation for Data Completeness, Data Transformations, Data quality, Performance and scalability.
• Explored data in a variety of ways and across multiple visualizations using POWER BI. Built cross tables, maps, scatter plots, pie, bar and density charts.
• Provided report support for Sales and Service Planning Department using Reporting Services (SSRS) and other Microsoft formats for daily and weekly. Created and deployed new SSRS reports.
• Created Ad-hoc reports, data driven subscription reports by using report Builder in SSRS.
• Store all source code in the Team Foundation Server (TFS) and update development status in the TFS timely.
• Maintained the SSIS projects and users accessing the Catalog and SSISDB. Scheduled and monitored the SQL Agent jobs to run these packages periodically.
• Worked in Agile methodology consisting of daily stand up sessions, four week sprints, monthly release planning/scheduling.

BI Developer

Confidential

Responsibilities:

• Created different Dashboards and charts using Power BI that were published the business stake holders for analysis and customization using filters and actions.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Created/Updated database objects like tables, views, stored procedures, function, packages.
• Experience in creating Power pivots, Power views and SSRS reports using tabular model (DAX), Cubes (MDX) and SQL queries.
• Created Data Source and Dataset using OLAP Cube to create Tabular and Matrix reports as per user requirements.
• Responsible for creating and changing the data visualizations inPower BIreports and Dashboards on client requests.
• Provided Continuous Maintenance and Development of bug fixes on power BI Reports.
• Developed Cubes using SQL Analysis Services (SSAS) and Experience in Developing and extending OLAP Cubes, Dimensions, and data source view.
• Worked on POC to migrate existing on-premise BI platform to Azure Cloud.
• Worked on Azure cloud in spinning of new resources under resource group.
• Worked on Data factory in order to load the data from on premise to Azure Data Lake.
• Configured Integration Runtime (IR) in order to move the data from on premise to cloud.
• Worked on power shell scripts to automate the creation of resources and resource group.
• Experience working with Azure Data warehouse, created TSQL code to use polybase external tables in order to load data from ADL to ADW.
• Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the insurance data from various source systems feeds using SSIS.
• Created different views using SSRS that were published the business stake holders for analysis and customization using filters and actions.

SSIS Developer

Confidential

Responsibilities:

• Translated business requirements into technical designs to map and load data for source systems to data warehouses, downstream applications, and trading partners.
• Developed system standards, architecture, scenarios, detailed screen specifications and documented High level- Conceptual, logical and physical data models.
• Designed and developed SSIS (ETL) packages to validate, extract, transform and load data from OLTP system to the Data warehouse and Report-Data mart.
• Involved in Performance Tuning of SQL tables, Views, Stored procedures using SQL Profiler and Tuning Advisor improving performance and scalability.
• Developed different type of reports including Sales Report, Client Contact Report, Accounting Statement Report, Employee/benefits census report, Benefits statements report, Enrollment count summary report, Billing reports and other file transfer reports by using SSRS.
• Involvedin writing expressions inSSRSand Expert in fine tuning the reports. Created many Drills through and Drill Down reports usingSSRS.
• Created Prompts, customized Calculations, Conditions and Filter (Local, Global), Parameters, Groups and sets for various analytical reports and dashboards on Tableau desktop.
• Utilize Tableau to design, develop, enhance and support Tableau visualizations including highly interactive dashboards, scorecards and reports with drill down to detail and analysis pathways to other supporting reports.
• Build and publish customized interactive Tableau reports and dashboards as well as manage extracts and refresh schedules using Tableau Desktop and Tableau Server.
• Generate ad-hoc reports in excel power pivot and shared them using Power BI to decision makers for strategic planning.
• Validated all the user requirements specified for User Acceptance Testingto ensure that the application performs and fulfills at an acceptable level of the Customer expectations.
• Worked in Agile environments participated in daily stand ups and weekly sprint sessions.

SQL Developer

Confidential

Responsibilities:

• Involved in analyzing business requirements that will facilitate the planning and the implementation phase of a data mart.
• Created complex stored procedures to perform Index maintenance, data profiling, metadata search, critical staging procedures for loading data marts and reporting database.
• Worked on the Optimization and restructuring of stored procedures for the application by evaluating indexing and partitioning large tables.
• Optimized the existing Index by analyzing and came up with more efficient plan to use Clustered and Non-Clustered Indexes for significant performance boost.
• Developed data migration strategies and impact analysis for various database systems.
• Created complex SSIS packages to pull data from SQL Server OLTP, Excel and Oracle, and load them to SQL server.
• Involved in data profiling and cleanup process after requirement analysis for the Data Mart, worked extensively on creation automated SQL scripts for data cleansing process faster.
• 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.
• Implemented Master/Child Packages so only the Master Package has to be scheduled which will in turn fire the other packages.
• Worked on Team Foundation Server (TFS) to coordinate with the development team on the deliverables and for Version Control.