SUMMARY

• 10+ years of Industry experience as a Data Analyst with solid understanding of Data Modeling, Evaluating Data Sources and strong understanding of Data Warehouse/Data Mart Design, ETL, BI, OLAP, Client/Server applications.
• Strong experience in using Excel and MS Access to dump the data and analyze based on business needs.
• Excellent knowledge on Perl & UNIX.
• Experience in analyzing data using Hadoop Ecosystem including HDFS, Hive, Spark, Spark Streaming, Elastic Search, Kibana, Kafka, HBase, Zookeeper, PIG, Sqoop, Flume.
• Experienced working with Excel Pivot and VBA macros for various business scenarios.
• Strong experience in Data Analysis, Data Migration, Data Cleansing, Transformation, Integration, Data Import, and Data Export
• Experience working with data modeling tools like Erwin, Power Designer and ER Studio.
• Experience in developing Map Reduce Programs using Apache Hadoop for analyzing the big data as per the requirement.
• 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.
• Experience in importing and exporting data using Sqoop from HDFS to Relational Database Systems (RDBMS) and from RDBMS to HDFS.
• Experience in data analysis using Hive, PigLatin, Impala.
• Well versed in Normalization / De - normalization techniques for optimum performance in relational and dimensional database environments.
• Experienced in various Teradata utilities like Fastload, Multiload, BTEQ, and Teradata SQL Assistant.
• Expert in writing SQL queries and optimizing the queries in Oracle, SQL Server 2008 and Teradata.
• Develop and manage SQL, Python and R code bases fordatacleansing anddataanalysis using Git version control
• Excellent Software Development Life Cycle (SDLC) with good working knowledge of testing methodologies, disciplines, tasks, resources and scheduling.
• Excellent knowledge in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
• Performed data analysis and data profiling using complex SQL on various sources systems including Oracle and Teradata.
• Experience in designing error and exception handling procedures to identify, record and report errors.
• Excellent experience in writing and executing unit, system, integration and UAT scripts in a data warehouse projects.
• Excellent experience in writing SQL queries to validate data movement between different layers in data warehouse environment.
• Excellent experience in troubleshooting test scripts, SQL queries, ETL jobs, data warehouse/data mart/data store models.
• Extensive knowledge and experience in producing tables, reports, graphs and listings using various procedures and handling large databases to perform complex data manipulations.
• Have good exposure on working in offshore/onsite model with ability to understand and/or create functional requirements working with client Excellent in creating various artifacts for projects which include specification documents, data mapping and data analysis documents.
• An excellent team player& technically strong person who has capability to work with business users, project managers, team leads, architects and peers, thus maintaining healthy environment in the project.

TECHNICAL SKILLS

Analysis and Modeling Tools: Erwin 9.6/9.5, Sybase Power Designer, Oracle Designer, ER/Studio 9.7

Database Tools: Microsoft SQL Server 2014/2012 Teradata 15/14, Oracle 12c/11g, MS Access, Poster SQL, Netezza.

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

ETL Tools: SSIS, Pentaho, Informatica Power 9.6, SAP Business Objects XIR3.1/XIR2, Web Intelligence

Operating System: Windows, Dos, Unix

Reporting Tools: Business Objects, Crystal Reports

Web technologies: HTML, DHTML, XML, JavaScript

Tools: & Software’s: TOAD, MS Office, BTEQ, Teradata SQL Assistant

Big Data: Hadoop, HDFS 2, Hive, Pig, HBase, Sqoop, Flume.

AWS: AWS, EC2, S3, SQS.

Other tools: TOAD, SQL PLUS, SQL LOADER, MS Project, MS Visio and MS Office, Have worked on C++, UNIX, PL/SQL etc.

PROFESSIONAL EXPERIENCE

Confidential, Detroit, MI

Sr. Data Modeler/Data Architect

Responsibilities:

