python,SQL, Azure, ETL, Power BI

M.PRANAY

•816-***-**** •********@*****.***

OBJECTIVE:

Seeking entry-level roles to apply and expand my skills with a strong foundation in Python, Databases and AZURE.

Expertise in writing complex SQL queries and database management to contribute to data-driven decision-making and enhance organizational efficiency.

Proficient in utilizing HTML, CSS, and JavaScript to craft pixel-perfect and responsive web pages, UI and layouts.

Familiar with NoSQL databases and experienced in designing and implementing efficient data models, wide-column, and key-value stores, enabling robust and scalable data management solutions.

Well versed with knowledge of Data and cloud services.

Expertise in project management & requirement analysis.

TECHNICAL SKILLS:

languages

Python, C#. NET,

Fronted framework & IDE

HTML, CSS, Java Script, Bootstrap, j-Query, AJAX, Visual studios.

Power BI, Tableau, R, Django, REST API

Databases

Relational Databases, Mongo-DB, My SQL Server

Cloud & DevOps

Azure, Docker, Kubernetes, Git, Jenkins, AWS

Operating system

Unix, Linux, Windows

Technical skills

Interpreting blueprints & schematics, developing test specifications & plans, Framework’s. source code debugging and developing data models.

EDUCATION:

Bachelor of Technology, Electrical and Electronic communication Engineering G.P.A - 3.7 May 2019

Keshav Memorial Engineering College, Hyderabad, India.

Master of Science, Computer Science G.P.A - 3.20 May 2023

University of Central Missouri, Lee’s Summit, MO

Courses completed:

• Object oriented programming Database Theory & Apps Compiler Design & construction

• Advance Algorithm’s Artificial Intelligence Software Testing and QA

• Big Data Analytics Python and machine learning C#. NET

PROJECTS:

Student Course Enrollment System: C#, HTML, CSS, MONGODB (Dec 2022)

•Online platform for course selection and registration and simplifies the process of choosing and enrolling the courses.

•Provides a centralized place for students to view available classes, allows students to check seat availability in real-time and enables students to enroll in their desired courses through the platform.

Ticket Management System: HTML, CSS, PHP, SQL, (June 2022)

•The Ticket Management System is a comprehensive solution for managing sports tickets.

•It provides a user-friendly and efficient way for users to purchase and manage their tickets, while also gith tools they need to schedule matches and manage seat availability.

Jr Software Engineer Zensar Technologies HYD, India 2018 April – Mar 2019 Technologies used: SQL, JAVA

•As a trainee engineer, I worked on automated Java code that related to Selenium to test web apps, built code for running web applications without manual input and developed logic to combine code with browsers to communicate with the server.

INTERNSHIP:

UNIVERSITY OF CENTRAL MISSOURI: Student Database Developer

Designed, migrated and normalized a new database for UCM key system using MS Access by retrieving data from previous databases which involve a large application with information on 30,000 people that eliminated major design flaws in original database.

•Performed DBA related responsibilities, repairing and maintenance, trained users and solved troubleshooting.

•Earned good experience in SQL script writing.

•Successful migration from Access to SQL Server Database.

•Integrated with Ellucian banner-ERP to ensure seamless data transfer and system compatibility, improving data management and reporting processes for student information and key access controls.

•Facilitated data exchanges between the Student Information System (Banner) and CRM (Slate), ensuring accurate data mapping, troubleshooting issues, and maintaining seamless integration for efficient student data management and communication workflows.

WORK EXPERIENCE:

Delta Dentals, California, Program Analyst from May 2023 - Current

Description: Develop Python-based applications for Delta Dental's Insurance Management System, focusing on functionalities such as enrollment, billing, claims processing, and policy administration.

•Utilize Python programming language and frameworks such as Django & Flask to develop back-end functionalities of the Insurance Management System.

•Employed DAX (Data Analysis Expressions) in Power BI to develop advanced calculations and measures, enabling real-time data analysis and providing deeper insights into insurance operations to support more efficient decision-making for stakeholders.

•Developed Python, SQL, and R for data processing, data analysis, and visualization to support initiatives and enhance communication workflows.

•Optimized Tableau to extract and analyze data for improving supply chain processes, enhancing decision-making in inventory and logistics management.

