M.Bhanu Kiran
E-Mail id: **********.*@*****.***
Mobile No: 897*******
. Over 3+ years of professional experience in software industry with
comprehensive knowledge through all phases of software development
lifecycle right from requirement analysis to maintenance of a project.
. Worked on technical aspects and feasibility of the functional
requirements with the requirement gathering team
. Extensive experience as Sybase Developer in ASE server 12.5 and 15.1
> Have written basic SQL's to retrieve, insert, update and delete data
while working in production support to complicated SQL's for generating
reports.
> Have done performance tuning for many report SQL's.
> Prepared stored procedures, indexes, views and triggers.
. Have good knowledge in UNIX Shell scripting.
> Written shell scripts that deal more with isql'ing DB and BCP'ing data.
> Also worked on shell scripts that deal with file data editing.
> Developed a script that will copy the table's data from one DB server to
another DB server.
. Good knowledge in database tools like DbVisualizer and Toad for Sybase.
. Preparation of Weekly Status Report for the client and involved in Weekly
Status calls with the onsite and client.
. Received many Client/Onsite appreciations and recognitions for the good
work done within the team and across the Units.
. Experience in all phases of the application development cycle - Design,
Coding, Testing (Unit testing and Integration testing), Maintenance and
Documentation.
. Very keen to involve in process improvements and job automations in shell
scripting for other teams too.
. Demonstrated a great deal of initiative, teamwork and excellent
communications skills
. Good Experience in working under tight deadlines.
. Excellent analytical and programming skills. Capacity for work meeting
deadlines. Diagnostic ability to go to the core of the problem.
. Willing to learn and adapt to new challenges.
Education:
. Bachelor of engineering from JNTU(Anantapur)
. Intermiedate from Board of A.P .
. SSC from Board of A.P .
Professional Experience:
. Working as a Software Engineer in Tata Consultancy Services Pvt
Ltd., Bangalore from Dec 2012 to till date.
. Worked as a Software Engineer in Adaptavant Technologies Pvt ltd.,
Chennai from October 2011 to Dec 2012.
Environment:
. Hardware : WINDOWS XP, UNIX (Sun-OS), Linux
. Languages : UNIX/LINUX Shell Scripting, TSQL and C.
. Database : Sybase ASE 12.5, 15.1
. Software : TSQL
. Tools : Db-visualizer 5.1, Toad for
Sybase, ws_ftp32, telnet and Putty
PROJECT #1:
Company : Tata Consultancy Services
Client : The Nielsen Company
Metered Sample Management
Title Software Engineer
:
Dec 2012 to Till Date
Role :
AC Nielsen is a pioneer in the leading global provider of
marketing research information services, analytical systems and
Duration : tools, and professional client service that help clients win in
the marketplace. AC Nielsen clients include virtually all the
Description : world's leading manufacturers and retailers of consumer packaged
goods, as well as companies that market many other types of
consumer products and services. Clients work with AC Nielsen to
Measure their market performance, Analyze market dynamics,
Diagnose and solve marketing and sales problems, and Identify and
capture growth opportunities.
AC Nielsen's operations span more than 100 countries.
Headquartered in New York, major regional business centers are
located in Schaumburg, Illinois; Hong Kong; Sydney, Australia;
Buenos Aires, Argentina; and Nicosia, Cyprus.
MSM is a client server based application provided mainly to the
field to manage metered markets and people meter samples.
Field personnel activities:
Recruit households
Gather household and person's demographic data
Install metering devices
Coach household members
The maintenance of a household is managed by an assigned field
rep in a structured system of field areas. Using a work flow
management system:
Service requests are generated for Faults and Flags to indicate a
problem or
potential issue.
Some other types of service requests are created to collect data,
verify data or manage devices.
Once a household is in the sample, data is gathered and reported
to downstream applications for reporting in our metered samples.
Some data includes household characteristics, person
characteristics, device characteristics, vehicle data etc.
Responsibilitie
s
Preparing the High Level and Low Level Design for enhancement
releases.
Effective communication with users to find better business
solutions.
Writing stored procedures and shell scripts for new work
requests.
Preparation of project related documents (for eg., Conceptual
design, Detailed design, Release document ).
Unit testing and preparing unit test cases.
Supporting SQA team during system testing and integration testing
To coordinate and communicate with On-site.
Participate in project status meetings and sending weekly status
PROJECT #2: reports to client.
Company :
Client
: Adaptavant Technologies Pvt ltd
Title GENISYS (General Insurance System)
:
General Insurance System
Duration :
October 2011 to Dec 2012
Role
: Software Engineer
Description Genisys is a Product developed using Client Server Technology to
automate all the operations of an operating office (Branch
offices/Divisional offices) of General Insurance sector. The
system caters to all the activities of the business like
underwriting policies, registering and settlement of claims and
all the related accounting activities. The Product is
Parameterized and Configurable to the requirements of the
offices. The system is flexible that in case of introduction of
new types of policies it can be incorporated at any time without
hindering the normal operations of an office. The system has
provision for consolidation of accounts at Branch and Divisional
office levels. Currently running in 115 offices in Chennai region
and over 800 offices all over India.
Responsibilitie
s Writing stored procedures and shell scripts for new work
requests.
Unit testing and preparing unit test cases.
Supporting SQA team during system testing and integration testing
Monitoring the jobs log file for status and fixing if any job
gets failed.
To coordinate and communicate with team members and client.
Attending the project status meetings and sending weekly status
reports to client.
Resolving the production support tickets that were logged by
users.
Attending Sev-1 calls.
Declaration:
I hereby declare that information furnished above is true to best of my
knowledge.
Signature
M.Bhanu kiran