Anjana Kumari

c88zbg@r.postjobfree.com

Mobile: +918*********

Current Location: Gurgaon,India

Is working with Fidelity International Limited as Analyst programmer.

Has worked with IBM as Associate System Engineer.

4+ years of application developer Experience(including 4 months of onsite experience) with strong expertise in Oracle pl/sql,sql,Shell scripting,Pro*C,D2K,Hyperion IR. Hands on development experience on telco and investment domain projects.

Working as Oracle,Sybase and business objects developer in FIL.

Education

Course of Study University/Board Year of Passing % Marks

B. Tech Cochin university of science and Technology 2007 74%

Experience

Organization Designation Duration

IBM India Pvt Ltd Associate System Engineer 2007 –May 2011

Fidelity International Limited Analyst programmer May 2011 till date

Technical Skills

Language SQL,PL/SQL,PRO*C,SHELL SCRIPTING

Databases Oracle 9i ,Oracle 10g,Sybase 12.5

Tools ETL tool ,HYPERION IR(Brio),D2K,Toad,SQL plus,Putty,Winscp,SQL Developer,Web intelligence

Operating System Windows 98/2000/XP, Unix

Applications MS Office,Edit plus

PROFESSIONAL EXPERIENCE IN DETAIL

1 Project Name: Performance systems

Client Fidelity

Role Application Developer

Organization FIL

Location Gurgaon

Software Language Used SQL,PL/SQL,Shell script,Sybase

Operating System UNIX,Widows XP

Tool ASE ISQL,SQL Devloper,Putty,Winscp,Toad

Responsibilities

• Production support and bug fix

• Coding

• Unit,integration and system testing

• Implementation/Deployment

• Documentation-TDD,Release Note,Summary Report,Test cases and result,Test Plan.

Performance systems is a team in investment management domain of FIL which generates performance reports (return, risk and attribution data) of all fidelity funds. There are 4 main application used for performance measurement in FIL. They are IPS, PerfAuto, PerfMaint and weekly relative. The performance data are published to different stakeholders and few of the reports are sent to higher management.

2 Project Name: MAXIS RAFFLESIA

Client MAXIS

Role Application Developer

Organization IBM

Location Kolkata

Software Language Used SQL,PL/SQL,Shell script,Pro*C

Operating System UNIX

Tool D2K,SQL Devloper,Putty,Winscp, SQL Devloper, ETL tool

Responsibilities

• Liase with user for requirement gathering

• Analyze the requirements and prepare design.

• Attend meetings with different vendors to assure the functional requirement accomplishment

• Follow appropriate s/w development model

• Attend meetings and discussion with appropriate parties

• Coordination with team members

• Prepare use cases and mapping docs

• Coding

• Unit,integration and system testing

• Implementation/Deployment

• Documentation-TDD,Release Note,Summary Report,,Test cases and result,Test Plan.

Developments and Enhancements

• IN SELECT CHRONOS PROJECT:The project objective is to change the existing system to cater changes occurred in IN format. . Changes are involved in call ticket, confirmation ticket, payment call ticket and DSD files. A new type of confirmation ticket (SMAF confirmation ticket) is also introduced. Payment confirmation ticket is not in the scope of change as MVNO does not process this ticket type.Tickets are loaded using ETL tool and Summary and aggregate tables were populated using ETL process.

• EPK,CIMB-ARI-The purpose of this UCR is to invoke ARI process whenever IC4 system is down.The new process performs a health check up of IC4 system at every one hour and invokes the pro*c process if IC4 is down so that all eligible customer's account can be reinstated

• GSM5 Project:-All CRM application are enhanced to support newly launched customer DB GSM5.

• SMS Notification for CAD,PBP,IVR and E-billing system payment:-This UCR deals with generation of SMS whenever a payment is received through any of the four payment channels(CAD,PBP,IVR,ECOL) of CRM.The process runs after every 15 mins and picks up all eligible msisdn's for SMS sending.

• 3+8 msisdn Project:-Enhancement of all the applications to cater one extra digit added to the existing msisdns.

• I-Share Data Mart:- I-SHARE is a Value-added service targeted for migrant workers: Maxis prepaid and postpaid subscribers (Malaysia) can send a top-up instantly to mobile subscribers in other countries.This enhancement is done to create data mart for I-share settlement report Creation

• CDSAP enhancement for GL CODE and COSTCENTER:-This enhancement work was done to configure GL CODE and COSTCENTER in CDSAP application.

• Project Dreamscapes:-Project Dreamscapes was a campaign which was introduced to increase revenue and obtain higher customer satisfaction by allowing customers to participate in interesting contest.

• Ang Pao Contest:-It was an enhancement of Project Dreamscapes which ran for 2 months.It was also introduced to increase revenue and obtain higher customer satisfaction by allowing customers to participate in interesting contest.

• Homeless Report:-The report was prepared to extract all supplementary accounts tied to deactivated principal account with customer name,address,status,mobile no,outstanding amount,average usages and witeoff amount.

• Kiwi Project:-Accounts tagged under KIWI promotion were extracted on daily basis and four reports were prepared.

3 Project Name: IDEA MIS Report -Phase-II Release-1

Client IDEA

Role Application Developer

Organization IBM

Location Kolkata

Software Language Used SQL

Operating System Windows XP

Tool HYPERION IR

Project Description

IDEA maintains a single database(SCPDB) to store the transactional data from different source systems(IN systems:Telecordia and CS3, UCS system, VTOPUP system, etc.). Based on the transactional data, summarization is done in the same database for analysis purpose and MIS reports are created from these tables to cater user requirement.Currently there are eleven circles for IDEA and some new circles are about to come. The current IDEA database is a single database which store both transactional and summary tables and the structures are not similar across the circles.

The assignment of the MIS project was to deliver 450(+) reports of IDEA. Out of which, 50 high priority Pre-paid reports had been identified for P2R1. The source data files had been loaded into transactional tables in a staging database using ETL jobs and from the staging database, summary tables had been created and loaded in a new MIS database by ETL jobs. The reports had been prepared from MIS database. The reports had been created through Hyperian IR(aka Brio) tool and ESSBASE cube, which provides drill-up, drill-down, slicing-dicing facilities to end users.

The flat files to Staging table population had been done by SCPDB Load.Enhancement Project which was also going on in parallel.

Responsibilities

• To design after requirement gathering from stake holders.

• Coding.

• Code testing (Unit Testing).

• Documentation (Scope doc,FDD-TDD,User manuals)

• Awards and Trainings

Oracle Database 11g: Administration Workshop I (Hosted) PRV.

IBM’s BRAVO AWARD for focus and passion of work in 2011.

Best supporting performer award in a business event in FIL.

Manager’s award for month of November 2011 in FIL.

ITIL V3 FOUNDATION Training

• Certification and Degree

Oracle9i certified Professional (OCP)

ITIL V3 FOUNDATION Certified

B.tech from Cochin University of science and technology in 2007.

• Personal strengths

Positive Attitude

Dedicated and Hardworking

Adaptability

Good planner & Management Skills

Active Participation in Team Work

Personal Details

Father's Name Jai Prakash Singh

Date of Birth 03-Nov-1984

I hereby declare that the information furnished above is true to the best of my knowledge.

Date: - 11/3/2012 Anjana Kumari

Contact this candidate