We provide IT Staff Augmentation Services!

Sr Programmer Analyst Resume

PROFESSIONAL SUMMARY:

  • Having 10 years Experience in Microsoft .Net Technologies ASP.Net, web forms, C#.Net, VB.Net, Visual Studio.Net, Classic ASP, VBA, VBScript, JavaScript, Angular JS, HTML, CSS, and XML.
  • Experience in SQL Server 2000/2005 and Oracle and MS Access in Windows environment.
  • Experience in writing SQL Queries and Stored Procedures in SQL Server and Oracle.
  • Experience working on MVC 4.0 and N - Tier architecture for web development projects.
  • Worked on SiteCore CMS tool and designed HTML 5 pages and validated for errors.
  • Experience in manipulating XML, Converting Data between ADO.Net and XML and Proven Knowledge in Schema
  • Familiarity in Python, Node JS and Ruby scripting.
  • Experience working with MVC 5 architecture using Razor engine.
  • Experience using REST and Web API's.
  • Skilled in Maintaining, troubleshooting SharePoint and making configuration settings and programming features using SiteCollections
  • Experienced in migrating and tuning T-SQL scripts, indexes, stored procedures and views. Tuning and optimization of SQL queries and stored procedures using SQL Profiler and Performance monitor and ensuring indexes are using updated statistics
  • Implemented Security using SQL Logins, Roles and Security Modes for various users in non -prod environment
  • Worked on Web services and Window Communication Foundation services(WCF).
  • Experience with Data Accessing including using Data Adapter, Data Reader and Dataset in ADO.Net Providers for data manipulation.
  • Experience in Microsoft Office, Excel and Power point.
  • Familiar with popular Object Oriented Design Pattern concepts.
  • Experience in ETL tools SSIS and reporting tools SSRS, Component one and Crystal Reports.
  • Experience in handling the tasks independently
  • Excellent technical problem solving and code debugging skills.
  • Having exposure and good knowledge of AWS (Amazon Web services) Cloud computing
  • Worked on SQL BI tool SSIS, SSRS and SSAS.
  • Experience working in Silverlight and Microsoft Expression Blend.
  • Experience in Creating Web Forms, Win Forms, User Controls, Custom Controls.
  • Excellent communication and interpersonal skills
  • Familiarity in Bigdata Hadoop, HDFS, Pig and Hive.

EXPERTISE:

  • Application Development
  • Software Development Lifecycle(SDLC)
  • ROM(Rough order Magnitude) Estimates
  • Post production maintenance
  • Release Management
  • Offshore Development Operations
  • QA & UAT Management
  • Team Building & Leadership
  • Document Designing

TECHNICAL SKILLS:

Methodologies: Agile, Waterfall and Iterative.

Architecture N: Tier, MVVM and MVC 5.

Operating Systems: Windows 2000/NT/XP/2003/, Windows 7.

Programming Languages: C#, VB.Net

Web skills: ASP.Net 1.0/1.1/2.0/3.5/4.5 , Classic ASP, IIS 5.0/6.0/7.0, VBScript, JavaScript, JQuery, XML, HTML, HTML 5, Razor Engine(CSHTML), Bootstrap, CSS, Silverlight, Veracode, AJAX, Angular JS 1.1/2.0, Sitecore 6.1/7.0/8.1, RESTful Services, Web API.

Distributed Technologies: Web Services, WCF

Relational Databases: SQL Server 2000/2005/2008/2012 , Oracle 9i/10g/11g, MS Access, Data Access and API's

3rd Party Tools: ADO.Net, ADO, RDO, ODBC, OLEDB, Infragistics, Telerik, Fusion Charts, Visifire, nHibernate, Castle Active Polgroup, Dynatrace.

Version Control Tools: Visual Source Safe, Team Foundation Server.

Reporting Tools: Cloud Computing Crystal Reports, SSRS, Component one.

Amazon Web Services: (AWS), EC2, IAM, RDS