• Designed the Logical Data Model using ER Studio 9.7 with the entities and attributes for each subject areas.
• Working with BTEQ to submit SQL statements, import and exportdata, and generate reports in Teradata.
• Defined and deployed monitoring, metrics, and logging systems on AWS.
• Responsible for technicalDatagovernance, enterprise wideDatamodeling and Database design.
• Implementdatawarehouse designs to collect and extract/transform/loading of legacydatato core SAP system.
• Designed thedatamarts using the Ralph Kimball's DimensionalDataMart modeling methodology using ER Studio.
• Incorporated business requirements in quality conceptual, logicaldatamodels using ER Studio and created physicaldatamodels using forward engineering techniques to generate DDL scripts.
• Advises on and enforces data governance to improve the quality/integrity of data and oversight on the collection and management of operational data.
• Designing normalized and star schemadataarchitectures using ER Studio and forward engineering these structures into Teradata.
• Responsible for Bigdatainitiatives and engagement including analysis, brainstorming, POC, and architecture.
• Demonstrated expertise utilizing ETL tools, including SQL Server Integration Services (SSIS), Data Transformation Services (DTS), and DataStage and ETL package design, and RDBM systems like SQL Servers, Oracle, and DB2.
• Review and Patch of Netezza and Oracle environments including DB2, OS and Server firmware.
• Data modeling, Design, implement, and deploy high-performance, custom applications at scale on Hadoop /Spark.
• Selecting the appropriate AWS service based on data, compute, database, or security requirements.
• Used Flume extensively in gathering and moving log data files from Application Servers to a central location in Hadoop Distributed File System (HDFS) for data science.
• Working on Amazon Redshift and AWS and architecting a solution to load data, create data models and run BI on it.
• Used Teradata Administrator and Teradata Manager Tools for monitoring and control the system.
• Developed and configured on Informatica MDM hub supports the Master Data Management (MDM), Business Intelligence (BI) and Data Warehousing platforms to meet business needs.
• Worked with Hadoop eco system covering HDFS, HBase, YARN and Map Reduce.
• Massively involved inDataArchitectrole to review business requirement and compose source to targetdatamapping documents.
• Worked and used different database types like DynamoDB orRedshift.
• Developed, Implemented & Maintained the Conceptual, Logical & PhysicalDataModels using ER/Studio 9 (ER Studio)- Forward/Reverse Engineered Databases.
• Involved in Agile project management environment.
• Translate business anddatarequirements into Logicaldatamodels in support of EnterpriseData Models, ODS, OLAP, OLTP, OperationalDataStructures and Analytical systems.
• Designed both 3NFdatamodels for ODS, OLTP systems and dimensionaldatamodels using Star and Snow flake Schemas.
• Worked extensively on ER Studio for multiple Operations across Hartford in both OLAP and OLTP applications.
• Developed PL/SQL scripts to validate and loaddatainto interface tables
• Involved in maintainingdataintegrity between Oracle and SQL databases.
• Involved in OLAP model based on Dimension and FACTS for efficient loads ofdatabased on Star Schema structure on levels of reports using multi-dimensional models such as Star Schemas and Snowflake Schema.
• Performed theDataMapping,Datadesign (DataModeling) to integrate thedataacross the multiple databases in to EDW.
• Perform administrative tasks, including creation of database objects such as database, tables, and views, using SQL DCL, DDL, and DML requests.
• Participated in several project activities includingDataArchitectdesign, ETL design, QA support, Code review.

Environment: ER Studio 9.7, Teradata 15, Star Schema, Snowflake Schema, OLAP, OLTP, Oracle 12c, ODS, Business Objects, MDM, Hadoop, Spark, Cassandra, SAP.

Confidential

Sr. Data Modeler/Data Architect

Responsibilities:

