SUMMARY

• Data analysis professional with around 8 years of total IT experience and expertise in data modeling for data warehouse/data mart development, Data Analysis, SQL and developing Conceptual, logical models and physical database design for Online Transactional processing (OLTP) and Online Analytical Processing (OLAP) systems.
• Hands - on experience with MMIS, ACA, HIX, HIPAA, and HL7 processes
• Worked closely with EDI 820 Payment Order/Remittance Advice and EDI 834 Benefit Enrollment and Maintenance.
• Implement client EDI834, 835, 837 Standard and Data mapping EDIfiles
• Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
• Excellent knowledge of complete data warehouse life cycle, testing methodologies, OLAP and OLTP.
• Well versed in Normalization and DeNormalization techniques for optimum performance in relational and dimensional database environments and have performed normalization up to 3NF.
• Worked on one complete ERP implementation project.
• Hands on experience in using MapReduce programming model for Batch processing of data stored in HDFS.
• Experience in Converting multiple reports fromExcel, Tableau and BO to Spotfire.
• Implemented Machine-Learning to predict the future trends with p-value and this feature had huge impact on the finding the result in this project
• Good Knowledge on NoSQL Databases like, MongoDB, Cassandra.
• Made predictions based on the data patterns and calculated ROC
• Data analysis techniques to validate business rules and identify low quality missing data in the existing data.
• Experienced with most of software deployments methodologies(SDLC) like Water Fall, Iteration, Agile and Rapid Application Development (RAD).
• Experienced in Business requirements conformation, data analysis, data modeling, logical and physical database design and implementation.
• Familiarity with Crystal Reports and SSRS - Query, Reporting, Analysis and Enterprise Information Management.
• Experienced in Normalization and Demoralization processes, Logical and Physical data modeling techniques.
• Experienced in Integrating high - level business rules (constraints, triggers and indexes) with the code.
• Proven knowledge in capturing data lineage, table and column data definitions, valid values and others necessary information in the data models.
• Strong Experience in ER & Dimensional Data Modeling to deliver Normalized & STAR/SNOWFLAKE schemas using Erwin r7.2 Erwin 9.6/8.2/7.0, Power Designer 15, Embarcadero E-R Studio and Microsoft Visio.and ER Studio 9.1.x
• Experience in Data Scrubbing/Cleansing, Data Quality, Data Mapping, Data Profiling, Data Validation in ETL.
• Experience in designing star schema, Snowflake schema for Data Warehouse, ODS architecture.
• Excellent communicative, interpersonal, intuitive, analysis, leadership skills, quick starter with ability to master and apply Confidential concepts.

TECHNICAL SKILLS

Data Modeling Languages: Erwin r7.1/7.2, Erwin r8.2, Erwin r9.1/9.5/9.6, Embarcadero ER/Studio, Oracle Designer, Sybase, Power Designer.

OLAP Tools: Microsoft Analysis Services, Tableau, Business Objects andCrystal Reports9

Programming Languages: SQL, T-SQL, PL/SQL, Base SAS, HTML, XML, VB.NET, C, C++, UNIX, Python and Shell Scripting

Database Tools: Microsoft SQL Server 2000/ 2005/20, MySQL, Oracle 11g/10g/9i/8i, DB2, MS Access 2000 and Teradata V2R6.1

Packages: Microsoft Office Suite, Microsoft Project 2010, SAP and Microsoft Visio.

ETL Tools: Informatica 7.1/6.2, Data junction, Ab-Initio, DataStage, SSIS,BODS

Other Tools: SAS Enterprise Guide, SAP ECC and Panorama Web Service, FACETS

PROFESSIONAL EXPERIENCE

Confidential, Glendale, CA

Sr. Data Modeler/Data Analyst

Responsibilities:

• Involved in requirement gathering put together with business analysts group and identifying KPIs.
• Gathered all the Analysis report prototypes from the business analysts of Business units
• Gathered various requirement matrices from the business analysts.
• Documented the performance within the system by learning the prevailing data model.
• Mapped company enterprise requirements and Confidential databases to logical data model which defines the project delivery needs.
• Participated in Joint Application Development(JAD) sessions
• Conducted Design discussions and meetings to agree on the appropriate Data Model
• Designed complex data model using database tool Erwin r7.0
• Used ER Studio to make logical and physical data models for enterprise wide OLAP system.
• Developed Star and Snowflake schemas based dimensional model growing the data warehouse
• Modeled the dimensions and facts using Erwin for centralized data warehouse
• Identified and tracked slowly changing dimensions and determined the hierarchies.
• Used Teradata utilities fastload, multiload, tpump to load data
• Responsible for managing life style of department including compliance initiatives, group practice agreements.
• Used NoSQL Database Cassandra for backup and recovery.
• Analyzed and reported on reviews of businesses and user retention using HiveQL and Pig after creating database, relations, and views from rawdatausingHadoopHive.
• Converted mutiple reports from Excel, Tableau and BO to Spotfire.
• Transformed data from one server to other servers using tools likeBulk Copy Program(BCP), andSQL Server Integration Services(SSIS) (2005/2008).
• Expertise in Creating Report Models for building Ad-hoc Reports Using SSRS.
• Expertise in Generating Reports using SSRS and Excel Spreadsheet.
• Modeled and populated the business rules using mappings into the Repository for Meta Data management.
• Worked in regard to the conversion way of data that's stored in flat files into Oracle tables.
• Experience in utilizing SSRS and Cognos in creating and managing reports for an organization.
• Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS-2008
• Implementation of Business Rules in the Database using Constraints & Triggers.
• Used data analysis techniques to validate business rules and identify low quality missing data in the existing data.
• Created, tested and implemented Teradata Fastload, Multiload and Bteq scripts, DML and DDL.
• Actively taken part in Statistical analysis and data mapping activities with the Data warehouse.
• Created summary tables using de-normalization technique to improve complex Join operations
• Generated comprehensive analytical reports by running SQL queries against current databases to conduct data analysis linked to Loan products.
• Conducts IS risk assessments to ensure compliance with corporate security policies, regulatory requirements and adherence to best practices.
• Creator of GRC model for DataModeling,DataIntegration Standards and DataBusiness Intelligence Dev.
• Using Archer GRC, review Security Physical and Logical Auditdatafor TPP hosted applications and gather Application vulnerability data to create Risk Assessments for findings.
• Participated in the tasks of knowledge migration from legacy to Confidential database system
• Worked on Metadata transfer among various proprietary systems using XML.
• Conducted Design reviews with business analysts, content developers and DBAs
• Designed and implemented traditional data models to manage marketing strategies along with satisfy reporting needs dynamically.
• Organized User Acceptance Testing (UAT), conducted presentations and provided support for Business users to get familiarized with banking applications
• Handled performance requirements for databases in OLTP and OLAP models.
• Worked together with the Implementation team to ensure a smooth transition within the design to implementation phase
• Performed Data Loading and Transformation using Data Junction 6.0

Environment: Erwin r9.1, ER Studio, SQL Server 2005, SSIS, MicroStrategy, SSRS, Windows XP/NT, Oracle 11i, MS-DTS, UML, SQL Loader, Data Junction, XML files, Rational Rose 2000, Oracle JD Edwards EnterpriseOne 8.12, TERADATA

Confidential, Boston, MA

Sr. Data Modeler/Data Analyst

Responsibilities:

• Studied the Requirements Specifications, use cases and analyzed the data needs of the Business users.
• Converted the Logical data models to Physical data models to generate DDL.
• Extensively worked with Teradata database as part of the enterprise warehouse development and the data mart, staging and prestaging environment build outs.
• Updated the Naming and version control standard documents and implemented version controlling using the Model Manager.
• Migrated several models in ERWin 4.1/7.1 into ERwin7.2 and updated the naming standards.
• Created complex mappings and mapplets using Lookup, Expression, Aggregator, Sequence Generator, Union, Normalizer, and Router transformations.
• Involved in writing the PL/SQL validation scripts to identify the data inconsistencies in the sources.
• Worked with Business Analysts to design weekly reports using Cognos.
• Created Design documents, Source Target Mappings and Sign-off documents.
• Worked on the Enterprise Meta data repositories for updating the metadata and also involved in Master Data Management MDM .
• Maintain and work with ourdatapipeline that transfers and processes several terabytes ofdatausingSpark, Scala, Python, Apache Kafka, Pig/Hive & Impala.
• Design and develop code to implement the Confidential reports and modify the existing code usingPerlscripting and MYSQL.
• Writing applications in PL/SQL, developing applications in Oracle Forms and Oracle reports.
• Wrote database triggers, procedures, functions inPL/SQLand incorporated business rules and constraints.
• Worked with development of packages and procedures usingPL/SQLand functions using ETL andPL/SQL.
• Automation database programming throughPerlDBI module.
• Worked on AWSRedshiftand RDS for implementing models anddataon RDS andRedshift.
• Built the Transformation Rules engine for use of all the designers across the project.
• Documented the designs so as to facilitate the personnel to understand the process and in corporate the changes as and when necessary.
• Implemented CURAMDB2 fix packs, installations and migrations.
• Worked on setting updb2 high availability technologies HADR/Pure scale.
• Responsible for detailed verification, validation and review of the design specifications.
• Conducted review walk through of data models involving SME, developers, testers and analysts.

