Summary
Overview
Work history
Education
Skills
Interests
Languages
Timeline
Generic

Balakishan Galipelli

Eastham,London

Summary

Data Analyst I am looking forward to associating myself as an Associate with an organization of quality environment where knowledge can be shared and dedicate my skills to the development of self and the organization served. Dedicated Associate with extensive experience collaborating with clients, promptly identifying needs and recommending products and services to meet targets. Enthusiastic individual with excellent communication and organisation skills seeks experience in customer-facing administration role. Supports busy, productive environments by working with focus, drive and attention to detail.

Overview

16
16
years of professional experience

Work history

Data Analyst

Cognizant Technology Solutions
Hyderabad
11.2022 - 11.2023
  • Years experienced Financial analyst and Informatica ETL Developer with a proven track record of establishing processes & methodology standards for all phases of an Enterprise Data Warehouse
  • Proficient in deploying ETL tools for designing scalable applications
  • Adept at the implementation of the full development life - cycle of Data warehousing & deploying ETL programs for supporting data extraction via Informatica Power Centre to deliver compelling business value for clients
  • Roles and Responsibilities :
  • Using data mining to extract information from data sets and identify correlations and patterns
  • Organizing and transforming information into comprehensible structures
  • Using data to predict trends in the customer base and the consumer population as a whole
  • Performing statistical analysis of data
  • Using tools and techniques to visualize data in easy-to-understand formats, such as diagrams and graphs
  • Preparing reports and presenting these to management or clients
  • Identifying and recommending new ways to save money by streamlining business processes
  • Monitoring data quality and removing corrupt data
  • Communicating with stakeholders to understand data content and business requirements
  • Worked with multi-cultural teams and handled teams form different locations
  • Worked on data integration projects, Metadata and Deduplication of data processes
  • Analyze & understand the client's requirements or business cases & break them into achievable work items (i.e
  • User stories & Features)
  • Participate in various scrum calls (i.e
  • Grooming, PI Planning, Stand-up calls etc.) and share valuable feedback with team
  • Processes reviewed as per the Lean principals
  • Prioritize the user stories, features /product backlogs based on priorities, business strategies and dependencies
  • Perform “User Acceptance Test (UAT) and regression testing and share feedback with scrum team
  • Grooming Product backlogs and prioritize the feature/user stories for the fix
  • Prepare project plan in accordance with project framework, standards and procedures
  • Check the possibility to eliminate repetitive processes, over processing and waste elimination within the teams with the help of RPA and blue prism
  • Identify ongoing issues/bugs etc, and co-ordinate with scrum team for the fix
  • Prepare Timeliness, Forecast, Budgeting, Team Performance Reports and share them with senior stakeholders for data analysis and decision making
  • Resolve various internal & external Client Questions & ERA's by conducting the route cause analysis on it
  • Evaluation of standard time to calculate the analyst performance with comparison with their actual output
  • Prepare “Procedure documents” or “User Manuals” which helps the team to perform their day-to-day activities in workflow
  • Working Tools and Skills:
  • Bit-bucket
  • Airflow
  • Data Bricks
  • Snowflake
  • SQL
  • Advanced Excel Power User
  • AWS
  • Informatica Power Center
  • Analysed large datasets, drawing meaningful conclusions and providing actionable recommendations.
  • Participated in requirements meetings and data mapping sessions to understand business needs.
  • Generated reports from extracted data for analyses.
  • Coordinated cross-functional teams in delivering data input, extraction and analyses.

AWS Associate

Cognizant Technology Solutions
Hyderabad
11.2022 - 11.2023
  • SDAH Application :
  • Every day SDAH Dags monitoring in Airflow production (As per schedule)
  • IF SDAH Dags are Failed we run dags again by using Clear or Trigger
  • Dags are different way dependent Dags and inter depended Dags
  • Dags are failed Checking For why Dag is failed
  • If any Files missed, OR Misplace and other index errors
  • Dags Failed Issues related raised tickets for Platform team
  • Solved CRQS from customers
  • Customer required to Enhance requirement changes in Dags
  • SQL code related monitoring every day in Snowflake
  • Source related gathering information from confluence application
  • Checking Errors in Databricks in S3 buckets
  • Creating validation and loading the rejected records into the relevant tables and send to users for re-submitting GTX_US Application:
  • As per schedule GTX _US Dags monitoring in Airflow Production
  • IF Dag is Failed, we run Dag again in Airflow prod (Trigger)
  • Dags Error related more clarity checking In S3 bucket in Databricks application
  • Checking For any Failed dags related files missed or Other unnecessary duplicate files load
  • If duplicate Files load in Dag inform to platform teams
  • Raise tickets regarding from Dag Failed Errors
  • SQL code related monitoring every day in Snowflake
  • Skills for developing, deploying & debugging cloud applications
  • Dag status mail to Client
  • Maintained positive and professional demeanor under pressure, handling difficult situations with composure and tact.
  • Completed assigned tasks quickly and accurately, using strong time management and task prioritisation.
  • Researched industry trends and innovations, keeping firm grasp on emerging technology and best practices.

