EXPERIENCE SUMMARY

10 experienced SQL Developer/ .Net professional with over 15 years of IT development experience, including strong skills in database development, administration, and team leadership. He is proficient in SDLC System Development Life Cycle including design using tools such as Visio, UML and Smart Draw from Wireframe. He is extremely well versed in OOP and OOD methodologies for software development web based and desktop applications . He has worked in an agile environment, most recently with Cedar Fair where he worked alongside a certified Scrum Master. Vijay has excellent interpersonal and customer service skills.

SKILLS SUMMARY

Applications: Visual Studio .NET includes C , VB.NET, Crystal Report 8.0,9.0, Visual Basic, VB and java scripting, CSS, HTML, XML, JAVA, JDBC, EJB, C , IIS, ADO, ADO.NET, OLEDB, ADODB, DAO, ASP.NET, Maintain and admin IIS

Databases: MS SQL Server 7.0, 2000, 2005, 2008, 2010, 2012, 2014 SSIS, SSAS, SSRS, DTS , Red Gate, Oracle 8i, 9i, TOAD, Access, Fox Pro

Development Tools: Visual Studio 6.0, Visual Basic, C , Visual Interdev and Visual Studio .NET 2003, Visual and C . Wise Installation package, Install shield with J and J

Design tools: VISIO, UML Graphic manipulation with Adobe Photoshop

Platforms: Window 2000, XP, Unix

PROFESSIONAL EXPERIENCE

Confidential

Developer II

• Responsible for developing a set of standard software engineering processes utilized by agencies.
• Develop data standards, data exchange, XML data standard or data sharing model. Provide technical XML services to the management and support staff. Handle the queries regarding XML and troubleshoot problems.
• Work with oracle and PowerShell to insert delete and update the data working on the different phases of the life cycle like analysis, designing, development and maintenance and maintained operational documentation.
• Worked with Win and Web forms with help of Visual Studio 2012 to create software which link to SSRS web site and also utilize Win form to create same project.
• Built WIMs, task sequences, package and collection architecture, oracle and SQL queries and report
• Implemented PowerShell remoting and script execution and perform ETL in PowerShell script.
• Configured Powershell in DDMG, In-Three, DDMAIL and DDI domains for script execution and remoting
• Worked with ICD-9 and ICD-10 codding and create script to write data in CSV file with help of PowerShell
• Worked with Service Now to retrieve the assignment and worked with documentation to justify all the work done. Prior to Service Now Worked on FOGBUGS to perform same functionality.
• Worked with Federal mandated health care project to rewrite Oracle query and converted into XML file to load into HP FARM
• Worked with Confidential for Version control for retrieving assignment and there after commit changes to existing program.
• Worked with SSRS web site with backend of Oracle and sql server 2012
• Worked with Sql developer and Sql Server with DBMS activity mentioned below:
• Installation, Administration and Maintenance of SQL Server Instances.
• Setup Test, Dev, Staging and Production Environments
• Create Users and assign permissions based on the level of database access the user would need.
• Create Linked Servers to SQL Servers and other databases such as Oracle, Access, Informix etc.
• Design database Backup and Restoration Strategy. Once created the database Backups, monitor those backups are being performed regularly. From time to time recover the databases to a specific point of time, as per the requests. Setup High-Availability as part Disaster Recovery Strategy for the Databases. Troubleshoot various problems that arise in a day-to-day work and fix the issues.
• Configure Hardware requirement for Database server Win 2008 server
• Monitoring and Performance Tuning Physical Server Level, Database level and query tuning
• Documenting major changes to the SQL Servers.
• Apply Service Packs

Confidential

Software Engineer

• Responsible for converting C Applications to C
• Developed win Form in MFC environment.
• Worked on PLC with C , AC drive, DC Drive and Data Acquisition
• Main purpose to built PLC machine control computer to read digital and analog inputs from various sensors From ADAPT Computer or Server control in Aerospace industries, Steel industries
• Created Dll for the project to interact with Window 2000, XP and latest one with window 7 on 32 and 64 bit application on C .NET version 4.0
• Worked on ADO.net with Access database to connect front end of C which bring log in information and product registration tables
• Utilized Install Pro to make package of WIN and MFC project

Environment: C , ADO.net, Access, C , Install Pro, Agile, MVC Practice and Pattern

Confidential

Senior Programmer Analyst/SQL Report Writer

• Developed web based Reporting SSRS site to support HR, Finance, and operation department
• Developed SQL Reports utilizing SSRS, MS Visual Studio and .NET framework 2.0
• Served as developer for the SSIS project
• Developed DTS/SSIS packages, created Link Servers, and utilized T-SQL
• Performed upgrade from SQL Server 2000 to SQL Server 2005
• Performed back-ups, restores, scheduling, and maintenance and disaster recovery planning for SQL Server
• Create Database schema with UML Visio, Wire Frame
• Involved in performance tuning and indexes Cluster and Non Clustered
• Worked on Win and Web forms with help of C in .NET Framework 2.0
• Administered SQL Server including back up / recovery, creation of user, indexing Cluster and Non Cluster for normalization
• Worked with Red Gate to perform: Link server, Source Control, Data Compare, SQL Multi Script
• Performed role as a security specialist in JD Edwards Enterprise One 8.12. ERP Project
• Provided 24/7 coverage on-site and off-side of SQL 2005 databases
• Performed security updates And patches for all user types
• Designed diagrams for all the databases
• Developed plans and managed and executed complex technical efforts
• Developed stored procedures, views, and triggers
• Performed database storage migration
• Developed documentation for all databases

