PROFESSIONAL SUMMARY:

• Having 12+ Years of experience in the areas of analysis, design and Confidential of SQL Server Databases & Business Intelligence solutions using Microsoft BI suite (SSAS, SSIS, SSRS & PowerBI) tools in Data warehousing applications.
• Experience in Data Extraction, Transform & Load (ETL) Confidential using SQL Server Integration Services (SSIS 2016/2012/2008 ).
• Experience in creating Stored Procedures, Functions, views, CTE's to assist in data manipulation and data consistency.
• Excellent experience in designing and Confidential of SQL Server databases ( MS SQL Server 2016/2012/2008 ).
• Extensive programming, installing, configuring, managing, monitoring and troubleshooting experience in MS SQL Server 2016/2012/2008 and Business Intelligence in SQL Server Reporting Services, SQL Server Integration Services and SQL Server Analysis Services.
• Experience in Business Requirements Gathering, Data Modelling and setting - up ETL architecture.
• Excellent experience in data modelling principles/methods including conceptual, logical & physical Data Models.
• Ability to translate a logical model into a physical model, adding appropriate physical objects needed to create the database.
• Experience maintaining a model repository (Model check-in and check-out).
• Experience in setting-up the ER Studio Repository & Enterprise team server to view the ER objects on web portal.
• Experience in synchronize models (by using compare & merge) to ensure that database structures match models.
• Experience in reverse engineering of physical data models from databases.
• Experienced in Data Cleansing, Data Quality, Data Profiling and Data Validation in ETL.
• Excellent experience in writing DAX formulas.
• Thorough Knowledge on Data Warehouse concepts like Star Schema, Snow Flake, Dimension and Fact Tables.
• Experience with interacting source system SME's, customers, and other team members to determine data extraction, transformation, analytics, and reporting requirements.
• Experience in Azure SQL Databases to pull data into Data warehouse.
• Experience in creating Jobs, Alerts, SQL Mail Agent, Database Mail and Scheduled SSIS Packages
• Experience in working on Agile methodology.
• Highly motivated and a conceptually strong individual with exceptional analytical and design skills.

TECHNICAL SKILLS:

Database: SQL SERVER 2016/2012 and 2008 R2, Oracle 11g/12c

BI Tools: Microsoft SQL Server data tools, SQL server BID Studio, SharePoint Server 2010, Performance Point Server 2010, MS SQL Server Business Intelligence Suite (SSAS, SSIS and SSRS), DQS(Data Quality Services) Client.

ETL Tools: SQL Server Integration Services (SSIS), Oracle Data Integrator (ODI)

Modelling Tools: ER/Studio Data Architect 2016 & Erwin

Visualization / Reporting Tools: PowerBI, SQL Server Reporting Services (SSRS), Report Builder, Report Designer, SAP BO crystal reports

Operating Systems: Windows server 2012/2008/2003

Programming Languages: C#, T-SQL, PL/SQL, MDX, DAX

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

Sr. Data Warehouse \ SQL ETL Lead Developer

Responsibilities:

• Responsible for design, Confidential, testing and support of Microsoft SQL Server Business Intelligence platform and reporting solutions.
• Design SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different application source databases.
• Manage ETL data load, testing and quality assurance, troubleshooting issues, ETL/Query performance tuning and routine production ETL process support.
• Translate data structures within the enterprise and establish appropriate data models for analysis, dimensions and tabular model OLAP cubes.
• Responsible for Confidential of SSAS tabular model cubes as per the business requirements.
• Responsible for changing and maintaining the Warehouse, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Created Data Warehouse schema to deploy fact and dimension table and defined Referenced relationships with the measure groups.
• Extracting data from various sources like SQL Server, Oracle, .CSV, Excel and Operational Data Store (ODS).
• Responsible to capture ETL package logs & Error handling for ETL loads.
• Responsible to write C# code to check ETL source files exists or not in ETL source folder by using SSIS Script task.
• Created custom code inside script task to check ETL load status of other process.
• Troubleshoot data issues, validate result sets, recommend and implement process improvements.
• Responsible to archive ETL source files by calling batch file in Execute Process task.
• Used Send Mail Task to notify the user group if we have any error records in ETL loads. This notification includes respective error file names and number of records.
• Wrote custom code in Script component to find-out the error column names in dataflow task.
• Created source to target mappings to bring the data from OLTP applications source systems to the warehouse.
• Design a STAR schema for the data marts and Plan data marts involving shared dimensions (Conformed).
• Translate business requirements into full scale developments and prepare technical design documents.
• Performed data profiling for better understanding of joins in ER models.
• Write DAX formulas to create calculated measures while developing Tabular model cube.
• Create and maintain SQL agent Jobs, Alerts, Database Mail and Scheduled SSIS Packages.
• Schedule the packages to keep extracting the data from OLTP at specific time intervals.

