SUMMARY

• Highly versatile software professional with expertise in software architecture and security in the financial sector ecommerce supply chain management and academic arenas
• Senior Developer/Architect with over 15 years of experience on successfully delivering large mission-critical initiatives in various roles including architect project manager developer and technical lead
• Proven track record of cross-platform cross-enterprise application development and integration as well as legacy application re-engineering and integration utilizing .NET DB web service SOA WCF and WPF technologies. 12 years .NET and 15 years DB.
• Solid knowledge of Design Software Engineering using OOAD UML and Design Patterns as well as advanced-level experience in SDLC. 6 years of providing technical leadership and architectural guidance.
• Strong analytical and programming aptitudes with the ability to adapt to new technologies.
• Capable of multi-tasking and completing complex projects in constantly changing environments along with an ability to work well with others and communicate effectively.

TECHNICAL SKILLS

Architecture OOA D UML SOA WCF WPF MVC MVVM Entity Framework Programming C .NET / VB.NET VB C/C LINQ XML schema Web technologies ASP.NET/ASP WCF Web Services Web API MVC XML JSON JavaScript HTML5 Frameworks Visual Studio .Net 2003 - 2013 .NET Framework 1- 4.5 RDBMS MS SQL Server 2005 - 2012 Oracle DB2 MS Access Query languages T-SQL SSIS PL/SQL stored procedures functions triggers Oracle Pro C Other technologies Azure MQ Series MSMQ TFS LDAP COM/DCOM MTS CORBA Crystal Reports

WORK EXPERIENCE

Confidential

l Establish Design and Coding Standards

• C coding standard
• WCF coding standard
• Design review best practices
• Experimented Microsoft Azure

l Design ACG Billing

• using T-SQL C Web API SSIS SFTP and design patterns
• Transform operational documentation into financial data
• Create a billing admin portal for user management configuration management and reporting
• Create a billing portal for coders to code review update insert and delete billing data and review reports
• Asynchronous file upload and download with compression and bufferless depends on file size and type.

l ACG Anesthesia

• using WPF VMMV T-SQL C
• Implemented and updated ACG Sedation and ACG Perfusion login and configuration
• To redesign the Block template and short case to improve the work flow and user experience

l Confidential

l Group Billing

• using SSIS T-SQL C VB.net OOAD and design patterns
• Loaded member eligibility payments claims and policy data from different sources into the database
• Matched and reconciled payment and claims information with corresponding members and created on-line reports for business users to research on the data that do not reconcile and to generate billing reports and invoices based on the corrections and on-line manual reconcile

l Redesign Fazal Enrollment System

• using SSIS T-SQL C VB.net web service and design patterns
• The Fazal Enrollment could not handle the increased volume of users which resulted into CMS sanction against CVS.
• Researched and analyzed the performance bottleneck and proposed solutions for those problems within 2 weeks of on task and in 6 months the system was redesigned and the performance increased 200 times which resulted into CMS lifting the sanction.
• Got rid of the inefficient data processing with web service in application layer. Instead moving the data processing and report generating logic into database to free up the resources on the web servers.
• Uncoupled the real-time enrollment processing and reporting generating functionality so that the on-line enrollment won t get interrupted by the reporting batch process.
• Got rid of redundant and bad coding and added process logging information to the application for better trouble shooting and compliance.
• Imported data from the old Fazal system into new system

l Medicare Part D Recon

• using SSIS T-SQL C
• With the CMS sanction CVS was required to research the cause of the enrollment performance issues. As a result we had to reload all data from the previous years into a new system to replicate the data process.
• Researched and analyzed the data and processes and documented the incorrect data processing logic in multiple ETL processes and suggested solutions to resolve them.

l 45-day Invoice generation using SSIS T-SQL

Load claims payment data from multiple sources and programmatically cleanse the data and match up with member eligibility previous payments and invoices data write-on and write-off data to generate report for manual research and create quarterly invoices to collect fee for unpaid services. .

Confidential

l PCI Compliance

• Analyzed risks and architected multiple strategies for more than a dozen of applications to reach PCI compliance
• Established standardized process for design coding and automation of deployment process for applications with a major focus on PCI compliance
• Reviewed application designs to address PCI compliance risks in different systems for order processing and fulfillment process.
• Designed and developed Data Retention projects to satisfy Johnson and Johnson IT security needs and Canadian Consumer Protection Agency needs to delete and/or mask customer financial and personal data from all systems after the customers become inactive for a certain period of time
• Re-engineered solutions to not store any financial data in plain text in logs exceptions databases and purge plain text financial data from logs and storage media
• Designed and developed application to real-time and batch process payment transactions with 3rd party payment processing system
• Designed and developed application to migrate historical data from in house payment processing application to 3rd party payment processing system

l Standardize Order Processing Web Services

