Summary
Overview
Work History
Education
Skills
Accomplishments
Awards
Workshops Training Programs
Certification
Languages
Timeline
Generic

Pranay Rajput

Piscataway,NJ

Summary

With 13 years of IT expertise in SAP HANA, SAP BI technologies, and Microsoft Data Tools, I have a strong foundation in various OLTP and OLAP environments. Also experienced in AWS Cloud migration, specifically with ECS and EC2 environments, as well as Java applications, microservices, and ETL packages. Currently pursuing an MBA in Artificial Intelligence & Machine Learning, set to be completed in July 2024. Well-versed in dashboard and report designing using SAP BusinessObjects applications like Web Intelligence, CMC, CCM, Lumira 2.0, SSRS, and PowerBI. Expertise in SAP S/4 HANA, SAP C/4 HANA, Customize Native HANA, Oracle Database 12c/11g/10g/9i using PL/SQL, SQL Developer, PostgreSQL, and IBM DB2. Experience extends to various SAP Modules such as FI-CO, Central Finance, Insurance, CD, PQM, Claims, ERM, and BPC with JIRA ticketing system and Fiori for frontend. Strong background in financial dashboards and report designing for sales, operation, and HR reports using SAP BusinessObjects applications while collaborating with SMEs in the Banking, Finance, and Insurance domain. Exceptional communication skills and excel at team coordination. In-depth understanding of the software development life cycle and business reporting. Complex problem-solver with an analytical mindset and dedication to achieving demanding development objectives within tight schedules while producing impeccable code. Equipped with strong problem-solving abilities and a willingness to learn. Poised to contribute to team success and achieve positive results while tackling new challenges with dedication and enthusiasm.

Results-oriented achiever with proven ability to exceed targets and drive success in fast-paced environments. Combines strategic thinking with hands-on experience to deliver impactful solutions and enhance organizational performance. Complex problem-solver with analytical and driven mindset. Dedicated to achieving demanding development objectives according to tight schedules while producing impeccable code.

Overview

14
14
years of professional experience
1
1
Certification

Work History

Tech Lead of Business Intelligence Team

Transamerica Corporation
03.2019 - Current
  • Company Overview: Life Insurance and Investment Company
  • Coordinate business management to understand the functional requirement and coordinate with Tech team for implementation
  • Design and Designing P&L statements for Group for the total investment for financial audits
  • Design MIS reports and Dashboards for Audit purposes
  • Design financial dashboard for upper management and field agent and Tax experts to know required statistics
  • Analytical dashboards with Flow charts for Mobile app users
  • Create Database tables for additional requirement
  • Develop PL/SQL Stored Procedures in IBM DB2, Oracle 11g and MS SQL Server Databases
  • Complete Database setup with Data Modeling, Regulatory Report design and MIS, Reconciliation and Audit reporting for Finance, Policy system, Risk and Security
  • Partnering with Finance IT team to ensure all change specifications have been implemented and tested under a formal user acceptance test scenario
  • Vendor management and team coordination to complete all development and deliveries
  • Responsible for the management and supervision of 4 offshore employees involved in month end technical reporting activities
  • Support General Ledger User Acceptance Testing 'UAT' of quarterly and off-cycle general ledger technical releases including providing feedback to system developers and end users
  • Contribute to the design and effectiveness of the team's IT project life cycle
  • Responsible for providing value adds to the customer to improve / product enhancements
  • Ensuring development / maintenance projects were delivered to quality standards
  • Reviewing Project Plans and estimation sheets, participate in configuration management, defect prevention activities, release audits etc
  • Were some of the key responsibilities
  • Life Insurance and Investment Company
  • Environment: SAP BusinessObjects Suite 4.2, SAP BO WebI, Microsoft SQL Server BI Services, IBM DB2 on ZOS, Tableau, PostgreSQL DB, MongoDB, SUSE Linux on AWS Cloud Platform

Business Intelligence – Finance and Operation

Edelweiss Financial Services
11.2017 - 02.2019
  • Company Overview: General Insurance and Investment Company
  • Design Regulatory reports with fixed formats and schedule
  • Deliver them on required destinations
  • Designing P&L statements for Group for the total investment for financial audits
  • Design MIS reports and Dashboards for finance and operation users
  • Design mobile-based status report for upper management and field agent to know required statistics for day-to-day work on individual mobiles
  • Analytical dashboards for internal reports and reconciliation using Fiori
  • Create Database tables for additional requirement
  • Design Information views using Attribute, Analytic and Calculation views
  • Complete Database setup with Data Modeling, Regulatory Report design and MIS, Reconciliation and Audit reporting for Finance, Policy system, Risk and Security
  • Complete SAP CRM with C4H implementation in AWS cloud
  • CRM Dashboard generation
  • Experience in C/4 Dial up configuration
  • Vendor management and team coordination to complete all development and deliveries
  • 4-person team reporting to me
  • General Insurance and Investment Company
  • Environment: SAP BusinessObjects Suite 4.2, SAP BO WebI, SAP BO IDP, SAP BO UDP, SAP ERP 7.5, SAP S/4 HANA, SAP C/4 HANA, SAP Fiori, IBM DB2 iSeries, PostgreSQL DB, MongoDB, SUSE Linux on AWS Cloud Platform

