Professional Summary:
12 years of IT experience in software development and practices. I have been involved in analysis, design, coding and testing phases of different projects. Worked on Data warehousing projects with major skill set Teradata (V2R5/12), Borland Delphi (3/4/5/6) and embedded with PMO Knowledge also the usage of other tools and technologies like UNIX, Oracle.
Possess aptitude of conveying sophisticated deliberation with exceptional aptitude in Project Management.
Innovative individual with proven ability to identify, analyze and solve problems to increase customer satisfaction and control costs through expertise in Teradata, Oracle and Borland Delphi. Workflow and cross functional team leadership. Exceptional in Project Management through strategy, designs and object orient technologies with sound knowledge in Teradata.
Quick adaptability of new technologies, zeal to improve technical skills.
Exhibited excellence in the international software market in Singapore for a year & in UK for 6 months.
Project Lead Skills (In the role of Sr. Developer):
• Successfully handled a team of 5 members by assigning various tasks at different workloads.
• Expertise in estimating the tasks and pro actively working with the clients.
• Compiling strategic analysis for moving typical data from one source system to another
and to the warehouse.
• Sometimes handled Change Requests (CRs), Issue Logs and Defect Track Sheets.
• Ensuring the client regarding billing hours of offshore via time sheets.
Development Skills:
• Did error handling in Teradata while moving the data.
• Good knowledge in fine tuning of queries and Teradata Utilities like BTEQ, Fast Load,
Multiload, Fast Export and TPump.
• Working with ER, UV and WT tables in error handling at various situations.
• Expertise in Debugging and Identifying fixes at various levels of Teradata.
• Good understanding of performance tuning, doing data reconciliation, using different
Transformations, monitoring the support process and failure handling.
• Experience of working with views, functions, triggers.
Educational Background
Diploma in Export Management, Export 1996
from Indian Institute of Export Management- Bangalore
Master of Business Administration (MBA), Marketing 1995
from KIMS, affiliated to Kakatiya University, Warangal
Bachelor of Science (B.Sc), Math 1992
from CKM College, affiliated to Kakatiya University, Warangal
Experience Summary
• Worked as a Project Leader for Apollo Health Street, Hyderabad from Sept 2008 – June 2010
• Worked as a Senior Technical Associate for Tech Mahindra, Pune from July 2004 – Sept 2008
• Worked as a Consultant for AFL InfoTech Ltd, Mumbai from Oct 2003 – March 2004
• Worked as a Software Consultant for Infosys Technologies, Pune from Jan 2003 – June 2003
• Worked as a Senior Software Programmer for Rao’s Soft, Warangal from Nov2001 – Dec 2002
• Worked as a Analyst Programmer for Singapore Telecommunications, Singapore from September 2000 – September 2001
• Worked as a Programmer for Gayatri Starchkem Limited, Hyderabad from April 1997 – May 2000
Technical Skills
Database : Teradata V12.0/V2R5, Oracle 8i/9i
GUI’s : Delphi 3/4/5/6, Visual Basic 6
Reporting Tools : Crystal Reports (8.0)
Operating Systems : Windows 95 /Windows 98/2000/XP, UNIX
Web Technologies : HTML, VBScript, ASP
Tools & Utilities : Teradata SQLAssistant, BTEQ, Fast Load, MultiLoad, Tpump and
Query Manager
Operating Systems : Windows 2000, Windows XP, UNIX
Training Attended:
Ø Siebel 7.7 CCC Internal Training 2006
from Tech Mahindra, Pune
Ø ITIL Internal Training 2007
from Tech Mahindra, Pune
Ø PMP Training 2009
from PMCC, Bangalore
Appreciations & Awards:
Credit of being the winner of SINGTEL (Singapore Telecom) Spot Awards for good performance in developing COCS (Connecting Operators Charging System) Project at Singapore Telecommunications Limited, Singapore.
Recent Accomplishments:
Project Name : Total Criterions Medical Suite (TCMS)
Client : Criterions, USA
Project Role : Project Lead/Sr.Developer
Software tools : Teradata, BTeq, Fast Load, MultiLoad, Delphi, UNIX, Windows2000
Team Size : 4
Project Description:
The primary objective of TCMS is to provide the full spectrum of information management needs - clinical, financial and administrative, for Major Hospitals. It’s a state-of- the art system that will enhance the accuracy efficiency and rapidity of your office’s medical billing, responsibilities. It also features an easy to use scheduling program that is designed specifically to your scheduling needs and an integrated information management software program that encrypts and stores any data or images, accordingly.
Responsibilities:
Ø Understanding existing business model (Blocks, Releases) and customer requirements.
Ø Providing optimal Data warehousing solutions to the Business.
Ø Using Teradata loading Historical and Incremental Data into Dimension / Fact tables.
Ø Extensively worked in data Extraction, Transformation and Loading from source to target
system using BTEQ, Fast Load and MultiLoad.
Ø Preparation of the unit test plan and test results along with the test data.
Ø Did data reconciliation across various source systems.
Ø Working on Data Cleansing.
Ø Managing defects and resolving environmental issues.
Ø Involved in query tuning and performance for some existing queries built for reports.
Ø Involved in Writing/Tuning the BTEQ, Triggers, Macros, Mload, Fload scripts for better
Performance.
Ø Client Meetings on providing the progress details of the tasks
Ø Assisting team members in Design, Development & resolving defects and Resolving Issues and problems faced by the team. .
Project Name : One Siebel (ASG)
Client : BT, UK
Project Role : Team Lead/Developer
Software tools : Teradata
Other Data bases : Siebel 7.7, Windows 2000 and Teradata (V2R5)
Environment : UNIX, Windows 2000.
Team Size : 4
Duration : Jun 2009 to Dec2009
Project Description:
One Siebel is the CRM platform currently being deployed to Major Business, Global Services and BTNI. It is a platform that is intended for all account managed customers and leverages the latest Siebel 7.7/Teradata technologies. One Siebel Platform will reduce the number of Siebel platforms in BT.
It supports the One BT end-to-end CRM business process model.
Responsibilities:
Ø Understanding the functionality and tasks to do by going through the documents
Ø Writing scripts in Bteq according to the Test cases.
Ø Did data reconciliation in Teradata.
Ø Sometimes collected the statistics and used join indexes.
Ø Answering ADHOC requests from the Business users.
Ø Load monitoring the Support Process by failure reporting and failure handling.
Project Name : Vodafone Logging and Tracking System (VLTS)
Client : Vodafone
Project Role : Team Member (Teradata)
Software tools : Teradata V2R6/12
Other Data bases : Oracle
Environment : UNIX, Windows 2000.
Team Size : 4
Duration : Jun’05 – Dec’05
Project Description:
Vodafone logging and tracking system enabled tracking of events within Vodafone’s departments, corporate partners and pay as you Talk (PAYT) customer care, including outsourced call centers. This Data warehouse project was implemented with Teradata RDBMS on Unix Server 4400 With MPP architecture. The data is sourced from various applications like, customer information, accounting information, marketing information, postcode information, business info and sales information, which are running on mainframe with Teradata database. This Project provides consistent, reliable and timely customer-centric data that is used for business critical decisions.
Responsibilities:
Ø Actively involved in understanding business requirements, analysis and design of the ETL
process.
Ø Extensively worked in data Extraction, Transformation and Loading from source to target
system using BTEQ, FastLoad and MultiLoad.
Ø Working with ER, UV and WT tables in error handling.
Ø Identifying the usage of Indexes in Teradata at various situations as part of tuning.
Ø Collected the statistics and used join indexes.
Ø Experienced in Writing/Tuning the BTEQ, Triggers, Macros, Mload, Fload scripts for better
performance.
Ø Load monitoring the Support Process by failure reporting and failure handling.
Ø Involved in preparation of loading & extracting scripts using Teradata (MultiLoad, FastLoad,
FastExport, BTEQ) utility.
Ø Involved in query tuning and performance for some existing queries built for reports.
Project Name : Advanced Commercial Banking System (ACBS)
Client : FIDILITY Bank, USA
Work Location : Mumbai, India
Duration : Aug ‘04 – Mar ‘05
Team size : 2
Platform/OS used : Delphi V6.0 as Front-end, Oracle9i as Backend
Project Description:
Enabled client to automate the entire corporate lending and syndication/trading process used by bank. ACBS is installed in more than 30 top global banks, including 16 of the world’s 50 largest banks & financial institutions.
Responsibilities:
Ø Provided after Hours Telephonic Support to ACBS external & internal Customers, Network Support for Account Lockout / New Account Creation and developed Support for Lansa & Visual Lansa related Tasks on AS/400 / Windows.
Project Name : Connect RM: Points Engine
Client : Carlson Marketing Group, UK
Work Location : Mumbai, India
Duration : Oct ‘03 – Mar ‘04
Team size : 4
Platform/OS used : Delphi V6.0 as Front-end, Oracle 8i as Backend
Project Description:
This application accumulates points and subsequent redemption of these points within a marketing program. Enabled setup and execution of points, and makes scoring mechanism to allow transaction activity to be monitored over a given period of time. It is developed using Automated COM objects.
Responsibilities:
Ø Performed Front end Coding, Creating Reports, & Code optimization. Worked on Change
requests per the client requirements.
Project Name : DHL Easyship
Client : DHL Couriers, Malaysia
Work Location : Pune, India
Duration : Jan ‘03 – Jun ‘03
Team size : 140
Platform/OS used : Delphi V6.0 as Front-end, DBISAM V3.2 as Backend
Project Description:
A multi-lingual application to provide basic shipment processing and shipment inquiry and tracing functionality to customers. It will support multiple levels of user access and deployed on a LAN with multiple installations, accessing a single database on a server. Contains design units they are: Airway bills, Receivers, Shippers, Reports, Utilities, Manifest, and Telecom
Responsibilities:
Ø Responsibly handled Front-end coding, custom components creation, Writing common functions and generating Reports.
Project Name : Cybernitics of Library
Client : Jaya Model Degree College,
Work Location : Warangal, India
Duration : June 2002 - November 2002
Team size : 3
Platform/OS used : Delphi V6.0 as Front-end, Oracle V 8i as Backend
Project Description:
This package records the Books, Students and Staff information; the purchasing and selling details of the books, physical locations of the books in the library. It stores the books issue details and returns de-tails and it also maintains the data about booksellers. It generates the reports like Total books list, issued books list, currently available list and lost books information.
Responsibilities:
Ø Responsibly designed the Front-end & database, developed reports (using quick Reports).
Created kit for the application.
Project Name : College Administrator
Client : Masterji Degree & P.G. College,
Work Location : Warangal, India
Duration : Dec ‘01 – Nov’ 02
Team size : 3
Platform/OS used : Delphi V5.0 as Front-end, Oracle V 8i as Backend
Project Description:
This System manages the transactions of students like Admissions, Fee and Exams, new student’s admissions, modifications, modification, deletions, online fee payments, and off-line fee payments. In the case of exam module, it allows to enter marks.
Responsibilities:
Ø Designed the Front-end, developed Reports (using Quick Reports) and
Setup kit for the application.
Project Name : Access Control Application (for COCS)
Client : Singapore Telecommunications Academy,
Work Location : Singapore
Duration : May ‘01 – Sep ‘01
Team size : 3
Platform/OS used : Delphi V5.0 as Front-end, Oracle V 8i as Backend
Project Description:
Implemented Access Control Application into the main COCS application. Menu items & buttons were disabled according to the user access rights. Ensured security control over the different group of users.
Responsibilities:
Ø Adeptly designed the Front-end, developed various Reports (using Quick Reports), created Help files (using Microsoft Help Workshop) and integrating them with the application.
Project Name : Connecting Operator Charging System (COCS)
Client : Singapore Telecommunications Academy, Singapore
Work Location : Singapore
Duration : Oct ‘00 – Apr ‘01
Team size : 5
Platform/OS used : Delphi (5.0) as Frontend, Oracle (8i) as Backend, Crystal Reports (8.0)
Project Description:
Facilitated for charging the interconnect operators for the calls routed into the Sing Tel’s physical network infrastructure. Manages up to 10 million CDR s (CALL DETAIL RECORDS) daily from validation to pricing and monthly generation of Invoices and Billing Verification Reports.
Responsibilities:
Ø Responsibly handled database analysis, designed of the Front end, Developed reports (3.0) and Crystal Reports (8.0), Custom Components Creation, and created Help files (using Microsoft Help Work-shop).
Project Name : Payroll Maintenance System
Client : Gayatri Starchkem Limited
Work Location : Hyderabad, India
Duration : Jun ‘99 – Nov ‘99
Team size : 3
Platform/OS used : Delphi (5.0) as Front-end, Oracle (7.3) as Backend
Project Description:
The project dealt with Attendance Register, Salary Register, Monthly summary generation depending on the data imported from Electronic Attendance Recording Machine. Generation of reports like Department Pay Details, monthly wages summary, details of overtime and incentives payments, social welfare expenses etc.
Responsibilities:
Ø Expertly designed & developed Software. Created reports using Quick Reports. Interacted with the HR Team to collect the requirements to build the application. Installed the application at Head Office and Factory.
Project Name : Shares Accounting Package
Client : Gayatri Starchkem Limited.
Work Location : Hyderabad, India
Duration : Aug ‘98 – Apr ‘99
Team size : 3
Platform/OS used : Delphi (3.0) as Front-End and Oracle (7.3) as Backend Database
Project Description:
This application maintains database for Shares Holders related information , monthly Transfers, Updating, Splits, Duplicate Issues, Transfer Reports, Distribution Schedule with Annexure & Annual Returns with Annexure Etc.,
Responsibilities:
Ø Designed the application as per the existing FoxPro based software.
Ø Studied the existing application (which is created in FoxPro 2.5 version) and converted it to FoxPro based application to Delphi and Oracle.
Project Name : Sales Controlling System
Client : Gayatri Starchkem Limited.
Work Location : Hyderabad, India
Duration : Oct ‘97 – Jun ‘98
Team size : 3
Platform/OS used : Delphi (3.0) as Front-End and Oracle (7.3) As Backend
Project Description:
Project dealt with Dispatch Instruction/ Order Acknowledgement, Invoice- Cum-Delivery Challan, Excise Gate Pass, Sales Journal, Excise.
Responsibilities:
Ø Efficiently designed & Coded Application. Creating the reports using Quick Reports.
