Siva Ramakrishna P

Technical Lead – Python Databricks Data Engineering

Email Id: ad3lgx@r.postjobfree.com Contact number: +1-571-***-****

PROFESSIONAL SUMMARY:

Having around 16 years of Overall IT Experience including 7 years of process automations using Technology and Tools like Python programming, Databricks, Azure Data factory, Data lake, Data Analytics, Data modelling, Data warehousing, Data Privacy,Django, SnowFlake,SQL, UiPath, VB macros, Docker Desktop, Azure DevOps (ADO), Jenkins, API development and Power BI.

Results-driven and strategic Product Owner with 3 years of experience in IT General Controls (GC) Automation project guiding Dev. Team/Testing cross-functional teams to deliver successful products. Proven expertise in product strategy, backlog management, and stakeholder collaboration. Strong analytical and problem-solving skills with a track record of driving product success in dynamic environments.

Proficient in overseeing end-to-end implementation processes, encompassing the design, development, testing, and deployment of automations and bots using tools such as Python, UiPath, and Work Fusion

Certified in UI Path - Diploma Of Completion in RPA Developer foundation Training.

Experienced in RPA Tools using UiPath to automate web applications, desktop applications, and performed excel manipulations and validations.

Hands on experience working with various version controls like ADO, GitHub and SVN and

Hands on experience in working closely with Process SMEs to prepare Process Definition Document (PDD) & Solution Design Document (SDD) and educated SMEs to work with Bots in production.

Quick learner and excellent team player, ability to meet tight deadlines and work under pressure and strengthened in adaptability, analytical and problem-solving skill.

TECHNICAL SKILLS

Technologies and Tools: Python programming, Data Bricks, SQL, HTML, JavaScript, Django, UiPath, C#.net, WorkFusion, Pandas, NumPy, Openpyxl, Docker Desktop, SnowFlake,Azure DevOps, Alteryx, Jenkins, GitHub, Confluence,

Programming Languages: Python, C#.Net, VB and SQL

Web Technologies: HTML, DHTML, Java Script, CSS

PROFESSIONAL EXPERIENCE:

Technical Architect (Python, Databricks, Python programming, Databricks, Azure Data factory, Data lake, Data warehousing (OLTP,OLAP), Data Privacy, SQL, Django, Product Owner, UiPath and WorkFusion)

Responsibilities:

Accountable for the design, implementation, and development of automation for PWC Internal Audit Controls (ITGC) using Python programming and backend as Databricks.

Responsible for implementing the full life cycle of SDLC using Agile Methodologies (SCRUM): Identifying automation opportunities, gathered requirements, implement, testing automation solutions

As a Product Owner, responsible for Product Backlog Management, Agile/Scrum Methodologies, User Story Writing, Stakeholder Collaboration, Release Planning, Cross-functional Leadership, Requirement Analysis, Data Analysis, Risk Management and Continuous Improvement

Led the development team in delivering ITGC related product/features, resulting in a 40% increase in customer satisfaction.

Collaborated with stakeholders to define and prioritize the product backlog, ensuring alignment with business goals.

Implemented agile methodologies to streamline the development process, resulting in a 40% improvement in team efficiency.

Automated Several Processes and Business activities for various business systems and Provided knowledge transfer/support/Assistance to the Application development and Support teams.

Worked with windows, web application end-to-end process automation using Python programming.

Involved in code review and fine tuning the code for performance related issues and worked on debugging application for fixing bugs.

Worked with different teams in making changes in developed processes as per the Technical Design Document (TDD) to meet the defined requirements.

Work Experience:

Client: PWC KSDC Pvt. Limited, Tampa, FL Nov 2021 - Till Date

Role: Technical Lead & Product Owner

Project: Information Technology General Controls (ITGC) Automations

Description:

ITGC Automation provides the Trust Solutions business with a strategic opportunity to simplify and standardize testing of manual ITGCs and to drive down the cost of delivery. The automated program change management testing solution will leverage existing PWC technology investments (e.g., C-AMS, Extract On-Ramp, Cams support suite, Databricks etc.) to generate a testing population and randomly select samples.

This solution will then match the samples to a supporting ServiceNow/Jira/Solmon ticket to evidence the control operation (attribute testing) and will populate a testing table for the engagement team’s review and completion.

Responsibilities:

Currently working as a Technical Lead and Product Owner for IT General Controls (ITGC) under Assurance, Digital Assurance and Transparency (DAT) Team

Involved in End-to-End ITGC automation using Agile Methodologies i.e. starting from requirements finalizing, estimations, designing, development till the deployment using ADO, Azure Repos, Pipelines and to postproduction support phase.

Standardize testing approach and documentation.

Randomly select samples from data loaded via Extract On-Ramp

Identify supporting evidence for samples selected and

Automatically prepare a testing table for engagement team review and identify items where follow-up is required.

Technologies and Tools: Python, Docker Desktop, Azure Data factory, Azure Data lake, Databricks, Data Privacy, Azure DevOps, Data modeling, SnowFlake,Analytics, Jenkins, SQL, GitHub, and Confluence.

Client: HPE Limited, Bengaluru, India Dec 2017 – Nov 2021

Role: Technical Lead and RPA Consultant

Project 1: CRISP – Contract Review Integrated system for PRS.

Description:

Contract Audits focusses on review of supplier contracts to identify non- compliances with agreed terms and conditions. It also entails contact with stakeholders ranging from Procurement, Business and Suppliers to get their concurrence on audit findings. The benefits of this exercise range from recoup of dollars, process fixing and in enhancing control environment.