• Implemented Dimensional Modeling using Star and Snow Flake Schema, Identifying Facts and Dimensions, Physical and logicaldatamodeling using ERwin
• Worked in Data Analysis, data profiling and data governance identifying Data Sets, Source Data, Source Meta Data, Data Definitions and Data Formats.
• Involved in the Analysis, design, testing and Implementation of Business Intelligence solutions using DataWarehouse, ETL, OLAP, Client/Server applications.
• Involved in Java code, which generated XML document, which in turn used XSLT to translate the content into HTML to present to GUI.
• Experience with BIReporting in Design and Development of Queries, Reports, Workbooks, Business Explorer Analyzer, Query Builder, Web Reporting.
• Extensive experience in ETL/Datawarehousebackend testing and BI Intelligence reports testing. used
• Elastic Search for indexing the tweets and enhancing the search speed
• Lead Architectural Design in Big Data, Hadoop projects and provide for a designer that is an idea-driven
• Responsible for the analysis, implementation, testing and maintenance of CCC's bibliographic and rights databases, ensuring data conformity to CCC policies, procedures and standards in support of ongoing bibliographic andmetadataexcellence in CCC's products and services
• UsedPythonscripts to update the content in database and manipulate files visionary with a high level of design skills of the complex nature of science and technology projects.
• Good knowledge in advanced Java language concepts like Multithreading, Collections and Generics.
• Extracting Mega Data from Amazon Redshift, AWS, and Elastic Search engine using SQL Queries to create reports
• Independently code new programs and design Tables to load and test the program effectively for the given POC's using with Big Data/Hadoop along with the following technical skills like Hive, HDFS, Impala, Hue, Solr, Jason Scripts, Spark, Cloudera Manager, Cloudera Navigator to deliver complex systems issues or changes.
• WrotePythoncode embedded with JSON and XML to produce HTTP GET request, parsing HTML data from websites.
• Strong understanding ofdatawarehousing concepts,dimensionalmodeling, Star and Snowflake schemas.
• Generated comprehensive analytical reports by running SQL queries against current databases to conductData Analysis.
• PerformedData Analysis, Data Migration and data profiling using complex SQL on various sources systems including Oracle andNetezza.
• Used Erwin model mart for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Used Model Manager Option in Erwin to synchronize the data models in Model Mart approach.
• Built database Model, Views and API's usingPythonfor interactive web based solutions.
• Involved inDimensionalmodeling(Star Schema) of theDatawarehouse and used Erwin to design the business process, dimensions and measured facts.
• Designed ER diagrams (Physical and Logical usingErwin) and mapping the data into database objects.
• Full life cycle of Data Lake, Data Warehouse with Big data technologies like Spark, Hadoop, Cassandra .
• Definemetadatabusiness-level (logical) terms through interactions with project teams, business subject matter experts, and data analysis.
• Worked with the ETL team to document the transformation rules for data migration from OLTP to Warehouse environment for reporting purposes.
• Used Netezza Analytical functions like RANK, ROW NUMBER etc.
• Performed ad hoc analyses, as needed, with the ability to comprehend analysis as needed

Environment: Oracle10g, SQL server, MS Excel, MS Visio, Rational Rose, Requisite Pro, Rational, Big Data, Oracle 8i, Windows XP, PL/SQL,, Sql Server, MS Office, MS Access, MS Visio.

Confidential, Atlanta, GA

Sr.Data Modeler/Data Architect

Responsibilities:

• Created logical data model from the conceptual model and validated the model with response to questionnaire from business analyst and its conversion into the physical database design.
• Conducted JAD sessions with management, vendors, users and other stakeholders for open and pending issues to develop specifications.
• UsedPythonlibrary Beautiful Soup for webscrapping.
• Have used SQL queries to perform Data Analysis and Data Profiling.
• Identify source systems, their connectivity, related tables and fields and ensure data suitably for mapping.
• UsedPythonscripts to update the content in database and manipulate files.
• Mentor new members of the Metadata Steward team.
• Involved in Big Data Analytics and Massively Parallel Processing (MPP) architectures like Green Plumand Teradata.
• Experience in writing test cases in java environment using JUnit.
• Generated ad-hoc SQL queries using joins, database connections and transformation rules to fetch data from Teradata database.
• Wrote code to support model-view-controller (MVC) pattern ofPythonDjango framework in developing several modules for the application.
• Involved with data profiling for multiple sources and answered complex business questions by providing data to business users.
• Worked with data investigation, discovery and mapping tools to scan every single data record from many sources.
• Conduct online educational presentations of various aspects of our metadata as well as our metadata tool, Ab Initio.
• Expertise and worked on Physical, logical and conceptual data model
• Designed both 3NF data models for ODS, OLTP systems and dimensional data models using star and snow flake Schemas.
• Integrated the Java code (API) in JSP pages and responsible for setting up Angular.JS framework for UI development. Developed html views with HTML5, CSS3, bootstrap and Angular.JS.
• Wrote and executed unit, system, integration and UAT scripts in a data warehouse projects.
• Able to guide / partner with VP / Directors for architecting solutions for the Big data Organization
• Created and enhanced OOTB/SharePointDesigner/Visual Studio Workflows.
• Implementation of full lifecycle inDatawarehouses and BusinessDatamarts with Star Schemas, Snowflake Schemas, SCD &DimensionalModeling.
• Created queries using BI- Reporting variables, navigational attributes and Filters. Developed workbooks, info set Queries. Defined reports as per reporting requirements.
• Wrote and executed various MYSQL database queries frompythonusingPython-MySQL connector and MySQL dB package.
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Validating the data passed to downstream systems.
• Collaborated with other data modeling team members to ensure design consistency and integrity
• Normalized the database up to 3NF to put them into the star schema of thedatawarehouse.
• Developed Java Beans and Utility Classes for interacting with the database using JDBC.
• Manually "Ingested" (registered and processed) incoming video files and metadata from multiple company
• Perform data reconciliation between integrated systems.
• Extensively used MS Access to pull the data from various data bases and integrate the data.
• Assisted in the oversight for compliance to the Enterprise Data Standards, data governance and data quality

