SUMMARY

• Around 7+ years of experience in data modeling and data analysis, production support, database management, strategic analysis, requirements gathering, application and decision support.
• In - depth knowledge of Software Development Lifecycle (SDLC) and Agile software development methodologies adhering to best practices and industry standards.
• Extensive experience in using ER modeling tools such as Erwin and ER/Studio, Teradata, and MDM.
• Proficient in data mart design and creation of cubes using dimensional data modeling - identifying Facts and Dimensions, Star Schema and Snowflake Schema.
• Experience with DDL and DML including Joins, Functions, Indexes, Views, Constraints, Primary Keys and Foreign Keys.
• Excellent knowledge on logical application design and physical implementation for database application.
• Selecting appropriate AWS services to design and deploy an application based on given requirements.
• Proficient in System Analysis, ER/Dimensional Data Modeling, Database design and implementing RDBMS specific features.
• Strong experience in Normalization and Denormalization techniques for effective and optimum performance in OLTP and OLAP environments.
• Expertise in data design and modeling, system study, design, and development by applying Ralph Kimball methodology of dimensional and relational data modeling.
• Experience in Data transformation and Data mapping from source to target database schemas and also data cleansing.
• Good in Data warehouse loads, determining hierarchies, building various logics to handle Slowly Changing Dimensions.
• Expertise in SQL Server Analysis Services (SSAS), SSIS and SQL Server Reporting Services (SSRS)
• Excellent understanding and exposure to SQL queries and PL/SQL stored procedures, triggers, functions and packages.
• Extensive experience on building dashboards in Tableau and involved in Performance Tuning of reports and resolving issues within Tableau Server and Reports.
• Proficient with Data Analysis source and target systems for data migration efforts and resolving issues relating to data migration.
• Experience designing security at both the schema level and the accessibility level in conjunction with the DBAs
• Excellent in performing data transfer activities between SAS and various databases and data file formats like XLS,CSV,DBF,MDB etc.
• Strong experience in using Excel and MS Access to dump the data and analyze based on business needs.
• Experience in writing and executing unit, system, integration and UAT scripts in a data warehouse projects.
• Excellent communicative, interpersonal, intuitive, analysis, leadership skills, quick starter with ability to master and apply new concepts.

TECHNICAL SKILLS

Data Modeling Tools: Erwin Data Modeler 9.8/9.7, ER Studio v17, and Power Designer.

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

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

Cloud Platforms: AWS, Azure

BigData: Hadoop, Cassandra, Hbase

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

Databases: Oracle 12c/11g, Teradata R15/R14, MS SQL Server 2016/2014.

Operating System: Windows, Unix, Sun Solaris

ETL/Data warehouse Tools: Informatica 9.6/9.1, SAP Business Objects XIR.

Methodologies: System Development Life Cycle (SDLC), Agile, Waterfall Model

PROFESSIONAL EXPERIENCE

Confidential - Richardson, TX

Sr. Data Modeler

Responsibilities:

• Worked as a Data Modeler in both Forward Engineering as well as Reverse Engineering using data modeling tools.
• Worked on HL7 data sets
• Designed the business requirement collection approach based on the project scope and SDLC Methodology.
• Skilled at gathering requirements by conducting one on one interviews, brainstorming sessions and Joint Application Development (JAD) sessions.
• Worked on Data modeling, Advanced SQL with Columnar Databases using AWS.
• Extensively used Erwin for developing data model using star schema methodologies.
• Used normalization and de-normalization techniques to achieve optimum performance of the database.
• Developed scripts that automated DDL and DML statements used in creations of databases, tables, constraints, and updates.
• Used Sqoop for data ingestion to Hadoop.
• Created graphical representation in the form of Entity Relationships and elicit more information.
• Designed logical and physical data models using data provisioning and consumption techniques.
• Resolved the data type inconsistencies between the source systems and the target system using the mapping documents.
• Used Cassandra as NoSQL storage
• Analyzed & designed the business rules for data cleansing that are required by the staging & OLAP and OLTP databases.
• Generated the DDL and assisted in designing the overall ETL strategy.
• Involved in extensive Data Analysis on the Teradata and Oracle Systems querying and writing in SQL and TOAD.
• Extensively analyzed Ralph-Kimball Methodology and implemented it successfully.
• Created packages in SSIS with error handling using various data transformations.
• Designed the PL/SQL procedures for getting the data from all systems to Data Warehousing system.
• Developed and maintained data dictionary to create metadata reports for technical and business purpose
• Involved in implementing Data blending, Replace references, customized queries and advanced visualizations in Tableau.
• Designed XML schemas using Unified Modeling Language UML translating business concepts into XML vocabularies
• Developed parameterized, caching, sub and Ad Hoc reports using SSRS.
• Created and Implemented triggers in T-SQL to facilitate consistent data entry into the databases.
• Written and executed unit, system, integration and UAT scripts in a data warehouse projects.
• Generated and reviewed reports to analyze Data using different excel formats Documented requirements for numerous Ad-hoc reporting efforts

