SUMMARY

• 4 years of experience in Data Analysis including Data Development, Implementation and Maintenance of databases and software applications.
• Working experience in both traditional Waterfall and sprinted Agile Methodologies.
• Having knowledge on gather business requirements and translate them into reporting needs.
• Solid hands on experience of data model repository, documentation in Meta data portals in such as Erwin, ER Studio and Power Designer tools.
• Experience with Teradata utilities like Fast Export, Fast Load, Multi Load to export and load data to/from different source systems including flat files.
• Experience in data cleansing, data transformation, data mapping specifications from source to target database.
• Extensive experience working with XML, Schema Designing and XML data.
• Good understanding of Ralph Kimball (Dimensional) & Bill Inmon (Relational) model Methodologies.
• Proficient in data mart design using dimensional data modeling - identifying Facts and Dimensions, Star Schema and Snowflake Schema.
• Extensive experience on usage of ETL & Reporting tools like SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS).
• Excellent knowledge in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, functions and Indexes using T-SQL.
• Extensive experience with T-SQL in constructing Triggers, Tables, implementing stored Procedures, Functions, Views, User Profiles, Data Dictionaries and Data Integrity.
• Well verse in system analysis, Relational and Dimensional Modeling, Database design and implementing RDBMS specific features.
• Proficiency in extracting data and creating SAS datasets from various sources like Oracle database, Access database, and flat files using Import techniques.
• Strong experience in using MS Excel and MS Access to dump the data and analyze based on business needs.
• Conduct data analysis, mapping, transformation, data modeling and data-warehouse concepts.
• Proficient in data governance, data quality, metadata management, master data management.
• Expertise in performing User Acceptance Testing (UAT) and conducting end user training sessions.
• Experience in testing Business Intelligence reports generated by various BI Tools like Cognos and Business Objects.
• Good knowledge and experienced in producing tables, reports, graphs and listings using various procedures and handling large databases to perform complex data manipulations.

TECHNICAL SKILLS

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

Programming Languages: SQL, PL/SQL

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

Cloud Management: Amazon Web Services(AWS), Redshift

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

Operating System: Windows, Unix, Sun Solaris

AWS tools: EC2, S3 Bucket, AMI, RDS, Amazon Redshift.

PROFESSIONAL EXPERIENCE

Confidential - California

Data Modeler/Data Analyst

Responsibilities:

• Massively involved as Data Modeler/Analyst role to review business requirement and compose source to target data mapping documents.
• Designed the business requirement collection approach based on the project scope and SDLC methodology.
• Designed and deployed scalable, highly available, and fault tolerant systems on Azure.
• Conducted data modeling JAD sessions and communicated data related standards.
• Extensively used Agile Method for daily scrum to discuss the project related information.
• Worked on Teradata SQL queries, Teradata Indexes, MDM Utilities such as Fast load and Fast Export.
• Created Data stage jobs (ETL Process) for populating the data into the Datawarehouse constantly from different source systems.
• Performed reverse engineering using Erwin to redefine entities, attributes and relationships existing database.
• Developed complex mapping to extract data from diverse sources including flat files, RDBMS tables, legacy system files, XML files, and Applications.
• Involved in writing T-SQL working on SSIS, SSAS, Data Cleansing, Data Scrubbing and Data Migration.
• Optimized and updated UML Models (Visio) and Relational Data Models for various applications.
• Worked on the Enterprise Metadata repositories for updating the metadata and involved in Master Data Management MDM .
• Involved in Dimensional modeling (Star Schema) of the Data warehouse and used Erwin to design the business process, dimensions and measured facts.
• Wrote Python scripts to parse XML documents and load the data in database.
• Written DDL and DML statements for creating, altering tables and converting characters into numeric values.
• Identified the Entities, attributes and designed a relational database system (RDBMS).
• Well versed in system analysis, ER/Dimensional Modeling, Database design and implementing RDBMS specific features.
• Translated business concepts into XML vocabularies by designing XML Schemas with UML.
• Extensively worked with enterprise data warehouse development by building data marts, staging and pre-staging.
• Used reverse engineering for a wide variety of RDBMS, including MS Access, Oracle and Teradata to connect to existing database and create graphical representation using Erwin.
• Worked on Data load using Azure Data factory using external table approach.
• Designed and Developed Oracle, PL/SQL and Data Import/Export, Data Conversions and Data Cleansing.
• Implemented end-to-end systems for Data Analytics, Data Automation and integrated with custom visualization tools using MongoDB.
• Worked on the reporting requirements and involved in generating the reports for the Data Model using crystal reports
• Developed several detailed reports to understand the trend analysis over periods using SQL Server Reporting Services (SSRS)
• Resolved the data type inconsistencies between the source systems and the target system using the Mapping Documents.
• Extensively used MS Access to pull the data from various data bases and integrate the data.
• Involved in T-SQL queries and optimizing the queries in SQL Server and Teradata
• Written and executed customized SQL code for ad hoc reporting duties and used other tools for routine report generation.

Environment: Erwin 9.8, Oracle 12c, SQL, PL/SQL, Agile, Teradata r15, ETL, SSIS, SSAS, MDM,XML Azure, MongoDB 4.0,T-SQL.

Confidential

Data Modeler

Responsibilities:

• Gathered the Business requirements from customers and creating data models for different branches using MS access and ER/Studio.
• Designed a STAR Schema for the detailed data marts and Plan data marts involving confirmed Dimensions.
• Worked on Teradata database, installed and configured the Teradata utility tools.
• Created reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries
• Worked on Metadata and Data Dictionary Management, Data Profiling, Data Mapping.
• Designed a normalized datamodel and several DE normalized datamodels for reports.
• Used SQL extensively for performing unit testing for the developed Modules.
• Performed data Ingestion for the incoming web feeds into the Datalake store which includes both structured and unstructured data.
• Developed reusable objects like PL/SQL program units and libraries, database procedures and functions, database triggers to be used by the team and satisfying the business rules.
• Created, managed, and modified logical and physical datamodels using a variety of data modeling philosophies and techniques including Inmon or Kimball
• Generated the DDL statements and working with the database team in creating the tables, views, keys in the database
• Managed the Metadata for the subject area models for the Datawarehouse environment
• Designed Activity, Sequence and Process FlowDiagrams using MSVisio to simplify and elaborate certain selection criteria and filter conditions
• Involved in cleaning of large data sets using python and Created named sets, calculated member and designed scope in SSAS, SSRS.
• Executed complex SQL sub queries to prepare ad-hoc reports in Oracle.
• Delineated and conducted walkthroughs of process flows using UMLdiagrams to identify data integration points to be secured.
• Designed and maintained the Logical & Physical dimensional data models using ER/Studio
• Extensively worked with Teradatautilities like fast Export, Fast Load, Multi Load to export and load data from different source systems including flat files.
• Delineated and conducted walkthroughs of process flows using UMLdiagrams to identify data integration points to be secured.

Environment: ER/Studio v15, Teradata r14, SSRSS, SQL, PL/SQL, SSAS, Oracle 10g