Uploaded File
Snehal
Snehal.patels@gmail.com
678-984-5299
Senior System/Software Engineer
25 years experience W2
0
Recommendations
Average rating
12
Profile views
Summary

  • 20+ years of experience in software development, devising customized and innovative solutions, meeting ever-changing business requirements
  • Telecom, Finance/RevOps and Medical/EHR domain
  • 14+ years of experience as hands-on technical team lead role, leading, mentoring and managing software engineers\projects onshore and offshore in fast-paced environments at top tier firms
  • Proven track record of leading and developing software/system projects with emphasis on data processing, EDW, BI for revenue operation, contract life cycle and corporate tax system
  • Software Development Life Cycle (SDLC) experience using Agile-Scrum (Rapid Application Development) and waterfall, CI/CD, Dev Security Operations practice for Data warehouse, BI Analytics, web-based n-tier architecture, and client/server systems
  • Hands-on development and SDLC involvement including requirement analysis, functional and high-level design, design walk through, development, code review, test plan, test data setup and level 1 to 3 production support
  • Experience in Enterprise application integration, data transformation (legacy system synergy due to mergers & acquisition), data profiling, data analysis, ETL, ELT, and batch processing, Python
  • Proficient in relational and dimensional modeling, access control, SCD, CDC, data integration, data warehouse and DB performance
  • Experience in software/system configuration management, database upgrade/migration and connection pooling
  • Analytical problem-solver, able to anticipate issues, alter/create new systems that streamline operations, resolve concerns and improve efficiency
  • Team player and individual contributor Technical:

Experience
Senior System/Software Engineer
Information Technology
Aug 2014 - present
Tax Processing Automation (TPA) System processes AT&T and its subsidiary companies Sales and Use Taxes to all jurisdiction. TPA process $650-900 million tax payment each month. TPA framework was vendor owned (until 2018) and supported for many years (until 2015). As a Lead developer/designer, my key responsibilities were to be vendor free environment that includes to Learn TPA, replace vendor team with in-house team and replace vendor owned system to in-house developed framework. Current initiative is to migrate TPA to Azure cloud platform.
  • Replaced vendor resources for day to day support and enhancement within one year, as per plan. Within another four years (2015 to 2018), along with day to day support and enhancement, design, develop and implement AT&T owned system that includes framework, rule engines, ETL/ELT process, data retention and retrieval process to support tax audits.
  • Responsible to analyze, reverse engineering, design/support, dynamic and parameter driven multi instance ELT, data processing and DW solutions for AT&T Tax Processing Automation system to file AT&T and its subsidiary monthly/yearly taxes
  • Responsible to enhance and provide support for tax compliance processes, storage of monthly raw and processed tax data as per AT&T retention policy. Maintain Business Objects to access raw and processed tax data for tax audits.
  • Responsible to design and implement tax data specs for M&A (Direct TV) and onboarding various legacy billers, CFAS, EDW data to Tax Processing Automation platforms by applying cleansing, data standardization, enrich data through mapping and custom rules to integrate data for filing AT&T subsidiary Sales and Use taxes
  • Manage day to day operation support for Property and Fixed Assed tax applications
  • DB modeling, process/query performance tuning. Design and develop various jobs to extract, cleanse, transform, integrate and process data in batch mode.
  • Developed Technical Specification from Business Requirements and Functional Specification Artifacts including SOP
  • Prepare deployment plan for enhancements, oversee the production deployment and enforce maintenance of non-production environment.
  • Serve as technical resource to teams of offshore and onshore programming resources.
  • Lead requirement gathering, analyze design with process/program objective, input/output requirement, scalability and optimized solution for various tax processing
  • Upgrade system code to be compatible for Oracle 11g R2, Unix to Linux, DB migration from On-Prim to Cloud Tools: Data Modeler, Toad, TLC framework, SQL Loader, ETL/ELT, SAP Business Object, Crystal Reports, Linux, Shell script, Windows server, Data archival, CI/CD
