SUMMARY

• Expert in Developing end to end Data Analytics / BI / Reporting solution using Industry Leading latest software tools like QlikView / Tableau / Power BI / MS Access /Crystal Reports / BO / SSRS / MS SQL Server, Lead Developer and Data Analyst with over 12 + years of experience in the IT environment working on large - scale enterprise projects involving complex business case functions, web integration, and data management.
• Expert in writing specifications and gathering requirements directly from the business end users.
• Experienced Crystal Reports Developer and Proficiency in using Crystal decision, Crystal Management Console, Crystal Configuration Manager, Crystal Repository, Crystal Migration Wizard and Crystal Publishing Wizard for publishing reports on the Internet.
• Expert in MS SQL Server suite of products like SSRS, SSAS and SSIS of MS SQL Server 2005.
• Strong expertise in handling parameterized reports in SQL Server Reporting Services.
• Expert in creating DTS/ SSIS packages for extracting data from various databases.
• Proficient in using global variables, expressions and functions for creating reports.
• Good SQL Server administration skills include creating Databases, Tables, indexes and clusters.
• Experienced in design and implementation of SQL Server 2000/2005.
• Vast experience in creating multi level Cascading prompt for both static and dynamic parameters.
• Developed Crystal Reports as per the client needs and maintain documentation of reports for future references.
• Proficient in data profiling, data modelling, creating complex SQL script, triggers, cursors, tables, views and other SQL joins and statements.
• Involved in all phases of software development life cycle from design, test and implementation.
• Understanding SQL Server tuning methodology provided by Microsoft and implementing for better performance.
• Detail oriented and resourceful in the completion of projects with an ability to multitask and meet strict deadlines.
• Excellent interpersonal skills, self-confident and poised in interactions with individuals at all levels readily developing rapport with clients and colleagues.

TECHNICAL SKILLS

• QlikView 11.2
• Tableau 9
• Power View 2013
• Power Query
• Power Pivot
• Business Objects / Crystal Reports 8.5/9/10/ XI Crystal Reports 2008
• Crystal Enterprise
• Actuate 8.0
• BOE XI webi/ DeskI
• BO Celsius
• Desktop Analytics
• Cognos
• Office 2000
• Office XP
• Erwin
• Oracle 8i/9i/10 g/11 g
• Oracle BI publisher
• SQL Server 6.5/7/2000/2005/2008
• BO Universe
• PostgreSQL
• Sybase
• MS SQL Reporting Services 2005
• SSAS
• SSIS
• TOAD
• T-SQL
• COM
• ODBC
• OLE DB
• ADO
• RDO
• DTS
• Sybase IQ 11.2
• IBM DB2 8.2
• MS BI Suite 2008
• MS Data Tool
• ActiveX
• PeopleSoft
• Lawson S3
• KRONOS Workforce Central suite
• MS-Windows
• UNIX
• Microsoft Services
• MS Access- 97/2000/2003/2010
• MS SharePoint
• Perl
• Shell Scripting
• HTML
• XML
• Java
• Power shell
• VB 6.0
• ASP.NET
• SDLC
• Waterfall /Scrum /Agile Methodology
• SDK.

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Data Analytics / BI / DW Lead Developer Analyst

Responsibilities:

• Meeting with the business users to collect the Business requirements.
• Designed the facts and dimensions data model in QlikView from multiple complex relational database sources designs.
• Developed conceptualization of reporting application with business and IT. Created multiple templates with different visualization. There were multiple reports like Dashboard by Business Unit, Dashboard by location showing comparison of KPIs with multiple periods on the same page.
• Developed QVD loader using Incremental load functionality of QV as this project involved multiple source data sets with monthly load.
• Created UI layer with different parameters, charts like bar graph, straight table showing current and previous years, KPI using set analysis, pivot table, pie chart for each dimension value, Bar chart showing totals using visualization tools like QlikView / Tableau.
• Extensively worked on Qlikview functions such as dual match, interval match, pick, peek, string functions, apply map, date and time functions, class functions, string functions, wild match... etc. at script level.
• Created QVD's and QVW's. Binary load has been implemented creating separate Qlikview document.
• Developed Power Pivot Reports in Excel 2013 by publishing them to SharePoint for providing ad-hoc reports according to client need.
• Developed Charts and other visualization to create dashboards using Power View in Excel 2013 by using power query to merge multiple data sources using advanced SQL queries with multi-table joins, group functions, subqueries, set operations, Calculated fields using DAX expression and functions.
• Designed and developed data model, Report dashboard using MS Power BI 2013 for self Service BI connected to SSAS Tabular Semantic data model using MS data tools and other data sources.
• Designed and created tables using complex script in MS Access DB for the user desktop access.
• Created Database objects like Tables, Stored Procedures, Views, Indexes, user defined data types and functions in Sybase IQ 11.2.
• Designed and created tables, indexes and complex ETL script using data profiling techniques for integrating data from multiple data sources into Data Warehouse built in Sybase IQ.
• Designed and Developed and successfully created user interface using Power pivot to browse the aggregated data for analysis.
• Support / Managing and debugging of existing QlikView reports, performance tuning, and optimization of Reports.
• Created and updated Project Design Specification documents.
• Conducted Unit Testing and working with Business users to validate actual results to expected results (UAT) and ensure appropriate user sign-offs are recd. before rolling to production.
• Involved in weekly meeting with Project Manager and business users to provide update about the status of the Project development.

