SUMMARY

• Over 7 years of IT experience as Data Analysis/ Modeling/ Integration in the field of Data Warehouse, requirement gathering, architecture, software evaluation and system testing.
• Efficiently carried out SDLC (Software Development Life Cycle) implementation.
• Designed data model, analyzed data for online transactional processing (OLTP) and Online Analytical Processing (OLAP) systems.
• Analyzed data flows and data conflicts between legacy systems and reconcile conflicting or ambiguous information, designed DFDs (Data Flow Diagrams) using Rational Rose.
• Created Logical/Physical data models by identifying facts and dimensions for the dimensional data models (Star and Snow Flake Schemas).
• Very strong in using Case Tools like ERWIN, ER/Studio and Visio and preparing mock - ups (wireframes).
• Normalized tables and dimensions up to 3NF in order to optimize the performance.
• Experienced in developing Conceptual, logical models and physical database design for Online Transactional processing (OLTP) and Online Analytical Processing (OLAP) systems, Master Data Management (MDM).
• Experience in Data Integration techniques like Data Extraction, Transformation and Loading(ETL) from disparate Data Source databases like Oracle, SQL Server, MS Access, flat files, CSV files and XML files into target warehouse using various transformations in Informatica, Data Stage, ODI.
• Developed re-usable Transformations, Mappings and Mapplets in Informatica Design center.
• Developed PLSQL Stored Procedures, Functions and Triggers using Informatica Transformations.
• Experience in writing SQL queries and optimizing the queries in Oracle and SQL Server
• Have understanding and experience with (SDM) Solution Delivery Methodology on application delivery.
• Involved in creation of metadata repository and data mappings according to the business requirements.
• Handled Slowly Changing Dimensions and accumulating snapshots. Involved in Data Collection and performed various data assessment operations like Data Cleansing, Data Scrubbing, Data Standardization, Data Profiling and maintained data governance using Data Flux.
• Created Parallel, Sequential workflows and scheduled workflows according to business rules in Informatica Workflow Manager.
• Solid experience in Process Methodology (SDM, SLC, CMM, ISO).
• Implemented OBIEE reporting tool and developed rpd files (Physical, BMM and Presentation Layers) in Oracle BI Administration tool.
• Utilized global and local filters and created Interactive Dashboards with drill down capabilities.
• Experienced in User Acceptance Testing (UAT), Unit testing, System testing, Integration testing, Development and Production.
• Involved in Performance Tuning, Backup and Recovery Process, Production Support on various platforms. Performed SQL Tuning and created Indexes for faster database access and better query performance.

TECHNICAL SKILLS

Data Modeling: Conceptual, Logical, Physical, OLAP-Star/Dimensional Data Modeling, E-R DiagramsRelational Database Design.

Data Warehousing: Informatica Power Center 7.1.1/7.1.2/8.1 , ORACLE Warehouse Builder (OWB), Oracle Business Intelligence Enterprise Edition (OBIEE).

Database Servers: SQL Server 2000, Oracle 8i/9i/10g/11i, Ms Access, Microsoft Visio2000.

Programming Languages: SQL, SQL*Plus, SQL*Loader, PLSQL, HTML, CSS, XML, Java, Visual Basic 2005, Unix and Scripting Languages shell Scripting.

Tools: Erwin Unified Modeling Language (UML), Power Design, Toad, SQL Server Management Services.

Environment: s: Windows 95/98/2000/XP, MS-DOS, UNIX, Rational Rose.

Reporting: Crystal Reports

Management: Agile/Waterfall Model.

Others: SDLC, Business Analysis, Vendor management and delivery.

PROFESSIONAL EXPERIENCE

Confidential - Wixom MI

Business Analyst

Responsibilities:

• Facilitated UAT meetings with business owners and Test team
• Acquired a strong understanding of the process and data flow from requirements and mapping documents.
• Reviewed the test scenarios and test cases, provided feedback to fill in gaps.
• Helped in validating and verifying cases.

Confidential

Business System Analyst

Responsibilities:

• Participated in meetings with business owners, stakeholders and as a part of business requirements gathering sessions
• Gather requirements from business owner and perform in-depth analysis and developed detailed functional requirements and created process flow diagrams.
• Evaluated Business Intelligence tool from various vendors with the technical team
• Proposed various drill-down paths for the reporting tool

