WORK SUMMARY

• Over 9+ years of experience as Sr. Data Modeler/Data Analyst with high proficiency.
• Experience with JAD sessions for requirements gathering, creating Data Mapping, documents, writing functional specifications, queries.
• Expertise in Normalization (1NF, 2NF, 3NF and BCNF)/Denormalization techniques for effective and optimum performance in OLTP and OLAP
• Good knowledge of Data governance/Data classification and reporting tools like Meta Center and Tableau.
• Experience in Dimensional Data Modeling, Star/Snowflake schema, Fact & Dimension tables.
• Expertise in creating conceptual, logical and physical data models for OLTP and OLAP systems.
• Working as Salesforce Business Analyst and ERP Consultant.
• Well versed experience in Data Modeling tools like Erwin, E/R Studio, Power Designer & Toad Data Modeler.
• Experience business experience in L&A Insurance.
• Expert in Agile/Scrum and waterfall software development methodologies.
• Experience in importing and exporting data using Sqoop from HDFS to Relational Database Systems (RDBMS) and from RDBMS to HDFS.
• Have good experience in databases such as HBase, CouchBase,
• Experience in Big Data, NoSQL Database like Cassandra and technical expertise in Hadoop.
• Good understanding of AWS, big data concepts and Hadoop ecosystem.
• Having good knowledge of Hive, HBase, Oracle, MySQL, DB2 and Teradata as Database.
• Good command in writing SQL queries, Stored Procedures and Triggers.
• Experience with data modeling tools like ER/Studio, Erwin and Power designer.
• Good knowledge on SQL tools like Teradata SQL Assistant and Oracle SQL Developer.
• Experience in cloud development architecture on Amazon AWS, EC2, EC3, Elastic Search, Elastic Load balancing, Redshift and AMI and Basic on MS Azure.
• Hands on experience with Kimball’s and Inmon are dimensional modeling methodology.
• Experience in Data Scrubbing/Cleansing, Data Quality, Data Mapping, Data Profiling, Data Validation in ETL.
• Have good experience in Life Insurance and Annuity.
• Having good experience in NOSql Couchbase
• Having experience in writing complex SQL queries to perform end - to-end ETL validations and support Ad-hoc business requests.
• Experience in conducting Joint Application Development (JAD) sessions with SMEs, Stakeholders and other project team members for requirement gathering and analysis.
• Experience with SQL Server and T-SQL in constructing Temporary Tables, Table variables, Triggers, user functions, views, Stored Procedures.
• Expertise in data cleansing for analysis, perform data quality testing for gaps, and liaising with data origination teams.
• Worked with various data sources such as Oracle, SQL Server, Teradata and Netezza
• Experience with Teradata utilities such as Fast Export, Mload for handling various tasks.
• Good understanding of Ralph Kimball (Dimensional) & Bill Inmon (Relational) model Methodologies.
• Working Knowledge of RDBMS (MySQL, PostgreSQL, SQL Server) and NoSQL databases such as HBase, CouchBase, Vertica, MongoDB, Cassandra.
• Strong understanding of principles of data warehousing, fact tables, dimension tables, Slowly Changing Dimensions (SCD) Type I and Type II.
• Excellent experience on using Teradata SQL Assistant, Teradata Administrator, PMON and data load/export utilities like BTEQ, Fast Load, Multi Load, Fast Export, and Exposure to Tpump on UNIX/Windows environments and running the batch process for Teradata.
• Extensive experience in supporting Informatica applications, data extraction from heterogeneous sources using Informatica Power Center.
• Experience in automating and scheduling the Informatica jobs using UNIX shell scripting configuring Korn-jobs for Informatica sessions.
• Strong Experience in working with Excel Pivot and VBA Macros for various business scenarios.
• Experience in generating DDL (Data Definition Language) Scripts and creating Indexing strategies.
• Excellent SQL Programming skills and developed Stored Procedures, Triggers, Functions, Packages using SQL/PL SQL, Performance tuning and query optimization techniques in transactional and data warehouse environments.
• Experience in Designing and implementing data structures and commonly used data business intelligence tools for data analysis.
• Expert in building Enterprise Data Warehouse or Data warehouse appliances from Scratch using both Kimball and Inmon’s Approach.

