SUMMARY

• Senior developer emphasizing technology and best practices while constantly providing optimal solutions that are aligned to the business needs
• More than 9 years of experience as developer in various technologies and key solution designer positions.
• Oracle Certified Associate - PL/SQL Developer.
• Strong knowledge of Oracle PL/ SQL, ETL Informatica, MS SQL Server 2005, 2008 and Autosys scheduler.
• Worked extensively on performance optimization and have considerable experience in tuning complex SQL Queries.
• Have working knowledge of UNIX shell scripting, Oracle SQL Developer Data Modeler.
• Have hands on experience with C# .Net, WCF, WPF, ASP.Net, MS SQL, .Net - MVC 4, SSIS and SSRS.
• Excellent ability to grasp complex systems, identify and analyze requirements to provide appropriate successful solutions.
• Have solid experience in 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.
• Domain-oriented: Leader in seeking out and sharing the latest domain related knowledge and developments.

TECHNICAL SKILLS

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

Database: Oracle PL/SQL - 9i, 10g, 11g, 12c, MS SQL 2005, 2008, 2012 and 2014.

Tools: Informatica Cloud, Power Center 8.6, Visual Studio 2008, 2012. MS SQL Server 2008, 2012, 2016. SQL Profiler, Oracle SQL Developer Data Modeler, SSIS, SSRS.

Version control: TFS 2008 & 2012, SVN.

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

PROFESSIONAL EXPERIENCE

DirecTV Dealer

Confidential, Agoura Hills, CA

Responsibilities:

• Modified the SQL queries and stored procedures to enhance the existing ETL Informatica Cloud process that handles Confidential process for ATT and Century Link clients to handle increased volumes.
• Worked with business teams to gather requirements about new DirecTV Confidential process and helped in the high-level design of the same using SQL.
• Using SQL, Informatica and SSIS worked on standardizing the Confidential process by identifying the common modules and the data required for the sales reps.

Enterprise Payment System

Confidential, 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 DirecTV using Oracle PL/SQL, UNIX, Autosys scheduler and ETL Informatica .
• Analyzed and Investigated 18 months’ worth of data to improve performance of long running query; identified the root cause and reduced the run time of the query from 10s to <0.1s.
• Profiled the data to identify the root cause of missing pre-paid commissions and prepared a report that can be used to identify such scenarios in advance.
• Worked on the Oracle PL/SQL performance tuning of complex SQL queries used in the purge process. Reduced the execution time of the purge process from 22 hours for 100k records to 3.5 hours for 300k.
• For the integration project to integrate DirecTV dealer payments on to ATT payments coordinated with multiple upstream systems and designed and developed PL/SQL packages, stored procedures, functions and triggers in an optimal manner to ensure timely delivery of the project with minimal defects.
• Worked on high volume, time-critical ETL load process which loads customer data based on which customer credits and dealer payments were made.
• Enhanced ETL Informatica Workflow to handle multiple data marts. Helped setting up new Informatica flow for integration customers.
• Worked on mappings, transformations, workflows and sessions to make modifications to the existing ETL process in order to accommodate changes to the underlying architecture due to the integration activities.
• Designed and delivered mappings and workflows for loading new customers using ETL Informatica process.
• Analyzed and provided optimal solution for tuning a long-running Informatica load process.
• Using SQL Developer Data Modeler identified optimal flows for customer loading process and suggested optimal ETL process to load customer service data.
• Worked with Admins to get a high-level overview of setting up Informatica in a new environment.
• Identify process gaps by analyzing the payment data and suggested improvements to the existing processes; saved ~250k per year in the install payments.
• Using PL/SQL stored procedures, packages and UNIX shell scripts, worked on automating deployment processes across multiple environments. Also using functions, triggers, cursors and SQL Developers Unit testing tool developed unit testing automation module to generate multiple combinations of flat files
• As a lead, assisted in designing Telco bundles chargeback; also by analyzing past defects, helped reducing the defect density by 80%.
• Saved ~$50k for the business by suggesting them to use an existing design of Telco bundles package for a new project, which led to its implementation without any development effort.
• Also worked Actuate reports / report Forms to display payment details to the business team.

Technology / Tools: Oracle PL/SQL, UNIX, Informatica (ETL), Autosys

Supplier Management System

Confidential, CA

Responsibilities:

• Analyzed and documented the end-to-end flow of Supplier Management System (SMS) of DirecTV, 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, helped in proposing improvements to the SMS.

ATT/DirecTV

Confidential, CA

Responsibilities:

• Using Oracle PL/SQL procedures, packages, functions and triggers - designed and delivered change requests and projects for DirecTV’s customer crediting systems.
• With end-to-end knowledge of the crediting application combined with the understanding of the business requirements, provided precise estimations and detailed design documents pertaining to each Offers project.
• Using complex SQL queries, designed the required packages, stored procedures, cursors and functions to standardize the error handling mechanism across the application.
• Despite a tight schedule, using PL/SQL stored procedures, functions, triggers and UNIX enhanced the NFL ticketing offers project and delivered it on-time without any defects just before the season started.
• Proactively analyzed the root cause of requirement defects that occurred every quarter and suggested requirement tracking and analyzing approaches thereby helped in reducing the defect density by 22% when compared to the previous 6 months.
• Helped team to achieve more than 96% of their milestones in these projects by pro-actively tracking and coordinating different modules of the project.
• Was instrumental in identifying enterprise level impacts for Extend equipment return timeline project and helped the teams to arrive at an optimal high level solution.
• The application was a Proof of Concept for PCL - which takes care of Request tracking. It has 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.
• This 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, helped improving the run times by up to 33%.
• Managed the back-office application – Smartbike. The application manages bike rental wing of Clear Channel.
• 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, SQL procedures, triggers and functions – 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.