Experience Summary

**+ years of IT experience in capacity of Senior Technical Consultant/Developer.

As a Technical Lead, have delivered many projects in world’s largest banks & Insurance, including estimations, measuring progress and Risk management.

Manage stakeholders in fast-paced environments, ability to effectively prioritize and juggle multiple concurrent challenges.

As a Technical Lead, I was responsible for the complete engagement and on timely deliverables, interacting with the Business users and understand all the business requirements and convert them to Requirement Document & effort-estimation as per the requirement.

Participated in the complete development lifecycle of DW-Reporting including requirement gathering, Testing, Development, Deployment and Migration.

Evaluate Functional requirements and Reporting requirements provided by the business and identify the gaps in requirements if any and will provide recommendations on BO-Universe & MSTR optimization.

Aware of Onshore/Offshore model, Lead team of 10. Demonstrated ability to work effectively in a fast paced, high volume, deadline driven environment.

Rich experience in understanding the current client systems and proposing new solutions using BI Tools -Business Objects 4.x/ XI3.x, Tableau-10.x,Oracle9i/10g/11g, Microstrategy 10.x,Xcelcius-2008.

Proficient in SAP BO Reporting- SAP BOXI R4, SAP BOXI R3, DESKI & Administrative tasks.

Proficient in Microstrategy as an Architect / Developer.

Proficient in Tableau-10.x Dash boarding.

Proficient in Xcelsius Dashboarding.

Proficient in Data analysis/Data Management tasks, involved in end to end data validation.

Prepared the project related documents-BRD/Test Cases for data management and maintained through SharePoint portal, Developed and Extract SQL’s at the Back-end.

Have prepared Analysis/Design/Technical document and Unit Test Plans as per the business logic.

Performed the Code and Document Reviews, unit testing and preparing deliverables.

Responsible for quality management activities and contribute to process improvements.

Having resource management experience, responsible for quality management activities and contribute to process improvements.

Participated in multiple leadership (Internal/external) Programs, Like - PMP Program conducted by Seed Infotech Academy, Leadership Journeyman Jr Program conducted by L&T Academy.

Skills Summary

Domain

Banking & Finance, Insurance,Healtcare

Programming Languages

Oracle, SQL

Operating System / ERP Version

Windows 7, Unix

Tools / DB / Packages / Framework / ERP Components

Business Objects-BOXIR4.x, Tableau-10.x, Oracle-SQL, Microstrategy-10.x, BOXIR3, BO-6.5, Cognos-10.1, Xcelsisus-2008

Professional Certifications/ Trainings

Leadership Program - Attended PMP Program conducted by Seed Infotech Academy,Pune,India.

Leadership Program - Attended Leadership Journeyman Jr Program conducted by L&T Academy.

Microstrategy - Certified Analyst (MCA) - Version 10

Microstrategy - Certified Report Developer (CRD) - Version 9.4.1

Microstrategy - Certified Project Designer (CPD) - Version 9.4.1

Oracle Certification - IZ 007 (Introduction to SQL).

Informatica Certification - S-Power Center 8 Mapping Designer.

Data warehousing & Oracle Certification - Conducted by Cognizant Academy.

Attended Microstrategy Training conducted by L&T Academy.

Attended BO-4.0 Training conducted by Wipro Academy.

Attended Xcelsius Training conducted by Wipro Academy.

Attended PM/PL session conducted by L&T Academy.

Received “DW scope award” twice for Excellent Performance in Cognizant.

Work Experience

Project 1

Project Name

Pfizer INC, Peapack-NJ

Cognos-10 to Business Objects-4.2 Migration

Team Size

10

Start Date

Nov 2017

End Date

Till Date

Role

BI Technical Lead/Sr.BI Technical Consultant

Project Description

Pfizer has a requirement to migrate their existing COGNOS 10.1 reports to Business Objects 4 platform as a part of their BI reporting platform consolidation strategy. COGNOS is currently being utilized by 1100+ users to fulfill their reporting needs. Goal is to migrate all existing COGNOS reports into Business Objects platform and decommission COGNOS gradually in order to minimize multiple BI tools usage across the organization. Primary scope includes migration of reports and framework manager from Production Cognos 10.1 to Production BO 4.2

