We provide IT Staff Augmentation Services!

Sr. Software/ Programmer Analyst Resume

2.00/5 (Submit Your Rating)

New Jersey, NJ

SUMMARY:

  • 8 years of experience in developing object oriented development and distributed n-tier architecture based web applications using VB.NET, C#.NET, ASP.Net using Microsoft framework 1.1/2.0/3.0/3.5, XML, XSLT,IIS 6.0, VB, classic ASP,C,C++, SQL Server 2000/2005/2008, Oracle ,Sybase, Main frame DB2 database, Ms Access Database, Crystal Reports.
  • Worked on development of web services using .NET, MVC, SOAP messages and Network Protocols - TCP/IP protocols.
  • Expertise in writing Stored Procedures, Triggers, Views, Cursors, SSRS, PL/SQL, SSIS and T-SQL.
  • Worked on MSMQ, WCF, WPF and COM/COM+ objects.
  • Experience in data analysis, data Migration/transfer, (import/export) of MS Access data, FoxPro, CSV files, Flat Files etc to SQL Server using ETL tools.
  • Creating DTS Packages, SSIS packages for application working on Heterogeneous Data Environment.
  • Experience with design and development of business reports using Crystal Reports 7, 8.5, 10 and BI Tool (Business Object Report Tool XI) for Client-Server and Web based applications.

TECHNICAL SKILLS:

Programming Languages: ASP.Net [.NET Framework 3.0, 2.0, 1.1, 1.0], C#.NET, VB.NET, VB, Visual

Basic 6.0, Classic ASP, C, C++

Web tools: ASP, AJAX, XML Web Services, HTML, DHTML, XML, Java script, and VBScripts, XSLT

Relational Database: MS SQL Server 7, SQL Server 2000, SQL Server 2005, Sql server 2008, MS Access, Oracle ,Sybase, DB2 Main Frame ( NEON Shadow , TGADP Driver )

Software package: MS Visual Studio 2005, Visual studio 2008, MS Project, MS Visio 2003,UML design, MS Access/Excel, Adobe Photoshop

Reporting Tools: Crystal Report 7.x/8.5 x/10.0x/11.0 x (Business object XI)

EDUCATION & CERTIFICATIONS:

  • Bachelor of Engineer in Information Technology
  • MCP (Microsoft Certified Professional)
  • 70-228 (Installing, Configuring, and Administering MS SQL Server 2000 Enterprise Edition)
  • 70-229 (Designing and Implementing Database with Microsoft SQL Server 2000 Enterprise Edition)
  • 70-306 (Developing Windows-based Applications with Microsoft Visual Basic .NET)
  • Object Oriented Analysis and Designing with UML Training (Jan 2007)

PROFESSIONAL EXPERIENCE:

Confidential, Georgia SEP 2010 – Till Date

Sr. Software/ Programmer Analyst

TMX Finance is now the parent company for a family of brands to include TitleMax, Title Bucks and Equity Auto Loan. TMX Finance is one of the largest, fastest growing and most profitable consumer specialty finance companies in the United States. The Company serves consumers without access to traditional credit-based lending products offered by banks, credit unions, credit card companies and other consumer finance businesses.

Repossession and Expense Check are one of the main modules for TitleMax for financing the loan. This module allows any store to capture and account for expense check and repossession of a vehicle. Repossession Module empowers associate (ASM and above can edit, CSR can view) to set vehicle status to: Repo Request for Approval, Out for Repo, REPO, Sold, Redeemed, Agent Removed or vehicle can be deleted. Expense check is used for cutting expense for various charges which effect was given to different ledger of accounts.

Responsibilities:

  • Created Master Pages and Views using WebForms View engine using MVC2, Asp.net 3.5, and C #.
  • Created Controllers, Strongly typed Views, Partial Views and Entity Models.
  • Developed Views, Shared Views, DisplayTemplates and EditorTemplates using various HTML Template Helpers.
  • Used various Annotations and decorated with Models to validate the data in model.
  • Implemented Report Data Models, Application Data Models and binding the controls using LINQ.
  • Used JQUERY and JSON data at client side validation. Invoked action methods from the client side using JQUERY.
  • Created WCF services using C# and hosted on IIS.
  • Application level tracing, debugging, state maintenance through the Web.Config file.
  • Implemented Generic Exception handling and use of Error codes for customized error messages. Implemented Audit and Exception logs using Log4Net.
  • Extensive use of Ad hoc T-SQL Queries, Stored Procedures, Views, Triggers to perform the data retrieval from SQL Server 2008 for reports.
  • Developed complex reports using SSRS Interfaces like drill down reports. The subscription and deploying them. Customized the report viewer tools.
  • Setup the delivery items for each release cycle and took initiation for builds.
  • Working in Agile project management environment to deliver scrums task and story assignments.