Environment: ERwin 7.2/7.1/4.1, Informatica 8.0, Cognos, Teradata, Oracle 9i, SQL Server 2003,SQL, PL/SQL, MS Office, Windows 2003.

Confidential, Louisville, KY

Data Modeler/Data Analyst

Responsibilities:

• Was included in all phases of projects including Requirement gathering, Analysis, Design, Coding, Testing, Documentation and warranty period.
• Experienced with MMIS, ACA, HIX, HIPAA, and HL7 processes
• Designed ER diagrams, logical model (relationship, cardinality, attributes, and, candidate keys) and convert these to physical data model including capacity planning, object creation and aggregation strategies, partition strategies, Purging strategies according to business requirements.
• Developed Data models and ERD diagrams using Erwin.
• Conducted analysis on data to find the KPIs.
• Data analysis of existing database to be aware of the data flow and business rule used on different databases by SQL
• Design and development of Ab initio ETL graphs, KSH wrapper scripts and batch scheduling.
• Involved in Logical & Physical Database Layout Design using Erwin.
• Conducted meetings with the business and technical team to collect necessary Statistical data requirements in JAD sessions.
• Performed Data Analysis and Data validation by writing complex SQL queries using TOAD against the ORACLE database.
• Involved in migration projects tomigrate datafrom data warehouses on Oracle/DB2 and migrated those toTeradata.
• Worked on SSIS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.
• Used SQL Queries and visual validation to validate data.
• Created standard abbreviation document in line with business standard.
• Used IBM UDM for consolidating and analyzing data to make inform decisions and turned insights into actions.
• Lead multiple project teams of technical professionals through all phases of the SDLC using technologies including Oracle, Erwin, Data Stage, Data Warehousing, Websphere and Cognos.
• Created and maintained Logical Data Model (LDM) / Physical Data Modeling with the system. Includes documentation of most entities, attributes, data relationships, primary and foreign key relationships, allowed values, codes, business rules, glossary terms, etc.
• Responsible in designing and introducing Confidential (FACT and Dimension Tables) towards the existing Model.
• Performed data cleaning, prepping and finding missing values in a large data set using machine learning techniques and scripting language.
• Plotting graphs to visualize the data using Matplotlib packages
• Numpy is used to do mathematical calculations on data and to find the trends from the data, and used Linear regressions on train and test data for predictive analysis.
• Implemented Machine-Learning to predict the future trends with p-value and this feature had huge impact on the finding the result in this project
• Extensively handled documentation of Data Model, Mapping, Transformations and Scheduling jobs.
• Responsible for data mapping and writing transformation rules.
• Assisted fellow ETL developers with troubleshooting activities.
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Extensively used SSIS transformations such asLookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Developed the Data mart with the base data in Star Schema, Snow Flake Schema and Multi Star Schema and linked to developing the Data warehouse with the Database.
• Expertise in Data Analysis by writing complex SQL Queries.
• Coordinated with customers and staff and provided support on data analysis.
• Performed data analysis on all results and able presentations for clients.
• Performed audit on data and resolved business related issues for subscriber base.
• Used Forward Engineering to further improve the Data Structures with the Existing Database and Create a Physical Data Model with DDL that most closely fits the requirements through the Logical Data Model.
• Performed reverse Engineering on existing Data model to learn data flow and business flow.
• Excellent analytical, inter-personal and communication skills using a strong technical background.

