SUMMARY

• 10+ years of IT experience in supporting Client Server applications using Java, C, Visual - Basic on Windows Platform.
• Experience working in DB2, Oracle Clinical, SQL Server 2000 and 2005 and Access databases and in healthcare industry.
• Experience in supporting Share Point web applications, monitor and maintain their performance using Moss2007 and Microsoft office 2007.
• Experience in analyzing business requirements and demonstrated effective solutions, acted as Business Analyst in some projects.
• Strong SSRS, SSIS, DTS, ETL and Quality Assurance methods as Systems Engineer.
• Strong organizational and communication skills, analytical and problem solving skills
• Strong leadership qualities, Customer contact and community outreach skills.
• Experience in different industries like health care, financial and banking industry.
• Experience in Testing with Rational Clear Quest, HPSM, JIRA etc for bug tracking and problem solving, incident management etc.
• Prioritize and work in fast paced work environment with tight deadlines in production support environment and Agile methodology.
• Experience working in Visual Café, Clear Case and Microsoft Visual Studio 6.0.
• Trained in MOSS 2007 (SharePoint), Oracle, SQL Server, DB2, Teradata, Metadata, SQL*Plus, PL/SQL, TSQL, Stored Procedures, Rapid SQL, Java 2.0, XML, VBA, VB5.0, .Net Framework 3.5, Visio, MS Project, Biztalk Server, CRM Dynamics, Autosys, TWD,
• Multi Lingual and excellent communication skills.

Professional Experience

Confidential

Analytics Consultant

Responsibilities:

• Worked in Confidential, experience with Banking, Financial and Mortgage industry.Performed Risk Analysis and dealing with Audit issues in Bankruptcy.
• Collaborated with different teams, interaction with clients to develop solutions and manage the project,budget and resources.
• Extensive experience in reporting tools Tableau, SSAS, SSIS, ETL, SSRS, Analytical Reports, creating Subscriptions and exporting them to Sharepoint site.
• Experience with advanced level Excel, Flat file, Word, Power point demonstarting high level expertise in Mathematics, design and Analytics.
• SSRS Reporting experience, Analytics and Statistics experience in Bankruptcy and Home Equity areas of business. Gave Presentations to Leadership and created statistical and risk based reports.
• As Project Manager, have the ability to make timely and independent judgment and decisions while working in a fast-paced, results-driven and also Agile Environment.
• Maintenance and Production Support of Bankruptcy Applications. Worked extensively on ticketing system, assign and followup on tickets, make sure the ticket is completed on time without any issues, tracking defects and incident management and resolution in the tracking system JIRA.
• Knowledge and understanding of data flow diagrams, data transformation and database packages using SSIS tools. Created various packages and scheduled jobs in Home Equity.
• Relational database experience in SQL Server as well as DB2 and Oracle. Used SQL stored procedures, Rapid Sql, Visual Studio .
• Ability to work across multiple lines of business leading large scale initiatives and large data and metadata. Experience with all phases of SDLC.
• Review peers code and make recommendations on improvising code and efficiency of the program. Managed and mentored other developers.

Confidential

Sr Apps Programmer

Responsibilities:

• Extensive experience with Visual Studio, ASP.Net, VB, C#, Sql Server database
• Creating SSIS packages and creating Jobs
• Creating SSRS Reports, sharepoint dashboards and create subscriptions
• On Shore and Offshore model of working and collaborate with multiple teams.
• Extensive experience in production support and ability to troubleshoot, root cause analysis, debugging code and fixing issues
• Development of C# code and ASP.Net applications
• Project management and assigning duties and guiding junior developers.
• Worked with system testing, writing test cases and interact with Customers to provide solutions they need and for user testing.

Confidential

Programmer Analyst

Responsibilities:

• Extensive experience in reporting tools, SSRS, Analytical Reports, created Subscriptions and exported them to Sharepoint site.
• Experience with Excel advanced level and expertise in Mathematics.
• Experience using various tools like TOAD, SSAS etc
• Analyzed and Created SSIS packages to automate manual billing cycles for Flood team.
• Integrated Billing functions that needed technology refresh, allowing administrators to view the rules as needed.
• Lead Change management and compliance rules articulation per project guidelines.
• Communication with business users, vendors, operations team as needed.
• Worked with business users and created requirement documents, designs and flowcharts.
• Lead projects, resource planning and estimation and ensure they are completed within timelines.
• Extensive experience with Visual Studio, ASP.Net, VB, C#, Sql Server database
• Created Invoice templates and did ongoing maintenance for operations team.
• Participated in BCP, Disaster Recovery and Audit programs.
• Maintenance of SCOM - System Center Operations Manager on a daily basis, finding the issues on different servers and resolving them.
• Supported Biztalk application (Flood Insurance) and CRM Dynamics Call Center application.
• Wrote test scripts and test cases, did manual testing for the windows and web applications.

Confidential

Systems Engineer

Responsibilities:

• Developed schedules and plans to set project deadlines, worked in all phases of the project lifecycle including testing and implementation phases.
• Participated in the analysis, code review, testing and documentation of various versions and releases of different applications using waterfall and iterative methodologies.
• Supported Rush-3 step refinancing project as a systems engineer. Fixing the problems or issues that the users have with loans.
• Writing SQL scripts and stored procedures to do database fixes.
• Doing uploads, manual uploads, sending loans to main frame, communication with LIS.
• Resolving eligibility issues, working on HARP loans, making HERA/HOEPA Compliance changes.

