Programmer Analyst Resume
Atlanta, GA
SUMMARY:
- Over 10 years of experience in the IT Industry with extensive experience in Technical Leadership, Systems study, Scheduling, Conceptual Design, Detail design, Requirement gathering, Prototyping, Analysis, Process modeling, System & Data modeling, Database Design, Development, Implementation, Testing, Documentation & maintenance of Applications in Client/Server and Web Environment.
- 10+ years of experience in .NET technologies (C#, VB.NET, ASP.NET, ADO.NET, Entity Framework, XML and Web Services)
- Expertise in designing, building and maintaining efficient, reusable and reliable C#.Net code.
- Expertise in designing and developing complex user interfaces using ASP.Net, Infragistics and Telerik controls.
- Experience in designing and developing SSRS and Crystal Reports.
- Expertise in creating database objects like tables, views, stored procedures and functions in SQL server.
- Expertise in performing Data Base refresh across environments.
- Expertise in creating SSIS packages.
- Expertise in using SQL Profiler.
- Expertise in creating ABAP function modules.
- Excellent skills in the use of XML, HTML JAVASCRIPT, BOOTSTRAP, JSON and jquery.
- Expertise in developing application with MVC, WebApi and AngularJS.
- Extensive exposure in Multithreading and OO Analysis & Design (OOAD).
- Good understanding of business process procedures in SAP SD module.
- Expertise in using the program FBGENDAT used to generate the test data.
- Experience in Performance Analysis of SAP programs using SAP standard tools like Runtime Analysis (SE30) and SQL Trace (ST05)
- Extensive experience in all Applications Software development and Product development life cycles.
- Implemented PCI compliant site with wild card SSL cert.
- Proposal development; Feasibility Studies; presentations to Senior Management.
- Business Process Analysis, Modeling, Reengineering.
- Developed process flow analysis and procedures for existing operations.
- Extensive experience in creating business, functional and technical documentation
- Excellent verbal, written communication and presentation skills, problem solving and conflict resolution skills, and detail oriented.
TECHNICAL SKILLS:
Environment: Visual Studio 6.0, Visual Studio .Net 2003/2005/2008/2010/2012
Languages: C, C++, VB.NET, C#.NET, ABAP
Database: SQL Server 2000 /2005 / 2008
Web Development: ASP.NET, ADO.NET, Infragistics, Telerik, XML
Source Control: Visual Source Safe, Team Foundation System (TFS).
PROFESSIONAL EXPERIENCE
Confidential, Atlanta, GA
Programmer Analyst
Responsibilities:
- Architected the full life cycle of the application from requirement gathering, designing, and development and testing.
- Developed the application in ASP.Net MVC and used C# as the language.
- Created indexes on tables for optimal execution plan.
- Integrated the application with SAP by using SAP .Net Connector.
- Responsible for maintaining, updating and bug fixing the site as per the requirements.
- Integrated the application to BOBJ reports where the user can schedule or run reports on demand, can choose prompts and also choose type of the report (excel / pdf).
- Created Maintenance plans to backup databases on a daily basis.
- Created scheduled jobs to rebuild and reorganize indexes on database tables to eliminate fragmentation.
- Responsible for supporting the application on a daily basis.
- Implemented application production releases as required.
- Used TFS for maintaining version control.
- Comodo Wild Card SSL cert is used for the site and is PCI compliant.
Environment: .Net Framework 4.5, Visual Studio 2012, IIS 8.5, ASP.Net MVC 4, C#, Entity Framework, SQL Server 2008, Team Foundation Server (TFS), JavaScript, jQuery and HEAT.
Confidential, Atlanta, GA
Responsibilities:
- Involved in complete life cycle including requirement gathering, application design, testing and deployment.
- Developed the application in ASP.Net and used C# to create classes.
- Developed the helper classes and controls in C# to facilitate reusable code.
- Developed Stored Procedures, functions and views as needed by the application.
- Created indexes on tables for optimal execution plan.
- Integrated the application with SAP by using SAP .Net Connector.
- Using the program FBGENDAT generated the test data, which was helpful in debugging the functional modules.
- Created or modified SAP ABAP Function Modules (BAPIs) as per the requirements.
- Used different telerik controls in building the application.
- Made changes to the existing application based on new business requirements.
- Testing the application on different browsers to ensure standard user experience for the users across all platforms.
- Responsible for maintaining, updating and bug fixing the site as per the requirements.
- Integrated the application to BOBJ reports where the user can schedule or run reports on demand, can choose prompts and also choose type of the report (excel / pdf).
- Created Maintenance plans to backup databases on a daily basis.
- Created scheduled jobs to rebuild and reorganize indexes on database tables to eliminate fragmentation.
- Responsible for supporting the application on a daily basis.
- Implemented application production releases as required.
- Used TFS for maintaining version control.
- Comodo Wild Card SSL cert is used for the site and is PCI compliant.
- Resolved incidents and service requests logged from Heat ticketing system.
- Implemented some of the YSlow and Page Speed suggestions to improve the overall performance of the site.
Environment: .NET Framework 3.5, Visual Sudio.NET 2008, IIS 6.5/8.5, ASP.NET, C#, ADO.NET, SQL Server 2005, LINQ, Telerik, Team Foundation Server, JavaScript, SAP GUI 7.2/7.3, ABAP, HEAT, Windows Server 2003/ 2012 R2.
Confidential,Atlanta, GA
Responsibilities:
- Architected the full life cycle of the application from requirement gathering, designing, and development and testing.
- Developed the application using MVC WebAPI and C# for creating the classes.
- Exported data from Excel sheet to SQL Server database using SSIS.
- Implemented Entity Framework to connect to Database.
- Implemented MVC WebAPI methods to data contexts to retrieve the data from the database.
- Implemented UI layer in MVC design using AngularJS.
- Consumed the WebAPI using AngularJS script.
- Responsible for maintaining, updating and bug fixing the site as per the requirements.
- Used TFS for maintaining version control.
- Implemented some of the YSlow and Page Speed suggestions to improve the overall performance of the site.
Environment: .Net Framework 4.5, Visual Studio 2012, IIS 8.5, MVC, WebAPI, Entity Framework, SQL Server 2008, Team Foundation Server (TFS), jQuery, AngularJS, Bootstrap and HEAT.
Confidential, Atlanta, GA
Responsibilities:
- Involved in creating UI components, designing reports and administration pages.
- Involved in creating database tables, users and security.
- Involved in creating Stored Procedures as needed by the application.
- Created Maintenance plans to backup databases on a daily basis.
- Created SSIS packages to move data between development, test and production databases.
- Created scheduled jobs to rebuild indexes on database tables to eliminate fragmentation.
- Created the security groups in active directory as per business requirements.
- Configured the application on both test and production environments.
- Created interface using C# to connect to Active Directory and navigating the users based on their roles.
- Maintaining the site availability and addressing any issues caused to the users.
- Resolved incidents and service requests logged from Heat ticketing system.
- Tested the application on different browsers to ensure standard user experience for the users across all the platforms.
- Performed Unit Testing and integration testing.
- Used TFS for maintaining version control.
Environment: .NET Framework 4.0, Visual Sudio.NET 2010, IIS 7.5, ASP.NET, C#, ADO.NET, Crystal Reports Ver 13.0, SQL Server 2008, LINQ, Team Foundation Server (TFS), JavaScript, jQuery, HEAT.
Confidential, Atlanta, GA
Responsibilities:
- Involved in complete life cycle including requirement gathering, application design, testing and deployment.
- Integrated the application with SAP by using SAP .Net Connector.
- Created or modified SAP Function Modules (BAPIs) as per the requirement.
- Created Function Modules to customize the functionality of BAPI SALESORDER CREATEFROMDAT2, BAPI INQUIRY CREATEFROMDATA2 and BAPI QUOTATION CREATEFROMDATA2 as per the requirements that allows the users to handle orders, inquiries and quotations.
- Using the program FBGENDAT generated the test data, which was helpful in debugging the functional modules.
- Developed the application in ASP.Net and wrote C# classes.
- Developed the helper classes and controls in C# to facilitate reusable code.
- Extensively used different telerik controls in building the application.
- Developed Stored Procedures, functions and views as needed by the application.
- Created indexes on tables for optimal execution plan.
- Tested the application on different browsers to ensure standard user experience for the users across all platforms.
- Responsible for maintaining, updating and bug fixing the site as per the business requirements.
- Created Maintenance plans to backup databases on a daily basis.
- Created SSIS packages to move data between databases, from excel / flat files to database and vice - versa.
- Created scheduled jobs to rebuild indexes on database tables to eliminate fragmentation.
- Responsible for supporting the application on a daily basis.
- Implemented application production releases as required.
- Used TFS for maintaining version control.
- Comodo Wild Card SSL cert is used for the site and is PCI compliant.
- Resolved incidents and service requests logged from Heat ticketing system.
- Implemented some of the YSlow and Page Speed suggestions to improve the overall performance of the site.
Environment: .NET Framework 3.5, Visual Sudio.NET 2008, IIS 6.5, ASP.NET, C#, ADO.NET, SQL Server 2005, LINQ, Team Foundation Server (TFS), JavaScript, SAP GUI 7.2/7.3, ABAP, HEAT.
Confidential, Atlanta, GA
Responsibilities:
- Involved in complete life cycle including requirement gathering, application design, testing and deployment.
- Integrated the application with SAP by using SAP .Net Connector.
- Created or modified SAP Function Modules (BAPIs) as per the requirement.
- Created Function Modules to customize the functionality of BAPI SALESORDER CREATEFROMDAT2, BAPI INQUIRY CREATEFROMDATA2 and BAPI QUOTATION CREATEFROMDATA2 as per the requirements that allows the users to handle orders, inquiries and quotations.
- Using the program FBGENDAT generated the test data, which was helpful in debugging the functional modules.
- Developed the application in ASP.Net and wrote C# classes.
- Developed the helper classes and controls in C# to facilitate reusable code.
- Extensively used different telerik controls in building the application.
- Developed Stored Procedures, functions and views as needed by the application.
- Created indexes on tables for optimal execution plan.
- Tested the application on different browsers to ensure standard user experience for the users across all platforms.
- Responsible for maintaining, updating and bug fixing the site as per the business requirements.
- Created Maintenance plans to backup databases on a daily basis.
- Created scheduled jobs to rebuild indexes on database tables to eliminate fragmentation.
- Responsible for supporting the application on a daily basis.
- Implemented application production releases as required.
- Used TFS for maintaining version control.
- Comodo Wild Card SSL cert is used for the site and is PCI compliant.
- Resolved incidents and service requests logged from Heat ticketing system.
- Implemented some of the YSlow and Page Speed suggestions to improve the overall performance of the site.
Environment: .NET Framework 3.5, Visual Sudio.NET 2008, IIS 6.5, ASP.NET, C#, ADO.NET, SQL Server 2005, LINQ, Telerik, Team Foundation Server (TFS), JavaScript, SAP GUI 7.2/7.3, ABAP, HEAT.
Confidential, Atlanta, GA
Responsibilities:
- Created new posts as per the requirements.
- Gave training to few HR employees to monitor the replies and adding / deleting users and overall blog.
- Added users, reset passwords on demand.
- Maintaining the blog with day-to-day activities.
Environment: WordPress, PHP, MySQL.
Confidential, Alanta, GA
Responsibilities:
- Involved in requirement gathering, application design, testing and deployment.
- Worked with offshore person to get the work done.
- Gave training to the users (IT staff) about the site.
Environment: PHP, MySQL.
Confidential, Atlanta, GA
Responsibilities:
- Decoding existing DTS packages that transforms the legacy pick system’s flat files to staging tables.
- Decoding .Net code which validates and parse the data, and transforms to main database tables.
- Worked with Data Integrator consultant on the requirements gathering and design of the Confidential .
- Involved in defining the data stores, defining jobs, work flows and data flows.
- Involved in loading and testing the data for integrity.
- Got trained on the DI tool.
Environment: SQL Server 2000 / 2005, Data Integrator, .Net Framework 2.0, Visual Studio 2003, IIS 6.0, HEAT.
Confidential, Atlanta, GA
Responsibilities:
- Involved in gathering existing infrastructure and overview of applications.
- Collected all .Net application assembly files
- Involved in collecting introscope agent/EM configuration and log files.
- Installed Wily workstation on few IT user machines based on the documentation provided by CA Wily
- Got hands-on and training on Wily Introscope, Enterprise Manager, Workstation, agents and dashboards.
- Created few custom tracers to report metrics at class and methods level.
- Installed wily agent on few new IIS servers.
Environment: .Net Framework 2.0, Visual Studio 2003, IIS 6.0, HEAT, CA Wily Introscope 8.0.
Confidential, Atlanta, GA
Responsibilities:
- Involved in application design, testing and deployment.
- Mentoring the offshore team group.
- Designed and developed the helper classes in C# to facilitate reusable controls and code.
- Encrypting some of our critical data with the help of 3rd party web services (Delego Web Service) and maintaining the data.
- Wrote functions that encrypt the data in the windows application using Microsoft encryption functions.
- Created maintenance rules to take the backups daily of our SQL Server databases.
- Created SSIS packages to move data between database servers, loading data from / to excel sheets as required.
- Used SQL Profiler to improve the performance of the SQL stored procedures and functions.
- Created indexes and maintenance plans to re-build and re-organize indexes on regular basis.
- Created and updated existing windows application pages by using Infragistics for Net Advantage for .Net.
- Monitoring and solving the day-to-day call logs using HEAT.
- Validated the data from our Mainframe systems (TZG) by using AccuTerm.
- Created and deployed the application in different environments (Development, UAT and Production) and maintaining the same.
- Used Team Foundation Services for source code control.
Environment: .Net Framework 1.1/2.0, Visual Studio .Net 2003/2005, C#, JavaScript, SQL Server 2000/2005, Visual Source Safe, Team Foundation Server, Infragistics 5.2/7.1, AccuTerm 2K2, HEAT.
Confidential, Atlanta, GA
Responsibilities:
- Involved in requirements gathering, application design, testing and deployment.
- Developed the applications in ASP.NET and involved in writing C# classes.
- Converting .Net projects from Framework 1.1 to 3.5
- Mentoring the offshore team group.
- Worked on designing and developing the helper classes in C# to facilitate reusable controls and code.
- Involved in creating web services and calling them from our applications.
- Encrypting some of our critical data with the help of 3rd party web service (Delego Web Service) and maintaining the data.
- Involved in writing some functions that encrypt the data in our windows applications using Microsoft encryption functions in C# code.
- Maintaining all our Web applications, Windows Services and Web Services on daily basis.
- Monitoring our data in our SQL Server Databases on regular basis.
- Updated the SQL Server database from 2000 to 2005. Updated the Stored Procedures, Views and tables as well in the process.
- Involved in creating the maintenance rules to take the backups daily of our SQL Server databases.
- Created SSIS packages to move data between development, test and production databases.
- Created few standard and custom reports for Sales Reps using SSRS (Microsoft Reporting Services).
- Designed screen layouts while creating customer reports.
- Implemented Indexes and created maintenance plans to re-build and re-organize indexes on regular basis.
- Involved in creating the DI process, which involves reading the nightly text files and loading them into our SQL Server 2005 databases using Data Integrator XI.
- Modified creating the pdf documents with the help of 3rd party control (Dynamic PDF Generator) on demand.
- Used SQL Profiler to improve the performance of the SQL stored procedures and functions.
- Involved in creating and modifying the windows application pages by using the 3rd party control (Infragistics for Net Advantage for .Net 2007)
- Monitoring and solving the day-to-day call logs. Using HEAT for Call Loggings.
- Validating the data from our Mainframe systems (TZG) by using AccuTerm.
- Using ADO.Net to fetch data from database using SQL Stored Procedures.
- Involved in writing test cases for Unit testing and integration testing.
- Created different environments for our applications (for developing and testing)
- Deployed the application in different environments (Development, UAT and Production) and maintaining the same
- Source code maintenance using Visual Source Safe.
- Involving using Team Foundation Services in place of Visual Source Safe for source code control.
Environment: .NET Framework 1.1/2.0/3.5, Visual Sudio.NET 2003/2005/2008, ASP.NET, C#, ADO.NET, HTML, JavaScript, .NET XML Web services, SQL SERVER 2000/ 2005, SSIS, SSRS, Visual Source Safe, Team Foundation Server, .NetFx3.0, XAML and Data Integrator XI 3.0 Premium, AccuTerm 2k2, CA Wily Introscope 8.1.0.0, HEAT.
Confidential, Chicago, IL
Programmer Analyst
Responsibilities:
- Involved in application design, testing and deployment.
- Developed the applications in ASP.NET and involved in writing C# classes.
- Involved in developing the GUI and windows based user controls using C#2.0
- Worked on designing and developing the helper classes in C# to facilitate reusable controls and code.
- Developed Web form application and assemblies using C#
- Development of CR related to Product registry admin module using C#. (Win Forms)
- Involved in the development of custom grid control using XAML and WPF having the functionalities like drag and drop of columns, cell editing, sorting, paging, image display and adding/deleting of rows.
- Used XAML for creating the UI part of our custom grid.
- Tested our grid with the real time data.
- Created Resource Files for Globalization.
- Experienced in creating Dynamic PDF files
- Created a windows service to process the orders and sending mails and fax to the end users.
- Involved in creating Web Services and consumed web services in our applications
- Projects made extensive use of Microsoft Data Access Application Blocks and Infragistics
- Discovered and corrected major security risk affecting the application.
- Used ADO.Net to fetch data from database using SQL Stored Procedures.
- Dealing with different time critical issues such as login and sync issues for end users
- Improved performance of the web site by modifying both the existing code and stored procedures.
- Created Stored Procedures and triggers to perform integrity rules, updating the related tables using SQL Server 2000 efficiently.
- Improving the overall performance of the application by implementing proper indexing and joins in the corresponding tables and queries.
- Testing and maintaining the application
- Involved in writing test cases for Unit testing and integration testing.
- Deployed the application in different environments (Development, UAT and Production)
- Source code maintenance using Visual Source Safe.
Environment: .NET Framework 1.1/2.0, Windows XP, Visual Sudio.NET 2002/2005, ASP.NET, C#, ADO.NET, HTML, JavaScript, .NET XML Web services, SQL SERVER 2000, Visual Source Safe, .NetFx3.0, WPF (Windows Presentation Foundation) and XAML.
Confidential, Iselin, NJ
Programmer Analyst
Responsibilities:
- Developed Win forms application using C#.
- Developed interfaces to get daily prices from market data sources.
- Developed loaders to load data on nightly basic from legacy systems.
- Developed assemblies using C#.
- Developed ASP.Net web application using C#.
- Developed Web pages as per the requirements.
- Created DTS packages for data transformation process.
- Written the data base stored procedures in SQL Server.
- Deployed the application on the test servers.
- Involved in fine tuning, Performance and Query optimization of the database.
- Involved in writing test cases for Unit testing and integration testing.
- Source code maintenance using Visual Source Safe.
Environment: .NET Framework 1.0, Visual Sudio.NET 2002, ASP.NET, C#, ADO.NET, HTML, JavaScript, SQL SERVER 2000, Visual Source Safe.