SUMMARY

• IT professional with extensive experience in analyzing developing and maintaining databases. Adept at database management, analyzing data and working closely with departmental managers to create solutions for the Business Users.
• Strong analytical, organizational, multi - tasking, planning and problem-solving skills. Operate well independently or within a team.
• Eager to increase my knowledge and add to my technical skill set. Looking for a challenge to create solutions for complex problems.
• Experience in database programming in writing T-SQL Stored procedures, Triggers, Constraints (Primary Key, Foreign Key, and Unique) Indexes and Batch Scripts using various DDL and DML commands.
• 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
• Expertise in generating reports using SQL Server Reporting Services, Power BI and MS Excel spreadsheets.
• Expert in generating drill down reports, parameterized reports, linked reports, sub reports and filters, charts in SSRS 2005/2008/2012 .
• Experience in creating Ad-hoc reports, data driven subscription reports by using Report Builder in SSRS.
• Involved in Huge data migrations, transfers using utilities like Data Transformation Services (DTS), and SSIS, Bulk Copy Program (BCP) and Bulk Insert.
• Experience in conversion of packages from legacy systems (DTS to SSIS) and migrating, deploying the packages across Dev/UAT/Prod environments.
• Exposure to Azure Data management - Azure Data Factory and Azure Data Lake.
• Good knowledge of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables.
• Proficiency in creating different types of reports such as Cross-Tab, Drill-down, Top N, Summary, Form, OLAP and Sub reports, and formatting them using both SSRS 2005/2008/2012

TECHNICAL SKILLS

• JIRA, TFS, GIT, Visual Source, SVN, Remedy
• SSIS, SSRS, MS Office, Power BI, Tableau, Denodo
• SQL Server, Oracle, MS Access, Teradata, Sybase
• SQL, PL/SQL, C, C++, HTML, Shell Scripting
• ERWIN, MS Visio, ER Studio
• Microsoft Dynamics AX

PROFESSIONAL EXPERIENCE

Confidential

Database Consultant

Responsibilities:

• Worked with the SMEs and the Business users to gather requirements and managed the mapping documents.
• Worked with the stakeholders to understand the existing issues in the data and addressed them while designing the data warehouse
• Created a central repository to host Asset, Financial and Plant data.
• Collaborated with teams across the organization to understand the reporting requirements and built Power BI Dashboards for Asset, Financial and Plant data.
• Worked on migrating the existing Tableau reports to Power BI
• Created solutions for scraping data from various emails.
• Created ETL solutions to migrate data maintained across various teams and multiple formats.

Environment: SQL Server 2019, SSIS 2016, JIRA, Power BI, Tableau, Azure

Confidential

Database Consultant

Responsibilities:

• Worked with the Enterprise architect to understand the issues on the existing process. Came up with a design to refactor the data loading strategy.
• Presented to management on a weekly basis the progress and issues regarding their data.
• Checked for index fragmentation and dropped the indexes that were overhead and not being used
• Created partition function and scheme for daily partitions.
• Created dynamic compressions for the partitioned tables.
• Proactively monitored the database health through automated scripts for checking the database growth.
• Optimized T-SQL query performance using Execution Plans. Brought down the overall end of day loading time by more than 60%.
• Created Tableau dashboards for the US and UK PNL reporting.
• Designed and Developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop
• Created Tableau reports by connecting to Denodo
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets.
• Restricted data for particular users using row level security and user filters.
• Experience with creation of users, groups, projects, workbooks and the appropriate permission

Environment: SQL Server 2016, Visual Studio 2013, SVN, Tableau, Denodo

Confidential

Database Consultant

Responsibilities:

• Worked with the SMEs and the Business users to gather requirements and managed the mapping documents.
• Created an ETL framework to migrate the legacy data into Microsoft Dynamix AX.
• Loaded data into Microsoft Dynamics AX using the DIXF (Data import export framework) tool.
• Created ETL packages using various control flow tasks such as Data Flow Task, Sequence Containers and Execute SQL Tasks
• Worked on integrating the SSIS packages with Melissa Data to validate and standardize Contacts and Postal Addresses in US and Canada.
• Created, maintained and supported Power BI reports with various visualizations such as Bar Charts, Pie Charts and Tree maps.
• Implemented page level filters, report level filters and visual level filters in Power BI based on the requirement.
• Developed various DAX functions to create different measures and columns in Power BI.
• Published Power BI reports to Power BI service and scheduled auto-data refresh utilizing power bi gateway.
• Worked on a POC on the Azure data factory.
• Moved on premise SQL Server data into Azure Data Lake.
• Created sample reports for the POC in Power BI using the data lake as source.
• Was responsible for the cutover activities during SIT, Mock and Go-Live deployments.
• Effectively migrated over 20 franchise and retail locations into MS Dynamics AX using the SSIS.

Environment: Microsoft Dynamics AX, SQL Server 2014, SSIS 2012, SSRS 2012,Melissa Data, Visual Studio 2013, TFS 2014, Power BI