PROFESSIONAL EXPERIENCE:

Confidential

Sr Programmer Analyst

Responsibilities:

  • Involved working in ASP.Net 3.5/4.0/4.5.1 framework for design and development of screens.
  • Designed and developed Confidential module in MVC4 architecture using Visual Studio 2010.
  • Reports design using Component one tool and used it's dll references.
  • Involved designing and developing the External audits web applications using MVC 5 architecture with the Razor engine, used CSHTML for Views.
  • Worked on JQuery and Ajax calls in Razor engine.
  • Troubleshooting Production server issues and fixed on daily basis.
  • Worked on Stored procedures for building internal applications and troubleshoot issues reported by users.
  • Wrote TSQL script / Store procedure’s to automate the backup and recovery for non-prod environments.
  • Worked on PADS windows applications and developed windows screens using C#.Net.
  • Designed and developed windows forms using C#.Net for Sampling and Finding Modules in PADS
  • Developed console applications in C# for sending automated email reports service.
  • Writing complex SQL queries, Procedures, Packages and Cursors in SQL Server and Oracle Databases.
  • Migrated the modules from VS 2008 to VS 2013(4.5.1 framework)
  • Worked on developing the Confidential interface with Angular JS 1.1
  • Worked on Angular Controllers and Modules
  • Developed Angular http get Service for retrieving the data using MVC5 Controllers
  • Implemented Angular Filter for Searching data on the client data
  • Worked on N-Tier architecture and used UI, Gateway, Proxy, web services and Data access layers
  • Used TOAD to write procedures, packages and queries for Oracle 11g.
  • Involved in writing cursors using SQL Server 2008/2012.
  • Worked on Batch processing developed in VB Project.
  • Worked on ADO.Net for data access using VB.
  • Used VBA for excel operations.
  • Used Jquery and AJAX calls to action methods in controllers.
  • Involved in developing CSS Javascript code for validations and show/hide functionalities.
  • Designed and developed reports in PADS Windows applications and web applications using Component one tool
  • Used SSIS for Data migration between MDB and SQL Server and from other flat files.
  • Migrated all DTS packages to SQL Server Integration Services ( SSIS ) and modified the packages accordingly using the advanced features of SQL Server Integration Services
  • Loading data in Dimension Tables in SQL Server using SSIS Packages.
  • Uploaded SQL Server 2005 Reporting Services ( SSRS ) RDL files to SQL Server 2005.
  • Generated invoice reports using SSRS.
  • Created complex stored procedures to generate reports using SSRS .
  • Scripts taken from old web portal and validated HTML 4/HTML 5 source in W3C Validator and used Sitecore CMS tool WYSIWYG editor and published the content.
  • Used Sitecore 7.1 for creating layouts.
  • Used SAP Crystal reports for generating Invoices.
  • Worked on Json arrays
  • Worked on Json to read data from web server and display in webpage
  • Building RESTful services with WCF

Environment: ASP.Net 1.1/2/0/3.5/4.0 , MVC4/MVC 5, VB.Net, C#.Net, Visual Studio.Net 2003, Visual Studio 2008/2013, SQL Server 2005/2008, AJAX, ASP.Net 4.0, XML, HTML, WCF, Webservices, JavaScript, Oracle 11g, ComponentOne, SAP Crystal Reports, UML, Sitecore 7.1, VSS, TFS, Agile, Scrum, nHibernate, Docushare, Service now ITSM 2.0, Angular.JS 1.1/2.0, REST Web API, Dynatrace, SSIS, SSRS.

Confidential, Atlanta, GA

Sr.Developer

