PROFESSIONAL SUMMARY:

• Around Solid 8 years Of Experience in the field of Data warehousing, Data Analysis, ETL and Business Intelligence.
• Domain Expertise in the field of Healthcare/Pharmaceutical.
• DataModelerwith strong Conceptual, Logical and PhysicalDataModeling skills,DataProfiling skills, MaintainingDataQuality,
• Experience with JAD sessions for Requirements gathering, Creating Business Specification Documents, Creating datamapping documents, writing Functional Specifications Documents, Use Cases, UML Diagrams, Flowcharts, Queries.
• Experience on various Software Development Life Cycles including Analysis, Design, Development and Testing to solidify client requirements in conjunction with Software Developers.
• Experience in ETL tool Informatica Power Center 9x/8.x with Oracle 11g/9i/10g, experience in SSIS and SQL ServerDataWarehouse in Microsoft DW/BI environments.
• Experience in Data modelling, Reporting and Business intelligence tool OBIEE (Oracle Business Intelligence Enterprise Edition) for building Repositories, Dashboards etc.
• Experience in implementingDatawarehousing solutions involving Dimension modeling, Star and Snow flake schema implementation (3 NF).
• Experience in integration of variousdatasources with multiple Relational Databases like SQL Server, Oracle and DB2.
• Experience in RDBMS (Oracle) PL/SQL, SQL, Stored Procedures, Functions, Packages, Triggers worked with Terabytes of Volume databases.
• Experience in building Dashboards, BI Repositories.
• Hands on experience in migrating database application from legacy to newer technology,data movement,datamapping
• Good experience indatatransformation,datamapping from source to target database schemas and alsodatacleansing.
• Experience in modeling with both OLTP/OLAP systems and Kimball and in MonDataWarehousing environments.
• A good expertise in Extract Transform and Load (ETL)datafrom spreadsheets, database tables and other sources using MicrosoftDataTransformation Service (DTS) and Informatica.
• Experience in Healthcare Claim Processing, ICD9 to ICD10 code conversion.

TECHNICAL SKILLS:

Databases/Tools: Oracle 8i/9i,10g/11g MS SQL Server 2000, MySQL, MS Access, Mainframe Files, XML, SQL Navigator, SQL, PL/SQL

ETL Tools: Informatica Data Virtualization 9x, Informatica Power Center 9x, 8x, 7x/6.1

BI Tools: OBIEE, Siebel Analytics, Siebel

Architectures: OLAP, OLTP

Operating Systems: Windows 95/98/2000/XP, UNIX

Programming Languages: SQL, Shell Scripting, C, C++, XML, HTML

PROFESSIONAL EXPERIENCE:

Confidential, NYC

Data Analyst

Responsibilities:

• Gathered Business requirements by organizing and managing meetings with business stake holders, Application architects, Technical architects and IT analysts on a scheduled basis.
• Closely worked with business analysts/Data Modeler(DM) in the process of requirements gathering for various application specific databases
• Created Functional Specification Documents illustrating Use cases and flow charts.
• Performing various Validations on the Claims for Monthly submissions.
• Monthly Submissions included submitting Claims from HIP and GHI regions.
• Participated in ICD9 to ICD10 Diagnosis Code Conversion.
• Participated in Various Vendor Submissions Including Medical Groups (MPG, SIPP, QLIMG), Inovalon, Altegra etc .
• Worked on two sources to bring in required data needed for reporting for a project by writing SQL extracts
• Analyzed the business requirements by dividing them into subject areas and understood the data flow within the organization
• Created a Data Mapping document after each assignment and wrote the transformation rules for each field as applicable
• Created DDL scripts for implementing Data Modeling changes. Created OBIEE reports in format depending upon the requirement, Published Data model in model mart, created naming convention files, co - coordinated with DBAs' to apply the data model changes.
• Used OBIEE for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Conducted GAP analysis and data mapping to derive requirements for existing systems enhancements for a project.
• Designing and customizing data models for Data warehouse supporting data from multiple sources on real time
• Developed the logical data models and physical data models that confine existing condition/potential status data fundamentals and data flows using OBIEE
• Defined the Primary Keys (PKs) and Foreign Keys (FKs) for the Entities, created dimensions model star and snowflake schemas using Kimball methodology
• Facilitated JAR/JAD sessions to determine data definitions and business rules governing the data, and facilitated review sessions with subject matter experts (SMEs) on the logical and physical data models.
• Applied data naming standards, created the data dictionary and documented data model translation decisions and also maintained DW metadata.
• Design and develop the subject area, business model, mapping, presentation catalog, answers, and complex dashboards for call center survey Siebel module in OBIEE.
• Design, conceptual, logical and physical data model, and build data warehouse for system using ETL Informatica and schedule the jobs in DAC for nightly incremental refresh.
• Use operator to view and manage integration jobs as well as manage users and their repository privileges in security manager.
• Used data profiling tools and techniques to ensure data quality for data requirements.