Role & Contribution

Role – Senior Technical Consultant

As a Senior Technical Consultant, I’m the only responsible for the complete engagement and on timely Deliverables.

Participating in the complete development lifecycle of DW-Reporting including requirement gathering, Testing, Development and Deployment.

Interacting with the Business users and understand all the business requirements and convert them to Requirement Document and proposing the design & effort-estimation as per the requirement.

Evaluate Functional requirements and Reporting requirements provided by the business and identify the gaps in requirements if any and will provide recommendations on used BI tools – Cognos/BO optimization.

Project Management (Knowledge/Experience), as a Mentor have ensured that team works effectively.

To monitor process compliance through sample checks and take the corrective action in case of non-compliance.

Resource management, Aware of Onshore/Offshore model, Lead 8-10 resources Team.

Responsible for quality management activities and contribute to process improvements.

Manage Stakeholders in fast-paced environments, ability to effectively prioritize and juggle multiple concurrent challenges.

Demonstrated ability to work effectively in a fast paced, high volume, deadline driven environment.

Performed the code/document reviews & prepared the project’s status report.

Role – As a Business Objects Sr. Developer

Proficient in Business Objects as a Developer / Universe Designer.

Development and enhancement of Business Objects Universe and Reports.

Development and enhancement of BO-Reports in SAP BO XI R4, SAP BO XI R3 and DESKI.

Development and enhancement of webi Reports (On demand, adhoc Reports, Frequency Reports, Summary Reports, Drill-Down, Cross-Tab).

Have trained and shared knowledge with the Business users to develop simple Ad-hoc reports as per their requirements.

Designed and Developed webi Reports using the features like Combined Queries, Merged Dimensions, Charts, Cross Tab, Drill Down.

Have prepared Analysis/Design/Technical document and Unit Test Plans according to business logic, involved in end to end data validation.

Developed and Extract SQL’s at the Back-end.

Performed the Code and Document Reviews, Unit testing and preparing deliverables, BO-Universe & Report & Design Documentation.

Extensive experience in data analysis to improve overall efficiency to support decision making, involved in Creating and Maintaining the User /Group Creation

Creating Security restrictions in universe and CMC based on different

Adding/ removing users, Groups and Folders, Migrating BO Report/ objects from Development to Test to Production Environments.

Role – As a Tableau Developer – Muliple POCs

Proficient in Tableau Dashbaording as a Developer.

Experience in connecting with datafiles (.csv) and workbook.

Experience in adding filters/quick filters/adding colors/adding label formatting/adding interactive action filters/Highlighting.

Understanding of groups/combine fields/calculated fields/aggregated fields /spotlighting to compare & analyze the data in different perspectives.

Experience in working with joining and Data Blending/Join with multiple fields/Join with duplicates values/Joining data vs Blending Data.

Understanding of Join – LEFT/RIGHT/FULL/INNER Joins in tableau.

Experience in table calculations/advanced dashboards/storytelling.

Experience in time series/aggregation/granularity and level of details.

Experience in working with hierarchies.

Experience in working with scatterplots/treemap chart.

Experience in advanced data preparation/data interpreter/pivot/splitting column into multiple columns.

Experience in adding a Highlighter/clustering in tableau/cross database join/modelling with clusters

Understanding of relational database structures.

Extensive experience in preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.

Created actions in worksheets and dashboards for interactivity and to compare data against different views.

Found ways to make graphs and tables visually exciting, and aesthetically pleasing, while at the same time maintaining the accuracy of the core information content that is being communicated.

Tools

Business Objects-BOXI R4, Oracle-SQL, Tableau-10.x

Project 2

Project Name

CITI Financial Bank, Warren-NJ

BO to MSTR Migration

Team Size

12

Start Date

Nov 2015

End Date

Nov 2017

Role

BI Technical Lead/Sr.BI Developer (BO&MSTR)

