Consultant Resume
New Jersey, NJ
SUMMARY
Have 14 years of experience in the Information Technology industry. I have worked as a Programmer/Analyst in the banking, healthcare, manufacturing, IT services and IT products industries. Prior positions have included the following job functions:
- Web Design
- Database Development
- Web Development
- E-Commerce
- System Development
- Development
- Testing
- Use Case Writing
- Cognos Report Administration
- CrystalReportAdmin& Development
- BusinessObjectAdmin& Development
- Oracle Express (Apex)
Chronology of Experience
Confidential, Sep 2010 to Present
Industry: Confidential,
Position: Sr Consultant
Environment: Windows XP
Tools: SQL server2008, Access, SSIS, SSRS, Asp and vb6 and Visual Studio 2010
- Working as a Lead for Run Team.
- Responsible for the Creating the SQL reports and SSIS Packages.
- Working on different Eligibility loader using Access and converting them to SSIS Packages.
- Working on different modules of new health Check management projects using ASP.net, VB.net JavaScript and SQL server.
- Responsible for production support.
Confidential, Oct 2008 to Sep 2010
Industry: Confidential,
Position: Report Developer
Environment: Windows XP
Tools: Cache Database, Business Objects XI, Crystal Repots 2008.
- Responsible for the Creating the Crystal report, Business Objects Webi and Desktop reports.
- Continuously interacted with other project, team, technical and business leaders, and with users to clarify requirements, identify and resolve problems, and ensure that user requirements are met.
- Design and modification of new and existing Universe.
- Creating the documents for each report including the formats, the database fields used any views or stored procedure used.
- Working with the Cache vendor to modify the database for the reporting needs.
- Tuning of SQL procedures.
- Created ad-hoc queries and reports.
Industry: Confidential,
Position: Application Developer
Environment: MS Windows 2000
Tools: Visual Studio. NET, ASP.NET, Visio, SQL Server 2005, SQL Reporting,
Sybase, EC MAP, Win Batch Scripting.
- Responsible for the management of B2B Information System instance.
- Work with internal customers to define requirements for EDI 834/835/837 transaction sets.
- Work with external trading partners to develop, test, and implement new transaction sets in accordance with X12 and company\'s standards.
- Working and maintaining different .net applications.
- Working on Reporting Project, using SQL reporting.
- Created the functions, procedures in SQL.
- Created Console applications using Visual Studio using C# and VB. Net
- Did data mapping using Ecmaping tools and SSIS.
- Created Win batch scripting for job schedules.
- Involved in creating data migration from Access, Excel and Sybase to SQL server
Confidential, Apr 2006 to Oct 2008
Industry: Confidential,
Position: Application Developer
Environment: MS Windows 2000
Tools: Visual Studio. NET, ASP.NET, ADO.NET, CVS, Visio, SQL Server 2000, Oracle 10g, Business Objects XI, Cognos 8.1, Oracle Apex, Quality center 9.2
- Led a team of Developers in different projects using Business Objects, ASP.net and supporting some applications.
- Worked in GTI Application Development and CHF Marketing departments.
- Web enabled the Word program without changing the previous functionality and added new
features with ASP.NET as front end and Oracle as back end.
- Created the Data Model, stored procedures, dynamic SQL for search engine, Online help and
test scripts.
- Working and maintaining different .net applications.
- Working on Centralized Reporting Project, using Oracle 10g, Business Objects XI and Crystal Reports.
- Worked in the Employee dataware House project and created different job and data transfers.
- Worked as System Admin, created the complex reports and stored procedure and function and business views.
- Created ad-hoc quires for reports.
- Helped in configuring Cognos and Business Objects servers.
- Converted different types of data to SQL server.
- Web enabled the Access program without changing the previous functionality and added new features with ASP.NET as front end and SQL server as back end.
- I have completed two Work Management System projects using Oracle Express. (Apex / HTMLDB).
- Used mercury Quality Center for bug tracking and fixing.
- Trained Report users on customizing and creating reports using Crystal Reports v 11
- Have experience with Onshore Offshore development model.
Confidential,Aug 2005 to 2006
Industry: Confidential,
Position: Programmer/Analyst
Environment: MS Windows 2000
Tools: Visual Studio. NET, ASP.NET, ADO.NET, Visual SourceSafe, Visio, SQL Server 2000 and Crystal Reports.
- Web enabled the Excel program using ASP.NET as front end and SQL Server as back end.
- Developed Web pages using ASP.NET, Visual Basic NET and used VSS for source control.
- Designed the Data Model for the project, wrote Use Cases, stored procedures, dynamic SQL for search engine.
- Used Crystal Reports for reporting. Provided assistance through completion of tasks to team members.
- Team with technical and business leadership, business users and subject matter experts to ensure the information delivery technical solution meets business requirements.
Confidential, March 2000 to 2005
Industry: Confidential,
Position: Programmer/Analyst
Environment: MS Windows
Tools: Oracle 9i, Cognos Report net 1.1, Crystal Reports
- Worked as a Business Intelligence and led a team of 7 Report developers.
- Set up Cognos and BO Servers and worked as an Administrator for them.
- Attended the JAD sessions to get the requirements and worked closely with the system applications team, data architects, business analysts, and system administrators.
- Worked directly with customers on project planning, execution, and issue resolution.
- Helped in setting up of Cognos Framework Manager, Query and Report Studio.
- Involved with Data Migration, Data Conversion and testing.
- Worked closely with vendors on technical Issues.
Industry: Confidential,
Position: Programmer/Analyst
Environment: MS Windows 2000
Tools: Visual SourceSafe, Visio, SQL Server 2000, Crystal Reports, Visual Basic,
XML
- Created new Reports using Crystal Reports and the Stored Procedures required for the report.
- Worked as Crystal Back up Administrator.
- Created the new extracts and their procedures as per the requirements.
- Debugged the Visual Basic code for the Transaction and Business Rules.
- Repaired non-working application.
- Tuned the database stored procedures.
Industry: Confidential,
Position: Programmer/Analyst
Environment: MS Windows 2000
Tools: Visual Studio. NET, ASP.NET, ADO.NET, Visual SourceSafe, Visio, SQL
Server 2003, Active PDF
- Created the Admin. Pages and implemented the changes required from the previous WebPages
using ASP.NET as front end and SQL Server as back end.
- Changed the Data Model for the new requirements and transferred the existing data to the new
database.
- Implemented the single sign on and converted the word Documents to PDF format with the
option of multiple printing.
- Transferred the web pages from windows 2000 server to 2003 server.
Industry: Confidential,
Position: Programmer/Analyst
Environment: MS Windows 2000
Tools: Visual Studio. NET, ASP.NET, ADO.NET, Visual SourceSafe, Visio, SQL Server 2000
- Web enabled the present Access program without changing the previous functionality and added
new features with ASP.NET as front end and SQL Server as back end.
- Designed and developed the Web pages using ASP.NET and Visual Basic.NET in a team environment.
- Created the Data Model for a project, and stored procedures, dynamic SQL for search engine and UAT/ ISR script.
- Created pages, which invoke a MS Word document with data from the database.
- Converted the HTML reports to Excel format for saving locally and sending as an attachment to
Email.
- Used data layer, business layer and presentation layer.
Industry: Confidential,
Position: Programmer/Analyst
Environment: PC/LAN, MS Windows 2000
Tools: Visual Studio. NET, ASP.NET, Visual SourceSafe, Visio, JAVA Script, SQL Server 2000
- Designed and developed Web pages using ASP.NET and Visual Basic. NET.
- Designed system architecture in Visio System. Developed a 3-tier web application containing presentation, generation, business and data layers.
- Performed setup of Visual SourceSafe project for version control during development.
- Developed .NET peer group site that helps developers interact with each other and post
questions they have in ASP.NET and VB.NET. Created screens and code behind for Login,
file uploads and down load and tree view control to display the XML data.
- Used XML and XSLT for the display of tree view control.
- Tested and documented the application modules.
Industry: Confidential,
Position: Programmer/Analyst
Environment: PC/LAN, MS Windows XP
Tools: XML, ASP.NET, VB.NET, HTML, JAVA Script, HTML, Visual Studio.NET, SQL Server 2000, IIS
- Worked on an Intranet web development project for storing the resumes of consultants,
providing searches by skill set or by resume finding the available resources.
- Designed the application to allow for upload of resumes and skill sets.
- Created the Data model and written the stored procedures and set up the user Roles.
Industry: Confidential,
Position: Programmer/Analyst
Environment: MS Windows 2000 Server
Tools: Visual Basic 6.0, SQL Server 2000, HTML, VS Script, JAVA Script, Visual Interdev 6.0, Active Server Pages 3.0, DHTML, XML / XSL, COM, Crystal Report 8.5
- Wrote the requirements for a project to merge two legacy (DOS/FoxPro) healthcare systems
into a single web based medical management product.
- Took the approach to deliver an effective solution, by merging the data stores of the legacy systems and web enabling the same using Microsoft\'s DNA architecture.
- Analyzed the legacy systems to web enable them. Supported the DBA in regular work in setting up of SQL server, creating the user roles, writing the procedures and data conversion.
- Designed more than 50 screen layouts and the workflow pertaining to Search, Case Management, Case Participant, Event, Note, Document modules, Member and Dependant.
- Implemented and unit tested 10+ complex screens using ASP, XML, XSL, JAVA Script and Business layer Components.
- Designed, developed, and unit tested 200+ methods in business layer using VB 6.0, COM+ and MS XML3.0 and their associated stored procedures using SQL/TSQL.
- Participated in trouble shooting the application during alpha and beta installation.
- Provided technical support during user acceptance testing (UAT).
- Worked as Administrator for Crystal Server and fine-tuned the SQL procedures for the reports.
March 1999 to September 1999
Industry: Confidential,
Position: Programmer/Analyst
Environment: MS Windows NT
Tools: Active Server Pages 2.0, VB Script, Visual Interdev 6.0, and
MS SQL Server 7.0, IIS 4.0
- Created web pages to keep track of details of resources, projects, sub-contractors, etc.
- Maintained details about resources that could be placed at various locations and their current
availability status. Created a query system to search by skill set, location and availability status of resources and then return the most appropriate available resource.
- Upgraded the entire resume database from Access to SQL Server 6.5.
- Created numerous reports such as summarization of resources in a particular skill set,
demographic information on resources, billing rates, location-wise billing and other summary
Reports.
- Coded major screens and reports using Crystal reports.
- Designed and developed ASP pages.
- Managed data in the database, and performed unit and integration testing.
- Used ADO and ASP to access database and present query responses.
Education
Papers in Business Computing
Bachelor of Science Degree - Electrical Engineering