SUMMARY

• Senior developer emphasizing technology and best practices while constantly providing optimal solutions that are aligned to the business needs
• Over 8 years of experience as developer in various technologies and key solution designer positions.
• Oracle Certified PL/SQL Developer.
• Strong noledge of Oracle PL/ SQL, Informatica, MS SQL Server 2005, 2008 and Autosysscheduler.
• Worked extensively on performance optimization and have considerable experience in query tuning.
• Have working noledge of UNIXshell scripting.
• Also have hands on experience with C# .Net - (WCF and WPF), ASP.Net, MS SQL, .Net - MVC 4 and Entity framework.
• Excellent ability to grasp complex systems, identify and analyze requirements to provide appropriate successful solutions.
• Have solid experiencein requirement analysis, design, solution preparation and release management phases of Waterfall and Agile development processes.
• Highly collaborative: develop and nurture relationships throughout IT groups and business units
• Worked in multi-cultural, multi-vendor, cross-platform applications to deliver high visibility projects.
• Automation: Automated the build and deployment process of an application, spanning multiple environments and different configurations using InstallShield.
• Domain-oriented: Leader in seeking out and sharing the latest domain related noledge and developments.

TECHNICAL SKILLS

Applications: Crediting systems, Supplier Royalty Management, Inventory management, Invoicing, Customer management and Billing

Technical skill set: .Net 3.5 & 4.0 - MVC 4 - Entity Framework 5, C# .Net, ADO.Net, Win Forms, Web forms, SSIS, SSRS, Angular.js, bootstrap.css, ASP.Net, UNIX - Shell Scripting.

Database: MS SQL 2005, 2008, 2012. Oracle PL / SQL

Tools: Visual Studio 2008, 2012. MS SQL Server 2008, 2012. WCF Test client, SQL Profiler, IIS, Visio, InstallShield, Autosys.

Version control: TFS 2008 &2012, SVN.

Operating Systems: Windows Server 2008, Windows NT, Windows 7 & XP.

PROFESSIONAL EXPERIENCE

Confidential, El Segundo, CA

Responsibilities:

• Designed and delivered optimal solutions to multiple projects within tight deadlines for the Enterprise Payment System (EPS), which handles payments to dealers of Confidential, using Oracle PL/SQL.
• Using PL/SQL procedures and UNIX shell scripts, worked on automating deployment processesacross multiple environments. Also using PL/SQL and SQL Developers Unit testing tool developedunit testing automation module to generate multiple combinations of flat files
• Worked on the Oracle PL/SQL performance tuning of the purge process. Reduced the execution time of the purge process from 22 hours for 100k records to 3.5 hours for 300k.
• Enhanced Informatica Workflow to handle multiple databases.
• For theintegration project to integrate Confidential dealer payments on to ATT paymentscoordinated with multiple upstream systems and designed and developed PL/SQL packages,procedures, functions and triggers in an optimal manner to ensuretimely delivery of the project with minimal defects.
• As a lead, assisted in designing Telco bundles chargeback; also by analyzing past defects, halpedreducing the defect density by 80%.
• Saved ~$50k for the business by suggesting them to use an existing design of Telco bundles packagefor a new project, which led to its implementation without any development effort.
• Also worked on high impact projects such as Income Tax filing reports and Continuous SubscriptionFee payment reports and halped in smooth, defect-free delivery by coordinating with the testingteam.
• Analyzed and documented the end-to-end flow of Supplier Management System (SMS) of Confidential, which handles $10B in annual payments to the content providers.
• SMS is built using combination of Oracle and Pro *C. The bulk of the business logic is database driven.The data is gathered and payments are made on a monthly basis to the content providers.
• With the ability to quickly grasp the functionality of a system, halped in proposing improvements to the SMS.

Confidential, El Segundo, CA

Responsibilities:

• Using Oracle PL/SQL designed and delivered change requests and projects for Confidential ’s customercrediting systems.
• With end-to-end noledge of the crediting application combined with the understanding of thebusiness requirements, provided precise estimations and detailed design documents pertaining toeach Offers project.
• Designed the required tables, procedures and PL/SQL packages to standardize the error handlingmechanism across the application.
• Despite a tight schedule, using PL/SQL and UNIX enhanced the NFL ticketing offers project anddelivered it on-time without any defects just before the season started.
• Proactively analyzed the root cause of requirement defects that occurred every quarter andsuggested requirement tracking and analyzing approaches thereby halped in reducing the defectdensity by 22% when compared to the previous 6 months.
• Helped team to achieve more TEMPthan 96% of their milestones in these projects by pro-actively trackingand coordinating different modules of the project.
• Was instrumental in identifying enterprise level impacts for Extend equipment return timelineproject and halped the teams to arrive at an optimal high level solution.

Technologies / Tools: Oracle PL/SQL, UNIX, Autosys.

Confidential

Responsibilities:

• The application was a Proof of Concept for Confidential - which takes care of Request tracking. It TEMPhas the ability to work offline, online and on desktops as well as tablets. It was implemented using latest .Net 4.0 - with MVC and K2 workflow to take care of sequential flow.
• Worked on the Models, Controllers and the database (SQL 2012) parts of the application. Used code first approach in Entity Framework to effectively create appropriate objects.
• Also coordinated integrating the application, which was implemented by 4 different teams on two different platforms - to make the application work both on desktops and portable mobile devices.
• Within a limited time, learnt the new technology and scaled up to deliver quality code.

Technologies / Tools: .Net 4.0, C#, MVC, MS SQL 2012, K2 Workflow.

Confidential

Responsibilities:

• Mentored a team of 5 software engineers to develop and deliver enhancements for the Smartbike Back-Office application.
• Automated build and deployment process of the entire application to different environments using InstallShield.
• Managed the SSRS and SSIS part of the Smartbike Back-Office application.
• dis part of the application involves preparing reports by transferring data from the production database to report database on a daily basis.
• Upgraded the application from SSRS 2005 to SSRS 2008; combined with the tune-up activities, halped improving the run times by up to 33%.

Technologies / Tools: .Net 3.5, C#, MS SQL 2008, WCF, WF, WPF, SSIS, SSRS, InstallShield.

Confidential

Responsibilities:

• Managed the back-office application - Smartbike. The application manages bike rental wing of Confidential .
• Involved in managing invoicing module – enhanced handling credit notes and optimized the invoice processing based on customer usage.
• The application was designed and developed in C#.Net. It made use of all the .Net capabilities including WCF, WPF and Windows Workflow.
• Coordinated with another vendor and worked on enhancing the website. Using ASP.Net – added new functionalities like displaying station details such as number of bikes remaining, station status, active bikes, etc.
• Maintained and enhanced the application and handled high volume production releases for cities like Barcelona and Antwerp.
• Also enabled theInfosys offshore team of 5 at Shanghai to scale up and deliver the projects from Shanghai and ensured that the transition from Chennai to Shanghai was smooth.