Learn Data Skills
Beta
Pramukh Molugu

Pramukh Molugu

Certified

Data Analyst

Skygen USA

Technologies

My Portfolio Highlights

My New Project

Analyzing Students' Mental Health

My New Course

Introduction to SQL

My New Project

Analyzing Students' Mental Health

Algorithmic artist, painting vibrant pictures with lines of code.

My Work

Take a look at my latest work.

project

Analyzing Students' Mental Health

course

Introduction to SQL

course

Intermediate SQL

project

Analyzing Students' Mental Health

My Certifications

These are the industry credentials that I’ve earned.

Data Scientist Associate

Data Scientist Associate

AI Fundamentals

AI Fundamentals

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

Courses

Introduction to SQL
Understanding Data Science
Intermediate SQL
Joining Data in SQL

My Work Experience

Where I've interned and worked during my career.

SKYGEN | Jan 2022 - Present

Data Analyst | Data Engineer

N/A

EMR | Jul 2020 - Dec 2021

Data Analyst

Create/Monitor daily data feeds to load data into stage and to SQL data warehouse. Database development and Data analysis on stored procedures, Triggers, and Functions. Coded on T-SQL and query optimization for developing ETL strategies using SSIS. Maintained development process for developing ETL Packages and reports as per the norms like Gathering Requirements, Design, Development, Code review, Unit Testing, Peer Review and Review before releasing to QA. Event Handlers for the Packages Using Event Handler Tab for Error Handling and Logging purpose. Transactions in packages to roll back the whole process in case of the package fails. Creating SQL agent jobs for the successful development of ETL packages and SQL codes. Maintained log information in SQL table for tracking Errors, Counts and recording package execution status by capturing the record counts and Execution processes. Started as an Intern joining as an experienced BI developer, I need to work closely with the Business Analyst/Scrum Master for requirement gathering and Sprints updates. Create/Monitor daily data feeds to load data into stage and the SQL data warehouse. Database development and Data analysis on stored procedures, Triggers, and Functions. Coded on T-SQL and query optimization for developing ETL strategies using SSIS. Maintained development process for developing ETL Packages and reports as per the norms like Gathering Requirements, Design, Development, Code review, Unit Testing, Peer Review and Review before releasing to QA. Event Handlers for the Packages Using Event Handler Tab for Error Handling and Logging purpose. Transactions in packages to roll back the whole process in case of the package fails. Creating SQL agent jobs for the successful development of ETL packages and SQL codes. Maintained log information in SQL table for tracking Errors, Counts and recording package execution status by capturing the record counts and Execution processes.
Show More

Adaequare | Jun 2014 - Dec 2018

Data Analyst

Designed packages using Control Flow Tasks like For Loop Container, For Each Loop Container, Sequential Container, Execute SQL Task, Execute Package Task, File System Task, FTP Task, Script Task, Send Mail Task and Data Flow Task. Implemented ETL Stage load packages with Full-loads & Incremental, dimension and fact packages according to business requirements with logging functionality. Developed Control package, which runs Stages, dimensions and facts in order and enables subscriptions to send the reports after successful run of all the data related packages. Created Transactions in packages to roll back the whole process in case of package fails. Created Configurations to change the package properties dynamically and preparing deployment documents before releasing to production. Worked intensively over creating Database objects for the development needs in order to implement the business rules like Stored Procedures, Triggers, Functions, etc,.

My Education

Take a look at my formal education

Master of Science - MS, Information TechnologyWilmington University | 2020
Jawaharlal Nehru Technological University | 2014

Powered by

  • Work
  • Certifications
  • Courses
  • Experience
  • Education
  • Create Your Data Portfolio for Free