SUMMARY:

• 10+ yrs of progressive Sr.DataArchitect experience in Development, Support and Maintenance of various Client/Server applications in Finance, Telecom projects.
• Goal - oriented IT professional with strong background in Data Analysis & Modeling.
• Experience using Map Reduce, and "Big data" work on Hadoop and other NOSQL platforms.
• Experience in analyzingBigDataapplying Supervised and Unsupervised learnings.
• Involved in designing and architecting data warehouses and data lakes on regular (Oracle, SQL Server) high performance (Netezza and Teradata) and big data (Hadoop - Hive and HBase) databases.
• Excellent knowledge of waterfall and spiral methodology of software development life cycle (SDLC).
• Participated in JAD sessions and requirements gathering & identification of business subject areas.
• Experienced in Data modeling for Data Mart/Data Warehouse development including conceptual, logical and physical model design, developing Entity Relationship Diagram (ERD), reverse/forward engineer (ERD) with CA ERwin data modeler.
• Strong Knowledge of Data Warehouse Architecture and Star Schema, Snow flake Schema, FACT and Dimensional Tables.
• Experience with big data concepts such as Hadoop and views, stored procedures, functions, Packages, joins and hash indexes in Teradata database.
• Working knowledge ofBigdata, NewSql, NoSQL, Vertica,
• Creatingdatamodels (ERD, logical) including robustdatadefinitions, which may be entity-relationship-attribute models, star, and snowflake models
• Good experienced inDataModeling andDataAnalysis as a Proficient in gathering business requirements and handling requirements management.
• Experienced in logical/physical database design and review sessions to determine and describedataflow andData mapping from source to target databases coordinating with End Users, Business Analysts, DBAs and Application Architects.
• Experienced in Teradata EnterpriseData Warehouse (EDW) andDataMart.
• Experienced in writing SQL queries and optimizing the queries in Teradata, Netezza, Oracle and SQL Server.
• Excellent understanding of Hub Architecture Style for MDM hubs the registry, repository and hybrid approach.
• Used the Ralph Kimball Methodology for Data Warehouse and Data Mart designs.
• Worked extensively on Erwin and ER Studio in several projects in both OLAP and OLTP applications.
• Managed the meta-data for the Subject Area models for both Operational & Data Warehouse/Data Mart applications.
• Experienced in Strong in Source to Targetdatamapping, Standardization Document Slowly Changing Mapping Creation, Star/Snowflake Schema Mapping Creation, RDMS, BuildingDataMarts and MetaData Management.
• Proficient in identifying Facts and Dimensions, Star Schema and Snow Flake Schema and ODS architecture for modeling aData Warehouse in Relational, Dimensional and multidimensional modeling.
• Highly Efficient inData Mart Design and creation of cubes using dimensionaldatamodeling - identifying Facts and Dimensions, Star Schema and Snowflake Schema.
• Experienced in understanding the ETL framework metadata to understand the current state ETL implementation.
• Worked expansively on forward and reverse engineering processes. Created DDL scripts for implementingData Modeling HTML, RTF format depending uponchanges. Created ERWIN reports in.
• Worked with ETL Architects and developer to design performance centric ETL mappings.
• Experience in technologies, including Oracle … MS SQL Server … MS Access, Microsoft Visio, Visual Basics, Windows DOS and UNIX shell scripting.
• Experience as a System Administrator/Computer Operator in the financial environment working on VM Ware, Appworx and IBM Mainframe.

TECHNICAL SKILLS:

Programming Languages: SQL, PL/SQL, UNIX shell Scripting, PERL, AWK, SED

DataModeling Tools: Star-Schema Modeling, Snowflake-Schema Modeling, FACT and dimension tables, Pivot Tables, Erwin

ETL/Data warehouse Tools: Informatica, SAP Business Objects XIR3.1/XIR2, Web Intelligence, Talend, Tableau, Pentaho

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

