SUMMARY

• Over 9+years of Experience in Business Intelligence Development (SSRS, SSIS, SQL and Power BI, Tableau, Vermilion Reporting Suite, BIRT, Interactive Report Designer ).
• Expertise experience in design, development and implementation of BI Solutions (ETL & Reporting & Analysis services)
• Expertise in Universe designing, developing and generating Complex Reports, Adhoc Reports, Dashboard Reports, Business views, List of values along with User Acceptance Test and data accuracy test.
• Expertise in gathering, analyzing and documenting business & functional requirements and developing BRD’s, defining project scope, defining UAT.
• Rich experience in design and developing the reports, rule engine and workflow in the Vermilion Reporting Suite and developed the reports in the form of Table, Matrix and Chart
• Experience in report development using Interactive Report Designer and Created simple and complex reports by customizing the look and feel by using various report models and pass the parameters according to business user’s request.
• Experience in creating reports involving formatting options such as Charting, Mapping, Grouping, Sorting, Alerting, Filter, Drill down, Field highlighting.
• Proficiency in Scheduling, Publishing and Distribution of Business Objects reports using Vermilion Reporting Suite and Interactive Report Designer.
• Analyzed requirements for various Reports, Dashboards and Scorecards and created the same using Tableau desktop server
• Experience in mart development using client inhouse ETL tool ESP 2.0.
• Experience in working with Enterprise Scheduler Autosys.
• Experience in installing/configuring/managing the JBoss Application Server.
• Experience in design/writing SQL & SQL procedures to retrieve the data from different types of data sources.
• Having good experience in Indexes, Joins, Views, Stored procedures, Functions, Constraints.
• Experience acting as a Scrum Master for multiple scrum teams
• Proficient in managing all phases of data warehouse lifecycle, including requirements gathering, analysis, preparing Business specifications, designing technical specifications, use cases, system implementation, designing and developing reports, performance tuning, testing, migrating to production and production support
• Highly skilled and experienced in Agile Development process for diverse requirements
• Extensive experience in system analysis, design, development, testing and implementation of projects in Software Development Life Cycle (SDLC)
• Robust MS Access and Excel skills with PowerPivot, PivotTable, Pivot Chart, Power View, VLookup functions and formulas.

TECHNICAL SKILLS

Programming and Web Languages: Java, XML, SQL, PL/SQL,PHP,HTML,CSS

BI Tools/ETL: Vermilion Reporting Suite (VRS), ESP2.0, MySS Interactive Report Designer, SSIS, SSRS,Power BI, BIRT reporting framework, Tableau 7.0, Tableau Desktop, QlikView

Supporting Tools: Eclipse, Toad, PVCS, SBM,RTC,Dreamweaver, AutoSys

Web/App Server: JBoss4.3, Apache web server, Tomcat5.5

Methodology: Waterfall, Agile

Data bases: Oracle 10g, SQL Server, MS - Access

PROFESSIONAL EXPERIENCE

Confidential - Princeton, New Jersey

Project Lead

Responsibilities:

• Played Dual role as Scrum Master and Report Developer.
• Responsible for gathering business requirements, worked directly with business units to define requirements and support various business initiatives and projects as it relates to analytics and reporting
• Organize and facilitate project planning, daily stand-ups, reviews, retrospectives, sprint/release planning, demos and other Scrum-related meetings
• Involved in full project lifecycle of SDLC and coordinated with all project teams
• Track and communicate team velocity and other development metrics with, and to all affected teams and management through RTC change and configuration management tool.
• Responsible for publishing and deploying the reports in different environments.
• Develop the new marts and categories etc. using the ESP framework as per the requirements.
• Extracted data from different source and loaded into tables using ESP 2.0
• Blended data from multiple databases into one report by selecting primary keys from each database for data validation
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in MySS Interactive Report Designer.
• Design and develop ESP meta model architecture which addresses business and technical requirements.
• Worked on Performance tuning of report with huge queries using concurrent query execution for better performance of report.
• Experience in report scheduling and deliver to internal client and external client location using SFTP.
• Follow Test driven development and other unit testing methodologies as a part development life cycle.
• Performed end to end testing on the reports and packages developed to ensure data quality is met.
• Participate in troubleshooting and triaging of issues with different teams to drive towards root cause identification and resolution
• Support Production deployment of applications, migration of legacy processes as a part of ESP continuous integration, documenting the issues and tracking towards their resolution.
• Scheduling jobs and monitoring through Autosys.
• To review the work of team members, ensure that it is as per the laid down specifications by Story and meets the desired State Street and quality standards as per Project.

