SUMMARY:

• 10+ years as BI Analyst, Developer and Support Analyst with experience in BI Design Development and Testing, Client Management, Production Support, ETL Testing and resource management. Strong hands on experience with Tableau Reporting & Data Visualization
• BI data Analyst with over 10+ years of experience in Designing Business Intelligence Solutions, BI Development, Dashboard Design, ETL testing, Application support, Test automation development, Client Management and Resource Management
• Extensive experience in developing Tableau BI reports and Data visualization from various data sources
• Expert in Building, Managing and guiding the team in Development, Testing and Support.
• Good Understanding of Data marts, Data warehouse, Operational Data Store (ODS), OLAP, Data modeling like Dimensional data modeling, Start Schema Modeling, Snow - Flake Modeling
• Expert in Designing and Developing Reports in Tableau and Predictive Analysis
• Expert on maintaining and managing Tableau driven reports and dashboards
• Expert in writing complex SQL and PL/SQL using SQL Developer and Toad as development tools.
• Familiar with Oracle, SQL Server, Oracle PL/SQL Packages, Stored Procedures, Functions & Triggers.
• Experienced in dealing with clients to understand the Business requirements and providing support.
• Experience in full Software Development Life Cycle (SDLC) (designing, debugging, testing, documentation, maintenance and enhancement).
• Experience in Agile Methodology for Developing and Testing reports using Tableau and Cognos.
• Experience in data analysis and problem solving with large amounts of data
• Hands on experience with analysis of business, technical, and functional requirements and Developed, Executed & Tested the test plans, test cases and test strategies.
• Experience with change management, versioning and maintaining the document repository.
• Expertise in Data Warehouse, ETL Verification, BI reports and DB Testing.
• A self-motivated, responsible and reliable team player with a set of strong technical skills.

TECHNICAL SKILLS:

Operating Systems: Windows XP, Unix

Languages: Oracle SQL, Unix Shell Scripting, VBA, PLSQL, MF Cobol

Database: Oracle, SQL Server, Teradata, DB2

Tools: Tableau, Cognos, Autosys

Quality Tools: HPALM

Testing: Manual ETL Testing, BI Testing

PROFESSIONAL EXPERIENCE:

Confidential

BI Analyst and Test Coordinator

Responsibilities:

• Involved in requirement gathering for new reports from business and management team
• Designing reports based on the requirement
• Responsible for ongoing maintenance and change management to existing reports and optimize report performance
• Experience in creating dashboards using various graphs and charts
• Experience in creating filters, quick filters, data source filters, local, global filters, context filters and user filters
• Designed, Developed and Published Power BI Reports, Power BI Dashboard - POC
• Responsible for BI Testing and coordinating with various team for quality deliverables

Confidential

Technology: Manual Testing, Tableau, Cognos, ETL tools, SQL, Teradata, Unix Shell Scripting, VBA

BI Consultant/Test Coordinator

Responsibilities:

• Requirement gathering for new reports from business and management team
• Designing reports based on the requirement
• Extensively worked on designing reports using Power BI
• Creating reports for all business and project needs based on the design document using Tableau and Power BI
• Responsible for ongoing maintenance and change management to existing reports and optimize report performance
• Experience in creating dashboards using various graphs and charts
• Experience in creating filters, quick filters, data source filters, local, global filters, context filters and user filters
• Used Report Manager to assign roles, permissions and to create report subscription
• Evaluating resources for Support project
• Involved in resource management and building up the team for new projects
• Guiding and Mentoring the team to identify automation opportunities and implementing the same
• Created multiple automation scripts in UNIX and VBA to improve the efficiency and reduce manual intervention

Project Description: This project deals with Data Management Operations across all the Business Units. The data will be processed from multiple sources and stored in Data Warehouse and Hadoop and the same will be used for Reporting and Analysis.

Confidential

Technology: Tableau, Cognos, ETL Tools, Oracle, VBA, Manual ETL and BI Reports Testing

BI Analyst and Test coordinator

