We provide IT Staff Augmentation Services!

Senior Systems Integrator/analyst Resume

0/5 (Submit Your Rating)

Phoenix, AZ

SUMMARY

  • Over 11 years of development experience in the designing, developing and maintaining Client - Server applications, Web based applications and .Net applications as a Software Developer and Internet Application Developer.
  • Experience in the complete life cycle of project development (SDLC), system analysis, design, development, testing, development and end user training.
  • Over 9 years of experience with application design and requirements analysis, proficiency in Object Oriented programming using C#, .Net 2.0, 3.0, and 3.5.
  • Experience in graphic/UI design for the web, ASP.Net, VB.Net, C#, HTML, DHTML, AJAX,, XML, XSLT and XPATH, HTTP Module, Handler, CSS, JavaScript development skills, cross browser compatibility issues and Microsoft design pattern and practices.
  • Extensive experience in developing and maintaining applications using Visual Basic 6.0/5.0 as front-ends, Oracle, MS Access 97/2000/, SQL Server 7.0/2000/2005 as back-ends, Crystal Reports for reporting on Windows95/98/2000/XP, NT, 4.0/3.51.
  • Proficient with UML for specifying, visualizing, constructing, and documenting the artifacts of software systems.
  • Strong understanding of Object Oriented Programming OOP and Object Oriented Analysis and Design OOAD concepts.
  • Very strong in database objects and database programming. Strong expertise and confidence to write effective SQL queries, stored procedure, extended stored procedures and triggers.
  • Experienced in various databases like MS SQL Server 2000/2005, Oracle 8i/9i/10g, and MS Access databases along with the querying tools like TOAD and SQL Query Analyzer.
  • Experience in using SQL Server 2005/08 Reporting Services, SSAS, SSIS and Crystal Reports.
  • Knowledge on .Net Framework 3.0 and 3.5 Windows Workflow Foundation (WF), Windows Communication Foundation (WCF), and Windows Presentation Foundation (WPF).
  • Experienced in ADO.Net/DAO/ADO/RDO, ODBC, and OLE Automation.
  • Strong PL/SQL, T-SQL skills. Sound knowledge of Stored Procedures, Triggers and Functions.
  • Extensively used XML, XSD, XSTL, XPATH, DHTML, COM, DCOM, MTS, COM+ and ActiveX technologies.
  • Worked on development and maintenance-enhancement projects covering all the steps of software life cycle and Strong understanding of database concepts is required.
  • Involved with client requirements gathering - tasks requiring meeting with functional system users to document business processes and define system functionality.
  • Flexible and versatile to adapt to any new environment and work on any project.
  • Highly motivated, possesses quick grasping power and very good analytical and technical skills.

TECHNICAL SKILLS

Operating System: MS-Dos, Windows 95/ 98/2000/XP/Server2003, Windows NT 4.0 /3.51 & UNIX

Database: SQL Server 2000/7.0/2005 , Oracle8i, 9i, MS-Access 97/2000/2003

GUI: Developer/2000 (Forms 4.5/3.0,2.3 Reports 6/2.5/2.0 and Graphics 2.5). Visual Basic 6.0/5.0

Web Technologies: HTML, DHTML, XML, XPATH, ASP, ADO.Net, and ASP.Net

Languages: C, C++, C#, VB.Net, AJAX, Java Script, VB Script, SQL, PL/SQL, T-SQL

Software Packages: MS-Office 97/2000/

Middle Ware: COM, MTS, COM+, Web Services

Web Server: Microsoft IIS

Tools: and Utilities: Visual studio 2002/2003/2005 , .Net framework 1.0/1.1/2.0/3.0/3.5 , AJAX Control Toolkit, AUTO It, Turbo XML, Toad, Crystal Reports 8.5, UML, Visio, VSS 6.0/2005

Version Control: Microsoft Visual Source Safe and Rational ClearCase

Other Skills: Crystal Reports

PROFESSIONAL EXPERIENCE

Confidential, Phoenix, AZ

Senior Systems Integrator/Analyst

