.net Web Api /advanced Programmer Analyst Resume
Louisville, KY
SUMMARY:
- 12+ years of experience in designing, developing and implementing database, web /Windows applications, and business data analysis using Microsoft Technologies, C#, SQL Server, and OOAD methodologies.
- Expert in C#, MS SQL Server, Web API/ Services: WCF and REST, SSRS, SSIS, Business/ Data analysis.
- Development experience in Web API, SSAS, MVC, Entity Framework, ASP.NET, ADO.NET, XML, XSLT, SOAP, HTML, CSS, JavaScript, AngularJS, R.
- Revised business performance metrics in collaboration with IT, hence increased transparency.
- Improved performance of SQL Databases by fine tuning and optimization of database objects such as stored procedures, indexes, views and functions.
- Architecture experience using Object Oriented Software Design best practices, SOLID Architecture, Design Patterns and Software Framework Development.
- Implemented and Enhanced business and data layer architecture and code performance. Performed code review and document
- Practical understanding of the Data modeling for Dimensional & Relational databases.
- Completed web applications/ web services development projects with unit/ system testing and Agile/ Scrum, Software Development Life Cycle (SDLC), providing code maintenance services and pertinent database upgrades.
- Successfully applied exceptional analytical skills to simplify business analysis, as well as identified and resolved technical challenges through effective problem solving.
- Demonstrated excellent communication skills in customer service interactions, hence improving customer experience.
- Showed proven skills to communicate clearly, with development team, as well as across Dev, QA and Business teams. Utilized mentoring experience for effective team building effectiveness.
TECHNICAL SKILLS:
Programming: C#, SQL Server, Oracle, R, CSS, HTML, C, Java, JavaScript.
Framework, Packages, Tools: Microsoft .Net Framework 2.0/3.5/4.0/4.5, DevExpress, Telerik, AngularJS, Web API, SSIS, SSRS, SSAS, ASP.NET with C#, ADO.NET with C#, MVC, XML, XSLT, WCF, RESTful, Erwin, Tableau, QTP, AWS ECE/S3/IAM/RDS/VPC, LINQ, MATLAB, jQuery
Operating Systems: Microsoft Client & Server Operating Systems, Linux
Networking: Cisco Routers, Network Security, LAN/ WAN Technologies
Team Collaboration / Other Tools: MS Visual Studio 2008, 2013, 2015, TFS, VSS, TeamForge, MS Visio, GitHub, JIRA, SharePoint, MS Office, Service - now
PROFESSIONAL EXPERIENCE:
Confidential, Louisville, KY
.Net Web Api /Advanced Programmer Analyst
Key Achievements:
- Develop features using Microsoft C#, .NET framework 4.0 and 4.5, Entity Framework and Web API to integrate Deals, volume management, invoice and billing
- Design and develop complex data reports to enhance user experience, and support invoicing/ billing. Created Win forms using C#.NET, DevExpress to enhance RBS.
- Implemented unit testing process, delivery team testing and defect resolution processes to improve business experience.
Confidential, Dallas, TX
Sr. Technical Lead/ Sr. Analyst
Key Achievements:
- Enhanced business data visualization for the weekly Directors' presentations.
- Optimize data load/ transform process by using bulk insert, ETL feed and by utilizing SQL Server SSIS for valuations project. Used ‘R’ to cross verify field data correctness.
- Utilized SSAS to perform data analysis for monthly reserves with Comp load/ AXIS process. Implemented various balancing reports on SSRS server for analysis and comparisons.
- Designed and Implemented dashboard using C#/ Entity Framework/ SQL Server/ MVC/ LINQ/ AngularJS/ .NET 4.5 to monitor job cycle progress/ maintenance of monthly production cycle of Valuations project.
- Provided L3 production support on multiple applications, including r-Pay, Valuation and CT-1035. Extensively utilized service-now to manage Incidents, problem management, Change Control Management.
- Implemented staging and ETL processing of the data between SQL Server and Oracle Datawarehouse.
Confidential, Sunrise, Florida
Senior Software Engineer
Key Achievements:
- Performed demos to key stakeholders and prospective new/ existing clients.
- Applied strong business and data analysis skills to bridge gap between business and technology teams, to fulfill business requirements and architectural model.
- Led production support team and provided L2/L3 production support to enhance business user experience, and also to improve productivity.
- Improved QA and UAT processes to increase efficiency and greater transparency.
- Delivered WCF/ REST web services / web applications implementations using C#/ASP.NET, SQL, with third party vendor applications, for data transfer/loan data processing/ship services, hence providing seamless integration, document generation and fulfillment.
- Enhanced SQL Server database structures and stored procedures to greatly improve search performance
- Used Erwin to architect AuthoRecord (a multi-tier Web application) DB design and standardization. Created data mapping objects by combining multiple source/ destination systems to meet system specifications.
- Created and managed data migration program with occasional upgrades/ enhancements.
- Implemented Production Dashboard using Tableau for data analysis/ representation.
- Designed and Developed IntelliAdmin web application using C#/ SQL Server and Telerik web controls. Applied usability enhancements to load Telerik UI web controls dynamically.
- Utilized various version control tools such as GIT, TFS to implement continuous integration/ deployments.
- Created and reviewed technical specifications, technical design and analysis documents.
- Implemented DocGen DMS system using cloud integration (AWS EC2/ S3). Briefly used VPC, CloudWatch, IAM, and RDS for setup of the cloud environment.
Confidential, Pompano Beach, Florida:
Software Developer
Key Achievements:
- Created data migration scripts using Microsoft SQL Server to provide support for data consistency, upgrade and reporting.
- Effectually applied data layering skills to enhance data mapping, transport and manipulation using C#.NET, XML and XSLT. Enhanced PPfA (Product Profile for Annuities) application UI screens utilizing jQuery UI to implement data validations and presentation.
Confidential, Sunrise, Florida
Research Assistant, Intern
Key Achievements:
- Developed and enhanced stored procedures.
- Implemented geo tools web application for evaluation of DTD (Drive Test Data) using C#/ SQL Server.
- Developed automated testing scenarios for mobile devices using QTP.