Environment: Asp.net 3.5, C# 3.5, AJAX, MVC, Web Services, Visual Studio 2010, SQL Server 2008, SSRS (Reporting Services), NHibernate, HTML, Java Script, JSON, JQUERY, XML, XSLT, IIS 7.0, Sub-Version, TFS, NAnt, Microsoft Enterprise Library, WCF,LINQ and MSMQ.

Confidential, NJ MAR 2010 – AUG 2010

Sr. Software/ Programmer Analyst

Merrill Lynch is one of the world's leading financial management and advisory companies, providing financial advice and investment banking services which is acquired by Bank of America.

DART Daily Alert Reporting and Tracking system:

Dart acts as a regulatory, Reconciliation and Reporting system which is a financial back office system and gets feeds from the calculations and posts of all the open items from different finance systems.

Responsibilities:

  • Involved in conversion of TBAND DART online application from Classic ASP legacy application to .net application using Asp .net, VB .net 3.5, Web services, Web services, WCF using SOAP communication, Visual studio 2008.
  • Involved in architecture designing to leverage pattern of the new application using multiple and distributed layers.
  • Customization of components and query tuning done to gain the speed of old system to Asp .net system.
  • Legacy systems maintained and bug fixing done using Classic ASP, True DbGrid 7.0, HTML, CSS, VB 6.0, COM/COM+, server side VB scripts and client side Java Scripts.
  • Designs and develops internal business systems/applications and take a primary role in smaller, low risk modules like DAL layer and Business layers using web services.
  • Communicates and defends design, requirements, feature set, functionality, usability, localization issues, and limitations of subsystem to the team.
  • Worked on agile software development life cycle for software development and maintenance.
  • Database layer developed to optimize and improve T-SQL and PL/SQL query performance for different database systems like MS SQL server, Oracle, Sybase, and Main Frame DB2 which are using ODBC, TGADP and NEON Shadow drivers, Back end data integrates to other systems like security, ledger and reconciliations.
  • Developed front end layer using DHTMLX components which were using XSLT style sheet to sort and represent data.

Environment: VB, Classic ASP, .Net Framework 2.0/3.5, VB.Net, ASP.NET, Sybase, Oracle , Mainframe Db2, ODBC, NEON shadow and TGADP drivers, ADO .NET, IBM MQ series, TCP/IP, COM+ server, XML, XSL, XSLT, True DBGrid 7.0,Visual Source Safe (VSS), HTML/DHTML, DHTMLX components, CSS, Java Scripts, Windows NT/9x/2K,VS 2005, VS 2008, .net framework 2.0,3.5 , IIS server 5.1.

Confidential, AZ May 2008 – Feb 2010

Software/ Programmer Analyst

Arizona department of education is handling all student detail data from all schools. It leads the State of Arizona in developing and implementing educational guidelines.

a) SDDI (Student Detail Data Interchange): Stack holders, LEA and Schools are using SDDI system for student detail data for generating finance data for student and school.

Responsibilities:

  • Handling multi-tier application which uses MSMQ (Microsoft Messaging Queue) on messaging layer.
  • legacy systems and Integrity, Aggregation and Data push modules are developed, maintained and enhanced using Classic ASP,ASP .net, HTML, AJAX, VB, COM/COM+ components and VBScripts.
  • Developed complex Store procedures, views using T-SQL in SQL Server 2005.
  • Data migrated from different formats like MS Access database, flat files-text files to SQL server 2005 using SSIS packages.
  • Migrated web application modules from ASP .net and C#.Net 1.1 to C# 3.0 application using WCF, web service and Web methods using SOAP communication.
  • Responsible for XML data sources, created XSL and XSLT transformations documents to represent XHTML pages for student details.

b) SAIS (Student Accountability and Information System): SAIS is a core system to which the following ADE functions have been linked: Student Services, School-to-Work, Exceptional Education Vouchers, Student Achievement, Grants.

Responsibilities:

  • Implemented and coded business object layer in C# 2.0 for administration modules.
  • Student information modules and student data transformation were developed based on XML, XSL and XSLT schema.
  • Developed utilities component for processing incoming files, track and process incoming and outgoing client files using WEB Services, web methods, classic ASP, ASP.net, C# .net, AJAX,COM/COM+.

