AJEET SINGH

ablyec@r.postjobfree.com

ablyec@r.postjobfree.com

ablyec@r.postjobfree.com

Cell No: +91-900*******

Objective:

Looking for a landmark position at the horizon of fastest growing IT

industry where I can utilize my expertise and experience up to apex of

my efforts in order to achieve culmination of technological

productivity.

Professional Summary:

> 7 years and 8 Month of software development experience in IT

industry.

> Efficient in developing applications using primary skills Business

Objects XI R2&R3, Oracle PL/SQL, SSIS, Oracle Warehouse Builder.

Strong exposure in Business Objects, SQL and PL/SQL, RDBMS concepts

in Database.

> Good technical knowledge and combined creative problem-solving

skills on both strategic and tactical areas.

> Strong team player with demonstrated ability to find creative

solutions to software on line problems.

> Flexible and versatile to adapt any new environment and work on any

project.

> Good analytical skills, commitment to co-operative teamwork and

developing high quality software meeting requirements of the

customer.

Education:

> B.Tech. in Information Technology from BBIET&RC Bulandshahr, UP

Technical University, Lucknow (U.P) during 2001 -2005 with 64%

marks.

Technical Skills:

Operating Systems : Windows NT/XP/2000/5/7 & 8 and Advance

Server

Languages : PL/SQL, SQL

Core Subjects : DBMS, OOPS and Operating System

Tools : Business Object XI R2 & R3, Life Cycle

Manager,

Team Foundation Server, Info Burst, SSIS,

Master Data Management System, Qlikview

11, Toad, PL/SQL Developer, Microsoft

Visual SourceSafe, Oracle Warehouse

Builder, Citrix.

Others : Oracle Forms and Reports 6i.

Training and Certification:

1-Join Soft skills training organize at CMC Ltd Delhi on Jun 2007.

2- Join Oracle 9i, PL/SQL training at CMC Ltd Delhi on Jul 2008.

3- Join Port Terminal Transportation domain knowledge training at CMC Ltd

Delhi on Jul.

2007.

4- Oracle Certified Associate (1st Paper).

5- Ericsson Service Engineer Certified Associates.

6- TCS Real State Certified.

Achievements

> Developed the PC controlled lift in the summer training for

DataMan software Technology Kanpur.

> Temporarily work permit for Congo B country.

Employment Summary

Organization Designation Duration

TATA Consultancy Services Assistant Mar 2013 - Till Now

Consultant

Ericsson India Global Solution Integrator (Apr 2011) - (Mar

Services Pvt. Ltd. 2013)

CMC Ltd Delhi (a TATA IT-Engineer (Jun 2007) - (Mar

Enterprises) 2011)

Experience:

#1

Organization TATA Consultancy Services

Project Name: Brook Field Global Relocation Services

Client Brook Field Global Relocation Services

Work Location India

Duration (Mar-13)-Till Now

Environment Business Objects XI R3, MS SQL Server, SSIS,

Team

Foundation Server, HPQC, LCM, Info Burst, 360

View,

Service Engine Application, Windows Server

Tools Excel, Access, Citrix

1

Brief Project Description:

Brookfield Residential Property Services, a division of Brook field Asset

Management Inc., is a leading global Real Estate and Relocation services

provider. Brook field Residential Property Services' portfolio consists of

operating lines in residential, real estate, global relocation services,

home valuations, move programs and related services, and technology

platforms that add value for their customers.

2 My Contribution:

. Working as a Project Lead as well as Technical Consultant.

. Managing a team of 15 Associates.

. Attending all the meeting and designing all documentation for project

(PMR, Billing Tracker, CSR etc.).

. Follow the SDLC model and holding the source code in TFS (Team

foundation server).

. We are using the agile methodology and having daily scrum meeting with

customer.

. Having requirement Gathering and Analysis from Service Engine

Application.

. Worked as Business Object solution Designer and Developer.

. Designing the SSIS package for ETL.

. Designing and developing Universe, new reports, and Customizing

exiting universe.

. Using LCM (Life cycle manager) for version management and promotion

from Dev to QA to Production environment.

. Using Info burst application for Scheduling and distribution of

reports.

. Solving the issue related to Client Server communication.

. Creating the Procedure, function and triggers also writing complex

queries.

. Solving the Database related issue.

