SUMMARY:

• 12+ years of IT and telecom industry experience encompassing a wide range of skill set, roles and industry verticals.
• Excellent communicator with strong investigation, problem - solving and decision-making skills, combined with a pragmatic approach and sound business acumen.
• Extensive experience in working/coordinating with the end user groups/communities to gather and collate the requirements to determine the underlying business processes driving the needs of the enterprise.
• Experience with data flow diagrams, data dictionary, database normalization theory techniques, entity relation modeling and design techniques. Expertise in client server application development using Oracle 12c/11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOAD and SQL* LOADER.
• Developed complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL. Effectively made use of table functions, indexes, Table Partitioning, Collections and query rewrite.
• Proficiency on using various Oracle utility tools SQL Plus, TOAD, PL/SQL Developer, SQL Navigator, SQL*Loader and Erw in.
• Experience in Tuning the application using Explain plan, SQL Trace and HINTS to optimize the cost and for higher efficiency.
• Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL tables.
• Developed materialized views for data replication in distributed environments .
• Experienced in following and monitoring processes improvements throughout the product development lifecycle (define, develop, unit test, install, deploy) using SDLC with phase like for a point of sale/ enterprise application.
• Experience in working as Technical Lead in onshore-offshore model and teams located across different geographical locations efficiently in diverse environments and oversee client/customer/vendor relationship to ensure that we met or exceed service expectations.
• Received consecutive appreciations from Senior Management for effective management of deliverables, dedicated teamwork, high energy, work ethics and commitment.

TECHNICAL SKILLS:

Languages: C, C++, PowerBuilder, JAVA, JSP, Visual Basic, .NET, ASP.NET, HTML, JavaScript, Form Builder, XML

Databases: MS Access, Sybase, Oracle 9i, Oracle 10g, Oracle 11g, Oracle 12c, MS SQL Server

Operating Systems: Windows 98/Me/2000/XP/7/10, Linux, Unix

Tools: /Utilities TOAD, Oracle SQL Developer, PL/SQL Developer, SQL Loader, ERwin, Crystal Reports, Quality Center, Rational Clearcase, InstallShield Express, Rational Portfolio Manager, Change Synergy, Jtrac, Symmetric DS

MS: Office

PROFESSIONAL EXPERIENCE:

Confidential, Overland Park, KS

Database Developer

Responsibilities:

• Work with Business team members to define technical requirements for new development and any support related changes.
• Develop/Modify programs using SQL, PL/SQL, UNIX Scripting and PowerBuilder.
• Involved in the continuous enhancements and fixing of production problems. Generated server-side PL/SQL scripts for data manipulation and validation of materialized views for remote instances.
• Prepare and execute unit/system test scripts to verify business logic of new or modified programs and mitigate post implementation failures.
• Work on Re-Architecture of the RMS application to move Business Logic written in PowerBuilder to Web services and stored procedures and deploy on Web logic Server.
• Created PL/SQL stored procedures, functions and packages for moving entire store data in between different channels.
• Partitioned the fact tables and materialized views to enhance the performance.
• Extensively used bulk collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Creation of database objects like tables, views, materialized views, procedures and packages using oracle SQL developer and SQL plus.
• Involved in data loading using PL/SQL and SQL *Loader calling UNIX scripts to download and manipulate files. Performed application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
• Handled errors using Exception handling extensively for the ease of debugging and displaying the error messages in the application.
• Worked on Symmetric DS tool to create a centralized database and replicate data from all channels used in Confidential to allow cross-channel returns and exchanges. Also used Golden Gate for replication across production databases.
• Responsible for Effort estimation -- Prepare LOE (Line of Estimation) for each project that consists of time required to complete the project/sub projects.
• Create user guide and system documentation for any new procedures or changes in the application.

Environment: Oracle 10g, Oracle 11g, Oracle 12c, Oracle SQL Developer, SQL, PL/SQL, SQL Plus, SQL Loader, ERWIN, PowerBuilder 12.5, PowerBuilder 11.5, ASP.NET, Unix, Windows 7, Windows XP, Win 2008 server, Symmetric DS, GoldenGate

