CHIRANJEEVI IANALA
Hyderabad
Summary
Highly skilled Lead Data Analyst with comprehensive background in data analysis, strategic planning and project management. Possess strong skills in interpreting complex data, identifying trends and formulating strategies to drive business growth. Demonstrated ability to lead teams effectively, foster collaboration and deliver impactful results. Successfully led numerous projects to completion, driving efficiency and profitability for companies.
Insightful professional in the realm of business intelligence, known for unparalleled productivity and efficiency in task completion. Specialize in data warehousing, predictive analytics, and visualization techniques. Excel in critical thinking, problem-solving, and effective communication, ensuring clarity and actionable insights in complex scenarios.
Overview
15
15
years of professional experience
1
1
Certification
Work History
Lead Analyst
BNY Mellon
06.2020 - Current
- Created and designed business intelligence databases and spreadsheets for stakeholders to make their business decisions.
- Developed custom queries using SQL programming language to extract meaningful information from large datasets.
- Performed ETL(Alteryx Analytics workflows) tasks such as transforming raw source files into a usable format for analytics purposes.
- Collaborated with stakeholders to define business requirements and objectives related to data analysis projects.
- Created dashboards using Tableau to visualize data for stakeholders.
- Recognized by management for providing exceptional customer service.
Team Lead - Analytics
UnitedHealth Group
10.2015 - 05.2020
- Company Overview: OptumRx specializes in the delivery, clinical management and affordability of prescription medications and consumer health products
- Understanding and analyzing present business practice in terms of BRS
- Analyzed the different source system data to be used in building the Target System.
- Developed and supported the Extraction, Transformation, and Load process (ETL) using SSIS and Talend jobs.
- Designed and deployed SSIS, Talend jobs/packages for the ETL process
- Extracted data from different sources like Oracle, Excel and Flat files and loaded into target SQL server
- Monitor daily jobs running in production as part of data migration
- Developed and deployed reports (SSRS), and also developed Tableau dashboards, and published them on the respective servers.
- Developed business dashboards by using Tableau, Alteryx analytics
- Published 40+ Tableau dashboards into Tableau server
- Initiate Alteryx tool and successfully completed high level workflow which connect and process data from HDFS server
Sr Software Engineer
TCS
05.2010 - 10.2015
- Company Overview: HDFC ERGO General Insurance Company Limited is a joint venture between Housing Development Finance Company (HDFC) and ERGO, HDFC ERGO offers General Insurance products in the Commercial, personal accident, travel, health, motor, and home sectors
- Understanding and analyzing present business practice in terms of URS
- Analyzed the different source system data to be use in building the Target System
- Migrating DTS packages in to SSIS packages
- Developed and supported Extraction, Transformation and Load process (ETL) using SSIS
- Designed and deployed SSIS packages for the ETL process
- Extracted data from different sources like DB2, Excel and Flat files and loaded into target SQL server
- Monitor daily jobs running in production as part of data migration
- Handled slowly changing dimensions type I and II
- Enforced the Business Rules by creating constraints
- Configured linked servers by using SSMS
- Created and implemented SQL Server agent jobs for the ETL process
- Involving Cubes (SSAS) creation and deployed on destination servers
- Developed and deployed Reports (SSRS)
- HDFC ERGO General Insurance Company Limited is a joint venture between Housing Development Finance Company (HDFC) and ERGO, HDFC ERGO offers General Insurance products in the Commercial, personal accident, travel, health, motor, and home sectors
Education
M.C.A - Computer Applications Development
Anna University
Chennai04-2009
Bachelor of Science - Computer Science
Acharya Nagarjuna University
06-2006
Skills
- MS SQL Server Query Optimization
- Oracle Database Management
- Workflow Automation
- ETL development
- SSIS, SSAS, and SSRS
- Crystal Reports
- Tableau Data Visualization
- Alteryx Proficiency
- Power BI Data Visualization
- KNIME Analytics
- Visual Basic Programming
- Skilled in Python Programming
- ASPNET
- Front-End Markup Skills – HTML
- XML Proficiency
- Stakeholder management
- Data governance
- Azure Data Solutions (Basic Understanding)
- Performance improvement
Certification
- Alteryx Designer core certified professional
- Alteryx Designer Advanced certified professional
Timeline
Lead Analyst
BNY Mellon
06.2020 - Current
Team Lead - Analytics
UnitedHealth Group
10.2015 - 05.2020
Sr Software Engineer
TCS
05.2010 - 10.2015
M.C.A - Computer Applications Development
Anna University
Bachelor of Science - Computer Science
Acharya Nagarjuna University
Similar Profiles
ANKUR WADHEANKUR WADHE
Associate I at Bank of New York Mellon (BNY Mellon)Associate I at Bank of New York Mellon (BNY Mellon)
Vishal TilwaniVishal Tilwani
Associate, AML/Prevention/KYC Representative at BNY Mellon (Bank of New York Mellon)Associate, AML/Prevention/KYC Representative at BNY Mellon (Bank of New York Mellon)
Sonali VetalSonali Vetal
Associate Quality Engineer at BNY Mellon TechnologyAssociate Quality Engineer at BNY Mellon Technology