Sambaiah Marri

12+ years of experience in Data Warehousing mainly into Data Analysis, Power BI Reporting, Business Analytics, ETL Design, Development, Implementation and Production Support projects.

Understanding of Agile/Lean leadership principles; proficient in agile team development as well as awareness of team training opportunities. Strong problem solving & technical skills coupled with people management and confident decision making for enabling effective solutions leading to high customer satisfaction and low operational costs. Managed multiple complex projects and ensuring the delivery on time and budget. Excellence in leading teams across levels through mapping of skills for different roles and during the project phase and guiding team members and enabling knowledge sharing among the team. Expertise in Requirement Analysis, Functional Analysis, Design, Development, Implementation, Testing, Debugging, Productions Support and Maintenance of various Applications. Good interpersonal skills at all levels of contact in a wide variety of situations, demonstrating the ability to listen and influence, and to relate to business customers. Involved in Migration projects and End-to-End developments and testing. Giving Knowledge Transfer to new team members regarding the specification as well as the testing process and tools used in the project. Helped Customers in exploring efficient and cost-effective methods for future requirements. IT Budget & Finance management., Organization effectiveness, ITIL Program Management, IT Infrastructure, SDLC, Compliance, Security and Engineering projects, SOX implementation, Integration, Vendor and Contract Management and Transition Management. Delivered sustainable, quality, solutions & services to drive improvements and realize business value to clients in different areas. Managed, Implemented, Architecture Design, Blueprint, Gap Analysis, Testing, Deployment of several complex full lifecycle Global Business Transformation projects. Managed Entire Applications Development, Support & Maintenance Program. Onshore/ Offshore Team Management with a team size of 30 resources. Preparing weekly and monthly application metrics report, also sending the End of Month Processing report to the Business stakeholders. Extensively used ETL methodology for supporting data extraction, transformation and loading process in a corporate-wide ETL Solution using Informatica, Snowflake and Teradata. Well versed with agile methodology which includes Sprint planning, Daily standup calls, Sprint review’s, retro’s, Backlog grooming’s and closure. Works with colleagues to review the operation and effectiveness of resourcing programs within the organization and contributes ideas for changes and improvements as appropriate. Maintains up-to-date knowledge of a broad range of emerging technology trends and identifies opportunities where technology might be deployed to deliver business improvements and competitive advantage. Uses metrics and tools to understand team performance and efficiency; takes actions to improve the efficiency of the team.

Infosys Limited, Technology Lead, Atlanta, GA, USA, 06/2022, Present,  

Infosys Limited, Technology Lead, Hyderabad, India, 10/2018, 06/2022, 

NTT Data Global Delivery Services Pvt Limited, Business Consulting Sr Consultant, Hyderabad, India, 09/2016, 08/2018

Inventech Info Solutions Pvt Ltd, Sr Teradata Data Base Administrator, Bangalore, India, 06/2014, 09/2016

Client: T-Mobile.

T-Mobile has an enterprise data warehouse built on the prepaid and the postpaid customer data coming from different billing systems. This project involved in developing Financial Analytics Data Store(FADS) data warehouse and integrated data warehouse which helps to analyze their business by based on reports on top of the FADS/IDW Data warehouse system. Snapshots and scorecard is built on the warehouse. Jobs are scheduled to refresh the data daily., Work with Solution Architect & Project team to understand the client requirement and gather information on the servers sizing and configurations. Prepare the architect diagrams and creating the resource in Azure for Informatica tools and documentation. Responsible for migrating T-Mobile's data assets from on-premises (Teradata) environments to the cloud (Snowflake) while ensuring data integrity. Prepare the documents for the new installations and upgrades for the team reference and mentor the team in various technical aspects. Address Doctor implementation and web service call from different applications. Implemented Load balancing, high availability on platforms. Responsible for EDC resource scanners creation, scheduling and maintenance support, ensuring the resources completes successfully. Responsible to SSL configuration and LDAP authentication. Integration of the Informatica jobs with Control-M scheduler. Troubleshooting the Power center workflows and MFT monitor job failures. Worked with Informatica Developers on the best practices and helped them in achieving the performance. HDFS File system management and Hadoop cluster monitoring and maintenance. Managing the RHEL Linux servers and support. Responsible for the backups and restoration process. Outages Handling, for Password Changes, Patch installation (Hot Fixes /Software’s), Restarting the Services, Network Changes and for any global/local outages as per change management updates. Co-ordinate with relevant teams to troubleshoot P1/P2 issues and lead the conference call for speedy solution. Incident, change & problem Management relating to Platform Ops across all supported applications.

