Information Technology Professional

Extensive experience in object oriented software Design, Modeling, Analysis, Development Implementation of enterprise systems and Data warehousing. Demonstrated record of success in database design and performance tuning, project management, process improvement and problem solving for systems and business processes. Expertise in application of Microsoft and Oracle technologies within the in financial and pharmaceutical/medical device industries.

PROFESSIONAL EXPERIENCE

Confidential

Principal Software Engineer

• Conceived, designed and created the overall architecture of a mission-critical, highly scalable, n-tier web application, Abbott Point Of Care Configuration Manager ACM and web services needed to support the next generation i-stat system
• Actively contributed to implementation using Visual Studio, ASP.net, C , CSS, HTML, JavaScript, Web application and web service security, Active Directory, Entity Framework experience, jQuery, various design patterns, etc.
• Introduced and performed verification and validation tasks in highly regulated environment FDA
• Served as the group's SQL Server 2008/2012 technical expert.
• Standardized and automated data feed and delivery, eliminating issues in synchronizing with other satellite corporate applications in use

Confidential

Software Lead/Manager Contractor

• Ownership of their most demanding e-discovery and e-data processing proprietary software by way of implementing new features and bug fixes to legacy systems
• Provided design, development and implementation of critical business applications using N-tier architecture, patterns, third party controls, C , Ajax, workflow foundation
• Worked single-handedly on Job Automation of FTPing data files to the vendors on a monthly basis i.e. creating data extraction Oracle 10g stored procedures, writing complex Korn Shell scripts, sending automated audit/error emails
• Hands on approach including peer testing, code reviews, and leading by example in coding and responsiveness
• Familiar with agile and scrum development methodologies
• Organized and participated in team building activities
• Led the weekly Development Meetings and provided accurate and prompt status reports to upper management

Confidential

Manager, Development Technical

• Displayed analytical and problem solving skills in diagnosing and performance tuning SQL stored procedure for SLP Client reports to show an improvement of almost 3000 , e.g., brought down production execution time from previous 26 minutes to 55 seconds for an enormous client
• Lead technical designer for new development, enhancement and integration efforts using best practices such as Design Patterns Microsoft Application Blocks
• Collaborated with business owners, business analysts, project managers, IS support groups and third party vendors to elicit and document business requirements for enhancements and new projects, defining scope of work, estimates, and resource plans and carry forth implementation
• Authoring and debugging Stored Procedures, Triggers, Cursors and T-SQL coding with strong in-depth expertise in T-SQL debugger, Index Tuning, SQL Profiler, etc
• Successfully defined implemented technical solutions, specifically application architecture design, working with the group architect, using ASP.NET 2.0/3.5, JavaScript, AJAX, VB.net etc.
• Maintained strong relationships with internal customers Managed project technical design, directing developers in implementation of the product, providing troubleshooting assistance and conducting code reviews for T-SQL on SQL Server 2005/2008
• Prepared and maintained related project technical documentation

Confidential

Lead Analyst Developer

• Reviewed and tuned complex Oracle 10g objects, PL/SQL packages for performance leaks. Performance tuned Oracle queries using Explain Plans, SQL Trace, Parallel Query, Hints, shared pool, cache size, etc. to pin point time consuming SQLs and tuned them by creating indexes and forcing specific execution plans.
• Used AJAX model - XMLHttp Object extensively to transfer data between client and server.
• Worked single-handedly on Job Automation of FTPing data files to the vendors on a monthly basis i.e. creating data extraction Oracle 10g stored procedures, writing complex Korn Shell scripts and then scheduling them on Maestro, sending automated audit/error emails
• Created robust reusable ASP.NET / ADO.NET, XML, XHMTL components / functions which were used in other applications across the board at J J.
• Created various Documents, including Source to Target Data mapping Document, Data Migration Document and Class Diagrams using UML
• Maintained version controls using PVCS Polytron Version Control Software and Visual SourceSafe
• Led team meetings to resolve issues/conflicts and achieve target dates collaboratively

Confidential

Architect Developer

• Architected and developed a front end application tool to help Account Mangers manage a campaign to proactively notify patients about their prescription benefits / drug utilization reviews. Technologies leveraged were Microsoft ASP.NET, Visual Basic.NET, XML, Visual Studio 2005
• Developed the Teradata 6.1 data-mart and built a robust ETL process using SQL to read the Corporate Warehouse for claims information
• Constructed well-structured SQL queries to avert watch-dog complaints from MEDCO DBAs by applying best practices, choosing the best primary and secondary index for the tables
• Developed a demo version of the product to solicit and incorporate feedback from business owners into the design such that it meets customer needs
• Created extensive documentation to cater to MEDCO's CMI level 5 SDLC standards. These included the Technical System Design, Psuedo Code, Code Review Record, Test Conditions Template, and various design, development and testing Q Gates

Confidential

Solutions Architect

• Spearheaded the project's analysis, functional requirement gathering, feasibility and gap analysis, design, development and documentation using Microsoft Visio MS Word
• Created a complex yet generic report engine in PL/SQL on Oracle 9i using SQL PLUS 3.3, TOAD and SQL Navigator which read custom parameters for each report from the report master and delivered customized reports
• Prepared design documents reflecting data-flow, wrote program specifications and then converted the same into robust stored procedures, triggers, tables, views, and synonyms for proper object orientation of the above
• Dealt extensively with Materialized Views, Partitioned Tables, Query Re-write feature
• Studied the star-schema logical design of the database and wrote highly optimized report queries using analytical SQL such as ROLLUP, CUBE, GROUPING, CASE expressions, etc.
• Developed shell script programs in UNIX to run oracle packages for Control M and GECS schedulers
• Enhanced and Supported the ROSTER and ALIGNMENT systems, a sales force and territory maintenance application respectively, interfacing with the SFA application...
• Designed and implemented porting of ETL jobs from C to Oracle 9i
• Created business classes and service components using VB.NET, ASP.NET web services SOAP to implement new business rules/changes to the ROSTER application based on user requests
• Created test plans and conducted unit testing and regression testing during enhancement releases
• Studied and reviewed complex code and provided successful and timely fixes for production bugs and modularizing/re-writing the legacy script in the process, as necessary