PROFILE:

• Skilled programmer analyst with over ten years experience in the area of system design, development and implementation. Experienced with systems development life cycle methodologies.
• Building, integrating and delivering enterprise-wide database and data warehouse solutions using MS SQL technologies (SSIS and SSRS)
• Certified URS Associate Project Manager.
• Interpret business requirements and programming specifications to write database programs that solve business needs. Worked cohesively with the web development team to implement and support ecommerce sites.
• Server side responsibilities include: Designing, maintaining and fine tuning various RDMS like SQL server 2005/2000/7.0/6.5, Oracle 8.x/7.x and MS Access. Expert in developing Stored Procedures, User Defined Functions and Triggers. Played a key role in the data migration process and successfully migrated data from various data sources (SQL 2000 /6.5/Access/text files) to Oracle using BCP and fully automated DTS packages.
• Client side responsibilities include: Gathering specifications, analyzing data, creating business interface by providing a comprehensive and unified look. Translate business requirements and document functional specs.
• Deployment involvement consisted of application rollout, user training documentation and application maintenance.
• Leadership roles have included setting up standards and guidelines to ensure compliance with Sarbanes Oxley. Team player with strong communication and interpersonal skill.
• Strong analytical problem solving skills.
• Designed reports with Crystal report (9/8.5).
• Ability to handle multiple tasks and demonstrated initiative and adaptability of handling responsibilities independently as well as a proactive team member.

TECHNOLOGIES:

• SQL server 2005/2000/7/6.5,T-SQL,PL/SQL
• SSRS, SSIS and working knowledge of SSAS
• .Net technologies - ASP.Net(visual studio 2005),IIS(5.5),C#, ADO.Net and Web Services .
• Visual Basic 6/5,VB and Java Script, ADO, RDO, DAO
• Visual Source Safe IIS
• Crystal Reports 9/8.5
• MS Visio, WindowXP, 2000/ NT4

EXPERIENCE:

Senior Database Analyst March, 2008 to present
Confidential, Paramus NJ 07652

Confidential, Corporation is a fully integrated engineering, construction and technical service provider with the capabilities to support every stage of the project life cycle. The company offers a full range of program management; planning, design and engineering; systems engineering and technical assistance; construction and construction management; operations and maintenance; and decommissioning and closure services.

• Invoicing: Played a pivotal role in designing an automated online tool to generate invoices by tracking, recording and computing the employee hours with payment schedule for the given subcontractor. This tool is used to formalize the process for increased transparency. Performed verification and validation of data and provided proactive support.
• Concrete Quality Assurance Services (CQAS): As a senior database analyst was responsible for the database design and implementation of program standard operating procedures. Worked cohesively with the web developer to implement a system that identifies inspection activity, tracking material, equipment fabrication schedules, assigning inspectors and processing concrete test results. Additional features include review, storage and retrieval of inspection documentation and assist with the disposition of nonconformance issues. Products involve database design, web development and document management techniques.
• NYCDEP Permit Tracking Program involving the database and web application development of tracking and identifying Permit activities. Many reports have been published using SSRS and providing a user friendly interface that would enable upload and view files.

Environment: SQL Server 2005, Visual Studio 2005.
Complex reports and sub reports were created using MS SQL technologies (SSIS and SSRS)

Programmer Analyst May, 2000 to March 2008
Confidential, Mack Center drive, Paramus NJ 07652
Confidential, is an auto finance company, specializing in purchasing retail automobile installment sales contracts originated by franchised and select independent dealers. The Company has a serviced portfolio of more than $1.5 billion and it conducts business in about 35 states. AmeriCredit Corp. has now acquired LBAC from ACC Capital Holdings

• Single handedly worked on the Investor Reporting System, which is a monthly financial process. The payment application process is broken down based on the type of loan where all monetary transactions are split between Principal and Interest. The balance of the loan is then computed on an actuarial amortization schedule.
  Delinquency is calculated both on a modified and actual level.
• Worked on the financial/demographic module of the data migration process. Extracted and consolidated data from various data sources. Transformed data by performing dynamic calculations, data scrubbing (handle corrupt data, diagnose and repair), summarizing/transposing data and optimizing queries for data retrieval. Provided 24/7 support for Development, Testing and Production. Designed and implemented many Data Transformation Service packages and automated the process by scheduling it. Monitor performance during Beta testing phase.
• Worked in a full project cycle in developing the Custody Warehouse System with the following functionality. Ability to track file receipt for new loan Fundings. Track/Age/Recycle exceptions and generate trust receipts based on warehouse sales. Generate daily file release based on inventory and loan closure. Ability to produce many custodial reports together with printing of labels and allonges.
• Created many reports in Crystal and deployed them within the Loancenter application.
• Created web services for new loan boarding.

Environment: SQL Server 2005, 2000,Visual Studio 2003, Visual Basic 6.0

Confidential, Dec, 1992 to April 2000
Metropolitan Hospital 1901 1st Ave, NY NY 10029

• Responsible for accurate investigation of medical claims.
• Use of Interpro / Omnipro system which is a direct link with Medicare and BlueCross respectively.
• Developing user reports using Access.
• Carried out managerial directives, as outlined during internal desk audits.
• Demonstrated consistent ability to ensure the timely completion of work within a given timeframe.

EDUCATION:

• Masters -English Literature
• Bachelor of Science
• Computer training/Certificates
• URS Associate project manager certificate 2010
• Avtech Institute of Technology (C#,ADO.Net,ASP.Net)
• Solartech - Course 2373 (programming with Visual Basic .Net)
• Visual Basic

ACCOMPLISHMENTS:

• Corporate employee of the year 2006 (Long Beach)
• Corporate employee of the year 2005 (Long Beach)
• Employee of the month April 2003(Long Beach)
• Employee of the month June 2001(Long Beach)
• Outstanding Investigator 1994 through 2000 (Metropolitan)