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.