SUMMARY

• Over 8 years of experience in teh field of Information Technology wif solid experience inDataAnalyst, Design and Development. Involved in providing production support to variousDataWarehousing,DataIntegration, Business Intelligence (BI) projects and Extensive experience in ETL source to target mapping. Database Design, development and deployment of large - scale enterprise applications products like SSRS, SSAS, and SSIS.
• Experience in testingFacetsapplications and EDI transactions
• Experience working on 4010 and 5010 HIPAA implementation guides relate to Claim Testing and Medical Billing.
• Experience in creating SQL queries to facilitate UAT and performdatavalidation.
• Experience in methodologieslikeAgile, Waterfall Model andDataModeling; Creating Process mapping, Use Cases, Sequence diagrams, Activity diagrams
• Developed Test Cases, Test Scripts and SQL to perform Unit Testing, System Testing and Load Testing. Worked wif Operations and Platform teams to migrate ETL Code and DB objects from Development to Testing, UAT and Production.
• Extensive experience wifDataWarehousing, Extraction, Transformation and Loading (ETL) and Business Intelligence (BI) tools.
• Hands on experience in all major facets of Project management - project planning, execution, milestone monitoring, resource utilization and driving a team wif multi vendors and customer.
• UsingFacetsfor various health insurance areas such as enrollment, member, Products and otherFACETSrelated modules
• Knowledge of teh EDI transaction sets such as 837, 834, 835, 270, 271, 276, 277, 999
• Understanding of HIPAA Standards and Compliance issues, HIPAA Privacy policy, opt in/opt out policy.
• Facets support systems were used to enable inbound/outbound HIPAA EDI transaction in support of HIPAA 834, 835, 837 270/271 transactions.
• Proficient in conducting System Testing, Functionality Testing, Regression Testing, User Acceptance Testing (UAT) and training of users
• ExecutedSQL queries and documented them as part of validatingthe Business Objectreportsand for testing purposes
• Involved in maintainingTest MatrixandTraceability Matrixand performingGAPanalysis
• Experience inDataMining,Datamapping andDatamodeling and good understanding of teh ETL tools like AB Initio, SSIS and Informatica Power Center.
• Experience in writing test plans, defining test cases, developing and maintaining test scripts
• Excellent experience in troubleshooting test scripts, SQL queries, ETL jobs,datawarehouse/datamart/datastore models.
• Solid understanding of Membership, Claims Processing, Billing, Benefit/Eligibility, Authorization/Referrals, COB, and has experience in HIPAA standards and corresponding EDI transactions.
• Expertise in Claims, Subscriber/Member, Plan/Product, Claims, Provider, Commissions and Billing Modules ofFacets.

TECHNICAL SKILLS:

Database Tools: SQL Plus, SQL Loader, SQL Developer, TOAD, Autosys, Zone, Serena

ETL Tools: DataStage/Quality Stage, SASDataFlux InformaticsDataQuality

Programming Languages: SQL, PL/SQL, UNIX Business Intelligence shell Scripting, VBScript,PERL, AWK, SED

Reporting Tools: SQL Server Reporting Services (SSRS) 2000/2005/2008/2008R2,Crystal Reports, Report Builder

Databases: Oracle 11g/10g/9.x, DB2 UDB 8.x/7.x

Operating Systems: Windows /XPDOS, UNIX, Linux

RDBMS: SQL, Oracle, and MS Access

Utilities/Application: MS Project, MS Visual, MS Office 03/07 (MS-Word, MS-PowerPointMS-Excel, MS-Access, MS-Outlook)

PROFESSIONAL EXPERIENCE

Confidential, Schenectady, NY

Sr. DataAnalyst

Responsibilities:

• Worked wif SSIS to load individual table and work wif SSRS to generate reports.
• Worked Wif HIPAA compliant ANSI X12 837 formats for both professional claims and institutional claims.
• Experience in calling a Web Service, through SSIS Package
• UsedFACETSAnalytics for fast and easy retrieval, display and grouping of information for performing queries and generating reports.
• Worked wif FACETS, Facets are extended enterprise of Trizetto's solution to assist payer organizations in staying ahead of trends in teh employer benefits market
• Involved in extensiveDATAvalidation by writing several complex SQL queries and Involved in back-end testing and worked wifdataquality issues.
• Construction and test of incrementaldatamovement code (extract, cleanse, validate, transform, and load)
• Performed extensive task which include DataQuality Analysis,Datalineage andDataStandardizationdatastructures,database design,data warehouses, business intelligence/analytic tools, SQL, ETL tools, anddataintegration methods
• DevelopedDatastage parallel jobs using stages Transformer, Modify, Look-Up, Join, Merge, Aggregator, Remove Duplicate, Column Generator, Change Capture, Change Apply, Dataset, Sequential File stage etc.
• Extensively usedDatastageEnterprise Edition (Parallel Extender) to develop various jobs to extract, cleanse and load thedataand also involved in migration from DS to versions.
• UsedDatastageDirector to schedule, monitor, cleanup resources and run job wif several invocation ids.
• Used SharePoint web application platform for content management, document management file management, business intelligence and process integration.
• Scheduled reports for daily, weekly, monthly reports for executives, Businessanalystand customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
• Worked wif Waterfall methodology during teh beginning of teh project then transitioned to Agile methodology
• Worked on design and development inDatastage VTO develop ETL code including:
• Handled Source to TargetDataMapping, Technical Specs documentation, and ETL documentations such as EarlyDataInventory DesignedSSIS Packages to transferdatabetween servers, loaddatainto database on SQL Server 2005 environment and deploy teh data.
• Support for creation and documentation of teh ETL Detailed Design.
• Perform Metadata analysis of teh Grants data dictionary from various grants systems;
• Modified existing program logic to improve overall system performance.
• Created Sequence jobs to control teh flow of jobs and their dependencies
• UsedDatawarehousing forDataProfiling to examine thedataavailable in an existing database.
• Designed and developed matrix and tabular reports wif drill down, drill through and drop down menu option using SSRS.
• Working wif teh application and BusinessAnalystteam to develop requirements
• Translating process/technical solutions for business during defect analysis
• Used TOAD, PL/SQL developer tools for faster application design and developments
• transformation, and wherein you declare a variable wif its URL link
• Participate in teh scrum meeting and also represented teh teamduring teh meeting
• Working through teh phases of SDLC using teh Agile methodology
• Worked closely wif Development team on ETL process,datainfrastructure,datamodeling, business intelligence reporting and dashboards
• Responsible forDatamapping testing by writing complex SQL Queries using WINSQL
• Reviewed ETL and Business Objects defects and proposed fix for defects as per teh scheduled timeframe
• Configured SSIS packages to incorporate slowly changing dimensions for tracking historical data.
• Expert in TSQL, creating and using Stored Procedures, Views, User Defined Functions, implementing Business Intelligence solutions using SQL Server.
• Dealt wif teh EDI transaction 835 claims payments and remittance advice, which deals teh payment from payer to provider.

Environment: IBM Information infosphere Informatica, SSIS, SSRS, COGNOS, Windows XP Toad for Oracle Version, SQL Developer, Agile, Waterfall, Oracle, MS Office tools, Facets, HP Quality Center, Windows, SharePoint, MS Visio.

Confidential, CT

Sr. DataAnalyst

Responsibilities:

• Experience in Data Validation, Data Modeling, Data Flows, Data Profiling, Data Mining, Data Quality, Data Integration, Data Verification, and Data loading
• Worked on generating variousdatamodeling reports and publishing model in various formats.
• Conducted review meetings wif development, QA anddatateam to communicate business requirements.
• Experience in development of data integration solutions using leading ETL products.
• Worked on maintenance of model using teh Complete Compare and Update Model features.
• PerformedDataAnalysis using procedures and functions in PL/SQL.
• Used MS Visio to represent system under development using case diagrams, activity diagrams and workflow diagrams.
• Produced functional specifications and led weekly meetings wif developers and business units to discuss outstanding technical issues and deadlines dat had to be met.
• Performed analysis, review, and estimation of client requests; prepared and reviewed system requirements and client documentation.
• Aided management in standardizing Web applications by preparing GUI standards and recommending alternatives for incorporation in phased, iterative manner.
• Creating teh as is and to be business process model to redesign to eliminate manual operations.
• Structured teh Database and Wrote requirements for designingDataMarts dat were used as teh source for teh various reporting systems in teh company.
• Working wif clients to better understand their needs and present solutions using structured SCRUM approach
• Involved in Analysis, Design and flow of user interface in web application
• Worked wif teh DBA and Database developers to convert teh functional specification to technical specification and generate thedatamodel.
• Conducted JAD Sessions wif teh subject matter experts, stakeholders and other management teams in teh finalization of teh User Requirement Documentation.
• PerformedDataModeling by creating Logical and Physical models of teh database system in ERwin.
• Developed an Intranet Web Server for User Support and System-wide documentation.
• Implemented Agile Scrum methodology for teh project life cycle and scrum framework for team management.
• Participated in Code and Design Reviews for teh ODS project for backendDatapopulation and reporting system.
• Responsible for teh project management activities of a web application including call center application,datawarehousing, customer relationship management,
• Involved in mentoring specific projects in application of teh new SDLC based on teh Agile Scrum and Rational Unified Process, especially from teh project management, requirements and architecture perspectives.
• Prepared interview questionnaires for teh users and gatheird requirements to writing specifications and shaping teh software development process.
• Performed Forward Engineering to generate DDL scripts and Reverse Engineering of theDataModels.
• Consulted wif SMEs and core team about teh requirement and technical issues.

Environment:Erwin Oracle, PL/SQL, MS-SQL Server 2000, Agile/Scrum, DB2, UNIX, MS-Office, MS-Visio, SAML, Windows NT

Confidential, MA

Sr. DataAnalyst

Responsibilities:

• Involved in gathering requirements as per teh consensus meetings between Humana and providers.
• Resolved data quality issues for multiple feeds coming from Mainframe Flat Files
• Creating detailed Data Quality workbooks to define Data Quality Standards and metrics
• Ensuring all teh PLC and PM deliverables are developed in compliance wif company policies.
• Created domain models and made them an integral part of multiple FRDs dat I created for various aspects of teh project.
• Worked on teh EDI 834-file load to Facets through MMS (Membership maintenance sub-system)
• Developed Use Case diagrams and process flow diagrams using Rational Rose and MS Visio.
• Actively prioritized and managed requirements throughout SDLC wif all key stakeholders
• Negotiated and managed multiple priorities, project plans, time frames and trade-offs while ensuring teh clinical and administrative staff understood teh final results of teh projects, sharing detailed vision of cost-benefit analysis.
• Worked on solving teh errors of EDI 834 load to Facets through MMS.
• Provide input to estimates for project management and change management activities through analysis of requirements effort, resources, and technology.
• Worked on EDI 834, 835,837 as per HIPPA guidelines.
• Performed teh detail comparison between 4010A and 5010 especially in regard to EDI 837.
• Used teh Rational Unified process methodology for teh application development and created Use cases, activity diagrams and drafted UML diagrams using teh Rational Rose.
• Worked closely wif teh Business Intelligence (BI) team to define standards for report.
• Worked on cross-functional team to deliver software systems as per teh customer expectations.
• Updated teh requirements and prepared comprehensive Business Requirements Document (BRD) dat provided teh appropriate scope for teh users and management to make appropriate decisions.
• Developed associated project documentation, schedule, design specifications, test plan, test scenarios/scripts, performed gap analysis, and test tracking reporting/monitoring for all phases of testing including B2B user acceptance testing.
• Played a key role in planning UAT and implementation of system enhancements anddatamigration and conversions.

Environment: Microsoft Visio, Windows XP, Facets, MS Office, Rational Requisite, Rational Rose, HP Quality Center, TOAD SQL.