Oracle SQL
Babu Perumal
Business Analyst
Chennai,TN
Summary
Highly analytical and action-oriented business professional with four years of entrepreneurial experience coupled with seven years of experience in IT industry. Agile and forward-thinking individual motivated by abstract business challenges with commitment to excellence.
Overview
3
3
Certifications
6
6
years of post-secondary education
11
11
years of professional experience
Work History
Chief Executive Officer
Suryabala Motors
Chennai, Tamilnadu
10.2017 - Current
- Drove year-over-year business growth of an OEM authorized automotive dealership while leading operations, strategic vision and long-range planning. Managed 100+ employees under different teams to enable cohesive and successful cross-functional team building.
- Applied performance data to evaluate and improve operations, target current business conditions and forecast needs. Reduced customer product delivery timeline by more than 100% to 2 days against industry standard of one week and improved sales conversion to 60% from 35% by leveraging technology and streamlining processes through data driven decisions.
- Built productive relationships with various external stakeholders including but not limited to OEM,Banking/finance partners, competitors and customers to support strategic business objectives.
Test Lead
HCL Technologies
Chennai, Tamilnadu
12.2014 - 10.2017
- Collaborated with developers and product owners in an agile development environment to stay current on product features and intended functionality.
- Wrote and optimized test cases to maximize success of manual software testing with consistent, thorough approaches.
- Test lead for a team on-boarding new ETL testing project and was responsible for Knowledge transformation and documentation from existing client vendor.
IT Analyst
Tata Consultancy Services
Chennai, Tamilnadu
03.2010 - 11.2014
- Key member of testing team in enterprise scale data migration project. Responsible for data analysis and verification to ensure successful data transformation in ETL.
- Built data validation models using complex SQL queries and small scale automation using Java fixtures to validate successful migration of multi dimensional data from legacy systems to latest technology.
- Continuous fine tuning of SQL queries to improve query processing time and Java fixtures used for automation improved defect slippage ratio and test efficiency by more than 30%.
- Hands on experience in creating and managing test artifacts including Test planning documents, Test scenarios and scripts with strong understanding of software development lifecycle.
Education
Bachelor of Engineering - Mechatronics Engineering
Sri Krishna College of Engineering And Technology
Coimbatore 08.2005 - 05.2009
Higher Secondary - Mathematics And Science
VHN Boys Higher Secondary School
Madurai 06.2003 - 06.2005
Skills
Business and Operations Management
ETL testing and SDLC
Data modelling and Analysis
Data Visualization and Reporting
Summary of Skills
Oracle SQL
- Writing and refactoring complex SQL queries including joins,nested sub-queries and grouping.
ETL
- Deep understanding of ETL concepts and architecture including Dimensions, facts, schemas and reference data.
- Worked with dynamic large datasets in an ETL environment and comfortable in exploratory testing of data to derive useful insights.
- Hands on experience in transforming and wrangling data as per business requirements.
Data Analytics and Visualization
- Thorough understanding of data viz design principles and data requirements to derive useful insights.
- Hands on experience in R programming to Collect,wrangle and manipulate data using dplyr and tidyr packages.
- NULL value handling and data imputation in R and Oracle SQL.
- Data visualizations in R using ggplot2 package and descriptive statistical analysis.
- Ability to connect to different data sources, establish data relationships and data visualizations using Tableau.
Business analysis and management
- Effective communication with different stakeholders across cross-functional teams for continuous improvement in business processes.
- Proven and demonstrated ability to work in ambiguous,highly agile and deadline oriented business environment.
- Strong orientation towards data driven decision making.
Software
Tableau and R programming
SDLC and SCRUM methodologies
ETL Concepts and Workflow
Microsoft Office Suite , JIRA and ALM
Certification
Google Certified Data Analyst
Timeline
Google Certified Data Analyst
06-2021
Chief Executive Officer
Suryabala Motors
10.2017 - Current
Test Lead
HCL Technologies
12.2014 - 10.2017
ITIL V2 Associate
04-2013
ISTQB Foundation Level
09-2012
IT Analyst
Tata Consultancy Services
03.2010 - 11.2014
Bachelor of Engineering - Mechatronics Engineering
Sri Krishna College of Engineering And Technology
08.2005 - 05.2009
Higher Secondary - Mathematics And Science
VHN Boys Higher Secondary School
06.2003 - 06.2005