Tools: and Software used: MySS Interactive Report Designer, Autosys, SS ESP Framework 2.0, Unix, SVN and RTC

Confidential - Princeton, New Jersey

Project Lead

Responsibilities:

• Responsible for gathering business requirements, worked directly with business units to define requirements and support various business initiatives and projects as it relates to analytics and reporting
• Involved in full project lifecycle of SDLC and coordinated with all project teams.
• Actively participated in Business Intelligence standardization to create database layers with user friendly views in SQL Server that can be used for development of various Tableau reports/ dashboards.
• Analyzed requirements for various reports, dashboards, and scorecards and created the same using Tableau desktop server.
• Designed and developed a business intelligence data visualization dashboard using Tableau Desktop, allowing executive management to view past, current and forecast sales data.
• Mentored business power users to create reports/dashboards using tableau desktop.
• Designed and Developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop
• Developed of key indicators and the appropriate tracking reports with graphical and written summations to assist in the quality improvement initiatives.
• Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.
• Created Prompts, customized Calculations, Conditions and Filter (Local, Global) for various analytical reports and dashboards.
• Created and modified Interactive Dashboards and creating guided navigation links within Interactive Dashboards.
• Make use of filters and making them local and global accordingly.
• Published the developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data.
• Scheduled frequency and time to refresh data for the when sources are publishes or extracted to server.
• Used SQL tools like Toad and SQL Assistant to run SQL queries and validate the data in the warehouse and marts.
• Extensive experience in developing Stored Procedures, Views, Cursors, Triggers, Scripts and Complex Queries in MS SQL Server.
• Worked on large sets of data for analyzing the business and improve the business methods.
• Oversee the performance of Design to develop technical solutions from Analysis documents.
• Provided post implementation production support.

Tools: and Software used: Tableau (Desktop, Server) 8.1,2018.1, SQL Server 2012, Oracle 11g, GIT

Confidential, Phoenix, AZ

Project Lead

Responsibilities:

• Created efficient, robust SSIS packages for data movement and loading with error checking and well documented code.
• Created SSIS Packages to integrate data coming from Text files and Excel files.
• Created Tables, Stored procedures and defined functions. Modified SQL scripts for tuning and scheduling.
• Extensively used joins and common Table Expressions to simplify complex queries involving multiple tables
• Was responsible in redesigning existing ETL ‘s to SSIS packages
• Expert in creating Power pivots, Power views and SSRS reports using SQL queries.
• Interactive data visualization products focused on business intelligence such as MICROSOFT Power BI.
• Developed confidential proprietary analytical tools and reports with Microsoft Excel, and Power Pivot, and Power Point.
• Publishing Power BI reports from Power BI Desktop to Power BI service.
• Build Tabular, line charts, Graph charts visuals for Marketing KPI's metrics based on fields brought in and transform using Power Query functions and DAX calculated Measures.
• Generated reports utilizing SSRS and Excel with power pivots; deployed reports within SharePoint integrated mode.
• Created detailed dashboards utilizing Microsoft BI desktop to improve analysis and decision making with various sources Azure, Sql server, Excels.
• Managed reports/data sources, schedule report execution, and delivery.
• Managed team foundation server utilizing source control, check-in, and check-out.
• Captured the long running jobs and worked on fine tuning the store procedures and tables to improve the performance.

Tools: and Software used: MS SQL Server 2008 R2/2014, SSIS 2008 R2/2012, SSRS 2008 R2/2012, Power BI

Confidential

Project Lead

Responsibilities:

• Interact with business analyst to develop a strong understanding of the project and development objectives
• Suggested the kind of report required for the Business and gathered the user requirements
• Created Report Definition Document (RDD) for the project
• Responsible for the overall direction, coordination, implementation, execution, control and completion f specific projects ensuring consistency with company strategy, commitments and goals.
• Provide technical assistance and cross training to other team members.
• Provide training and assistance to users for generation of adhoc reports
• Design and implement technology best practices, guidelines and repeatable processes.
• Actively Participating into Technology like creating accelerators, Tool Evaluation, Customer Visit, Demo to Clients, Training Plan for BI Community.
• Installing and Configuring VRS Product in the production environment and Release Management
• Provide technical assistance and training to the business users.
• Support activities - Application support, technical support - manage servers and queues.

Tools: and Software used: Vermilion Reporting Suite (VRS), JBoss Application Server, Java, Oracle 9.2 and PVCS, SBM