Testing Tools: Win Runner, Load Runner, Test Director, Mercury Quality Center, Rational Clear Quest

BigData: Hadoop, HDFS 2, Hive, Pig, HBase, Sqoop, Flume.

RDBMS: Oracle 12c/10g/9i/8i/7.x, MS SQL Server, UDB DB2 9.x, Teradata, MS Access 7.0

OLAP Tools: MS SQL Analysis Manager, DB2 OLAP, Cognos Powerplay

Environment: Windows: (95, 98, 2000, NT, XP), UNIX

Other Tools: TOAD, MS-Office suite (Word, Excel, Project and Outlook), BTEQ, TeradataSQL Assistant

PROFESSIONAL EXPERIENCE:

Confidential, Auburn Hills, MI

Sr. Data Architect/Data Modeler

Responsibilities:

• Working in Regulatory Compliance IT team where worked as Data Architect role which involved Data Profiling, Data Modeling, ETL Architecture & Oracle DBA.
• Analyzed the reverse engineered Enterprise Originations (EO) physical data model to understand the relationships between already existing tables and cleansed unwanted tables and columns as part of Data Analysis responsibilities.
• Responsible for Big data initiatives and engagement including analysis, brainstorming, POC, and architecture.
• Designed the Logical Data Model using ERWIN 9.64 with the entities and attributes for each subject areas.
• Developed long term data warehouse roadmap and architectures, designs and builds the data warehouse framework per the roadmap.
• Implemented Join optimizations in Pig using Skewed and Merge joins for large datasets schema.
• Designed and developed a Data Lake using Hadoop for processing raw and processed claims via Hive and Informatica.
• Provided a consultative approach with business users, asking questions to understand the business need and deriving the data flow, logical, and physical data models based on those needs.
• Involved in loading data from LINUX file system to HDFS Importing and exporting data into HDFS and Hive using Sqoop Implemented Partitioning, Dynamic Partitions, Buckets in Hive.
• Design and developed architecture fordataservices ecosystem spanning Relational, NoSQL, and BigDatatechnologies.
• Data modeling, Design, implement, and deploy high-performance, custom applications at scale on Hadoop /Spark.
• Specifies overall Data Architecture for all areas and domains of the enterprise, including Data Acquisition, ODS, MDM, Data Warehouse, Data Provisioning, ETL, and BI.
• Developed Data Mapping, Data Governance, and Transformation and cleansing rules for the Master Data Management Architecture involving OLTP, ODS.
• Create conceptual, logical and physical models for OLTP, Data Warehouse Data Vault and Data Mart, Star/Snowflake schema implementations.
• Involved in Normalization / De normalization techniques for optimum performance in relational and dimensional database environments.
• Performance tuning and stress-testing of NoSQL database environments in order to ensure acceptable database performance in production mode.
• Implemented strong referential integrity and auditing by the use of triggers and SQL Scripts.
• Implemented database procedures, triggers and SQL scripts for development teams.
• Designed and developed T-SQL stored procedures to extract, aggregate, transform, and insert data.
• Developed SQL Stored procedures to query dimension and fact tables in data warehouse.
• Performed Hive programming for applications that were migrated to big data using Hadoop
• Generated parameterized queries for generating tabular reports using global variables, expressions, functions, and stored procedures using SSRS.
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Extensive knowledge in Data loading using PL/ SQL Scripts and SQL Server Integration Services (SSIS).
• Focused on architecting NoSQL databases like Mongo, Cassandra and Cache database.
• Point in time Backup and recovery in MongoDB using MMS. Data modeling for data from RDBMS to and MongoDB for optimal reads and writes.
• Implemented Data Integrity and Data Quality checks in Hadoop using Hive and Linux scripts.
• Proficiency in SQL across a number of dialects (we commonly write MySQL, PostgreSQL, Redshift, SQL Server, and Oracle).
• Experience with AWS ecosystem (EC2, S3, RDS, Redshift).
• Routinely deal in with large internal and vendor data and perform performance tuning, query optimizations and production support forSAS, Oracle 12c.