Environment: PL/SQL, Tableau, ETL Tools Informatica 9.5/9.1 Oracle 11G, Teradata R14, Teradata SQL Assistant 14.0, Informatica 8.1, Data Flux, Oracle 9i, Quality Center 8.2, SQL, TOAD, PL/SQL, Flat Files, Teradata, Netezza.

Confidential, Jacksonville, FL

Sr. Data Modeler/ Data Analyst

Responsibilities:

• Designed logical and physical databases and reviewed database design.
• Facilitated data requirements and business requirements based on the project by interacting with business people.
• Participated in integration of MDM (Master Data Management) Hub and data warehouses.
• Performed data analysis and data profiling using complex SQL on various sources systems including Oracle 10g/11g and Teradata.
• Hands on experience indatawarehousing ETL tools like Informatica 8.x, 9.x, including good knowledge ofdimensionalmodeling.
• Analysis of functional and non-functional categorized data elements for data profiling and mapping from source to target data environment. Developed working documents to support findings and assign specific tasks
• Involved with data profiling for multiple sources and answered complex business questions by providing data to business users.
• Worked with data investigation, discovery and mapping tools to scan every single data record from many sources.
• Helped track invoices for costs on requesting French and Spanish language metadata translations
• • Performed scheduling of EST, IVOD, SVOD, VOD, FVOD and TVOD content.
• Involved in the transportation ofBIobjects from development to quality and production.
• Created a logical design and physical design inER Studio.
• Worked with data source systems and Client systems to identify data issues, data gaps, identified and recommended solutions.
• Performed data modeling and data analysis as required.
• Worked on database features and objects such as partitioning, change data capture, indexes, views, indexed views to develop optimal physical data model.
• Worked with the Data Architect in defining and maintaining database design standards.
• Performed quality control for compressed video files, checking for digital hits, audio tears, and correct metadata mapping.
• Involved in developing detailed test plan, test cases and test scripts using Quality Center for Functional and Regression Testing.
• Involved in Data mapping specifications to create and execute detailed system test plans. The data mapping specifies what data will be extracted from an internal data warehouse, transformed and sent to an external entity.
• Responsible for different Data mapping activities from Source systems to Netezza
• Developed, maintained, and applied standards for enterprise modeling, including reviews, naming conventions and XML naming standards.
• Involved in theBigDatarequirements review meetings and partnered with business analysts to clarify any specific scenarios.
• Worked with Development DBA to assist and support developers with SQL performance tuning, query tuning and code reviews
• Analysis of functional and non-functional categorized data elements for data profiling and mapping from source to target data environment. Developed working documents to support findings and assign specific tasks
• Involved with data profiling for multiple sources and answered complex business questions by providing data to business users.
• Worked with data investigation, discovery and mapping tools to scan every single data record from many sources.
• Performed data mining on Claims data using very complex SQL queries and discovered claims pattern.
• Created DML code and statements for underlying & impacting databases.
• Perform data reconciliation between integrated systems.

Environment: PL/SQL, ETL Tools Data Stage, Oracle 11G, UNIX, Information Analyzer, Erwin