Summary
Overview
Work History
Education
Skills
Certification
Skillsets Tools
Community Service
Projects
Training
Disclaimer
Timeline
Generic

Padma Priya

Data Engineer
Richmond,VA

Summary

Looking for a challenging position, where can contribute maximise efforts for the growth of the organization as well as myself by being dedicative as a dynamic team member and to update knowledge following the latest data analytic/engineering trends. Beginner Level experience, yet will be enthusiastic to work with all phases of Software Development Life Cycle, enabling data ingestion including data extraction and analysis. Hands on knowledge in Excel, SQL Server and SQL and Power BI reports. Possess Strong communication and problem-solving skills. Eager to work with the Data Architects and DBA to build the logical and physical data model, Posses Knowledge in exposure on Data warehousing and ETL concepts. Multi-tasking, Customer oriented professional with excellent analytical and logical skills, has experience as Data analyst/Engineer Working on various Business Specification, Technical Speciation and Change Requests. Leverage the project knowledge and Conducted meetings with business stakeholders, analysts, product owners for requirement gatherings and presented various solutions incorporating best practices. Connecting data sources using informatic power center and transforming data for data warehousing using SQL's/scripts, worked on the sprints using Agile Methodology, Having basic working experience in UNIX and shell scripting Possess SQL Knowledge in writing Joins, Views, Stored Procedures, Functions and Temp Tables creation as per the data model definitions/metadata. Performed data analysis and ad hoc reports for the management resulting in improved decision-making. Collaborated with cross-functional teams to find data issues and provide solutions resulting in improved data quality. Managed data quality by performing regular data quality checks resulting in correct data. Constructing or ensuring proper Data Model, ETL-code before production development. Effective at supporting team needs with high-quality code, subject matter expertise and collaboration skills. Skilled programmer and complex problem-solver experienced in data analytics and report writing. Diligent SQL Developer with [1] years of experience creating databases and writing applications. Expert in basic SQL queries. Blends strong technical and analytical acumen to deliver quality code.

Overview

11
11
years of professional experience
5
5
years of post-secondary education
4
4
Certifications
2
2
Languages

Work History

SQL DEVELOPER

Aspire Systems
07.2021 - 12.2021
  • Worked as SQL developer for Fuel Farm Management System and had database designer/developer for Guest Relations Management System
  • Involved in all phases of software development life cycle (SDLC) including requirement gathering and analysis, design, implementation, testing, deployment, and maintenance, related to various database projects
  • Developed Data warehouse logical and physical data model using Erwin tool
  • Built Star Schema data model DW
  • Built SSIS packages to Load data from source systems to Data warehouse
  • Built SSIS packages for dimension and fact tables
  • Designed, developed and deployed dashboard using Tableau
  • Depending on size of data in dimensions handled type 2 slowly changing dimension using merge statement or lookup part
  • Loaded fact table with millions of data by partitioning and loading fact table using metadata columns
  • Designed SSIS packages to handle both full and incremental data load
  • Used staging tables to cleanse data and, also to transform data wherever needed
  • Used For each loop container to load multiple files at one time into table and archived loaded files
  • Deployed SSIS package to different environments and scheduled packages using SQL Server agent job and monitored deployed packages on production server
  • Tuned performance of SSIS packages by avoiding blocking transformation, by configuring default buffer size and default buffer max rows, by using index wherever necessary.
  • Created optimal technical solutions to user needs with in-depth system analysis
  • Designed and developed customized extract, transform and load (ETL) applications per client specifications

SAP MM FUNCTIONAL CONSULTANT AND ANALYST

Capgemini Consulting Services
01.2011 - 08.2012
  • Code creation/maintenance process in both New and old versions of SAP (Workflow/MM01)
  • Maintaining alternative UOM
  • BOM/MR/PV creation
  • Info record creation  Cost simulation run
  • Pricing condition creation/maintenance
  • Cross reference table maintenance
  • Varit creation/maintenance in older version
  • Defined split between what client will do and what Capgemini will do for NA Region
  • SOP and SLA agreed, Documentation works performed.
  • Preparation of Weekly review documents, and held discussion of same with clients.
  • Migrated Master Data Management/BOM Process from Syngenta to Capgemini in 2010 (Seeds).
  • Migrated Master Data Management (older Version) Process from Syngenta to Capgemini in 2011(Flowers).
  • Started crops protection project with multiple warehouses and resolved conflicts to define rule book for standardization and got approval.

Education

Bachelor of Engineering Technology - Computer Science

Anna University
Chennai, India
07.2004 - 07.2009

Skills

Business Intelligence

undefined

Certification

01/01/24, Linked learning, Oracle Database 19c: Basic SQL

Skillsets Tools

  • Software/Platform, Win 95/98, Windows XP, Windows 7, Practitioner level user of MS – Excel and Win Word, Unix and Linux
  • ETL tool, Informatica 10.2.0
  • Program/Database, Basics of Oracle (SQL), Oracle 19c, SQL

Community Service

  • 11/01/22, Current, Richmond Tamil Sangam, Richmond, Tamil Tutor, Extending time and going back to roots and teach kids native language Tamil.
  • 02/01/22, 11/30/22, HCPS-Room Parent, Volunteer, Volunteer on behalf of Teacher for a session with School Kids

Projects

07/01/21, 12/31/21, Aspire Systems, Bangalore, India, SQL developer, Worked as an SQL developer for Fuel Farm Management System and had database designer/developer for Guest Relations Management System. Involved in all the phases of software development life cycle (SDLC) including requirement gathering and analysis, design, implementation, testing, deployment, and maintenance, related to various database projects. Developed Datawarehouse logical and physical data model using Erwin tool. Built Star Schema data model DW. Built SSIS packages to Load data from source systems to Datawarehouse. Built SSIS packages for dimension and fact tables. Designed, developed and deployed dashboard using Tableau. Depending on the size of the data in dimensions handled type 2 slowly changing dimension using merge statement or the lookup part. Loaded fact table with millions of data by partitioning and loading the fact table using metadata columns. Designed SSIS packages to handle both full and incremental data load. Used staging tables to cleanse the data and, also to transform data wherever needed. Used Foreach loop container to load multiple files at a time into the table and archived the loaded files. Deployed SSIS package to different environments and scheduled the packages using SQL Server agent job and monitored the deployed packages on the production server. Tuned the performance of the SSIS packages by avoiding the blocking transformation, by configuring the default buffer size and default buffer max rows, by using index wherever necessary.

Training

  • 01/01/22, 01/31/22, Zeyobron Analytics, Hyderabad, India, Data Engineering Foundation Course, Completed Basics on the ETL, Unix, SQL knowledge on data Engineering with End-to-End Project Implementation
  • 08/01/22, 08/31/22, Visi Info Tech, Irving, TX, USA, SQL Handson Course and Data Analyst Fundamentals, Completed Basics On The SQL Knowledge On Data Engineering
  • 03/01/23, 03/31/23, Visi Info Tech, Irving, TX, USA, Handson Course Power BI Fundamentals, Completed Basics on the data Reporting

Disclaimer

I, hereby, proclaim that the information given in this resume is true to the best of my knowledge. 01/31/24 Richmond, USA

Timeline

SQL DEVELOPER

Aspire Systems
07.2021 - 12.2021

SAP MM FUNCTIONAL CONSULTANT AND ANALYST

Capgemini Consulting Services
01.2011 - 08.2012

Bachelor of Engineering Technology - Computer Science

Anna University
07.2004 - 07.2009
Padma PriyaData Engineer