Resume

Sign in

PL/SQL, Unix, Informatica, Datastage

Location:
Canton, MI
Posted:
January 06, 2020

Contact this candidate

Resume:

Shreyashi Kundu

Mobile: 682-***-****

Mail: ada78y@r.postjobfree.com

! Visa : H4 EAD

SUMMARY

• 12 Years of professional experience in Software Development, Production Support and Maintenance work with strong background in analyzing business requirements, coding, testing, data modeling, ETL design and database technologies .

• Extensive experience in database technologies - Oracle, SQL, PLSQL, Microservices and advanced scripting using Unix shell.

• Working knowledge of Informatica Cloud Services & Power Center -Creating Informatica mappings & mapping configurations for the existing Database processes. Migrating complex database functions and process to more manageable mappings and job flows using Informatica Cloud Services and PowerCenter.

• Strong SQL knowledge with ability to write complex queries, database components – triggers, functions, exceptions, procedures, packages and Unix Shell Scripting.

• Experience in developing solution for Extraction, Transformation and Loading data from various sources to Datawarehouse and generating reports for data visualization.

• Trained in data visualization tools like Tableau to combine different views of data for prediction and trend analysis in form of graphs and charts.

• Experience in web services.

• Experience in developing ETL solution using Datastage.

• Experience in incident/change management using - Remedy change management tool and Quality Center for defect management.

• ITIL Certified.

• Certified in Oracle (OCA), Java (SCJP) and ITIL process.

• Experience in Microservices deployments using Jenkins, Kubernetes and Docker.

• Experience in generating operational reports using Splunk, Nagios & Kibana and code deployment using advanced tools like – Jenkins, Github, Kubernetes and configuration tools like SVN.

• Experience in operating in Global development model using scaled agile software development methodology.

• Experience in formulating Testing strategies, writing and execution of test cases.

• Strong knowledge of Telecom and Manufacturing domains.

• Self-motivated and result oriented professional with excellent track record in both individual and team environments. Exceptional interpersonal, communication and leadership skills with an ability to relate to clientele, management and fellow team members.

TECHNICAL SKILLS

Databases Oracle 10g/11g

Tools Jenkins, Kibana, Splunk, Informatica Cloud Service, Power center, Kubernetes, Github, Nagios, NX, Wiki, Jira, Kintana, PVCS

Languages SQL, PL/SQL, UNIX Shell, Microservices

OS UNIX, Windows

EDUCATION/DOMAIN CERTIFICATIONS

Engineering Degree in Information Technology, 2007

(West Bengal University, India)

Oracle

(Oracle Certified Associate - OCA)

Java

(Sun Certified Java Programmer - SCJP)

Domain

(ITIL - IT Infrastructure Library)

EXPERIENCE SUMMARY

Company: Tech Mahindra

Designation: Sr. Associate Technical specialist

AT&T Services, Richardson, TX

Project : CSI Dec 2013 – Present

AT&T is the worlds largest telecommunication company. Like many others in the service industry, AT&T also checks the eligibility of it’s new customers, before on-boarding them. The process of qualifying a customer involves parsing the application information, received via a webservice, running it through several database processes - functions, procedures, triggers and packages to determine the eligibility of the customer. The logic of approving and disproving a customer application is built into these database components. Once the application is parsed the response is sent back using a webservice. Responsibilities:

• ETL Development and production support work for CSI project

• Writing complex queries, database components – triggers, functions, exceptions, procedures, packages and Unix Shell Scripting.

• Creating Informatica mappings & mapping configurations for the existing Database processes.

• Migrating complex database functions and process to more manageable mappings and job flows using Informatica Cloud Services and PowerCenter.

• Experience in developing solution for Extraction, Transformation and Loading data from various sources to Datawarehouse and generating reports for data visualization.

• Managed and tracked changes/incidents using Remedy tool and Quality center for defects.

• Root cause analysis and problem management for long term fixes.

• Trained in data visualization tools like Tableau to combine different views of data for prediction and trend analysis in form of graphs and charts.

• Developing ETL solution using Datastage.

• Experience in web services.

• Experience in Microservices using Jenkins, Kubernetes and Docker.

• Requirement gathering – Working closely with business to identify and document requirements.

• Effort & Cost estimation – Coordinating with business and other teams to estimate cost and time.

• Creating Work Breakdown Structure – Break the requirements into manageable components using Agile Methodology – Creating Epic, Sub-Epics, User stories and tasks.

• Development & Unit testing – Designing, developing and unit testing of the sub-epics prioritized by Business users.