. Performance Optimization.

. Development and Integration.

#2

Organization Ericsson India Global Services Pvt. Ltd.

Project Name: Standard Reports Migration

Client Vivacell MTS

Work Location India and Armenia

Duration (Oct-12) - (Mar-13)

Environment Business Objects XI R3, ENIQ 11.2, Tech Pack

IDE, Sybase IQ, Windows Server

Tools Excel, Access, Citrix

3

Brief Project Description:

Gathering the requirement for developing new reports and migration of

existing standard reports for Performance management domain in Ericsson.

Designing the requirement document, designing the Logic to implementation

new logic's for reports either predefined or customized reports. Creating

new Customized reports from the Business Objects to show various PM KPI.

This Report is the key report for analyzing the Network for any operator.

4 My Contribution:

. Requirement Gathering and Analysis.

. Worked as Technical Lead as well as Analyzer, Designer and Developer.

. Designing and developing new reports.

. BO Installation (Client & Server) and effort Estimating.

. Solving the issue related to Client Server communication.

. Solving the Database related issue.

. Development and Integration.

. KPI Testing.

#3

Organization Ericsson India Global Services Pvt. Ltd.

Project Name: 3G Mapa Reports

Client Airtel& ZAIN (Nigeria, Burkina Faso, Ghana,

DRC, Congo, SL, Niger and Gabon)

Work Location Burkina Faso & India

Duration (Apr-12)- (Oct-12)

Environment Business Objects t XI R3, ENIQ Tech Pack IDE,

Sybase IQ, Oracle 10g, Windows Server

Tools Toad, Excel, Access, Citrix

2

Brief Project Description:

Customizing Universe and gathering the requirement for developing new

reports for Ericsson Airtel or Airtel Bharti itself. Designing the

requirement document. Designing the Logic to implementation new logic's for

reports either predefined or customized reports. Creating new Customized

reports from the Business Objects to show various PM KPI. These KPI'S

include 55 Data providers and 300-400 functions. This Report is the key

report for analyzing the Network for any operator.

1 My Contribution:

. Requirement Technical lead as well as Functional Lead( Requirement

Gathering and Analysis).

. Worked as Designer and Developer.

. Designing customized universes as per business logic.

. Designing and developing new reports.

. BO Installation (Client & Server) and Estimating of effort.

. Solving the issue related to Client Server communication.

. Solving the Database related issue.

. Development and Integration.

. KPI Testing.

#4

Organization Ericsson India Global Services Pvt. Ltd.

Project Name: 3G Mapa Reports

Client Airtel Bharti, India

Work Location India

Duration (Nov 11) - (Apr-12)

Environment Business Objects t XI R3, ENIQ Tech Pack IDE,

Sybase IQ, Windows Server

Tools Toad, Excel, Access, Citrix

3

Brief Project Description:

Creating Universe and gathering the requirement for developing new reports

for Bharti. Creating Customized reports from the Business Objects to show

various PM KPI. Lots of reports having 30 to 50 Data providers. These

reports include the KPI'S from 300-400 functions. This Report is the key

report for analyzing the Network for any operator is known as MAPA reports.

1 My Contribution:

. Requirement Gathering and Analysis.

. Worked as Designer and Developer.

. Designing customized universes as per business logic.

. Designing and developing new reports.

. Development and Integration.

. KPI Testing.

#5

Organization Ericsson India Global Services Pvt. Ltd.

Project Name: Billing Reports

Client MTN Network System(CONGO)

Work Location Congo B

Duration (July 11) - (Nov 11)

Environment Business Objects t XI R3, Oracle 10G, Windows

Server

Tools Toad, Excel, Access, Citrix

4

Brief Project Description:

Creating Universe and gathering the requirement for developing new reports

for MTN. Designed metalized view, view and procedures for aggregation of

data to manage the database. Data is aggregated into Fact tables Day/ Busy

Hour/ Month level. Creating Customized reports from the Business Objects to

show various PM KPI.

1 My Contribution:

. Requirement Gathering and Analysis.

. Worked as Designer and Developer along with Functional Analyst.

. Designing scratch universes as per business logic.

. Designing and Developing of new reports.

. Designing and developing Oracle procedure as per client requirement.

. Metalized view creation for reporting issue.

. BO Installation (Client & Server) and Estimating of effort.

