SUMMARY

• 12+years of IT experience in Business Intelligence, Data visualization, Analytics, Design, Development, Testing, Implementation, Deployment and Maintenance.
• Experience in working in Waterfall andAGILE environment, and ability to work in pressurized environment with tight deadlines
• Very good hands - on experience in development and implementation of Data Warehouse applications.
• Extensive experience in improving the customer experience and reducing the call volume.
• Excellent Data-Analysis skills and Analyzed data sources like enterprise data, click stream data, ordering data, call center data and outbound campaign system to perform Analytics on Ordering, Billing, Tech Support, Authentication, After Call Survey, Digital Offers, Handoff, Repeats and Customer Experience.All these Analysisresulted in $1.2M savings.
• Excellent experience in creating visual and static reports for RTCI and OMNI data.
• Extensive experience in Marketing Campaign, After Call Survey, Digital and Churn(Billing) Analytics using BI tools.
• Experience in creating Databases, Stored procedures, Triggers, user defined functions and Indexes.
• Hands on experience on Performance Tuning and Monitoring.
• Drove key projects IVR dash board and customer journey map, delivered the project with in timeline, which resulted in $4M savings.
• Reduced IVR metrics servers from 30 servers to 20, which halped in reducing operational and maintenance cost by 30%
• Strong experience in SQL Server development, System Analysis, Design, Development and Support of MS SQL Server 2012, 2008, 2005 and 2000.
• Extensive experience in using Microsoft Business Intelligence studio products like SSIS, SSAS, SSRS for implementation of ETL methodology in data extraction, transformation and loading.
• Extensive experience with design and development of Power BI and Tableau visualization solutions.
• Designed and Developed Crystal Reports such as List reports, Parameterized, Mail Label, Cross tab Reports using the base tables, Views, Commands, involving Formulas, Subtotals, Running totals and Sub reports.
• Extensive experience in working closely with stakeholders, vendors and business users.
• Very good hands on experience on Data Security (Data Encryption and Masking). Especially for CPNI and PCI
• Extensive experience on migrating TLS 1.0 to TLS 1.2(Migrated 30 Servers and reduced data vulnerabilities to 0)
• Review project components for adherence to standards(Project Plan, Requirements Documents, Design Documents, Test Plans and Cases and other work products as part of the Software Development Life Cycle)
• Experience in designing conceptual, logical and physical mode using CA Erwin
• Strong understanding in the principles of data wear housing using Fact Tables, Dimension Tables, Star Schema modeling, Snowflake modeling, foreign key concepts and referential integrity.
• Experience in management for large projects from requirement gathering through implementation

TECHNICAL SKILLS

Database: MS-SQL Server 2000, 2005/2008 / 2008 R2/2012/2016, Teradata, My SQL, Hive

Business Intelligence: MSBI, Power BI and Tableau.

ETL Tools: SSIS, Informatica

OLAP Tools: SSAS Pivots

Languages: C#, VB.Net, SQL, PL/SQL, My SQL, Confidential SQL.

Web Technologies: ASP, ASP.NET2.0, XML, HTML

Version Control: Visual Source Safe 6.0, GitHub and TFSs

Scripting: VB Script, Java Script

DB Management Tool: SQL Management Studio

PROFESSIONAL EXPERIENCE

Confidential

Business Intelligence Analyst

Responsibilities:

• Involved in reviewing business requirements and analyzing data sources from Confidential Sheets/Oracle for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Involved in creating and scheduled workflows as per the business requirements.
• Build SQL scripts in PLX using Dremal and F1 SQL Engine
• Involved in the continuous enhancements and fixing of production problems
• Troubleshooting columnio plx query performance.
• Involved in managing users including creation/alteration, grant of system / db roles and permissions on various database objects and object level permission.
• Generated and Published weekly metrics
• Monitored workflows and performing health check on day to day basis
• Created customized reports using various chart types like text tables, bar, pie, Heat maps, line charts, Area charts, scatter plot, dual combinations charts in Tableau.
• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Worked extensively with Filters, Calculations, Parameters, Maps, for preparing dashboards and worksheets
• Working on generating various dashboards in Tableau Server using Confidential Sheets and Oracle
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Created report schedules on Tableau server and Tableau Online
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.

Confidential

Business Intelligence Senior Analyst, Tech Lead, Tech Manager

Responsibilities:

• Involved in reviewing business requirements and analyzing data sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Created customized reports using various chart types like text tables, bar, pie, Heat maps, line charts, Area charts, scatter plot, dual combinations charts in Tableau and Power BI.
• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Worked extensively with Filters, Calculations, Parameters, Maps, for preparing dashboards and worksheets
• Working on generating various dashboards in Tableau Server using different data sources such as Teradata, Oracle, Microsoft SQL Server and Microsoft Excel
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Created report schedules on Tableau server and Tableau Online
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Blended data from multiple databases into one report by selecting primary keys from each database for data validation
• Designing and generating reports in Crystal reports 11.
• Implementation and delivery of MSBI platform solutions to develop and deploy ETL, analytical, reporting and scorecard / dashboards on SQL Server 2012/2008 R2 using SSAS, SSIS, SSRS
• Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and loaded the data into target tables by performing various kinds of transformations using SQL Server Integration Services (SSIS)
• Worked on ETL migration with required transformations like Derived Column, Data Conversions
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
• Involved in the continuous enhancements and fixing of production problems
• Worked on SQL Server Log shipping, Replication and Mirroring.
• Involved in Installation and configuration of SQL Server 2000/2005/2008/2012/2016.
• Written Stored Procedures, Functions, and Views as per DBA requirement.
• Troubleshooting query performance.
• Involved in managing users including creation/alteration, grant of system / db roles and permissions on various database objects and object level permission.
• Involved in creating & scheduling the maintenance plans.
• Installed IBMDB2 Client tool and configured DB2 Databases in SQL Server environment.
• Developed and Automated OLAP reports using Dimensions and Cubes (SSAS).
• Hands on experience in IIS.
• Generated and Published Daily, Weekly, Monthly reports as per the Client's requirement
• Involved in shrinking the Data files and log files if more free space is available.
• Monitored Database server, performing health check, SQL Jobs on day to day basis
• Involved in creating and scheduled SQL jobs as per the business requirements.
• Maintaining and Monitoring Production, Pre-Production and Development database server environment.
• Performed Import/Export tasks using SSIS from different data sources like Flat file, Excel and DB2.
• Configured complete existing project setup in new servers and provided support for few months and upon handed over to Frontier as a part of Verizon landline Spinoff to Frontier.

Confidential

Project Lead

Responsibilities:

• Develop web service component, which synchronizes the data between facility database and corporate database for each transaction made in the facility or corporate level.
• Designing and generating reports in Crystal reports 11.
• Designing and Developing Web pages in ASP.Net and VB.Net as Code behind.
• Developed User Controls for application reusability.
• Written Stored Procedures, Functions and Views for data access.
• Client scripting using Java Script.