Environment: Oracle 11g, OBIEE, Informatica, ETL, Microsoft 2008, SQL Developer, SQL Manager, SQL Developer Data Modeler, Microsoft SQL Server 2012, SQL Manager

Confidential, NYC

Data Analyst

Responsibilities:

• Part of the team responsible for the analysis, design and implementation of the business solution.
• Facilitated development, testing and maintenance of quality guidelines and procedures along with necessary documentation
• Created BRD and FSD as per the requirements given in by the users.
• Conducted logical data analysis and data modeling JAD sessions, communicated data-related standards.
• Used Model Mart of OBIEE for effective model management of sharing, dividing and reusing model information and design for productivity improvement
• Used Star Schema and Snow flake schema methodologies in building and designing the logical data model in the dimensional Models.
• Redefined many attributes and relationships in the model and cleansed unwanted tables/columns as part of Data Analysis responsibilities.
• Involved with the Business Analysts' team in requirements gathering and based on provided business requirements, defined detailed Technical specification documents.
• Analyzed the Business information requirements and examined the OLAP source systems to identify the measures, dimensions and facts required for the reports.
• Utilized Power Designer's forward/reverse engineering tools and target database schema conversion process.
• Documented logical, physical, relational and dimensional data models. Designed the data marts in dimensional data modeling using star and snowflake schemas.
• Redefined attributes and relationships in the model and cleansed unwanted tables/columns as part of data analysis responsibilities.
• Worked on the reporting requirements and involved in generating the reports for the Data Model.
• Initiated and conducted JAD sessions inviting various teams to finalize the required data fields and their formats.
• Conversed with Business Analyst and developers to gather information about the data models (Data Definition) to place the data dictionary in place.
• Designed different type of STAR schemas for detailed data marts and plan data marts in the OLAP environment.
• Interacted with Business analysts and Developers to gather the Data Definitions for the Data Models to get the Data Dictionaries in place.
• Created DMR mapping spreadsheets, Source to Target mapping documents including the transformation rules
• Transformed requirements into data structures which can be used efficiently to store, manipulate and retrieve information.
• Worked with the Business and the ETL developers in the analysis and resolution of data related problem tickets and other defects.

Environment: Erwin, Informatica, Windows XP/NT/2000, SQL Server 2000/2005, SQL, Oracle 10g, MS Excel, MS Visio, Oracle 10g/9i, TOAD, CSV files, XML files, UNIX

Confidential

Data Analyst/Developer

Responsibilities:

• Participated in User meetings, gathering requirements, Functional Design documents discussing the issues to be resolved.
• Development of tasks for OBIEE, and Informatica as an ETL tool.
• Identify Source tables (OLTP) and Target tables (OLAP) for Data mapping.
• Involved in Data analysis and Validations after completing the loads.
• Participate in Design Reviews of Data model and Informatica mapping design.
• Assisted in creating Logical and Physical data modeling.
• Development of mappings workflows and session tasks using Informatica Power Center.
• Developed mapping to load the relational data model for operational data store and staging areas, Designed Dimension & Fact tables for data marts.
• Developed Informatica ETL Mappings documents, created ETL staging area framework, created data mapping documents, data flow diagram, ETL test scripts etc.
• Analyzed and optimized the existing business processes using Conceptual Models and Data Flow Diagram. The process included performance enhancement requirements assessment and mapping of existing work flow and data flows..
• Participated in testing Data matching between Siebel and Siebel Analytics Databases and Dashboards.
• Involved in RPD development using Admin tool to build Physical layer, BMM layer and presentation layer.
• Identified joins, tables, Dimensions, Facts, Aggregates, and Measures etc.
• Unit testing the reports, debugging and fixing the errors for Right reports.
• End to End testing of Reports for data and functional behavior.
• Providing support and fixing issues related to Data on Reports, Dashboards etc.
• Provided RPD support to manage the Reports and Dashboards.
• Worked using Oracle SQL.
• Monitoring Daily ETL data load in DAC.
• Involved in Moving the RPD from DEV to QA, QA to PROD. Also, involved in moving the Web Catalog used for Reporting from DEV to QA and QA to PROD.
• Involved in Informatica Mappings migration from DEV to QA, QA to Prod.