Project Description

Build solution for processing for all the operations - Capital Allocation/Loss Capture in CITI Group. Also the Operational risk reporting intends to handles all the losses from system. It was divided in multiple parts and then gathered the collectively losses on quarter basis. This project was involved the development and enhancement of reports in Business Objects XIR3, Microstrategy.

Role & Contribution

Role – Project Lead / Technical Lead

As a Technical Lead, I was the only responsible for the complete engagement and on timely Deliverables.

Participated in the complete development lifecycle of DW-Reporting including requirement gathering, Testing, Development and Deployment.

Interacting with the Business users and understand all the business requirements and convert them to Requirement Document and proposing the design & effort-estimation as per the requirement.

Evaluate Functional requirements and Reporting requirements provided by the business and identify the gaps in requirements if any and will provide recommendations on used BI tools – BO/MSTR/XCLESIUS optimization.

Project Management (Knowledge/Experience), as a Mentor have ensured that team works effectively.

To monitor process compliance through sample checks and take the corrective action in case of non-compliance.

Resource management, Aware of Onshore/Offshore model, Lead 8-10 resources Team.

Responsible for quality management activities and contribute to process improvements.

Manage Stakeholders in fast-paced environments, ability to effectively prioritize and juggle multiple concurrent challenges.

Demonstrated ability to work effectively in a fast paced, high volume, deadline driven environment.

Performed the code/document reviews & prepared the project’s status report.

Role – As a Business Objects Sr. Developer

Proficient in Business Objects as a Developer / Universe Designer.

Development and enhancement of Business Objects Universe and Reports.

Development and enhancement of BO-Reports in SAP BO XI R4, SAP BO XI R3 and DESKI.

Development and enhancement of webi Reports (On demand, adhoc Reports, Frequency Reports, Summary Reports, Drill-Down, Cross-Tab).

Have trained and shared knowledge with the Business users to develop simple Ad-hoc reports as per their requirements.

Designed and Developed webi Reports using the features like Combined Queries, Merged Dimensions, Charts, Cross Tab, Drill Down.

Have prepared Analysis/Design/Technical document and Unit Test Plans according to business logic, involved in end to end data validation.

Developed and Extract SQL’s at the Back-end.

Performed the Code and Document Reviews, Unit testing and preparing deliverables, BO-Universe & Report & Design Documentation.

Extensive experience in data analysis to improve overall efficiency to support decision making, involved in Creating and Maintaining the User /Group Creation

Creating Security restrictions in universe and CMC based on different

Adding/ removing users, Groups and Folders, Migrating BO Report/ objects from Development to Test to Production Environments.

Role – As an Microstartegy Sr. Developer

Proficient in Microstrategy as an Architect /Developer.

Participated in Microstrategy Schema / Reports / Dashboard Development / Configuration, Deployment and Administration.

Development and enhancement of MSTRProject / Schema Objects / Public Objects.

Development and enhancement of Intelligent Cube / Documents & Visualization

Development and enhancement of MSTR Reports including Objects / Filters / Prompts / Metrics / Attribute / Custom Group.

Development and enhancement of MSTR Reports including Consolidation and Cubes Creation, Participated in Data Analysis / Validation & Troubleshooting.

Migrating MSTR Reports / Objects from Development to Test to Production environments, Security configuration.

Role – As a Tableau Developer – POC Work

Proficient in Tableau Dashbaording as a Developer.

Experience with creation of users, groups, projects, workbooks.

Used Data Blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives.

Extensive experience in preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.

Created Actions in Worksheets and Dashboards for interactivity and to compare data against different views.

Found ways to make graphs and tables visually exciting, and aesthetically pleasing, while at the same time maintaining the accuracy of the core information content that is being communicated.

Understanding of relational database structures.

Tools

Business Objects -BOXI R4 & BOXI R3, Microstrategy-9.x, Microstrategy-10.x, Oracle-SQL, Tableau-9.x

Project 3

Project Name

CITI Financial Bank, Warren-NJ

Team Size

