ASHISH JAIN Email: abm63i@r.postjobfree.com Ph:240-***-****(Cell),
240-***-****(O)
** + years of IT experience with over five years of experience as a
Data Architect providing technical architecture solution for
enterprise class data warehouse/OLTP SDLC projects.
Developed business, logical and technical data architectures,
including data models, data quality plans and functional data
processes as well as assist in milestone planning and project
execution.
Extensive experience in business process analysis and generating
business requirements documents.
Define enterprise metadata strategy including administration and
lineage.
Develop data management strategy and processes supporting data
governance, leadership and security
Expert in normalization, de-normalization, data rationalization, and
optimization techniques.
Expert in implementing Service Oriented Architecture(SOA).
Very good understanding of XSD, XML and XML related technologies.
Expert in designing the database solution for OLTP and OLAP
applications.
More than 10 years of experience with ETL and other types of
high-volume data movement, data replication, data transformation
,data mining, data cleansing, data extraction, data validation and
data integration.
Provide data profiling expertise including techniques and best
practices.
Define and develop data validation, verification and reconciliation
strategies.
Very strong experience in developing Dimensional Data Model,
Enterprise ER Data model, data mapping documents, and Canonical
model using Erwin, Embarcadero ER Studio, Visio, Sybase Power
Designer.
Develop and implemented the Metadata repositories, Data Governance,
Data Ownership, Data Stewardship and Data Policy.
Very strong experience in developing the test plan and conducting
system testing, integration testing, user acceptance testing and
Implementation of very large systems.
Tested and conducted acceptance reviews with customer.
More than 10 years of experience in developing the OLAP and
business intelligence solution.
Over 10 years experience in managed healthcare industry as a Facets
developer, HIPAA, Pervasive Data Integrator Developer, EDI X12
developer, business analyst and Oracle/Sybase database developer.
More than 7 Years of experience in HIPAA EDI X12 transactions
(837,835,834,270,271,277)
Over 10 years experience in Relational Database Systems, Data
Architecture, Data Modeling, Database design, Database backend
programming in Oracle PL/SQL, Sql Server T-SQL and Sybase T-SQL.
This includes writing Stored Procedures, Triggers, Functions,
Cursors, Views, Indexes and Constraints and tuning SQLs .
Extensive experience in diverse business sectors including Managed
Healthcare, Manufacturing, Financial and Banking.
Team Lead, Project estimation and execution experience.
Extensive experience with tuning of PL/SQL Packages, Stored
Procedures and Triggers,
Extensive experience in business process analysis.
STRENGTHS
Strong interpersonal skills, ability to interact with people at all
levels.
Extensive project life cycle experience and have been involved in
requirement specification, analysis, design, development, user
acceptance testing, and Implementation of very large systems. Tested
and conducted acceptance reviews with customer.
Strong communication skills and project management capabilities.
Experience in providing leadership to a team of database programmers
and mentoring developers.
Strengths are problem solving, and ease of adaptation to newer
development techniques, languages and working culture.
Analytical, highly self-motivated, goal-oriented professional with
proven success in technology consulting and software development.
Having extensive work experience in cross-functional and
multicultural environment.
Client Business Employer Duration Role
Application
Freddie Mac Corporate Data Consultant July 2009 Data Architect
Warehouse - Dec /Data Modeler
FAS140 2009
Model Office Consultant Nov 2008- Database
CareFirst Blue Service Domain July 2009 Integration
Cross Blue Project Specialist
Shield
Multiplan, MultiPlan EDI Consultant Sept 2006 Data Architect
Rockville, MD X12 - July /Data Modeler
Application 2008
Presbyterian, FACETS Axiom Aug 2005 Data Architect
Albuquerque, Implementation Systems, MD -Sept 2006 /Data Modeler
New Mexico
Rocky Mountain RMHP Data Axiom Jan 2004 Data Architect
Health Plan, Warehouse. Systems, MD till July /Data Modeler
Grand Junction 2005
Magellan Health Enterprise Axiom Jan 2003 Data Architect
Plan, Columbia, Data Warehouse Systems, MD till Dec /Data Modeler
MD system. 2003
Health Plan of HCFA and UB-92 Axiom Jan 2003 Lead SQL
San Mateo, CA EDI Systems, MD till Mar Server/DBA
Application 2003 Developer Lead
EDI Developer.
Axiom Systems, Maxim Axiom Oct 2002 Lead SQL
Germantown, MD Systems, MD till Dec Server DBA/
2002 Developer/Lead
DBA.
CareFirst, Gap Analysis Axiom Aug 2001 Lead SQL
Columbia, MD HIPAA and Systems, MD till Sept Server
Legacy Systems 2002 DBA/Developer/
Lead EDI
Developer.
BlueCross FACETS Axiom Jan 2001 Lead SYBASE
BlueShield, Reporting Systems, MD till July Developer/DBA
Oklahoma Solution 2001
BlueCross FACETS Axiom Sept 2000 Lead SYBASE
BlueShield, St Reporting Systems, MD till Dec Developer/DBA
Louis Solution 2000
US DataMax, Des Enterprise Axiom May 1999 Sr.
Planes, IL Resource Systems, MD to Aug Programmer/Ana
Planning 2000 lyst
IIS LTD, UK Financial IIS LTD, UK Aug 1998 Sr.
Management to May Programmer/Ana
System 1999 lyst
Sony, Singapore TRIMS NIIT, Nov 1995 Sr.
Singapore to July Programmer/Ana
1998 lyst
EDUCATIONAL DETAILS
MS (Computer Application), Bhopal University, India
BS (Electronics), Sagar University, India
TECHNICAL SKILLS
Hardware HP 9000, HP 3000, Pentium based
machines
Operating System Windows NT/2000/XP, HP Unix, Linux
Programming Languages/Tools Power Builder, Crystal Reports,
Perl,UNIX Shell Script, BCP,
Pervasive Data Integrator,
Data Junction, Visual Basic, MS
Access, MS Project, MINITAB,
Excel, Visio, Toad, ERWIN, Rapid
SQL.
Oracle Tools Toad, Sql loader, Export, Import
1.PROJECT TITLE Corporate Data Warehouse FAS140
INDUSTRY Mortgage
CLIENT Freddie Mac, McLean
DURATION From Oct 2009 till Dec 2009
ROLE Data Architect
PROJECT SPECIFIC SKILLS Data Modeling, ER
Studio,Sybase,DB2,Rational Clear
Case, Rational Clear Quest,SSIS
DESCRIPTION OF THE PROJECT
The CDW is a corporate data repository that makes accessible
historical and current business relevant data as of the prior
business day. The CDW's primary purpose is to centralize corporate
data from disparate data sources residing within Freddie Mac's
transaction processing and end-user systems into one relational
database for decision support, management reporting, ad-hoc and
trend analysis, modeling and data mining purposes.
Roles and responsibilities
Meet with business stakeholders and other technical team members to
gather and analyze corporate data repository requirements
Responsible for data model change management and implementation.
Design Logical and Physical data models for various projects under
corporate data repository.
Responsible for capacity planning and devising the table
partitioning strategy.
Provide status reports to management regarding project status, task,
and issues/risks
Provide first level operational support for Development, UAT and
System integration testing and production data model changes
Use Rational Clear Case for version control and Clear Quest for
deployment and work flow.
2.PROJECT TITLE Model Office Service Domain
Project
INDUSTRY Managed Healthcare
CLIENT CareFirst BlueCross BlueShield
DURATION From Nov 2008 till Aug 2009
ROLE Database Integration Specialist
PROJECT SPECIFIC SKILLS FACETS,Oracle11g, PL/SQL, ERWIN,
Mercury Quality Center, SharePoint
DESCRIPTION OF THE PROJECT
Model Office project is designed to facilitate Voice Response Unit,
Business OnLine systems
with FACETS 4.5.1 Member, Benefits, Claims and Enrollment data
through SOAP Services.
SOAP services designed in TIBCO Business Works integrate with FACETS
4.5.1 Stored
Procedures to retrieve data to feed the downstream systems.
Roles and responsibilities:
Developed the interface between FACETS and VRU/BOL/EIVR system.
Design and identify the existing services to deliver the application
under Service Oriented Architecture(SOA) framework.
Meet with business stakeholders and other technical team members to
gather and analyze application requirements
Design database solutions to incorporate application (business and
technical) requirements
Business process analysis. Designing and developing the data
extraction algorithm to extract the benefits, authorization,
referrals and network resolution data from FACETS and feed it to
CareFirst's VRU(Voice Response Unit) and BOL(Business Online) layer.
Provide status reports to management regarding project status, task,
and issues/risks
Provide first level operational support for development and
production database systems
Established the process for version control,code deployment and
work flow.
Responsible for ORACLE PL/SQL code tuning.
3.PROJECT TITLE MultiPlan Data Warehouse Solution
INDUSTRY Managed Healthcare
CLIENT Multiplan, Rockville, MD
DURATION Sept 2006 till July 2008
ROLE Lead Oracle Data Warehouse
Architect
PROJECT SPECIFIC SKILLS Dimensional Data Modeling, ERWIN,
Oracle 11g, PL/SQL, Pervasive Data
Integrator/Data Junction, HIPAA
EDI X12 Transactions, Clear Case,
Clear Quest
DESCRIPTION OF THE PROJECT
The data warehouse solution stores all the incoming claims
transactions which multiplan receives from various sources this
includes 837,UB-92, HCFA, NSF and several proprietary formats.
Roles and responsibilities:
Designed and Implemented the Claims, Eligibility, Members and
Provider Data Mart
Designed the Conceptual, Logical and Physical data Model
Develop and Implemented the metadata repositories
Designed the ETL Architecture to load the data into the data
warehouse.
Created data profiling rules to analyze the source data.
Define and develop data validation, verification and reconciliation
strategies.
Developed ETL processes for extracting the data from HIPAA X12
transactions(837I,837P,837D), to load it to operational claims
database.
Responsible for Source to Target mapping and Transformation Logic
Business process reengineering of External Network application, EDI
HIPAA X12 claims (837I, 837P) loading application, database
designing and data modeling using ERWIN.
Business process analysis of 270,271,276,277,997, 834 HIPAA EDI X12
transactions.
Creating and maintaining stored procedures, functions, indexes,
users, tables, views, triggers etc.
4.PROJECT TITLE FACETS Implementation and Data
Warehouse Implementation
INDUSTRY Managed Healthcare
CLIENT Presbyterian, Albuquerque, New
Mexico
DURATION August 2005 till Sept 2006
ROLE Lead Oracle Data Warehouse
Architect
PROJECT SPECIFIC SKILLS Dimensional Data Modeling, Oracle
PL/SQL, HIPAA EDI X12
Transactions, Facets MMS
Interface, Data Integrator,
ERWIN,Mercury Quality Center
DESCRIPTION OF THE PROJECT
The data warehouse solution stores all the incoming EDI claims
transactions which Presbyterian receives from various sources this
includes 837,UB-92, HCFA, NSF and several proprietary formats.
Roles and responsibilities:
Data Warehouse
Designed Conceptual Model, Logical model, Physical Model for
Billings and Claims Data mart, Benefits Data mart and Provider &
Membership Data Marts.
Develop and Implemented the metadata repositories .
Responsible for Source to Target mapping documentation and
Transformation Logic.
Designed and developed the ETL process Architecture.
Created Materialized Views to precompute and store aggregated data.
FACETS
Analyzed, Designed and Developed the MMS interface using oracle
PL/SQL stored procedure for Presbyterian the biggest healthcare
provider in New Mexico. The Facets Membership Maintenance Subsystem
(MMS) is a batch load process that easily facilitates the initial
loading and subsequent maintenance of subscribers, members and their
associated information (addresses, COB information, PCP selections,
etc.).
Analyzed, Designed and Created the interface to generate the 835
Remittance Advice out of the FACETS database using oracle PL/SQL
stored procedure.
Responsible for business analysis for HIPAA X12 transactions, Design
Documentation,. Develop logical/physical maps for HIPAA X12
transactions. Tested and conducted acceptance reviews with customer.
Tuned databases and SQL for high performance.
Creating and maintaining users, schemas, tables, views, triggers,
stored procedures, functions sequences, and indexes comprise the
data dictionary.
5.PROJECT TITLE RMHP Data Warehouse
INDUSTRY Managed Healthcare
CLIENT Rocky Mountain Health Plan, Grand
Junction, CO
DURATION January 2004 till July 2005
ROLE Lead Oracle Data Warehouse
Architect Developer
PROJECT SPECIFIC SKILLS SYBASE 12.5 T-SQL, ORACLE 10g
PL/SQL, FACETS, HP 9000 UNIX, Data
Integrator
DESCRIPTION OF THE PROJECT
Roles and responsibilities:
Designed the data warehouse solution to store all the claims,
providers, members and eligibility transactions from FACETS SYBASE
12.5 database to ORACLE 10g Database.
Designed Conceptual Model, Logical model, Physical Model using ERWIN
CA Data Modeler.
Created the Claims Data mart, and Marketing Data Mart.
Develop and Implemented the metadata repositories.
Responsible for Source to Target mapping documentation and
Transformation Logic.
Created the ETL process to load the data into data warehouse.
ETL and other types of high-volume data movement, data replication,
data transformation,data mining, data cleansing, data extraction,
data validation and data integration.
Define and develop data validation, verification and reconciliation
strategies.
6.PROJECT TITLE Enterprise Data Warehouse system.
INDUSTRY Managed Healthcare
CLIENT Magellan Health Plan, Columbia, MD
DURATION Jan 2003 till December 2003
ROLE Lead Oracle Data Warehouse
Architect
PROJECT SPECIFIC SKILLS Oracle 9i, HP 9000 UNIX,
Embarcadero ER Studio, Pervasive
Data Integrator/Data Junction,Perl
DESCRIPTION OF THE PROJECT
Analyzed 10 years of claims data to generate the reports Per-patient
average billing amounts. Per-patient average visit numbers.
Per-patient average medical tests. Per-patient average medical test
costs. Per-patient average prescription ratios detailing the cost of
services. It helped Magellan to improve response time to claims, and
thwart fraudulent claims. increasing predictability of
claims-payment flows, and identifying loss potentials for specific
geographical areas.
Roles and responsibilities:
Worked as Data Architect for the Enterprise Data Warehouse system.
Designed, Developed and implemented the data replication process
from AMISYS 3000 to Magellan's data warehouse on ORACLE 9i platform
under HP-UX, using PL/SQL, Pervasive Data Integrator /Data Junction
and UNIX shell script. Developed the ETL process,
Responsible for requirement analysis, Dimensional Data Modeling
,Logical and Physical Database Modeling, Source to Target mapping
and Transformation Logic.
Designed, developed and implemented the 837,834,270,271, NSF,HCFA
and UB92 transactions.
Responsible for creating physical Database, Application DBA support
and query tuning.
Creating and maintaining users, schemas, tables, views, triggers,
stored procedures, functions sequences, and indexes.
7.PROJECT TITLE HCFA and UB-92 EDI Application
INDUSTRY Managed Healthcare
CLIENT Health Plan of San Mateo, CA
DURATION Jan 2003 till Mar 2003
ROLE Lead Sql Server Developer/Lead EDI
Developer.
PROJECT SPECIFIC SKILLS Sql Server 2000 T-SQL, Pervasive
Data
Integrator, Embarcadero ER Studio.
DESCRIPTION OF THE PROJECT
Designed, developed and implemented the 837,834,270,271, HCFA and
UB92 transaction out of MAXIM.
Responsible for Data mapping,Used Embarcadero data modeling.
8.PROJECT TITLE MAXIM
INDUSTRY Managed Healthcare
CLIENT Axiom Systems, Germantown, MD
DURATION Oct 2002 till Dec 2002
ROLE Lead SQL Server Developer/Lead
DBA.
PROJECT SPECIFIC SKILLS Sql Server 2000, Pervasive Data
Integrator/Data Junction,
Embarcadero Studio.
DESCRIPTION OF THE PROJECT
Designed, developed and implemented the database design for Axiom's
Maxim product.
9.PROJECT TITLE Gap Analysis HIPAA and Legacy
Systems
INDUSTRY Managed Healthcare
CLIENT CareFirst, Columbia, MD
DURATION Aug 2001 till Sept 2002
ROLE Lead SQL Server and EDI Developer.
PROJECT SPECIFIC SKILLS Sql Server 2000, Pervasive Data
Integrator/Data Junction, Visual
Basic.
DESCRIPTION OF THE PROJECT
Perform the gap analysis between legacy system and HIPAA EDI
transactions for CareFirst.
Used DTS packages, Bcp, sql server replication, Database Tuning,
Crystal Reports.
10.PROJECT TITLE FACETS Reporting Solution
INDUSTRY Managed Healthcare
CLIENT Bluecross BlueShield, Oklahoma
DURATION Jan 2001 till July 2001
ROLE Lead SYBASE Developer/DBA.
PROJECT SPECIFIC SKILLS Sybase T-SQL, Crystal Reports,
UNIX
DESCRIPTION OF THE PROJECT
Developed the reporting solution for Bluecross BlueShield, Oklahoma
out of FACETS
11.PROJECT TITLE FACETS Reporting Solution
INDUSTRY Managed Healthcare
CLIENT BlueCross BlueShield, St Louis
DURATION Sept 2000 till Dec 2000
ROLE Lead SYBASE Developer/DBA
PROJECT SPECIFIC SKILLS SYBASE T-SQL, CRYSTAL REPORTS,
UNIX
DESCRIPTION OF THE PROJECT
Developed the reporting solution for Bluecross BlueShield, Oklahoma
out of FACETS
12.PROJECT TITLE Enterprise Resource Planning
INDUSTRY Information Technology
CLIENT US DataMax, Des Planes, IL.
DURATION May 1999 to Aug 2000
ROLE Lead SQL Server Developer/Lead EDI
Developer.
PROJECT SPECIFIC SKILLS ORACLE 7/8i,PowerBuilder,UNIX
shell scripts
DESCRIPTION OF THE PROJECT
Developed ERP product for manufacturing Industries. Front End
development using PB
13.PROJECT TITLE Financial Management System
INDUSTRY Finance
CLIENT IIS LTD, UK
DURATION Aug 1998 to May 1999
ROLE Sr. Programmer/Analyst
PROJECT SPECIFIC SKILLS PowerBuilder 7, ORACLE 7, Crystal
Reports
DESCRIPTION OF THE PROJECT
voucher, posting cash and bank entry, Bank Reconciliation, Trial
Balance, Balance sheet
14.PROJECT TITLE TRIMS
INDUSTRY Manufacturing
CLIENT Sony, Singapore(Employer NIIT LTD,
Singapore)
DURATION Nov 1995 to July 1998
ROLE Sr. Programmer/Analyst
PROJECT SPECIFIC SKILLS Power Builder 7, Oracle 7, Unix
Shell Scripts, PRO*C, SQLLDR,
IMPORT, EXPORT
DESCRIPTION OF THE PROJECT
Developed the Total Response Information System for Sony
Electronics