PREETI

Software Engineer specializing in object-oriented design and analysis with extensive experience in complete Software Development Life Cycle SDLC process including documentation, design, development, testing and maintenance of Standalone and Intranet/ Internet based applications.

SYNOPSIS

• 8 years of experience in analysis, design and development of software applications new/ redesigns/ rewrites
• In-depth knowledge and experience in software application security
• Demonstrated knowledge of complete SDLC process, standards best practices, versioning and version control using TFS
• Knowledgeable in stress testing and performance monitoring
• Experience in requirements gathering, technical support, performance optimization, and follow up / troubleshooting
• Experience in development of various Microsoft Dynamics products and Sage ERPs
• Proven ability in identifying improvement opportunities, refactoring the code, and implementing creative solutions
• Diligent in system integration and database connectivity
• Strong skills in technical documentations, service documentations, and process flows
• Proficient in thorough unit testing using Visual Studio Unit Testing Framework
• Strong experience of working on multiple complex projects
• Ability to work in a team with cultural and geographical diversity, with tight deadlines
• Experience of working in Waterfall as well as Agile environment
• Excellent in communication and building Team Spirit

TECHNICAL SKILLS

• Langages: C, C , X
• Database: SQL Server 2014/ 2012/ 2008 R2/ 2005
• IDE: Visual Studio 2013/ 2012/ 2010/ 2008, Morph X
• Web Technologies: HTML5, XML, ASP.NET MVC, Web Forms, JavaScript, Razor, JQuery, WCF, WPF, CSS, Entity Framework, SOAP/ REST Services, Web API
• ERP: Microsoft Dynamics - AX, GP, NAV, SL Sage MAS 90/200, MAS 500, AccPac
• Third Party Tools: Business Connector for AX, XML-Spy, DevExpress controls
• Version Control: Visual Studio TFS
• Testing Tools: MS Visual Studio Unit Testing Framework
• Others: Agile, Rally, LINQ, Fiddler, MS Visio, WINMERGE

EXPERIENCE

Confidential

Confidential is a complex online research project for developing an application for Sales Tax Rates and decisions. It puts up-to-date Tax Rate and Taxability details with the capability to customize the view of information, based on user's physical locations and stock keeping unit.

Responsibilities:

• Analyze user stories in Rally and estimate time to complete the tasks
• Design tables in SQL Server 2012
• Write service methods in C to retrieve/insert data into the database
• Design UI using ASP.NET MVC 4.0, DevExpress controls
• Write unit test methods and analyze code coverage using Visual Studio 2010
• Perform system integration testing, Coded UI testing
• Create detailed Technical Design document, Service document and Process flow chart
• Lead the Deployment and Customer Support activities

Environment: ASP.Net, MVC 4.0, JavaScript, .Net Framework 4.0, C .Net, Code First Entity Framework, T-SQL, XML, Visual Studio 2010, Visual Studio Team Foundation Server, SQL Server 2008 R2 / 2012, Visual Studio Unit Test Framework

Confidential

Project Management

It is a mega project spanned over multiple years, involved processing and loading confidential data into seven different ERPs Confidential CCH tax data into the appropriate format and transfers it into different ERP Systems. It provides different parameters/settings based on which data is imported into ERP. STLU consists of two main executable components and a Vendor Class Library.

Responsibilities:

• Analyze ERP modules and Database tables in SQL Server 2008
• Design UI using WPF, DevExpress controls
• Integrate core and peripheral IT systems and generate database connectivity
• Download monthly Sales Tax data from Zip Product Manager ZPM into text files
• Read text files and load the data into intermediate database called DLU Data Logic Unit
• Import this data into different ERPs based on different options and categories
• Use Business Connector to load the data into AX and use SQL Scripts to load the data into other ERPs
• Execute stress testing and performance monitoring
• Write unit testing code, perform system integration testing
• Create installer using InstallShield 2011
• Create detailed Technical Design Document

Environment: ASP.Net Web Forms, .Net Framework 3.5, C .Net, ADO.NET, T-SQL, XML, Visual Studio 2008, Visual Studio Team Foundation Server, SQL Server 2005 / 2008 R2, Visual Studio Unit Test Framework

Confidential

This tool is developed for the QA team to compare the Actual versus Expected results for web-service methods. That way in future if the actual results change, then those would be shown as a failure in ST3 and would give an opportunity to report the issues and fix them.

Responsibilities:

• Design the tables in local SQL Server Database
• Create XML input for web-service methods
• Write C code to read the XML input parameters, send it to web-service methods and get the results back. Store the input and actual output in the corresponding tables.
• Write the program to compare the actual and expected data, and show the difference in WINMERGE tool