. Solving the issue related to Client Server communication.

. Development and Integration.

. Testing.

#6

Organization Ericsson India Global Services Pvt. Ltd.

Project Name: NAWARAS (OMAN)

Client Nawaras Network (Oman)

Work Location India

Duration (Apr 11) - (July 11)

Environment Business Objects t XI R3, ENIQ Tech Pack IDE,

Sybase IQ, Solaris 10

Tools Toad, Excel, Access, Citrix

5

Brief Project Description:

This Project included the development of technology package on the ENIQ

platform. This development included the defining the database schema for

BSS nodes. Creating Universe and verification reports for the technology

type. Designed procedures for aggregation of data to manage the database.

Data is aggregated into tables Day/ Busy Hour/ Month level. Creating

Customized reports from the Business Objects to show various PM KPI.

1 My Contribution:

. Worked as Designer and Developer along with Functional Analyst.

. Requirement Gathering and Analysis.

. Designing and Developing of new reports.

. Migrating OSS Reports into Eniq Reports.

. Leading Team and Estimating effort.

. Development and Integration.

. Testing.

#7

Organization CMC Ltd Delhi,

Project Name: CONCOR DWH

Client CONCOR (Container Corporation India Limited)

AND CCLS (Container and Cargo Logistics

System)

Duration (Dec 09) - (Mar 11)

Environment Oracle10g, PL/SQL, Business Objects XI R2,

Oracle

Warehouse Builder.

Tools Toad, Excel, Access,Citrix & Microsoft

Visual SourceSafe

Brief Project Description:

This System will help the Management & Analysts of CONCOR to Analyze and

report on the data captured by different source systems / databases within

CONCOR.CONCOR management understands that to serve the consumers more

efficiently as well to improve operational process it is essential to get a

complete view of the consumers. Once the data warehouse is fully functional

and all the source databases are incorporated, the data warehouse will

serve as the single point database of all information pertaining to various

aspects of the operations.

1 My Contribution:

> Created daily, weekly and quarterly reports for the management team

and from business objects report.

> Extensively used Calculations, Sorting, Rank, Slice and Dice,

Formatting, Changing Displays and Prompts for creating BO reports.

> Created reports in Simple, cross tab from Universe and Personal Data

File.

> Create reports using BO function Like (Running Sum, Cascaded Prompt).

> Creating tables, Indexes and Constraints.

> Creating Backend Procedures and Functions for ETL process.

> Tuning the Queries with the help of the Explain Plan.

> Ability to work effectively in a team as well as individually with

excellent communication and interpersonal skills. Also has an ability

to develop creative solutions for challenging client needs

#8

Organization CMC Ltd Delhi,

Project Name: ETMS (Export-Import Terminal Management

System)

Client CONCOR (Container Corporation India Limited)

Duration (Jun 07) - (Dec 09)

Environment Oracle9i/10g, PL/SQL, Oracle Forms and

Reports 6i on windows operating system.

Tools Toad, Excel, Access,Citrix & Microsoft

Visual SourceSafe

Brief Project Description:

ETMS governs business flow of CONCOR by managing and controlling the

transportation flow of containers between the different port and ICD of

India. It manages the flow of Rail, vehicles and other transportation

means, which are, engage in this system. ETMS is combination of Export,

Import, Rail and Billing modules, which are again divided into lots of sub-

modules.

1 My Contribution:

10 Requirement Analysis and Designing for Oracle Forms and Reports.

11 Develop the procedures, Functions and queries as per requirement of Form

and Report in backend and Front-end.

12 Develop the Forms and reports as per requirement of client.

13 Handle On-line problems of system.

14 Handle online database.

15 Work on optimization and tuning of queries.

16 Handling Online data Transfer through EDI System (With Unix).

17 Created/Developed test Cases for code generation.

Personal Details:

Date of Birth: 15 Aug 1983

Sex: Male

Hobbies : Net Surfing, Listening music and Playing cricket.

Strength: Hardworking, flexible to adapt new environment,

creative and confident and also goal oriented.

Belief: Tough times never last but tough people do it.

Permanent (Behind Post Office) Shantinagar Chaubepur Kanpur

Address Nagar.

Pin No: 209203

Date: 25-Sept-14 Signature:

Location : Lucknow (Ajeet

Singh)

4

Contact this candidate