PROFESSIONAL SUMMARY:

• 11+ years of experience in Data Analysis, Design & Modeling across various industries, clients and geographies.
• Experienced with all major databases: Oracle, SQL Server 2008/2012, Teradata in large data warehouse (OLAP) environments.
• Experience working with data modeling tools like Erwin, Power Designer and ER Studio.
• Experience in designing star schema, Snowflake schema for Data Warehouse, ODS architecture.
• Experience in Requirement gathering, System analysis, handling business and technical issues & communicating with both business and technical users.
• Designed the Data Marts in dimensional data modeling using star and snowflake schemas.
• Well versed in Normalization / Denormalization techniques for optimum performance in relational and dimensional database environments.
• Very proficient with Data Analysis, mapping source and target systems for data migration efforts and resolving issues relating to data migration.
• Efficient in analyzing and documenting business requirement documents (BRD) and functional requirement documents (FRD) together with UseCase Modeling and UML.
• Experienced with integration of External Data with SAP in Business Warehouse.
• Experience in Data Scrubbing/Cleansing, Data Quality, Data Mapping, Data Profiling, Data Validation in ETL.
• Experienced with Data Quality Management, Metadata Management, Master Data Management, Process Modeling, Data Dictionary, Data Stewardship, Data Profiling, Data Quality, and Data Model Standards.
• Excellent knowledge of Bill Inmon and Ralph Kimball methodologies to design database architecture. Excellent knowledge on logical application design and physical implementation for database application.
• Excellent knowledge of complete data warehouse life cycle, testing methodologies, OLAP and OLTP. Excellent knowledge of SDLC phases (Inception, Elaboration, Construction and Transition). Excellent knowledge on retail domains.
• Experienced with most of software deployments methodologies like Water Fall, Iteration, Agile and Rapid Application Development (RAD).
• Experienced in Database using Oracle, XML, Teradata, SQL server and NoSQL.
• A good familiarity and expertise in the work environment including things like Business analysts, Production/Support teams, Subject Matter Experts, Database Administrators and Database developers.
• Experience in creating scripts to fetch data from NoSQL database like MongoDB.
• Well versed in conducting Gap analysis, User Acceptance Testing (UAT), Cost benefit analysis and ROI analysis.
• Worked with Architects, Developers and Quality Assurance lead to understand Use Case and functional requirements.
• Facilitated and participated in Joint Application Development (JAD) sessions, and white board sessions to keep executive staff and the team members apprised of goals, project status, and resolving issues.
• Excellent communicative, interpersonal, intuitive, analysis, leadership skills, quick starter with ability to master and apply new concepts.

TECHNICAL SKILLS:

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

OLAP Tools: Microsoft Analysis Services, Business Objects and Crystal Reports9.

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

Database Tools: Microsoft SQL Server 2000/2005/2008/2012/2014 , MySQLOracle 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.

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

Data Modeler/Data Analyst

Responsibilities:

• Attended and participated in information and Requirements Gathering sessions.
• Ensured that Business Requirements can be translated into Data Requirements.
• Involved in many meetings with the customers, Business and users to understand their requirements and to effectively change the existing design to improve the performance.
• Used OWB as ETL tool to extract data from source systems, cleanse Transform, and Load data into databases.
• Designed Star and Snowflake Data Models for Enterprise Data Warehouse using ERWIN.
• Identified the Facts & Dimensions Tables and established the Grain of Fact for Dimensional Models.
• Worked on Migrating the Tables from Oracle database to Vertica.
• Designed process flows to execute the mappings in orderly fashion, called PLSQL procedures in the process flows and other functions.
• Generated SQL loader scripts and shell scripts for automated daily load processes. Reverse Engineered the existing database structure to understand the existing data models.
• Worked very close with Data Architectures and DBA team to implement Data Model changes in database in all environments. Generated DDL scripts for Database Modifications, Views and set tables.
• Created Universe using Business Objects for pulling the data for analysis and reporting.
• Part of team conducting logical data analysis and data modeling JAD sessions, communicated data-related standards.
• Conducted one-to-one sessions with Source SME to gather Source Mapping for the reporting attributes.
• Worked with developers and Quality Assurance lead to develop Use Case and functional requirements,Logical Architectural Diagrams, User Acceptance Test plans.
• Identify Source systems, set up access to the systems and document source application coverage's.
• Performed Data Profiling on the attributes which helps in reducing the project risk by identifying data quality issues that must be handled in the code that moves data from the legacy system to the Target(new)system and identifying data issues that may require a change to the Target(new) system .
• Have done Data Mapping to Identify the Subject Area, Target table name and Target Column name to which the Source attribute should fall under.
• Configure model design tool (Power Designer), metadata repository (Informatica Meta Manager), and analytical/reporting tool (Business Object) and set up Environment.
• Developed a Conceptual model using Power Designer based on requirement analysis.
• Created normalized Logical and physical data models using best practices to ensure high data quality and reduced redundancy with the IDW Standards and Guidelines.