Informatica Associate

MIDAS MDAH Application
  • A highly dedicated and Dynamic Professional around 6+ years of Experience in Data warehouse implementation using Informatica PowerCenter tool as ETL-Developer
  • Main areas of expertise are analyzing, developing and testing the data warehousing projects
  • Experience in the Data Warehousing using Data Extraction, Data Transformation and Data Loading
  • Used ETL process to Extract, Transform and Load the data into stage area and data warehouse
  • Extensively used Informatica client tools - Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Informatica Repository Manager, Excellent experience in Design & Implementation of ETL processes, Transformation, mappings and loading using 10.x
  • Extensive experience in creation of ETL mappings and Transformation to reflect business rules using Informatica Power Center to move data from multiple sources into target area
  • Most of the transformations were used like the Source qualifier, Update strategy, joiner, lookup, Filter, Router, Seq Generator, Union, Rank, Aggregator and Sequence generator
  • Experienced in integration of various relational and non-relational sources such as Oracle Tables, and Flat Files
  • Experienced in Performance Tuning of Mappings, Sessions
  • Having Good Knowledge over Dimensional Modeling like Star /Snow Flake Schemas
  • Experienced in using parameter files, mapping parameters in mappings
  • Experienced in implementing Incremental load by using Mapping variables to load from Source to stage on daily Basis
  • Experienced in implementing SCD type-1 and Type-2 to load the Dimension tables
  • Experienced in implementing Un-Connected and Dynamic Lookup.

Informatica Developer, Developer

US BANK Crop
  • Fidelity Financial Services is leading Financial company in United States of America
  • They offer house loans in USA
  • Their loyalty programs help customers afford their dream products
  • Their branded credit cards helps them earn points towards what they want most
  • And their real-time approval technology helps them do it all on the file.
  • Project no :2
  • Project, Environment Informatica 10.5, Oracle 11g Description:
  • MIDAS MDAH application (Novartis)
  • This Applications helps the Client to manage company's interaction with current and future customers
  • Novartis do the daily Follow-ups with their customers regards the pending account, status and also, they have remainder in which it reminds the Novartis to follow particular customers
  • This application helps to get various reports and get the information such as Daily-wise Reports, Novartis patient -Monthly reports, Master Reports, Follow-up and customer History reports
  • Roles and Responsibilities
  • Mainly involved in ETL developing Creating the mappings and transformations using Informatica
  • The data from the staging area was transformed and loaded to the target on Oracle using Informatica Tool
  • Responsible for the development of Metadata transformations and establishing load schedule
  • Optimizing/Tuning mappings for better performance and efficiency
  • Extensively used transformations like Filter, Aggregation, Joiner, Expression, Lookup, Router, and Update Strategy.

Associate

SLA IT Solutions Limited
Bristol
06.2023 - Current
  • Project #1 SNL Financials Client SNL Financials Role Informatica Developer Environment Informatica 9.6, Oracle 11g Description:
  • This Applications helps the Client to manage company's interaction with current and future customers
  • Snl financials do the daily Follow-ups with their customers regards the pending account, status and also they have remainder in which it reminds the SNL Bank to follow particular customers
  • This application helps to get various reports and get the information such as Daily-wise Reports, SNl Bank-wise reports, Master Reports, Follow-up and customer History reports.
  • Monitored KPIs and reported on performance to address corrective action needs.
  • Applied mastery in Microsoft Office Suite to deliver top-quality administrative support.
  • Identified inefficiencies and suggested process improvements to reduce operation backlogs.
  • Maintained positive and professional demeanor under pressure, handling difficult situations with composure and tact.

