SUMMARY OF QUALIFICATIONS:
Over * years of professional experience in Software Development Life Cycle (requirement analysis, software design/development and maintenance) with high degree of efficiency.
Proficient in developing n-tier applications conforming to Service Oriented Architecture utilizing Windows Application, Web Services and Windows Services in .NET Framework using C#, VB .NET, Visual Studio, ASP.NET, Entity Framework, LINQ to SQL, RESTful API, ADO.NET, XML, XSLT and SOAP.
Experience working with ASP .NET MVC, Web API, Web Form, Web Page
Experience with Identity Server 3 framework, oAuth 2.0, OpenID connect protocol
Experience on troubleshooting using Fiddler, Remote Debugging, IDE, browser dev tools
Experience on working with Windows Communication Foundation (WCF), and Windows Presentation Foundation (WPF)
Experience in Administration, Maintenance and Development of Reports using SQL Reporting Services (SSRS), SQL Integrating Services (SSIS), Microsoft Reporting and Crystal Reports
Proficient in writing efficient SQL Queries, Stored Procedures, Triggers, Functions, Types and design of Normalized Database back end and middleware technologies like ADO.NET, ODBC, SSIS
Strong knowledge in Agile/SCRUM, TRIBE/Squad methodologies. Coordinated with the developers, monitoring project progress and development using SCRUM methodologies.
Excellent communication and interpersonal skills, self-motivated with ability to handle multiple projects and meet tight deadlines
TECHNICAL SKILLS:
.NET Technologies
ASP.NET, .NET Core, C#, VB.NET, ADO.NET, ASP.NET MVC, LINQ, WCF, WPF, Web Services
Programming Languages
C#, VB, Python, Java
Databases
MS SQL Server 2012/2008/2005, Oracle 10g, 11g XE, MySQL, MS Access
NPM
NodeJS, Nuget
Debugging
IDE, Browser Development Tool, Remote debugging
Scripting Languages
JavaScript, VB Script, jQuery
Markup Languages
HTML, XHTML, DHTML, XML, XSD, DTD, XSLT, CSS, AJAX
GUI Frameworks
MVC, Web Form, Win Form, WPF
Design Technique
MVVM, MVC, SOLID
Web/Application Servers
IIS Express/7/6
Design Tools
SharePoint, Microsoft Expression Blend, Microsoft Visio, Dia
Other Tools
Expression Blend, Expression Design, Crystal Report, CruiseControl, MS Project, MS Excel, VersionOne, Citrix, VMWare
BI Tools
SSIS, SSRS
TDD Tools
nUnit, JUnit, MSTest
Version Control System
GIT, TFS, SVN, Visual SourceSafe
IDEs
Visual Studio 2019/2017/2015/2013/2012/2010/2008/2005, SQL Server Management Studio 2012/2008/2005, Eclipse, WebLogic, TOAD 9.7.2, Oracle 10g XE
Operating Systems
Windows 10/8.1/7/XP/Windows Server 2012/2008/2003 R2, Linux
Collaboration Tools
Microsoft Lync, Skype, Team Viewer, Citrix WebEx, AT&T Interwise
PROFESSIONAL EXPERIENCE:
Avantax Wealth Management – Irving, TX
Sr. Software Engineer (May 2016 - Present)
Project: myAvantax Feature Parity (Dec 2019 – Present)
The purpose of this project is to add/remove features that got missed during the Repoint process as a result of company merger.
Job Responsibilities:
Disable Outside Assets, Create/Update a plan feature from myAvantax portal and related back-end jobs/services
Implement advisory fee calculator in myAvantax portal for legacy 1G advisors
Project: RMS Aspire (Oct 2019 – Dec 2019)
The purpose of this project is to allow legacy HDV advisors and any new advisor to be able to use legacy 1G system for RMS billing process.
Job Responsibilities:
Onboard legacy HDV advisors on legacy 1G system using Pivotal CRM system
Modified back-end process for data feed restrict data flow from legacy 1G to legacy HDV to avoid data duplication
Created SQL script to bulk update flag for Contact and Company records in Pivotal
Made minimal code changes to use existing RMS system
Environment: .NET Framework 4.6, VS 2019, C#, MVC, SQL Server 2012, Windows 10.
Project: Repoint (Jul 2019 – Oct 2019)
The purpose of this project is to allow financial advisors to be able to manage client’s account using a single platform. Any kind of account from brokerage to direct can be created in a few steps and manage from within the application. All data integrity and syncing happens in real-time. The repoint is the project to integrate products from 1st Global and HDVest to become one single business operating company.
Job Responsibilities:
Rebranding of Portfolio and 1040 Analyst functionalities and reports to meet company guidelines in Advisor Portal application.
Implemented Sass to generate stylesheet for rebranding various reports.
Rebranded new account, change account, 3 years, customer change and address change letter templates for Books and Records application.
Implemented Single Sign On in Advisor Portal application for users to be able to use legacy 1st Global application.
Rebranded legacy 1st Global reports in various application like IMS Rocks, Advisor Compensation System (ACS), Retirement Management System (RMS) and Global Access Reports.
Environment: .NET Framework 4.6, VS 2019, C#, MVC, Web API, EF, SQL Server 2012, LINQ, eMoney, Rotativa, Windows 10.
1st Global Research and Consulting – Dallas, TX
Sr. Software Developer
Project: Retirement Management System (Jan 2019 – Jul 2019)
RMS (Phase II): The purpose of this project is to enhance the current Retirement Management Solutions (RMS) infrastructure to efficiently and accurately manage plan information, as well as accurately calculate and process RMS fees for all existing and new vendor relationships and plan fee schedules. RMS allows financial advisors to manage their client’s retirement account. Designed and developed RMS application with notion in mind to make it simple, flexible, extensible, and configurable.
Job Responsibilities:
Designed and developed RMS application to help advisors manage client’s data
Created new section in Web Admin to host RMS application
Created separate module for managing plan, participant, vendor, import, fee calculation, invoice, statements, payment and reports.
Created UI for managing RMS modules using kendo custom controls
Implemented user permission based on Windows Active Directory (AD) groups
Implemented messaging queues using RabbitMQ to publish and consume messages for Invoice and Statement functionalities
Implemented Swagger for Web API to auto generate documentation and built-in UI for testing API methods
Created Windows services for consuming messages queued from UI through RabbitMQ
Implemented Unit test throughout the application
Environment: .NET 4.6, VS 2019, C#, MVC, Web API, RabbitMQ, Swagger, Telerik controls, SQL Server 2012, LINQ, Windows 10.
1st Global Research and Consulting – Dallas, TX
Sr. Software Developer
Project: Retirement Management System (Aug 2018 - Dec 2018)
RMS (Phase I): The purpose of this project is to enhance the current Retirement Management Solutions (RMS) infrastructure or create a new RMS infrastructure to efficiently and accurately store plan information, calculate and process RMS fees for all existing and new vendor relationships and plan fee schedules.
Job Responsibilities:
Create new section in RRAPP to manage RMS related information
Created new module for showing vendor information
Implemented CRUD operations for plans and participant
Implemented Web API for all CRUD operation
Created UI for displaying all plan, participant, and vendor data
Modified stored procedure to create plan/participant record in BOS for RMS creation
Created Web API to create plan record in Pivotal using XML form post
Used remote debugging to troubleshoot any error related to web/app server
Environment: .NET Framework 4.5, VS 2017, C#, Web API, SQL Server 2012, LINQ, Windows 10.
1st Global Research and Consulting – Dallas, TX
Sr. Software Developer
Project: Thomson Reuters CLEAR (CIP) (Jun 2018 - Dec 2018)
The Customer Identification Process (CIP) at 1st Global is an automated system for verification of parties, consisting of customers and account beneficial owners at this time, in compliance with due diligence regulations of the government.
Job Responsibilities:
Implemented SSIS import and export packages to verify client’s information
Created control flow and data flow for import and export process
Implemented script task using C# code to read Thomson Reuters specification and generate XML file
Implemented SFTP to fetch the files for import and export process
Modified existing code logic to switch from Equifax to Thomson Reuters
Implemented code to support logging
Implemented CIP incident report for any client’s record failing the CIP passing score
Implemented and configure CIP rules in metadata
Environment: .NET Framework 4.5, VS 2015, C#, SSIS, SQL Server 2012, LINQ, Windows 10.
1st Global Research and Consulting – Dallas, TX
Sr. Software Developer
Project: Post Brazos (Apr 2018 - Jun 2018)
The new account application used by Operations to open IMS and brokerage business, Review and Release (RRApp), has several deficiencies that should be addressed after the Brazos project is released to production. This project request will detail improvements needed to make the application as fully functional as possible for the New Accounts group.
Job Responsibilities:
Implemented IMS accounts from scratch
Modified NFS API to create IMS accounts from scratch
Used Entity Framework for back-end database functionalities
Added ability to add or remove account from client’s account holder tab in RRApp.
Added ability to change relationship for specific account holders as needed
Implemented helper methods to format data in specific format when importing from external application like Docupace Starting point.
Implemented logic to correctly set default tax code based on the account types.
Ensure primary account holder is always set for client’s account.
Environment: .NET Framework 4.5, VS 2015, C#, Web API, SQL Server 2012, LINQ, Windows 10.
1st Global Research and Consulting – Dallas, TX
Sr. Software Developer
Project: Trusted Contact (TC) & Beneficial Owner (BO) (Aug 2017 – Apr 2018)
The purpose of Trusted Contact project is to comply with FINRA Rules 2165 and 4512, which will require us to collect and maintain the name and contact information of a trusted contact person for an account. The purpose of Beneficial Owner
project is to become compliant with the final ruling for FinCEN customer due diligence requirements for financial institutions.
Job Responsibilities:
Implemented new module to manage Trusted Contact information in RRApp
Implemented new module to manage Beneficial Owner information in RRApp
Implemented Customer Identification Program (CIP) through Equifax using SSIS
Implemented import and export SSIS packages for CIP
Implemented SFTP to fetch the files for import and export process
Created middle-tier web APIs for CRUD operations
Used Entity Framework for back-end database functionalities
Created several stored procedures for saving and updating TC/BO information
Implemented code to support NFS API to save/update TC/BO information
Implemented new section in Back Office System (BOS) to manage TC/BO
Environment: .NET Framework 4.5, VS 2015, C#, Web API, SSIS, SQL Server 2012, LINQ, Windows 10.
1st Global Research and Consulting – Dallas, TX
Sr. Software Developer
Project: First Global Single Sign-On (Oct 2016 – Aug 2017)
First Global Identity system supports Single Sign-On (SSO) authentication to log in all the 3rd Party systems where single authentication provides access to multiple applications by passing authentication token seamlessly to configured applications. Various security measures are considered while developing application as 1st Global is considered to be a major financial sector.
Job Responsibilities:
Implemented SSO service to single sign on using SAML 2.0 protocol
Implemented SSO Service to create SAML Assertion for exchanging authentication data between Service Provider (SP) and Identity Provider (IdP)
Implemented Assertion Consumer Service (ACS) to receive SAML Assertion from Identity Providers and Single Sign On to 3rd party system
Performed SAML Response signature verification, Assertion encryption and decryption
Managed certificate in the certificate store required for signing saml assertion
Implemented Saml 2.0 using Kentor libraries and Identity Model libraries
Implemented Semantic Logging Service to handle and log exceptions
Performed several validations required to Single Sign On with various systems
Designed database tables based on Saml 2.0 schema to manage Single Sign On (SSO)
Environment: .NET Framework 4.5, VS 2015, C#, Identity Server 3, oAuth 2.0, OpenID connect, ASP.NET MVC 5.0, jQuery, angularJS, CSS3, JavaScript, Bootstrap, Web API, SQL Server 2012, LINQ, Windows 10.
1st Global Research and Consulting – Dallas, TX
Sr. Software Developer
Project: First Global Identity (May 2016 – Oct 2016)
First Global Identity is a centralized web application mainly used to perform 1st Global Authentication, two factor authentication using RSA third party system and all other applications within 1st Global to perform authentication. Various security measures are considered while developing application as 1st Global is considered to be a major financial sector.
Job Responsibilities:
Involved in configuring RSA using RSA back office tool for two factor authentications
Implemented Identity Server3 and OpenID Connect for authentication mechanism
Implemented Windows authentication service to single sign on
Implemented OpenID connect to integrate with in-house built application
Performed several validations required to Single Sign On with various systems
Designed responsive User Interface (UI) using Bootstrap
Implemented Login, Forgot Password, Reset Password and User Maintenance flows
Implemented RSA Challenge and Enrollment process
Implemented dependency injection using Ninject
Created Web API controllers, services for various database related operations
Implemented SMTP email functionality to notify change password / reset password link
Created and updated database using Entity Framework Reverse Engineering tool
Configured Postman and tested Web API services using postman
Created Application Pool and configured sites in Internet Information Services (IIS)
Environment: .NET Framework 4.5, VS 2013, C#, Identity Server 3, oAuth 2.0, OpenID connect, ASP.NET MVC 5.0, jQuery, angularJS, CSS3, JavaScript, Bootstrap, Web API, SQL Server 2012, LINQ, Windows 10.
Thomson Reuters - Carrollton, TX
Sr. Software Developer (Dec 2014 – Mar 2016)
Project: OneSource 1099
ONESOURCE 1099 is a web-based payment information reporting system. Application Service Provider (ASP) hosting for applications and databases is provided by Thomson Reuters Tax & Accounting. Payer, recipient and form information from various source systems is transmitted to the Thomson Reuters Data Center via encrypted FTP transmission or secure transmission upload (HTTPS). After a data transmission is complete, user can map their data using customizable mapping tools and begin importing the data on their database tables.
Job Responsibilities:
Extensively worked on the code maintenance of various modules and enhancements.
Implemented various modules such Import, Review & Maintenance, Print, Filing, Options, Compliance, Security, eCViews and Withholding.
Redesign several existing web pages
Developed various Entity View Models, Business Logic Layer methods, Data Access Layer
Implemented angularJS with MVVM paradigm for creating responsive UI pages as a part of web solution redesign.
Implemented Web API to provide services to HTTP requests.
Design and implemented batch job scheduler program which is command line exe for A2A filing functionality.
Involved in creating internal win form application for file decryption
Implemented logger for logging several events and exceptions/errors using Log4Net.
Environment: .NET Framework 4.5, VS 2013, C#, ASP.NET MVC 5.0, jQuery, angularJS, CSS3, JavaScript, Bootstrap, WCF, Web API, SQL Server 2012, LINQ, Windows 7.
CBRE - Dallas, TX
Sr. Software Developer (Aug 2014 – Nov 2014)
Project: PriceLab
PriceLab is a commercial facility cost tool that allow for the consolidation of data from different commercial and internal sources into a single platform from which the GCS global sales and RFP solutioning teams can create building-level cost buildups associated with the management of an RFP portfolio, identify and model possible saving opportunities, and assess and underwrite the risk of budget and savings targets.
Job Responsibilities:
Created the UI design, prototype using MVC 5.0 and SQL Azure
Extensively worked on the code maintenance of various modules and enhancements.
Implemented various Modules such Proposal, Reports, Import and Export
Developed various Entity View Models, Business Logic Layer methods, Data Access Layer and UI Helper methods
Implemented jQuery/JSON for a dynamic and interactive UI, data retrieval, client-side validations, document parsing and animations.
Implemented SmartFish, Bootstrapper, Knockout java script library for creating responsive UI
Implemented the logging mechanism for logging several events and exceptions/errors in the system using Log4Net.
Unit tested the System using nUnit.
Environment: .NET Framework 4.5, VS 2013, C#, ASP.NET MVC 5.0, HTML5, jQuery, Tortoise SVN, CSS3, JavaScript, Bootstrap, Foundation, SmartFish, SQL Azure, LINQ, Windows 7.
Hewlett Packard (HP) - Houston, TX
Sr. Software Developer (Aug 2013 – Aug 2014)
Project: Sudden Impact (SI)
Sudden Impact is a system that provides the business with the ability to manage product quality and reliability from development through production and end of life. It allows user to track and manage customer problems. It also allows user to create and describe a known issue, as well as collect and communicate information relating to the root cause and solution for the issue.
Job Responsibilities:
Gathered, analyzed and implemented business requirements for SI based on information gathering sessions with clients /stakeholders and project manager.
Extensively worked on the code maintenance of various modules and enhancements.
Implemented various Modules such as Elevation, Product Issue, Actions, Observation, Resolution, Document Request, Knowledge Management, CRM, Products in the SI
Created the UI design, prototype and developed all the forms for the modules in the System using ASP.NET, VB .NET and SQL.
Implemented code to authenticate user using LDAP from windows active directory.
Implemented the Web Services using SOAP XML to consume information from internal tool WES/OPT, ASP.NET and SQL Server 2008.
Developed the various Entity View Models, Business Logic Layer methods, Data Access Layer and UI Helper methods using VB.NET and ADO.NET.
Implemented the logging mechanism for logging several events and exceptions/errors in the system using Log4Net.
Wrote several SQL scripts, Stored Procedures, User Defined Functions and Views using MS SQL Server 2008.
Used jQuery/JSON for a dynamic and interactive UI, data retrieval, client-side validations, document parsing and animations.
Documented and Unit tested the System.
Mentored the junior developers as and when needed.
Environment: .NET Framework 2.0, VS 2012, VB .NET, ASP.NET, jQuery, ADO.NET, Web Services, TFS 2012, CSS, JavaScript, SQL Server 2008, T-SQL, Windows 7.
Intergraph Corporation – Maddison, AL
Sr. Software Analyst (Oct 2010 – Aug 2013)
Project: SmartPlant Construction (SPC)
SmartPlant Construction is a work planning and managing software that meets the specific needs of construction companies, project management offices, fabricators, and owners in managing resources, materials, and schedules. The product allows customizable and configurable interfaces which enable work package planners to create effective work packages using industry-proven work processes.
Job Responsibilities:
Extensively worked on .NET Framework 4.0/3.5 class libraries
Contribute to requirement gathering, requirement analysis, and design
Responsible for design and development of performance optimization of the system
Designed and developed rich GUI controls using Expression Blend, Expression Design
Implemented Model View ViewModel (MVVM) design technique with Composite Application
patterns (PRISM) for various modules in an application
Extensively worked on XAML for creating Style, Templates and Presenter classes.
Implemented Dependency Property, Bindings in View and View Models
Implemented Web Service using SOAP XML to consume data from SmartPlant Materials
Involved in building SOA service using WCF to share data with Oracle Primavera
Created SQL jobs to process files, execute SSIS packages, publish data on the web server
Involved in generating reports using SSRS, Crystal Report together with XML, LINQ, XPATH
Involved in developing and maintaining website in ASP .NET MVC 3 for viewing performance matrix of Unit Test and ATPs
Implemented Microsoft Windows Installer XML (WIX) Toolset to build setup and patches
Involved in implementing macros using VBA to generate XML file for custom process
Involved in creating and maintaining internal sites using SharePoint designer
Involved in automating the test using Coded User Interface Testing (CUIT) as part of TDD
Developed a comprehensive Exception Management mechanism to log errors and a number of utility for classes to use along the entire span of the project
Designed and developed database system for the user authentication and authorization
Developed various Server API to implement the business logic
Fully participated in documentation and technical review of implemented functionality
Involved in regular code review and pair programming
Involved in root cause analysis of application bugs and defects
Environment: .NET Framework 4.0/3.5, VB, C#, Oracle 11/10g XE, Visual Studio 2010/2008, TOAD 9.7.2, TFS, Windows 7, Windows Server 2008/2003 R2, IIS 7.0, WCF, SmartPlant Foundation, SmartPlant Markup, SmartPlant Review, Oracle Primavera, SmartPlant Materials.
EDUCATION:
Master of Computer Information System, Bellevue University, Nebraska, USA
Bachelor of Computer Software Engineering, University of Texas at Arlington, Texas, USA
CERTIFICATION AND TRAINING
SmartPlant Foundation: Admin I, Admin II, Schema Modeling and Mapping
Citrix XenApp6: Admin I