PROFESSIONAL SUMMARY:

• More than 10 Years of experience as a Perl developer in retail/telecoms domains, this includes requirements gathering, analysis, design, coding, testing, documenting, deployment and maintenance.
• 4+ years of experience in ETL tool IBM Data Stage 8.0.1/9.1, CGI, HTML, CSS and Oracle Database.
• In - depth experience in OO Perl, IBM Data Stage, C/Pro*C, SQL, PL/SQL, UNIX shell scripting, XML.
• Experience in using the source code control tools like CVS, SVN.
• Hands on experience in data migration, automation, designing and developing innovative solutions.
• Excellent analytical & problem-solving skill.
• Good verbal, written, and presentation skill.
• Excellent team member. Self-motivated and quick learner.
• Adaptable to a fast growing and changing environment.

TECHNICAL SKILLS:

Programming Languages: Perl 5.16.1, C/Pro*C, UNIX (Korn Shell/Bourne Shell/Bash/Awk/Sed), PL/SQL

Operating Systems: Linux (Red Hat/Ubuntu/Fedora), UNIX (HP-UX/Compaq-Tru64/Sun Solaris/IBM AIX), Microsoft DOS/Windows 95/98/NT

RDBMS: Oracle 8i/9i/10g (SQL & PL/SQL), SQL*plus, SQL*Loader, SQL*Net

Editors: Vi/Vim/Emacs, Edit Plus, sublime text 2, Eclipse.

Tools: XML/XSLT/XSD, CVS,Subversion,make, gdb debugger, JIRA, Serena Changeman, Autosys scheduler, curl, Toad 7.6, Secure CRT, PUTTY, SSH/FTP/SFTP/SCP/SSL/SNMP, VMware, VirtualBox,BMC Remedy Tools, STEVE Roaming TAP Editor, FileZilla Client, Oracle SQL DeveloperIBM Data Stage Client 8.0.1, 9.1, CGI, HTML, CSS

SDLC Models: Waterfall and Agile modelsFrame Works: DataX

PROFESSIONAL EXPERIENCE:

Confidential, King of Prussia, PA

Perl Developer

Responsibilities:

• Understand the requirements from Small projects team, size the estimate and design the project.
• Develop and code and test and support all the phases of SDLC cycle till the project gets into production.
• Involved in data migration project from Oracle 9i to 11g and server migration project from Secaucus data center to Los Vegas/salt lake city.
• Build interfaces for importing/exporting 3rd party data feeds leveraging various external formats using CPAN Perl DBI, Net::FTP,XML::CSV,XML::Simple, XML::Writer modules
• Write Perl modules to create new data feeds in XML,CSV formats as per SMP requests, To modify and develop new image feeds in production,
• Explore research and implement new technologies to obtain increased efficiency for large data set processing.
• To design and develop B2B Order feeds and order status feeds(Drugstore/Walgreens project), channel Advisor Sku Product and omniture feeds,scene7 image feeds, third party content feeds,
• Create automated content and image loading procedures, used XSD to design B2B XML order feeds,
• To modify and debug existing Perl code issues, to develop new feeds to extract data from the database and send to channel partners and web stores. To monitor the on call supports issues and fix them.
• Develop PL/SQL procedures & functions to generate the reports by retrieving the data from applications using IBM Data stage,
• Good understanding of DWH ETL concepts and IBM Data Stage 8.0.1/9.1.
• Developed parallel jobs, sequencers using Data stage.
• Troubleshooting and Tuning SQL queries, writing shell scripts, scheduling jobs through Autosys,
• Experience working with FTP, SFTP, and data encryption.

Environment: OO Perl 5.16.1, UNIX Shell scripting (Bash/Korn shell), Oracle 10g/9i (SQL, PL/SQL), SQL*Loader, Unix/Red Hat Linux, CVS, JIRA, Serena Changeman, XML/XSD/XSLT, Autosys, Oracle SQL developer,IBM Data Stage 8.0.1/9.1

Confidential

Information Specialist

Responsibilities:

• Meeting with all developers and project stakeholders to lead a kickoff meeting. Define and introduce the project, team members' roles, and key deliverables. Mapped out time lines, milestones, communication processes, question and answer session. Generate excitement and buy-in to secure commitment to project objectives, and share a group vision to start the team on a motivated track.
• Lead a team of six people in supporting the system post production. Identify gaps and plan for, plan and arrange for knowledge transfers. Coordinate and work closely with delivery to get in - depth knowledge of the solution that’ll go in production.
• Co-ordinate and keep a close check on ongoing issues to avoid later surprises. Keeping track of the end-to-end testing, Defect tracking and follow-up. Work as a focal point for all issues in UAT and production. Work towards 100% Production readiness by checkpoint meetings, Production readiness testing and arranging Knowledge transfer sessions for the Production support team. Document the business processes by identifying the requirements. Prepare functional test plan and test cases.
• Responsible for identifying new processes, finding out gaps in existing process, arranging modules for new process development and implementation.
• Design and prepare QA billing requirements and providing solutions to telecoms billing requirements