Associate

Cognizant Technology Solution Limited
11.2021 - 11.2022
  • Project #1 US BANK Crop

AWS

Project : Novartis
11.2021 - 11.2022
  • Project #1 Novartis Client Novartis Pharmaceutical company Role AWS Developer Description:
  • As a part of Novartis AWS developer is responsible for setting up, maintaining, and evolving the cloud infrastructure of web applications
  • AWS developers are expected to understand the core AWS services and apply best practices regarding security and scalability
  • Roles and Responsibilities
  • Mainly involved in AWS Related Dag's Monitoring
  • Enhancement requirement solved for Customer CRQs
  • AWS-platform as a service (Pass) and infrastructure as a service (IasS)
  • Extensively used applications like Bitbucket, Databricks, GitHub, snowflake, and Airflow
  • A bucket is a container for objects stored in Amazon S3
  • You can store any number of objects in a bucket and can have up to 100 buckets in your account Collaborated with various team & management to understand the requirement & design the complete system
  • Experience in guiding the classification, plan, implementation, growth, adoption and compliance to enterprise architecture strategies, processes and standards
  • Involved in the end-to-end deployment process
  • Creating validation and loading the rejected records into the relevant tables and send to users for re- submitting
  • On boarded multiple international clients as Ubuntu OpenStack Cloud users
  • Skills for developing, deploying & debugging cloud applications
  • Any Dugs failed we will try to re success of that dugs again failed checked in data bricks and work flow tools, Meet Deadlines Goal Oriented
  • Committed to continuous learning Technical and Financial knowledge Highly Organized
  • Self-motivated Collaborative team player
  • Skilled in Advanced MS Excel Power User, Informatica, AWS SQL & OTHERS
  • Roles and Responsibilities
  • Mainly involved in ETL developing Creating the mappings and transformations using Informatica
  • The data from the staging area was transformed and loaded to the target on Oracle using Informatica Tool
  • Responsible for the development of Metadata transformations and establishing load schedule
  • Optimizing/Tuning mappings for better performance and efficiency
  • Extensively used transformations like Filter, Aggregation, Joiner, Expression, Lookup, Router, and Update Strategy
  • Creating validation and loading the rejected records into the relevant tables and send to users for re- submitting
  • Involved in designing the mapplet and reusable transformation according to the business needs
  • Knowledge of slowly changing dimension tables and fact tables
  • Roles and Responsibilities
  • Developed ETL mappings, transformations using Informatica Power Center
  • Developed mappings using various transformations like update strategy, lookup, stored procedure, Router, Filter, sequence generator, joiner, aggregate transformation and expression
  • Involved into source code review, the mappings created by my team members
  • Prepared deployment document and assisted to deployment team while migration
  • Involved in creating test scripts
  • Involved in performance tuning by optimizing the sources, targets, mappings, and sessions
  • Mappings were designed to cater to the slowly changing dimensions
  • Developed several reusable transformations and mapplets that were used in other mappings.
  • Combined data using AWS Data Pipeline and PySpark for reliable ETL processes.
  • Completed AWS and data security training to build knowledge on computer technology, infrastructure and network security trends.
  • Advised on corporate governance issues, maintaining compliance with applicable laws and regulations.

Business Analyst

Project :IHS Markit In S&P Global
11.2017 - 02.2021
  • Project #2 IHS MARKET Client IHS MARKET Role Informatica Developer Environment Informatica 9.6, Oracle 10g, 11g Description:
  • The main aims of this project was to process data from different sources, Monitor the daily data processing to Sales Force and maintain the data quality
  • Also to make sure Information Cloud jobs to replicate data to downstream applications
  • As a part of this project, we had to analyses and understand the source data condition/Pre-requirements for the data to be processed via ODS
  • Once the data was processed to Veeva(Sales Force), we need to check the data consistency and correct it if found any data discrepancy
  • Roles and Responsibilities
  • Understanding the Business Requirements and Develop an ETL process to load data from source to target
  • Extensively used Informatica power center for loading the data from sources involving flat files to target as a relational table
  • Mainly involved in ETL development to Extract, Transform and Load the data into stage area and data mart
  • Extensively used different transformations like Source Qualifier, Expression, Lookup, Filter, Update Strategy, Router, and Sequence Generator to develop Data Mart from the staging area
  • Creation of sessions for mapping and validate the session
  • Schedule and monitor the session's workflows using Informatica workflow manager and workflow monitor, daily basis
  • Using Target Load Plan to optimize the performance of the server
  • Identify the bugs in existing mapping by analyzing the data flow.
  • Documented process flows and implemented requirements for functional improvements.
  • Prepared comprehensive analyses and reports for management to inform strategic decision-making.
  • Worked closely with stakeholders to define key performance indicators (KPIs) and establish metrics for processes and projects.
  • Analysed business processes, systems and data to identify opportunities for enhancement and efficiency.