c) Student Needs: Schools and LEA are using student Needs portal to get information of student examinations needs, Grades and special needs etc.

Responsibilities:

  • Worked on T-Sql of SQL server 2008 and Visual Studio 2008 along with web services and web methods for distributed systems.
  • Developed design and documents using Ms Visio and UML notations.
  • Presentation layer developed, migrated and maintained using classic asp, ASP.Net, C# .Net.
  • Data migrated from different formats like MS Access database, flat files-text files to SQL server 2005 using SSIS packages.
  • Worked on XML files which are sorted using XSLT style sheet rules for student needs requirements.
  • ELL (English Language Lerner) and SPED (Special Education) modules are developed and maintained using Win Forms and Web Forms which are using classic ASP, ASP.NET, C#.NET, Ajax, XML, XSL, XSLT, SQL server and COM+ objects.

d) SAIS Concurrency: Portal used when student has concurrent enrollment in more than one school for funding distribution based on membership days in each school.

Responsibilities:

  • Migrated old legacy systems to new web portal from Classic ASP, VB, COM/COM+, MSMQ to ASP.net, C# 3.0, Ajax, WCF, web services.
  • Developed Presentation and Business layer using ADE Framework with C# 3.0, WCF, web services and web methods.
  • Involved in Deployment, unit and integration testing.
  • Used MS Visual source safe (VSS) for maintaining concurrent work environment of work files.

Environment: SQL Server 2000/2005, VB, Classic ASP, .Net Framework 1.1/2.0/3.5, VB.Net, ASP.NET, C#. Net ( 1.1, 2.0 , 3.0), Crystal report Object, ADO .NET, AJAX,MSMQ, TCP/IP, Active Reports, COM+ server, XML, XSL, XSLT, Visual Source Safe (VSS), HTML/DHTML, MS Visio, UML, CSS, VBScripts, Windows NT/9x/2K

Confidential, Thailand – Bangkok Oct 2007 – Apr 2008

Sr. Software Engineer

Diamond Jewelry Production Portal: Viva Jewels Exports is a leading diamond manufacturing unit in Bangkok. The Diamond Jewelry Production Software manages the diamond and gold production process.

Responsibilities:

  • Application developed using RAD (Rapid application development) Model - Software Development Life Cycle (SDLC).
  • Created custom controls, UI Forms using ASP.NET 2.0, C#.Net, AJAX, HTML, DHTML, CSS.
  • Responsible for software conversions from VB,MS Access to VB.Net using MS Visual studio 2005.
  • Data Transformation done using BCP, SSIS. Report developed using business object’s Crystal reports XI and BI Tool.
  • Provided technical documents like BRS, SRS, Design Specifications, and UML using MS Visio.
  • Worked with XML data sources, where XSLT Transformations documents were used for rules of xml data. Reports created using crystal reporting tool (business object XI-crystal report XI).

Environment: VB, C# .NET, VB.NET, ASP.net, MS Access, HTML,DHTML,AJAX toolkit, SQL Server 2005,2008, Ms Access Report, Crystal report, visual studio .net 2005. ADO.Net, IIS, XML, XSL, XSLT, Web Services (SOAP), WCF, AJAX, .NET Frame work 2.0, Microsoft Visual Source Safe (VSS), MS Visio

Reliance Info Solution Ltd, India Jan 2005 – Sep 2007

Sr. Software Engineer

It’s a group company of India’s largest private sector company Reliance Industries Limited & in the elite group of fortune 500 companies.

a) RGTIL Portal (Reliance Gas Transportation Infrastructure Ltd.): Reliance Industries has laid down pipeline from Bharuch (Gujarat) – Kakinada (Hydrabad) in India (Almost 1500Kms in length). RGTIL portal keeps track of pipeline project work.

Responsibilities:

  • Responsible for handling Normalize Database designing and creation, Data Modeling, Data structures, Database schema, Tables, Rules, Constraints and Views.
  • Involved in designing, creating Object oriented web applications, user and custom web server controls for reports developed in ASP.NET, VB.Net, HTML, DHTML, VBScripts to view reports on Web.
  • Developed complex Store procedures, views and triggers using T-SQL development by analyzing client data requests.
  • Experience with Data Extraction, manipulation, and migration using SSIS, ETL Tools from excel files to SQL Server 2002/2005 using T-SQL.
  • Used data transferring XML along with XSL and XSLT schema files.
  • Database analysis reports developed using SSRS (SQL server Reporting Services) and Crystal reports.