Environment: C, Perl, Korn Shell (KSH), Oracle 9i (SQL, PL/SQL), Linux/Ubuntu

Confidential

Technical services professional

Responsibilities:

• Managing a team of 15 application developers and providing guidance, setting goals and motivating them.
• Developing operational procedures, documents and conducting and giving knowledge transfer to new joiners.
• Writing SQL, PL/SQL programs including triggers and stored procedures for generating business reports.
• Developing applications in C, Pro*C and Perl and Korn shell.
• Supporting end to end development, design, testing and implementation of intra-circle roaming project.
• Worked on requirements gathering, detail design, construction, unit and system testing phase for development of Amdocs billing migration project for APRM, ARCM, ABMG and Rater.
• Innovating, designing, developing and testing new applications in roaming billing.
• Installation of SSH/SFTP public/private key setup and exchange of keys to initiate automatic file transfers,
• Attending the client meetings and coordinating with end users for resolving issues.
• Involved in up gradation of TAP version from 3.2 to 3.11.Written Perl scripts to automate the tasks.
• Handled new shipment implementation for
• MNP & Prepaid filtration.
• Created tables, synonyms, sequences, views, PL/SQL stored procedures and triggers.
• Created PL/SQL functions to facilitate the smooth migration of Confidential India telecom circles databases from Oracle 8i to Oracle 10g.
• Handled all India telecom circle roaming subscribers CDR rating, billing & support application migration.
• Participated in analysis and validation of input CDR files received for rating chain reject calls, invoices created and end user queries.
• Call dumps and sample bills generated and verified before & after rollout into production
• Written Korn shell scripts to perform sample rating and validation of TAP files in test environment. Involved in migration of DCH of Confidential India from MACH India to Syniverse India.
• Performed UAT of various roaming processes like IOT, re-pricing and RAP recycling and client online support portal.
• Performed sample processing and validation of Confidential IN files in FMS system.
• Automated comparison of sample TAP files versus Confidential data files in Perl.
• Enhanced existing Perl scripts to integrate the legacy systems with Amdocs billing systems.
• Designed and executed test cases for surround applications and functionality.
• Generated various reports in stored procedures and Korn shell scripts for data validation.
• Maintained the staging environment for Roaming LVT, HVT and FVT.
• Created documents for roaming billing migration strategy.
• Integrated ARCM module and validated Amdocs APRM & ARCM reports.
• Performed unit testing and raised defects as and when required.
• Performed in-roamer’s CDR charging in Amdocs SIT environment.
• Developed a Pro*C based application to provide data extract from legacy system for configuration in Amdocs SIT & U2U environment.

Confidential

Senior Systems Analyst

Responsibilities:

• Developing C and Pro*C applications to support the operations of roaming billing team.
• Handling IREG/TADIG Testing (IR 24, 32, 35, 60), coordinating with roaming coordinators, switch team (IREG team) and with DCH for launches.
• Writing Korn shell and Perl scripts to rectify the not rated calls both at the database and CDR level.
• Coordinating with the DCH for transfer of TAPIN, TAPOUT files (missing and aging files) and RAP disputes.
• Developing PL/SQL stored procedures, triggers to generate IOT reports, monitoring RAPs and resolving issues with DCH and roaming partners to avoid revenue loss. Reconciliation of aggregated TAPOUT files (via Roam ware aggregation cycles).
• Developing processes to provide the ad-hoc reports to various departments like Roaming Marketing, revenue assurance, finance and nodal agencies as and when required.
• Performed charging of CDRs (production and test) as per billing standards involving rating of home subscribers, in roamers and interconnect billing systems.
• Designing mediation exchanger application in Perl and Pro*C which would exchange files between Confidential and Idea FTP servers.
• Supporting the testing of ICR CDR at mediation and billing ends and freezing the common CDR format between Confidential and Idea telecom circles.
• Attending meetings with clients, Idea team and other stakeholders regarding the challenges, progress in implementation and coordinating with all the application end users about the impact of ICR and getting changes done at respective ends. And reviewed the changes with the client.

Tools: Pro*C, Korn Shell scripting (KSH), Oracle (SQL, PL/SQL), HP-UXRoaming TAP Manager

Confidential

Responsibilities:

• Designed and developed customized solution in Pro*C and Perl for Confidential India.
• Achieved 100% SLA in Confidential file management using Korn shell scripting.
• The application is fully automated and monitored 24*7/365 days and handles all types of exceptions.
• Conceived and developed this application in Perl, Pro*C, Curl and extended it to six Confidential telecom circles, resulting in huge revenue saving for client. Appreciated by client and recognized as the best performer of the year 2008 by IBM India.
• Developing applications in Perl and Pro*C for handling tap validation and decoding and loading of tap files into databases,
• Developing stored procedures to generate HUR (High Usage Report) reports and IOT (Inter-operator Tariffs) Validation reports.
• Developed Korn shell and Perl scripts to do tap recycling and repairing, and processing and transfer of files to individual roaming partners,

Environment: Pro*C, Perl, Oracle (SQL, PL/SQL), Korn Shell, HP-UXClient: Orange/Hutchison Max Telecom Limited, Mumbai, India