Roles and Responsibilities:

• Work with Solution Architect & Project team to understand the client requirement and gather information on the servers sizing and configurations.
• Prepare the architect diagrams and creating the resource in Azure for Informatica tools and documentation.
• Responsible for migrating T-Mobile's data assets from on-premises (Teradata) environments to the cloud (Snowflake) while ensuring data integrity.
• Prepare the documents for the new installations and upgrades for the team reference and mentor the team in various technical aspects.
• Address Doctor implementation and web service call from different applications
• Implemented Load balancing, high availability on platforms
• Responsible for EDC resource scanners creation, scheduling and maintenance support, ensuring the resources completes successfully
• Outages Handling, for Password Changes, Patch installation (Hot Fixes /Software’s), Restarting the Services, Network Changes and for any global/local outages as per change management updates.
• Co-ordinate with relevant teams to troubleshoot P1/P2 issues and lead the conference call for speedy solution
• Incident, change & problem Management relating to Platform Ops across all supported applications
• Act as primary contact for coordinating all daily operations involving the team to higher management and client
• Extensively worked creating the Folders, Labels, Object Queries, Deployment Groups and migrating the code across all environments
• Troubleshoot and monitored around 5000+ batch jobs per shift which are distributed on Informatica/Hadoop and Tidal (Enterprise scheduler)
• Responsible for the housekeeping activities on Linux servers.
• Worked on the enhancements of mappings to achieve the performances Troubleshooting issues with Informatica workflows and Hadoop oozie jobs involving infrastructure issues(memory), Java issues (out of range) & Scheduler issues
• Working experience in Hadoop Hortonworks, Oozie, Ambari, HIVE, Sqoop
• Preparing weekly and monthly application metrics report. Also sending the End of Month Processing report to Business
• Imparted 24 x 7 on-call support and handled daily interactive and batch processing operations.
• Co-ordinate with relevant teams to troubleshoot P1/P2 issues and lead the conference call for speedy solution

Datum Info Systems, Teradata Database Administrator, Hyderabad, India, 11/2010, 06/2014. 

Client: Visa Inc

Visa is a global payments technology company that connects consumers, businesses, banks and governments in more than 200 countries and territories, enabling them to use digital currency instead of cash and checks. Visa has built one of the world’s most advanced processing networks. It’s capable of handling more than 24,000 transactions per second, with reliability, convenience and security, including fraud protection for consumers and guaranteed payment for merchants., 

Roles and Responsibilities:

• Use of Data Dictionary/Directory tables and views to manage the system. Maintenance activities like Check Table, Scandisk, Packdisk using Ferret Utilities.
• Used Teradata Index Wizard to identify the good SI for a query and workload. Used Teradata Statistics wizard to identify the missing and extra stats.
• Creating and managing user accounts with appropriate security.
• Prepared shell scripts for monitoring the system. Refreshed the data by using fast export, multiload, fastload and ARC utilities.
• Assisting developers/users to tune queries. Overseeing daily and weekly back-ups.
• Performance monitoring, investigating long running queries and Tuning queries with the analysis of Business objects.
• Teradata Administrator – graphical Windows tool to assist in administration. Teradata Manager – suite of Windows tools for performance management, etc.
• Teradata Analyst Toolset – Index Wizard, Statistics Wizard, and Teradata SET. Teradata Database Query Manager – job scheduling facility. System utilities – e.g., dbscontrol, ferret.
• Used TDWM for defining the work loads for ETL’s and Reporting.
• Used TSET for copying the stats and other information and analyze the issue.
• Automated the stats collection process using shell scripts.
• Analyzing data and implementing the multi-value compression for optimal usage of space. Granted & Revoked Object Rights, System Rights on Databases/ Users/ Roles.
• Reviewing the projects in all the phases and Migrating the database objects.
• Defined a backup process for DB with ARC utility and Tara. Active participation in Teradata upgrade activities.
• Worked with BI Production Supporting team for production database issues.