Environment: M.S Office, M.S Visio, Snagit.

Confidential - Southfield MI

Sr. Business Systems Analyst

Responsibilities:

• Participated in JAD/Kick-off meetings with business owners, stakeholders and areas across the company as a part of business requirements gathering sessions.
• Gather Business requirements from stakeholders perform in-depth analysis and develop detailed business/functional requirements and created use case/process flow diagrams, screen mock-ups (wireframes).
• Develop and document medium to high complexity business workflow.
• Good understanding of Claims, Membership & Billing FACETS Data Model and Crosswalks.
• Create Data Mapping Document detailing out the source, transformation rules, and target to generate /external extracts using FACETS data.
• Using SQL’s extract data from Facets tables and other sources like Oracle Data Warehouse.
• Provided Subject matter expertise in Claims, Care Advance, membership areas.
• Worked with vendors to resolve claims data issues related to vendor extracts.
• Participated in ICD-10 prototyping solutions to provide the business unit a preliminary evaluation and/or user interface internal experience.
• Worked with BCBSM BI team to extract Membership/Claims data from IKA System.,NASCO to Care Advance.
• Developed systematic and business recommendations for improved performance based on report analysis.
• Good understanding of EDI transactions like 270/271,276/277,837p/837i.
• Worked with SQL queries using MS Access for data manipulations.
• Involved in analysis to providing FACETS Claims data back into paper form that assist business in paper claims analysis (eDOCS).
• Experience in change control processes, issue tracking and cross-functional communication of impact and successful resolution measures.
• Experience in facilitating successful issue resolution between technical and business teams.
• Act as a liaison between business units, Delivery Leads, Developers, Testers.
• Set up schedules for training, training the users; Validation of canned reports for functionality and data quality.
• Lead Reporting Analysis by working with Business from Blue Cross.
• Good understanding of TriZetto’s Care Advance Data Model.
• Helped the developers and designers in designing and optimizing query and ran queries to provide reconciliation of data by performing analysis
• Performed quality reviews with Business, Medical informatics and IT team and got approvals.
• Gave assistance to development and testing teams in understanding the Care Advance Data model and User Interface (UI).
• Generated test data for Business Users and testing teams in Access.

Environment: Facets Analytical and Reporting Environment (FARE) - Analytical Data Store (ADS) - Oracle, SQL DBX,Top Team, Infomatica ETL, Top Team, SCM, Operational Data Store (ODS) - Sybase and FARE, Microsoft SQL Server, PVCS,Snagit

Confidential, KS

Business Systems Analyst

Responsibilities:

• Lead User Validations by communicating with the users on a daily basis so that they can re-mediate the Data Warehouse.
• Project duties included multiple task project assignments, scheduling, and tracking; facilitating meetings with all levels of the business community for requirements gathering, project development, design considerations, impact and risk analysis, and quality control of client acceptance testing
• Provided Data on an ad-hoc basis to the test team and the business with the help of SQL.
• Created Access DB for Metadata, before uploading into Rochade (Metadata management COT).
• Closely worked with the financial systems architect, developers and the business in requirement gathering and in turn provided them with the high level scope, effort and gap filling estimates.
• Designed and implemented basic SQL queries for testing and report/data validation
• Involved in developing and analyzing the Data in the Teradata Data warehouse and mapping to the Business attribute requirement to create functional and technical documents.
• Analyze and determine the data quality for the source system and target systems
• Acquired in-depth knowledge of the banking industry (Mortgage, Assets, and Accounts Receivables/Accounts Payables etc).
• Closely worked with the data architect and ETL team to bring in additional attributes to support the data requirements and in creating pop specs to source them into the data hub.
• Closely worked with the service developers while implementation of the tech specs, providing solutions to data related concerns.
• Generated test data for Business Users and testing teams in Access.
• Created SQL Reports and queries for statistics for the business users to validate the data.
• Was a Data Steward managing and governing the DB.
• Used Query Analyzer, Execution Plan to optimize SQL Queries
• Worked Closely with Architecture teams on resolving issues related to the application and its dependents.
• Created Logical Master Data Management (MDM) architecture.
• Lead the Knowledge Transfer initiative through web conference.
• Conducted current state study which included data collection methodologies, data quality and data integration problems, data storage and infrastructure related issues.
• Tested the major changes to the application manually and addressed any defects that would pop up during the testing phase.
• Identified and documented business requirements in accordance with SRP’s WaterfallSDM.
• Involved in writing Test Plans and Test Cases using Mercury Quality Center
• Created ER-diagrams for business users to explain the existing physical model with new logical model
• Using Microsoft project had to update the weekly status and scope of the assignments to the project manager.
• Gave valuable input in terms of Modification Requests and Enhancement Requests
• Involved in design, code, test and various other review meeting.