10

Start Date

Nov 2013

End Date

Nov 2015

Role

BI Technical Lead/Sr.BI Developer

Project Description

Build solution for processing for all the operations - Capital Allocation/Loss Capture in CITI Group. Also the Operational risk reporting intends to handles all the losses from system. It was divided in multiple parts and then gathered the collectively losses on quarter basis. This project was involved the development and enhancement of reports in Business Objects XIR3, Microstrategy.

Role & Contribution

Role – Technical Lead

As a Technical Lead, I was the only responsible for the complete engagement and on timely Deliverables.

Participated in the complete development lifecycle of DW-Reporting including requirement gathering, Testing, Development and Deployment.

Interacting with the Business users and understand all the business requirements and convert them to Requirement Document and proposing the design & effort-estimation as per the requirement.

Evaluate Functional requirements and Reporting requirements provided by the business and identify the gaps in requirements if any and will provide recommendations on used BI tools – BO/MSTR/XCLESIUS optimization.

Project Management (Knowledge/Experience), as a Mentor have ensured that team works effectively.

To monitor process compliance through sample checks and take the corrective action in case of non-compliance.

Resource management, Aware of Onshore/Offshore model, Lead 8-10 resources Team.

Responsible for quality management activities and contribute to process improvements.

Manage Stakeholders in fast-paced environments, ability to effectively prioritize and juggle multiple concurrent challenges.

Demonstrated ability to work effectively in a fast paced, high volume, deadline driven environment.

Performed the code/document reviews & prepared the project’s status report.

Role – As a Business Objects Sr. Developer

Proficient in Business Objects as a Developer / Universe Designer.

Development and enhancement of Business Objects Universe and Reports.

Development and enhancement of BO-Reports in SAP BO XI R4, SAP BO XI R3 and DESKI.

Development and enhancement of webi Reports (On demand, adhoc Reports, Frequency Reports, Summary Reports, Drill-Down, Cross-Tab).

Have trained and shared knowledge with the Business users to develop simple Ad-hoc reports as per their requirements.

Designed and Developed webi Reports using the features like Combined Queries, Merged Dimensions, Charts, Cross Tab, Drill Down.

Have prepared Analysis/Design/Technical document and Unit Test Plans according to business logic, involved in end to end data validation.

Developed and Extract SQL’s at the Back-end.

Performed the Code and Document Reviews, Unit testing and preparing deliverables, BO-Universe & Report & Design Documentation.

Extensive experience in data analysis to improve overall efficiency to support decision making, involved in Creating and Maintaining the User /Group Creation

Creating Security restrictions in universe and CMC based on different

Adding/ removing users, Groups and Folders, Migrating BO Report/ objects from Development to Test to Production Environments.

Role – As an Microstartegy Sr. Developer

Proficient in Microstrategy as an Architect /Developer.

Participated in Microstrategy Schema / Reports / Dashboard Development / Configuration, Deployment and Administration.

Development and enhancement of MSTRProject / Schema Objects / Public Objects.

Development and enhancement of Intelligent Cube / Documents & Visualization

Development and enhancement of MSTR Reports including Objects / Filters / Prompts / Metrics / Attribute / Custom Group.

Development and enhancement of MSTR Reports including Consolidation and Cubes Creation, Participated in Data Analysis / Validation & Troubleshooting.

Migrating MSTR Reports / Objects from Development to Test to Production environments, Security configuration.

Tools

Business Objects-BOXI R4 & BOXI R3, Microstrategy-9.x, Microstrategy-10.x, Oracle-SQL, Tableau-10

Project 4

Project Name

Fifth Third Bank, Cincinnati-Ohio

Team Size

8

Start Date

April 2011

End Date

Nov 2013

Role

BI Technical Lead / Sr.Business Object Developer

Project Description

The purpose of this project is to incorporate data elements that Fifth Third Bank currently receives from Royal Bank of Canada (Canada Branch & Can link RBC Accounts) and CITI Bank Multi-Currency Accounts into Fifth Third’s Data Warehouse and Customer Relationship Management (CRM) system. This will enable improved reporting and a more accurate view of the customers’ data.