Confidential, Northfield, IL

QlikView / DW / SSRS / SQL Team Lead

Responsibilities:

• Meeting with the business users to collect the Business requirements.
• Design and developed Data Warehouse / BI solution for predictive analysis from the present OLTP system.
• Analyzing the report requirement and conducting the feasibility studies with the available resources.
• Mentoring, coordinating and managing the offshore team development to meet the project goal.
• Enhancement of the existing reports and creating new standard reports Using SSRS 2008 R2.
• Migrating existing reports from SSRS 2005 to SSRS 2008 R2.
• Creating complex T SQL queries and store procedure in MS SQL Server 2008.
• Created SSIS package for uploading data to MS SQL server 2008 R2 using SSIS packages.
• Created charts like bar graph, straight table showing current and previous years, KPI using set analysis, pivot table, pie chart for each dimension value, Bar chart showing totals using visualization tools like QlikView.
• Extensively worked on Qlikview functions such as dual match, interval match, pick, peek, string functions, apply map, date and time functions, class functions, string functions, wild match... etc. at script level.
• Loaded data into QVD's thru which QVW's will connected and access data in the desktop application.
• Designed and Developed OLAP cubes using SSAS and successfully created user interface using Power pivot to browse the aggregated data for analysis.
• Configured and Scheduled automated reports using SSRS report server including data driven subscription.
• Support / Managing and debugging of existing reports, performance tuning, and optimization of Reports.
• Developing various new Parameterized reports, Drill down reports, Sub-Reports, Cross Tab Reports and Charts to meet the business user requirements.
• Creating and updating Report Design Specification documents, Report Design standards and Report Naming convention standards and design check list.
• Conducting Unit Testing and working with Business users to validate actual results to expected results (UAT) and ensuring that all necessary sign-offs have been achieved.
• Involved in weekly meeting with CIO and other top management and business users to provide update about the status of the Project development.

Confidential, Chicago IL

Crystal reports / SSRS / PL SQL Developer/ Analyst

Responsibilities:

• Created numbers of new reports using Lawson ERP DB using GL, AP, AR, HR, PR, BENEFITS, and AM etc. modules using Crystal reports XI R2.
• Created numbers of new reports utilizing PAS patient and Insurance data using SSRS 2008 R2.
• Migrated reports from Hyperion Essbase reports to Crystal Report XI R2.
• Analyzed the existing and discussed with business users to gather the exact report requirement.
• Created store procedures, Indexes and complex SQL queries.
• Configured and Scheduled automated reports using SSRS report server / BO Info view including data driven subscription /Report Bursting.
• Managed all debugging, performance tuning, and optimization of Reports.
• Developed Drill down reports, Sub-Reports, Cross Tab Reports and Charts.
• Published reports using BO Info view / LBI / SSRS report server Web application.
• Created Design Documents, Report Design standards and Report Naming convention standards and design check list etc...
• Conducted Unit Testing and Created Test Cases for developed reports for User Acceptance Testing for User Sign-Off.
• Created Release Document for production tickets and coordinated with internal departments for smooth production release and created design specification document for all new reports for future reference.
• Gathered requirement and specification directly from the business user for up gradation of the existing reports and new report requirement.
• Worked with DBA team to troubleshoot and performance tuning.
• Involved in weekly meeting with project manager and business users to give update about the status of the development.

Confidential, McLean, VA

Crystal reports / SQL Developer/ Analyst

Responsibilities:

• Converted numbers of existing ACTUATE reports to Crystal reports.
• Analyzed the existing Actuate reports and DACAR files to gather existing report requirements.
• Wrote stored procedures and complex SQL queries.
• Developed Drill down reports, Sub-Reports, Matrix Reports and Charts.
• Published reports using BO Info view.
• Scheduled automated reports using BO Info view
• Converting the legacy systems data into MS SQL server 2005 using SSIS packages.
• Created Release Document for production tickets for future reference and Created design specification document for all new reports.
• Gathered requirement and specification from the business user for up gradation of the existing reports.
• Worked with development team to troubleshoot and performance tune applications.
• Involved in weekly meeting with project manager and business users to give update about the status of the development.

Confidential, Reston, VA

MS SSRS/ SSIS/ SQL Developer/Analyst

Responsibilities:

• Created complex formulas for generating SQL (SSRS) reports.
• Converted numbers of existing ACTUATE reports to SSRS reports.
• Created stored procedures and functions to give advance features to SSRS.
• Responsible for adding new columns and expressions as per client requirements.
• Converted the legacy systems data into MS SQL server 2005 using DTS/SSIS packages.
• Created Release Document for production tickets for future reference.
• Generated Reports using global variables, expressions and functions.
• Designed customer friendly parameterized reports with drill-down and drill-through options to navigate through reports and report data.
• Designed and Created stylish tabular and matrix reports in SSRS. Wrote stored procedures and functions to create SSRS reports.
• Identified and worked with parameters for parameterized reports in SQL Server Reporting Services (SSRS).
• Created reports using OLAP cubes which is developed using SSAS.
• Created Test Cases for reports for User Acceptance Testing.
• Worked with Report Manager for publishing the report.
• Involved in biweekly meeting with project managers to give update about the project status.