PROFESSIONAL SUMMARY:

• Experience in creating ETL workflows to pull data from multiple sources including SharePoint List, FTP, MySQL, Excel, SQL Server Database, flat files, XML, JSON, SalesForce, etc.
• Experience in implementing metadata driven data profiling, cleansing, and blending to meet reporting requirements and standards using SSIS
• Experience in configuring SSIS Control Flow Tasks including Data Flow Task, Execute SQL Task, Script Task, FTP Task, Send Mail Task, File System Task, Data Profile Task, Execute Process Task, Execute Package Task, Package Parts, etc…
• Experience in using Transformations such as conditional split, union all, lookup, Merge, Merge Join, Data Conversion, Derived Column, OData Source, Row Count, and Multicast
• Experience in developing Master Package to manage multiple child packages
• Experience in deploying SSIS Projects and Packages to SQL Server Integration Catalog
• Experience in scheduling SSIS packages using SQL Server Agent
• Experience in converting requirements and user stories into Bus Matrix
• Experience in designing dimensional data model (Star Schema and Snowflake) for enterprise data warehousing and Reporting Platform
• Experience in converting dimensional data models into dimension (Dim) and fact tables
• Well - versed in utilizing T-SQL to construct database objects such as Stored Procedures, UDFs, Views, Triggers and Indexes
• Extensive experience in database design, Modeling, Data Analysis and Normalization process
• Extensive experience with SQL Server database automation through job creation and scheduling
• Experience in designing and documenting Conceptual, Logical and Physical data models
• Experience in building various visualizations using Power BI
• Experience building data visualizations in Power BI Desktop and Power BI Service
• Experience in designing dynamic visuals using bookmarks, slicers, custom tooltips in Power BI
• Experience in creating and managing Power BI App workspaces (Classic and Modern) Experience in Publishing and Sharing Power BI reports and Data models to Power BI workspace
• Experience in developing SSRS reports using SQL Server Data Tool (SSDT), Business Intelligence Development Studio (BIDs) and Report Builder 3.0
• Experience in developing paginated Reports with custom page breaks, grouping, and visibility
• Experience in creating drill-down, drill-through, parameterize, cascading, sub, linked reports
• Experience in managing report users based on built-in and Custom Role on SQL Server Report Manager
• Experience with all phases of the SDLC for a data-centric web application
• Experience in Working with Scrum Masters and Product Owners to convert Product requirement into technical specification
• Experience working on Agile projects with Multiple Sprints cycles and Scrum meetings
• Experience in utilizing agile tools (such as Slack and Trello)

TECHNICAL SKILLS:

RDBMS: SQL Server 2008, 2012 and 2016

Database Tools: SSIS, SSRS

Reporting: SQL Server Data Tools (SSDT), Report Builder, Visual Studio, Tableau, Power BI

Languages: T-SQL, VB.NET, C++, Java

MSOffice: Microsoft Office Tools

UNIX: Mac Operating System

Operating Systems: Windows Server 2003, 2008/R2, 2012

Tools: Oracle SQL Developer Data Modeler, Trello, Slack, GitHub

PROFESSIONAL EXPERIENCE:

Confidential

SQL/BI Developer MD

Responsibilities:

• Work with end users, subject matter experts and technical teams to refine the business requirements that must be met for building and maintaining Data Warehouses/Marts.
• Building ETL workflows and applying transformation rules to pull data from multiple data sources system into Data Warehouse and Data Marts
• Ensure data is properly loaded into the Data Warehouse or Data Mart
• Performing ongoing support for various SSIS packages and implementing error-handling solutions, resolving errors, resolving performance issues and failed jobs.
• Deploy and Automate ETL processes using SQL Server Agent Job
• Works with technology partners to ensure source systems technology align with business intelligence and analytics roadmap
• Work closely with Business Analysts and end users to evaluate business requirements and advise on appropriate informative views and dashboards
• Develop Proof of concepts to mock up complex reporting requirements with upcoming technologies on Microsoft Analytics platform
• Design, develop, deploy, monitor, report and improve enterprise process data visualization
• Develop Power BI reports &dashboards, publish reports to Power BI service, & Establish Gateway Refresh
• Optimizing and improving performance of existing SQL Queries and Stored Procedures
• Developing complex and high performing Stored Procedures, SQL queries using various joins, aggregates, system functions, UDFs, views to clean, sort, validate and format data
• Work on Microsoft BI analytics stack (SSIS, SSRS, SSAS, Power BI) and work on investigating new tools, tool capabilities and engage with Business to propose, manage, and implement solutions
• Maintain source-code repository and participate in deployment of code into production using GitHub
• Coordinating with IT team that responds to all system problems perform root cause analysis in order to reduce or eliminate production problems
• Updating and communicating with team and management regarding project status. Documenting changes made on the project for future reference

Confidential, MI

BI Developer

Responsibilities:

• Developed & maintained complex SQL stored procedures and functions
• Worked with Type 1 and 3 dimensions, Fact Tables, Star Schema design, Operational Data Store (ODS), leveling and other Data Warehouse concepts
• Developed Complex SSIS Packages to load data into Staging, ODS, & Data Warehouse systems
• Developed SSIS packages using Lookup Transformations, Merge Joins, Union all Fuzzy Look Ups, & Derived Columns with Multiple Data Flow tasks
• Automated SSIS Packages using SQL Server Agent Jobs
• Configured various event driven e-mail notification process in SSIS packages
• Created audit database to handle SSIS error output and validate data
• Deployed SSRS report to Report Server Web Service
• Configured report server & report manager for SSRS report deployment and management
• Designed reports with single /multi valued, dependent & Cascading Parameters
• Created Report Email Subscription using Data Driven & Time Triggered Report Subscriptions
• Wrote efficient stored procedures for optimal performance
• Developed, executed, documented, & maintained appropriate BI documents
• Worked with end users & developers to determine requirements

Confidential, NY

SQL Server Developer

Responsibilities:

• Actively contribute to SDLC process of requirements gathering, design, development and quality testing, with a focus on relational database technologies
• Involved in the creation of confidential Schema dimensional database model for data warehouse development
• Created complex Stored Procedures, triggers, cursors, tables, views and other SQL joins and statements for application support, reporting and Ad Hoc data Request
• Utilized SQL and other database access tools and methods to address business or technical requirements
• Proactively maintained and improved system performance and reliability via system level and applications level performance tuning.
• Identified query performance bottlenecks to fine-tune and optimize SQL Queries/Views
• Designed, created and regular tuned of physical database objects (tables, views, indexes) in MS SQL Server
• Designed, implemented and supported ETL solutions across multiple platforms and data sources (Database tables/views and external files) using custom code and ETL tools and frameworks
• Designed and created various SSIS packages that perform ETL tasks from multiple sources
• Imported data from various data sources/business systems including SharePoint, MySQL, flat files, MS Excel, MS Access, Oracle, and other sources to SQL Server using SSIS features such as multitasking, conditional split, union, union all, merge, lookup, fuzzy lookup, and data conversion
• Deployed SSIS packages and scheduled job in SQL Server Agent for package automation
• Involved in troubleshooting mapping issues and developing error-handling procedures
• Created and maintained SSIS packages to perform nightly refresh of data
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS
• Documented MSSQL database structures and functionalities and developed template for mapping specification