The early benefits have been in the range of 60-70 % reduction in time spent on data consolidation. This will give a massive scalability edge to address 10 X increase in contract audits from the current base of 200 contracts per year. It is projected to result in potential windfall gains in recovery dollars. Besides, giving the Analysts more time in communicating and collaborating with the stakeholders rather than worrying about data consolidation issues. There could be potential latent use of this application in the Legal & Compliance Industry.

3- Tier Process

It flows through a 3-tier process:

Consolidation: Consolidation of all contractual agreements, purchase order documents and invoice information from disparate systems.

Analytics: Comparative analysis of the contractual pricing/rebates/discount thresholds with actual expenditure.

Collaboration: Liaising with different stakeholders from Procurement, Business and Supplier to get their concurrence on contract audit findings.

Technologies and Tools : Python programming, Workfusion RPA Express and UiPath Developer tool.

Project 2: Fixed Assets Asset packet creation process overview

Description:

Asset Packets creation is a US sales tax requirement applicable only for US Company Codes and involves creating all related backups like copies of Invoices, Purchase Order, Purchase Requisitions and SAP Screenshots against each Purchase Order. These asset packets are submitted to CTG Team (Corporate Tax Group) and go to external auditors for review.

Scope:

The scope of Asset Packet creation includes 5 sub processes & average monthly volume is around 390 Packets

Responsibilities:

Worked as RPA Solution Architect

Working on UiPath (Certified), Work fusion as a Certified RPA developer, Python and Databases (SQL, NoSQL))

Involved in End-to-End RPA life cycle i.e. starting from Identifying opportunities to till the BOT is deployed into Production.

Designed solutions utilizing RPA best practices and maintain technical responsibility for project delivery.

Before moving to RPA, worked as technical lead supporting.net applications.

Technologies and Tools: Python, UiPath Developer Tool, SQL Server.

Client: Mindtree Limited, London, UK Dec 2010 - Dec 2017

Role: Technical Lead(.NET)

Project: ABG – Car rental/reservations - Data Analytics

Description:

This Project (proof of concept) aims to do ETL, Data Aggregation, and Data Analysis on top of car bookings across ABG, Enterprise and Hertz. ABG is one of the top car rental companies in the UK. The data set contains millions of records about car bookings and reservations. This entire data is in Oracle System, we migrated the data from Oracle to Hadoop using Sqoop. We wrote several MapReduce/Pig programs to do ETL and Link Analysis. This analysis includes trends in bookings of different segments, where ABG needs to change their pricing system when compared with their competitors, We used Hive/HBase to do adhoc querying, reporting and real time querying.

Responsibilities:

Involved in several client meetings to understand the problem statements and other requirements.

Data Migration from Source Systems to Hadoop.

Wrote MapReduce/Pig programs for ETL and Link Analysis of data.

Created Hive/HBase table schemas, data loading, report generation.

Delivering the reports and getting feedback from customer to enhance the Analysis.

Worked with Python, Databases (SQL, NoSQL), Big Data Technologies (Hadoop, HBase, Hadoop Ecosystem)

Logs processing and several Text processing tasks -- Entities extraction, keyword extraction.

Worked in the area of Data Analytics

Worked on Projects and POCs for various Business Verticals.

Before moving to BIG Data, worked as Technical lead supporting .net applications.

Technologies and Tools: SQL, Apache Hadoop, HBase, Pig, Hive, Sqoop, Spark.

Client: Infosys Limited, Bengaluru, India Feb 2006 - Dec 2010

Role: Senior Software Engineer

Project : Wizard OneSource, Service center, Win2k3 Migration – ABG

Description:

Avis Budget group operates one of the world's best-known car rental brands with approximately 5,450 locations in more than 165 countries. ABG currently maintains two sets of Wizard source code: one to support the Avis brand and a second to support Budget brand. This configuration generates additional costs to update both brands for new requirements and development. Hence, we have developed and enhanced their IT applications across the portfolio to support both Avis and budget brands and any new brand that will be acquired by Avis in future.

Responsibilities:

Worked as a senior software Engineer in .Net technologies.

Coding of the modules in ASP.Net. Creating Stored Procedures/Functions/Views/Triggers in SQL server

Estimation and Requirement analysis for the enhancement requests

Low level design of the new enhancements without impacting existing functionality. Fixing the existing defects, support to testing/DBA and onsite team.

Lead the team towards the project delivery and resolve/timely escalated the technical issues encountered by them so that delivery is on-time

Implemented framework components for handling cross cutting concerns like logging and exception handling

Analyzing and validating user requirements. Identify and map Active Directory groups with custom SharePoint groups.

Successfully completed WOS project across 9 countries with a team of 15 members and handled all major escalations post GO live of WOS project.

Understand the existing architecture and framework core components.

Actively worked on solution designing and provided suitable technical solutions to the client.

Analyzing requirements, get clarifications from Business Analyst and share the estimates.

Developed modules from UI to repository layer.

Guided the team to follow SDLC process thoroughly and made sure that all the artifacts/process documents (Burn down, Product backlog, IA, UAT and Release notes) are shared with client on time.

Attended the daily sprint status meeting for every sprint.

Co-ordinated with all the BA’s and business users/clients to get the clarifications resolved on time with very minimal impact to schedule.

Technologies and Tools: ASP.Net 4.0, MVC 4.0, Visual Studio 2010, SQL Server 2008 R2, TFS 2010, HTML5, Javascript and XML.

Contact this candidate