Archana G

Al Nanda Sharjah UAE|Email:[email protected]|Phone:+971-528113482

 
Professional Summary:

Dedicated IT professional with exceptional data warehouse, database, application testing and business intelligence experience. Supportive and enthusiastic team player dedicated to streamlining processes and efficiently resolving project issues. Willing to take ownership of core components.

Technical Skills:

ETL:
SQL Server Integration Services, SQL Server DTS, Data Stage
OS:
Windows XP/7/8, UNIX/LINUX
Programming:
Basic JavaScript, C++, HTML/XML, Active Directory
OLAP/Reporting:
Business Objects , SQL Server Analysis Services, SQL Server Reporting Services
Tools:
TOAD, Informatica, SQL*Loader, Service now-Incident Management Tool, Remedy Mgmt-Job status change tool
Software:
Microsoft Office Suite applications, Vmware, outlook
Databases/RDBMS:
MySQL, MS SQL Server, Oracle 11g/10g/9i, DB2
Experience Details:

Ø  Senior Application Support Engineer – DWH – Cognizant Technology Solutions, Chennai (March 2014 – July 2016)

·         Having professional work experience in Data warehousing majorly in Production Support with exceptional background in monitoring support of Data warehouse applications.

·         Worked as L2 Support Engineer, supporting in resolving tickets to attain SLAs.

·         Worked extensively in Java language, ETL (Informatica Power Center), Unix Shell Scripting and SQL programming.

·         Appropriate escalation of support tickets to third line support and vendors

·         Clear separation and reporting of incidents verses enhancements and requests for change

·         Successful transition of projects and enhancements into operations

·         Facilitation of testing including system, user acceptance as well as performance and integration testing

·         Regular communication with line manager clearly reporting support trends and service level attainment

·         Regular formal and informal meetings with business stakeholders and key users

·         Contribute to relevant Support, Applications and Infrastructure developments.

·         Working relationships with outsourced Level 3 support teams, product vendors, IT teams, Security and compliance teams, process leads and technical design authorities, Group IT teams, and Global Business End User Community.

·         Handled different production support issues like DB slowness and Integration service failures.

·         Designed standards and guidelines for enhancement of ongoing projects and goals.

·         Worked on assessments for new requirement.

·         Conducted cost benefit analysis of various ETL tools and technologies.

·         Created UNIX shell scripts, JCL mainframe procedures, and processes to extract data from various sources such as DB2 and Oracle.

·         Implemented complex transformations by creating custom transformations in addition to using built-in ones.

·         Oversaw unit and system tests and assisted users with acceptance testing.

Education:

School / Degree

Year

School / University

Percentage

Bachelor of Computer

2009- 2013

Kalasalingam University,

7.76 (cgpa)

Science Engineering.

Srivilliputtur,Tamil Nadu.

12th

2008-2009

Mahatma Montessori matric. Hr. Sec. School,Madurai, Tamil Nadu

87.16

10th

2006-2007

Mahatma Montessori matric. Hr. Sec. School,Madurai, Tamil Nadu.

84.60

Certification course:

Ø  ITIL V3Foundation certified.

Ø  IT IS Yellow belt, process space at Cognizant Technology Solutions..

Ø  JAVA ORACLE certified

Ø  Completed Automation Testing course “Selenium”.

Projects:

Group Benefits Division: The Hartford Insurance:

Operating System         : Windows XP

Tools                            : Informatica, Oracle, Autosys, Brio, UNIX

Team Size                     :10

Role                             : Senior System Engineer

Location                       : Chennai

PROJECT OBJECTIVE & DESCRIPTION:

This project is to provide application development, enhancement, information delivery and maintenance of life Insurance  Data Warehouse for Hartford Life Insurance which is fourth  biggest life insurance  giants in US. This deals with Group Benefit division of Life insurance.
The HLI has 27 logical legacy source system from which data is extracted and staged in 5 different staging tables, after which subjected to Data Warehouse area which contains 9 data marts.
In support of information delivery, GBD Data Warehouse is accountable for the capture and movement of data from transactional and external data sources to the Data Warehouse environment.
A historical level of data is stored in persistent staging data stores and then transformed and loaded to operational data stores and data marts.
ETL processes are scheduled to meet daily, weekly and monthly service level expectations.
Data loads are primarily incremental updates with a full table refreshes treated as exceptions.
ROLES & RESPONSIBILITIES:

Provide production support for the ETL (Informatica) part, Autosys, reporting (brio/BO)
Involved in implementing Enhancements (ETL design and development) to the existing systems.
Part of the Defect prevention group in the team and Handling the Team in the newly implemented MSM model.
Leading the MSG Team that handles the production support of the newly added application (ETL (Informatica), Autosys, Reporting).
Data warehouse Batch jobs using Informatica, Autosys and batch reports through Brio scheduler. Monitoring, troubleshooting in daily Batch jobs using Informatica Data Warehousing Tool.
Working with BQY creation for the reports.
Responsible for daily maintenance of the database and for the access for online on request from the clients.
Responsible for doing daily restart of web logic services and Handling Operational tasks in technologies like data warehousing.
Preparing reports on daily, weekly and monthly basis and regularly testing and maintaining client business portal.
Problem Identification, Performing service restart on request from the clients.
Responsible for preparing effort metrics and daily dashboard for the team and for various initiatives towards business re-engineering.
Managing the activities of the project in each shift.
Helping to prepare weekly metrics/monthly metrics for our project.
Analyzing tickets & resolution.
Identifying the key areas for the improvement.
Conduct frequent meeting with team members & sending the status to our Managers.
Conducted peer design and code reviews and extensive documentation of standards, best practices, and ETL procedures.
Played role in design of scalable, reusable, and low maintenance ETL templates.
Design and develop SSIS packages, store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance.
Train and manage developers, advising other groups in organization on SSIS development, data warehouse development, and ETL development best practices.
Conduct code walkthroughs and review peer code and documentation.
Build efficient SSIS packages for processing fact and dimension tables with complex transforms and type 1 and type 2 changes.
Created system for capturing, reporting, and correcting error data.
Work with developers, DBAs, and systems support personnel in elevating and automating successful code to production.
Provide on-call support to production system to resolve any issues.
Gather requirements and design of data warehouse and data mart entities.
ACHIEVEMENTS:

·         Organized and handled various Internal Knowledge Sharing sessions within the Project.

·         Spent quality time in identifying various areas of improvement in the Project and resolved the same with team effort.

·         Tailored the Service Delivery Processes towards ITIL standards. Implemented ITIL practices such as   incident management, request fulfillment and event management.

·         Prepared Knowledge repository for the tasks that are performed in the project.

·         Handled knowledge transition within the project.

·         Active contribution in preparing the OM documents, status and metrics reports.

·         Team management activities like organizing.

·         Awarded WAH points from cognizant for extensive support during crisis management.

·         Received “Rookie of the Month”, “Associate of the Month”, ‘’Customer Champion’’ awards.

·         Have scaled own performance efficiently to meet project needs.

·         Have taken up the challenges and shown capability & confidence to work in the multiple technologies and the management activity.

·         Conduct frequent meeting with team members & sending the status to our Managers.

Experience 2: Hewlett Packard – Test Engineer

Healthcare Volunteer (Web application) – (July 2013 – Feb 2014)

Technologies : Oracle 9i, Windows 7
Used Tools : Selenium( IDE, Selenium RC, Web Driver Testing, JAVA), Test link Eclipse IDE
Role : Test Engineer
RESPONSIBILITIES:

Involved in understanding requirements.
Interacted with client to have a better understanding of functionality.
Involving in planning and estimation for monthly build releases and version releases
Coordinating team in planning and work distribution
Involving in resolving valid issues and queries
Performing Regression testing.
Involving in giving daily and weekly status reports to clients.
Involved in knowledge transfer to the newly recruited personnel.
Involved in creating Test metrics.
Personal Details:

Name                                       : Archana G

Date of Birth                             : 16- 09 -1991

Father’s name                           : Gurusamy G

Marital Status                            : Married

Spouse’s name                           : Guru Prasath S, Mechanical Engineer, Dubai.

Nationality                                : Indian

Visa Status                               : Resident Visa

Hobbies                                                : Music, long drives, creative designing, Comprehensive writing

Current Address                          : Al Nahda, Sharjah.

(Archana G)