Sr Developer & Analyst

RACHANA KHATKHATE H: 847-***-**** C: 317-***-****

*** ******* *****, ***. **, Wheeling, IL 60090 *******.*********@*****.***

SUMMARY OF QUALIFICATIONS

Software Developer and Engineer with experience as a technical lead for application development, maintenance, and enhancement projects. Adept at writing code to comply with user requirements and modifying existing code to improve efficiency. Excellent communication skills; able to gather requirements by talking to users and develop effective user training documents. Skilled at managing time and resources to meet strict deadlines. Background working independently or in a team environment.

Hands-on experience includes:

Working on issues with third party vendor code and interacting with their personnel to resolve issues.

Performance tuning of existing queries.

Designing new functionalities or re-designing existing functionality code for better performance.

Working with inter-platform designs and code for design and maintenance purposes.

Collaborating with business users and testers to develop comprehensive test plans.

Writing / modifying code to load data from flat files into the appropriate tables.

Writing / modifying stored procedures, stand alone functions, and PL/SQL packages to comply

with requirements.

Writing code to create a variety of reports, such as trending or forecast reports.

Writing technical documents for all code and database components added and/or modified.

Managing sensitive information effectively and efficiently.

TECHNICAL SKILLS

Programming: Basic, Pascal, C, C++ (with Data Structures and Object Oriented Design), VB, JAVA, Oracle, XML, VB.Net, ASP.Net, C#, MATLAB, VHDL, MIPS Assembly, POSTGRESQL, SQL, PL/SQL

Environments: Win NT/XP/2000/98/95, UNIX (Sun Solaris), Linux, OpenVMS System, Pro*C, SQL Navigator, TOAD

Applications: MS Office, Visual Studio, Visual Studio.Net, GNU debugger, SQL*LIMS, SQL*Trace, TK Prof and Explain Plan

Databases: Oracle 7x/8i/9i SQL Server, MS Access

Business Intelligence: Business Object 5.1.4/6.5, Crystal Reports 10, Oracle Forms and Reports, Developer 2000

ETL: Informatica Power Center/ Power Mart 5.1/6x

PROFESSIONAL EXPERIENCE

UNION SECURITY INSURANCE (ASSURANT EMPLOYEE BENEFITS), Kansas City, MO & Indianapolis, IN

Software Developer (06/2007 – 09/2009)

COMPASS (Comprehensive Administrative Support System): Policy Holder and Benefits Administration and Billing and Correspondence tool used by Assurant Employee Benefits

KEY PROJECTS:

Fulfillment Code Rewrite

Analyzed existing code for poor efficiency and limited volume-handling capabilities.

Redesigned the request managers code having JAVA and PL/SQL components.

Served as technical lead for the COMPASS team for this project. Worked with 3 Developers and 2 Business testers for completing the rewrite. Resolved several coding and other technical issues in the process.

OEM Report Creation

Created a PL/SQL script to debug production issues – this went on to become the basis of the OEM report used for post sales improvement, initial billing accuracy, and Six Sigma teams.

Automated report to generate monthly and send data in the form of Excel spreadsheet.

Modified Interfacing Pro*C code to send the information from the report to interfacing applications

Family Shared Max

Worked on designing and Developing Code for this product

Modified Oracle Reports and Created a new Oracle form to conform with the new design

Modified and added PL SQL functions and Procedures for the same

Modified and Maintained Pro*C code to accommodate the added functionality for interfacing with other applications

Change Management and SOX Compliance

Created and managed releases for the COMPASS team.

Collaborated with team members and change managers to put a process in place to efficiently create RFCs and manage releases with minimum post-production issues.

Ensured that all code and documentation was SOX compliant.

Contributed to troubleshooting and debugging during 10g upgrade for Oracle database, forms and reports, PaRisc to Itanium server upgrade, and COMPASS application upgrade.

E-BASE TECHNOLOGIES, Fremont, CA

Software Developer Consultant (11/2005 – 06/2007)

ASSURANT EMPLOYEE BENEFITS, Kansas City, MO

Software Developer and Business Analyst (02/2007 – 06/2007)

COMPASS (Comprehensive Administrative Support System): Policy Holder and Benefits Administration and Billing and Correspondence tool used by Assurant Employee Benefits

Studied existing code to support the COMPASS application; compared code with existing and new requirements and maintained the application code.

Read business requirement documents and interacted with users to obtain exact requirements.

Converted requirements into technical documents.

Calculated time estimates and determined deadlines.

Wrote efficient code in PL/SQL to comply with requirements.

Modified existing code to improve efficiency.

Modified and maintained Pro*C code used to interface with other applications

Modified existing database (Oracle 9i) elements as necessary.

Used SQL Navigator or SQL Trace to get the Explain Plan.

Provided performance tuning of new and existing queries using SQL Hints, Index Creation / Modification, Statistics Gathering, Data Partitioning, and Query Rewrite.