WORK EXPERIENCE

Confidential - Greensboro, NC

Sr. Data Modeler/Data Analyst

Responsibilities:

• Massively involved in Sr. Data Modeler/Data Analyst role to review business requirement and compose source to target data mapping documents.
• Working on data profiling and analysis to create test cases for new Architecture evaluation.
• Responsible for Data Analysis, Data Modeling, Data Integration, Data quality & Metadata management solution design and delivery for Enterprise EDW and Cloudera Hadoop environment.
• Planned and conducted requirements elicitation meetings with the business to collect functional and non-functional requirements relating to client's Salesforce technology enhancement and initiatives.
• Worked on Agile and Scrum Methodology for Salesforce custom app implementation.
• Createed, maintained, reviewed and updated Enterprise Job Scheduling code (BMC Control-M).
• Knowledge in BMC Control M scheduling (GUI and Mainframe), Control D reporting, Remedy, Mainframe z/OS, obfuscation, and distributed platforms
• Worked in an Agile team using Scrum methodology and participated in backlog prioritization with product owner and Scrum master.
• Developed a generic model for predicting repayment of debt owed in the healthcare, large commercial, and government sectors.
• Knowledge of RDBMS (MySQL, PostgreSQL, SQL Server) and NoSQL databases such as HBase, CouchBase, Vertica, MongoDB, Cassandra.
• Experience with Document - oriented NoSQL databases - MongoDB and CouchDB.
• Created Logical & Physical Data Modeling on Relational (OLTP), Dimensional Data Modeling (OLAP) on Star schema for Fact & Dimension tables using Erwin.
• Create and maintain data model standards, including master data management (MDM).
• Implemented Normalization Techniques and build the tables as per the requirements given by the business users.
• Worked Normalization and De-normalization concepts and design methodologies like Ralph Kimball and Bill Inmon approaches.
• Developed and presented Business Intelligence reports and product demos to the team using SSRS (SQL Server Reporting Services).
• Identifies and complies with business process controls and department goals through documentation, monitoring, and reporting critical activities.
• Used windows Azure SQL reporting services to create reports with tables, charts and maps.
• Used Azure reporting services to upload and download reports
• Worked with MDM systems team with respect to technical aspects and generating reports.
• Used Erwin for 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).
• Assisted in designing and creation of training material and conducted internal training sessions for business users on Salesforce technology functionalities.
• Constructed complex SQL queries with sub-queries, inline views as per the functional needs in the Business Requirements Document (BRD).
• Involved in designing and developing SQL server objects such as Tables, Views, Indexes (Clustered and Non-Clustered), Stored Procedures and Functions in Transact-SQL.
• Delivered dimensional data models using Erwin to bring in the Employee and Facilities domain data into the oracle data warehouse.
• Experience working with automated scheduling, job restart software, specifically BMC Control-M software.
• Developed Data Mapping, Data Governance, Transformation and Cleansing rules for the Master Data Management Architecture involving OLTP, ODS and OLAP.
• Performed detailed data analysis to analyze the duration of claim processes and created the cubes with Star Schemas using facts and dimensions through SQL Server Analysis Services (SSAS).
• Performed Data Analysis and Data Profiling using complex SQL queries on various sources systems including Oracle, Teradata.
• Part of JAD sessions for defining business requirements and translating them into technical specifications.
• Responsible for designing a Data dictionary & Business Glossary.
• Designed stunning visualization dashboards using Tableau desktop and publishing dashboards on Tableau server and desktop reader.
• Created DDL scripts using Erwin and source to target mappings to bring the data from source to the warehouse.
• Facilitated in developing testing procedures, test cases and User Acceptance Testing (UAT).
• Extensively worked on PL/SQL programming Stored Procedures, Functions, Packages and Triggers.
• Developed PL/SQL scripts to validate and load data into interface tables
• Performed the Data Mapping, Data design (Data Modeling) to integrate the data across the multiple databases in to EDW.

Environment: ER/Studio v17, SSIS, Salesforce, CouchDB, MS Azure, OLTP, ETL, Agile, SSRS, MDM, HDFS, HBase 1.4, Yarn 2.9, MapReduce, OLAP, PL/SQL, Hive 2.3, Hadoop 3.0