Responsibilities:

  • Designed the UI search filters in windows application using C#.Net 4.0 framework.
  • Implementation of comps and wireframes using cross-browser compatible HTML & CSS.
  • Feature development using Javascript Libraries including Jquery.
  • Used Firebug for debugging and tracking the compatibility issues.
  • Worked on Cross browser compatibility issues in IE7/8/9, Firefox and Chrome.
  • Cross browser testing of web portals.
  • Worked on windows forms using C#.
  • Design and develop SSIS package for loading data from OLTP to ODS and finally to Data Warehouse.
  • Used AngularJS Scope for binding between HTML and View.
  • Interacted with business users and gathered the requirements.
  • Worked on Office Interoperability applications and extensively worked on compatibility issues.
  • Used TOAD to write sql queries and procedures and packages in Oracle 10G.
  • Worked with DB Tools like SQL Developer, TOAD and ER Model
  • Worked on Stored procedures for building internal applications and troubleshoot issues reported by users.
  • Wrote TSQL script / Store procedure’s to automate the backup and recovery for non-prod environments.
  • Involved in utilizing with the defects tracking using TFS (in integration with HP ALM)for tracking application development, pre and post production deployment defects. Involved in participating the scrum/stand up meetings daily and update the status of daily tasks
  • Consumed webservices to connect to sharepoint URL for accessing the word documents.
  • Developed the functionality that inserts the text into excel cells using C#.
  • Worked on stored procedures to generate reports using SSRS .
  • Involved in Synchronization using Multithreading functionality in C#.Net.
  • Involved in writing application level code to interact with Restful Web APIs, Web Services using AJAX.
  • Developed the text search functionality that gets content from word documents in sharepoint and display the results in List box.
  • Experience in design patterns such as Factory and Singleton patterns

Environment: HTML/CSS, Javascript using the JQuery library, Angular.JS, wireframing & prototyping, SEO, RSS, Adobe Photoshop and Dreamweaver, C# 4.0, Visual Studio 2010, TFS, Oracle 10g, Windows 8, HP ALM, SSIS, SSRS.

Confidential, Atlanta, GA

Web Developer

Responsibilities:

  • Involved in requirements gathering, preparing ROM (Rough Order Estimates), Analysis and design the ASPX forms.
  • Created the project in MVC3 architecture and presented .cshtml files as Views layer.
  • Worked on SiteCore CMS tool and designed HTML 5 pages.
  • Extracted data from Oracle and migrated into SQL Server 2005 using SSIS .
  • Generated reports using SSRS
  • Integrated Sitecore with backend systems and provided user controls.
  • Used Angular ng-repeat and Bootstrap for faster performance.
  • Created Angular Custom Directives for retrieving demographic data.
  • Implemented Multithreading Concepts to improve the application Performance
  • Wrote SQL Stored procedures, Views and complex queries for SELECT, INSERT’s and UPDATE’s using SQL Server 2008
  • Using code behind language C# (VS 2010) for functionality development.
  • Worked on User controls.
  • Worked on Javascript for client side scripting.
  • Extensive use of Restful Web Services
  • Single Sign On(SSO) in Sitecore with Active Directory Users and Roles
  • Used SAML for web-based single sign-on.
  • Achieved single sign on by implementing custom membership, role and profile providers.
  • Used ADO.Net technology for data operations.

Confidential

Developer

Responsibilities:

  • Gathering the requirements and prepared the process flows.
  • Integrated Sitecore with backend systems and provided user controls.
  • Extracted data from Oracle and migrated into SQL Server 2005 using SSIS .
  • Generated reports using SSRS
  • Utilized Sitecore CMS to design .Net application features.
  • Enabled Single Sign On(SSO) in Sitecore with Active Directory Users and Roles
  • Used SAML for web-based single sign-on.
  • Achieved single sign on by implementing custom membership, role and profile providers.
  • Used Angular Filter for Searching data on the client data
  • Participating in daily scrum meetings and giving updates on daily basis and discuss on outstanding issues which is tracked through HP ALM tool.
  • Designed and developed forms using Docworks application to deploy in Confidential product
  • Wrote business rules using Javascript, VB Script and Classic ASP.
  • Wrote sql queries and procedures in SQL Server 2005/2008.
  • Worked on different backup and recovery techniques for non-prod environment and was also involved in migrating databases from SQL Server R2
  • Used Perforce tool to deploy codes.
  • Created jobs and monitored them through SQL Server Agent.
  • Wrote webservices in VB to integrate with MYeyonline application.
  • Used Veracode tool to analyze and suppress the flaws of the application.

