SATYA DUDALA

* ******** **, **********, ** ***** ad2vvz@r.postjobfree.com 978-***-****

https://www.linkedin.com/in/sattyadudala/

OBJECTIVE

Seeking a challenging role in the field of Business Intelligence and Data Warehousing that utilizes my skills and experience in the domain of ETL development and BI reporting.

EDUCATION

Master of Science in Information Systems, Northeastern University, Boston, MA May 2016

Coursework: Big Data, Data Warehousing and Business Intelligence, DBMS, Web Tools,

Web Design and User Experience, Application Engineering Development, Enterprise Architecture GPA: 3.5/4.0

Bachelor of Technology in Information Technology Engineering, JNTU, Hyderabad, India April 2009

PROFESSIONAL WORK EXPERIENCE

BIE/Program manager,Amazon,Massachusetts July2020-Present:

Leads the sub-team within AMXL DS NA Production Planning Team (90+ locations across North America) responsible for document controllership, change management, communication strategy and long-term labor strategy at a network level.

Built the strategies to find out how well the new trainings are doing at the fulfillmentcenters

Built the strategy in assessing how many shifts are needed to avoid hours scarcity problem that would cost millions.

Proficient programming knowledge in SQL and basic level knowledge in HTML,Javascript and css

Accountable for development of timelines, project management of all end to end data management deliverables in collaboration with cross functional team members and vendors on assigned tasks.

Primary contact between various stakeholders and technical team. Liaises directly with amazon customers.

Manages performance and quality issues.

Building learning business metrics and developing interactive dashboard using SQL and AWS solutions for NA Ops Talent Development

Gathering requirements from various stakeholders to build the dashboards.

Understand the business needs and proactively creating dashboards that are useful for business.

Experience with building ETLs using datanet.

Building the dashboards using QuickSight.

BI/ETL Software Engineer, Staples, Framingham MA June’2016 – July2020

As a member of Staples Global Data Warehouse (GDW) team, I worked on consolidating world wide sales data into a data warehouse built on Teradata.

Analyzed business requirements, discovery of data, architect technical design for flow of data, model relational tables to meet business requirements.

Developed code by translating mapping documents into ETL code and carry out deployments

Designed and developed several BTEQ scripts to load target tables in GDW.

Created Informatica Mappings using Mapping Designer to load data from various sources using transformations like SQL, Aggregator.

Developed mappings that perform Extraction, Transformation and Load (ETL) source data into target tables using informatica power center transformations like source qualifier, filter, expression, lookup, sequence generator to meet business logic

Responsible for generating reports using the data loaded through Microstrategy, BI tool. Created schemas, public objects, advanced metrics, report data manipulations based on the business requirements

Developed a report for Staples CA retail stores that help them analyze sales, compensations to store workers. I was involved in both ETL and BI reporting

Completed Power BI training and earned a certificate as there are reports that need to be developed using Power BI

Right now converting legacy applications into looker visualizations. Creating tiles,editing lookml.

Client Delivery Intern, Attivio Inc, Newton MA Sept’2015 - Dec’2015

Upgraded Attivio's internal search tool to the newer version. Refined and greatly enhanced user experience and built full-featured search applications by integrating Twigkit.

Added twitter feed to the internal search tool using Twitter4J Java library and jQuery.

Integrated Salesforce data into Attivio Intelligence Engine (AIE) and developed new database connectors for efficient retrieval and slick rendering of data.

Documented, reported and tracked bugs using Atlassian Jira.

Senior Systems Engineer, Infosys Limited, Hyderabad, India Jun’2009 – Feb’2013

Developed and executed complex SQL queries against Oracle and SQL Server databases.

Developed over 100 Jasper (a Java reporting tool) reports for inventory control at client warehouses.

Verified test data using DML, DDL, Joins and other SQL statements.

TECHNICAL SKILLS

Programming Languages: SQL

Data Integration & BI Tools:,PowerBi

Web Technologies: HTML5, CSS, XML, Jasper

ACADEMIC PROJECTS

Data Integration and Visualization

Integrated large-scale data from AdventureWorks database using SSIS and Talend. Performed error handling by creating error tables. Modeled and designed a Data Warehouse in SQL Server.

Performed data discovery and visualization by creating dashboards in QlikView, Tableau and PowerPivot.

Informatica Cloud iPaas Research Project

Performed Data Replication, Data Validation and Data Synchronization from cloud and on-premise applications using Informatica Cloud. Implemented real time data integration of twitter feeds.

Embedded integration functionality into application and implemented triggers to call REST API.

Chicago Crime Analysis

Accomplished analytics on a large Chicago crime dataset by setting up a 4-node hadoop cluster.

Performed different types of analysis and multiple MapReduce jobs using Pig, Hive, Spark and HBase.

Database Design and Implementation for a Restaurant chain

Modeled an Entity-Relationship diagram using RDBMS Normalization techniques.

Implemented Stored Procedures and Triggers to facilitate the ease of retrieving information quickly.

References furnished upon request.

Contact this candidate