SUMMARY:

• 8 years of experience in analyzing, designing and developing client/server, Business Intelligence (BI) database applications, Requirement Elicitation, ETL, Data visualization, Analytics, Data Integration and related database Platforms in banking and Health Care sectors.
• Experienced in ETL, data analysis with solid understanding of Business Requirements Gathering, Data warehousing, Business Intelligence, Data Mapping and Data Modeling.
• Experienced in MS - SSRS, SSIS, SSAS, OLTP, OLAP, Slowly Changing Dimensions, Data Cleansing and Data Migration.
• Experienced in generating and documenting Metadata while designing OLTP and OLAP systems environment.
• Extensive work experience in ER Modeling, Dimensional Modeling (Star Schema, Snowflake Schema) and Data Warehousing, OLAP tools.
• Experienced in developing conceptual, logical and physical data models as per enterprise standards.
• Experienced in Database Programming SQL & PLSQL, MS Access, Oracle 12c/11g/10g/9i, XML, DB2 Teradata, Database Tuning and Query Optimization.
• Experienced working with data modeling tools like Erwin, Power Designer and ER Studio.
• Experienced in designing star schema, Snowflake schema for Data Warehouse, ODS architecture.
• Experienced in Data Modeling, ETL & Data Analysis experience using Dimensional Data Modeling and Relational Data Modeling, Star Schema/Snowflake Modeling, FACT & Dimensions tables, Physical & Logical Data Modeling.
• Experienced in Data Profiling, Analysis by following and applying appropriate database standards and processes, in definition and design of enterprise business data hierarchies.
• Provided subject matter expertise to internal staff and customers on Optum/Caremedic billing applications: Claims Management, MedicareRT, EFR, Enterprise Gateway, Dashboard, etc...
• Managed Knowledge Base project which included creating documentation of processes, procedures and troubleshooting steps.
• Experienced in Data Scrubbing/Cleansing, Data Quality, Data Mapping, Data Profiling, and Data Validation in ETL.
• Experienced in creating and documenting Metadata for OLTP and OLAP when designing a system.
• Performed data analysis and data profiling using complex SQL on various sources systems including Oracle and Teradata.
• Extensive experience in development of T-SQL, DTS, OLAP, PL/SQL, Stored Procedures, Triggers, Functions, Packages, performance tuning and optimization for business logic implementation.
• Experienced using query tools like SQL Developer, PLSQL Developer, and Teradata SQL Assistant.
• Excellent in performing data transfer activities between SAS and various databases and data file formats like XLS,CSV,DBF,MDB etc.
• Expertise in developing standard and re-usable mappings using various transformations like expression aggregator, joiner, source qualifier, lookup and router.
• Expertise in designing complex Mappings and have expertise in performance tuning and slowly-changing Dimension Tables and Fact tables.
• Expertise in extracting, transforming and loading data between homogeneous and heterogeneous systems like SQL Server, Oracle, DB2, MS Access, Excel, Flat File etc. using SSIS packages.
• Experienced in Performance tuning on Oracle databases by leveraging explain plans, and tuning SQL queries.
• Proficient in System Analysis, ER/Dimensional Data Modeling, Database design and implementing RDBMS specific features.
• Expertise in analyzing and documenting business requirement documents (BRD) and functional requirement documents (FRD) along with Use Case Modeling and UML.
• Excellent understanding and working experience of industry standard methodologies like System Development Life Cycle (SDLC), as per Rational Unified Process (RUP), AGILE Methodologies.
• Excellent Team player to work in conjunction with Business analysts, Production Support teams, Subject Matter Experts, Database Administrators and Database developers.
• Excellent analytical, inter-personal and communication skills with clear understanding of business process flows.

TECHNICAL SKILLS:

Data Modelling Tools: Erwin 9x, 8x, 7x, Sybase Power Designer, ER Studio and Oracle Designer, MDM Infosphere, Purisma 4.1.3 MDM Tool.

Data Modelling: Logical Model, Conceptual Model, Physical Model, Star-Schema Modeling, Snowflake Schema, FACT & Dimension, Facets, OLAP, HOLAP, MOLAP, ROLAP

OLAP Tools: Tableau, SAP BO, SSAS, Business Objects, and Crystal Reports 9, ACL