Confidential, Eden Prairie, MN

Sr. Data Modeler/Data Analyst

Responsibilities:

• Developing full life cycle software including defining requirements, prototyping, designing, coding, testing and maintaining software.
• Worked as a Sr. Data Modeler/Analyst to generate Data Models using Erwin and developed relational database system.
• Monitored new Salesforce released features and functionality to provide recommendations for process
• Worked on Software Development Life Cycle (SDLC) with good working knowledge of testing, Agile methodology, disciplines, tasks, resources and scheduling.
• Provided solutions to customers in Health Care, Pharmacy, Life Insurance, Mortgage Insurance and Annuity.
• Researched and developed hosting solutions using MS Azure for service solution.
• Developed long term data warehouse roadmap and architectures, designs and builds the data warehouse framework per the roadmap.
• Developed logical data models and physical database design and generated database schemas using Erwin.
• Designed and developed architecture for data services ecosystem spanning Relational, NoSQL, and Big Data technologies.
• Designed both 3NF data models for ODS, OLTP systems and dimensional data models using star and snow flake Schemas.
• Worked with business stakeholders to gather data quality requirements, action data profiling, and produce metrics to identify opportunities for improved testing and reporting.
• Implemented data quality process including transliteration, parsing, analysis, standardization, and enrichment at point of entry and batch modes.
• Conducted sessions for the team on Agency Management system as well as basic insurance modules.
• Developed Data Mapping, Data Governance, Transformation and Cleansing rules for the Master Data Management Architecture.
• Lead Data Governance process with external and internal data providers to ensure timely, accurate and complete data.
• Document data dictionaries and business requirements for key workflows and process points
• Involved in Dimensional modeling (Star Schema) of the Data warehouse and used Power Designer to design the business process, dimensions and measured facts.
• Designed ER diagrams and mapping the data into database objects.
• Involved in Data profiling in order to detect and correct inaccurate data and maintain the data quality.
• Developed Data Migration and Cleansing rules for the Integration Architecture (OLTP, ODS, DW).
• Developed a web-to-lead functionality to vertrue.com site which directs leads to Salesforce CRM.
• Implemented Forward Engineering by using DDL scripts and generating indexing strategies.
• Reverse Engineered physical data models from SQL Scripts and databases.
• Worked with Data Analytics, Data Reporting, Ad-hoc Reporting, Graphs, Scales, PivotTables and OLAP reporting.
• Wrote test plans and test cases in compliance with organizational standards.
• Designed the data warehouse architecture for all the source systems using MS Visio.
• Developed and maintained an Enterprise Data Model (EDM) to serve as both the strategic and tactical planning vehicles to manage the enterprise data warehouse.
• Monitored the Data quality and integrity of data was maintained to ensure effective functioning of department.
• Worked with project management, business teams and departments to assess and refine requirements to design/develop BI solutions using MS Azure.
• Developed and implemented data cleansing, data security, data profiling and data monitoring processes.
• Worked with MDM systems team with respect to technical aspects and generating reports.
• Worked with the data team to profile source data and determine source and metadata characteristics.
• Involved in Data profiling, Data analysis and data mapping artifacts design.
• Wrote and executed SQL queries to verify that data has been moved from transactional system to DSS, Data warehouse, data mart reporting system in accordance with requirements.
• Performed detailed data analysis to analyze the duration of claim processes and created the cubes with Star Schemas using facts and dimensions through SQL Server Analysis Services (SSAS).
• Responsible for Big data initiatives and engagement including analysis, brainstorming, POC, and architecture.
• Installed and configured Hive, Pig, Sqoop, Flume, Kafka, Oozie on the Hadoop cluster.
• Generated various reports using SQL Server Report Services (SSRS) for business analysts and the management team.
• Designed OLAP system environment and maintained documentation of Metadata.
• Analyzed results from data validation queries to present to user groups.
• Create and communicate the strategy and use of Big Data.
• Responsible for the data architecture design delivery, data model development, review, approval and Data warehouse implementation.
• Testing responsibilities included unit testing, integration testing, and business acceptance testing.

