SUMMARY

• More than 13 years of extensive experience on different phases of SDLC including analysis, design, BI reports development, testing and production support in retail, finance, healthcare, pharmaceuticals and biotechnology domains.
• Extensive experience in working with IBM Cognos, Tableau Desktop, Tableau Server and Power BI Desktop
• Hands - on experience on Tableau Server Administration, software installation, managing server licensing, Security (SSL, TLS 1.2), upgrades, AD groups, scheduling and Sites maintenance.
• More than 3 years of experience leading Hadoop and EDW teams with technical experience working on Big Data Ecosystems: HDFS, Hive, NiFi, Kafka, HQL’s, scheduling, Diyotta and Unravel
• Have good experience in SQL Server, Netezza, MySQL and Oracle SQL & PL/SQL involving developing of new and modifying existing Functions, stored procedures, Packages, Pl/SQL Blocks, Triggers, Object Types and SQL performance tuning.
• Well versed with ITIL practices of Incident, Problem and Change management procedures.
• Good knowledge of scrum-Agile methodology for development of projects using Jira, Confluence & TestRail.
• Excellent presentation and communication skills, people management, team building, motivation and leadership skills.
• Exceptional ability to quickly master new concepts and technologies.
• Good at troubleshooting complex issues by having production support experience.

TECHNICAL SKILLS

Databases: Oracle 9i, 10g, 11g, Netezza, SQL Server, MySQL

Technical Skills: Big Data Hadoop, HDFS, MapReduce, Hive, HBase, MongoDB, Kafka, NiFi, Diyotta, IBM Cognos 7, 8.x, 10.x - Framework Manager, Cognos Studios, Informatica, DataStage, Web Services, XML, JavaScript and HTML

BI Tools: Cognos, Informatica, DataStage, Erwin, Tableau Desktop, Tableau Server, Power BI Desktop, Cognos Life Cycle Manager, SSAS, AtScale

Software Tools: Visual Source Safe (VSS), TFS, StarTeam, Perforce, Chameleon, TOAD, SQL Developer, SQL Navigator, PLSQL Developer, IntelliJ IDEA, Jira, Life Cycle Manager, DB Visualizer, SSMS

Operating Systems: Microsoft Windows, UNIX, LINUX

Trained Skills: C, OS, RDBMS concepts, Oracle concepts, PL/SQL, DataStage 7.5, Cognos 8.4, 10.2, Informatica 9, Tableau Server and Desktop 10, Diyotta

Products: Dealer Dashboard, Store Operations Dashboard, Confidential (Revenue Management Product), IMS Study Optimizer (Clinical Trials)

PROFESSIONAL EXPERIENCE

Confidential

Senior BI Analyst

Responsibilities:

• Leading DevOps team supporting EDW, Hadoop applications and BI environments across all CTC banners and handling intake items from delivery and business teams.
• Currently leading a team of more than 10 people supporting Hadoop environment using Big Data Ecosystems stack: HDFS, Hive, NiFi, Kafka, HQL’s, ESP scheduling, Diyotta and Unravel
• Working on automation of major Hadoop issues like Kafka alerts, NiFi retry logic, Queues Cleanup, Diyotta and Service Now integration
• Created dashboards for analyzing Netezza data using Tableau desktop.
• Extensive experience with the design and development of Tableau visualization solutions.
• Background in installing and upgrading of Tableau server and server performance tuning for optimization.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Currently working on Power BI Desktop to create dashboards for senior executives to provide holistic Netezza view which includes Usage space analysis, resources availability, databases growth trend analysis
• Migrating existing reports in Tableau to Power BI enterprise reporting and analytics tool.
• Successfully developed Tableau Dashboards for management to visually display CAPex vs OPex, Project Finance burn down charts and project detailed status, Incident and Change Management dashboards thereby improving visibility of team utilization, budget allocations and project tracking to top management.
• Successfully migrated nearly 300 reports and packages from Cognos 8.4.1 to 10.2.2 in scrum methodology delivering reports in multiple sprints using Jira board.
• Applied Scrum-Agile methodology for development of project reports and successfully delivered various reports.
• Worked extensively on Jira, Confluence & TestRail creating stories for sprints and Kanban boards to track the issues, backlogs and intake items.

Technologies: Cognos 10.2.2, 8.4.1 Report Studio & Framework Manager, Tableau Desktop & Server 9.2 & 10, Power BI Desktop 2.76, Erwin, Oracle SQL, PLSQL, Basic Java, HTML scripting & UNIX, NiFi, Sqoop, Hive.

Confidential

Senior Consultant - BI Developer

Responsibilities:

• Analysis of the client requirements and provide feasibility options to the client.
• Applied Scrum-Agile methodology for development of project reports and successfully delivered reports in multiple sprints to improve efficiency and regularity in project.
• Creating packages using Framework Manager relational and dimensional models.
• Developing custom Reports using complex SQL queries and scheduling the reports.
• Fine-tuned SQL queries to improve performance of existing reports by analyzing the explain plans, adding hints and with-clauses.
• Work with Functional and Testing teams to clarify the issues, complete enhancements and fix Production bugs.
• Deployment of the developed reports in Test & UAT environments with Production strength data.
• Improved reports performance at Framework manager model level.
• Implemented report bursting to distribute reports appropriately.
• Deliver report exports to client xml & zip formats to further deploy in client environments.
• Enhancement requests to pull new attributes to Data warehouse using Informatica.
• Maintain Source control repository for Cognos reports.

Technologies: Cognos 10.2 Report Studio & Framework Manager, Informatica, Erwin, Oracle SQL, PLSQL, Basic Java & UNIX.

Confidential

Web Developer

Responsibilities:

• Involved with Business analysts in gathering functional specifications and provide feasibility options thereby reducing turnaround times involved in clarifications.
• Effectively analyzed functional requirements from business team and customer support teams.
• Developing native SQL based reports and scheduling the reports.
• Implementing Cognos 8.4 to 10.2 upgrade by involving in installation, configuration, migration and testing of all objects in multiple environments.
• Resolving migration issues occurred due to java prompts, crosstab calculations and validation issues.
• Testing - Unit testing and fixing bugs.
• Involved in authoring Unit Test Cases and Technical Specification documents.
• Providing training on complex reports to the business users on how effectively the reports will run and pull required data in less time.
• Deployment of the developed reports in appropriate domains.
• Transition of developed reports to Application Support Team.

Technologies: Cognos 8.4, 10.2 Report Studio, Oracle SQL, PLSQL, Basic Java & UNIX.