Environment: ASP.Net Web Form, JavaScript, .Net Framework 4.0, C .Net, LINQ to SQL dbml , T-SQL, XML, Visual Studio 2012, Visual Studio Team Foundation Server, SQL Server 2008 R2

Confidential

This is a rewrite project. Original STO is a standalone application developed using PLEX UI. This rewrite involves two modules. It allows the users to communicate with the Calculation Engine to perform particular tasks within the STO application e.g.: calculation of tax liability, finding the geo-block for addresses, etc. . The end user consumes web-services for these tasks.

Responsibilities:

• Gather requirements, create user stories and estimate time to complete the tasks
• Design tables in SQL Server 2014
• Write service methods in C to retrieve/ insert data into database
• Design UI using ASP.NET MVC, JQuery, DevExpress controls
• Write unit tests methods for testing and analyze code coverage using visual studio 2013
• Coordinate for Deployment and Customer Support
• Create detailed Technical Design document, Service document, and Process flow chart
• Implement and test application security against risks such as SQL Injection, Cross Site Scripting, Insecure Cryptographic Storage, etc.

Environment: ASP.Net, MVC 5.0, JQuery, JavaScript, Razor, .Net Framework 4.5, C .Net, Code First Entity Framework, T-SQL, XML, Visual Studio 2013, Visual Studio Team Foundation Server, SQL Server 2012/2014, Visual Studio Unit Test Framework

Confidential

This project is intended to insert the Rally data Confidential into local database using Rally Rest API. It is developed to generate reports for detailed project tracking, generating cost estimates and comparing the estimates with actual values as the work progresses.

Responsibilities:

• Design the tables in local SQL Server database to transfer the data from Rally database
• Develop the code in C using Rally Rest API to generate various complex reports to sort the Issues per category, such as Open, Closed, Suspended, Active, WIP, and Priority Date
• Refresh the data programmatically real time and calculate the delta per day and per week/ month
• Create intuitive dash board for higher management to represent the data graphically
• Develop similar programs to sort the Rally Tasks based upon attributes such as Severity, Date of Origin, Created by, Assigned to, Closed on, and Attachments. Generate reports
• Also develop similar program for sorting and updating the records for User Stories based upon their Complexity, Iteration level, Status Open, WIP, Completed , Dependencies, Hierarchy, Test results Accepted, Rejected, In QA
• Perform unit testing

Environment: ASP.Net Web Form, .Net Framework 4.0, C .Net, Code First Entity Framework, T-SQL, Visual Studio 2012, Visual Studio Team Foundation Server, SQL Server 2012, Visual Studio Unit Test Framework, Rally Rest API

Confidential

Responsibilities:

• Analyze AX modules and determine work flow to support tax calculations
• Design UI, table structures and class structures
• Develop API and library in C
• Write code in X
• Create utility for stress testing
• Create installer using InstallShield 2008
• Create detailed Technical Design document

Environment: Microsoft Dynamics Axapta, Morph X, X , C , ASP .NET Web Forms, InstallShield

Confidential

Production Support

• Providing production support for the existing tools, gathering information on the issues from the user in order to understand and root cause the issue, providing on time resolutions, managing escalations, contacting various teams involved in the escalation and sending hourly status report for Priority 1 and 2 P1/P2 issues.
• Generating the support matrix report using BO Business Objects and presenting it to the IT manager to show the graph of case reductions on monthly basis.

Enhancements

• Identifying the code changes which lead to the support issues, performing analysis and root cause, presenting the proposed changes to various boards for approval, involved in creation of the deployment patches for production code changes, ensuring that the deployment to the production environment is successful, post IT testing and coordination with customer other cross functional teams to perform end-to-end testing
• Involved in the oracle 11i migration for OPUS tool It is a Cisco customized tool which is used to create/update the item attributes in ERP . In oracle 10.7 the pricing database was in manufacturing, but due to 11i changes, it is shifted from manufacturing database to the Order Entry database. Enhanced the tool to perform these pricing changes within a short period of time and delivered the code with zero bugs.
• Involved in identifying the existing bugs in the system, worked on the root cause and responsible to provide a report to the customer specifying the estimated time to fix these bugs with the number of resources required for each tasks.

Coordination

• Interfacing with customers to capture their requirements /expectation, resolving project related issues by ensuring high quality customer deliveries and active participation in code and documentation review.
• Monitoring the projects for timely completion through weekly reports.
• Monitoring defects and improvement steps towards defect prevention.
• Managing customer relationships to win repeat/new business.
• Conducting feasibility study for new proposals, and working on new proposals.
• Knowledge sharing by training other team members.

Environment: Oracle 7.x/8.x, SQL Plus, PL/SQL, SQL Loader, Forms 4.5/5.0/6.0, Remedy,

Reports 2.5/3.0/6.0, Oracle Applications 10.7/11/11i INV, BOM, WIP ,