SUMMARY:

Twenty years of IT professional experience in Healthcare/Financial industries as a Senior Database Engineer / BI developer, with extensive experience in whole Software Development Life Cycle (SDLC): designing and developing complex databases, data warehouse, data mart, BO Universe, SSIS / SSRS reports, T SQL, performance tuning and optimization, Crystal / Webi Report. An effective team player / team lead, a loyal employee, a quick learner with excellent communication skills, and strong data analytical and problems solving skills.

PROFESSIONAL EXPERIENCE:

Confidential, Piscataway, NJ

Technical Lead / Architecture Senior Specialist / Senior Database Engineer

Responsibilities:

• Technical lead for our database team with strong communication skill in a Scrum / Agile Environment.
• Strong data analytical skills via T - SQL, strong performance tuning skills for complex queries, and procedures; experience in designing and implementing complex logical and physical Data Models.
• Strong SSIS with .NET skills - load and transform different formats of data (CSV, txt, Excel, etc) to our databases.
• Developed and maintained company’s core databases: daily loads to downstream databases: data warehouse (ODS and EDW), Star or Snowflake schemas, and data marts (DM), and B2B / B2C for client and member portals.
• Created several new Business Object Universes for storing medical/clinical data.
• Developed operational, analytical and ad-hoc data extracts via business object Crystal report and Webi reports.
• Configured Biztalk server 2012, Biztalk Admin console, Analyzed Biztalk projects (Map, Orchestration, and pipeline) to convert EDI to XML or CSV.
• Designed/created new Team foundation server (TFS) architect / projects for our teams to store, and check in/out codes. Wrote a TFS guide for different IT teams.
• Wrote various technical guides to define team’s TSQL and SSIS code standards and best practices, how to update data warehouse / data mart data, etc.
• Familiar with Business object admin tools, CMS / CMC, InfoView, and automate reports.
• Worked with different vendors: create SSIS ETL to import and export files from/to Meditrac HSP, Milliman, Cactus, ACO/Medicare/CMS, CaseNet / TruCare, Navinet, CVS Caremark, ESI, Envision, Emdeon / change healthcare, Care Analyzer, etc.
• Worked on various Projects: TPA provider, Compliance reports, ACO (load and extract provider, Beneficiary, and claims from CMS), EFT, RFP, Member IDcard, Paper GoGreen, etc.
• Involving in Full software life-cycle using SQL Server ; Working with different teams and clients to gather requirements, planning, designing, developing, and testing.

Confidential, Edison, NJ

Lead Database Engineer / SSIS and SSRS / Crystal Report Developer

Responsibilities:

• Maintain the data for our .NET window application which manages everything from the initial client contracts to the execution of the marketing programs.
• At the end of execution of programs maintain financial transactions, compliance reporting and invoice generation.
• Write store procedures, functions, views to implement complicated business requirements.
• SSIS - developed SSIS packages to automate processes. Integrate data with Appature software.
• Integrate, convert, and migrate data from various clients, automated data import and export.
• Load various data to our database. Compare and merge new data into our database.
• Troubleshoot data performance issues using SQL server profiler and red gate tool.
• Administrate SSRS and Crystal report portals. Create various ad-hoc reports and set up automated report subscriptions. Create dashboard reports via Tableau reporting tool.
• Maintain our existing ColdFusion websites.

Confidential, Totowa, NJ

Database and Report Developer

Responsibilities:

• Designed and created various complex financial T-SQL store procedures / views / functions and Crystal reports. Interfaced with clients, manager and analysts to determine report requirements.
• Worked on a software product that provides a partnership and investor accounting and reporting solution to be used by funds of funds, hedge funds and their administrators to support both U.S. domestic partnerships and offshore.This web-based reporting tool helps firms quickly assess investment performance and market.
• Created financial reports using Crystal reports, and SSRS, crosstabs, charts, and graphs. Sample reports are Account statements, income statements, trial balance, and balance sheet.
• Designed relational data models, wrote Stored Procedures and Views to provide various functionalities used by reports and web services. Resolved a lot of performance optimization.
• Migrated Crystal reports to SSRS.

Confidential, Bethesda, MD

Lead Web & Database Developer

Responsibilities:

• Involved in the full life cycle on applications for requirement collection, feature design, architecture design, implementation and quality control.
• Designed the databases, maintain, support and operation of the SQL server databases, and created tables, views and store procedures.
• Lead ASP developer and SQL Server DBA of a big financial web application used by NIH budget officers.
• Total amount of revenue saved in this system exceeds $220,000,000 each year.
• Lead ASP developer and SQL Server DBA, IIS Admin for an ASP web application that checks every candidate's background before NIH hires him/her and then keeps track of accurate background information for candidate screenings
• Converted Excel Reports to an SQL server without losing any information and made it easier to update and delete cases.
• VB.NET/C#.NET developer and Crystal Report writer of a big client/server application that handles NIH parking and Transhare (PARTS) information. All used in excel convert to web to allow user easier access and update information.
• Developed a financial web application that made it easier for the NIH Staff to data gathering and keep track of historical information in a centralized database.

Confidential, Washington, DC

Web Programmer/Analyst

Responsibilities:

• Developed JavaScript, HTML, Style Sheet, and Perl
• Designed web sites and graphics using Photoshop, Illustrator, Fireworks, Macromedia Flash
• Used Web development tools: Dream Weaver, FrontPage, and InterDev
• Learned CGI, Perl, Python, XML, and UNIX.