Environment: Erwin 9.6,Microsoft SQL Server 2014, Teradata DB, Teradata SQL Assistant

Confidential, Norfolk, VA

Data Modeler

Responsibilities:

• Worked with Business Analysts team in requirements gathering and in preparing functional specifications and translating them to technical specifications.
• Extensively involved in developing logical and physical data models that fit in exactly for the current state and the future state data elements and data flows using Erwin.
• Documenting business names and descriptions for tables and columns, relationships among datasets and data types, business rules and domains used ER/Studio.
• Using Kettle Scripting/ Pentaho processed data from one table and replaced some values, filtered some values and syncing two data sources.
• Utilized existing Informatica, Teradata, and SQL Server to deliver work and fix production issues on time in fast paced environment.
• Defined the key columns for the Dimension and Fact tables of both the Warehouse and Data Mart.
• Interacted with the End users frequently and transferred the knowledge to them.
• Conducted and participated JAD sessions with the Project managers, Business Analysis Team, Finance and Development teams to gather, analyze and document the Business and reporting requirements.
• Conduct Design discussions and meetings to come out with the appropriate Data Mart Confidential the lowest level of grain for each of the Dimensions involved.
• Interacting with the Business Users for gathering data design requirements and taking feedback on improvements.
• Designed a STAR schema for the detailed data marts and Plan data marts involving shared dimensions (Conformed).
• Worked on Informatica Data Quality to resolve customers address related issues.
• Worked on MongoDB database concepts such as locking, transactions, indexes and replication.
• 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.
• Worked with data owners/stewards to ensure awareness of data quality standards and monitoring requirements.
• Performed data migration from an RDBMS to a NoSQL database.
• 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.
• Conduct Design reviews with the business analysts and content developers to create a proof of concept for the reports.
• Ensured the feasibility of the logical and physical design models.
• Collaborated with the Reporting Team to design Monthly Summary Level Cubes to support the further aggregated level of detailed reports.
• Prepared documentation for all entities, attributes, data relationships, primary and foreign key structures, allowed values, codes, business rules, and glossary evolve and change during the project.

Environment: Erwin 9.2, Informatica Power Center 9.X, Oracle 10g,Microsoft Excel, MS Word, SIEM Technology, Power Point, TOAD, and SQL developer for Oracle.

Confidential, San Antonio, TX

Data Modeler/ Data Analyst

Responsibilities:

• Maintained the stage and production conceptual, logical, and physical data models along with related documentation for a large data warehouse project.
• Assisted in migration of data models from Oracle Designer to Erwin and updating the data models to correspond to the existing database structures.
• Investigated data sources to identify new data elements needed for data integration.
• Performed data analysis using SQL queries on source systems to identify data discrepancies and determine data quality.
• Served as a resource for analytical services utilizing SQL Server and TOAD/Oracle and Created SQL queries using TOAD and SQL Navigator and also created various databases object stored procedure, tables, views.
• Updated or Created new data models for each release and generated database scripts from Erwin.
• Used Erwin to create report templates. Maintained and changed the report templates as needed to generate varying data dictionary formats as contract deliverables.
• Worked with the DBAs on maintaining existing, and creating new, database Tools & Technologies and communicate to leadership within our company to convey the importance and business value of data descriptions for entities, attributes, domain values and relationships using data modeling tools to create Entity Relationship Diagrams.
• Created Data stage jobs (ETL Process) for populating the data into the Data warehouse constantly from different source systems.
• Analyzed and designed the business rules for data cleansing that are required by the staging and OLAP & OLTP database.
• Updated or worked with test team members to help them understand data changes and write test cases.
• Identified and documented data sources and transformation rules required to populate and maintain data warehouse content.
• Was responsible for indexing the tables in the data warehouse and performed data modeling within information areas across the enterprise including data cleansing and data quality using data modeling methods and processes.
• Involved in logical and Physical Database design & development, Normalization and Data modeling using Erwin and SQL Server Enterprise manager.
• Implemented the Data Cleansing using various transformations.
• Used Data Stage Director for running and monitoring performance statistics.
• Reverse Engineered the existing ODS into Erwin.
• Created reports to retrieve data using Stored Procedures.
• Designed and implemented basic SQL queries for testing and report/data validation.
• Ensured the compliance of the extracts to the Data Quality Center initiatives.
• Gathered and documented the Audit trail and traceability of extracted information for data quality.

