Data Aws

VENKATA BUDDHARAJU

***.****@*****.***

Ph: +1-989-***-****

https://www.linkedin.com/in/venkata-buddharaju/

PROFESSIONAL SUMMARY:

• 8+ years in Information Technology with expertise in Business and data analysis, database management and consulting with Financial and Aviation industry experience.

• Certified AWS Solution architect Associate, SAP certified Associate and Lean Six Sigma greenbelt.

• Experienced in extracting, transforming and loading (ETL) data from files, spreadsheets, database tables and other sources in to RDMS and Cloud based Data warehouses.

• Experienced in developing conceptual, logical models and physical database design for OLTP and OLAP systems.

• Proficient in data mart design and creation of cubes using dimensional data modeling – identifying facts, dimensions, dimensional hierarchies, star schema and snowflake schema. Well versed in normalization / de- normalization techniques.

• Experienced in relational databases Teradata, MS SQL server, Oracle, and NoSQL databases like mongoDB, DynamoDB

• Hands on experience in writing SQL queries in Teradata, SQL server, Oracle Db, Spark and Hive.

• Experienced working on cloud data platforms like AWS and Palantir Foundry.

• Experience with Hadoop Platform (HDFS, Hive, HBase, Spark, Kafka, Sqoop, Flume and Pig)

• Exposure in overall SDLC including requirement gathering, development, testing, debugging, deployment, documentation, production support and Extensive experience in Project Management methodologies.

• Efficient in analyzing and documenting business requirement documents BRD and functional requirement documents FRD along with the Use case modeling and UML. SKILLS

AWS Certified SA and SAP Certified Associate

ER Studio, Erwin, SAP Power Designer

Teradata, SQL Server, Oracle DB, Hive,

AWS, Palantir Foundry, Python

Cognos, Tableau, Alteryx, Ab Initio

DataStage, Informatica, Sqoop, Spark

EDUCATION:

MS, Information Systems GPA 3.85 Central Michigan University, MI 08/15 – 12/16 BE, Electrical Engineering GPA 3.7 Andhra University, India 06/06 – 03/10 PROFESSIONAL EXPERIENCE:

United Airlines Houston, TX

Senior Data Modeler 07/19 – Present

• Experience in analyze requirements, developing, validating, publishing, maintaining LOGICAL and PHYSICAL, Relational and dimensional data models for cloud platform.

• Experienced in designing Data pipelines using Python and ETL tools in AWS cloud platform.

• Designing the data sourcing, data staging and ETL process. Mapped the data between the source and targets.

• Provide guidance on data taxonomy for product attribution.

• Experience working on Accounting, Operational, Commercial portfolios.

• Provide guidance on models for application data, and master product data (hierarchy, attribution)

• Work with Business Analysts, Data Architects, Software developers, DBAs to achieve project objectives.

• Prototyping on physical models (Hadoop Hive, SQL Server, PostgreSQL, Teradata)

• Worked with the development teams to document the transformation rules for data migration for reporting purposes using Python and SQL.

• Knowledge of various data warehousing practices including dimensional modeling skills.

• Experience in using ticket tracking and project management tools like Confluence, JIRA.

• Developed data mapping documents between Legacy, Production, and User Interface Systems. Environment: Erwin, AWS, Teradata, Oracle, SQL server, Ab Initio, Palantir Foundry, Tableau, Pyspark, Python, Confluence, JIRA, Visio, Agile, Waterfall.

American Airlines Tulsa, OK

Senior Data Modeler 04/17 – 07/19

• Demonstrable experience in analyze requirements, developing, validating, publishing, maintaining LOGICAL and PHYSICAL data models.

• Demonstrable experience using data modeling tools like ER Studio and Erwin.

• Perform a thorough gap analysis, data modeling, data discovery & data mapping tasks on complicated data sets with potentially complex data integration scenarios with limited supervision.

• Design and implement highly performing data pipelines in Teradata and SQL

• Work with Business Analysts, Data Architects, Software developers, DBAs to achieve project objectives.

• Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy.

• Worked with the ETL team to document the transformation rules for data migration from OLTP to Warehouse environment for reporting purposes.

• Created tables, views, sequences, indexes, triggers, table spaces, constraints and generated SQL scripts for physical implementation.

• Designed the data sourcing, data staging and ETL process. Mapped the data between the source and targets. Environment: ER Studio, SAP Power designer, Teradata, Oracle, SQL server, IBM Datastage, Informatica, Cognos, Tableau, Alteryx, Apache Hive, Apache Pig, Apache spark, Azure, AWS, Visio, Agile, Waterfall. ADP, LLC Hyderabad, India

Senior Analyst 08/10 – 07/15

ADP is a provider of human resources management software and services. ADP is a global provider of cloud-based Human Capital Management (HCM) solutions that unite HR, payroll, talent, time, tax and benefits administration, and a leader in business outsourcing services, analytics and compliance expertise.

• Worked closely with clients to gather project requirements during the blueprint phase and to resolve issues during the User acceptance and post go-live phases.

• Translates functional and technical requirements into detailed design

• Provides data design/data movement services to help develop solutions that improve overall quality of data and support enterprise data strategies.

• Implemented SAP HCM Payroll, Time, and Employee and Manager Self Service portal applications for multiple clients.

• Knowledge and experience of ERP applications or processing financial data, including interface management experience and working knowledge of data warehousing, data transformation, or IT production support.

• Experience with responsibility for leading efforts or teams in organizational change management, or related area

(training, communications) on large or complex process, technology or organizational change projects. Environment: SAP ECC 6.0, Financial Accounting, SAP BW, ESS/ MSS, SAP Lumira, Visio, Informatica, Agile

Contact this candidate