ETL Tools: SSIS, Pentaho, Informatica, Power Center 6.0/7.1/8.1.1, Power Mart 6.0.

Programming Languages: Java, Base SAS and SAS/SQL, SQL, T-SQL, UNIX shells scripting, PL/SQL.

Database Tools: Microsoft SQL Server 2000/2008/2012, IBM DB2, Teradata, Oracle 12c/10g/9i, and MS Access, PostgreSQL.

Reporting Tools: Business Objects, Crystal Reports, OBIEE, SAS Enterprise Guide

Packages: Microsoft Office 2010, Microsoft Project 2010, SAP and Microsoft Visio, Share point Portal Server 2003/2007.

Big Data: Hadoop, HDFS 2. Hive, Pig, HBase, Sqoop, Flume.

Operating Systems: Microsoft Windows 9x / NT / 2000/XP / Vista/7 and UNIX.

Quality Assurance Tools: Quick Test Pro, Win Runner, Load Runner, Quality Center.

Other Tools: MS-Office suite (Word, Excel, Project and Outlook), BTEQ, Teradata, SQL Assistant.

PROFESSIONAL EXPERIENCE:

Confidential,Cranston, RI

Sr. Data Analyst/ Business Analyst

• Executed continuous monitoring activities in Internal Audit Department using ACL for assigned business area, working with the senior Audit Director to assess and conclude the quality of internal controls.
• Communicated effectively to provide credible advice in areas of expertise to Internal Audit Teams and collaborated with stakeholders to drive improvement to Data Analytics Team.
• Maintained and design Data Analytics tools/applications based on expertise and ensured Internal Audit and business line requirements are met.
• Extensively worked with SAS programming for auditing data, developing data, performing data validation QA and improve efficiency of SAS programs.
• Independently validated retail credit MRAs related to reporting, requested by OCC which extensively focused on SAS coding and programming.
• Extensively participated in translating business needs into Business Intelligence reporting solutions by ensuring the correct selection of toolset available across the Tableau BI suite.
• Built analytics solutions using variety of technologies and analytics tools as required by the line of business, and created robust documentation of solutions and underlying design decisions and operating procedures.
• Performed Data analysis and Data profiling using complex SQL on various sources systems including Oracle and Teradata and migrated critical reporting systems to Business Objects and Web Intelligence on a Teradata platform.
• Implemented data refreshes on Tableau Server for biweekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Maintained large data sets, combining data from various sources by Excel, SAS Grid, Enterprise, Access and SQL queries and analyzed Data Sets with SAS programming, R and Excel.
• Developed Data mapping specifications to create and execute detailed system test plans. The data mapping specifies what data will be extracted from an internal data warehouse, transformed and sent to an external entity.
• Created Mapping Specification document to outline mapping data from source systems to the target data warehouse.
• Extensively involved in Data Extraction, Transformation and Loading (ETL process) from Source to target systems using Informatic Power Center.
• Used data analysis techniques to validate business rules and identify low quality missing data in the existing data.
• Analyzed Requirements and created Business Requirement Document (BRD), Current business process flow, Future business process flow, Use Cases, Use Case Diagrams, and Activity Diagrams using Microsoft Visio.
• Wrote complex SQL, PL/SQL Testing scripts for Backend Testing of the data warehouse application.
• Reviewed normalized/Denormalization schemas for effective and optimum performance tuning queries and data validations in OLTP and OLAP environments.
• Involved in understanding the Internal Auditors needs with regards to data, documenting requirements, developing complex SQL statements to extract the data and packaging/encrypting data for delivery to customers.

Environment: SQL Server 2008, SQL Server Analysis Services 2008, SSIS 2008, SSRS 2008, Windows 2000, Micro strategy 9.3, Erwin, Informatica Power Center, power designer, CSV files, XML files, Business Objects, Oracle10g, SharePoint, SAS, ACL, Teradata, TeamMate, Tableau.

Confidential, Boston, MA

Sr. Data Analyst/ Business Analyst

