Venkata Ranjith Kumar Nimmalapalli
Brussels
Summary
Detail-focused Data Analyst with knowledge in data warehousing, process validation and business needs analysis. Proven to understand customer requirements and translate into actionable project plans. Dedicated and hard-working with passion for Big Data. Seasoned collaborator experienced in meeting needs, improving processes and exceeding requirements in team environments. Diligent worker with strong communication and task prioritization skills.
Proactive Data Analyst with 14+ years of professional experience in various DWH Projects.
Overview
15
15
years of professional experience
1
1
Certification
Work History
Data Analyst
International Post Corp
07.2020 - Current
- Produced monthly reports using advanced Excel spreadsheet functions.
- Utilized data visualization tools to effectively communicate business insights.
- Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.
- Improved decision-making processes with accurate data analysis and visualization techniques.
- Participated in requirements meetings to understand business needs.
- Collaborated with cross-functional teams to ensure data integrity and accuracy, resulting in better-informed decisions.
- Managed large-scale databases to ensure timely access to critical information for key stakeholders.
- Integrated multiple sources of disparate data into cohesive datasets using ETL processes, improving overall analytic capabilities.
- Collaborated with business-unit leaders to identify and prioritize problems.
- Reduced operating costs by automating manual data processes using scripting languages such as Python or R.
- Analyzed data to identify root causes of problems and recommend corrective actions.
- Created data models to support decision-making processes.
- Provided technical support for troubleshooting analytics and reporting issues.
- Implemented business intelligence solutions to increase operational efficiency.
Technical Data Analyst
Proximus
05.2016 - 06.2020
- Working as Onsite coordinator and leading both onsite and offshore team in Developing and Operational Deliverables.
- Working as an Lead Analyst, and resolving all unresolved and high technical issues related to PowerBI, ETL (informatica as etl), BO , Python & Shell Scripting , PL/SQL, Oracle and Web services
- Performed ad-hoc analyses as requested by senior leadership, addressing critical questions with speed and accuracy.
- Mentored junior analysts on best practices in data management and analysis techniques, fostering professional development within the team.
- Improved customer segmentation through detailed profiling and cluster analysis, driving targeted marketing campaigns.
- Optimized database performance with comprehensive data cleansing and standardization procedures.
- Identified and analyzed project risks and developed mitigation strategies.
- Closely working with Business Users and Client manager to prioritize critical issues and resolving them to avoid necessary business impact
ETL Lead Developer
Infosys Ltd.
01.2013 - 03.2016
- Created Optimized Invoicing Application , to upload monthly customer invoices to Calivi application .
- Followed agile way of working , bi-weekly deliverables and Scrum calls and workload estimation .
- Responsible for E2E deliverables until production , Defect handling and bug fixing .
- Convert functional understanding to technical solution.
- Collaborated with business intelligence staff at customer facilities to produce customized ETL solutions for specific goals.
- Designed integration tools to combine data from multiple, varied data sources such as RDBMS, SQL and big data installations.
- Managed data quality issues during ETL processes, directing qualitative failures to team lead for amelioration.
- Designed and created ETL code installations, aiding in transitions from one data warehouse to another.
ETL Informatica Developer
Computer Science Corporation, CSC
05.2009 - 12.2012
- Extraction, transformation and loading of data from different source systems like flat files, SQL Server, DB2 etc.
- Prepare Migration documents for all objects (sources, targets and reusable transformations) and maintain quality of project as per standards
- Proactively identified potential risks within projects, taking necessary steps to mitigate them before they became critical issues.
- Contributed insights during design reviews that led to more effective solutions being implemented within project scope.
- Enhanced data integration by designing and developing efficient ETL processes using Informatica PowerCenter.
- Maintained adherence to established coding standards while delivering high-quality deliverables on time.
Education
Master of Computer Applications - Computer Engineering
JNTU University
Kakinada01.2009
Skills
- Technical: Data Modelling(Both LDM and PDM)
- Methodologies: Agile, Waterfall Model
- Domains: Telecom, Insurance, Postal Network
- Management: E2E Project Lead, Operations Lead, Data Analyst
- Databases: Oracle Exadata 9i/10g/11g R2/12c,SQL ,Hive, Relational (RDBMS)
- ETL Tools: ETL (Informatica 10x),Pentaho, SAP BODS , SSIS, PL/SQL Developer
- Reporting : MSTR , Power BI, Power Query
- Scripting: Unix shell and Python Programming
- Modeling : Power Designer (DB UML) and MS Visio(Functional Process flow)
Certification
- Informatica Mapping Design 'S' Professional Certification
- Informatica U - Power Center 8 Advanced Mapping Design
- INS -21 Property & Liability Insurance Principles Certification
Languages
English
Bilingual or Proficient (C2)
French
Beginner (A1)
Timeline
Data Analyst
International Post Corp
07.2020 - Current
Technical Data Analyst
Proximus
05.2016 - 06.2020
ETL Lead Developer
Infosys Ltd.
01.2013 - 03.2016
ETL Informatica Developer
Computer Science Corporation, CSC
05.2009 - 12.2012
Master of Computer Applications - Computer Engineering
JNTU University
Similar Profiles
Marcus HinesMarcus Hines
Service Delivery Agent at Canada Post Corp.Service Delivery Agent at Canada Post Corp.
Malhar AzamMalhar Azam
Letter Carrier at Canada Post Corp.Letter Carrier at Canada Post Corp.
Tannis AtchisonTannis Atchison
Driver Trainer Specialist at Canada Post Corp.Driver Trainer Specialist at Canada Post Corp.