Environment: Classic ASP, VB Script, ASP.Net 2.0/3.5/4.0,VB.Net, Veracode, Angular JS, MVC3, Visual Studio.Net 2010, XML, HTML, CSS, JavaScript, Sql Server 2005/2008, Agile, Team Foundation Server, SSIS, SSRS.

Confidential, Albany, NY

Web Application Developer/VB.Net developer

Responsibilities:

  • Designed and developed screens in ASP.Net 1.1 for Confidential 1.1 application.
  • Worked on N-Tier architecture.
  • Worked on Entity Framework.
  • Wrote Validations using Java Script.
  • Wrote procedures, packages and queries using Oracle 11g in TOAD.
  • Worked on WCF Services.
  • Utilized Sitecore CMS to design .Net application features
  • Enabled Single Sign On(SSO) in Sitecore with Active Directory Users and Roles
  • Worked on Silverlight and Microsoft Expression blend for rich UI design in web applications.
  • Wrote XPath queries and procedures in Oracle.
  • Worked on Batch processing developed in VB Project.
  • Worked on designing Application flow diagrams in Microsoft Visio.
  • Worked on file import batch, that stores the file data in Database tables.
  • Worked on third party tools Infragistics for grid controls.

Environment: ASP.Net 1.1,VB.Net, Visual Studio.Net 2003, WCF Services, Infragistics, Telerik, Visual Studio 2010, XML, HTML, JavaScript, Oracle 11g, Silverlight, Visual Source Safe, Team Foundation Server.

Confidential, Albany, NY

.Net Developer/Web Developer

Responsibilities:

  • Used ADO.Net for accessing the database and displaying the records in front end.
  • Used VB as code behind technique.
  • Worked on GridView controls
  • Used ADO.Net for database operations
  • Worked on the content editor and media library in Sitecore 6.1
  • Validated the code in HTML 4.0 and HTML5 and published the pages in Sitecore 6.1 CMS.
  • Worked on UI designing using Adobe Dreamweaver
  • Wrote client side validations using Javascript
  • Integrated Sitecore with backend systems and provided user controls.
  • Worked on JQuery scripts
  • Wrote queries, stored procedures, functions, and triggers in Sql sever 2005
  • Worked on CSS for good look and feel for the pages

Environment: Visual Studio 2008, Sitecore 6.1, XML, HTML 4.0, HTML5, Adobe Dreamweaver, JavaScript, JQuery, SQL Server 2005

Confidential, Urbana, Maryland

.Net Developer

Responsibilities:

  • Designed and Developed user controls in WPF using XAML in .Net Framework 4.0.
  • Designed the screens with rich UI using XAML in .Net framework 4.0.
  • Worked on VSS to maintain code history and for check in check out.
  • Wrote C# code for developing business logic using Visual Studio 2010.
  • Worked on delegates and event handlers in C# for passing the data from one screen to the other screen.
  • Worked on Grid controls, Group Boxes and stack panel lay out controls in WPF using XAML.
  • Worked on schema browser and editor in TOAD for Oracle 9.5 for database operations.
  • Wrote complex queries in Oracle.
  • Worked on datagrid operations in C# and XAML.
  • Extracted data from MS Access, Excel, Oracle and migrated into SQL Server 2005 using SSIS .
  • Developed reports using SSRS
  • Used 3rd party tool Visifire to generate the graphs and charts on the UI.
  • Designed and developed the application from scratch using Visual Studio 2010.

Environment: Microsoft Visual Studio 2010, .Net Framework 4.0, C# 4.0, WPF, XAML, XML, TOAD, Oracle SQL developer, Visual Source Safe, SSIS, SSRS.

Hire Now