Rahul Chandra
Bengaluru
Summary
Insightful Manager with experience directing and improving operations through effective employee motivational strategies and strong policy enforcement. Proficient in best practices, market trends and regulatory requirements of industry operations. Talented leader with analytical approach to business planning and day-to-day problem-solving.
As a seasoned data engineer, I have a proven history in designing and implementing robust data solutions. I bring a wealth of expertise in data engineering and advanced analytics from various industry settings. Over the years, I have mastered transforming data into valuable business insights that drive growth across various sectors, including finance, retail, and manufacturing. My proficiency spans a wide range of database technologies, ETL processes, and data warehousing, and I excel in programming languages such as Python and SQL. I successfully delivered complex data projects and collaborated with cross-functional teams to deliver data-driven solutions. I am committed to excellence, leveraging best practices and staying current with the latest trends in data engineering to ensure higher standards of deliverables.
Overview
21
21
years of professional experience
7
7
years of post-secondary education
1
1
Certification
Work History
Manager
Capgemini
Bengaluru, Karnataka
04.2023 - 03.2024
- Buyout from GE Digital
Sr. Data Engineer
GE Digital
Bengaluru, Karnataka
05.2019 - 03.2023
- Managed wide range of on-prem and cloud databases during various development cycle for digital collaboration software and for migration of On-Prem Oracle Database to Postgresql Azure Cloud
- Designed and developed data warehouse and analytics solutions to measure usage and user engagement of various collaboration software modules during transition from legacy to NextGen software
- Built dashboard to monitor the health the Azure SQL Database
- Worked on various SOX and divestiture initiatives in the Organization
- Worked on replacing the internal Attivio based search engine with Elasticsearch, resulting infrastructure cost savings
- Indexing data, ILM, enabling Lexical and Semantic Search, ECS, EQL
- Buyout from GE Digital
- Accomplished multiple tasks within established timeframes.
System Analyst
Blackstone Technologies
03.2017 - 06.2017
- Designed and coded variety of subroutines to implement various business process
- Added new reports and built Analytics dashboard for an existing application
Sr. Data Warehouse Engineer
Retail Solutions
05.2016 - 12.2016
- Maintaining and supporting the ETL layer of BI Application
- Designed and Build enhancements and new functionality and made bug fixes
- Developed new reusable APIs for use within the ETL layer
- Made performance tuning enhancements for ETL Process
- Performed current system analysis to understand how different systems in organization interact with each other and their impact
Data Analyst
Better Finance
05.2014 - 10.2014
- Translate data from structured database into information that help companies measure key performance indicators
- Built Jasper reports and dashboards — using SQL connecting to MySQL database
- Used SQL to perform source data analysis
- Modified existing reports for performance improvement and data integrity
- Data Modeling for Data warehouse
- Built ETL jobs to populate data warehouse to analyze trends and patterns for business KPls
Business Analyst
Gymboree
07.2013 - 10.2013
- Writing PL/SQL Stored Procedures, Packages, and Triggers to implement the business rules specific to the retail applications
- Built new ETL jobs to meet data needs for new reports
- Production support for existing applications
- Developed Dimension Model (Dimensions and Facts), Source-Target Data Mapping, Data Profiling
- Collaborated with different IT and Business teams to standardize development process
- Facilitated project review meetings with project stake holders to track project deliverables, resolves risks and change requests
- Steered requirement gathering meeting to properly understand and document business requirements
Sr. Developer
Vitech Systems
08.2011 - 05.2013
- Designed and built various subroutines to implement the business process
- Built Analytics dashboard for the application
Sr. Developer
Office Depot
03.2008 - 03.2011
- Worked on the implementation, support and maintenance of various Retail Applications
- Oracle Retail Merchandising System (RMS)
- Retail Demand Forecasting (RDS)
- Promotions Application
- Purchase Planning Application
Sr. Developer
UST Global for Hanes Brands Inc
10.2006 - 01.2008
- Overall production support issues
- Create functional and technical design specifications for enhancements and bug fixes, making estimates
- Develop stored procedures, packages, triggers, and other Oracle database logic
- Performing code review for the code changes from offshore
- Performing Unit Testing, Integration testing for the new bug fixes and Enhancements on Development and Test Environments
- Responsible for all the deliverables and coordination with offshore team members
Technical Leader
iGate Systems for Cummins Inc
Columbus, Indiana
05.2003 - 10.2006
- Worked on Distributor Process and Systems of North America
- Gathering high-level requirements from client
- Analyzing and translating those requirements into written plans
- Translate high-level business requirements into low-level tasks and then design Oracle PL/SQL code to accomplish these objectives
- Create functional and technical design specifications for development efforts
- Develop complex Stored Procedures, Functions, Packages, Triggers, and other database logic
- Developed new Oracle Forms and Reports and modified existing ones to incorporate new business & enhancements
- Design, analyze, and develop efficient table and index design, monitor and tune performance and execution plans to improve performance
- Designing components and performing complex Coding/Programming
- De-bugging and manual Testing
- Worked with development team to improve Oracle application performance and resolve real-time problems as they occur
- Prepare requirements specifications, design documents and unit test plans
- Performing Unit Testing, Integration testing and infant care for new modules and enhancements in production
- Providing estimates for completion times and required resources for assigned projects and program initiatives
- Providing mentoring and/or guidance on coding & debugging
- Performing code Reviews and Design Reviews
- Participating in user group meetings to understand new enhancements and opportunities in existing problem areas
- Resolving user issues/tickets and consistently maintained high SLA
- Responsible for overall production support issues for modules such as Inventory, Purchase Order management, Sales Order Management and NDH
Systems Analyst
IGate Global Solutions
Bengaluru, Karnataka
05.2003 - 04.2005
- Collaborated with cross-functional teams to develop innovative solutions for business challenges.
- Created detailed documentation for both internal reference and client-facing presentations, improving communication between stakeholders.
- Gathered requirements and performed gap analysis through design workshops with users.
- Provided expert technical support, reducing system downtime and minimizing disruptions to daily operations.
Education
MBA - International Business
Florida Atlantic University
Boca Raton, FL 01.2011 - 05.2012
Master of Science - Computer Application
Dr. B. R. Ambedkar University, Agra
Agra, UP 05.1997 - 08.1999
Bachelor of Science -
Nagpur University, Nagpur
Nagpur, MH 03.1994 - 03.1997
Skills
Python
SQL
Oracle
MySQL
Postgresql
Teradata
SQL Server
Performance tuning
Cassandra
Elastic Search
Databricks
Redis
NumPy
Pandas
PySpark
Scikit-learn
OpenCV
Matplotlib
NLTK
Elastic
Kafka
FLINK
Airflow
Apache Airflow
Apache Nifi
DBT
PowerBl
Jasper
Tableau
Talend
Datastage
Oracle Forms
Oracle Reports
Git
Docker
Kubernetes
Atlassian
Jira
ServiceNow
Azure
AWS
Team leadership
Operations management
Strategic planning
Decision-making
Certification
Please see LinkedIn profile also mentioned in the title.
Timeline
Manager
Capgemini
04.2023 - 03.2024
Sr. Data Engineer
GE Digital
05.2019 - 03.2023
System Analyst
Blackstone Technologies
03.2017 - 06.2017
Sr. Data Warehouse Engineer
Retail Solutions
05.2016 - 12.2016
Data Analyst
Better Finance
05.2014 - 10.2014
Business Analyst
Gymboree
07.2013 - 10.2013
Sr. Developer
Vitech Systems
08.2011 - 05.2013
MBA - International Business
Florida Atlantic University
01.2011 - 05.2012
Sr. Developer
Office Depot
03.2008 - 03.2011
Sr. Developer
UST Global for Hanes Brands Inc
10.2006 - 01.2008
Systems Analyst
IGate Global Solutions
05.2003 - 04.2005
Technical Leader
iGate Systems for Cummins Inc
05.2003 - 10.2006
Master of Science - Computer Application
Dr. B. R. Ambedkar University, Agra
05.1997 - 08.1999
Bachelor of Science -
Nagpur University, Nagpur
03.1994 - 03.1997