Responsibilities:

  • Active participation in the architect, design, then development of both Web and desktop applications, n-Tier server applications and web services/applications using .NET C#, .NET VB, and SQL 2005 & 2008.
  • An Integration Services (SSIS) package was scheduled to daily load data from operational database.
  • Wrote and integrated custom Reporting Services (SSRS) reports with SharePoint. The reports’ logic was encapsulated within stored procedures to facilitate changing requirements.
  • A security layer was integrated with the reports to meet requirements. Performance tuned the application by optimizing the queries. The data was displayed on a SharePoint website.

Environment: C#, VB.Net, ADO.Net, Visio, Win-forms, SharePoint, ASP.Net, JavaScript, AJAX, Visual Studio.Net 2008, SQL Server 2005, Oracle11g, VB 6.0, Rapid SQL 7.5.5, Windows XP Professional, IBM Rational Clear Case, Team Foundation Server.

Confidential, IA

Senior Programmer Analyst /Developer

Responsibilities:

  • Design, developed UI for Macros using with three tire application.
  • Implemented business logic (C#).
  • Created User Controls and Custom Controls like Calendar Control, Input Box, Header Control, Communicator Control and Footer Control.
  • Worked on ADO.Net components like Data Adapter, Data Reader and Grid View to access/manipulate data from MS SQL Server 2005
  • Created sophisticated SQL Server database to responsively handle complex queries (T-SQL, DTS, triggers, stored procedures, functions, optimization) and .Net data access components
  • An Integration Services (SSIS) package was scheduled to daily load data from operational database.
  • Wrote and integrated custom Reporting Services (SSRS) reports with SharePoint.
  • The reports’ logic was encapsulated within stored procedures to facilitate changing requirements.
  • A security layer was integrated with the reports to meet requirements. Performance tuned the application by optimizing the queries. The data was displayed on a SharePoint website.
  • Performed the initial unit testing during the development of code and functional testing of the business login
  • Involved in the support and maintenance of the application during production phase.
  • Trouble shooting, Bug Tracking, Bug fixing and helping others.
  • Check In and Check Out of file and project using Clear Case.
  • Managed implementation and provided technical support.

Environment: C#, VB.Net, ADO.Net, Visio, Win-forms, SharePoint, ASP.Net, JavaScript, AJAX, Visual Studio.Net 2005, SQL Server 2005, VSS 2005, Windows XP Professional, IBM Mainframes, IBM Rational Clear Case.

Confidential, TX

Senior Programmer Analyst /Developer

Responsibilities:

  • Unit Visit Tracking System is client/server application which is designed Using C# and SQL Server 2005 as backend.
  • Implemented business logic (C#).
  • Created and modified TSQL-queries.
  • Developed Custom Controls.
  • Created sophisticated SQL Server database to responsively handle complex queries (T-SQL, DTS, triggers, stored procedures, functions, optimization) and .Net data access components
  • Performed the initial unit testing during the development of code and functional testing of the business login
  • Involved in the support and maintenance of the application during production phase.
  • Trouble shooting, Bug Tracking, Bug fixing and helping others.
  • Extensively used Version control tools (VSS) for the entire development cycle.
  • Managed implementation and provided technical support.
  • Involved in PAS Enhancements & Testing Project.
  • Recorded manual test scripts using Auto IT.

Environment: C#, ADO.Net, Visio, ASP.Net, JavaScript, AJAX, Visual Studio.Net 2005, SQL Server 2005, VSS 2005, Windows XP Professional, Auto IT v3

Confidential, TX

Senior Programmer Analyst /Developer

Responsibilities:

  • Implemented a shopping cart system based on ASP.Net, C#, SQL Server 2005.
  • Customized web interface for retrieving online orders.
  • Created Stored Procedures to improve the efficiency of the application.
  • Extensively used Version control tools (VSS) for the entire development cycle.
  • Managed implementation and provided technical support.
  • Responsible for fixing and trouble-shooting various issues in production.
  • Create User interface Using ASP.Net as front end and C# as code behind language.

Environment: C#, ASP.Net, ADO.Net, CSS, Java script, AJAX, Visual Studio.Net 2005, SQL Server 2005, VSS 6.0, Windows XP Professional

Confidential, NY

Programmer Analyst

Responsibilities:

  • Developed accounting related User interface Using VB.Net.
  • Involved in designing and implementation of N-Tier Application architecture.
  • Converted their existing VB6 desktop application to web pages.
  • Developed all accounting functions call from service pages these pages use web service call to cams tar server.
  • Responsible for fixing and trouble-shooting various issues in production.
  • Developed web services using Insite 4.1 Designer.
  • Developed and scheduled Backend jobs.
  • Developed cost accounting reports using VB.Net.
  • Extensively used Version control tools (VSS) for the entire development cycle.
  • Managed implementation and provided technical support.

Environment: VB 6.0, VB.Net, ADO.Net, ASP.Net, JavaScript, Web services, Visio, Visual Studio.Net 2003, SQL Server 2005, VSS 6.0, CAMSTAR, Infragistics2005, Windows XP Professional

Confidential

Responsibilities:

  • Developed client-server application with Visual Studio .Net 2003 (VB.Net & ADO.Net) and SQL Server 2000.
  • Developed an Reports using .Net Charts
  • Extensively used Version control tools (VSS) for the entire development cycle. Managed implementation and provided technical support.
  • Create an interface for Reports Using Win forms.
  • Created Reports Using Active Reports.
  • Digital dashboard for displaying out custom charts for business needs.

Environment: VB.Net, ADO.Net, Visio, Visual Studio.Net 2003, SQL Server 2000, VSS 6.0, MS Access, Crystal Reports, .Net Charting, Windows XP Professional

Confidential, OH

Programmer Analyst

Responsibilities:

  • Application was developed using Client /Server Technology using C# as the code behind and Oracle9i as the backend database.
  • Developed an XSD for clients interaction with Web Service
  • Created and deployed XML Web Services using ASP.Net.
  • Extensively used Version control tools (VSS) for the entire development cycle. Managed implementation and provided technical support.
  • Developed Exception logging (to Event Log & database) and alarming Utility classes for this application using .Net Framework
  • Responsible for fixing and trouble-shooting various issues in production.
  • Communicating with External Services.

Environment: ASP.Net, ADO.Net, C#, Java script, XML, XPath, Turbo XML, Vision, Visual Studio.Net 2003, Oracle9i, VSS 6.0, Windows XP Professional

Confidential, AR

Programmer Analyst

Responsibilities:

  • Involved in design and implementation of the whole life cycle of the product.
  • Involved in converting various Power Builder screen into VB.Net, Win forms.
  • Developed user controls and custom control for the product.
  • Writing of stored procedures and TSQL functions.
  • Used ADO.Net objects to access database layer
  • Extensive usage of Data Bound controls like Data grid for displaying database information in html table format.
  • Conducted code reviews to make sure that organization standards are followed.

Environment: C#, VB.Net, ADO.Net, Win forms, SQL Server, Power Builder, Informix, Visual Studio.Net, Windows XP Professional

Confidential, NY

Programmer/Web Developer

Responsibilities:

  • Developed & Design the application using C#.
  • Involved in the creation of presentation framework using C#
  • Writing Stored Procedures to improve the efficiency of the application
  • Extensive usage of Data Bound controls like Data grid for displaying database information in html table format.
  • Developed user controls and custom control for the product.
  • Specifying, visualized, constructing, and documenting the artifacts of software systems using UML
  • Design and development of reports using Active reports.

Environment: C#, ADO.Net, XML, XPath, Windows 2003 Server, UML, Visual Studio.Net, Visual SourceSafe, Active Reports, SQL Server 2000

Confidential, NJ

Programmer

Responsibilities:

  • Involved in the requirement analysis, Design, Development & testing of the whole product.
  • Design ASP.Net Pages for server side processing and updating the data sent by the client browser.
  • Responsible for writing client and server side validation using JavaScript and C#.
  • Responsible for using ADO.Net and XML method packages for data interaction between Client and Server.
  • Created Eligibility Document for all Benefit Programs and Benefit Plans under these programs.
  • Looked into terminated employees with active benefits. Analyzed the data to find out the reasons for active benefits and corrected the data.
  • Created functional specifications for Salary Change so that a row is inserted in Bas Activity when the compensation changes occur for an employee.
  • Processed snapshot events for employees. Conducted snapshot analysis and investigated errors.
  • Made configuration and setup changes where applicable. Used Eligibility debugging the errors. Resolved the errors and took snapshot events to finalization.
  • Created Test employees and various scenarios to test two processes used to keep the Hire event open during the benefits enrollment window period.
  • Analyzed calculation of Confidential LTD using alternative compensation values.
  • Reviewed setting up of Non-Qualified Medical Coverage and researched on enrollment of Non-Qualified Adults as dependents.
  • Involved in defect fixing; defects were tracked using Clear Quest.
  • Used MSMQ to Process Requests.

Environment: ASP.Net, VB.Net, C#, ADO.Net, JavaScript, XML, XPath, Visual Studio.Net, SQL Server 2000, Windows 2000 Professional, CSS, MSMQ, IIS, SQL Server7.0/2000, MTS

Confidential, Atlanta, GA

Web developer

Responsibilities:

  • Created dynamic ASP pages using Visual Interdev.
  • Developed the Style sheets, which are used for the entire site.
  • Created a Tracking COM component and deployed in MTS, which gives the facility to track the pages in which the user has visited and the time spent on the particular page.
  • Handled the Tracking Component.
  • Used Email component for implementing email facility.
  • Used in embedded Java script for client side validations and VB Script for the server side scripting.
  • Used ADO objects like ADODB.connection, ADODB.Recordset for interaction with the oracle database.
  • Created a stored procedures, and triggers in Oracle database which are used in asp pages.
  • Installed the Windows NT server4.0, IIS 4.0, and SQL Server7.0, and used visual source safe6.0 as a version control system.
  • Used MS Visio for drawing flow charts, which are useful to analyze the site flow.

Environment: ASP 2.0, SQL Server 7.0, IIS 4.0, XML, MTS,FTP, Oracle 8.0, Visual Interdev 6.0, Visual SourceSafe 6.0, VB 6.0, ADO2.0 VB Script, JavaScript, HTML, Windows NT and Windows 98

Confidential, CA

Responsibilities:

  • Developed relationships in MS-Access database.
  • Good working knowledge with the linked tables in MS-Access database,
  • Maintained referential integrity and indexes in the database.
  • Strong in maintaining the backups of the database.
  • Developed new interface between the MS-Access to ASP.
  • Created dynamic ASP pages using Visual Interdev.
  • Used embedded JavaScript for client side validations and VBScript for the server side scripting.
  • Used ADO objects like ADODB.connection, ADODB.Recordset for interaction with the Oracle 8.0.
  • Created a stored procedures and triggers in SQL Server database which are used in asp pages.
  • Installed the Windows NT Server 4.0, IIS 4.0, and used Visual Source Safe 6.0 as a version control system.
  • Used MS Visio for drawing flow charts, which are useful to analyze the site flow.

Environment: MS Access, Oracle 8.0, ASP 2.0, IIS 4.0, MTS, Visual Interdev 6.0, Visual SourceSafe 6.0, VB 6.0, ADO 2.0, VB Script, JavaScript, HTML, Windows NT and Windows 98

Confidential

Software Developer

Responsibilities:

  • Made an analysis and generated reports to identify the villages or habitations where the government has to concentrate more towards its development.
  • Reports were also generated to know the Literacy Rates, Population Distribution, availability of schools and hospitals, social welfare schemes adopted, etc.
  • Linked the database to MPHS (Multipurpose Household Survey) database to get the information about a particular village, habitation, panchayat, mandal or constituency and about each and every individual present in the village.
  • This application generated various reports like: Count Percentage of each individual parameter by Habitation, Panchayat, Mandal and Constituency Grid based reports, Text Frequency, Response, Deficiency, and Personal details. Responsibilities included design, development, and performance tuning, maintaining and testing.

Environment: Visual Basic 6.0, MS Access, Oracle 8.0, Crystal Reports, and COM

We'd love your feedback!