Srinivasa Guntupalli
Pleasanton,CA
Summary
Information technology (IT) professional with 20+ years experience in large-scale, enterprise projects. Strong in transforming business problems into IT solutions. Extensive Data Warehouse & Mainframe development projects. Strong Project Management and Led Remote Development Team. Strong Analysis, Design, Development and Testing. Software Development Life Cycle (SDLC) using Scrum, Agile, Waterfall, VLSS. Strong Interpersonal, Written, and Verbal communication skills. Proven customer service skills.
Overview
25
25
years of professional experience
Work History
Sr Software Engineer
Albertsons
05.2022 - Current
- Migrate Rewards Application to Omni Channel Rewards Program
- Gather Requirements, Analysis, Design and Implement OCRP
- Migrate Data Stage Jobs/Sequencers to Azure using Spark Scala
- Migrate Oracle tables, Views to Cassandra
- Publish messages using Apache Kafka to load to snowflake
- Provide Job Scheduling using Cron
- Strong Scripting Skills
- Coordinate with Customers and Interface Teams
- Migrate Spark Scala jobs from Azure HDInsight to Azure Databricks
- Skills: Apache Spark, Scala, Azure HDInsight, Hadoop, MapReduce, Azure Databricks, Python, GCP, Google Big Query, Snowflake, Cassandra, Apache Kafka, Linux, Git, CI/CD, ServiceNow, Jira
Sr ETL Developer
Safeway
10.2017 - 05.2022
- Provide Reporting on Retail Data collected in the Business Data Warehouse for various Loyalty Applications Rewards, EMJU, UCA and OMS
- Gather Requirements, Analysis, Design and Implement EDW
- Develop Reusable Data Stage Jobs/Sequencers using various Transformations
- Develop SQL Scripts, Functions, Procedures, Views and SQL Performance tuning
- Develop standards for coding and failover processes
- Provide Data Stage Job Scheduling using ESP
- Strong Scripting Skills
- Coordinate with Customers and Interface Teams
- Excellent in Performance Tuning and Optimization of ETL Jobs
- Skills: Info Sphere Data Stage 11.3, Director, Designer, Oracle 11g, PL/SQL, Teradata 15.0, Snowflake, SFTP, BTEQ, FAST LOAD, MLOAD, Linux, ESP, Git, ServiceNow, Jira
Sr ETL Developer
SeaSpine
05.2017 - 09.2017
- Provide Reporting on Sales and Inventory Data collected in the Business Data Warehouse
- Gather Requirements, Analysis, Design and Develop Reusable Components
- Develop Data Stage Jobs/Sequencers using various Transformations
- Develop SQL Scripts, Functions, Procedures, Views and SQL Performance tuning
- Strong Scripting Skills
- Develop Reports using Cognos BI
- Involve in Unit, Integration Testing for the Application
- Skills: Info Sphere Data Stage 11.5, Director, Designer, Oracle 11g, SQL Server 2012, Cognos 10.2 BI, Windows Server 2012 R2
Sr Datastage Developer
Harvard Pilgrim Health Care
09.2013 - 04.2017
- Provide Reporting on Healthcare Data collected in the Business Data Warehouse
- Gather Requirements, Analysis, Design and Implement EDW
- Develop Reusable Data Stage Jobs/Sequencers using various Transformations
- Develop SQL Scripts, Functions, Procedures, Views and SQL Performance tuning
- Develop standards for coding and failover processes
- Provide Data Stage Job Scheduling using Autosys
- Strong Scripting Skills
- Coordinate with Customers and Interface Teams
- Excellent in Performance Tuning and Optimization of ETL Jobs
- Knowledge in Healthcare and PBM
- Provide Oncall Support
- Skills: Info Sphere Data Stage 11.3, Director, Designer, Oracle 11g, PL/SQL, Teradata 15.0, SFTP, BTEQ, FAST LOAD, MLOAD, Linux, Autosys, Remedy, Work Bench, Jira, Subversion
Sr Datastage Developer
Boeing
04.2013 - 06.2013
- Provide Reporting on Financial Data collected in the Business Data Warehouse
- Gather Requirements, Analysis, Design, Coding, Testing and Implement EFBI
- Develop Reusable Data Stage Jobs/Sequencers using various Transformations
- Develop SQL Scripts, Functions, Procedures, Views and SQL Performance tuning
- Involve in Unit, Integration Testing for the Application
- Provide Data Stage Job Scheduling using Autosys
- Strong Scripting Skills
- Excellent in Performance Tuning and Optimization of ETL Jobs
- Skills: Info Sphere Data Stage 9.1, Quality Stage, Director, Designer, Oracle 11g, Teradata 14.0, SFTP, Unix, Autosys
Sr Datastage Developer
Verizon Enterprise Solutions
01.2011 - 11.2012
- Company Overview: CUST360
- Provided reporting on Order Data collected in the Business Data Warehouse (VzBDW) for Order Entry
- Involved in all Phases of Project Life Cycle
- Coordinate with Customers & Interface Systems
- Gather Requirements, Analysis, Design, Coding, Testing
- Develop Reusable Data Stage Jobs/Sequencers using various Transformations
- Develop SQL Scripts, Functions, Procedures, Views and SQL Performance tuning
- Involve in Unit, Integration Testing for the Application
- Set up Connectivity thru SFTP, NDM and provided Production Support for the Application
- Involve in Design and Code Reviews
- Monitor Data Stage Jobs for Performance Issues and Troubleshoot
- Excellent in Performance Tuning and Optimization of ETL Jobs
- Provide Data Stage Job Scheduling
- Strong Scripting Skills
- CUST360
- Skills: Info Sphere Data Stage 9.1, Quality Stage, Director, Designer, Oracle 11g, Teradata 13.0, PL/SQL, Connect Direct, SFTP, FTP, BTEQ, FAST LOAD, MLOAD, FASTEXPORT
Sr Datastage Developer
Verizon Business
03.2005 - 12.2010
- Company Overview: FINTRAN
- Provide reporting on billed and booked financial data collected in the Business Data Warehouse (VzBDW)
- Coordinate with Customers & Interface Systems
- Involved in all Phases of Project Life Cycle
- Gather Requirements, Analysis, Design, Coding, Testing
- Develop Reusable Data Stage Jobs/Sequencers using various Transformations
- Develop SQL Scripts, Functions, Procedures, Views and SQL Performance tuning
- Involve in Unit, Integration Testing for the Application
- Set up Connectivity thru SFTP, NDM and provided Production Support for the Application
- Monitor Data Stage Jobs for Performance Issues and Troubleshoot
- Involve in Design and Code Reviews
- Excellent in Performance Tuning and Optimization of ETL Jobs
- Provide Data Stage Job Scheduling
- Strong Scripting Skills
- FINTRAN
- Skills: Data Stage 7.5.3, Oracle 10g, Teradata 12.0, PL/SQL, Connect Direct, SFTP, FTP, BTEQ, FAST LOAD, MLOAD, FASTEXPORT
Sr Staff Specialist
MCI Communications
01.2004 - 12.2005
- Company Overview: IAR
- Developed an Internal Accounts Repository System consisting of all Internal Revenue Accounts
- Develop PL/SQL Code, Stored Procedures using Oracle, UNIX shell Scripts, PHP scripts
- IAR
- Skills: Oracle, PL/SQL, UNIX, PHP
- Impact: All Internal Revenue Accounts Repository
Staff Specialist and Analyst
MCI
03.2000 - 12.2003
- Primary IT liaison for all applications that use Business Markets Order Entry and Billed Revenue and to provide a system that presents data in a common format with consistent product identification
- Reduced the response time to business changes, eliminating redundancy, enhancing product visibility, ensuring application reconciliation and decreasing ongoing maintenance
- Transformation of Business Markets revenue & customer data to generate common format feeds
- Analyzed specifications, modifying the existing, building and testing new Code/Jobs/Process
- Analysis & Documentation of Business Opportunities
- Provided Production Support, improved performance by implementing code changes
- Skills: VS COBOL II, JCL, DB2, VSAM, EASYTRIEVE, REXX, SAS, ISPF/PDF, File-Aid, QMF, Xpediter, SuperC, PDSMAN, SPUFI, CA-7, Syncsort
Education
B.S. - Mechanical Engineering
JNTU University
Skills
- Apache Spark, Scala,Azure HDInsight,Hadoop,MapReduce
- Azure Databricks,Apache Kafka,Python
- GCP,Google Big Query,Snowflake,Cassandra
- Linux,Git,CI/CD,ServiceNow,Jira,Datastage
Technologies
Sun Solaris 5.0, IBM 3090 Mainframe, MS Windows, UNIX, LINUX, Solaris, MVS/ESA, Windows NT/98/2000, C, C++, Java, Java Script, HTML, XML, SQL, PL/SQL, VS COBOL II, JCL, EASYTRIEVE, REXX, PHP, SAS, PERL, Scala, Oracle 12c, DB2, Teradata 15.0, SQL Server 2008, Snowflake, Google BigQuery, Lotus Notes, IBM IIS Data Stage 11.3, Quality Stage, Director, Designer, Apache Spark, Erwin, Toad, SQL Developer, JBuilder, Connect Direct, SFTP, FTP, Crontab, BTEQ, FAST LOAD, MLOAD, FASTExport, TPump, MS Excel, MS Project, MS Visio, ISPF/PDF, File-Aid, QMF, Xpediter, SuperC, PDSMAN, SPUFI, CA-7, ESP, Syncsort, VSAM, IBM Rational Clear Quest, Autosys, BMC Remedy, Jira, ESP, Servicenow, IBM Rational Clear Case, CVS, Panvalet 14.3, Endevor 3.7, Changeman, CA Work Bench, Subversion, Git
Timeline
Sr Software Engineer
Albertsons
05.2022 - Current
Sr ETL Developer
Safeway
10.2017 - 05.2022
Sr ETL Developer
SeaSpine
05.2017 - 09.2017
Sr Datastage Developer
Harvard Pilgrim Health Care
09.2013 - 04.2017
Sr Datastage Developer
Boeing
04.2013 - 06.2013
Sr Datastage Developer
Verizon Enterprise Solutions
01.2011 - 11.2012
Sr Datastage Developer
Verizon Business
03.2005 - 12.2010
Sr Staff Specialist
MCI Communications
01.2004 - 12.2005
Staff Specialist and Analyst
MCI
03.2000 - 12.2003
B.S. - Mechanical Engineering
JNTU University
Similar Profiles
Vishwanath UpadhayayVishwanath Upadhayay
Lead Android Developer at AlbertsonsLead Android Developer at Albertsons
Angela CaggianoAngela Caggiano
Produce Clerk/Assistant Produce Manager at AlbertsonsProduce Clerk/Assistant Produce Manager at Albertsons
ADAM VEILLEAUXADAM VEILLEAUX
Courtesy Clerk/Cashier at AlbertsonsCourtesy Clerk/Cashier at Albertsons
Darius Justin FordDarius Justin Ford
Courtesy Clerk at AlbertsonsCourtesy Clerk at Albertsons
Gwendolyne NelsonGwendolyne Nelson
ECE Teacher's Assistant at Pleasanton Unified School DistrictECE Teacher's Assistant at Pleasanton Unified School District