• Testing - Creating strategies, Functionaltestcases, prepping test data, and executing functional, performance & load testing.

• UAT – Coordinate and execute user acceptance testing with the business users.

• Deployment and Release management – Responsible for packaging code for deployments/releases and closely work with QA & Prod deployment teams to migrate code to the higher environment.

• Perform trouble shooting and maintenance of the application.

• Involved in daily agile stand ups and various status meetings with business.

• Responsible for setting up and configuring monitoring tools and alarms in production

• Generating operational reports using Splunk & Kibana as in when requested by business.

• Provided technical guidance to team members for designing and developing Database components.

• Trained in Informatica – Cloud services & Power Center to migrate the complex database functions and process to more manageable mappings and job flows. Company: Zensar Technologies Designation:

Software Engineer

Cisco - July 2007 – Dec 2013

1. Project : CSCC

Cisco Systems, Inc. is an American multinational technology conglomerate headquartered in San Jose, California, that develops, manufactures and sells networking hardware, telecommunications equipment and other high-technology services and products. The Cisco CSCC application is used to scan a customer’s network, requesting quotation to purchase Cisco networking devices. In order to compute the optimal number and type of networking devices required for the customer’s network, the application searches the inventory and generates a a quotation and a contract for the customer. The CSCC application is built using several algorithms based on historical data and complex PLSQL processes. Responsibilities

• Enhancements to the existing application.

• Understanding requirements and modifying PLSQL objects – Triggers, procedures and functions.

• Worked on performance tuning of SQL queries.

• Experience in developing ETL solution using Datastage.

• Creating and executing functional test cases.

• Creating several documents required as per the standards – Design document, technical inspection, Change management etc.

• Perform trouble shooting and maintenance of the application.

• Scheduling jobs using Unix Operating system.

• Unix Shell scripting to manage several process and job flows.

• Deployment – Responsible for packaging code for deployments/releases and closely work with QA & Prod deployment teams to migrate code to the higher environment. 2. Project : Smartcare

• The Cisco® Smart Care Service is a service offering that provides Cisco Partners with a proactive service platform that allows them to create tailored services for their SMB customers. The service covers networks with a device count of between five and 105 commercial-class Cisco products, including

voice.IP phones are fully covered by the service but are not counted as a unit in the pricing.

• Smart Care is implemented on the customer site through a Network Appliance

(hardware) or Network

• Client (software), that continually analyzes data about the health of the network then securely communicates this information to the partner through a Cisco hosted system. The Network Appliance or Network Client also provides a broad range of proactive assess and repair, Cisco network foundation,

voice, and security solutions on a single contract. Additionally, Smart Care provides:

• Proactive notifications to simplify the updating of Cisco devices

• Partner delivered technical support backed by expert Cisco TAC

• Hardware replacement of qualified Cisco devices

Responsibilities :

1. New Enhancements to application using Oracle PL/SQL(Creating Package, Procedure,Cursor, Trigger).

2. Troubleshooting client queries and analyzing defects by debugging backend code using Oracle PL/SQL.

3. Fixing issue through data fix from frontend and backend in monthly release using Oracle PL/SQL

4. Client Communication, Monitoring application availability 24/7 and taking appropriate action during downtime.

5. Sceduling and Monitoring of dollar U jobs through Unix Shell . Unix shell scripting and adding users and groups through Unix shell.

3. Project : Livelink(Wiki)

• CISCO CCW-Livelink(Wiki) Application is used to quote for CISCO devices and appliances.Network Client also provides a broad range of proactive assess and repair, Cisco network foundation, voice, and security solutions on a single contract. Additionally, Wiki provides:

• User Interface for uploading documents.

• Proactive notifications to simplify the updating of Cisco devices

• Partner delivered technical support backed by expert Cisco TAC

• Hardware replacement of qualified Cisco devices

Responsibilities:-

1.Troubleshooting client queries and analyzing defects by debugging frontend code on Java and JSP and backend code using Oracle PL/SQL. 2.Fixing issue through data fix from frontend and backend in monthly release using Oracle PL/SQL and Java .

3.Automation of Tools and Reports.

4.Sceduling and Monitoring of dollar U jobs through Unix Shell . Awards and Recognition

• Zensar Team Award – 2008

• Zensar Client Centric Award – 2010

• Tech Mahindra – Star Performer Award - 2017

• Received Many client appreciations

Personal Profile

Passport - (Valid up to 12/18/2026)

Visa - H4 EAD



Contact this candidate