ASTHA PANDEY
*********.****@*****.***
“Looking only for Corp 2 Corp Jobs”
SUMMARY:
Over 7 years of extensive experience in Analysis, Designing, Development, Testing, Bug fixing, Documentation and Implementation of Client/Server and Web Technologies for various N-Tier applications.
Proficient in all phases of requirement management including requirement gathering, analyzing, documenting and tracking.
Expertise in .NET framework with great proficiency in creating applications using Web Forms, ASP.NET, C#/VB.NET, ADO.NET, XML, AJAX, AJAX toolkit, Cascading Style Sheets (CSS), JavaScript, WCF, WPF, IIS7.0, SQL Server 2000 / 2005 /2008 /2008 R2, LINQ, and Visual Studio.NET
Extensive experience web based GUI Development using Angular JS, HTML, JavaScript, CSS2, CSS3, User Controls and Master Pages.
Proficient in developing Service Layer using ASP.NET Web services, Windows Communication Foundation (WCF).
Experience in application development using C#, Web Forms in ASP.NET using C# as the code-behind language and Windows Forms.
Proven technical expertise in analysis, design, development, and implementation of web and client server application applications using Microsoft Technologies –MS BI (SSRS, SSIS and elementary knowledge of SSAS), C #.Net, ASP.NET, VB.NET, MVC 5, and WCF.
Experienced in Service Oriented Architecture (SOA) using WCF.
Strong knowledge and working experience of Web Programming using JavaScript, JQuery, VBScript, HTML, AJAX and CSS.
Extensive experience in writing Database Queries, stored procedures, functions using MSSQL SERVER 2005/2008/2012 Relational Databases and triggers.
Involved in Data Analysis, Logical & Physical Design, Data Integration and creating Database objects with both ORACLE and SQL server.
Good Experience with Unified Modeling Language (UML) standards and documentation and experience in preparing Use Case Diagrams, Class Diagrams, Sequence Diagrams and Activity Diagrams using design tools such as Microsoft Visio.
Experience in Reporting Services: Microsoft SQL Server Reporting Services (SSRS) & Crystal Reports.
Extensive Experience in ETL services and SSIS.
Experienced at writing business requirement documents, functional specification documents and detailed design documents.
SKLLS:
Languages
ASP.Net, C#.Net, VB.Net, PL/SQL, JAVA, C, C++, VBScript, JavaScript, JQuery, JSON
Web Technologies
Web Service (WSDL), SOAP, AJAX, JavaScript, HTML, AJAX, CSS, Content Management System.
Middle-ware
ADO, ADO.NET
.Net Technologies
.Net Framework, ASP, ASP.NET, C#, WPF, WCF, LINQ
IDEs / Web Server
Visual Studio, IIS
Reporting Tools
SSRS, Crystal Report 6-10.
Version Control System
Visual Source Safe (VSS), TFS.
Operating Systems
Windows
RDBMS
SQL Server.
EDUCATION
Masters in Analytics, Harrisburg University, USA (Coursework: Data Mining, Data visualization, Risk Modelling and Analysis, Sentiment Analysis and Big Data Architectures.)
BTech in Information Technology, Nirma University, India
CERTIFICATION
Certified for MCTS 70-536 Microsoft .NET Framework, Application Development Foundation
Certified for MCTS 70-562 Microsoft .NET Framework 3.5, ASP.NET Application Development
EXPERIENCE:
Client: JPMorgan Chase, NY Oct 17 - Till Date
Role: .Net Developer
Description: Open Online Account project designed and developed for users who wish to open account online and bank associates to process applications at bank. User needs to provide Social security number and other required details to open account. Once user identity verified account would be opened otherwise user need further verification process at nearest bank location.
Involved in various phases of SDLC including requirements gathering, design, development, testing and documentation.
Upgraded ASP.NET 2.0 Web Projects created in .NET Framework 2.0 and VS 2005 to ASP.NET 4.0 using .NET Framework 4.0 and VS 2010.
Implemented MVC architecture to accomplish task of isolating Business Layer, Presentation Layer and Data Layer.
Developed Business Logic components in middle tier using C# and created complex business components in C#.Net using .Net Class Library assemblies.
Developed Web Forms for User Interfaces using ASP.NET with Server Controls, HTML Controls and User Controls.
Extensively Used. ASP.NET 4.0 controls like Master Page Templates, Menu Controls, Grid View Controls and File Upload Controls.
Developed the application using MVC frame work, Bootstrap, MVVM and WCF.
Built various types of reports such as Table, List, Matrix reports using Visual Studio 2010 and displayed them on ASP.NET 4.0 Web Forms using Report Viewer Control.
Used validation techniques and Java Script, JQUERY for User Input Validations.
Extensively JavaScript for UI interaction, XML for data transmission via WCF services and data manipulation using LINQ.
Used Cascading Style Sheets (CSS) to attain uniformity of all web pages.
Created and consumed WCF services which are based on SOA architecture. Used Basic Http Binding for binding purposes. Worked on WCF security.
Used AJAX Controls and WPF for Effective Look and feel of the web portal. Developed Win forms using WPF and XAML.
Used Entity Framework and LINQ as part of DAL layer.
Created new web pages using HTML, CSS, XML and Java Script.
Designed and developed using java script libraries like Angular.js.
Used Team Foundation Server (TFS) as a source control repository and for creating user stories to enhancements, bug tracking and tasks to enter time estimates.
Used Microsoft Visual Source Safe (VSS) for the purpose of version Control and source code maintenance needs.
Created complex Views, Store Procedures and user defined functions using SQL Server 2008 and designed reports using Crystal Reports.
Deployed the system to the production server and effectively involved in trouble-shooting various issues in production.
Environment: ASP.Net 4.0, C#.Net, Ajax, WPF, WCF, Visual Studio 2012, HTML, Angular.js, LINQ, XML, Action script, CSS, JavaScript, JQuery, N-tier, TQSL, SQL-Server 2008, Windows.
Client: WellPoint, Norfolk, VA Apr 16- May 17
Role: .Net Developer
The application solution that provides the tools to manage the submission of applications for a new health insurance. The built-in controls supply various functions to ensure that data is clean and in order before the submission process. The main objective of the package is to provide customers with the options either to apply online or via a call center. The package was mainly directed at automating the decision process for the new policies. This involves less underwriting time, obtaining the complete health history of the applicants required for the decision process.
Developed solutions for diverse programming scenarios in C#, employing Object Oriented Programming (OOP) concepts.
Worked on C# (4.0), .NET, MVC (4.0), Angular JS, HTML5 for developing various tabs in the * Used Entity framework CODE FIRST to improve the overall performance of the application.
Designed and developed SOA architecture with WCF binding concepts for making data binding for end points.
Developed Web Application in ASP.NET MVC 4.0 razor view engine, ASP.NET with C# as code behind Angular JS, is used for client side validation.
Used Oracle PL/SQL for implementing business rules and do performance tuning procedures.
Maintained version control and code review using TFS.
Used AngularJS as the development framework to build a single-page application.
Developed Razor views with strongly typed view models and helpers and partial views using ASP.NET MVC4, CSS3 and C #.
Used SVN for Version Control.
Managed online content, performed editing and proofread all content. Developed, maintained and evaluated content for website.
Analyzed web content summarized it and documented results for website users.
Implemented Partial views (user controls), Master Pages, Strongly Typed Views and Complex Views.
Implemented Get, Post, Put, delete by using Controller actions and Caching by using Action Filters and Child actions in Controller and return Razor HTML to View through Action Results.
Leveraged Angular JS for scripting, AJAX calls and JSON and XML for passing objects from Controller to View and vice versa.
Used JSON to transmit data between Server and Web Application, an alternative to XML Serialization.
Implementing LINQ queries on different data sources in Silverlight applications.
Created packages using Integration Services (SSIS) for data extraction from Flat Files, Excel Files OLEDB etc. to Access etc.
Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
Used Team Foundation Server (TFS) for source control and documented the entire application.
Created test plans and performed unit and regression testing on the application.
Environment: VisualStudio2012, C#, ASP.NET MVC 4.0/ 3.0, WCF, Entity Frame Work 6.3/4.0, Java Script, Angular JS, TFS 2012, WCF, ADO.NET, LINQ,, PL/SQL.
Client: Bank of America (Infosys Ltd) Sep 12 – Oct 13
Role: ASP.NET Developer
Port view Trading - Maintenance
Port view is the Wealth Management suite of applications used by Portfolio Managers of US Trust line of business of Bank of America.
The core application is called Portview Trading which is a trade initiation platform that interacts with various systems like PACE (Trust Accounting Platform), IPS Plus (A repository of Clients’ investment policies, Comp ARS (review system), etc.
Interfaced between Business and the IT tech teams to facilitate communication between the two departments.
Documented Business Requirements Document and prepared use cases.
Developed the data layer class, Business layer class using C# which is reusable for data transactions of entire project.
Developed data flow diagrams, illustrating the flow of data from the Legacy systems into the Application Database Tables, along with checkpoints for testing / verification.
Preparing estimates for some requests.
Implemented UI Design using HTML and CSS.
Development and enhancement of small basic SSIS packages.
Enhanced VB .Net Windows application (with Syncfusion controls) and simple ASP. Net web sites (with Infragistics controls).
Developed Web Services, MS SQL database stored procedures, SSIS packages.
Involved in the generating reports using Crystal Reports.
Maintained close communication with UI/UX team to enhance product quality.
Provide support during onshore User acceptance testing phase.
Responsible to provide system support once the code is migrated to Test, QA or Production environments.
Deployment of Application on Test and Production Server.
Environment: SQL Server 2005, Crystal Reports, SSIS, ASP.Net with VB.Net, HTML, JavaScript.
Bank of America (Infosys Ltd ) Oct 10 – Aug 12
ASP.NET Developer
Port view is a streamlined relationship and account management application that supports all the mechanics of portfolio management such as account, investment and relationship management, trading, and client reporting.
Actively involved in High Level Design and Architecture framework of the application.
Captured requirements by directly interacting with the client.
Planning and estimation of the individual tasks associated with each requirement.
Implemented the front-end screen using ASP.Net controls, HTML & CSS for improved look and feel of the screens.
Development using C#, WCF, SQL server and various client side scripting.
Responsible for writing CSS and HTML.
Ability to design web pages and handle CSS and JavaScript code.
Implemented the code using C# as code behind and ADO.NET for connecting to the SQL Server database.
Developed the data layer class, Business layer class using C# which is reusable for data transactions of entire project.
Involved in Creating Views, Triggers, Constraints, and Normalization at the Data Access Layer.
Implemented page level error handling using Custom Error pages and Error logs.
Implemented various Validation controls for client-side validation of Server Controls.
Performed Unit Testing, Integration Testing and Regression Testing of the application.
Actively involved in Bug Fixing during the build and deployment process and debugging.
Environment: ASP.NET (C#), SQL Server 2005, Web Services, SSIS, MVC Framework, HTML, JavaScript.
Toyota, India (Infosys Ltd ) Sep 09 – Oct 10
ASP.NET Developer
Dashboard was created to automate the reporting task followed by Toyota Motors Europe. The whole project was divided into two phases. The first phase consisted or numerous tabular and graphical reports developed using SSRS. Similarly, the second phase had many tabular/graphical reports. The ETL part was developed using SSIS.
Direct interaction with the client to understand the business requirements.
Design and Implementation of optimized scripts for various data requirements as back end for SSRS based Reports.
Organizing the internal Knowledge Management team which equipped the team with crucial technical and business tips to enhance quality.
Handling weekly meetings with clients.
Extracted data from internal data warehouse system to SSRS.
Scheduled jobs to execute SSIS packages which were developed to update database objects daily and maintained nightly loads of data by creating the corresponding tasks.
Created SSIS packages to export and import data from CSV files, Text files and Excel spreadsheet. Involved in installation, configuration and developing of SSIS packages using BIDS.
Extensively using joints and sub-queries for complex queries which were involving multiple tables from different databases. Analyzing data and re-mapping fields based on business requirements.
Store procedures, User defined functions, Views, T-Sql scripting for complex business logic. Optimized the database by creating various clustered, non-clustered indexes and index views. Using aggregate strategies to aggregate data, sorting and joining tables.
Developed cubes by identifying tables (fact and dimension), Data Source and Data Source Views, attributes, dimension members, calculation, actions, partitions and perspective using SQL Server Analysis Services 2008R2 to analyze data based on sales information.
Generated various Monthly, Quarterly, Bi-Yearly, Yearly reports by different type of reports using SSRS.
As part of the development process, has exploited various features provided by SSRS such as Sub Reports, parameters, sorting, grouping etc.
Pitching in and fixing the urgent production issues which needs immediate assistance.
Used Team Foundation Server (TFS) extensively for unit testing and constant integration.
Environment: SQL Server Reporting Services, SQL 2008, SSIS, ETL services, HTML, CSS, JavaScript.
Infosys Ltd Internal Project -Product based May 08 – Aug 09
ASP.NET Developer
Supply Chain Risk Management (SCRM) is a discipline to pro-actively identify and manage risks in the supply chain network and minimize the damage for the focal organization. It is a tool conceptualized and developed for managing all phases of risk management process in supply-chain. This covers modules for Identification of risks, Assessment of Risk impact and Mitigation of risk.
Direct interaction with the client to understand the business requirements.
Development of web using C MVC5/MVC4 ASP.Net XML in Microsoft Visual Studio IDE.
Developed User Interface pages using ASP.NET Web Forms, Web Server controls and custom user controls, HTML, XML, CSS, and JavaScript.
Constructed CSS based layouts and worked with JavaScript.
Used XPath, Xml Node to access files and used Datasets to read XML files.
Unit and integration testing for the product.
Used ASP.NET validations as well as developed custom validations using JavaScript in this application for validations.
Development and testing for urgent requirements like bug fixes etc.
Pitching in and fixing the urgent production issues which needs immediate assistance
Preparing estimates for some requests.
Performed stringent reviews and testing on the code.
Co-ordinated and assigned work to different team members and monitored the progress of work.
Environment: ASP.NET, MVC5, SQL Server 2008, C#.net, ADO.Net, IIS, SSRS, Enterprise Library, HTML, JavaScript.