Environment: SSRS, C , Visio, SQL Server, Red Gate, UML, T-SQL, SSIS, DTS

Confidential

SQL DBA/Sr.NET Developer/Lead Programmer Analyst

• Developed web applications with Visual Studio 6.0 Visual Interdev, Visual Basic, ASP and SQL Server 2000, 2003, 2005
• Maintained and recommended changes in existing web application utilizing Visual Basic, Visual Interdev, SQL Server 2000, Active Reports, COM and DB2 QMF
• Interfaced with JDE ERP solution to auto creates the product and non-product order service order in a web based application called Service Auto maintenance SAM
• Created, altered and deleted tables, views and store procedures in SQL Server 2000 and AS400 which eventually connects to JDE ERP Solution
• Created flat files from Access and SQL Server 2000 database tables as needed
• Created DTS packages, SSIS, SSRS
• Worked efficiently in and around the ADO, DAO and RDO
• Documented all transactions and weekly status reports with MS Office Suite
• Created Exe files with Visual Basic 6.0 and Active Report to generate the reports

Confidential

Senior DB2 and .NET Developer/Lead Programmer Analyst

• Worked as a DB2 developer in Confidential subsidiary named Antares Solutions. The application consisted of a medical coverage, b dental coverage with capability to edit, delete and update the information of doctor and patient customer as required
• Rewrote the code for exporting the data in XLS, Microsoft Word and Crystal Report to allow the information to save or open
• Rewrote the user control in corporate with twelve different web pages to elevate from testing stage to development to QA environment to deploy in production

Confidential

Senior .NET developer/Senior Consultant, Programmer/Analyst

• Worked as a SQL developer on an insurance application module includes Auto, RV and Marine, with the capability to edit, remove and update the information
• Migrated database with DTS package. Administered database by performing duties such as 1 database tuning, 2 backups and recovery, 3 database design, 4 creation of entity relationship, 5 creation of tables, view, store procedure and indexes
• Developed the Window and Web based application with help of Visual Studio.NET includes C with Microsoft SQL server 2000 database to incorporate with ADO.NET creation of Store Procedure, Tables and Triggers and ASP.NET
• Utilized UML to create database schema
• Performed the integration and unit test to verify any errors and conclude at software usability evaluations by perform following methods 1 user -based, 2 expert-based, 3 model-based
• Migrated Smalltalk software application from IBM mainframe to Microsoft arena for editing and retrieving of insurance policy in reference to Customers, Vehicles with help of three tire application and taking care of business layer includes rules and reference used in IBM based application data access layer, security layer, document all the changes
• Created SQL script to run a trace and run a UNIT test for the proper retrieval of data, importing the data from Excel .XLS into SQL database DTS package
• Performed duties as SQL DBA for entire projects. This included creation of table, store procedure synonyms, trigger, performance tuning, backups, replication using OLAP, reporting, DTS package etc.

Confidential

Senior .NET developer/Senior MS SQL Server 2000 Developer

• Developed Window and Web based application. Named info tracking project with help of Visual Studio.NET and its language such as VB.NET, C , ASP.NET IIS 5.0 and 6.0 , ADO.NET database from MSSQL 2000 and Oracle 8i with creation of table, view, store procedure, OLEDB Allow oracle or other database to connect to front end of C or VB.NET , with tools like data grid, dropdown list, List box, Command button, User Control, Validation controls etc., Wise Installshield was applied on Window based desktop application. Java and VB scripting involved in Wise Installation
• Migrated software from VB 6.0 to .NET for technical department for intranet and window application. Involved in development of intranet web site to capture information for the engineering department to view, edit, update and delete the information. Connect from database with store procedure, view, tables with creation of dataset, connection string and data connection. Performed import and export data from Excel spreadsheet to MS SQL server. Administrated IIS v 6.0 and VSS to capture or save the entire project. Involved in designing database with help of VISIO as well as Smart Draw from Wire Frame designing tool to create schema, web design, and different presentation for project . Involved in web services like XML, XSL, and XSLT
• Created tables, stored procedure synonyms, triggers, views and database optimization, performance monitoring and tuning, database maintenance, backup/recovery, data consistence check, security administration and data cleanse. Furthermore, responsible to design and implement enterprise databases etc. act and perform duty as MS DBA and also worked with cluster management
• Developed email form to send feedback to engineering department with help of SMTP server and VB script and eleven web pages with developing report READ ONLY with Crystal Report
• Created user control to include ten web pages and debug the application for the smooth operation of the software includes database, compilation errors etc . Performed the integration and unit test to verify any errors and conclude at software usability evaluations by perform following methods 1 user -based, 2 expert-based, 3 model based

