SUMMARY

• Around 8 years of development experience in MSBI and overall 3 years of Experience in QlikView .
• Microsoft SQL 461) and QlikView Training Certified (Qlik Tech) Certified.
• Exposure to Energy, Building efficiency, Insurance, Consumer Goods, Technology domain, Banking and Finance, Tele communication
• Primary Skills - T-SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Power BI, QlikView
• Secondary Skills - C#.Net, SSAS, Tableau, Linux,SAS,MongoDB
• Worked on QlikView script development 4 tier architecture along with QMC strong knowledge for creating parents & child relationship of task and their schedule.
• End to end experience in designing and deploying dashboard using Tableau & QlikView.
• Hands on Experience in ETL Development using SSIS. worked closely with different clients in the design and implementation process for developing, deploying, managing, archiving and extracting data for SSRS report.
• SSIS Package deployment and management using SQL Agent and BCS (Batch Control System)
• Active Contribution - Technical Specification, Impact Analysis in the pre-development stage of projects
• Active Involvement - SDLC and Agile(Sprint) phases such as Creating user story, Analysis, Documentation, Development, Unit Testing, and Deployment
• Hands-On experience in Production Support Troubleshooting issues, Resolving Trouble Tickets, Monitoring Loads, Enhancements, Change Requests and other support activities.
• Proficient in designing ETL solutions and data flow for building the data warehouse. Well versed in providing strategy related to data migration, data quality and data consolidation
• Good command over business communication and exposure of handling projects for clients located in North America and Europe(Denmark).
• Excellent communication, presentation, management and inter personal skills

TECHNICAL SKILLS

Database: MS SQL Server 2008R2/ 2012/2014, Oracle, Teradata, Mongo DB

ETL Tools: SSIS 2008R2, 2012,2014, 2016 QlikView, SAS

Reporting Tools: SSRS 2008R2, 2012,2014.2016, Tablue

Source Code Management: Visual Source Online (VSO), TFS, Rally, ServiceNow

Scheduling Tools: SQL Server Agent, BCS (Batch Control System), Cron daemon (Python), QMC,Autosys

Dashboards: Tableau 10.20, QlikView 11.2, Power BI

PROFESSIONAL EXPERIENCE

Confidential, Hartford, CT

ETL/BI Consultant and onsite coordinator

Responsibilities:

• Participate in regular Technical Reviews, Defect review and walkthrough meetings with business stakeholders throughout the project life cycle to gather requirement for product using by 600+ user and implementation.
• Currently working as an Onshore lead and responsible for end to end deliverables of Insurance BI Product. Design ETL solutions, Dashboard, Reports and data flow for building the data warehouse using SSIS, QlikView.
• Implement SCD, incremental load, Section Access and more transformation as per requirement of QlikView Dashboard.
• Transforming Requirements in to Design & Development. Various QlikView Dashboard, Power BI, SSRS Report Development for Business Performance Analytics and Northland Insurance report.
• Implement strategy and provide POC related to existing system SAS, Teradata, Excel, MongoDB to migrate & convert in to SQL, SSIS, QlikView, SSRS & Power Bi Dashboard that enhance availability of data by 80%.
• Involve in huge data migration with lots of business logic from various sources in SQL server using SSIS.
• Create Task & Schedule QlikView job through QMC.
• Created QlikView/power BI Self Service scorecards, dashboards using Bar Chart.
• Pie Chart. Combo Chart. Scatter Chart. Line Chart.
• Radar Chart. Grid Chart. Gauge Chart and calendar map .

Tools: QlikView, Microsoft BI Tools (SSIS, SSRS), SQL Server 2008/12/14/16, Teradata, SAS, Mongo DB

Confidential

MSBI Consultant

Responsibilities:

• Assess the current system and provide better solution to improve existing SSIS job and QlikView dashboard performance.
• Architected, Designed, developed, tested and maintained SSIS packages and SSRS Reports
• Provided and Implemented many strategies to improve DWH system utilizing traditional BI standard and best practices of Microsoft & QlikView/Tableau tools which drastically improved the performance by 60%.
• Discuss and Consolidate Requirements from Business Analysts.
• Implement SCD, incremental load and more transformation as per requirement and job converted from Python to Sql server Agent.
• Transforming Requirements in to Design & Development.
• Various SSIS packages, SSRS Report Development for regulatory and operational reports.
• Create logging for Error and improve the performance of packages.
• Automated Email notification for creating service ticket in case of SSIS job failure.
• Implement SCD, incremental load and transformation, huge data migration on heterogeneous environment using SSIS as per business requirement and job converted from Python to SQL server Agent.
• Created PowerBI scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps using show me functionality.

Tools: Microsoft BI Tools (SSIS, SSRS &SSAS), SQL Server 2008/12/14, Power BI, python

Confidential

MSBI and QlikView Developer

Responsibilities:

• Discuss and Consolidate Requirements from Business Analysts.
• Implement SCD, incremental load and more transformation as per requirement using task factory third party tool.
• Create logging for Error and improve the performance of packages.
• Participated in regular Technical Reviews, Defect review and walkthrough meetings with important project & business stakeholders throughout the project life cycle.
• Transforming Requirements in to Design & Development. Various SSIS packages, SSRS Report Development for regulatory and operational reports.
• Converted reports from SSRS to dashboard.
• Power BI and QlikView

Tools: Microsoft BI Tools (SSIS &SSRS), SQL Server 2008/12/14, QlikView

Confidential

MSBI Developer

Responsibilities:

• Understanding requirements from Business Analysts.
• Analyze requirements, designing and developing project.
• Experience in creating and implementing interactive charts, graphs, and other user interface elements.
• Create logging for Error and improve the performance of packages.
• Worked on Raw data sent by Heterogeneous environment as per Confidential data from different warehouse across the globe.
• Involved in designing and deployment of reports for the front end - users requests using web interface and SSRS.

Tools: SSIS, SSRS, SSAS, MYSQL, ORACLE, MS Excel

Confidential

MSBI developer

Responsibilities:

• Understanding requirements from Business Analysts.
• Analyze Requirements & provide Estimates.
• Designing and Developing Projects
• The packages created using a variety of transformations like Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion.
• Optimize SSIS Packages, SSRS Report Queries for performance
• Created Data extracts for better performance and accessing data offline.
• Implementation of incremental data extracts updated on timely basis as database updates, Refreshing extracts, optimization and tuning applications for maximum memory management, scheduling.

Confidential

MSBI & SQL Developer

Responsibilities:

• Involved into the Impact Analysis process and develop the BRD.
• Developed SSIS Packages using various file format text, CSV, XML
• Performed a key Onshore/Offshore Team coordinator role for the KC Support position, engaged into the support team weekly status meeting to share the reports and receive updates on new ticket/change request activity.
• Created stored procedures, views, triggers for providing required information to user for some specific page.

Tools: SQL SERVER 2008 R2/2012, MSBI Tools, MS Project Server, Visual Studio 2010, LINUX, Service Now