Environment: SQL Server management Studio, Windows XP, MDM, Embarcadero ER Studio, Microsoft Visio Professional 2003, SQL Server 2005 & 2008, Teradata, Business Objects

Confidential, Washington, DC

Business Systems Analyst

Responsibilities:

• Gathered requirements from users for the data changes through surveys, prototyping and observing from UI (user Interface) of the existing system, took screen mock-ups (wireframes)
• Designed and analyzed data in the Data Warehouse and Data marts for the data conflicts or ambiguous information.
• Implemented ODS (Operational Data Store) in the architecture of the data warehouse.
• Analyzed the requirements to identify / resolve data issues and participated in functional design sessions.
• Implemented the project and systems development life cycle in the Equities, Fixed Income and Investment Banking Infrastructure (business, technology and operations)
• Validated data against industry standards and analyzed Data Consistency and data flow from systems standpoint.
• Worked closely with Business Analyst, Data Architect and IT Lead and responsible for designing the DFD’s (Data Flow Diagrams) by using the gathered requirements.
• Followed Agile Methodology to implement some disciplines in SDLC (Software Development Life Cycle).
• Identified key facts and dimensions for the design of the star/snow flake schema.
• Designed Conceptual / Logical / Physical data models using Erwin and documented data analysis results in a logical format to be presented to the client.
• Used reverse engineering to connect to existing database and created graphical representation and involved in script generation.
• Analyzed Teradata and DB2 Source System and determined the necessary data for the requirement.
• Used Query Analyzer, Execution Plan to optimize SQL Queries.
• Acted as a Data Analyst for the CDS implementation the backbone for data integration among myriad systems, including ERP, CRM, Portal, Workflow Engine, Payroll and related interface
• Migrated data from legacy systems to new systems and checked for compatibility of data and their data types.
• Created Metadata Repository and documented for Data Analysis in Informatica.
• Implemented Master Data Management (MDM) for all the high level entities in the project by maintaining a master hub for improving the data quality by following various data governance techniques and data dictionary standards.
• Created specifications and documented source to target mappings according to the business rules and involved in Data Collection.
• Tuned INFORMATICA sessions to increase the cache size, target based commit interval.
• Data Profiling, Data Standardization, Data cleansing, Data Replication and Data scrubbing operations are performed for data assessment using the Expression transformation.
• Created mapplets, workflows and sessions using source, target and transformations to run the mappings in the desired order.
• Performed database tuning to improve performance by creating and modifying table space and querying database using SQL and informatica.
• Performed Unit testing, User Acceptance Test and also documented test cases for UAT.

Environment: InformaticaPower Center 8.1.1, Oracle 10G, MDM, DB2, SQL Server 2005, UNIX shell Scripting, Erwin, Toad, snagit

Confidential, Charlotte, NC

Business Systems Analyst

Responsibilities:

• Developed, analyzed and maintained Alltel Data Warehouse and Data marts for customer support enterprise Data Warehouse.
• Assisted SME’s in looking at the database architecture and in designing the Business Solution Templates (BST) to guide the investigation (Gap Analysis) and scope the requirements.
• A series of meetings / JAD sessions were conducted to gather requirements from business system users for reporting purposes.
• Developed SQL queries using SQL Navigator to extract data from the target tables to prove the data mapping.
• Facilitated four extensively used Star Schema methodology in building the design of the logical data model into the Dimensional data modeling.
• Adopted Kimball life cycle, Bus Architecture and Dimensional Data Modeling to create a clean and effective Enterprise Data Warehouse.
• Identified the grain, key dimensions and facts for the star and snowflake design and developed logical/physical data modeling.
• Involved in design and development of standard and ad-hoc reporting using SQL.
• Followed the organization Data dictionary Standards in Data Collection, Data Conversions, Data Acquisitions and performed Gap Analysis while transforming data from legacy systems to updated technologies using custom SQL scripting as well as ETL applications from Relational Solutions.
• Identify and document, business functions, activities and processes, data attribute and table meta-data, and general and detail design specifications.
• Created walkthroughs and validations on logical model and created physical data model using forward engineering.
• Analyzed data requirements, data accuracy and created specifications for the ETL team to load data into the target database and insisted them with source to target mappings and with the tables, columns and other database objects.
• Assisted the ETL team to understand the model and insisted them with source to target mappings and with the data elements like tables, columns, data types, primary and foreign keys, default values and other data structures.
• Created documentation and test cases, worked with users for new module enhancements and testing.
• Focused on development of integrated data environment with minimal Data Redundancy.
• Design, plan and program data conversion procedures from old to new databases.
• Involved in Data Conversions and Gap Analysis from source systems to updated technologies using custom SQL scripting as well as ETL applications from Relational Solutions.
• Worked with Business Analyst to create hierarchies and design reports using OBIEE (Oracle Business Intelligence Enterprise Edition).
• Coordinated bug fixing activities related to issues rose during end - User Acceptance Testing (UAT).

Environment: Informatica Power Center, OBIEE, Oracle 9i/10g, MS SQL Server 2000, UML, Microsoft Visio 2003, and Erwin.

Confidential, Milwaukee, WI

Business Systems Analyst

Responsibilities:

• Gathered requirements from the clients/users and created use case diagrams for the analyses of those requirements.
• Gathered and analyzed data in support of SOP’s, business use cases, proposed projects, and systems requirements for mortgage loan origination system using RUP standards.
• Analyzed the data for data changes, developed DDL and DML scripts, created templates and documented the analysis results in a logical format and checked for data accuracy.
• Produced external procedural documentation for the customer deliverables to include assumptions, data flow charts, field definitions and process flows.
• Facilitated JAD sessions with the business and IT and revaluated all the reviews for the development and implementation of appropriate project plan.
• Conducted a series of meetings with a team of business system users to determine the final requirements for reporting.
• Interacted with the end users to determine the level of grain for the project.
• Identified key dimensions and fact measures according to their hierarchy level, designed logical/physical models.
• Created specifications, developed effective mappings to load data into database and conducted performance tuning to the model for effective results.
• Connected to the existing database by performing reverse engineering and re-created the E-R diagram by refining the existing data model.
• Extensively used Erwin tool in creating Entity Relationship diagram in notational formats like IDEF1X, IE and in maintaining Metadata.
• Assisted in data extraction from Flat Files, Excel sheets, Xml files and also from Databases and helped in loaded the extracted data the target systems.
• Identified appropriate data validation procedures and resolved data issues.
• Utilized SQL and Informatica to check for data consistency from source systems to target database.
• The data model is created using the knowledge of the object oriented and generalization concepts.

Environment: Oracle 9i, SQL Server 2000, Erwin, Rational Rose, Win 2000, Informatica 7.1.1, 7.1.2.

Confidential, Oklahoma City, OK

Business Systems Analyst

Responsibilities:

• Designed ER diagrams and managed database objects like tables, views, indexes etc.,
• Created the best fit physical model from the logical model and helped the DBA in the physical implementation of the model.
• Identified the grain, key level facts and dimensions required for designing a model.
• Performed UAT, Data Quality, Data validation and Data integrity checks on the Bank Data Warehouse.
• Designed Conceptual, Logical and Physical models using Erwin data modeling tool and created Star / Snow flake schema by identifying key facts and dimensions needed for the design.
• Documented Source to target mappings and created complex mappings and Mapplets using Informatica Design Center.
• Responsible for maintaining Master Data Management (MDM) Hub and distribution of appropriate information according to the requirement.
• Performed tuning on SQL queries and PLSQL procedures.
• Conducted Data Profiling and data assessment activities like Data replication, Data Cleansing, Data Standardization and Data Scrubbing for maintaining data quality.
• Coordinated bug fixing activities related to issues raised during end - User Acceptance Testing (UAT).

Environment: Erwin, PLSQL procedures, functions, Informatica 7.1.1, MDM, Oracle 9i, MS-Visio.