•Implement client-side interactions and dynamic content using CSS, HTML, JavaScript and frameworks like Bootstrap for efficient UI development.

•Optimized Microsoft Excel, Word and PowerPoint to create and automate data-driven presentations and reports for tracking key metrics related to enrollment, billing, and claims processing. Used pivot tables, charts, and macros in Excel to streamline data analysis and provided visualizations in PowerPoint to present insights to stakeholders and Word for Documentation.

•Designed and managed ETL pipelines to automate data extraction, transformation, and loading processes, ensuring consistent, high-quality data flow for reporting dashboards and data warehouse.

•Developed and maintained QliekView to facilitate secure data exchange between front-end components and back-end services in the Insurance Management System,

•Developed complex SQL queries, stored procedures, and functions to support data retrieval and analysis, improving the performance of claims processing, policy administration, and reporting workflows in the Insurance Management System and operations like Data Manipulation and Division.

•Made use of Azure solutions like Azure App Service and Azure app insights to host microservices, Azure SQL Database for storing data, and Azure Functions for executing server-less computations.

•Leverage Kubernetes to orchestrate containers and Docker for containerization to efficiently deploy and manage microservices.

•Configure the CI/CD pipeline for deploying microservices and Lambda functions with Jenkins.

•Used Git for version control, managing code repositories, and facilitating collaborative development among team members.

•Followed Agile Methodologies (Scrum) involved daily stand-up meetings, hands on experience with Agile project management tools such as JIRA.

•Participate in code reviews, provide feedback, and ensure adherence to coding standards and best practices.

Environment: Python, Power BI, R, Tableau, HTML, CSS, JavaScript, Django, Flask, Git, Azure, Bootstrap, SQL, Docker, Jenkins, Agile, Ruby, ETL, Kubernetes, REST API

SUNMICRO info solutions, Software Engineer, HYD Aug 2019 -Mar 2021 Description: The main purpose of our project is to build an application for a local bank. My work is to store customer information such as personal information, transaction history, credit information and perform different functions like updating and deleting them from database SQL server.

•Developed entire front-end and back-end modules using python and Django web Framework.

•Developed and tested many features for dashboard using HTML5, CSS3, AJAX, JavaScript and jQuery.

•Involved in writing SQL Queries and Stored Procedures Tables, Indexes, Views, User defined functions, Triggers, Parameterized Stored Procedures, Constraints and Roles.

•Utilized R for statistical analysis and Optimized Tableau to visualize customer data, transaction history, and credit information, enabling stakeholders

•Implemented Extract, Transform, Load (ETL) to ensure integration of data from various sources into the bank's database, ensuring data quality and consistency throughout the application.

•Involved in using AWS for tableau server scaling and secured Tableau server on AWS to protect the environment using Amazon S3, AWS Athena and AWS direct connect.

•Utilized Microsoft Office tools such as Excel for tracking project metrics, PowerPoint for creating presentations to report project status to clients, and Word for documentation, ensuring clear communication and efficient project management throughout the development cycle.

•Utilized Julia to automate deployment tasks and manage server environments, enhancing efficiency and consistency in application deployment

•Developed and maintained XML-based data exchange processes to facilitate seamless communication between the bank's application and external systems, ensuring structured and reliable data transfer. Utilized JSON to enhance the front-end of the application, ensuring compliance with web standards for better cross-browser compatibility and a more robust user experience.

•Used LINUX for managing server environments, scripting, and ensuring smooth deployment and operation of applications.

•Used Git as version control and streamlined the code check-in process by implementing continues building and integration.

•Followed the full SDLC process, from requirement gathering and design to development, testing, deployment, and maintenance, ensuring that the application met the bank's functional and security needs while adhering to industry standards and best practices throughout the project lifecycle

•Collaborated with cross functional teams, reported project status to client on daily basis and involved in release planning meetings.

Environment: Python, HTML, CSS, JavaScript, AJAX, j-Query, Django, ETL, SQL Server, AWS, Git, Unix, XML, R, Tableau, SDLC, Julia

CERTIFICATIONS:

•Azure Fundamentals AZ – 900.

•Azure Administrator Associate AZ – 104.

•Python Institute – Certified Entry Level – Python programmer (PCEP) python institute. (CISCO)

•Hack rank SQL certification

Contact this candidate