Satya Vatti

Green Card Holder.

Phone: +1-408-***-****

Email: adjoe5@r.postjobfree.com

Summary

Over 20 Years of experience as a Sr. DW Analytics Engineer/Bi Lead, experienced in data modeling, integration, data warehousing, application development with hands on knowledge of all the phases of software development and experience with managing a team of Developers.

Expert in data analysis, migration, Data Pipelines, modeling, integration and data warehousing concepts, application and analytics.

Used MDM suite of tools to design, develop, optimize and support related to Customer, product and Supplier Master Data.

Good understanding on Big Data Architecture, Data Science.

Extensive experience in data architecture, ETL, data modeling, star and snowflake schemas, AWS

Extensive experience in SQL debugging, tuning and Query optimization.

Extensive experience in designing and implementing server side stored procedure, package, Database Triggers on high volume transactional Systems and Unix Shell Scripting.

Hands on experience with ETL tools like Talend, Kettle(Pentaho), Informatica 8.x/9.x and Python programming, AirFlow

Designed, Developed and implemented the in house developed ETL solution for Flextronics.

Have very good communication and interpersonal skills.

SKILLS:

Languages:

SQL, PL/SQL, C, SQL* Loader, HTML, Python(Pandas, NumPy, Matplotlib),

Data Pipelines using Python(SQLAlchemy), JavaScript, VB Script, ASP, UNIX Shell Scripting/Java/XML

RDBMS:

AWS(Redshift), Google Cloud Platform, Oracle 8i/9i/10G/11G,Vertica Analytic Database 6.0/7.0,Teradata, Postgres 8.1,9.2 and SQL Server,MySQL

Tools:

Kettle(Pentaho) 4.0.1/5.0.2, Talend 5.0.1/5.0.3/5.1.1/6.0.1/7.1, Hive, Oracle Forms 6i/10g, Cognos 7.3, Informatica 8.1.1, OWB,Business Objects, SAP BI/BW, Oracle Application Server, 9IAS/10G,Tivoli Job Scheduler, Open ModelSphere 3.2,Schedulix 2.6, Mirth Connect 3.2,Qlikview,S3, Spotfire, PyCharm, Git, Jupyter, AirFlow

EDUCATION BS in Engineering, Gulbarga University.

PROFESSIONAL EXPERIENCE:

Sr. DW Analytics Engineer /BI Lead – Artha Solutions - March ‘18 – Sept ‘20

Client: Maxis Communications

Designed, developed, managed and implemented of ETL load solutions in DW using Talend ETL tool and Vertica as Database.

Responsible for design, development, extraction and implementation of master data like demographics of Subscribers, key words, batches and transactions like deals in staging area and Operational Data Store. Implemented the master data of prepaid and post paid subscribers from different sources.

Responsible for design, development and implementation of Dimensions and Facts in DataMart being used for Reporting. Using this Data, calculated the summary data for daily and monthly reports.

Involved in writing Queries and fixing the performance issues in BigQuery.

Developed Processing, archiving the file processing and calling the procedures to populate the data using Python.

Sr. DW Analytics Engineer/BI Lead – Symphony Advanced Media, CA June ‘15 – April ‘17

Symphony Advanced Media is a high-tech company that collects the multi-screen media consumption.

Designed, developed and implemented of ETL load solutions using Talend ETL tool and Vertica as Databases for analytics of media consumption.

Load the data into AWS(Redshift) for reporting and archiving the files into AWS(S3).

Responsible for design, develop and implementing the business logic to identify and arrive at the frequency at which Ads were watched by a panelist in Mobile devices and PC.

Designed, developed and implemented of ETL load solutions using SSIS tool and SQL Server as Databases and implemented Survey Analysis.

Worked on reporting tools like Qlikview.

Sr. Data Architect/Tech Lead – Quantros, Milpitas, CA May ‘13 – April ‘15.

Quantros is a health care software development company.

Designed, developed and implemented of ETL load solutions using Pentaho Kettle and postgres as Database. Provided proper resolutions for data integration issues.

Implemented partitioning in the tables to resolve the bottle necks in the parallel processing architecture. We use patient safety/quality /Admission/Discharge data for Analytics like Quality KPMs, Safety KPMs etc.

Sr. DW Engineer/Tech Lead – Decision Technologies - March ‘12 – April ‘13

Clients:

Ocwen Financial Corporation

Involved in the data analysis of the legacy system for data architecture in the enterprise.

Involved in design of the data modeling for the data mart using the tool open model sphere.

GreenHeck Fan Corporation, Wisconsin

Involved in the data analysis of legacy system. Develop and implement strategies, policies and standards for data architecture in the enterprise. Involved in design, writing specifications, development and implement of Data modeling, ETL / MDM project to create a new primary system of record for motor data using Talend.

Verisign,MountainView:

Actively involved in the Data Analysis. Identified the relationships of the tables by looking at the data and developed the ER diagram as Verisign doesn’t have proper documentation.

Symantec, Mountain View:

Involved in the design and development of the Authentication BI(AuthBI) project.

Actively involved in data analysis, design the data modeling, writing the intensive sql queires for the reports in Hyperion. Actively involved reconciliation of the BI data with source systems.

Sr. DW Solutions Architect/BI Lead – Flextronics, CA September ‘01 – March’ 12

Job Description:

involved in all activities relating to Business Intelligence development projects including resource management, overall project planning and tracking, and delivery of systems solutions supporting the business community.

Architect the solutions for Materials and Finance database & Web based applications.

Involved in design, writing specifications, development and implement of Data modeling, ETL / MDM project related to Customers, Suppliers for Materials. Implement policies and controls designed to ensure that enterprise master data is accurate, complete. Maintain all customer/supplier master data in MDM including entry of new customers as well as maintenance of existing customer master data and mapping Global Customer/Supplier data.

Design, Develop and Implement DSS Data warehouse.

Manage a team of developers to maintain and support the database applications.

Responsible to perform database work with database management and overall performance of the Business Intelligence and reporting initiatives. Involved in all activities relating to database management, BI development projects including resource management, overall project planning and tracking, and delivery of systems solutions supporting the business community.

SQL debugging, tuning and Query optimization on a database intensive code belongs to PL/SQL.

Involved in design/development of many reports/cubes/self service reports in Cognos and Business Objects.

Actively involved in design, development of dimensional modeling in SAP BI/BW.

Providing technical database-related leadership on large development projects.

Involved in Dimensional data modeling, star schemas and other data warehouse considerations like data mart, Cube.

Developed UNIX shell scripts to automate daily activities and customer extracts.

Environment: Oracle 8i/9i/10G/11G, SQL, PL/SQL, SQL* Loader, Cognos, Business Objects, SAP BI/BW, Oracle Application Server/9IAS/10G AS, V.B 6.0, .NET,HTML, JavaScript, Windows NT, UNIX, Optika Work Flow Solutions, Outlook Soft Everest and Tivoli Job Scheduler.

Contact this candidate