Senior Data Researcher 1

S & P Global Market Intelligence
08.2006 - 11.2017
  • Years :
  • Perform primary research on financial reports and extract validated financial statements
  • Conduct manual research to scope missing documents not sourced From WebCrawler
  • Accurate and timely collection of financial data from 10 k, 10-q, and news wire reports from various Stock Exchanges into CIQ database based on standard benchmarks
  • Analyze various items in the Income Statement, Balance sheet and Cashflow to get an insightful picture of financial details as per IFRS and native GAAP accounting standards
  • Synthesize the country's filing patterns of financial reports and establish country-level standards while processing reports to the CIQ database
  • Develop guidelines based on the country for processing financial reports of various companies
  • Analyze the future filing dates of the quarterly and annual reports filed by the company
  • Handle queries and provide solutions to the external and internal clients for processing financial statements further
  • Document financial reporting pattern in which the company follows its rule while filling their reports in the stock exchanges
  • Understanding and resolving production issues for team members
  • Gather industry, market and business information using internal & external research sources and prepare output for clients
  • Identify and handle the GAAP & reporting currency changes from financial reports
  • Maintain database regarding the production details and EQA reports and report to the Management team
  • Cross-train and mentor team members to ensure that they are thorough with the production outcome
  • Prepare the industry-based reports, which include the company's segmental analysis as well as geographical revenues, business descriptions, and major competitors
  • Email and secure information from companies whose information is not available in the public domain
  • Validate financial data as per company policies and ensure that the financial information has been prepared accurately
  • Track corporate restructuring and reverse mergers transactions
  • Provided subject matter expertise, guiding team members and stakeholders on modelling matters.
  • Utilised advanced statistical and machine learning for valuable insights and data-driven decision-making.
  • Prepared data for modelling and monitoring, upholding integrity.
  • Developed and deployed impactful segmented models for sustainable growth within risk limits.
  • Played key role in aligning modelling efforts with organisational goals for team success.

Education

V OLU N T E ER I N G

Master of Commerce - undefined

AININGS & A C A DE MI, University college of commerce and Business Administration, Osmania University
2005

Bachelor of Commerce - undefined

Siddipet, Osmania University
2003

Intermediate (12th) - undefined

Prathibha Junior College Siddipet, Board of Intermediate
2000

Certificate (10th) - undefined

Government High School, Board of Secondary Education
1998

Skills

  • Product and service expertise
  • Preparing reports
  • Customer service
  • Product knowledge
  • Customer service orientation
  • Report analysis
  • Excel spreadsheets
  • Report writing
  • Database maintenance

Interests

Hobbies: , Playing badminton and Cricket

Languages

English
Upper intermediate

Timeline

Associate

SLA IT Solutions Limited
06.2023 - Current

Data Analyst

Cognizant Technology Solutions
11.2022 - 11.2023

AWS Associate

Cognizant Technology Solutions
11.2022 - 11.2023

Associate

Cognizant Technology Solution Limited
11.2021 - 11.2022

AWS

Project : Novartis
11.2021 - 11.2022

Business Analyst

Project :IHS Markit In S&P Global
11.2017 - 02.2021

Senior Data Researcher 1

S & P Global Market Intelligence
08.2006 - 11.2017

Informatica Associate

MIDAS MDAH Application

Informatica Developer, Developer

US BANK Crop

V OLU N T E ER I N G

Master of Commerce - undefined

AININGS & A C A DE MI, University college of commerce and Business Administration, Osmania University

Bachelor of Commerce - undefined

Siddipet, Osmania University

Intermediate (12th) - undefined

Prathibha Junior College Siddipet, Board of Intermediate

Certificate (10th) - undefined

Government High School, Board of Secondary Education

Similar Profiles

Create profile
Balakishan Galipelli