Environment: VB.NET, C#.NET, ADO .NET, IIS 6.0,Visual studio .Net 2005, SQL Server 2000/2005, .Net Framework 1.1/2.0, Web services (SOAP), Visual Source Safe (VSS), ETL,XML, XSL,XSLT, Crystal reports, HTML/DHTML,CSS, JavaScript, VBScript, IIS, Windows NT/9x/2K

b) POY Loading System & Fiber Vision System: POY (Partially Oriented Yarn) loading is an Intranet-based, web-enabled application for optimizing, Monitoring and managing POY loading on machines. Fiber Vision System is related with QC-QA department which is used for quality checking of Polyester Texturising Yarn Product.

Responsibilities:

  • Reports developed using Asp.net, VB.net, HTML, DHTML, VBScripts, web services and web methods.
  • Creation and Scheduling of BCP, DTS Packages, Transact-SQL (T-SQL) scripts for application working on Heterogeneous Data Environment.
  • First phase for data capturing – Developed using VB.NEt, Crystal reports, SQL Server 2000.
  • Written ETL Tools components to import the history records (Flat File format) from the running automated machines using DTS packages of SQL server 2000.
  • POY machine data were developed and maintain on XML data using XSLT rules .
  • Second Phase – Developed using Asp.net 2.0, HTML, DHTML, VBScripts, Crystal reports – BI Tool.

c) OLT (Online Tension Monitoring System): OLT is the heart of the plant machinery. All Online tension of Yarn Product is measured on texturising machines are using OLT System.

Responsibilities:

  • Scheduling the Backup of Transaction Logs and Monitoring of Server Performance through SQL Performance Monitor.
  • Involved in Object oriented design to support N-Tier architecture using ASP.net and C#.Net.
  • Monitoring of Disk Space for SQL Servers and responsibility of Restoring the Database.
  • Scheduling of Jobs & Alerts notification via SQL server agent and SQL Mail.
  • Worked on PL/SQL and Store procedure to access tension data from Oracle database.
  • Module developed for Speed data capturing from machine using C and C++ language.

Environment: SQL Server 2000, Oracle, C, C++, C# .net, VB, ASP.net 2.0,VB.NET, Java Scripts, VB Scripts, Crystal report, IIS, Dos6.22, Windows NT/9x/2K

d) Bobbin Tracking System: Database developer/Software developer System has been designed to have a complete online tracking of Texturising Machine production (in terms of yarn bobbins).

Responsibilities:

  • Got experienced on Object oriented architecture and Distributed System Architecture using .NET architecture, SOAP messaging, XML web services, ASP.net, VB.NET, VBScripts, HTML and DHTML.
  • Involved in Data warehouse and OLAP system from OLTP system using SQL Server 2000
  • ETL tools developed for desire data transfer from OLT database.

e) Time & Payroll System, Employee & contract system, VMS (Visitor Management System), Medical Management System, HRVISION, Library Mgt System, Society System

All windows and web based portal applications are ued by HR department to support employee information which makes an ERP solution.

Responsibilities:

  • Developed, maintained and enhanced Object oriented application which uses reports and data imports using SQL server 2000.
  • Using DTS packages transfer data from Ms Access and FoxPro to SQL Server 2000.
  • Web Forms are developed using ASP.net, VB.net, XML, XSL, and XSLT for data representation rules.
  • Reports developed using crystal reports tool.
  • Environment: SQL Server 2000, VB.NET, HTML, DHTML, ASP.NET, XML, XSL, VBScripts, Crystal Reports, TCP/IP network Protocol, VB, FoxPro, MS Access, Windows NT/9x/2K

    Confidential, May 2003 – Dec 2004

    Application developer

    Pencil Product Inventory System

    A system is used to maintain inventory parts like machinery, instruments, and Daily Production.

    Responsibilities:

    • Worked on Visual basic 6.0, VB.NET for windows based and Classic Asp, Asp.net for web based modules.
    • Developed database trigger, stored procedures, and view and database functions.
    • Object Oriented COM (Component object model) and ActiveX (OCX) developed in inventory module.
    • Designed, developed and implemented Reports (Standard, Cross Tabs) using Crystal reports.

    Environment: SQL server 2000, Visual Basic 6.0, Classic ASP,HTML, DHTML, VBScripts,ASP.net, VB.NET, Visual Studio .NET, HTML, DHTML,XML,XSL,XSLT, Crystal Reports, TCP/IP, HTTP, Windows NT/98/XP.

    We'd love your feedback!