• Translated the business requirements into workable functional and non-functional requirements at detailed Production level using Workflow Diagrams, Sequence Diagrams, Activity Diagrams and Use Case Modeling as per the requirement set for the project by OCC (Office of the Comptroller of the Currency).
• Worked with Database Administrators, Business Analysts and Content Developers to conduct design reviews and validate the developed models.
• Identified, formulated and documented detailed business rules and Use Cases based on requirements analysis.
• Identified all necessary Business and System Use Cases from requirements, created UML diagrams including Use Case Diagrams, Activity Diagrams, and Sequence Diagrams using Microsoft Visio.
• Created SSIS packages to Export data from text file to SQL Server Database.
• Facilitated development, testing and maintenance of quality guidelines and procedures along with necessary documentation.
• Performed Reverse Engineering in the existing data marts and identified the Data Elements (in the source systems), Dimensions, Facts and Measures required for reports.
• Involved in exhaustive documentation for technical phase of the project and training materials for all data management functions.
• Developed Complex Stored Procedures, Views and Temporary Tables as per the requirement for reporting.
• Worked on Santander banking products and retail products such as checking, savings, credit cards, loans, lines of credit and/or small business banking with understanding or processes at branch networks and call centers.
• Worked closely on banking compliance investigations, strong knowledge of audit practices for handling of evidence and findings, analysis of structured and unstructured data, evaluation of violations, determine level risks and/or of compliance, documentation of findings.
• Facilitated Agile Adoption Retrospective for the organization with the leadership and guided teams with outcome resulting in enhanced performance.
• Actively Involved in Sprint planning, backlog refinement and release management activities using JIRA tool.
• Created and maintained Logical Data Model (LDM) for the project. Includes documentation of all entities, attributes, data relationships, primary and foreign key structures, allowed values, codes, business rules, glossary terms, etc.
• Validated and updated the appropriate LDM's to process mappings, screen designs, use cases, business object model, and system object model as they evolve and change.
• Created SQL Server Reports and developed query for generating drill down and drill through reports using SSRS.
• Created customized SharePoint Sites, SharePoint Lists, Features, Workflows, and Document Libraries using SharePoint Object Model programming. Involved in preparing logical data models and conducted controlled brain-storming sessions with project focus groups.
• Pulling data daily from OLTP database to OLAP or staging database using the SSIS packages.
• Worked with the Implementation team to ensure a smooth transition from the design to the implementation phase.
• Worked closely with the ETL Developers to explain the complex Data Transformation Logic.
• Employed naming standard editor for defining new naming standards for the entities, attributes, domains, columns and tables that applied consistently all over the enterprise.
• Provided source to target mappings to the ETL team to perform initial, full, and Incremental loads into the target data mart.

Environment: SQL Server 2008, SQL Server Analysis Services 2008, SSIS 2008, SSRS 2008, Windows 2000, Micro strategy 9.3, Erwin, Informatica Power Center, power designer, CSV files, XML files, Business Objects, Oracle10g, SharePoint, SAS, Tableau.

Confidential,Mahwah,NJ

Sr. Data Analyst/ Business Analyst

• Provide data architecture support to enterprise data management efforts, such as the development of the enterprise data model and master and reference data, as well as support to projects, such as the development of physical data models, data warehouses and data marts.
• Lead the strategy, architecture and process improvements for data architecture and data management, balancing long and short-term needs of the business.
• Created and maintained Logical and Physical models for the data mart and created partitions and indexes for the tables in the data mart.
• Involved in ETL Data Analysis, Data Cleansing, Requirements gathering, Business Analysis, Entity Relationship diagrams (ERD), Architectural design docs, Functional and Technical design docs, and Process Flow diagrams.
• Created entity / process association matrices, entity-relationship diagrams, functional decomposition diagrams and data flow diagrams.
• Analyze data model, write business algorithms using stored procedures and queries, and perform proof of concepts for new data architecture.
• Preparing Dashboards using calculations, parameters in Tableau .
• Designed different type of STAR schemas using Erwin with various Dimensions like time, services, customers and FACT tables for Claims related project.
• Working with technical analysts and software developers to identify and design data models based on requirements definitions and interactive discussions to support both new and existing application system processes.
• Managed Knowledge Base project which included creating documentation of processes, procedures and troubleshooting steps.
• Provided support to full Software Development Life Cycle, testing, training and implementation.
• Analyzed the functional details of various modules in mainframe and did the GAP analysis with the new system.
• Created and implemented support project to ensure quality and streamline support policies / procedure.
• Implemented standards and methods to measure the performance and resolution quality of the product support analysts.
• Developed and maintains data models and data dictionaries, data maps and other artifacts across the organization, including the conceptual and physical models, as well as metadata repository
• Developed SQL scripts for creating tables, Sequences, Triggers, views and materialized views and Defined and implemented data quality maintenance processes.
• Involved in designing and developing Data Models and Data Marts that support the Business Intelligence Data Warehouse.
• Perform data profiling and data analysis to enable identify data gaps and familiarize with new source system data.
• Designed dimensional models that can reduce development time for InfoSphere Data Warehouse and IBM Cognos Business Intelligence reporting.
• Extensively used ETL to load data using Power Center / Power Exchange from source systems like Flat Files and Excel Files into staging tables and load the data into the target database Oracle.
• Developed multiple MapReduce jobs in java for Data Cleaning and pre-processing analyzing data in PIG.
• Analyze existing source system with the help of Data Profiling and source system data models thus creating individual data models for various domains/subject areas for the proposed data warehouse solution.
• Transforming staging area data into a STAR schema (hosted on Amazon RedShift) which was then used for developing embedded Tableau dashboards.
• Translating business requirements into SAS code for use within internal systems and models and performed Unit Testing, System Integrated Testing for the aggregate tables.