SAP BI Lead – New York Fixed Income Trades

BNP Paribas ISPL
04.2014 - 11.2017
  • Company Overview: International Banking and Corporate Investment Group
  • Design batch jobs for Data loading in Data Marts and Data Warehouse with regulatory reporting using SAP BW on HANA, Oracle, SQL Server
  • Fetch data from SAP HANA sidecar system to pull financial dashboards and journal extracts
  • Design and modify HANA views to implement Business Architecture
  • Design and upgrade Data Marts to store trade details with coordination of team
  • Migrate Business Objects reporting to SSRS and Data loading by SSIS
  • Migrate DB2 database to SQL Server
  • Development of the new requirement, Unit-Testing, Integration-Testing with other requirements, performance tuning, Bug-Fixing
  • Coordinate with ABAP and SLT team for data validation and testing functionalities
  • If the any error occurred in the report output, coordinate with Finance team to resolve the reconciliation
  • BI project planning including effort estimation, resource alignment and created an interim project plan
  • Used Team Foundation Server as a repository and JIRA as internal issue tracking system
  • International Banking and Corporate Investment Group
  • Environment: SAP HANA, SAP BW, SAP SLT, SAP BusinessObjects 3.x and 4.x, BOBJ CMC – CCM, Oracle DB, SQL Server 2012 & 2014, IBM DB2, SAP Sybase, Microsoft .Net 4.x, Microsoft Azure cloud

BI Developer: Operational and Financial Datastore

AEGON Religare Financials
12.2012 - 04.2014
  • Company Overview: Life Insurance and Investment Company
  • Requirement gathering from users
  • Design and maintain ETL jobs in ODS and Data Warehouse
  • Design Business Objects Reports and Universe
  • Develop Oracle procedures/ packages and other objects to accommodate business requirements
  • Design dashboards for finance and audit
  • Developed reports specific with these Delegated Search, Database Delegated, Open Document and Data tracking new functionalities
  • Data archiving and retrieval ensures the completion of projects within the agreed statement of work
  • Provided the necessary archiving execution of archiving objects that accompany a typically scoped SAP business environment
  • Published Reports to CMC (Central Management Console) and involved in Scheduling and exporting the reports in different Formats
  • Involved in development of BW Objects InfoObjects, InfoCube, Multiprovider, Transformation, DTP, Datasource
  • Created the reports using Business Objects functionality’s like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae’s etc
  • Organized data in the report Inserting Filters, Sorting, Ranking and highlighting data
  • Life Insurance and Investment Company
  • Environment: SAP BusinessObjects BI XI R/3, SAP R/3 BW 3.5, SAP BO DataServices, BOBJ CMC – CCM, Oracle DB, Linux

SAP BO-BI Developer – Financial Data Store

Genworth Financials
08.2011 - 11.2012
  • Company Overview: General Insurance Company
  • Design packages and procedures for complete ETL
  • Design MTD, YTD dashboards for management reporting
  • Complete project life cycle with multiple testing and required documentations
  • Deployment of project in Linux based environment with design of shell scripts
  • Unit testing of individual module
  • Worked with functional consultant for mapping the source data (R/3) to target Data Sources in BI
  • Configured Custom cubes, Aggregates, queries
  • Monitored the development of data model to satisfy the functional requirement by implementing queries and cubes using business content
  • Worked on transformations to translate the business processes into end reporting objects
  • Involved in Data Modeling, Extraction loading and reports creation in BEx Query designer
  • Involved in performing production support activities
  • Actively involved in Rectification of Load failure Errors like Master Data Loads, Transactional Loads
  • Manually loading data to data targets on daily basis, Weekly basis and monthly basis
  • General Insurance Company
  • Environment: SAP R/3 BW 3.5, SAP BusinessObjects BI XI R/3, SAP BEx Analyzer, Oracle 10g, SQL Server 2005, Linux

Internship - SAP BO and BW Developer – MIS