Role & Contribution

As an Onsite Lead I was responsible for the complete engagement and on time deliverables

Participated in the complete development lifecycle of DW-Reporting including requirement gathering, Testing, Development and Migration.

Interacting with the Business users and understand all the business requirements and convert them to Requirement Document.

Evaluate Functional requirements and Reporting requirements provided by the business and identify the gaps in requirements if any and will provide recommendations on Universe optimization.

Have prepared Analysis/Design/Technical document and Unit Test Plans as per the business logic.

Developed and enhanced SAP Business Objects Universe and Reports.

Developed and Extract SQL’s at the Back-end.

Developed/Enhanced reports in SAP BO XI R3 and DESKI.

Developed and enhanced Universe & Report & design documents as well.

Developed WebI Reports (on demand, AdHoc Reports, Frequency Reports, Summary Reports, Drill-Down, Cross-Tab)

Designed and Developed WebI Reports using the features like Combined Queries, Merged Dimensions, Charts, Cross Tab, Drill Down.

Performed the Code and Document Reviews, Unit testing and preparing deliverables.

Extensive experience in data analysis to improve overall efficiency to support decision making.

Involved in Creating and Maintaining the User /Group Creation

Creating Security restrictions in universe and CMC based on different

Adding/ removing users, Groups and Folders.

Migrating report/ objects from the development, test and Production environments.

Security configuration

Project Management (Knowledge/Experience).

Understanding requirements from the BRD and proposing designs as per requirements and Preparing Effort Estimation as per the requirement.

Tools

Business Objects (BOXI R4, BOXI R3), Xcelsius-2008, Oracle-SQL

Project 5

Title

Aviva Insurance, Pune-India

Start Date

April 2010

End Date

April 2011

Role

Sr. Business Object Developer

Role & Contribution

Design which includes high level design, low level design and facilitating design sign off

Client interaction & Demonstrated ability to work effectively in a fast paced, high volume, deadline driven environment.

Ability to understand customer needs and manage expectations.

Project Management activities

Understanding requirements from the BRD and proposing designs as per requirements and Preparing Effort Estimation as per the requirement.

Preparing Analysis/Design/Technical document and Unit Test Plans according to business logic.

Developing and enhancing SAP Business Objects Universe and Reports.

Developing Extract SQL’s at the Back-end.

Developed/Enhanced reports in SAP BO XI R4, SAP BO XI R3 and DESKI.

Developing and enhancing Universe & Report & design documents as well.

Performing Code and Document Reviews, Unit testing and preparing deliverables

Tools

Business Objects (BOXI R3), Xcelsius-2008, Oracle-SQL

Key Achievements

Successfully have completed many POCs in Xcelsius dash boarding.

Project 6

Title

JP Morgan Chase - CIT DAC Reporting, Pune-India

Start Date

Dec 2006

End Date

April 2010

Role

Business Object Developer

Role & Contribution

Design which includes high level design, low level design and facilitating design sign off

Client interaction & Demonstrated ability to work effectively in a fast paced, high volume, deadline driven environment.

Ability to understand customer needs and manage expectations.

Project Management (Knowledge/Experience).

Understanding requirements from the BRD and proposing designs as per requirements and Preparing Effort Estimation as per the requirement.

Preparing Analysis/Design/Technical document and Unit Test Plans according to business logic.

Developing and enhancing SAP Business Objects Universe and Reports.

Developing Extract SQL’s at the Back-end.

Developed/Enhanced reports in SAP BO XI R4, SAP BO XI R3 and DESKI.

Developing and enhancing Universe & Report & design documents as well.

Performing Code and Document Reviews, Unit testing and preparing deliverables

Educational Qualification

Education & Credentials

Bachelor’s in Computer Science in 2006 with RGPV University, Bhopal.

Immigration / VISA Details

H1-B

Having Valid & Stamped H1B – Current Petition is Valid till Dec-2020

I-140

Having approved I-140

Contact this candidate