Environment: Erwin9.8, SQL, AWS, ETL, Oracle12c, Teradata15, OLAP, OLTP, PL/SQL, Tableau, XML, T-SQL, SSRS, TOAD.

Confidential - Thousand Oaks, CA

Data Modeler

Responsibilities:

• Created Dimensional Model for the reporting system by identifying required dimensions and facts using Erwin.
• Involved in Scrum Meetings for Sprint Planning, Created Agile user stories, Sprint Review, Daily Scrum and update based on the burn-chart of the sprint sessions.
• Resolved the revolving issues by conducting and participating in JAD sessions with the users, modelers and developers.
• Worked on AWS Redshift and RDS for implementing models and data on RDS and Redshift
• Participated with application developers and DBAs to discuss about various De-normalizations, partitioning and indexing schemas for physical model.
• Created Data Dictionaries, Source to Target Mapping Documents and documented Transformation rules for all the fields.
• Designed and Developed logical & physical data models and Meta Data to support the requirements.
• Carried out effective data profiling to eradicate anomalies between source and target data.
• Designed and developed Informatica mappings for data loads and data cleansing.
• Worked with T-SQL to create Tables, Views, and triggers and stored Procedures.
• Implemented SSIS data transformations scripts, created maintenance procedures and provided data integrity strategies.
• Written PL/SQL Packages, Procedures and Functions to implement the business rules and to generate the attribute corrections and parallel comparison reports.
• Performed Data Analysis and Data Profiling using complex SQL queries on various sources systems including Oracle and Teradata.
• Generated ad-hoc SQL queries using joins, database connections and transformation rules to fetch data from legacy Oracle database systems
• Maintained Meta Data Repository for storing table definitions, table spaces and entity definitions.
• Implemented of slowly changing dimensions to accommodate OLTP, OLAP and BW environments
• Involved in the data migration, data lineage and also studying the data impact analysis.
• Compiled Data analysis, sampling, frequencies and stats using SAS.
• Designed ER diagrams and mapping the data into database objects.
• Created cascading parameters for SSRS reports as well as drill-down, drill through, sub reports and interactive sorting capability.
• Created and deployed Reports utilizing Tableau to design complex reports.

Environment: Erwin9.7, Agile, SQL, PL/SQL, T-SQL, Redshift, Informatica, SSIS, Teradata15, Oracle12c, OLAP, OLTP, SAS, SSRS, Tableau.

Confidential - Little Rock, AR

Data Modeler/Data Analyst

Responsibilities:

• Modeled new tables and added them to the existing data model using Power Designer as part of data modeling.
• Facilitated JAD sessions for project scoping, requirements gathering& identification of business subject areas.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases.
• Used Query, SQL, Merge, Case, Validation transforms to transform the data (as needed) before loading into the warehouse tables.
• Involved in the development of a normalized database using Data Definition Language (DDL) in T-SQL.
• Extracted and reviewed data from heterogeneous sources like (Excel, CSV, Oracle, flat file) using SQL Server Integration Services (SSIS) from OLTP to OLAP.
• Designed and developed Tableau dashboards using stack bars, bar graphs, scattered plots, and Gantt charts.
• Involved in Data profiling, data analysis and data visualization with SAS new features, tools and technologies including SAS Visual Analytics.
• Massaged the existing model to create new logical and physical models that formed the basis for the new application.
• Implemented Data Mart, Facts, Dimensions, Snow Flake schema, Star Schema and OLAP cubes
• Created the data mapping document from source to target and the data quality assessments for the source data.
• Conducted one-on-one sessions with business users to gather Data Warehouse Requirements.
• Involved in MDM Process including data modeling and prepared data mapping documents based on graph requirements.
• Performed legacy application data cleansing, data anomaly resolution and developed cleansing rule sets for ongoing cleansing and data synchronization.
• Prepared documentation for all the analysis done and extensively used MS Office to prepare presentations.
• Created naming standards for data attributes and metadata to track data source, load frequency, generated key values, and data dictionary.
• Improving the performance on SSRS procedures and provided the recommendation on server related tuning issues.
• Created PL/SQL packages and Database Triggers and developed user procedures and prepared user manuals for the new programs.
• Worked on Metadata exchange among various proprietary systems using XML.

Environment: Power Designer, ETL, SSIS, T-SQL, Oracle11g, OLAP, OLTP, SAS, Excel, MDM, XML, SSRS, PL/SQL.