Confidential

Senior .NET developer/Senior SQL Developer/DBA Senior Consultant and Team Lead/System Admin/Programmer Analyst

• Web and window based application developer with migrating different software from VB 6.0 to VB.NET and C and performed duty as MS SQL DBA with 7.0/ 2000. Also acted as project administrator
• Developed web based and window based desktop application with Visual Studio 6.0 Visual Basic 6.0 and C and migrated the project in January 2002 into Visual Basic.NET, as well as C forms and project with Oracle and MS SQL Server 7.0/2000 ODBC and afterward wrote and managed multiple reports into Crystal Report 7.0 to 9i and applied it on the internet with the help of Crystal enterprise and Seagate Info. Experience building analysis and posting it to the internet as add on to reports generated from ORACLE, MS SQL SERVER and ACCESS
• Involved in PowerPoint presentation as well as Visio diagram to provide meeting agenda, web page design and other clip art to mention in slide show
• Developed web site and client server project for ecological services dealing in consulting business
• Applied Visual Interdev for testing the ODBC for Oracle and MS SQL 7.0 Includes creation of tables, view, Stored Procedures and Synonyms , perform Database Performance Tuning, SQL PLUS, SQL LOADER, SQL worksheet. Administer Database but NOT DBA Access into window and web application, Application of Visio for Database connectivity Diagram and Configuration of chain of command. Project Design includes performing relational database design and conversion or transfer Or DTS package Import and Export Database and its files and folders from Documented to Oracle 8i. and Utilized SQL Loader to perform Data Transfer. Visio was designing tool to implement database structure and also web designing.
• Developed and maintained web and window based application to synchronize in handheld Device like Palm Pilot to eliminate carrying laptop application includes 8 forms connected to SQL Server 2000 and blend with Crystal report 8.0 to 9.0 Allow the project Manager to obtain all the information regarding future Project ,Employees, other requirement Designed MS SQL server and Oracle to keep in mind following aspect of Info Tracking project : 1 Creation of tables, views, store procedure, triggers, Index, 2 backups/ recovery plans, 2 data consistence check, security administration, and data cleanse. Furthermore, responsible to design and implement enterprise databases.
• Designed web, database ER diagram, Presentation of project in format of PPT with Smart Draw from wire frame , Visio or UML

Confidential

Oracle and SQL Developer and DBA/Project Lead and Senior Consultant and Programmer/Analyst

• Worked as a Team Lead as well as Sr. Developer For Confidential Project Investment Banking for Confidential and window Includes Architect, designing, Implementation as well as complete lifecycle software applying various technology like C , Visual Basic, DCOM, COM, COM , IIS, MTS, Visual Interdev and Microsoft PowerPoint Macros, Java, EJB, Apache Tomcat which includes Confidential is a web based Pitch Book Development and collaboration system for Investment Banking Division of Confidential. This enables the bankers to create and manage the pitch book creation and sharing it across their global divisions. This solution supports the entire standard document management functionalities. 0n addition, this system also comprises of a job track system that implements a workflow for publishing services. This is a global system that is deployed at multiple locations i.e. Confidential. It is a J2EE compliant solution
• Performed In-house projects in Window based application by applying Technology like Visual Basic/Oracle/ODBC/Crystal Reports/Visual Interdev company information management application to track details about the company's clients, employees and Employee training needs. Developed, designed, coded, documented and tested the software includes QA testing Worked on Updating company's web site with help of IIS , as well as HTML, Front Page and MTS technology, XML Worked in OOPS and OOD environment to enhance the performance in IT department
• Applied Visual Interdev for testing the ODBC for Oracle and MS SQL 7.0 Includes Creation of tables, view, Store Procedure and Synonyms , Access into web application,
• Application of UML and Visio for Database connectivity Diagram and Configuration of chain of command and Project Design includes relational database and convert or transfer Import and Export Database and its files and folders from Documentum to Oracle 8i.
• Prepared Documentation to support the software and Mentoring junior staff in Java technology for new project as well as in Visual Basic and Oracle ODBC ADODB, ADO, and DAO and Crystal Report.
• Administered database MS SQL7.0/2000 and ORACLE 8i and IIS for proper operations with keep in mind the security and helpful to HELPDESK for controlling the entire USER interaction for login info with window and all the application related to project.
• Managed the team of 15 consultants for various project within organization from Project Scope to Maintenance includes Scope, Analysis/Software Requirements, Design, Development, Testing: 1 Unit Testing and 2 Integration Testing, Training, Documentation, Pilot, Deployment, Post Implementation Review
• Developed computer system specification for proposed solution to information system problem according to SDLC for following project. Includes Project planning, feasibility study, Systems analysis, requirements definition, Systems design, Implementation, Integration and testing, Acceptance, installation, deployment, Maintenance, Documentation