Environment: s: ETL, OBIEE, Informatica 7.7.212, Siebel Analytics 7.8.52, Siebel CRM 7.8, DAC 7.7.1, Toad, Windows XP

Confidential

Data Analyst / Developer

Responsibilities:

• Interacted with business and users, gathered the business requirements, designed and developed functional requirement documents for loan, fund, consolidate enrollment tool, and beneficiary maintenance.
• Designed and developed complex reports, interactive dashboard, answers related to payroll deduct and direct bill loan, fund, consolidate enrollment tool and beneficiary maintenance.
• Built the Siebel Analytics repository (RPD) /metadata and defined/created the subject areas where reporting and analysis were centered around.
• Constructed data visibility and security rules as well as implemented them within Siebel Analytics to provide record-level, team-based, and group-based security into the Data warehouse.
• Collaborated with client to define corporate Key Performance Indicators, business intelligence corporate strategy, and roadmap.
• Created, modified, and administered analytics intelligence interactive dashboards, answers with links to web sites, HTML text, links to documents, and embedded content, such as images, text, charts, and tables.
• Captured and documented Business Requirements from client conducting interviews and workshops.
• Completed the development on the functional and the technical specifications.
• Assisted in the performance of gap Analysis related to Data Models and data extracted in ETL’s, and map client requirements into OBIEE/ Siebel Analytics functionality.
• Extensively handled data modeling, including multi-dimensional modeling & Data Warehousing.
• Built the Star Schemas based on the functionality.
• Designed, configured, and documented logical and Physical Data Models.
• Presentation Layer included the administrator functionality.
• Produced on the different layers of the Siebel Administration Tool.
• Designed, built, and tested reports, Dashboards, BI Publisher, Microsoft Integration, and other functionality within the OBIEE suite.
• Create Oracle BI metadata in the analytics repository with Oracle BI Administration Tool.
• Implemented Multi-User Development (MUD) in Production and created dimension hierarchies to achieve the drill down functionality.
• Performed administrative tasks like creating Users and assigning them to a group and restricting users to the development environment.
• Implemented caching to increase performance as well as created, modified, and administered analytics intelligence dashboards.
• Maintained Session and Security in OBIEE and created users and groups assigning these users and groups to the Dashboards.
• Developed Test Plan including test scripts for Unit, System, and User Acceptance Testing including resolution of bugs.
• Delivered world class business and technology solutions that enable client to become high performance businesses.
• Led configuration of in-scope functional and technical requirements based on design documents including data structures, data mapping, and related Performance Tuning.
• Involved in Moving the RPD from DEV to QA, QA to PROD. Also, involved in moving the Web Catalog used for Reporting from DEV to QA and QA to PROD.

Environment: s: ETL, BI, Informatica 7.7.212, OBIEE 10g, Siebel CRM 7.8, DAC 7.7.1, Toad, Windows XP

Confidential

OBIEE Tester/Data Analyst

Responsibilities:

• Preparation of test scripts and testing the same.
• Security testing was carried out for various logins (i.e.) different positions in the hierarchy to ensure data integrity.
• Performance testing was carried out to check if links, drilldowns, prompts etc. open within the specified time as indicated.
• Editing the queries and execution of the same in Toad.
• Have been involved in understanding new change requirements and development of test cases for the same.

Environment: s: OBIEE 10g, Toad, MS Excel, Windows XP