Confidential, Boston, MA

PL/SQL Developer

Responsibilities:

• Provide daily support to the existing client server voter registration system for approximately 1000 users in over 350 offsite locations with additional selected, secure, interfaces to State and Internet networks.
• Evaluate business processes, anticipating requirements, uncovering areas for improvement, and developing and implementing solutions. Perform requirements analysis. Lead ongoing reviews of business processes and develop optimization strategies.
• Involved in creating UNIX shell scripting, De-fragmentation of tables, partitioning, compressing and indexes for improved performance and efficiency.
• Maintain database performance by identifying and resolving production and application development problems; calculate optimum values for parameters; evaluate, integrate, and install new releases; completing maintenance; answering user questions.
• Involved in the continuous enhancements and fixing of production problems. Designed, implemented and tuned interfaces and batch jobs using PL/SQL.
• Wrote sequences for automatic generation of unique keys to support primary and foreign keys in data conversion process.
• Analyzed and designed relational databases using ER studio and Erwin data model tool.
• Extract data from databases and create and display several reports using Powerbuilder and Crystal reports tool.
• Develop Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Create various user defined EXCEPTIONS to control the process based on the business requirement.
• Wrote packages to fetch complex data from different tables using joins, sub queries and database links.
• Determine database structural requirements by analyzing client operations, applications, and programming; reviewing objectives with clients; evaluating current systems.
• Develop and execute unit test plans, provide support for User Acceptance Testing and post production issues to the end users.

Environment: Oracle 10g, Oracle 11g, Oracle 12c, Oracle SQL Developer, SQL, SQL Loader, Win merge, Erwin, Unix, PL/SQL, PowerBuilder, Windows 7, Windows XP, Win 2008 server.

Confidential, Overland Park, KS

Onshore Technical Lead/ Database Developer

Responsibilities:

• Responsible for development and analysis of RMS (Retail Management System) application that supports any retail Operation, from a one-register store to a multinational chain, because of its highly scalable, relational database architecture mainly used by around 1200 Confidential Retail Stores and 50 Affiliates all over United States.
• Responsible for performing technical feasibility study based on system requirement received from system analyst or system architect and provide feedback for any modifications.
• Responsible for Change Management to transform the current application to store of the future on mobile and tablet devices to convert all middle logic to stored procedures that will be called by new webservices.
• Analyze and improve the performance of Oracle DB objects and batch applications.
• Lead and coordinate with offshore development team, monitor project progress, provide support for foreseen issues and ensure high quality software code using various quality process and strict adherence to guidelines to SDLC standards.
• Created various DML and DDL statements using Oracle PL/SQL and SQL.
• Work with SQL* Loader to import and export data from the flat files in and out of the legacy database.
• Worked with SQL Trace, TKPROF in generating statistics for queries which are performing badly.
• Develop/Modify programs using SQL, PL/SQL, UNIX Scripting and PowerBuilder.
• Participate in creation of database objects like tables, views, cursors (implicit, explicit, REF), procedures, packages, cursors, sequences using Oracle tools like PL/SQL, SQL* Plus, SQL* Loader and handled exceptions.
• Develop forms using Form Builder used to deploy on the Signature Capture Devices (SCD) that constitutes the peripheral part of the RMS application for consenting and capturing customer signature.

Environment: Oracle 9i, Oracle 11g, Oracle SQL Developer, InstallShield Express, JAVA, Rational Clearcase, SQL, PL/SQL, Toad, Pl/SQL Developer, PowerBuilder 11.5, Windows XP, Windows 2003 server, Win 2008 server.

Confidential

Subject Matter Expert

Responsibilities:

• Work closely with the Amdocs Infra team providing consultation for any PowerBuilder issues across Ensemble and provided training on security module used in CSM application.
• Responsible for analysis, development and support integrated testing to ensure smooth delivery.
• Develop implementation and test plans coordinated with end client to oversee the acceptance and dissemination process.
• Responsible for database design involving new objects or enhancements to existing objects.
• Designed and developed transactional and analytical data structures.
• Analyze and improve the performance of Oracle DB objects and batch applications.
• Develop tool called Internationalization in PowerBuilder for language translation between different languages (English, French and German) and was used across all the teams in Amdocs that used CSM application.
• Responsible for supporting different Service Call tickets, Incident tickets for implementation and maintenance activities.
• Provide support and gained experience in following Ensemble modules viz. CSM Online, Price Plan, OL2 applications, Security Online.

Environment: Oracle 9i, SQL, PL/SQL, Toad, PL/SQL Developer, Windows XP, UNIX, PowerBuilder 10.5

Confidential

Subject Matter Expert

Responsibilities:

• Worked on all the phases of development from High Level Estimate (HLE) till User Acceptance Testing (UAT) gaining functional & technical experience in the design of Telecom Billing Amdocs Ensemble (CSM Online) during this period.
• Responsible for analysis, development and support integrated testing to ensure smooth delivery.
• Develop implementation and test plans coordinated with end client to oversee the acceptance and dissemination process.
• Develop/Modify programs using SQL, PL/SQL, UNIX Scripting and PowerBuilder.
• Support enhancements in the Price Plan application and provide support to onshore system test team.
• Create, Track Defects and manage Test case reports using Quality Center.
• Analyze and improve the performance of Oracle DB objects and batch applications.
• Responsible for complete enhancement of Confidential Canada’s tax system with the Tax Harmonization Project that involved major Tax conversion in many provinces of Canada and had a major impact on the application.
• Responsible for identifying methods that will best fit the customer requirements.

Environment: PowerBuilder 10.5, Oracle 9i, SQL, PL/SQL, Toad, Pl/SQL Developer, Windows XP, UNIX

Confidential

Software Engineer

Responsibilities:

• Responsible for development of reports and enhancements in the ISEC ( Confidential ) application.
• Activities as Unit Test Case Creation, Coding, Unit testing & document updating with respect to ISO Standard were carried out.
• Coordinate with the client and made regular visits to the client place to gather requirements, and analyze the system.
• Migration of the application from PowerBuilder 6.0 to PowerBuilder 9.0.
• Worked closely with the testing team for identifying any functional gaps and ensured a smooth bug free delivery.
• Responsible for all the coordination activities and carrying out daily tasks as EOD (End of Day) processing and BOD (Beginning of Day) processing for the ISEC application.

Environment: PowerBuilder 9.0, Oracle 9i, SQL, PL/SQL, Toad, Pl/SQL Developer, Windows XP

Confidential

Consultant

Responsibilities:

• Prepare Software Requirement Specifications and User Manual Documentation.
• Responsible for development and testing of different interface screens for the treasury module at Confidential .
• Responsible for development of the modules as Certificate of Deposits (CD) and Collateral Borrowing and Lending Obligation (CBLO).
• Develop Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Carry out end to end activities required for the development/enhancement of the application.
• Provide support for the existing modules in the treasury application and prepared reports on Defect fixing and code changes carried out during the support activities.
• Migrate treasury application from PowerBuilder 8.0 to PowerBuilder 9.0
• Prepare reports using PowerBuilder 8.0 and 6.0.

Environment: Sybase ASE 12.5, ASA 7.0, Oracle 9i, SQL, PL/SQL, T-SQL, PowerBuilder 9.0, Windows XP

Confidential

Trainee Engineer

Responsibilities:

• Installation, Commissioning & Acceptance testing of SDH Transport Access Equipment (An-2000) from UTSTARCOM used in TTML (Tata Teleservices Maharashtra Limited).
• Coordination with sub-contractors and engineers to plan and schedule installation activities for a particular region.
• Assist monitoring transmission activities and help solve issues in downtime.