• Verified the application to ensure that the requirements, artifact from each phase, and the final product are complete and correct.
• Identified the requirements and arranged peer reviews, walkthroughs and sign off meetings.
• Verifying, defining and performing the Test strategies and associated scripts for the verification and validation of the application and ensuring that it meets all defined business requirements and associated functionality.
• Co-ordinated with multiple stakeholders for the release and prepared timelines for each testing phase.
• Conducted meetings with the team regularly to understand any challenges and addressing it.
• Performed the functional testing to validate the data is mapped correctly which provides a qualitative check of overall data flow up and deposited correctly in Target Tables
• Performed SQL validation to verify the data extracts and record counts in the database tables.
• Designed policies, standards and procedures for testing life cycle for the data warehouse and data marts.
• Attended the Requirement reviews, Design reviews, Code reviews to understand the overall process flow and Source to Target Mappings.
• Writing Complex SQL Queries to retrieve data from database to verify and validate the data are moved properly from source to target.
• Verified and Prepared test data to verify the functionality.
• Performed Data validation to verify the data extracts and record counts in the database tables as per the requirments.
• Prepared and provided the management with weekly test metrics, reports, and schedules.
• Conducted weekly status meetings, walkthroughs, documented proceedings, and mentored new team members in test documentation and test case execution.
• Identified automation opportunities and developed scripts in vba to improve the testing standards and reduce the manual efforts

Project Description: This project deals with Regulatory Data from multiple Firms and stores the data in Data Warehouse using ETL tools and Hadoop. These data will be used for Reporting and Analysis using Cognos and Tableau.

Confidential

Technology: Tableau, ETL Tools, Oracle, SQL Server and Unix Shell Scripting

Team Lead and BI Developer

• Planning Deliverables and resource utilization
• Testing and Developing reports in BI tool (Tableau and Cognos)
• Interacting with Clients for Reporting requirements
• Design, Code Review, UTR review and Supporting Production deployment
• Co-ordinate with multiple stake holders for various deliverables and deployment
• Co-ordinate and guide the team for quality deliverables
• Providing support for the application
• Initial analysis and assigning works to the team
• Tracking and metrics preparation.
• Process adherence

Project Description: This project deals with Metadata management for different LOB’s across the bank.

Confidential

Technology: Oracle sql/plsql, Unix, Shell Scripts, Perl, Java, Cobol

Team Lead and Developer

• Planning Deliverables and resource utilization
• Involved in development activities
• Code Review, UTR review and Supporting Production deployment
• Involved in Manual Testing and Coordinating with UAT team
• Co-ordinate and guide the team for quality deliverables
• Providing support for the application
• Initial analysis and assigning works to the team
• Tracking and metrics preparation

Confidential

Technology: Oracle sql/plsql, Unix, Shell Scripts, VB, Cobol, Autosys

Team Lead and Support Analyst

• Review program specifications for enhancements
• Guiding the team in developing the Code for enhancement
• Indulged in UNIT, System Integration testing
• Monitoring Batch jobs
• Providing support for the applications
• Initial analysis and assigning works to the team
• Guiding and tracking the tasks to help the team in completing the same on time.
• SPOC for all the Forecasting, Reporting and Registration apps for Europe, Asia Pacific regions.
• Coordinating and providing support for new launches
• Create or Modify programs and scripts
• Perform bug fix
• Ensured the quality of the deliverables made
• Metrics preparation and involved resource management

Project Description: VOPS - Order processing and reporting application which has around 20 applications. Broadly classified into Froecasting, Order processing, Scheduling, Reporting and Registration applications.

I worked in Forecasting, Reporting and Registration apps as a Team Lead. Most of these are OLAP applications. The reports generated by these applications will be used by top management for vehicles tracking from order to delivery and for decision making and forecasting

Confidential

Technology: Cobol, Pro-Cobol, Oracle sql/plsql, Unix, Shell Scripts, DB2, JAVA, Autosys, .Net

Module Lead and Team Member

• Review program specifications for enhancements
• Guiding the team in developing the Code for enhancement
• Indulged in UNIT, System Integration testing
• Monitoring Batch jobs
• Providing support for the applications
• Initial analysis and assigning works to the team
• Guiding and tracking the tasks to help the team in completing the same on time.
• SPOC for all the Forecasting, Reporting and Registration apps for Europe, Asia Pacific regions.
• Coordinating and providing support for new launches
• Create or Modify programs and scripts
• Perform bug fix
• Ensured the quality of the deliverables made
• Metrics preparation and involved resource management