• using OOAD WCF SSIS design patterns entity framework and proven integration principles
• Architected and developed a global framework for processing order and customer info from external and internal eCommerce sites.
• Provided a systematic approach to standardize the web services interface and implementations instead of one off solution for each every client
• Added new functionality to support multi-client and multi-site with a new dashboard to monitor the application s health.
• Designed and developed an application to update front-end inventory information

Confidential

l SolutionsBank Web Site Redesign

• using OOAD design patterns SSO and windows integrated authentication Microsoft Enterprise Library and AJAX on SQL server.
• Re-architected the application to conform to ABB global web standards and to improve functionality security and performance
• Migrated the application from classic ASP to Asp.Net 2.0
• Added new interactive guides to SolutionsBank offerings to provide rich user experience for customers around the world.
• Provided a new mass mailing tool to give marketing and the management over 100 selection criteria to send the promotional and/or business critical information to specific targeted user groups.
• Consolidated multiple applications into a single one to improve usability and reduce maintenance overhead

Standardize Development Process

• Provided the guidelines for software design and development especially in security aspects.
• Provided the guidelines for offshore estimation development and testing process.
• Provided C coding standards for North American IS organization.
• Architected the dashboard to monitor the health and performance of the applications for the NS services organization.

NA Customer Service Portal

• Collected business requirements brain-stormed the features and functionalities of the new customer service portal for North Americas service organization.
• Evaluated numerous web 2.0 platforms and performed proof of concept with some of them.

NA ABB University Security Fixes

• Discovered and fixed the site s major security risks by encrypting customer financial information and using secured software coding practices to prevent form injections URL injection as well as SQL injections.
• Analyzed the data lose cause and impact on the security breach instance and recovered the lost data. Recommended changing the software package for NA training organization needs.

Confidential

Global Integration Solutions

• using OOAD WCF design patterns and proven integration principles
• Architected a global framework for all dealer management systems DMS to interface with Snap-on Business Solutions Electronic Parts Catalog EPC products.
• Provided a systematic approach to standardize the interface for DMS and EPC products of various platforms and deployment models.
• Managed development teams to ensure that the work quality is up to standards

Global Technology Roadmap

• Major contributor to the company s 5 year technology vision and roadmap to standardize the EPC platform and integration systems using the Global Integration Solutions architecture.

Confidential

l Agency Management Interface Web Services

• using C ASP.NET ADO.NET Web Services WCF LDAP ACORD XML XML Schema and secured software development methodology
• Provided the standard interface for all agency management systems to interface with Progressive s ForAgentsOnly.com FAO .
• It authenticates the XML requests from agency management systems and automatically log the agents into desired FAO pages for inquiries and make payment transactions.
• It also provides authentication for vendor quoting and selling of policies.
• Architected and delivered the product from conception to going live.
• This is hailed as the first in Progressive the best in the industry and agents love it.

l FAO .NET Migration Policy Object Framework

• using C ASP.NET ADO.NET Web Services parallel processing
• Centralized all policy data retrieval from various data sources and process them into data stores for all FAO policy data needs.
• It is the corner stone of the FAO .NET Framework and it makes sure that data retrieved from .NET pages and classic ASP pages are reusable for any subsequent FAO policy pages.
• Acted as the technical lead for needs analysis design project coordination as well as all phases of the development cycle.

l Transformation Station TS Real Time Transactions

• using ASP LDAP ACORD XML XML Schema and secured software development methodology
• It enables agents to retrieve real-time policy data without having to leave their management systems. It also implemented real-time quoting transactions.
• Acted as the technical lead for needs analysis design project coordination with internal and external teams as well as all phases of the development cycle.
• Progressive was awarded Best Interfaces of Insurance Industry for this project.

Confidential

l Enterprise Load processing applications

• using OOAD and Microsoft DNA VC VB COM/DCOM MTS IIS MQ XML XSL ASP JavaScript and PL/SQL Stored Procedures on Unix and Windows platforms.
• Transmit data messages to and from the GEIS Enterprise Software
• Extract order and load information based on customer specific requirements with a generic EDI format map it to fit customer specific data representation FTP to customers.
• Accommodate each customer s system data representation by applying filters.
• Automate the load confirmation process by reformatting customer electronic data to update TM Database via DMP Dynamic Message Processor and CORBA APIs
• Delete shipments of certain status and keep audit history
• Publish the exception report on Intranet for manual intervention.
• Load zone data in Excel from intranet into TM Database
• Take information from the Good Receipt files from clients and from the TM Database and write files for AI to translate them to EDI message to be loaded into TM Database in Pro C
• Take customer s XML ASN data and update the orders in TM Database via and CORBA APIs
• Responsible for needs analysis design and all of the database development and application layer development.
• Customers include Ford GM Craft Maid Whirlpool Fresenius Medical

Confidential

• l Primary Investigator of Chemoprevention of Liver Cancer with 11 research publications
• l Designed and developed an automated image processing system for matrices of liver samples using convolution algorithms in C. Responsibilities included serving as project owner for needs analysis design and development.