Environment: Oracle 12c, SQL Plus, Erwin 9.6, MS Visio, SAS, Source Offsite (SOS), Hive, PIG, Windows XP, AWS, QC Explorer, Share point workspace, Teradata, Oracle, Agile, Data Stage, MDM, Netezza, Facets, IBM Infosphere, SQL, PL/SQL, IBM DB2, SSIS, Power BI, Redshift, Business Objects XI3.5,COBOL,SSRS, QuickData, Hadoop, MongoDB, HBase, Cassandra.

Confidential,New York

Sr. Data Analyst/ Business Analyst

• Conducted or performed business data modeling and analysis exercises in support of subject areas and specific client needs for data, reports, or analyses, with a concern towards reuse of existing data elements, alignment with existing data assets and target enterprise data architecture.
• Developed conceptual, logical, and physical Enterprise Data Model based on industry standards.
• Involved in preparing logical data models and conducted controlled brain-storming sessions with project focus groups.
• Used Model Mart of ER/Studio for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Involved in designing Context Flow Diagrams, Structure Chart and ER- diagrams and worked on database features and objects such as partitioning, change data capture, indexes, views, indexed views to develop optimal physical data mode.
• Adopted Unified Modeling Language (UML) methodologies to plan and define system requirements to model Use Case, Use Case Scenario and Use Narrative.
• Accomplished efficient JAD sessions with management, SME, vendors and other stakeholders for open, pending and critical issues.
• Translated the business requirements into workable functional and non-functional requirements at detailed production level using Workflow Diagrams, Sequence Diagrams, Activity Diagrams and Use Case Modelling.
• Designed the Logical Model into Dimensional Model using Star Schema and Snowflake Schema.
• Worked with SQL, SQL PLUS, Oracle PL/SQL Stored Procedures, Triggers, SQL queries and loading data into Data Warehouse/Data Marts.
• Rationalized the relationships expressed in the logical data model to the schema of the physical data store (that is, database tables and columns).
• Involved in the design and development of user interfaces and customization of Reports using Tableau and OBIEE and designed cubes for data visualization, mobile/web presentation with parameterization and cascading.
• Used SAS extensively to create ad hoc reports, match merge and created graphs by using SAS/GRAPH base.
• Employed Rational Requisite Pro as a user to analyze the Business Requirements and developed test plans, test cases and test strategy using Rational Test Manager.
• Developed complex SQL queries, and perform execution validation for remediation and Analysis.
• Developed SQL queries on Teradata to get the data from different tables using joins and database links.

Environment: ER/Studio, Windows 7, Microsoft Office SharePoint 2007, Facets, Cognos, Rational Requisite Pro, MSOffice (Word, Excel and PowerPoint), Teradata, MS Project, MS FrontPage 2003, MS Access, CSVfiles, EDI, Documentum 2.0., UML, Java, Erwin, MS Visio, Oracle 11g, Oracle Designer, SQL Server 2008, OracleSQL developer 2008, Micro strategy 9.2, Tableau report builder, SQL, SAS, T-SQL