Application Development Data Warehousing ETL Analysis Business Requirements Auditing Business Objects Compliance Continuous Deployment Continuous Integration Data Cleansing Data Mapping Crystal Reports Database Maintenance M&A Linux Oracle Oracle 11i Performance Tuning Requirements Gathering Shell Scripts Software Engineer SQL Loader SQL Technical Specifications TOAD UNIX Windows Windows Server Agile Methodology Database Design System Design Test Planning
Remove Skill
Systems Engineer
Information Technology
Jul 2013 - Jul 2014
Key responsibility to replace fifteen year old GE Capital compliance IT team to new IT team (from one off-shore to another) to support Synchrony Financial spin-off. Another initiative was to improve IT infrastructure such as migrate to new data center with upgrade of servers OS, DB and COTS version so new company can focus on business then IT. Responsible for interacting with internal customer, and other technical resources to deliver solution for a wide variety of applications. Applications supported are a mix of commercially available (Fircosoft filtering and Kronos) and internally developed ALM and HR platform. Applications deployed supports the functional areas of Compliance, Human Resources and Finance. Essential responsibilities:
  • Played a pivotal technical role in the successful transition of GDC resources (for 15 years), data center, and software upgrades to new technical team
  • delivering high-quality solutions on time and within budget
  • Applied accrued experience and skills across multiple application development teams in a fast-moving multi-location environment as a designer, developer, and tester
  • Developed Technical Specification from Business Requirements and Functional Specification Artifacts including SOP
  • Worked closely with an experienced staff comprised of both GE FTE resources and/or 3rd party contractors.
  • Architected and designed ETL/ELT, reconciliation and audit process
  • Serve as technical resource to teams of offshore and onshore programming resources.
  • Lead requirement gathering, analyze design with process/program objective, input/output requirement, scalability and optimized solution for GECOM interface enhancement and employee WLS process
  • Integrated various solution components using variety of tools and languages for a variety of functional applications including: ETL/ELT design, Ab Initio graph, batch processing, DB development, various scripting (shell, JIL, batch), XML and J2EE Components for Unix and Windows Server 2008 Tools: ERwin, Data Modeler, IBM InfoSphere, Toad, Ab Initio, SQL Loader, Fircosoft
Application Development ETL Analysis Business Requirements Ab Initio Compliance Data Center Data Modeling Database Upgrades Erwin Data Modler Human Resource Requirements Gathering J2EE Scripting SQL SQL Loader Systems Engineering Technical Specifications TOAD UNIX Windows Windows Server XML HP ALM Agile Methodology System Design Test Planning
Remove Skill
Data Modeling/Architect
Information Technology
Aug 2012 - Jul 2013
I was hired as Lead System Performance Engineer, after five months I was assigned with primary role as Data Modeling/Architect and spearheaded system performance responsibility Responsible for data modeling and database design (ODS, Data Mart, OLTP) for (JITR) Just In-Time Rating system that process network data to billing systems. Integration to Usage Broker systems to processes all Verizon wireless network usage data for rating and billing.
  • Design ODS as per requirement, deploy ODS, load and maintain data with CDC replication for subscriber and ETNI
  • Design OLTP DB for UB/JITR and Error Handling Systems
  • Design Revenue Operation Data Marts for reconciliation and Error correction
  • Data modeling responsibility includes access control, naming standard, data stewardship, following data governance, creation of DDL/DML, deployment, replication, data flow walkthrough, DB development code review Tools: ERwin, Data Modeler, IBM InfoSphere, Toad, Informatica, SQL Loader
Application Development Analysis Business Requirements Data Governance Data Marts Data Modeling CDC Data Replication Database Design Erwin Data Modler OLTP SQL SQL Loader System Design Systems Integration TOAD Wireless Networks Billing Informatica Agile Methodology
Remove Skill
Sr. Software Engineer - Data Warehouse and BI Analytics
Information Technology
Feb 2012 - Jun 2012
Design, development and support of Mobile Marketing OLAP DW system. DW enhancement and BI Analytics reporting for latency/performance, traffic, campaign and billing. Data Warehouse process improvements focusing on ETL, partitioning, materialized views, SQL tuning and logs.
  • DW ETL process to convert router non-relational data in to fact and dimension model. Daily volume of 25-30 million rows.
  • Various batch processing of scheduled marketing campaigns for analysis and billing. Volume 5 to 10 million rows.
  • Automated Star Service monthly billing process using shell script, PL/SQL and ETL processes.
  • Development of customer facing latency and performance reports for marketing campaign.
  • ETL job using Talend File delimited and positional metadata, tMap, tFilterRows, Row generator, tLogRow and output to Oracle database or data file
  • Analysis and design of real time data refresh and new BI reporting platform using Vertica (Analytical DBMS) and Tableau for data visualization
  • internal and customer facing portal.