Environment: Erwin r9.6, SQL Server 2012/2014, Ab initio, JIRA Informatics Power Center, Teradata, Source Analyzer, IBM UDM,Datawarehouse designer, Workflow Manager, Workflow Monitor, PL/SQL.

Confidential, Foster City, CA

Data Modeler

Responsibilities:

• Participated in requirement gathering session, JAD sessions with users, Subject Matter experts,
• Architects and BAs.
• Participated in Sprint Testing and documented the Project Change Control and the Impact analysis, worked with BA’s on GAP Analysis
• Worked with System Architects in providing solutions to the system design, reducing the number of screen selections, internal and external application workflow design and in design of user interface screens.
• Reviewed clients network das network data requirements for design, configuration of routers, switches, OSPF protocol and MPLS spanning over 25 network technical projects for Duke NERC CIP
• Provided solutions to performance issues in the databases include re-indexing, recompiling stored Procedures and other maintenance tasks.
• Applied Normalization techniques and created Logical and Physical models based on the requirements.
• Conducted and participated in Database design review meetings.
• Prepared Enterprise Naming Standard files and project specific naming standard files in some exception cases.
• Worked with Enterprise Architect team in developing Enterprise Data Models, which is used by most of the applications.
• Designing the SSAS (SQL Server Analysis Services) Cubes; SSRS (SQL Server Reporting Services) Reports, Adhoc Querying facilities.
• Worked with MDM team in making changes to database to accommodate requirements and in
• Capturing the demographic information from different applications by providing source application data dictionaries, identifying the demographic information and by providing DDL.
• Involved in the redesigning of Legacy systems, Modifications, Enhancements and Break Fixes to existing systems and in integration of one system with the other.
• Worked on Forward and Reverse Engineering using Erwin, reverse engineered XSD structures, excel spread sheets and copybooks.
• Worked on Comparing different models, different versions of models using complete compare in Erwin and compared Databases directly and produced alter scripts.
• Worked on upgrading Erwin Data modeler from v7.3 to v9.5, served as Erwin Repository administrator
• Experience with Version Control tools.
• Experience in Developing Stored Procedures, Functions and Triggers using T-SQL.
• Worked with DBA’s in migrating data from one database environment to another environment.
• Worked with ETL teams in designing Load jobs and used Informatica Designer, Workflow Manager and Repository Manager to create source and target definition, table load order documents, design mappings, create repositories and establish users, groups and their privileges.
• Analyzed Data Specification Documents (DSDs) and implemented their logic in the form of Informatica mapping design.
• Worked with BI team in providing SQL queries, Data Dictionaries and mapping documents (Report attributes to Database columns).
• Acted as a Strong Data Analyst analyzing the data from low level in conversion projects, provided mapping documents between Legacy, Production and User Interface systems.
• Extensively performed Data Profiling, Data Cleansing, De-duplicating the data and has a good knowledge on best practices.
• Involved in high complex research, quantitative analysis, modeling and monitoring of data necessaryto produce the logical design for review.
• Developed and initiated more efficient data collection procedures
• Worked with Architects in designing conceptual model for the Data warehouse and Identified Facts and Dimensions, designed Logical and Physical data models
• 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.
• Worked on Converting Physical only models to Logical and Physical models.

Environment: Oracle 10g/11g/11c/12c, SQL Server 2005/2008/2012, SSRS, Erwin 7.3/9.5, IBM DB2, CaseComplete, Tableau, Blue Zone, Toad SQL Developer, Informatica Analyst 9.6.1 Sybase Power Designer 15, MSOFFICE 2015, Crystal Reports, ALTOVA XML Spy.

Confidential, Herndon, VA

Data Modeler/ Data analyst

Responsibilities:

• Gathering business requirements by organizing and managing meetings with business stakeholders, Application architects, Technical architects and IT analysts on a scheduled basis.
• Analyzed the business requirements by dividing them into subject areas and understood the data flow
• Created conceptual and logical models, logical entities and defined attributes, and relationships between the various data objects
• Updated existing models to integrate Confidential functionality into an existingapplication.
• Conducted one-on-one sessions with business users to gather data warehouse requirements
• Developed normalized Logical and Physical database models to design OLTP system
• Created dimensional model for the reporting system by identifying required dimensions and facts using Erwin r9. worked on multiple implementations on Corporate sponsored and variable universal life insurance section of their web based application.
• Created DDL scripts for implementing Data Modeling changes. Created ERWIN reports in HTML, RTF 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 forward engineering to create a Physical Data Model with DDL that best suits the requirements from the Logical Data Model.
• Maintaining and implementing Data Models for Enterprise Data Warehouse using ERWINr9
• Create and maintain Metadata, including table, column definitions
• Synched up the models by reverse engineering, compare model and merge model from database to the original models
• Responsible for defining the naming standards for data warehouse.
• Used Model Mart of Erwin r9 for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• UsedErwinfor reverse engineering to connect to existing database and ODS to create graphical representation in the form of Entity Relationships and elicit more information
• Developed Data Migration and Cleansing rules for the Integration Architecture (OLTP,ODS, DW).
• Verified the correct authoritative sources were being used and the extract, transform and load (ETL) routines would not compromise the integrity of the source data
• Tuned the SQL Queries by breaking down the predefined queries into smaller queries for processing, Pushed Query processing up from the client to application server level
• Gathering Business requirements by organizing and managing meetings with business stake holders, Application architects, Technical architects and IT analysts on a scheduled basis.
• Possess strong Documentation skills and knowledge sharing among Team, conducted data modeling review sessions for different user groups, participated in sessions to identify requirement feasibility

Environment: Erwin r9, SQL Server 2008, Oracle 11g, Informix 16, MS Excel, MS Visio2010, Requisite Pro 7.1, TOAD, SQL, PL/SQL, Windows.

Confidential

Data Modeler/ETL Developer

Responsibilities:

• Gathered business and functional requirements.
• Interacted with business users and studied available documents/application to learn the requirements.
• Worked with large multiple data to search out rate flow trends and patterns, identify and fasten data anomalies
• Used Erwin r7.0 for creating tables using Forward Engineering
• Designed the prototype about the Data mart and documented possible outcome while using it for end-user.
• Involved operating process modeling using UML
• Developed and maintained data dictionary to make metadata reports for technical and business purpose.
• Identified facts and dimensions and designed the Star Schema.
• Designed logical database design and converted logical model into physical model on SQL Server.
• Cleansed, extracted and analyzed business data on regular basis and generated ad-hoc analytical reports using Excel and T-SQL
• Done SQL Server configuration database size estimation, database creation logins & users creation, granting object level permission, estimation of indexes on tables.
• Developed Data Mapping, Data Governance, Transformation and Cleansing rules for the Master Data Management Architecture involving OLTP, ODS and OLAP
• Identified and tracked slowly changing dimensions and determined the hierarchies .
• Actively took part in data mapping activities with the data warehouse.
• Created summary tables using de-normalization solution to improve complex Join operations
• Designed logical database design on SQL Server and PostgreSQL.
• Applied data cleansing rules from staging to data mart.
• Developed ETL jobs for refreshing the main points of Cisco Contact Center Analysis dashboards using Talend
• Worked with DBAs to have a best fit physical data model about the logical data model
• Worked together with Implementation team to assure a smooth transition from the design to implementation phase
• Identified and Created Indexes on tables for better query performance.
• Principally authored the documents: Business Requirement Documents, High Level Requirements, Detail Level Requirements, Functional Requirements Documents, Requirement Traceability Matrix, Quality Requirements, ETL Jobs documentation, Functional/Stakeholders Requirements, User Stories, and Logical Data Models for Dash Boards etc.
• Captured the metrics of contact center data like Agent Performance, Call Profile, and Customer Effort to demonstrate in dashboards.
• Designed the logical data model for Error Event and Audit tables.
• Worked under Scrum master environment and followed defined timelines for completion of project.
• Generated ad-hoc reports using Crystal Reports.

Environment: Erwin 4.0, SQL/MS SQL Server, MS OLAP Manager, MS Analysis Services, Windows NT, MS Visio, XML, Informatica Power Center 6.0, Crystal Reports, pgAdmin (PostgreSQL), Talend 5.6.1