Environment: Erwin 9.7, MS Azure, NoSQL, Salesforce OLTP, MS Visio 2017, MDM, Metadata, SSRS, SSAS, SSIS, OLAP, Hive 2.3, Pig 0.17, Sqoop 1.4, Flume 1.8, Kafka 1.1, Oozie 4.3, Hadoop 3.0

Confidential - Malvern, PA

Sr. Data Modeler

Responsibilities:

• As a Data Modeler involved in performing business area analysis and logical and physical data modeling using ER/Studio for data warehouse/data mart applications
• Conducted data modeling JAD sessions and communicated data related standards.
• Conducted walkthroughs with the DBA to convey the changes made to the data models.
• Implemented SQL Scripts to modify the data to resolve assigned defects.
• Implemented Forward engineering to create tables, views and SQL scripts and mapping documents.
• Analyze our insurance clients' business and technology challenges and build creative solutions to drive transformation.
• Used reverse engineering to connect to existing database and create graphical representation (E-R diagram).
• Designed different type of STAR schemas like detailed data marts and Plan data marts, Monthly Summary data marts using E/R studio with various Dimensions Like Time, Services, Customers and various FACT Tables.
• Defined and processed the facts, dimensions. Designed the data marts using the Ralph Kimball's Dimensional Data Mart Modeling methodology using ER Studio.
• Responsible for data governance rules and standards to maintain the consistency of the business element names in the different data layers.
• Designed the ER diagrams, ERP financial logical model (relationship, cardinality, attributes, and, candidate keys)
• Involved in extensive Data validation using SQL queries and back-end testing.
• Developed full life cycle software including defining requirements, prototyping, designing, coding, testing and maintaining software.
• Created Logical & Physical Data Model on Relational (OLTP) on Star schema for Fact and Dimension tables using ER/Studio.
• Performed GAP analysis to analyze the difference between the system capabilities and business requirements.
• Responsible for data modeling and building a Snow-flake schema model in ER/Studio.
• Designed the data marts using the Ralph Kimball's Dimensional Data Mart modeling methodology using ER/Studio.
• Initiated the process of implementing standard audit columns required for all SCD types.
• Worked on normalization techniques, normalized the data into 3rd Normal Form (3NF).
• Worked Normalization and De-normalization concepts and design methodologies.
• Performance tuning and stress-testing of NoSQL database environments in order to ensure acceptable database performance in production mode.
• Assisted in defining business requirements and created BRD (Business Requirements Document) and functional specifications documents.
• Developed / modified Oracle PL/SQL codes like stored Procedures, Functions and Triggers etc.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and bulk collects.
• Monitored the Data quality and integrity of data was maintained to ensure effective functioning of department.
• Developed Data Migration and Cleansing rules for the Data Integration Architecture (OLTP, ODS, DW).
• Created DDL Scripts using ER/Studio for the ODS and Mart model and executed them in respective DEV environments so as to make sure the ETL can start the build/code drop development.

Environment: E/R studio 9.5, PL/Sql, OLAP, Sql, Oracle11g, ODS, NoSQL, Rational Rose, MS Visio.

Confidential, San Francisco, CA

Sr. Data Analyst

Responsibilities:

• Worked with business requirements analysts/subject matter experts to identify and understand requirements. Conducted user interviews and data analysis review meetings.
• Wrote PL/SQL statement, stored procedures and Triggers in DB2 for extracting as well as writing data.
• Performed thorough data analysis for the purpose of overhauling the database using SQL Server.
• Prepared complex T-SQL queries, views and stored procedures to load data into staging area.
• Wrote and executed unit, system, integration and UAT scripts in a data warehouse projects.
• Worked Extensively with DBA and Reporting team for improving the Report Performance with the Use of appropriate indexes and Partitioning.
• Extensively used SQL, T-SQL and PL/SQL to write stored procedures, functions, packages and triggers.
• Worked on Data Analysis, Data profiling, and Data Modeling, data governance identifying Data Sets, Source Data, Source Metadata, Data Definitions and Data Formats.
• Designed and Developed PL/SQL procedures, functions and packages to create Summary tables.
• Worked in importing and cleansing of data from various sources like Teradata, flat files, SQL Server with high volume data.
• Prepared process flow/activity diagram for existing system using MS Visio and re-engineer the design based on business requirements.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, using UML and Business Process Modeling.
• Used advanced MS Excel with V-Look up and Pivot table functions to identify the issues in the data and helped in further modifications to build new versions.
• Wrote SQL scripts to run ad-hoc queries, PL/SQL scripts, Stored Procedures & Triggers and prepare reports to the management.
• Manipulated, cleansing & processing data using Excel, Access and SQL.
• Created reports analyzing large-scale database utilizing Microsoft Excel Analytics within legacy system.
• Created reports from several discovered patterns using Microsoft excel to analyze pertinent data by pivoting.
• Performed Data Analysis and Data validation by writing complex SQL queries.
• Developed the financing reporting requirements by analyzing the existing business objects reports.