Worked on some JAVA code for interfacing with the interfacing teams.

Wrote and modified C++ classes and functions as wrappers around the PL / SQL code structure.

Created and modified Unix shell scripts to call the C++ code.

Created and scheduled Autosys jobs to run the shell scripts on a regular basis.

KEY PROJECTS:

Compass Conservation Letters code rewrite

Studied the code existing coding issues

Worked with the Business End users to analyze the required code enhancements

Took ownership of the code and worked with several developers from my team and other teams to create a comprehensive technical design

Created an phased implementation plan

Worked with the Business testers to create test plans and test cases for each stage of implementation

Created new PL/SQL packages

Created new Unix scripts and scheduled them for the nightly batch using Autosys scheduler

Worked with the Change Management team for the Production release of each of the phases

SPRINT NEXTEL, Overland Park, KS

Software Developer and Data Specialist (04/2006 – 11/2006)

RFISS (Radio Frequency Information Super Store): An application which started as a local RF solution and went on to become a national RF tool maintained by the IT Network Systems group at Sprint.

KEY PROJECTS:

Bouncing Busy hour (BBh) report

Maintained BBh report used by RF teams for modifying the base station tower designs.

Worked closely with RF teams to analyze the generated data and modify the code to make the report dynamic, smarter, and more efficient.

Worked on and resolved production issues with the report.

Change Control

Maintained and modified the change control code which converted data from the existing snowflake schema into star schema for more efficient reporting.

Worked with the DBA to modify the data architecture to reduce the number of joins in a query for efficient reporting, while keeping the data redundancy as low as possible.

AMGEN (COGNIZANT), Thousand Oaks, CA

Software Developer and Technical Writer (11/2005 – 02/2006)

POQ IS Team: Team customized SQL* LIMS code to suit requirements at Amgen. Maintained a large database (Oracle 9i); developed forms and reports for users in the organization.

Gained an understanding of the existing system, i.e., database, code, open VMS, and SQL* LIMS.

Used SQL Navigator to access and view database components.

Wrote and modified PL/SQL code to maintain the database.

Provided performance tuning using SQL*Trace, TKProf, and Explain plan.

Created and maintained application and database level triggers.

Created forms and reports in accordance with user requirements.

Created daily lab reports, weekly and monthly status reports, quarterly and yearly trending reports, and auto-generated lab label reports.

Documented the code using reverse engineering.

Created a Uniform Quality Design Document to comply with FDA standards.

UNIVERSITY OF CALIFORNIA, Riverside

Graduate Research Assistant (01/2004 – 06/2005)

KEY PROJECTS:

Constrained Minimum Spanning Trees

Studied existing polynomial time algorithms; implemented algorithms on various random graphs as well as on Traveling Salesman Problem (TSP) benchmarks using C++.

Researched improvements to the upper bound on weight of degree-constrained minimum spanning tree in comparison with unbounded minimum spanning tree.

Optimization of area allocation of decoupling capacitances

Studied decoupling capacitances used for noise reduction in P/G networks. The area allocated for these decoupling capacitances was optimized using conjugate gradient method; the gradient at each iteration was dynamically calculated using Adjoint-network method.

Implemented in C++ and tested on SPICE Netlists.

Reduced order modeling of linear circuits with multiple sources

Used extended Krylov subspace method to find orthogonal basis, required for similarity transformation of the given system into a reduced order system. First implemented for multiport systems with input sources, which change slowly; later extended to include high-frequency components of input sources.

Implemented both algorithms in C.

Large linear circuit analysis using partial random walk

Algorithm combines the pure random walk method with LU factorization. Tested on SPICE Netlists; implemented in C++.

Lecturer – Mumbai University, India (10/2002 – 06/2003)

Taught Engineering Mathematics, C, and C++ to engineering students.

Software Engineer (Intern) – BSES, Mumbai, India (07/2001 – 07/2002)

Software Application for Data Acquisition, Fault Line Isolation, and Alternative Source Provision.

EDUCATION

Master of Science in Electrical Engineering – University of California, Riverside (2005)

Bachelor of Engineering in Electrical Engineering – Mumbai University (SPCE), India (2002)

Advanced Coursework: Computer Architecture and Design, Computer Aided Electronic Circuit Simulation, Intermediate Data Structures and Algorithms using C/C++, Microprocessors, Computer organization, C Programming, Object Oriented Programming, Engineering Mathematics

CLASSROOM PROJECTS

Hospital Database

Database created POSTGRES with hospital data, showing all the integrity constraints.

Reduced Order Macro-Modelling of Linear Systems (Presentation)

Passive Reduced Order Interconnect Macro-Modelling Algorithm (PRIMA) implemented on SPICE Netlists.

Voice and Speaker Recognition System

Noise elimination from sampled voice signals, calculation of Mel Frequency Cepstrum Co-efficient (MFCC) for each voice sample. Project completed in MATLAB.

Contact this candidate