Software Engineer Data
Resume:
SMITA GUGWAD
E-Mail: ***********@*****.***
Mobile: 669-***-****
https://www.linkedin.com/in/smitagugwad
PROFESSIONAL SUMMARY:
●Over 10 years 10 months of IT professional experience and 8 years of experience as ETL Ab Initio Data Specialist in software application development in Banking and Telecom domain for Wipro, past IBM India PVT LTD, past NTT DATA Inc and MICROLAND.
KEY RESPONSIBILITIES:
●Having good experience in development, maintenance, debugging, Support and enhancement in ETL Ab Initio, Shell Scripting along with Hadoop and Hive .
●Have a clear understanding of Data Warehousing concepts with emphasis on ETL and life cycle development.
●Extensive experience in Extraction, Transformation and Loading of Data into Data
Warehouse using Ab InitIo.
●Varied experience in Designing and developing the mappings from various Transformations like
●Reformat, Join, Rollup, Scan, XML Components, Lookup, Input and Output Tables, Partition Components, Gather, Filter By expression and various other components.
●Experience in Debugging sessions and implementing the complex business rules.
●Experience in extraction of data from various Heterogeneous sources (Relational database, Flat
●Files, XML Files, Database Tables) to load into Data Warehouse/Datamart targets.
●Proficient in understanding business processes/requirements and translating them into technical requirements.
●Worked with DBMS like Oracle 9i/10g/11g, SQL server, Informix.
●Experience in Database development skills using Oracle PL/SQL to write stored procedures,functions.
●Extensive development, support and maintenance experience working in all phases of the Software
●Development Life Cycle (SDLC) in Data Warehousing and Business Intelligence.
●Prepare/Maintain documentation on all aspects of ETL processes, definitions and mappings to support knowledge transfer to other team members.
●Have experience in Unit testing and SIT testing of end-to-end process before implementing the project in production.
●Experience in preparing the ETL Specifications and Technical Design documents like LLD and HLD.
●Excellent communication and interpersonal skills to quickly grasp new concepts and apply methodologies as per business needs.
●Have the ability to set and achieve project goals effectively as a team member as well as an individual.
●Work exceptionally well in a team or in an individual environment (self-starter).
●Ability to learn new technologies and tools quickly.
WORK EXPERIENCE
Organization
Designation
Duration
MICROLAND
Business Analyst
04/2009-04/2010
NTT Data
Senior Software Engineer
04/2010-12/2012
IBM
Senior ETL Data Specialist
12/2012-01/2019
WIIPRO
ETL Consultant
06/2019-Till date
TECHNICAL SKILLS:
Operating System
Windows
Technologies
ETL Ab Initio 2.14 & 3.02, Hadoop, Hive,
PL/SQL, Unix, Shell Script, 4GL, C, Scala
Database
Oracle 11g/9i/8i, Informix, SQL Server, DB2,
MySQL
Software Versioning Tools
IBM Rational Clearcase, Apache SubVersion (SVN)
Other Tools
TECTIA, PUTTY, CRT, VISIO, AUTOSYS, Operation
Console, SharePoint, Service Now, Autowatch, IntelliJ
DOMAIN WORKED FOR:
•Banking
•Telecom
PROFESSIONAL EXPERIENCE:
Project Name
:
Intraday Load, UMFCS Gloals, India Localization
Client
:
Visa International
Role
:
Senior Developer
Duration
:
June 2019 – Till date
Team size
:
3
Organization
:
WIPRO
Environment/Tool : Unix, Ab initio, Shell Script, Hadoop, HIVE, Spark
Description: This application is the most critical application under CMLS portfolio as it serves as the main and critical source of Authorization data collected from different OLTP systems (VIP) physically located at different parts of world to which around 50 downstream applications and BI reporting within VISA have subscribed directly or indirectly.
Participate in business and system requirements sessions
Requirements elicitation and translation to technical specifications
Provide inputs on solution architecture based on evaluation/understanding of solution alternatives, frameworks and products
Interact with clients to elicit architectural and non-functional requirements like performance, scalability, reliability, availability, maintainability.
Performed changes in the existing processes as per Business requirement and made sure to deploy bug free code in production.
Enhancing Existing Ab initio graphs and plans to implement ETL processes as per requirements.
Developed Several Shell Scripts, which invoked hive queries and Hadoop commands to get the required inputs from the hive tables, and process them using SDS and falcon load.
Developed Several Hadoop distcp scripts to transfer data from different servers.
Worked in migration of existing Ab Initio process to HIVE HQL.
Developed new Scala Class for UMF Global NSPK Project and Unit Test cases to test the individual methods.
Also involved in integration testing and UAT testing. Validated all the Test Cases manually
Involved in training and mentoring activities.
Project Name
:
Genesis Data Acquisition Platform NAM and Data Quality
Platform
Client
:
Citi Bank New York
Role
:
Senior ETL Data Specialist
Duration
:
December 2012 – January 2019
Team size
:
9
Application
:
Ab Initio 2.14 Development, UAT SIT Testing and Production
Support
Organization
:
IBM
Technologies and other Tools: Ab Initio 2.14 & 3.02, SQL, PUTTY, Python, Tectia, UNIX, Shell Scripting, Autosys, Sharepoint Operation Console, Service Now.
Database: Oracle 11g/9i/8i, Informix, SQL Server, DB2, MySQL.
Description:
Brief introduction about Genesis Data Acquisition Platform NAM and Data Quality Platform:
•Receiving, Processing and timely delivering live feeds to downstream as per business requirement.
•Identifying, triage and resolving critical issue of batch processing at the time of feed processing.
•Timely delivery of critical business information to end-users for proactive management.
•Analyses end user problem while any assessment failed at their end and unable to generate report.
•Taking care of production environment, in terms of performance tuning of application, which is running on that production environment.
•Taking care of Monthly, Weekly and daily batch processing issue.
Responsibilities:
●Designed graphs with various transformations to data using GDE and unix.
●Doing test analysis on Ab Initio codes in UAT.
●Varied experience in Designing and developing the mappings from various Transformations like
●Reformat, Join, Rollup, Scan, XML Components, Lookup, Input and Output Tables, Partition Components, Gather, Filter By expression and various other components.
●Experience in Debugging sessions and implementing the complex business rules.
●Experience in extraction of data from various Heterogeneous sources (Relational database, Flat Files, XML Files, Database Tables) to load into Data Warehouse/Datamart targets.
●Created test cases and maintained with version control.
●Attending and leading business meetings to understand functional requirements.
●Review Code execution and doing changes for optimizing code for production.
●Developed background running unix script to clean up temp files, OC logs,
●Enhanced and Supported 6 major applications
●Ensuring batch completions within defined SLA's for all applications.
●Scheduling and monitoring Ab Initio jobs, graphs, parameter sets and unix scripts in OC & Autosys.
●Investigated performance and functional issues in Production environment.
●Managing the production server outages and resolving issues.
●Communicate activities/progress to project managers, business development, business analysts and clients
●Provided technical and investigative support for functional users on defects, change requests, debugging issues, testing and adhoc report requirements
●Perform application availability check after OS/DB upgrades
●Providing Support for Application Deployment at production and other activities like environment upgrades, COB Testing, Migrations and Disaster Recovery, Continuity of Business etc.
●Establishing Quality Procedure for the team and continuously monitor and audit to ensure team meets quality goal
●Controlled code versions using EME, SVN.
●Tested and debugged Ab Initio code in SIT and UAT.
Project Name
:
Merlin Migration and ILCOD Upgrade Anytime Transaction
Client
:
Orange, UK
Role
:
Senior Software Engineer
Duration
:
January 2011 – June 2012
Team size
:
2
Application
:
ETL – Ab Initio
Organization
:
NTT DATA
Project
:
1
Technologies and other Tools: Ab Initio 2.14 & 3.12, SQL, PUTTY, CRT, VISIO, UNIX, Shell Scripting.
Database: Oracle.
Description:
Merlin Migration:
•The scope of the project is to migrate the existing Merlin Applications (Publisher and Subscriber) from the older Ab Initio environment o the new environment version 3-1-1-2.
Merlin ILCOD Upgrade Anytime:
•The objective of this project is to do the changes in the Merlin Combined Publisher to the direct and indirect upgrade Feed to get the Early and Normal Upgrade details from the Merlin Reporting Database.
Responsibilities:
●Requirements Gathering, Estimating and Analysis
●Development activities
●Maintaining Coding Standards
●Code analysis and Profiling (Including preparing RTP Scripts)
●Preparing Low level Design and High Level Deisgn Documents.
●Unit Testing
●Production release
●Status Reporting
Project Name
:
iFUP (Intelligent Fair Usage Policy) Subscriber and Publisher
Client
:
Everything Everywhere, UK
Role
:
Senior Software Engineer
Duration
:
April 2011 – December 2011
Team size
:
2
Application
:
ETL – Ab Initio
Organization
:
NTT DATA
Project : 2
Technologies and other Tools: Ab Initio 2.14, SQL, PUTTY, CRT, UNIX, Shell Scripting.
Database: Oracle
Description:
iFUP Subscriber:
•The scope of the project is to develop a new subscriber, which will retrieve the interaction history details from Public Interface Server and insert those details to Customer Hub Database.
iFUP Publisher:
•The objective of this project is to provide an option in Customer Hub that will publish the details of interaction history done by the customer as a daily extract to the Public Interface Server and will be subscribed by target systems.
Responsibilities:
●Requirements Gathering, Estimating and Analysis
●Development activities
●Maintaining Coding Standards
●Code analysis and Profiling (Including preparing RTP Scripts)
●Unit Testing
●Production release
●Status Reporting
Project Name
:
BLACKBERRY (Soap Call to the ATG SERVER)
Client
:
T - Mobile, UK
Role
:
Senior Software Engineer
Duration
:
April 2010 – December 2010
Team size
:
2
Application
:
ETL – Ab Initio
Organization
:
NTT DATA
Project
:
3
Technologies and other Tools: Ab Initio, SQL, PUTTY, CRT, UNIX, Shell Scripting.
Description:
Blackberry:
The aim of this project is to improve the PAYG Customer experience for joining Blackberry Services (BIS) by adding “Try” BIS to all new acquisitions automatically and allowing customer to self serve the take-up or re-subscription to chargeable BIS.
Responsibilities:
●Requirements Gathering, Estimating and Analysis
●Development activities
●Maintaining Coding Standards
●Code analysis and Profiling (Including preparing RTP Scripts)
●Unit Testing
●Production release
●Status Reporting
Project Name
:
IRP2 Expired Card deletion (Soap Call to BPO SERVER)
Client
:
Everything Everywhere, UK
Role
:
Software Engineer
Duration
:
January 2010 – May 2010
Team size
:
2
Application
:
ETL – Ab Initio
Organization
:
NTT DATA
Project
:
4
Technologies and other Tools: Ab Initio, SQL, PUTTY, CRT, UNIX, Shell Scripting.
Description:
IRP2 Expired Card deletion:
•This project aims to extract the expired card details from JT database. Then trigger a SOAP call to BPO service to delete these expired records.
Responsibilities:
●Requirements Gathering, Estimating and Analysis
●Development activities
●Maintaining Coding Standards
●Code analysis and Profiling (Including preparing RTP Scripts)
●Unit Testing
●Production release
●Status Reporting
Project Name
:
Merlin DWH
Client
:
Orange, UK
Role
:
Software Engineer
Duration
:
October 2009 – December 2009
Team size
:
2
Application
:
ETL – Ab Initio
Organization
:
NTT DATA
Project : 5
Technologies and other Tools: Ab Initio 1.14, SQL, PUTTY, CRT, UNIX, Shell Scripting.
Description:
Merlin DWH:
•This project was to improve the performance of the application for various runs (Daily, Adhoc and Monthly).
Responsibilities:
●Requirements Gathering, Estimating and Analysis
●Development activities
●Maintaining Coding Standards
●Code analysis and Profiling (Including preparing RTP Scripts)
●Unit Testing
●Production release
●Status Reporting
Project Name
:
VAT Rate increase, JTK_Upload performance improvement
and STK
Client
:
Just Talk, UK
Role
:
Software Engineer
Duration
:
April 2009 – October 2009
Team size
:
4
Application
:
4GL, Informix
Organization
:
NTT DATA
Project
:
6
Technologies and other Tools: 4gl, Informix, Unix Shell Scripting.
Description:
Just Talk - JT:
•JT stands for Just Talk, system used in Orange for creation and maintaining of PayG customers. JT is one of the biggest systems Keane is handling. JT deals fully with the PAYG customers. Pay as you go offers customers more choice and flexibility options tailored to customer needs. My projects aims to increase the VAT Rate to 20% and improve the performance for an application called JTK_Upload and also have worked in resolving few STK’s as well. Working in the project learnt me Informix, 4gl and Unix Shell Scripting.
Responsibilities:
●Development activities
●Code analysis
●Unit Testing
●Production release
●Status Tracking and Reporting
Duration
:
April 2009 – April 2010
Role
:
Business Analyst
Client
:
Belkin, UK
Organization
:
MICROLAND
Responsibilities:
●Here my role was Business Analyst to study the networking products like routers, modems,USB devices and Network boosters and other products and prepare a user manual on them and study the pattern of problems faced by the customers and to provide fix to them .
EDUCATION:
●Bachelor of Engineering in Computer Science from VTU University 2008 passed out.
CERTIFICATIONS:
●Informatica Power Center 9.6.1 Trained - Edureka
● Python Introduction to Big data 101 - IBM, India
● GBS Big Data – Using Big Data to Transform an Enterprise course -IBM,
India
●Effective Java Programming - Keane Learning Management System – KLCI
●Behavioral Trainings – Achieving Excellence, Goal Setting, Email Etiquette and Listening Loud and Clear Keane Learning Management System – KLCI
Contact this candidate