Bhanupriya Batkiri
Moline,USA
Summary
- Having 13+ years of IT experience in Analysis, Design, Development, Testing, and Implementation of business application systems for Banking, Retail and Manufacturing Sectors.
- 5+ years of comprehensive experience in AWS environment, Databricks, pyspark, python with Strong experience in Cloud computing platforms such as AWS services.
- Design Architectural solution for Enterprise Data Lake and cloud enablement.
- Strong experience in implementation of Business Intelligence solutions using Data Warehouse, ETL, OLAP, BI applications.
- Holds strong interpersonal, communication and analytical skills.
- Involved various phases of software development lifecycle using Waterfall & Agile Methodologies.
Overview
14
14
years of professional experience
Work History
Consultant
Infosys Ltd
11.2017 - 04.2020
- Design Architectural solution for Single Enterprise layer of Information from heterogeneous data sources, for OM downstream reporting with integration of legacy and sources
- Developing ETL program for supporting Data Extraction, transformations and loading using Informatica Power Center
- Involved in HANA information model design and build which includes Package, Attribute View, Analytical View, Calculation View and Schemas
- Designing Schemas, Creating Packages, Calculation view, Analytical Privileges, Procedures
- Implemented test driven development for HANA views Involved in all phases of Agile Scrum (Sprint Planning, Daily Standup, Retrospective, Sprint Review)
- Incident Management-Perform Tier 2 and Tier 3 incident management
- Implemented improvement ideas in consultation with client
- Provided recommendations and directions for continuous improvement.
Senior Associate Consultant
Infosys Ltd
01.2016 - 10.2017
- Using Informatica PowerCenter Designer analyzed the source data to Extract & Transform from various source systems by incorporating business rules using different objects and functions that the tool supports
- Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections
- Prepared migration document to move the mappings from development to testing and then to production repositories
- Created complex mappings using Lookups, Sorter, Aggregator and Router transformations for populating target table in efficient manner
- Involved in processing tasks using Workflow Manager to move data from multiple sources into targets.
Senior Associate Consultant
Infosys Ltd
09.2014 - 12.2015
- Developed OLAP & OLTP universes with measures and dimensions objects, Join conditions, Filters, LOV, cardinality, Aliases, Contexts, Aggregate Awareness using Business Objects Designer
- Developed simple to complex report from ORACLE database and SAP BW using Hyperlink, Rank, Combined Queries, and Merged Dimension
- Worked on creating users, user groups, universe and folder access using Central Management console (CMC)
- Involved in incident management
- Involved in Business user meetings in fixing and explaining the reports for its errors and fixes
- Performed Unit Testing, Integration Testing, and User Acceptance Testing (UAT), to validate universes & reports
- Involved in Audit reporting using audit database.
Developer
Polaris Financial Ltd
06.2013 - 08.2014
- Developed Universes using Designer
- Designed and developed Deski and webi reports Using Desktop Intelligence & Web Rich Client
- Gathering requirements and designing the ER model database objects and developing packages, stored procedures, and functions
- Performed query tuning using Quest SQL Optimizer
- Handled feed processing to import and export to external systems.
Developer
Polaris Financial Ltd
01.2012 - 05.2013
- Created Universes using Designer according to the Requirement
- Generated several Templates in both DeskI/WebI
- Providing all required SQL queries and stored procedures, packages and functions for the front-end developers
- Performed query tuning to improve performance
- Understanding existing CP system Data Base design of Three Regions Europe, Asia, US along with BASEL, RTMM application
- Designed Target DB structure for Maintenance module
- Generating ER model for the DB structure
- Providing the Design and technical specification document for all database related activities.
Developer
Polaris Financial Ltd
06.2010 - 12.2011
- Created New Classes and User Objects in the universes
- Developed and modified the Deski/WEBi Reports using the Universe as a main data provider
- Published reports using Desktop Intelligence and trained users for ad-hoc reporting
- Involved in developing PL/SQL procedures, packages, and functions as per the requirement
- Involved in preparing MDD, TDD and CCB documents for the enhancements.
Senior Consultant
Infosys Ltd
05.2020 - Current
- Design & development of Python based In-Memory Spark applications to provide seamless data to data scientist community using AWS IAM, and secret management service
- Involved in data migration from flat files, On-premises database to AWS S3 and Enterprise Data lake
- Developed Clock Based (Batch and Real Time) Data Integration Strategy to store, extract, load and Transform (ETL) the data from Varied Sources
- Design proactive data load monitoring system sending Automated alerts to End users on data / application availability and related metrics
- Low level technical document including detailed design specifications of various AWS components like S3, SNS, DynamoDB, Lambda and Spark application components
- Multiload architecture with auto submission capabilities, reducing support effort and Standardization of on-premises data to EDL loads with templated process, improved load quality and reduced implementation time
- Used py-spark Mathematical and statistical libraries and functions to handle complex business transformations
- Designed Continues integration and code deployment framework using Jenkins
- Involved in all phases of Agile Scrum (Sprint Planning, Daily Standup, Retrospective, Sprint Review)
- Incident Management-Perform Tier 2 and Tier 3 incident management
- Collaborated with stakeholders to gain complete understanding of project goals and objectives.
- Handled complex problems and issues by understanding root cause of issue and implementing solutions
- Developed scripts to automate deployment and maintenance of public cloud resources.
- Promoted high customer satisfaction by resolving problems with knowledgeable and friendly service.
Education
Bachelor of Technology - Electronics And Communications Engineering
Jawaharlal Nehru Technological University
India05-2008
Skills
- AWS Solutions Architect
- Databricks Data Engineer
- Data Analytics
- SAP HANA
- Informatica
- PySpark
- Python
- AWS Lambda
- AWS DynamoDB
- AWS S3
- Databricks Data Pipeline
- SQL and Databases
- SAP Business Objects (4X)
- PL/SQL Developer
Technical Summary
- Have extensive experience in development and implementation of BI projects using AWS, Databricks, pySpark, python, SAP Native HANA, Informatica, SAP Business Objects.
- Experience in Full Life Cycle Implementation & Support from Design, Development, Testing, Go-live and Post Go-live activities.
- Have Good experience in design & development of Python based In-Memory Spark applications to provide seamless data to data scientist community using Databricks, pyspark, and AWS services like DynamoDB, Lambda, SNS, S3, IAM, CloudWatch and secret management service.
- Developed Multiload architecture using Lambda function and DynamoDB streams. Worked on Data migrations from On-premise to AWS Cloud (Enterprise Data lake).
- Developed Pyspark scripts for end user / analyst requirements to perform ad hoc analysis. Expertise in developing data driven applications using Python on Visual Studio and PyCharm.
- Designed Continues integration and code deployment framework using Jenkins & Git Actions.
- Rich Knowledge of SAP HANA Modeler HANA Studio, Creating Packages, Attribute View, Analytical View, Calculation view, Analytical Privileges, Procedures.
- Expertise in developing ETL jobs (workflows, worklets, sessions & mappings) using Informatica Power Center (Designer, Workflow Manager, Repository manager & workflow Monitor).
- Experience in implementing BI solutions using SAP BO 4.x/R3 for RDBMS and OLAP sources. Experience in Design and developing Universes using Designer, UDT & IDT.
- Have good knowledge in developing Webi reports and dashboards using Web Intelligence, BI Launchpad & CMC.
Certifications And Achievements
- AWS Certified Solution Architect Associate
- AWS Certified Cloud Practitioner
- Databricks Certified Data Engineer
Languages
English
Professional
Hindi
Full Professional
Telugu
Native/ Bilingual
Timeline
Senior Consultant
Infosys Ltd
05.2020 - Current
Consultant
Infosys Ltd
11.2017 - 04.2020
Senior Associate Consultant
Infosys Ltd
01.2016 - 10.2017
Senior Associate Consultant
Infosys Ltd
09.2014 - 12.2015
Developer
Polaris Financial Ltd
06.2013 - 08.2014
Developer
Polaris Financial Ltd
01.2012 - 05.2013
Developer
Polaris Financial Ltd
06.2010 - 12.2011
Bachelor of Technology - Electronics And Communications Engineering
Jawaharlal Nehru Technological University
Similar Profiles
Sudhakar KatikireddySudhakar Katikireddy
Lead Consultant at Infosys LtdLead Consultant at Infosys Ltd
SAIKRISHNA HARISAIKRISHNA HARI
Principal Consultant at Infosys LtdPrincipal Consultant at Infosys Ltd
SHRIYA GANGULYSHRIYA GANGULY
Senior System Engineer at Infosys LtdSenior System Engineer at Infosys Ltd
ATHUL NATHUL N
Systems Engineer (Microsoft Project) at Infosys LtdSystems Engineer (Microsoft Project) at Infosys Ltd
Mark VermeulenMark Vermeulen
VP Operations at Blackhawk Acquisitions DBA ProMaxVP Operations at Blackhawk Acquisitions DBA ProMax