Environment: Microsoft SQL Server 2016 Integration Services, Analysis services, Microsoft Power BI, ER-Studio, Microsoft Windows Server 2012, Microsoft SQL Server 2016 and Oracle 12c.

Confidential, Long Island City, NY

Sr. Data Modeler & ETL Developer

Responsibilities:

• Designed ER diagrams (Physical and Logical) and map the data into database objects and identified the Facts and Dimensions from the business requirements.
• Responsible to create data models and building OLAP cubes, aggregating data from multiple data sources.
• Responsible to create Source-to-Target mapping document for ETL loads.
• Design SSIS Packages to extract, transfer, load (ETL) data into SQL Server from different operational data sources.
• Extracted data from Azure SQL Databases to Data warehouse.
• Manage ETL data load, testing and quality assurance, troubleshooting issues, ETL/Query performance tuning and routine production ETL process support.
• Design a STAR schema for the data marts and identify confirmed dimensions.
• Performed data profiling for better understanding of cordiality (one-to-one, one-to-many & many-to-many) in ER models.
• Extracted data from web API and loaded into MongoDB by using script component.
• Create and maintain SQL agent Jobs, Alerts, Database Mail and Scheduled SSIS Packages.
• Transform Logical Data Model to Physical Data Model ensuring the Primary Key and Foreign key relationships, Consistency of definitions of Data Attributes and Primary Index considerations.
• Create Data Warehouse schema to deploy facts and dimensions tables and defined referenced relationships with the measure groups.
• Designing current database by adding tables, relationships, creating stored procedures, views and functions.
• Created various types of reports such as drill down & drill through reports and Sub reports using SQL Server Reporting Services (SSRS) on Relational databases.
• Schedule the packages to keep extracting the data from OLTP at specific time intervals.
• Created various Power BI Reports that includes Charts, Filters, Scorecards, Drilldown and Drill-Through, Cascade, Parameterized reports.
• Mentored business power users to create reports/dashboards using Power BI desktop.
• Perform preventive maintenance activities like causal analysis, restructuring program codes, data problems resolution and performance tuning.

Environment: Microsoft SQL Server 2016 Integration Services, Analysis services and Reporting Services, Microsoft Power BI, Microsoft Windows Server 2012, Microsoft SQL Server 2016 and ER-Studio.

Confidential, Confidential, New York

Sr. Microsoft BI Developer

Responsibilities:

• Design SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.
• Design Dimensional model by analyzing all the requirements from the clients for the different source systems.
• Designed a STAR/Snow Flake schema for the data marts and identify the confirmed dimensions.
• Designed Physical and Logical Models and mapping the data into database objects and identified the Facts and Dimensions from the business requirements.
• Responsible to create Source-to-Target mapping document for ETL loads.
• Responsible in Data Cleansing, Data Quality, Data Profiling and Data Validation in ETL
• Extract data from various sources like SQL Server, Oracle, .CSV and XML files.
• Imported .dat files from various business units through SSIS FTP task.
• Involved in creation/review of functional requirement specifications and supporting documents for business systems.
• Design SSAS Cubes and building attribute relationships for optimal MDX query performance of Hierarchies and Fact Dimensions.
• Finding the gaps between different modules of the system and discussing the gaps with the functional personal.

Environment: Microsoft SQL Server 2012 Integration Services, Analysis services and Reporting Services, Performance point server, Team Foundation server, ER/Studio Data Architect, ER/Studio Repository and Team Server, Tableau Desktop 8.0, Microsoft Windows Server 2012, Microsoft SQL Server 2012.

Confidential, New York

Sr. SQL/ETL Developer

Responsibilities:

