 Designed, developed and implemented an in-house EDI Billing system to support Accounting’s need for Health Care claims and/or encounters. Integrated ASP .NET, SQL Server & EDI HQ into one consolidated Web Application, so Billers could view & submit claims/encounters to various clients based on each client’s specific EDI format. Built SQL Sever solutions for various data migration/replication process. Created database maintenance plans for monitoring database integrity and performance. Migrated data from various data sources to centralized SQL server databases using SSIS or customized SQL job. Optimized Indexes for better performance by analyzing their Query Plans. Improved Performance by creating Clustered and Non-Clustered Indexes and by optimizing the T-SQL statements using SQL profiler.  Created Entity Relationship Diagrams (ERD), data dictionaries, and physical data structures such as tables, primary/foreign keys and indexes. Developed various T-SQL objects such as Functions, Tables, Views, Triggers, Indexes, Constraints and created Dynamic and Static Stored Procedures and Queries to develop Decision Engine.  Maintained Batch logging, Error logging tables and handled errors using Event handlers.  Developed, monitored, and deployed SSIS packages and/or customized SQL job for Dynamic ETL flow to validate, extract, transform and load data into database.  Created Customized reports (Parameterized, Drill-through, and Drill-down Reports) using SSRS.  Involved in deploying, configuring and managing reports using Report Manager and Report Builder. Developed ETL audit process and controls to ensure data quality is compliant with defined standards and thresholds. Developed customized eligibility process for each client based on different eligibility file format. And integrated all eligibility data into one consolidated Web application for internal call centers.

 Technology: Microsoft .NET Framework 3.5, WCF, C#, MS SQL Server 2005 Gathered and analyzed client’s requirements; designed product N-Tier architecture framework Ensured all development for each sprint are completed on time and meet customer requirements; eliminated possible waste by agile development using scrum. Developed new components and maintained/upgraded existing components. Daily responsibilities include project development and production support. Ensured all development comply with coding standards, and have been fully tested before deployment by using Unit Test, Functional test, Integration Test, Regression Test, UAT and Site Test

• Travel Reservation Booking Engine for the site http://www.tripz.com/Worked with 4 team members to create an online reservation booking Engine and administration System, including services to Hotel, Air, Car, Vacation rentals and Package distribution. Met the 8-month deadline and saved the client $200,000 in budget.Technology: C#, ASP .NET, MS SQL Server 2000, XML, Web Service.• ISP Billing Harmonization Project for eBilling Center of TELUS Corporation.Worked with 22 team members to merge ISP billing systems in British Colombia, Alberta and central Canada onto one billing platform, and upgraded to Portal Infranet® 6.1. Technology: ASP .NET/Oracle, C, PORTAL Infranet® 6.1 and Crystal Report.• PALM Application for Drugmagnet.caDeveloped a patient management and treatment system. Worked with 15 team members to meet the tight deadline with new technology, achieve client requirements and save the company $80,000 in budget.Technology: Palm, Visual Basic .NET/Sybase• Internet-enabled Customer Accounts Receivable System (iCARS)-Phase 2Created a long distance call’s online billing and reporting system for Bell Atlantic that provides full service to their customers from the Internet. Technology: ASP/ MS SQL Server 7.0, Visual Basic 6.0 and Crystal Report.• Timekeeper System for Toronto Hydro Corporation (Intranet)Created a web-based timekeeping system to better assist employees with their timesheet entry. (Technology: ColdFusion 4.5/Oracle 8.0)