Programmer Analyst/tech Lead/data Modeler Resume
Plano, TX
SUMMARY:
- Over Twelve Years of extensive experience in Analysis, Design and Development of web and client/server applications for various clients.
- Nine Years of Mortgage and Agile Experience.
- Proven ability in providing Subject Matter Expertise in all phases of the project development from requirements to implementation.
- Experience in designing the applications that meet both short term and long term business needs.
- Very Good experience in developing Internet, Intranet and Client/Server applications using VB.Net, C#.Net, ASP.Net, XML, XSL, HTML, Java script, VBA and VB script.
- Very good experience in writing stored procedures against SQL Server, MS - Access, Oracle back-ends.
- Strong Experience in designing database tables and ERs.
- Used version control tools Visual Source Safe (VSS), Clear Case, Subversion and PVCS.
- Wide exposure to developing multi-tier distributed applications.
- Experience in automating Ms-Word, MS-Excel and Outlook using VBA.
- Excellent experience in the areas of Design, Analysis and Development of Software Applications using MS-Access and MS-Excel VBA.
- Expert in building MS-Access front-end applications using MS-Access forms and manipulating them through VBA class modules.
- Familiar with Waterfall methodology and Agile methodology
- Worked on different business domains including Mortgage, Insurance, Education, and CRM.
- Ability to work in a dynamic, fast-paced environment.
- Proven team player with excellent communication and interpersonal skills.
TECHNICAL SKILLS:
.Net Technologies: C#.NET, ASP.NET, VB.NET, ADO.NET, Web Services, Web-forms, Win-forms and Ajax
.Net Frameworks: Microsoft Visual Studio 2.0/1.1
Languages: C, C++, VB, JAVA, SQL, XML, XSLT, HTML, DHTML & CSS
Database Technologies: SQL Server 2000/2005, MS Access 2000/2003, Oracle 8i/9i
Connection APIs: ADO.NET, ADO, ODBC, OLE DB
Markup Languages: HTML, DHTML, XML, XSLT, XSL
Scripts: Java Script, VB Script, DHTML
Version Tools: MS Visual Source Safe, PVCS, Clear Case, Subversion
Web Servers: IIS 6.0
Reporting Tools: Crystal Reports 8.5
Operating Systems: MS-Windows 98/2k/XP, Windows Server 2003 and Windows Vista
PROFESSIONAL EXPERIENCE
Confidential, Plano, TX
Programmer Analyst/Tech Lead/Data Modeler
Responsibilities:
- Estimate scope of work and LOE.
- Participate in Design Tollgate to get approvals from stakeholders like Domain Architect, Platform services and Integrated Production Support team.
- Design Process flows using MS-Visio.
- Work development changes for Director Scripts.
- Designed and developed various Excel, Access tools for calculating NPV using VBA, C#.
- Work with Agile scrum team for the product development.
- Update documentation and upload to Knowledge Link
- Participate in Pre Implementation Tollgate and provide all the artifacts to get sign off on Implementation.
- Coordinate with Implementation team for successful implementation by providing IT validation and business validation.
- Involved in various conversion projects.
- Involved in various pilot projects to convert current technology from VBA to blaze/Salesforce/MVC.
- Use Clear case, Subversion for version control of Director Scripts.
- Work on HPSM (HP service manager) for change management.
- Research on new solutions to provide effective solutions for business cases.
Environment: VBSCRIPT, C#, MVC5, API, VB.NET, MS-Access, VBA, MS-Excel, SharePoint, Version One, MS-Visio, BKFS MSP system, BKFS MSP Passport, Quality Center, HP Service Manager, Clear Case, Jenkins, GitHub.
Confidential, Columbus, OH
Application Developer
Responsibilities:
- Write procedures for Director Script naming, coding and code review processes.
- Director Scripts are VBScripts using Director Objects of Fidelity MSP system.
- Maintain development, test and production environments for Director Scripts.
- Serve as Director Script development SME helping the business design better Director Scripts from a technical point of view.
- Participate in design review meetings to insure that naming, coding, testing and documentation standards are met.
- Work with the business to help prioritize new Director Scripts.
- Migrate Director Scripts from development to SIT, UAT and finally Production.
- Support Migration tools developed through C#.NET, ASP.Net
- Write procedures for test script development process.
- Update Documentation and upload to SharePoint.
- Develop Director Script for MHA program/ Obama Plan which mainly includes plan break, plan setup for a home loan.
- Work with OLLW team to generate letters for MHA(Making Home Affordable) program.
- Extracting data from various sources (flat files, MS Excel, etc) for Automated Scripts using VBScript, VBA Macros.
- Used MS-Access to retrieve data from InfoOne (Oracle Client).
- Develop scripts to analyze the scripts usage for all the orgs hChase, hWamu, and hEMC.
- Work with Control-M on EDGE applications for all the orgs.
Environment: Visual Studio 2003/2005, C#.NET, ASP.NET, PVCS, XML, VBSCRIPT, MS-Access, VBA, MS-Excel, SharePoint, Info One (Oracle client), MS-Visio, Fidelity LPS MSP system, Fidelity MSP Passport, Quality Center, AHK, Windows Script Component.
Confidential
Application Developer
Responsibilities:
- Worked as part of the CIS applications.
- Worked on the EDI processing.
- Designed and developed the user interface using VB.NET, involved in implementing the code according to the business logic.
- Developed Mid-tier components using VB.NET
- Developed SQL Sever stored procedures to execute the back end processes.
- Handled Source code management using Visual Source Safe.
- Instrumental in developing the CC/DD Processing, Prior Period adjustments, Change of ownership functionalities.
- Providing Subject Matter Expertise in analyzing requirements for project development as well as service requests.
- Used MS-Access to retrieve data from SQL server and created and maintained the MS-Access database.
- Providing day to day support to the business area from an IT stand point.
Environment: Visual Studio 2003/2005, VB.NET, ADO.NET, Visual Source Safe, XML, SQL Server, MS Access and Windows XP.
Confidential
Web Developer
Responsibilities:
- Made use of ASP.NET for writing front end of application, deployed server controls throughout the project.
- Developed all the required stored procedures, user defined functions, triggers.
- Customized the data grid column by implementing hyperlink column to pass multiple queries to new page.
- Involved in Unit testing and functionality testing.
- Configured ASP.NET web.config file for the entire web application.
- Implemented Validation using JavaScript and Validation controls for alerts.
- Created CSS Files to maintain consistent look and feel across the website.
Environment: ASP.NET, C#.NET, ADO.NET, SQL Server 2000, JavaScript, VBScript, Visual Studio .NET, Visual Source Safe, Windows 2000.
Confidential
Windows Developer
Responsibilities:
- Participated in Requirements Gathering from Business users.
- Participated in the development of the Prototype.
- Developed Win Forms with VB.Net using MS Visual Studio.
- Created Tables, Functions, Views, and Stored Procedures using SQL Server.
- Implemented Validation using Validation controls.
- Unit testing of each module.
Environment: VB.NET, SQL server 2000, Visual Studio .NET, Visual Source Safe, Windows 2000.
Confidential
Programmer
Responsibilities:
- Involved in requirements gathering and acted as coordinator between the management and the development teams.
- Responsible for fulfilling the component requirements for student and staff modules using COM components.
- Developed stored procedures for the oracle back-end to implement part of the business logic and optimize performance.
- Involved in designing the ASP pages and writing the code for server side processing.
- Involved in configuring and administering the IIS.
- Supervised and involved in the testing of the application.
Environment: ASP 2.0, ADO, VB Script, JavaScript, IIS, Oracle 8.0 and Windows NT.