• Gather the requirements from the business users for the different source systems.
• Responsible for ETL Design and come up with Dimensional model after analyzing all the systems together.
• Estimate the effort required to develop the components.
• Extracted data from various sources like SQL Server 2008, Oracle, .CSV, Excel and Text file from Client servers and through FTP.
• Designed current database by adding tables, relationships, creating stored procedures, views.
• Created and deployed cubes using star and snowflake schema. Performed and worked with dimensions, measures, generating KPI, MDX queries.
• Created SSIS Packages for performing ETL operations from the external source.
• Generated canned Reports/Dashboards for Business users by using SQL Server Reporting Services.
• Performance tuning of SQL queries and stored procedures
• Proficiency and expertise in SQL Server database Backup/Recovery and OLAP cube replication.
• Worked closely with business to enhance functionality of Business Intelligence platform to implement various client requirements.

Environment: Microsoft SQL Server 2012, Microsoft SQL Server 2012 Reporting Services, Integration Services and Analysis services, Performance Point Server 2010, Team Foundation server, Microsoft Windows Server 2008 R2.

Confidential, New York, NY

Senior Business Intelligence developer

Responsibilities:

• Implementation and delivery of MSBI platform solutions to develop and deploy ETL, analytical, reporting on SQL Server 2008 using SSAS, SSIS, SSRS.
• Used transformations like Look Up, Derive Column, Conditional Split, Aggregate, Row Count, and sort and execute SQL Task to load data into Data Warehouse.
• Responsible for ETL statistics Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Experienced in SDLC life cycle for Design, Confidential and Staging phases of the projects with support of Data-Flow and Process Models.
• Maintained log information in Text file to tracking Errors and recording package execution status. Created Configurations, Checkpoints and Breakpoints.
• Understanding OLAP process for changing and maintaining the Warehouse, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Created Data Warehouse schema to deploy fact and dimension table and defined Referenced relationships with the measure groups and fact tables.
• Understood the existing ETL and relational database framework and Scheduled Packages using SQL Server Agent Jobs.
• Perform Preventive maintenance activities like causal analysis, restructuring program codes, data problems resolution and performance tuning.
• Store all source code in the Team Foundation Server (TFS) and update Confidential status in the TFS timely.

Environment: Microsoft SQL Server 2008, SQL Server 2008 Integration Services, Analysis Services and Reporting services, SQL Server 2008 Management Studio, Performance point services dashboard designer and Team Foundation Server, Microsoft Windows Server 2003/2008 R2.

Confidential, New York, NY

Business Intelligence Developer

Responsibilities:

• Created numerous ad-hoc reports for daily needs regarding Client and Customer financial standings.
• Expert in creating various types of reports such as drill down & drill through reports, Matrix reports, Sub reports and Charts using SQL Server Reporting Services (SSRS) on Relational databases.
• Designed different project solutions to handle wide array of reporting needs from different aspects.
• Perform Preventive maintenance activities like causal analysis, restructuring program codes, data problems resolution and performance tuning.
• Provide clear instructions to promote reports to UAT and PROD.
• Coordinating with a Project Manager and/or a Business Analysts to resolve issues and collect specifications for developing new reports.
• Publish weekly Status reports, Minutes of Meeting and Update Project documents.

Environment: Microsoft SQL Server 2008, SQL Server 2008 Reporting Services, SQL Server BID Studio 2008, SQL Server 2008 Management Studio and SAP BO crystal reports, Microsoft Windows Server 2003.

Confidential, Montvale NJ

Application Developer

Confidential

Responsibilities:

• Provide technical support for production cycles jobs and troubleshoots issues.
• Discuss all production support aspects with application Confidential management.
• Interact with infrastructure, release management, change management, QA, DBA and application teams.
• Provide regular status reports to management on application status and other metrics.
• Coordinate escalation and resolution of major service issues.
• Report promptly to management and business partners regarding critical outages until resolution.
• Understanding the issues, analysing and finding the root cause.
• Responsible to create new reports & provide fix/support to existing SSRS reports.
• Ensured adherence to all the quality norms followed throughout the project like tracking the life-cycle of a ticket/issue/query through Work Allocation Sheet (WAS), preparing analysis documents for all the issues, logging of review comments in the REVIEW LOG, preparing Minutes of Meeting (MOM) after every weekly call.

Environment: ASP.Net, C#.Net and T-SQL, Microsoft SQL Server 2005 , Microsoft Windows Server 2003