Application Development Data Warehousing ETL Analysis Business Requirements Analytics Data Visualization Metadata OLAP Oracle Process Improvement Shell Scripts Software Engineer Tableau SQL Talend Studio Agile Methodology Database Design
Remove Skill
Lead System Consultant - System Analysis and Programming
Dec 1998 - Oct 2011
Responsible for design and implementation of SDLC for contract and billing related IT systems for revenue operation for Verizon Communications' global footprint.
  • Analyze and assimilate ever-changing business requirements and users' needs by development, enhancement and integration of various contract and billing systems.
  • Collaborate with project managers and cross functional business group to define change control and ensure on-time completion of project deliverables.
  • Develop project design, walkthrough, data integration, configuration management.
  • Developed J2EE application components & back end processing to ease implementation of business logic.
  • Designed and implemented various interfaces between revenue operation applications via data feeds, web services (SOA), ad-hoc reports to streamline business process.
  • Implemented connection pooling using JAVA to support increased 20% load towards month end.
  • Fine-tuned time-consuming queries identified by AWR report, using indexes, hints, and partitioning, materialized view/logs and rewrote many of the queries to substantially improve 80% response time.
  • Worked extensively with DBA to upgrade, access control and migrate database to grid.
  • Played a key role in building off shore development team, providing system training to bring them up to speed to participate in development.
  • Ensured timely production support and issue resolution including level 3 production support. Audit Engine (Primary Project)
  • Data Warehouse: Design and development of ETL processes to consolidate 16 legacy systems data into data warehouse allowing a one stop audit, auto pilot, verification process, and automated work flow management for various user groups across field reps, contract implementation, and revenue operation.
  • Change Data Control (CDC) and Slowly Change Dimension (SCD) design and implementation.
  • Development and support of ETL processes using SQL Loader, external tables, global temp tables, PL/SQL, procedures, packages, UNIX shell scripts and Talend tool.
  • Responsible for logs, data archive and purge functionality.
  • Development of batch process using PL/SQL, UNIX scripts to apply business rules, WFM, and audits\exceptions processing on consolidated data.
  • Daily volume 5
  • 20 million rows.
  • Online Analytical Processing (OLAP): Developed OLAP for Accounts, HLQ, Data view, Rate cards, and promotions. Designed and developed Descriptive and Predictive Analysis processes to apply business rule and validation of customer's billing data setup on correlation of consolidated data as per contractual terms.
  • Decision Support Systems: Notification of customer's contract\amendment data change analysis to appropriate POC/business owner group. Auto validation of account, rates, circuit change data control as per contract terms, existing billing data and approval process. Work flow management functionality for billing data discrepancy within expected time.
  • Business Performance Management: Removed cross functional group dependency (billing auditor's dependency on account team verification) by implementing account team automated notification and 3 days escalation to reporting hierarchy. Notification and escalation process improved billing quality and reduce back billing by 10% along with better customer service.
  • OLTP: Web application for various user groups to authenticate billing data, search functionality, automated audit options setup.
  • Reporting platform: Contract\amendment process time and accuracy summary by region, center, and reporting hierarchy including various ad hoc and automated\on line reports. Contract implementation performance reports. Audit discrepancy report by account, analyst, and auditor group.
  • Consumed and Publish web services for real time integration along with daily data feeds to 5 downstream systems.
  • Servlets, DAO, JSP, HTML, CSS, JDBC, Connection Pooling, Oracle 11g, PL SQL, ETL, shell scripting, batch processing, Talend. Billing Transformation projects (Primary project) Lead and participate in various Billing Transformation projects for WorldCom/MCI/Verizon legacy systems synergy initiative. Supervised change control for AE, CRS, Rev Ops Web services project.
  • Designed and implemented legacy systems decommission/integration projects
  • Analysis and development of billing data integration ELT process in batch mode using Vertica
  • Extensively worked with DBA for contingency plan including database backup, import-export utility, data files, control files, and table spaces.
  • Development of complex stored procedures and optimized SQL queries for large volume data and intricate billing audit process
  • data migration and built in functionality. Contract Reporting System (Primary Project) Maintain contract life cycle from presale to archive, contract work flow management through various stages of contract (Presale/Sale, Implementation, Billing) with data repository module.
  • Published/consumed many web services, RPC, and data feeds to Rev Ops applications.
  • Spring framework, EJB, DAO, JSP, Java Applets, Java Servlets, JDBC, connection pooling.
  • Oracle Database 11g and Oracle Reports. Rev Ops Web Services (Secondary Project) Web services projects for real time interface between AE/CRS, and other REVOPS system. Published and consumed to publish and consume web services. Responsible for AE/CRS related web services.
  • Web service uses Axis, XFire, CXF, JAXB, EJB, DAO, and JDBC.
Application Development Data Warehousing ETL Analysis Business Requirements Configuration Management CSS Data Integration Data Migration Database Backups HTML OLAP Oracle Oracle 11i Oracle Reports Performance Management Production Support Project Management SDLC Shell Scripts SQL SQL Loader Stored Procedure Talend Studio Training UNIX Unix scripts WebServices J2EE Java Servlet JDBC JSP Scripting Database Design System Design Test Planning
Remove Skill
Software Engineer
Information Technology
Jan 1997 - Jan 1998
Responsible for GUI and functionality design for commercial client/server application (Connex4.0) used by hospitals and medical practice for Behavioral Health Area.
  • Developed PFC class extension objects to be used by development team.
  • Designed and developed Appointment Scheduler for HMO/PPO facilities.
  • Designed and developed Connex4.0 data migration functionality for employee health benefits.
  • Developed eligibility data import functionality from various insurance companies to application by ETL.
  • Worked as a member of a team in problem solving and issue resolution.
  • Involved in evaluating the use of PowerBuilder 6.0
  • PowerBuilder 5.0 with PFC and MS SQL server/Sybase SQL Anywhere database.
Application Development ETL Analysis Business Requirements Data Migration Problem Solving Software Engineer SQL SQL Server Sybase PowerBuilder PFC
Remove Skill
Software Engineer
Information Technology
Jan 1996 - Jan 1997
Member of a software team responsible for developing two client-server systems (Vehicle Registration and Title System) for DOT. Responsible for dealer license processing and transactions.
  • Developed and implemented the Info Image subsystem, which displayed scanned images from MS SQL server to application processing windows.
  • Integrated DP500 (Document Processing) to VRTS application.
  • Designed, developed and implemented an incident tracking system for the North Dakota DOT.
  • Occasionally coded DLL functions in C.
  • PowerBuilder 5.0/PFC, Oracle 7.3, and MS SQL Server
Application Development Analysis Business Requirements SQL SQL Server PowerBuilder Software Engineer Oracle Windows PFC
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Master's in Computer Science
SOUTHERN POLYTECHNIC STATE UNIVERSITY 1996
Bachelor's in Electronics and Communications Engineering
DHARAMSINH DESAI INSTITUTE OF TECHNOLOGY
Skills
Analysis
2021
23
Application Development
2021
23
Business Requirements
2021
23
SQL
2021
23
ETL
2021
21
SQL Loader
2021
21
System Design
2021
21
Database Design
2021
20
Oracle
2021
20
Test Planning
2021
20
UNIX
2021
20
Data Warehousing
2021
19
Oracle 11i
2021
19
Shell Scripts
2021
19
Data Migration
2011
13
J2EE
2014
13
OLAP
2012
13
Scripting
2014
13
Talend Studio
2012
13
Configuration Management
2011
12
CSS
2011
12
Data Integration
2011
12
Database Backups
2011
12
HTML
2011
12
Java Servlet
2011
12
JDBC
2011
12
JSP
2011
12
Oracle Reports
2011
12
Performance Management
2011
12
Production Support
2011
12
Project Management
2011
12
SDLC
2011
12
Stored Procedure
2011
12
Training
2011
12
Unix scripts
2011
12
WebServices
2011
12
Agile Methodology
2021
8
Software Engineer
2021
8
TOAD
2021
8
Windows
2021
8
Compliance
2021
7
Requirements Gathering
2021
7
Technical Specifications
2021
7
Windows Server
2021
7
Auditing
2021
6
Business Objects
2021
6
Continuous Deployment
2021
6
Continuous Integration
2021
6
Crystal Reports
2021
6
Data Cleansing
2021
6
Data Mapping
2021
6
Database Maintenance
2021
6
Linux
2021
6
M&A
2021
6
Performance Tuning
2021
6
PFC
1998
2
PowerBuilder
1998
2
SQL Server
1998
2
Ab Initio
2014
1
Data Center
2014
1
Data Modeling
2014
1
Database Upgrades
2014
1
Erwin Data Modler
2014
1
HP ALM
2014
1
Human Resource
2014
1
Problem Solving
1998
1
Sybase
1998
1
Systems Engineering
2014
1
XML
2014
1
Analytics
2012
1
Application Integration
0
1
Billing
2013
1
CDC
2013
1
Data Governance
2013
1
Data Marts
2013
1
Data Profiling
0
1
Data Replication
2013
1
Data Visualization
2012
1
EMR
0
1
Enterprise Applications
0
1
Informatica
2013
1
Metadata
2012
1
OLTP
2013
1
Process Improvement
2012
1
Scrum
0
1
Systems Integration
2013
1
Tableau
2012
1
Wireless Networks
2013
1
Languages
English, Fluent/Bilingual