Environment: DB2, CA Erwin 9.6, Oracle 12c, MS-Office, SQL Architect, TOAD Benchmark Factory, SQL Loader, PL/SQL, SharePoint, ERwin r9.64, Talend, MS-Office, Redshift,SQL Server 2008/2012/2014 , Hive, Pig, Hadoop, Spark, AWS.

Confidential, Ashburn, VA

Data Architect/Data Modeler

Responsibilities:

• Performeddataanalysis anddataprofiling using complex SQL on various sources systems including Oracle 10g/11g/12c and Teradata.
• As aArchitectimplement MDM hub to provide clean, consistentdatafor a SOA implementation.
• Developed a Conceptual Model and Logical Model using Erwin based on requirements analysis.
• Created the best fit Physical Data Model based on discussions with DBAs and ETL developers.
• Utilized Erwin's forward/reverse engineering tools and target database schema conversion process.
• Full life cycle of Data Lake, Data Warehouse with Big data technologies like Spark, Hadoop, Cassandra.
• Define Big Data strategy, including designing multi-phased implementation roadmaps.
• Performed PoC for Big data solution using Cloudera Hadoop for data loading and data querying.
• Reviewed and implemented the naming standards for the entities, attributes, alternate keys, and primary keys for the logical model.
• Created conceptual, logical and physical data models, data dictionaries, DDL and DML to deploy and load database table structures in support of system requirements.
• Worked ondatawarehousing, ETL, SQL, scripting andbigdata(MPP + Hadoop)
• Worked on data mapping process from source system to target system.
• Created dimensional model for the reporting system by identifying required facts and dimensions using Erwin.
• 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.
• Extensively worked with Crystal Reports in Designing and generating the Report format and templates for the general reports system for the applications
• Worked in generating the reports in Erwin 8.1 with the help of Crystal Reports.
• Responsible for analyzing variousdatasources such as flat files, ASCIIData, EBCDICData, RelationalData(Oracle, DB2 UDB, MS SQL Server) from various heterogeneousdatasources.
• Extensively used Star and Snowflake Schema methodologies.
• Worked on Slowly Changing Dimension tables.
• Leaddataarchitectand designer of next generation high-speeddataingestion / cleanse / transform pipeline spanning thousands of columns ofdata
• Developed and maintainedDataDictionary to create Metadata Reports for technical and business purpose.Responsible for differentData mapping activities from Source systems to Teradata.
• Excellent experienced in troubleshooting test scripts, SQL queries, ETL jobs,Data Warehouse/data mart/datastore models.
• Excellent in creating various artifacts for projects which include specification documents,Data mapping anddataanalysis documents.

Environment: Erwin 8.0, SQL, SQL Server 2012, Teradata, SQL Assistant 12.0/13.11, Data stage 8.1, DB2, Spark, Hadoop, Cassandra.

Confidential, NYC, NY

Data Architect/Data Modeler

Responsibilities:

• The focus for this Project included technical thought leadership, team and client project leadership, enterprise architecture, Data design and implementation, business development, and strategy evaluations that are focused on cloud services. Moreover to provide solutions within the Hadoop environment using technologies such as HDFS, MapReduce, Pig, Hive, HBase, ZooKeeper, Storm, pentaho ETL and other Big Data technologies. In a senior Enterprise Data Architect role regularly communicated Business Intelligence and Data Warehousing conceptsto both our corporate Business managers and Technology partners.
• Developed Conceptual model using Erwin based on requirements analysis.
• Worked with Business Analyst during requirements gathering and business analysis to prepare high level Logical Data Models and Physical Data Models.
• Prepared data dictionaries and Source-Target Mapping documents to ease the ETL process and user's understanding of the data warehouse objects
• Implemented the slowly changing dimension (Type II) and determined the hierarchies in dimensions.
• Developed various QlikviewDataModels by extracting and using thedatafrom various sources files, Sybase, DB2, Excel, andBigdata, Flat Files.
• Developed a strategy to modernize application architecture by enabling agile development and implementation through containerization, introducing support for unstructureddatathrough NoSQL and bigdatadatabase technologies, eliminating maintenance downtime through regional replication and distributed infrastructure, and creating an always-on customer centric service for information delivery.
• Extensively used reverse engineering feature of Erwin to save the data model with production.
• Used Erwin data model mart for storing different versions of the model.
• Extensively used Erwin and Normalization Techniques to design Logical/Physical Data Models, relational database design.
• BigData/DataLake - assessing and defining strategic businessdataarchitectures.
• Created Data dictionary using ERWIN modeler.
• Analyzed and optimized the existing business processes using Conceptual Models and Data Flow Diagram. The process included performance enhancement requirements assessment and mapping of existing work flow and data flows
• Understand and follow naming conventions as defined by IBC Data Architecture team and associated documentation.
• Played a key role together with top technicalarchitectsfrom Sun, Oracle, BEA, Microsoft, and IBM to design and build a reference implementations of automotive ordering internal enterprise web service based application and company-external ebXml service based automotive application
• Ability to ensure the DDL generated from Erwin is correct for four DBMSs: Oracle 10g, SQL Server 2008, DB2 ZOS and DB2 LUW.
• Ability to recognize and resolve discrepancies between executed DDL and the physical data model using complete compare
• Ability to document activities and communicate with Data Architects as to status of Physical Data Modeling activities.
• Created functional decomposition diagrams and Context Diagrams.
• Participated in JAD sessions to solve the revolving issues between the executive teams and developers.

Environment: ERWIN, Power Designer 12.5, DATAFLUX 6.1,, Oracle 9i, SQL/PL SQL, SQL, Pig, Hive, HBase, ZooKeeper Navigator, Windows NT 4.0, UNIX, Microsoft Access, Microsoft Visio, SQL Server 2000, MS Access, Microsoft Excel.

Confidential, Dayton, OH

Data Analyst/Data Modeler

Responsibilities:

• Experienced in 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
• Worked on various business areas related data and extracted data from various sources such as flat files, Oracle and Mainframes.
• Worked with data investigation, discovery and mapping tools to scan every single data record from many sources.
• Performed data analysis and data profiling using complex SQL on various sources systems including Oracle and Teradata.
• Experienced in Writing several shell scripts using UNIX Korn shell for file transfers, error logging, data archiving, checking the log files and cleanup process.
• Worked onMetrics reporting, data mining and trends in helpdesk environment using Access
• Performed data management projects and fulfilling ad-hoc requests according to user specifications by utilizing data management software programs and tools like Perl, Toad, MS Access, Excel and SQL
• Written SQL scripts to test the mappings and Developed Traceability Matrix of Business Requirements mapped to Test Scripts to ensure any Change Control in requirements leads to test case update.
• Involved in extensive DATA validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.
• Assisted in defining business requirements for the IT team and created BRD and functional specifications documents along with mapping documents to assist the developers in their coding.
• Good knowledge in Identify & record defects with required information for issue to be reproduced by development team.
• Experienced in Designed and developed database models for the operational data store, Data Warehouse, and federated databases to support client enterprise Information Management Strategy.

Environment: - MS SQL Server 2008 client & SERVER, MS office, Legacy - Mainframes, Titanium, Rational Clear Quest, Clear Case.

Confidential, Chicago, IL

Data Analyst/Data Modeler

Responsibilities:

• Experienced in 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.
• Created DML code and statements for underlying & impacting databases.
• Performed data reconciliation between integrated systems.
• Extensively used MS Access to pull the data from various data bases and integrate the data.
• Performed data analysis and data profiling using complex SQL on various sources systems including Oracle and Teradata.
• Responsible for different Data mapping activities from Source systems to Teradata
• Assisted in the oversight for compliance to the Enterprise Data Standards
• Worked in importing and cleansing of data from various sources like Teradata, Oracle, flat files, SQL Server 2005 with high volume data
• Worked with Excel Pivot tables.
• Created and Monitored workflows using workflow designer and workflow monitor.
• Good experienced in Performing data management projects and fulfilling ad-hoc requests according to user specifications by utilizing data management software programs and tools like Perl, Toad, MS Access, Excel and SQL
• Worked withDataSteward Team for designing, documenting and configuring Informatica Data Director for supporting management of MDMdata.
• Wrote SQL scripts to test the mappings and Developed Traceability Matrix of Business Requirements mapped to Test Scripts to ensure any Change Control in requirements leads to test case update.

Environment: Quality Center 9.2, MS Excel 2007, PL/SQL, Business Objects XIR2, ETL Tools Informatica 8.6, Oracle 10G, Teradata V2R12, Teradata SQL Assistant 12.0

Confidential, Denver, CO

Sr. Data Analyst/Data Modeler

Responsibilities:

• Worked on discovering entities, attributes, relationships and business rules from functional requirements
• Used Erwin, created Conceptual, Logical and Physical data models.
• Performed Data Analysis and Data Profiling and worked on data transformations and data quality rules.
• Designed both 3NF data models for ODS, OLTP systems and dimensional data models using star and snowflake Schemas
• Conducted design walk through sessions with Business Intelligence team to ensure that reporting requirements are met for the business.
• Tuned and optimization of Teradata Queries Created the ETL data mapping documents between source systems and the target data warehouse.
• Facilitated project kickoff session with Business and SMEs to understand the requirements which also involved Project Manager, Development Lead, Data Modeler, Data Mapper, Architect etc.
• Designed the ER diagrams, logical model (relationship, cardinality, attributes, and, candidate keys) and physical database (capacity planning, object creation and aggregation strategies) as per business requirements.
• Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Worked on building up a SQL query for extraction of data from the warehouse for a reporting schedule
• Designed Star and Snowflake Data Models for Enterprise Data Warehouse using ERWIN
• 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.
• Completed ad hocdataanalysis requests in a timely and efficient manner.
• Executed data mapping and transformation and worked on data integrations.
• Worked on data analysis in Microsoft Excel and Access.

Environment: CA Erwin7.3, Oracle 8i, SQL server, IBM DB2, Informatica Power Center, Oracle BI, Visual Studio, ETL

Confidential

Data Analyst/Data Modeler

Responsibilities:

• Experienced in Gathering Business requirements by organizing and managing meetings with business stake holders, Application architects, Technical architects and IT analysts on a scheduled basis.
• Responsible for the analysis of business requirements and design implementation of the business solution.
• Experienced in developing Entity-Relationship diagrams and modeling Transactional Databases and Data Warehouse using tools like ERWIN, ER/Studio and Power Designer.
• Experienced in Using ERWIN r7.3 for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Identified Facts and Dimensions from the business requirements and developed the logical and physical models using ERWIN
• Highly generated comprehensive analytical reports by running SQL queries against current databases to conductdataanalysis.
• Experienced in Using Teradata Fast Export utility to export large volumes ofdatafrom Teradata tables and views for processing and reporting needs.
• Experienced in Handled performance requirements for databases in OLTP and OLAP models.
• Involved inData mapping activities for theData Warehouse.
• Developed complex Stored Procedures for SSRS (SQL Server Reporting Services).
• Experienced in Created database objects like tables, indexes, synonyms, views, materialized views etc.
• Documented ER Diagrams, Logical and Physical models, business process diagrams and process flowdiagrams.
• Created complex SQL server 2008 and Oracle stored procedures and triggers in support of the applications with Error handling.

Environment: Informatica Power Center, TeradataV6, Oracle 9i, Microsoft SQL Server 2008, SVN tool, Sybase Power Designer 16.1, BTEQs, MLoads, Fast Load, UNIX scripting, PLSQL Programming, Erwin .