HARIKRISHNAN
PROFILE
A Senior developer and a natural analyst with techno-functional experience in Customization in Telecommunication Billing System (Ensemble, Enabler) with more than 12 years of experience in, Oracle, C, COBOL, PL/SQL, and shell scripting. In an IT career that spanned 9+ years, analyzed, designed, developed, tested, deployed, and supported N-Tier & client/server applications for telecommunication, production, and sales oriented industries. Well experienced Amdocs application developer with working knowledge of COBOL, C, and Focus. Capable team player with excellent communication, analytical, interpersonal and presentation skills, who works well with people at all levels, with extensive experience in working under high stress environment. Participated in project requirement and planning meetings with customers.
TECHNICAL EXPERTISE
LANGUAGES COBOL,PRO*C, “C”, Sqlplus, PL/SQL, Shell scripting, Focus/Web Focus,PERL
RDBMS Oracle 9.i/8i, Sybase, Ingress and MS Access
OPERATING SYSTEMS Unix, Solaris, and Windows 9x/NT 4.0/2000
OTHER TOOLS TOAD, Ms-Office, Mercury Test Director and Steve
MODULES EXPERTISE:
• Billing
• Message Processing system
• Price Plan
• Account Receivable (AR)
• CSM
• QA
• Reports
• Can handle any development modules
PROFESSIONAL EXPERIENCE
American Express, NY, U.S.A May’08 – Till Date
Product : GRCA (Global Rewards Capabilities and Analytics) Reporting Portal
Title : SR Data Architect
GRCA reports is a reporting portal where managers/BAs of AMEX can see the various reports like Activation Trend reports, Attrition Reports, Account Profile 12 month snapshot reports etc.worked on Designing, Developing, Testing this reports.
• Collecting user requirements, data base design, report design Etc
• Develop SAS queries to extract high volume of report data from tables
• Convert SAS datasets to relevant format ready for cube processing
• Involved in dimension tables design, data mart design
• Responsible for cubes design
• Creating cubes and processing
• Data loads into dimension tables etc
• Analysis and testing the reporting data against all possible sources
• Responsible for Data loads using DTS, DTS scripting etc
• Responsible for creating DTS packages that process the OLAP cubes and dimensions
• Trouble shooting DTS packages, cubes and dimensions
• Database management like taking backups, restoring the database
• Worked with SQL Server 2005, OLAP, MS DTS, MS Analysis services
• Worked with creation of SAS datasets using SAS9 and SYSBASE
Environment: SQL Server 2005, SAS9, SYBASE, Analysis Services, MDX, ASP.NET
Amdocs Canada Inc, @ Bell Canada, Montreal May 06 – May 08
Project : Billing Ensemble
As a Senior Subject Matter Expert my responsibilities
• Design and development of Billing application module
• Involved in the full software development cycle for the Billing module.
• Performed a valuable team member in BILLING application for new enhancements and production activities.
• Involved in the tier-2 activities of BILLING module and worked for smooth move of the daily activities.
• In a given short period of time understand the concept of BILLING process and playing a key role in BILLING development activities.
• Focal point for BILLING development activities and a trusted person for the client and the Amdocs team.
• Responsible for the Service Level Agreement for BILLING application performance.
• Responsible for inter module transactions with CSM, MPS and AR modules.
•
Environment: Unix, C, COBOL, Proc*C, PL /SQL, Tuxedo, Focus, Oracle
Amdocs Champaign Inc, Champaign Jun‘01 – May-06
Project : Sprint PCS and Nextel , Billing Module
As a Senior Subject Matter Expert my responsibilities
• Involved in Design &Development of Code for new Change Request for ENSEMBLE Billing.
• Involved in Unit Testing, Sub-System Testing, System Testing of the Developed Billing Modules.
• Handle Billing Issues based on severity on day-to-day basis
• Maintain Code for Different Billing Modules – Charge Creation, Balance calculations, QA, and reports.
• On-Site Support for the Customer for New Releases.
• Fine Tuning the Billing BATCH jobs performances to meet the Service Level Agreement.
• Creating Test Sets, Test Rules for New Module Changes and executing them.
• Interact with other teams like MPS, CSM, AR for a proper handshake of issues.
• Developed and Maintained Several New Billing /QA Reports
• FOCUS-Reporting Language Expert
• Hands-on Experience on Variety of tools – Mercury Test Director, TOAD etc;
.
Environment: Unix, C, COBOL, Proc*C, PL /SQL, Tuxedo, Focus, Oracle
Amdocs Cyprus Limited, Cyprus, Jan’98 – Jun’01
Client : MobiKomm, Austria, Manessman(MMO),Germany, and
Libertel,Holland
Title : Programmer/Sr.Programmer.
As a Programmer, I was responsible for
• Responsible for designing and developing new enhancements, testing, and problem fixing in support of existing BILLING applications.
• Developed Routines for Billing Extract (BE) Process.
• Developed Routines for Quality Assurance (QA) Process.
• Involved in Design, Development of Billing Report Process.
• Creating & Executing Test Cases for New Modules.
• Resolving Defects/Issues raised by the Customer.
• Creating New Batch Jobs for New Processes.
• Development of new enhancements using C, COBOL, and Focus
• Batch jobs and reports using C and COBOL.
• ORACLE 9.1 database tools TOAD
• In-depth knowledge in Amdocs SDLC, configuration control.
Environment: C, Tuxedo, Focus, COBOL, Oracle 9i, XML and
Sun Solaris 8.
AERIUS Systems Solutions Ltd, India Apr’96 – Oct’97
Product : Production Control System(PCS) for Leather Garment Factory
Title : Senior Programmer
PRAKASH Business Software Consultancy, India Jun’94 – Apr’96
Product : QUEST
Title : Programmer