SUMMARY

• Data Architect/Engineer with a proven ability to design complex data warehouses/Data Mart/Data Lake that is scalable, flexible and robust. Expertise in architecting & developing high performance data warehouse and business solutions using SQL server, MSBI (SSIS/SSRS/SSAS), Power BI & Azure.
• 15+ yearsin Information Technology with Expertise in Data modeling forData Warehouse/Data Martdevelopment, Data Analysis for Online Transaction Processing (OLTP) and Data Warehousing (OLAP)/Business Intelligence (BI) applications & Azure.
• Exposure in overallSDLCincluding requirementgathering, development, testing, debugging, deployment, documentation, production supportand Extensive experience in Project Management methodologies, Microsoft SQL Server database management.
• Strong Data Modelling experience using ER diagram, Dimensional data modeling, Star Schema modeling, Snow - flake modeling using tools like Visio, Erwin
• Expertize in writing complex stored procedures and dynamic SQL
• Extensive knowledge in Tuning SQL queries and improving teh query performance.
• Involved in various projects related toData Modeling, System/Data Analysis, Design and Development for both OLTP and Data warehousing environments.
• Strong T-SQL experience in creating database objects like Tables, Stored Procedures, DDL/DML Triggers, Views, Indexes, Cursors, Functions and User defined data types.
• Experienced in SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases.
• Expertise in implementing various SSIS features like Event Handling, Precedence Constraints, Break Points, Check Points, and Logging for Complex SSIS Packages and dynamic packages.
• Experience in implementing Transactions, Logging, Error files to SSIS Packages.
• Worked on performing incremental loads while transferring data from OLTP to data warehouse using different data flow and control flow tasks in SSIS.
• Experience in designing Database Models using MS Visio and Erwin.
• Expertise in generating reports using Crystal Reports 8.0, SQL Server Reporting Services (SSRS) and Tableau.
• Experience in developing Custom Reports and Various types of Tabular, Matrix, Ad-hoc, Drill-down, Lists, Charts, Parameterized and Cascading Reports with multiple formatting using SQL Server Reporting Services (SSRS).
• Expertise in developing and extending SSAS cubes, Dimensions, Data source views, SSAS- data mining models including deploying and processing of SSAS objects.
• Experience working in Waterfall and Agile development methodologies.
• Excellent business, analytical, user interaction, presentation skills coupled with excellent written, interpersonal, and verbal communication skills.
• Experience in creating dashboards/reports using Tableau & Power BI
• Developed calculated measures using Data Analysis Expressions (DAX)
• Experienced in Azure SQLDB, ADF, Azure Data Services

TECHNICAL SKILLS

• Microsoft Specific Skills
• SQL Server 2005/2008/2012/2014/2016/2017
• SQL Server Integration Services
• SQL Server Reporting Services
• SQL Server Analysis Services
• Power BI, GIS using google API
• C#.Net, VB.Net, WCF
• AngularJS JIRA DAX
• Azure (Azure Data Factory, Azure Data Bricks, Azure Data lake)
• Tableau C
• Hypertext Markup Language
• Extensible Markup Language
• Java Script, VB Script
• Crystal Reports 8.0
• PowerPivot & Power Views
• MS Visio Erwin

PROFESSIONAL EXPERIENCE:

Confidential

Technologies: SQL Server, SSIS, SSRS and SSAS, Power BI, Tableau, Visio, Azure

BI Architect & Lead developer

Responsibilities:

• Responsible for end-to-end delivery of teh projects and work on deliverables(hands-on)
• Architecting teh Enterprise Data Warehouse for Property and Cyber data.
• Responsible for Staging and data warehouse design
• Designing Star data models using MS-Visio
• Implement Master Data Services and SSIS packages.
• Implementing processes for transactional and incremental loads.
• Architecting teh BI solution for data load.
• Work as SME for Data Warehouse, ETL and BI Solutions.
• Creating SSRS, Power BI, Tableau reports for Premium & Claims data.
• Assisting teh team in analyzing and completing teh project work.
• Interacting with clients and end-users to finalize functional requirements for teh assigned deliverables.
• Improved teh performance of teh SSIS or SQL processes
• Created dashboards using Power BI and DAX (for calculated measures).
• Azure data migration
• Lift and shift of SSIS packages to Azure Data Factory.

Confidential

Technologies: SQL Server, SSIS, SSRS and SSAS, Tableau, Power BI, GIS, .Net, WCF, AngularJS and MS-Visio.

BI Architect & Lead developer

Responsibilities:

• Architecting teh Enterprise Data Warehouse for Axis Pricing Analytics and Exposure Management systems using Star & Snowflake modelling
• Implement Master Data Services, Data Quality Services and SSIS.
• Implementing Change data capture feature for transactional and incremental loads.
• Architecting teh BI solution for Pricing Analytics project.
• Prepared data models and flow diagrams using MS-Visio.
• Work as SME for Data Warehouse, ETL and BI Solutions.
• Creating SSRS, Tableau and Power BI reports.
• Assisting teh team in analyzing and completing teh project work.
• Interacting with clients and end-users to finalize functional requirements for teh assigned deliverables.
• Performed incremental loads while transferring data from OLTP to data warehouse using different data flow and control flow tasks in SSIS.
• Improved Performance of teh database by creating Clustered and non-clustered Indexes and by optimizing teh T-SQL statements using SQL profiler.
• Enforced data Integrity by maintaining and assuring teh accuracy and consistency of data (using Constrains, Foreign Key relations) over its entire life-cycle.
• Involved in maintaining batch log tables and error logging tables to handle errors using event handlers.
• Involved in creating multiple dynamic reports using SSRS and scheduled a report to run weekly, monthly and quarterly based on teh business requirements.
• Designed dashboards that provided interactive reporting environment for market trend, forecast and budgeting using tableau.
• Creating different types of GIS maps using exposure data using Google Maps API
• Created HeatMap, Points, bubble map using google maps API
• Experience in using KML files in Google Maps
• Created WCF services based on user requirements to pull data from other systems and embed in excel
• Designing and implementing web applications using ASP.Net, AngularJS

Confidential

Technologies: SQL Server, SSIS, SSRS, SSAS and Erwin

BI Architect & Lead Developer

Responsibilities:

• Responsible for gathering requirements and project planning.
• Responsible for architecting teh solution and data modeling
• Designed Star & Snowflake data models and flow diagrams using MS-Visio and Erwin.
• Involved in development and enhancements of SSIS Packages performance.
• Involved in change requests in more TEMPthan 100 SSIS Packages.
• Involved in Regression Testing phase of reports.
• Bug Finding and Fixing in Reports
• Reports Development and Modifications.
• Win 8 application development.
• Back end testing for Data Validation Queries in UAT and SIT phase.
• Leading teh support team to support 3000 SSRS reports and more TEMPthan 800 SSIS packages.
• Involved in doing teh Change Requests.
• Responsible for creating subscriptions using data driven subscriptions on weekly and monthly basis.
• Working on new change requests on SSIS, SSRS and SSAS.
• Prepared weekly status reports
• Logging and addressing problems in teh internal ticketing system.
• Designed SSRS reports using SQL queries and MDX

Confidential

Technologies: SQL Server, SSIS, SSRS and SSAS.

Lead Developer

Responsibilities:

• Interact with client and gather requirements.
• Created teh database and stored procedures
• Created SSIS packages and fixed SSIS Packages performance issues in existing packages.
• Involved in change requests in more TEMPthan 100 SSIS Packages.
• Involved in Regression Testing phase of reports.
• Reports Development and Modifications.
• Involved in Support and in solving teh tickets.
• Involved in doing teh Change Requests.
• Improved performance of SSRS reports using cube and MDX queries.

Confidential

Technologies: SQL Server, SSIS

Senior Software Engineer

Responsibilities:

• Involved in Business requirement gathering
• Created SSIS Packages to move teh data from flat flies into sql server database
• Loading teh data to History tables
• Writing teh store procedures to remove teh bad data and for validations
• Log all teh errors generated by SSIS package into windows event log
• Performance tuning for teh exiting store procedures
• Testing teh Package by using file status table
• User accepting testing
• Deploy teh SSIS package into production

Confidential

Technologies: SQL Server, SSIS

Senior Software Engineer

Responsibilities:

• Involved in Business requirement gathering
• Created SSIS Packages to move teh data from flat flies into sql server database
• Loading teh data to History tables
• Writing teh store procedures to remove teh bad data and for validations
• Log all teh errors generated by SSIS package into Sysdtslog90 table
• Performance tuning for teh exiting store procedures
• Testing teh Package by using file status table
• Designing Reports using SSRS.
• User accepting testing
• Deploy teh SSIS package and SSRS Reports into production

Confidential

Technologies: SQL Server, SSIS, SSAS, SSRS

Senior Software Engineer

Responsibilities:

• Involved in Business requirement gathering
• DataWareHouse Database design
• Created SSIS Packages to move teh data from Excel flies into sql server database
• Loading teh data to History tables
• Writing teh store procedures to remove teh bad data and for validations
• Log all teh errors generated by SSIS package into Sysdtslog90 table
• Testing teh Package by using file status table
• Star Schema and Cube Creation using SSAS 2005 based on teh Dimension and Fact tables
• Calculated Measures using MDX.
• Designing Reports using SSRS.
• User accepting testing
• Deploy teh SSIS package and SSRS Reports into production