We provide IT Staff Augmentation Services!

Lead Bi Developer/analyst Resume

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.

Hire Now