Environment: MS Word, MS Excel, MS Access, Erwin, SQL Server, MS Visio, Oracle, UNIX, Linux, Teradata, DB2.

Confidential, Cincinnati, OH

Data Analyst

Responsibilities:

• Analyze the OLTP Source Systems and Operational Data Store and research the tables/entities required for the project.
• Designing the measures, dimensions and facts matrix document for the ease while designing.
• Created data flowcharts and attribute mapping documents, analyzed the source meaning to retain and provide proper business names following the very stringent FTB's data standards.
• Developed several scripts to gather all the required data from different databases to build the LAR file monthly.
• Implemented data quality checks on the monthly LAR file to make sure the data is within the federal regulations.
• Developed numerous reports to capture the transactional data for the business analysis.
• Developed complex SQL queries to bring data together from various systems.
• Organized and conducted cross-functional meetings to ensure linearity of the phase approach.
• Collaborated with a team of Business Analysts to ascertain capture of all requirements.
• Created multiple reports on the daily transactional data which involves millions of records.
• Used Joins like Inner Joins, Outer joins while creating tables from multiple tables.
• Created Multiset, temporary, derived and volatile tables in Teradata database.
• Implemented Indexes, Collecting Statistics, and Constraints while creating tables.
• Utilized ODBC for connectivity to Teradata via MS Excel to retrieve automatically from Teradata Database.
• Developed various ad hoc reports based on the requirements.
• Designed & developed various Ad hoc reports for different teams in Business (Teradata and Oracle SQL, MS ACCESS, MS EXCEL).
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Involved in writing complex SQL queries using correlated sub queries, joins, and recursive queries.
• Delivered the artifacts within the time lines and excelled in the quality of deliverables.
• Validated the data during UAT testing.
• Performing source to target Mapping
• Involved in Metadata management, where all the table specifications were listed and implemented the same in Ab Initio metadata hub as per data governance.
• Developed Korn Shell scripts to parallel extract and process data from different sources simultaneously to streamline performance and improve execution time in a parallel process for better time, resource management and efficiency.
• Used Teradata utilities such as TPT (Teradata Parallel Transporter), FLOAD (Fastload) and MLOAD (Multiload) for handling various tasks.
• Developed Logical data model using Erwin and created physical data models using forward engineering.

Environment: Erwin 8.0, Teradata 13, TOAD, Oracle 10g/11g, MS SQL Server 2008, Teradata SQL Assistant, XML Files, Flat files.

Confidential

Business Analyst/ Data Analyst

Responsibilities:

• Gathered and translated business requirements into detailed, production-level technical specifications, new features, and enhancements to existing technical business functionality.
• Reverse Engineered existing Relational and Dimensional data base systems as there were no existing data models for them.
• Applied data warehousing methodologies in enhancing the existing data model.
• Enhanced the warehouse model using Erwin tool.
• Implemented Star Schema, snowflake methodologies in enhancing data warehouse.
• Identified new facts, dimensions and reused existing conformed dimensions as per business requirements.
• Enhanced existing facts and dimensions based on the business requirements.
• Scheduled working sessions with ETL team to understand the need of work tables where needed.
• Performed gap analysis where applicable to make sure there are no data anomalies.
• Followed standards and best practices in indexing and partitioning where performance can be a concern.
• Provided detailed data mapping documents for both OLTP and OLAP.
• Supported ETL team in understanding the process and creating/enhancing the ETL maps.
• Supported QA by providingassistance in writing the sql prototypes as needed.

Environment: Erwin r7.0, SQL/MS SQL Server, MS OLAP Manage, MS Analysis Services, Windows NT, MS Visio, XML, Informatica, Crystal Reports 9.