SUMMARY:

• Over 14+ years of proficiency in consulting clients to transform their underlying data into actionable intelligence, visualization and data quality assurance.
• Excel in Reporting solutions for Operational reports.
• End to End implementation of comprehensive solutions for regulatory reporting, executive and operational reporting/dashboards using Data Warehousing concepts
• Data visualization and Analytics using Tableau, Cognos on the Databases like Cloudera Hadoop (Hive Impala), Oracle, MS SQL Server.
• Business Intelligence Reporting & Root cause Analysis, Requirement & Business Data Analysis.
• Analyze & Understand data and provide suggestions for Visualization.
• Architecture & Design of Data Consumption Single Semantic layers, Data Analytics.
• Kanban, SDLC - Agile, Waterfall
• Demonstrated translate a question into a visualization which provides insight and answers the question.
• Transform requirements into consumable data and/or new report designs.
• Provide architecture and design inputs across the projects to align with business objective.
• Review current processes for inefficiencies and make recommendations for correction.
• Development of new Reports and Interactive Dashboards using Tableau and relevant data source (Big Data Platform (Cloudera Hadoop Preferably Impala and Hive), SQL Server, Excel, CSV)
• Perform detailed data analysis (i.e. determine the structure, content, and quality of the data through examination of source systems and data samples).
• Interact with client to understand their business and reporting needs, including the identification of critical metrics like KPI's and KRI's.
• Developed, publishing customized interactive reports/dashboards, report scheduling using Tableau server.
• Performance Tuning of reports / Dashboards. Improving the performance through Extracts.
• Validation/Testing of data migrated to Hadoop from Excel using HUE Browser
• Successfully Migrated Cognos 10 Reports to Service Now Reporting.
• Worked as Business Intelligence Reporting SME for Service Now -CMDB Reports.
• Setup Service NOW Report Governance for Operational and Performance Analytics Reporting.
• Data Reconciliation between multiple Asset repositories.
• Worked on Migration from ISM to Service NOW Tool.
• Created Various Reports/Dashboards using ServiceNow Reporting.
• Created Key Performance Indicators (KPI) for IT Asset Inventory Data Health.
• Prepare all the KPIs & KRI reports for Management with the help of Cognos Report Studio to maintain the Data Health.
• Provide support to all Cognos issues and maintain knowledge on all new techniques and prepare reports for all warehouse functions
• Coordinate with all customers and analyze test queries and analyze client issues and assist all application analysts to translate all workflow requirements to efficient data points.
• Prepare all designs and code for various Cognos reporting objects and ensure compliance to all best business practices in industry.
• Schedule and ensure compliance to all design code and test activities and prepare plans for same and design various dashboards and maintain required framework for all processes.
• To analyze functional/nonfunctional requirements and seek clarifications for finalizing requirements.
• Responsible for Analysis of Tickets created by client for their data or report issues.
• Worked as Team Lead.
• Monitoring Dashboard and Data Stage Jobs.
• Analysis of Stored Procedures & functions.
• Based on the Peregrine Tickets doing analysis of Cognos Reports and associated Stored Procedures, IBM Data Stage jobs and providing resolution.
• Onsite Lead and Data Analyst.
• Coordination with Offshore team and client.
• Production ETL Job Monitoring.
• Experienced in developing business reports by writing complex SQL queries using views, volatile and global temporary tables.
• Experienced in Automating and Scheduling the Teradata SQL Scripts in UNIX using Korn Shell scripting.
• Experienced working on large volume of Data using Oracle SQL & PL/SQL.
• Good experience in Production Support, Identifying root causes, Trouble shooting and Submitting Change Controls
• Wrote several Oracle SQL Queries using TOAD.

PROFESSIONAL EXPERIENCE:

Lead BI Developer/Analyst

Confidential

Responsibilities:

• Responsible for Analysis, Design and Report Development
• Worked as Module Lead for Actuate Report Development.
• Develop complex queries.
• Develop Stored Procedures & functions.
• Responsible to create Application Design & Unit Test plan documents of the requirement.'
• Preparation of Templates, Coding Standards, Review Checklists and Deployment Checklists
• Unit Testing.

Lead BI & Data Analyst

Confidential, Atlanta

Responsibilities:

• Responsible for Developing Actuate Reports.
• Responsible for developing complex queries in DB2.
• Preparation of Templates, Coding Standards, Review Checklists and Deployment Checklists
• Responsible for Analysis, Design and Report Development
• Worked as Module Lead for ESA Web Report Development.
• Analyze requirement specification and report issues if any.
• Maintaining & Scheduling reports on Daily & Monthly basis on i-Server.
• Develop complex queries.
• Develop Stored Procedures & functions.
• Responsible for UNIX script development
• Responsible to create HLD, Application Design & Unit Test plan documents of the requirement.
• Preparation of Templates, Coding Standards, Review Checklists and Deployment Checklists
• Unit Testing.
• Responsible for Developing Actuate Reports.
• Responsible for developing complex queries in DB2.
• Preparation of Templates, Coding Standards, Review Checklists and Deployment Checklists
• Responsible for Analysis, Design and Report Development
• Worked as Module Lead for ESA Web Report Development.
• Analyze requirement specification and report issues if any.
• Maintaining & Scheduling reports on Daily & Monthly basis on i-Server.
• Develop complex queries.
• Develop Stored Procedures & functions.
• Responsible for UNIX script development
• Responsible to create HLD, Application Design & Unit Test plan documents of the requirement.
• Preparation of Templates, Coding Standards, Review Checklists and Deployment Checklists
• Unit Testing.

Sr. BI Developer

Confidential, Phoenix

Responsibilities:

• Responsible for Analysis, Design and Report Development
• Worked as Module Lead for Callidus Report Development.
• Develop complex queries.
• Develop Stored Procedures & functions.
• Responsible for UNIX script development
• Responsible to create HLD, Application Design & Unit Test plan documents of the requirement.
• Preparation of Templates, Coding Standards, Review Checklists and Deployment Checklists

Application BI Developer

Confidential

Responsibilities:

• Responsible for Developing Forms in VB.NET.
• Responsible for developing complex queries in Oracle.
• Preparation of Templates, Coding Standards, Review Checklists and Deployment Checklists
• Responsible for Analysis, Design and Forms Development
• Managing the interface between front-end application and oracle 9i which is used to manage this Attendance System.
• Develop complex queries, Stored Procedures & functions.
• Responsible to create HLD, Application Design & Unit Test plan documents of the requirement.
• Preparation of Templates, Coding Standards, Review Checklists and Deployment Checklists
• Responsible for Developing Forms in VB 6.0.
• Worked on File Stream Objects.
• Worked on various string functions in VB 6.0.
• Responsible for Developing Forms in VB 6.0, Worked on various grid controls in VB 6.0.
• Unit Testing.