Confidential

Operations Analyst

Responsibilities:

• Developed and supported HealthEZ, America's PPO and TPA web applications.
• Developed web pages and web parts in a website using C#.net based on the requirements and designed the presentation layer using AJAX.
• Experience in trouble shooting and resolving problems in the financial system of the company which is a Windows based application used by the internal users.
• Database maintenance including writing queries, scripts and stored procedures using T-Sql, Query Analyzer and SQL Server Management studio.
• Provided excellent customer service to the application users depending on the helpdesk tickets, prioritizing and fixing issues on time.
• Participated in the development and discussion meetings in IT team to coordinate next steps in the SDLC of the projects.
• Developed schedules and plans to set project deadlines, worked in all phases of the project lifecycle including testing and implementation phases.
• Participated in the analysis, code review, testing and documentation of various versions and releases of different applications using waterfall, iterative and Agile methodologies.

Environment: Windows XP, Windows Server 2003, SQL Server 2005,SSIS, SSRS, MOSS2007,Visual Source Safe, Visual Studio.Net, ASP.Net, C# and VB.Net, WSS 3.0.

Confidential

Programmer/Analyst- Production Support

Responsibilities:

• Support Compass and IMS Application in VB.Net and SQL Server database, providing first level service by troubleshooting, root cause analysis and problem resolution.
• Extensive use of XML data files to send data from one application to other.
• Supporting and enhancing online inventory and product description website.
• Web development with ASP.Net and C# for order tracking tool CHRWOnline.
• Used DTS and SQL Server management studio to perform T-SQL operations on data, writing stored procedures, DML statements and scripts.
• Worked within IT support group to handle production issues, to escalate high priority tickets, to schedule software updates and to perform disaster recovery tests.
• Closely worked with development team, BA's, application trainers and business users to communicate business requirements, incidents and issues.
• Perform incident and problem resolution using tools like ITCM, ITSM, Citrix Metaframe and CHRSMA and provide excellent customer service by documenting and communicating issues and their solutions to the users.
• Worked as On-Call support programmer which involved working in different shifts, timings.

Environment: Windows XP, VB 6.0, SQL Server 2000/2005, SSIS, SSRS, T-SQL, Araxis Merge, MOSS2007,Visual Source Safe, Visual Studio.Net, ASP.Net, C# and VB.Net languages.

Confidential

Database Developer

Responsibilities:

• Maintenance of access databases like BDDB and USOC.
• Enhance VBA applications viz., Sales Proposal generator and Neustar.
• Migrated Global Crossing Inc. application from Microsoft Access to SQL Server and developed frontend with VB.Net.
• Designed and deployed USOC database application. It is used by more than 100 users in the Provisioning department.
• Created new stored procedures (PL/SQL procedures) to handle the automation of tasks. Created new views for the database export process.
• Worked on BCP (bulk copy program) to export the data to a text file.
• Designed and deployed PSON database application with C# and Java.
• Doing the archive process for the Cut database.
• Wrote software design specifications, data models and workflow documents for some of the new projects.

Environment: Oracle 8i, MS Access, PL/SQL, SQL Plus, Forms 5.0, Reports 3.0, VBA, VB 6.0, Crystal 9,SQL Server 2000, T-SQL, Visio, Visual Slick Edit, Java on Eclipse and NetBeans, Visual Source Safe, Visual Studio.Net, ASP.Net on Web Matrix platform with C# and VB.Net languages.

Confidential

Clinical Applications Developer (CAD)

Responsibilities:

• Programming of edit checks based on the Data Validation Plan specifications provided by the data managers and create reports.
• Developed procedures to identify the bad records and Patient details that did not meet the study specifications, from the data received from the sites.
• Creating tables and views to meet the requirements of the data management group for analysis and summary reports.
• Created Edit checks "Global procedures" (program level) & "Local procedures" (protocol level) to meet the validations of CRF forms.
• Programming using RPLSQL, a macro language.
• Using the TOAD extensively for database checks and SQL procedures.
• Running the edit checks using the eRT runtime system and checking the correctness of the consistency checks.

Environment: Oracle 8i, eDataManagement 3.2, RPL/SQL, Forms 5.0, Reports 3.0, and PL/SQL, TOAD, WinNT.

Confidential

Software Developer

Responsibilities

• Work with TC Reliance Reservation Manager software for video services.
• Enchance the Graphical User Interface using Applets in various modules.
• Create custom reports for retrieving the information requested by the user.
• Create SQL Queries for back end testing and worked with SQL Worksheet.
• Extensively use Rational Clear Quest for Bug tracking and resolving bugs.
• Use Visual Cafe and Visual Source safe and Visual Inter Dev 6.0.
• Involved in status meetings for discussing technical problems and resolving them.

Environment: JDK 1.1, VB 6.0, Java Web Sphere, VBScript, Applets, ASP, XML, Oracle 8.0, Clear Case, Rational Clear Quest, Microsoft Visual Studio 6.0 and Windows NT/2000.