State Bank of India
02.2011 - 08.2011
  • Company Overview: Indian Public Sector Bank
  • Design and Maintain BusinessObjects Infoview reports
  • Design Desktop Intelligence reports
  • Design and modify Universe using Universe design tool
  • Design MTD, YTD dashboards for management reporting
  • Execute and modify PL/SQL packages to test BO outputs
  • Coordinate with Users for UAT, Use Case and Production sign off
  • Maintain and modify BW jobs for all database changes to accommodate new structures
  • Complete project life cycle with multiple testing and required documentations
  • Worked with functional consultant for mapping the source data (R/3) to target Data Sources in BI
  • Configured Custom cubes, Aggregates, queries
  • Worked on transformations to translate the business processes into end reporting objects
  • Involved in performing production support activities
  • Actively involved in Rectification of Load failure Errors like Master Data Loads, Transactional Loads
  • Manually loading data to data targets on daily basis, Weekly basis and monthly basis
  • Indian Public Sector Bank
  • Environment: SAP R/3 BW 3.5, SAP BusinessObjects BI XI R/3, Oracle 10g, 9i, PL/SQL, Linux

Education

MBA - Artificial Intelligence & Machine Learning

Dr. D. Y. Patil University
Maharashtra
07.2024

Bachelor of Engineering - Computers

Vivekanand College
Mumbai, Maharashtra
06-2011

Skills

  • Data Modeling and analysis
  • ETL processes and Data warehousing
  • SAP HANA and SAP BusinessObjects
  • Performance tuning and Optimization
  • Databases: IBM DB2, Oracle, SQL Server, Postgres, MS Office Access
  • Financial Reporting, Dashboards, SSRS Reporting
  • Technical analysis and Software architecture design
  • Software development life cycle (SDLC), version control
  • AWS Cloud computing and Data migration planning
  • Trained in AI-ML, SSIS Packages

Accomplishments

  • Supervised team of 20 staff members.
  • Achieved successful automation of all environment deployments by completing AWS Blue/Green deployment for EC2 applications with accuracy and efficiency.
  • Collaborated with teams from other organizations too in the development of Retirement AWS cloud migration.
  • Resolved product issue through consumer testing.
  • Documented and resolved Mainframe to Linux DB2 migration issues which are used as standard syntax for any DB2 stored procedures development right now.

Awards

  • Transamerica Corporation
  • Surpass Award for high incident resolution and technical expertise
  • Spot Award for timely completion of a major project
  • Surpass Award nominee for resolution of quarter end financial reporting issues.
  • Edelweiss Financial Services
  • Certificate of appreciation for successfully implementing critical projects
  • Emerging Leader Award: Member of Emerging leader squad for best team work and managing critical issues.
  • BNP Paribas ISPL
  • SPOT Award for resolving the longest running issue permanently.
  • Best Developer recognition for migrating all the reporting environment between completely two different technologies
  • 5 STAR Award for best performance in team
  • Tata Consultancy Limited
  • TCS Gens Smiles award: Appreciation for outstanding performance
  • TCS Gems Innovation award: For resolving multiple client issues
  • Star of the Month: Timely completion of big client project
  • AIEEE Robot Soccer team winner in Engineering College.

Workshops Training Programs

  • AWS Certified Cloud Practitioner
  • Trained in SAP BO XI and 3.x
  • Trained in SAP HANA Modelling
  • Trained in SAP ERP 7.0 with FICO, FS-PM, FS-PQM application
  • Microsoft Project Life Cycle Management
  • Google Analytics certified

Certification

· AWS Certified Cloud Practitioner

· Trained in SAP BO XI and 3.x

· Trained in SAP HANA Modelling

· Trained in SAP ERP 7.0 with FICO, FS-PM, FS-PQM application

· Microsoft Project Life Cycle Management

· Google Analytics certified

Languages

English
Professional Working
Marathi
Native or Bilingual
Hindi
Professional Working

Timeline

Tech Lead of Business Intelligence Team

Transamerica Corporation
03.2019 - Current

Business Intelligence – Finance and Operation

Edelweiss Financial Services
11.2017 - 02.2019

SAP BI Lead – New York Fixed Income Trades

BNP Paribas ISPL
04.2014 - 11.2017

BI Developer: Operational and Financial Datastore

AEGON Religare Financials
12.2012 - 04.2014

SAP BO-BI Developer – Financial Data Store

Genworth Financials
08.2011 - 11.2012

Internship - SAP BO and BW Developer – MIS

State Bank of India
02.2011 - 08.2011

MBA - Artificial Intelligence & Machine Learning

Dr. D. Y. Patil University

Bachelor of Engineering - Computers

Vivekanand College
Pranay Rajput