Dharmaraju Jalla
Email ID: adl0qc@r.postjobfree.com
Mobile: +91-809*******
Prelude:
Seeking excellence in the software field through my commitments, talent, skill and hard consistent worth value and involve myself in managing the organization. Striving to achieve excellence through selective and focused pursuit of the short term and longterm goals through my chosen organization and work field where knowledge has always been in my mind to cope up with the future challenges. As a quick learner and having a strong understanding ability, I am capable of switching to any domain or functional area and always adhered to all the quality processes and techniques required to deliver optimum quality results for an organization.
Profile Summary:
Goal-oriented professional with more than 4.2 years of experience in Software Applications Design, Development, migration and Operations and so on.
Hands on experience in Azure Data Factory, Power BI, Python, Vertica DB, Adaptive card design, Oracle PL/SQL, SQL UNIX shell scripting
Exposure in writing Simple, Medium and Complex SQLs, PL/SQL Procedures and creation of database Objects like Tables, Stored Procedures.
Experience of working closely with client from Onsite at Mexico for 5 months.
Debugging skill for package or procedure
Good Experience in working under tight deadlines and with zero defects delivery and also providing round the clock support.
An effective team player with exceptional planning and execution skills coupled with a systematic approach and quick adaptability
Expert in digging down the issues to find the root causes and proposing solutions.
Proficiency at grasping new technical concepts quickly & utilizing it in a productive manner.
Worked on projects in waterfall & Agile methodology.
Professional Experience
Currently working as Technology Analyst in INFOSYS from Jan.2017 till date.
Educational Qualifications
B. Tech (2013-16) in Mechanical Engineering from Rajiv Gandhi University of Knowledge Technologies, APIIT Nuzvid, Andhra Pradesh with 84.9%.
10+2, from Rajiv Gandhi University of Knowledge Technologies, APIIT Nuzvid, Andhra Pradesh with 81.3s
SSC,studied at Z.P.H.S Bhaskararao Peta, Andhra Pradesh in 2010 with 94%
Technical Skills:
Languages
Python, SQL, UNIX
Operating Systems
UNIX, Windows 7, Windows10.
Database
Oracle 11g,12c, MS SQL Server, Vertica
Primary Skills
Azure Data Factory, Azure Cloud Services, Power BI
Secondary Skills
UNIX, Vertica, Adaptive Card design
Database/Reporting Tools
Power BI, OBIEE, SQL Developer, Microsoft SQL Server Management Studio, DB Visualizer, Toad for Oracle
Other Tools
Putty, Service Now and CTRLM
Certifications
98-381 – Introduction to Programming using Python
AZ-204 – Developing solutions for Microsoft Azure
DA-100 – Analyzing Data with Microsoft Power BI
Infosys Global Agile Developer Certification
Projects Experience:
1. Fastmart Operations
Procter & Gamble Co.
May’18 to Till date
Team Size : 10
Based On: Vertica Database, OBIEE, SPOTFIRE
Description: In today’s consumer goods industry, multiple internal and external forces have combined to create a dynamic and rapidly changing business environment. Rapid growth of point of sale (POS) data volumes for large retailers and technology constraints has been limiting Procter and Gamble’s capabilities to convert POS data into insights for top customers. Implementation of Fastmart free the data solution, which is joint Hewlett Packard Enterprise (HPE) and P&G project, supported by new technologies like massive parallel processing Vertica columnar database will enable fast and easy access to POS data at store and banner level. A wide range of flexible reporting solutions enabling ad-hoc queries, data extractions capabilities and pre-build reports will provide competitive advantage to P&G’s selling capability with customers.
Roles : Technology Analyst (L3 support & Lead)
Responsibilities:
Interacts with end users in gathering the requirements, draws out a plan to deliver them and communicates regularly on the progress.
Assesses impact to the service due to introduction of new or changes in the functionalities to the existing application.
Co-ordinates with client and software developers to determine the road map for smooth releases to production environment and define business communication strategy.
Estimates the resource needs and testing effort for the release. Reviews process and procedural manuals, solution design and service delivery documents.
Establishes the environments used to conduct testing of the final deliverables.
Performs migrations across environments and post migration by resolving complex technical issues, to facilitate uninterrupted service delivery.
Provides technical support to software developers and business users in executing and managing test processes. Performs non-negative impact testing on the new/change implementations.
Performing end to end release to operations activities by adhering to the client change management process.
Works with cross vendors to improvise the release process and mentors the team to ensure project’s best practices are followed.
Manages activities to ensure the software products meet quality standards and performance objectives within defined time and budget targets.
Participated in code and design reviews
L3 Support activities.
2. ACL (Active Code List)
Procter & Gamble Co.
Nov’20 to till date
Team Size:3
Based On: Azure Data Factory, SSMS, Python, Power BI
Description: We are responsible for ingestion implementation specific to the Active code list (ACL) which is an extract from Simplement & Sales Forecast data (Sources). Source team will push data to sources 1. Simplement (SQL Database) and 2. Sales Forecast Data (Oracle) in case of Full data load. ACL team will process data from Simplement storage to Azure SQL using ADF. For each region, ADF pipelines use the source data and ingest into multiple Staging tables. We are following traditional approach based on the type of loading.
Roles : Developer
Responsibilities:
Source team will push the data to respective databases. We ingest the data into Azure SQL database Staging Tables using ADF pipelines and stored procedures.
Work on Ad-hoc requests raised by users with given timelines.
Monitoring the pipeline runs daily/weekly basis and fix if any failures.
Work on manual dashboard refresh in PowerBI based on user request.
3. Digital Brain
Infosys internal use case
Oct’20 to Dec 20
Team Size: 5
Based On: VS Code, Ne04J Aura Professional, Neo4j Bloom, Kafka, MongoDB, Azure as IAAS, Docker, Kubernetes, Adaptive card designer, Postman/Curl, Power BI.
Description: It is about proactively notifying ecommerce managers or similar staff with Nudges on Teams, and informative visualizations understandable through UI or Power BI dashboard. To take corrective actions based on received information. This Digital Brain setup will be altered based on suitable client requirements once there is an agreement between Client and Vendor.
Roles : Developer
Responsibilities:
Set up an environment (installing software’s)
We created an orchestration of 8 Microservices using Python Flask API's and their integration flow is designed to work seamlessly.
creating a python script for importing CSV data from azure blob storage to Neo4j.
Creation of nodes and relationships using cypher queries and visualization in bloom along with search phrases.
Inserted collections in MongoDB server using Mongo shell and retrieved collections using python connector.
Locally testing each API before deploying it to kubernetes, built docker image for code, pushed it to ACR and then deployed it to kubernetes using azure cloud shell after preparation of necessary yaml files for deployment and service.
Exposed all the applications deployments to be accessible from any network using external load balancer service.
Prepared the script for bulk insertion of nodes and relations for entire setting up of schema on one go.
we build the adaptive card using adaptive card designer and generated various templates which were useful for covering multiple scenarios.
Prepared Power BI dashboard for visualization for SLA.
4. Customer Data Service (CDS) Procter & Gamble co.
Sep’17 to Apr’18
Team Size: 15
Based On: Oracle SQL, UNIX Shell Scripting
Description: This project is based on Business Intelligence having data warehouse in which transactional data of retailers of P&G is maintained across the globe. In this application Extraction Transformation Loading (ETL) is done followed by some business derivation, aggregation and reporting. The main objective of this project is to onboard retailer specific data on the CDS platform and creates business views used by reporting applications. This is a functional application used by Global Point of Sales Customer team to drive business growth and provide business insight to P&G. The data from this application is used by business users and down Stream applications to forecast the sale, improve the supply chain and warehouse performance. Scope of the project is development, migration and changes involving requirements elaboration, design, build, testing and implementation. The system will be developed in multiple releases using the waterfall methodology.
Roles: Developer & Analyst
Responsibilities:
Interacts with end users in gathering the requirements, draws out a plan to deliver them and communicates regularly on the progress.
Worked on impact assessment to the service due to introduction of new or changes in the functionalities to the existing application.
Estimates the resource needs for Development and testing effort for the release. Reviews process and procedural manuals, solution design and service delivery documents.
Performing pre-migration & modeling: Internal team discussions, analyzing legacy or existing setup for individual retailers which are in scope and finalize migration strategy.
Preparing the Data collection template, Preparing Mapping with the Target application after Source application & Data analyzing.
Performing Unit testing and preparing test cases.
Performs migrations across environments and post migration by resolving complex technical issues, to facilitate uninterrupted service delivery. Giving support to System Testing & User Acceptance Testing.
Managing code, documents versions & performing Code & documentation reviews.
Works with cross vendors to improvise the process and mentors the team to ensure project’s best practices are followed
ACHIEVEMENTS:
Got INSTA awards that is given by Infosys to an employee for the Best Performer.
Key member in team which delivered multiple releases with Zero Production defects.
Received “Most Valuable player” Award from P&G for exceptional performance in the team.
Got appreciations from Clients and Managers across the globe
Personal Details:
Nationality : Indian
Gender : Male
Marital status : Single
DOB : 15-09-1994
Linguistic Abilities : English, Hindi, Telugu
Passport : N8449180
Declarations:
Should you feel convinced as regards the achievements stipulated, may please contact me to be across your table to justify my worth for the position applied for, I shall be grateful.
Date: Dharmaraju Jalla