Environment: PL/SQL, DB2, T-SQL, SQL, Teradata 14, MS Visio 2012, MS Excel 2012, MS Access 2012

Confidential

Data Analyst

Responsibilities:

• Worked with the business analysts to understand the project specification and helped them to complete the specification.
• Worked in Data Analysis, data profiling and data governance identifying Data Sets, Source Data, Source Metadata, Data Definitions and Data Formats.
• Used MS Access, MS Excel, Pivot tables and charts, MS PowerPoint, MS Outlook, MS Communicator and User Base to perform responsibilities.
• Extracted Data using SSIS from DB2, XML, Excel and flat files perform transformations and populate the data warehouse
• Performed Teradata, SQL Queries, creating Tables, and Views by following Teradata Best Practices.
• Prepared Business Requirement Documentation and Functional Documentation.
• Primarily responsible for coordinating between project sponsor and stake holders.
• Conducted JAD sessions to allow different stakeholders such as editorials, designers, etc.
• Extensively SQL experience in querying, data extraction and data transformations.
• Experienced in developing business reports by writing complex SQL queries using views, macros, volatile and global temporary tables.
• Developed numerous reports to capture the transactional data for the business analysis.
• Collaborated with a team of Business Analysts to ascertain capture of all requirements.
• Involved in writing complex SQL queries using correlated sub queries, joins, and recursive queries.
• Designed reports in Access, Excel using advanced functions not limited to pivot tables, formulas
• Used SQL, PL/SQL to validate the Data going in to the Data warehouse
• Wrote complex SQL, PL/SQL testing scripts for Backend Testing of the data warehouse application. Expert in writing Complex SQL/PLSQL Scripts in querying Teradata and Oracle.
• Extensively tested the Business Objects report by running the SQL queries on the database by reviewing the report requirement documentation.
• Implemented the Data Cleansing using various transformations.
• Used Data Stage Director for running and monitoring performance statistics.
• Designed and implemented basic s for testing and report/data validation.
• Ensured the compliance of the extracts to the Data Quality Center initiatives.
• Wrote multiple SQL queries to analyze the data and presented the results using Excel, Access, and Crystal reports.
• Gathered and documented the Audit trail and traceability of extracted information for data quality.

Environment: MS Access 2010, MS Excel 2010, MS Power Point, MS Outlook, SSIS, XML, Teradata 12, SQL, PL/SQL, Oracle 10

TECHNICAL SKILLS

Data Modeling Tools: Erwin 9.7, Erwin Model Manager, ER Studio v17, and Power Designer 16.6.

Programming Languages: SQL, PL/SQL, HTML5, XML and VBA.

Reporting Tools: SSRS, Power BI, Tableau, SSAS, MS-Excel, SAS BI Platform.

Big Data technologies: HBase 1.4, HDFS, Sqoop 1.4, Spark, Hadoop 3.0

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

Cloud Platform: AWS, Redshift, Azure, Google Cloud, Cloud Stack/Open Stack

Databases: Oracle 12c, Teradata R15, MS SQL Server 2016, DB2, Cassandra, MongoDB, Hive2.3

Operating System: Windows 10/8/7, Unix, Sun Solaris

ETL/Data warehouse Tools: Informatica 9.6/9.1, SAP Business Objects XIR3.1/XIR2, Talend, and Pentaho.

Methodologies: RAD, JAD, RUP, UML, System Development Life Cycle (SDLC), Agile, Waterfall Model.