Confidential, Lexington, Massachusetts

Business Analyst / Data Analyst

• Gathered business requirements through interviews, surveys, prototyping and observing from account managers and UI (User Interface) of the existing Broker Portal system.
• Identified the objects and relationships between the objects to develop a logical model in Erwin tool.
• Prepared High Level Logical Data Models and BRDs (Business Requirement Documents), supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the actors to analyze and document business data requirements.
• Involved in migration of various objects like stored procedures, tables, and views from various data source to SQL Server.
• Part of team conducting logical data analysis and data modeling communicated data-related standards. Conducted Design discussions to come out with the appropriate Data Mart.
• Designed different type of STAR schemas like detailed data marts and Plan data marts, Monthly Summary data marts using Erwin with various Dimensions Like Time, Services, Customers and various FACT Tables.
• Assisted in migration of data is performed from various OLTP servers and documented issues related to data cleansing.
• Created data mapping documents mapping Logical Data Elements to Physical Data Elements and Source Data Elements to Destination Data Elements.
• Implemented Slowly Changing Dimensions Type2 and Type3 for accessing history of reference data changes.
• Identified entities and attributes and developed conceptual, logical and physical models using Erwin.
• Used reverse engineering to create Graphical Representation (E-R diagram) and to connect to existing database.
• Generated comprehensive analytical reports by running SQL queries against current databases to conduct data analysis.
• Writing Complex SQL queries in Teradata to pull the records with data issues reported by the users using complex joins, partitions, ordered analytical functions, aggregate functions etc.
• Created documents for logical, physical and dimensional data models.
• Establish documentation for agile methodology for implementation with a very water-fall-centric development team.
• Created various SQL Schema, Triggers, views, index/keys and stored procedures along with compiling them in SQL server and troubleshoot errors.
• Returned mail also provides an opportunity to improve your CRM database. In this case CRM is Critical Records Management as well as Customer Relations Management.
• Created data model for the star schema using Erwin, created DDL scripts for static dimensions.
• Analyzing query results in Excel, creating pivot table/chart reports etc. and sharing them with MDM team members.
• Developed data mapping documents between Legacy, Production, and User Interface Systems.
• Creating or modifying the T-SQL queries as per the business requirements.
• Designed and Developed Oracle database Tables, Views, Indexes with proper privileges and Maintained and updated the database by deleting and removing old data
• Managed full SDLC processes involving requirements management, workflow analysis, source data analysis, data mapping, metadata management, data quality, testing strategy and maintenance of the model.

Environment: Oracle 11g, SQL, Erwin, Teradata, ODBC, CRM, SQL Server 2005/2008/2012/2013, SQL, Tableau, HTML, Agile methodology, T-SQL, MDM, Visio, MS office.

Confidential

Data Analyst/Business Analyst

• Gathered requirements from Business Analysts and Operational Analysts and identifying the data sources required for the requests.
• Involved with Data Analysis Primarily Identifying Data Sets, Source Data, Source Meta Data, Data Definitions and Data Formats
• Performance tuning of the database, which includes indexes, and optimizing SQL statements, monitoring the server.
• Wrote SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
• Created new HL7 interface based on the requirement using XML, XSLT technology.
• Experienced in creating UNIX scripts for file transfer and file manipulation.
• Utilized SDLC and Agile methodologies such as SCRUM.
• DataStage jobs were scheduled, monitored, performance of individual stages was analyzed and multiple instances of a job were run using DataStage Director.
• Led successful integration of HL7 Lab Interfaces and used expertise of SQL to integrate HL7 Interfaces and carried out detailed and various test cases on newly built HL7 interface.
• Wrote simple and advanced SQL queries and scripts to create standard and ad hoc reports for senior managers.
• Used Expert level understanding of different databases in combinations for Data extraction and loading, joining data extracted from different databases and loading to a specific database.
• Designed and Developed PL/SQL procedures, functions and packages to create Summary tables.

Environment: Facets, SQL Server,UML, Business Objects 5, Teradata, Windows XP, SSIS, SSRS, Embarcadero, ER studio, Erwin, DB2, Informatica, HL7, Oracle, Query Management Facility (QMF), SSRS, Data Stage, Clear Case forms, SAS, Agile, Unix and Shell Scripting.