Data Engineer Part Time
Resume:
Menaka Shanmugasundaram
Austin, Texas, United States
***.******@*****.***
Work Authorization: On L2 Visa, Valid till March 2025 Professional Summary
Over 13+ years of experience as Data Engineer/Ab Initio Developer and worked for telecommunication, Banking, and healthcare sectors.
7 years of Ab Initio experience with Data mapping, Data Transformation and Data loading from source to target systems in a complex, high volume environment. Well versed in Ab Initio parallelism techniques, MFS and all major components.
Extensively worked in all phases of the Software Development Life Cycle(SDLC)- Analysis, Design and Modelling, Development, System Testing, System Implementation, Acceptance and Maintenance. Handled the code in different environments(SIT, UAT, PROD) and created the documents for code promotions.
Involved in development of the Abinitio continuous flow graphs using ICFF files to serve WEB services and hands on development with various Ab Initio Components Such as Rollup, Normalize, Scan, Join, Partition Components, Multi-file handling.
Hands on experience in M Commands and AIR commands and good experience in creating tag and save files for code promotion.
Experience in providing End-to-End production support to AbInitio and Involved in troubleshooting the production issues and provide immediate solution to business users on Adhoc requests. Strong knowledge on Unix shell scripting and developed scripts for automation process. Experience of working with Agile methodologies with diverse teams using Jira. Worked in Client location(Sydney) and directly interacted with them for requirement gathering, system analysis, technical/functional specifications of the project, liaising extensively with offshore/onsite model. Quick learner and excellent team player, ability to meet tight deadlines. Skills
Abinitio, Unix Shell scripting, Oracle, Vertica, Teradata, SQL, PL/SQL, Control-M, Qliksense, Agile methodology, IICS, ITIL Service now, Logic Monitor, Git Hub
Education
Masters in Business Administration: Technology Management (Part time) May 2011 Anna University, India
Bachelors of Engineering: Computer Science and Engineering (Full time) May 2008 Anna University, India
Professional Experience
DXC Technology, Bangalore
Professional 2 Information Design Engineer/L2 Production Support May 2020 to April 2022 Client: Hewlett Packard Enterprise
• Worked as L2 production support for standard suite of applications includes HPE IDOL, HPE Vertica, AbInitio and Apache Hadoop that are core components of the HPE Haven software platform.
• Responsibilities includes Diagnosing, troubleshooting, and developing new solutions that solve the root cause of customer problems in tickets elevated from our L1 support team.
• In-depth knowledge of technical implementation of Change management, Problem management and Incident Management.
• Quickly responds to incident alerts and support calls. Identifies, and coordinates with teams that are critical to the event’s resolution.
• Developed complex unix shell scripts to handle the requirements from business.
• Responsibilities include Installing and Configuring Qliksense server with qliksense web console, Nprinting in all environments.
• Developed Qliksense objects like Pivot tables, Line charts, Bar charts, Line objects, Multi boxes, buttons.
• Hands on experience in customizing Qliksense and Nprinting reports as per business requirements.
• Created logins / users grant / deny permissions and other security issues in QlikSense.
• Import apps, extensions, data connections to the new colo environments.
• Work experience on QlikSense Hub, QMC, Proxy, Qlik Sense Scheduler (QSS), Qlik Sense Repository (QRS).
• Involved in SIT to achieve zero-defect reports.
DXC Technology, Bangalore
Senior Data Engineer October 2015 to June 2019
Client: AT&T, CVS Caremark
• Responsibilities includes Interacting with Clients for understanding the requirements
• Converting the customer requirement into technical requirements
• Developed a new system in UNIX for archival of data from the vertica server to the optim. Pull the dump files from vertica server and load these dump files into Oracle external tables.
• Archive the data from external tables and store it into NAS volumes.
• Overcoming the complexity of pulling the data from Vertica server to Optim.
• Responsibilities includes Evaluate records for preservation and retention and purge the data after the retention period.
• Estimating development activities and preparing Summary Reports
• Walk through of the deliverables to the client.
DXC Technology, Chennai
Data Engineer/AbInitio Developer Aug 2011 to Aug 2015 Client: Optus (Australian telecom)
• Involved in meetings with E2E SD’s and business stake holders to capture detailed level requirements.
• Designing a detailed abinitio solution in ARBOR billing system to calculate unbilled usage for approx 2 million PostPaid Mobile customers.
• Involved in development and worked on a new OLAP database named VERTICA (HP owned) and a Change Data Capture tool named DBsync (Owned by Wisdomforce).
• Involved in development of the Abinitio continuous flow graphs using ICFF files and used subscribe,Publish and queue components to serve WEB services.
• Preparing technical documentations, such as Implementation plans, Detailed Design Specification, Test Strategy, Test cases, Test Summary Report, Interface Contract, Operational Support Manual.
• Extensively used various AbInitio components like Reformat, Join, Partition by Key, Rollup, Scan, Normalize, De-Normalize etc to create graphs.
• Utilized AbInitio parallelism techniques and MFS techniques with the conditional components to improve overall performance by optimizing the execution time.
• Various in-built functions like lookup, lookup local, datetime add were effectively used in transform functions.
• Responsible for End-to-End validation when project migration to higher environments SIT, UAT, PRE-PROD and PROD. Co-ordinate with support team for on time and error-free code migration.
• Good experience in creating tag and save files for code promotion.
• Prepare UNIX shell scripts for file validations and loading data to the table.
• Accountable for user stories and acceptance criteria in Agile Sprints.
• Involved in production support activities for all the project delivered to production.
• Provided 24*7 extended supports during the production rollout and bug fixes
• Reverse engineered existing graphs to create the necessary design documents like high level and detailed- level technical designs, mapping documents and then update them for additional new functionality.
• Experience in AbInitio EME/Sandbox to implement version control and impact analysis to manage various project across the organization.
• Developed various Unix shell wrapper scripts to run AbInitio jobs and used shell scripts in graphs.
• Massively used AIR commands and m_ commands in Abinitio.
• Configured the environment to connect to Vertica database and loaded the table.
• Used the AbInitio standard documents and imposed it for more clarity.
• Involved in bug fixes, resolved performance issues, troubleshoot and provide resolution.
• Have worked on creating the Runbook document for the project.
• Involved in the development of the WOBs in the CA workload automation scheduler tool.
• Investigate AbInitio job failure and identify the root cause.Resolving the customer issues and provide solutions in patch.
Steria India Limited, Chennai
AbInitio/Unix Developer Aug 2008 – Jul 2011
Client: Barclays
• Prepare UNIX shell scripts to handle the requirement from business.
• Trained in Abinitio and have solved all the cookbook exercises.
• Have conceived data from sources, cleaned, transformed and loaded into target databases using the ETL tool, AbInitio.
• Experience in designing and development of Abinitio graphs using components like Lookup file, Join, Reformat, Filter by Expression, Rollup, Dedup sorted, sort within groups, Partitioner, de-partitioner, Multi- reformat, Update table, I/O file, FTP components etc. components based on requirement.
• Creation of SQL Queries for analysis and to validate data accuracy.
• Involved in SIT, UAT and production support activities.
• Acting as a central reference and information source, providing guidance and assistance in the system project decision making process.
• Conduct user acceptance tests and training; create user documentations.
• Resposible for updating the project manager regarding status of development efforts in a team of 6.
• Prepare UNIX shell scripts for file validations and loading data to the table.
• Setting up the environment for code promotion and duplicating the data.
• Use Control-M as job scheduler to automate the daily and monthly jobs.
Contact this candidate