SUMMARY

• Above 9+ years of IT experience as Sr. Data Architect/Data Modeler and Data Analyst in design, development, testing and maintenance ofdata warehouse, business intelligence and operationaldatasystems.
• Architectand design conceptual, logical and physical models and builddatamarts using hybrid Inmon and Kimball DW methodologies
• Excellent understanding of an Approach to MDM to creating adatadictionary, Using Informatica or other tools to do mapping from sources to the Target MDMDataModel.
• Experience in conducting Joint Application Development (JAD) sessions with SMEs, Stakeholders and other project team members for requirement gathering and analysis.
• Experience in importing and exportingdatausing Sqoop from HDFS to Relational Database Systems (RDBMS) and from RDBMS to HDFS.
• Experience as a dedicatedData Warehouse Architect, with expertise inDesigning and Developing Data Model.
• Extensive experience in shell scripting Python, Perl, Ruby, or any other scripting language.
• Knowledge and working experience on big data tools like Hadoop, Azure Data lake,AWSRedshift.
• Strong experience with architecting highly performant databases using PostgreSQL, PostGIS, MYSQL and Cassandra.
• Specialization in Data Modeling, Data warehouse design, Building conceptual Architect, Data Integration and Business Intelligence Solution.
• Experience in working with business intelligence anddatawarehouse software, including SSAS, Pentaho, Cognos, OBIEE, QlikView, Greenplum Database, Amazon Redshift, or AzureData Warehouse
• Experienced in Hadoop Ecosystem development using MapReduce, HDFS, Hive, Pig, HBase, Sqoop, Flume, Spark, and Oozie.
• Hands on experience with variousDataArchitectand ETLArchitect, subsystem and patterns, including Change Date Capture, Slow Change Dimension,DataCleansing, auditing and validation, etc.
• Experience in developing Map Reduce Programs using Apache Hadoop for analyzing the Big data as per the requirement.
• Experience in various Teradata utilities like Fastload, Multiload, BTEQ, and Teradata SQL Assistant.
• Experience in integration of various relational and non - relational sources such as DB2, Teradata, Oracle, Netezza, SQL Server, NoSQL, and Netezza database
• Good experienced in Dimensional and RelationalDataModeling using Star and Snowflake Schemas, OLTP/OLAP system, Fact and Dimension tables, Conceptual, Logical and Physicaldata Modeling using Erwin.
• Experienced in SQL, PL/SQL package, function, stored procedure, triggers, and materialized view, to implement business logics of oracle database.
• Good knowledge of Data Marts, Operational Data Store (ODS), Dimensional Data Modeling.
• Strong background in variousDataModeling tools using ERWIN, ER/Studio and Power Designer.
• Extensively used ERWIN for REVERSE Engineering, FORWARD Engineering, SUBJECT AREA, DOMAIN, Naming Standards Document etc.
• Excellent understanding and working experience of industry standard methodologies like System Development Life Cycle (SDLC), as per Rational Unified Process (RUP), AGILE and Waterfall Methodologies.
• Expertise in SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS).
• Expertise in Normalization/De-normalization techniques for optimum performance in relational and dimensional database environments.

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 etc.

Web technologies: HTML, DHTML, XML, JavaScript

Reporting Tools: Business Objects, Crystal Reports

Operating Systems: Microsoft Windows 7/8/XP / Vista, Linux and UNIX

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

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

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, Omaha, NB

Sr. Data Architect/ Data Modeler

Responsibilities:

• Worked 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.
• 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.
• 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 MasterDataManagement (MDM), Business Intelligence (BI) andDataWarehousing 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, Malvern, PA

Sr. Data Architect/ Data Modeler

Responsibilities:

• Developing full life cycle software including defining requirements, prototyping, designing, coding, testing and maintaining software.
• Independently coded new programs and design Tables to load and test the program effectively for the given POC's using BigData/Hadoop.
• Enforced referential integrity in the OLTPdatamodel for consistent relationship between tables and efficient database design.
• Familiar and with advanced Amazon Redshift and MPP database concepts
• As aArchitectimplement MDM hub to provide clean, consistentdatafor a SOA implementation
• Establishand develop new database maintenance scripts -Automate Netezza database management and monitoring
• Utilized Informatica toolset (Informatica Data Explorer, and Informatica Data Quality) to analyze legacy data for data profiling
• Performed database health checks and tuned the databases using Teradata Manager.
• Experience using MapReduce, and "Big data" work on Hadoop and other NOSQL platforms.
• Developed, managed and validated existingdatamodels including logical and physical models of thedatawarehouse and source systems utilizing a 3NF model.
• Used Star Schema and Snowflake Schema methodologies in building and designing the LogicalDataModel into Dimensional Models.
• Implemented logical and physical relational database and maintained Database Objects in thedatamodel using Erwin 9.5.
• Full life cycle ofDataLake,DataWarehouse with Bigdatatechnologies like Spark, Hadoop.
• Involved in debugging and Tuning the PL/SQL code, tuning queries, optimization for the Oracle, and DB2 database.
• Worked on Business Intelligence solution using Redshift DB, and Tableau.
• DevelopedDataMapping,DataGovernance, and transformation and cleansing rules involving OLTP, ODS.
• Designed and deployed scalable, highly available, and fault tolerant systems on AWS.
• Developed various QlikViewDataModels by extracting and using thedatafrom various sources files, DB2, Excel, Flat Files and Bigdata.
• Involved in developing Database Design Document including Data Model Conceptual, Logical and Physical Models using Erwin 9.5.
• Responsible fordatamodeling and managing thedatawarehouse environments which include mentoring junior DBAs.
• Developed and implemented strategy for the extraction ofdatafrom the different sources and loading into appropriatedata-mart composition.

Environment: ERWIN r9.5, Oracle 11g, DB2, Flat files, QlikView, Star Schema, Snowflake Schema, T-SQL, MYSQL, Hadoop, Hive, Map Reduce, MDM, PL/SQL, OLAP, OLTP, DB2, ODS

Confidential, Seattle, WA

Sr. Data Architect/ Data Modeler

Responsibilities:

• Interaction with Business Analyst, SMEs and otherDataArchitectsto understanding Business needs and functionality for various project solutions
• Translating high level business requirements into solution, infrastructure architectures, involved enterprisearchitectsto align strategic view.
• Defined the architecture and various phases for the implementation of the transactional anddata warehouse systems.
• Full life cycle ofDataLake,DataWarehouse with Bigdatatechnologies like Spark, Hadoop.
• Architected and delivered various complex OLAP databases/cubes, scorecards, dashboards and reports.
• Assigned tasks among development team, monitored and tracked progress of project following Agile methodology.
• Worked with BTEQ to submit SQL statements, import and exportdata, and generate reports in Teradata.
• Worked in generating and documenting Metadata while designing OLTP and OLAP systems environment.
• Involved in relational and dimensionalDataModeling for creating Logical and Physical design of the database and ER diagrams usingdatamodeling like Erwin.
• Worked with Data governance, Data quality, data lineage, Data architect to design various models and processes.
• Performance Tuning (Database Tuning, SQL Tuning, Application/ETL Tuning).
• Performeddataanalysis and data profiling using complex SQL on various sources systems including Oracle and DB2.
• Created a Logical Design and Physical Design in Erwin and used Erwin for developingDataModel using Star Schema methodologies.
• Controlled data cube development based on requirement prioritization and consolidation.
• Conducted Learning sessions for business users, analysts, QA team to provide insight intodata model and providing documentations.

Environment: Erwin 9.x, DB2, Hadoop, Spark, Star Schema, Snowflake Schema, ETL, ODS, Agile, PL/SQL, Erwin, OLTP, Oracle 10g/11g, SQL server, BTEQ,, MS Access, Excel.

Confidential - New York, NY

Sr. Data Modeler/ Data Analyst

Responsibilities:

• Worked as aDataModeler/Analystto generateDataModels using Erwin and developed relational database system.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD (Object oriented Design) using UML and Visio.
• Created DDL scripts using ER Studio and source to target mappings to bring thedatafrom source to the warehouse.
• Developed dimensional model for Data Warehouse/OLAP applications by identifying required facts and dimensions.
• Worked with Architecture team to get the metadata approved for the new data elements that are added for this project.
• Designed a STAR schema for the detailed data marts and Plan data marts involving shared dimensions (Conformed)
• Generated DDL (Data Definition Language) scripts using Erwin and supported the DBA in Physical Implementation of data Models.
• 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.
• Experience in Data Extraction/Transformation/Loading (ETL), Data Conversion and Data Migration by using SQL Server 2008 Integration Services (SSIS) and PL/SQL Scripts.
• Worked on Oracle PL/SQL and Shell Scripts, Packages, Scheduling, Data Import/Export, Data Conversions and Data Cleansing
• Development of database objects like Tables, views and materialized views etc using SQL.
• Involved in analysis of Business requirement, Design and Development of High level and Low level designs, Unit and Integration testing
• Datagovernance functional and practical implementation and also responsible for designing commonDatagovernance frameworks
• CreatedDataflow diagrams for current system. Developed adatatopology based on thedata storage, various replications, and movements ofdata.
• Created and maintained thedatadictionaries, maintained some parameters to provide faster query performance-using SQL.
• PerformedDataAnalysis anddataprofiling using complex SQL on various sources systems including Oracle 10g/11g and Teradata.

Environment: ER/ Studio, SSIS, SSRS, Teradata, PL SQL, Oracle 9i, SQL Server 2008, OLAP, OLTP, Star Schema, Snowflake Schema, ODS.

Confidential

Sr. Data Modeler/ Data Analyst

Responsibilities:

• Gathered Business requirements by organizing and managing meetings with business stake holders, Application architects, Technical architects and ITanalystson a scheduled basis.
• Communicated with users and business analysts to gather requirements. Involved in business process modeling using UML through Rational Rose.
• Reverse Engineered the Data Models and identified the Data Elements in the source systems and adding new Data Elements to the existing data models.
• Worked on data profiling and data validation to ensure the accuracy of the data between the warehouse and source systems.
• Executed the UNIX shell scripts that invoked SQL loader to load data into tables.
• Participated in several JAD (Joint Application Design/Development) sessions to track end to end flow of attributes starting from source screens to all the downstream systems.
• Involved in Data Profiling, Data Cleansing and make sure the data is accurate and analyzed when it is transferring from OLTP to Data Marts and Data Warehouse.
• Involved in data extraction, validation, analysis of the data and the store in data marts.
• Involved in Performance tuning by leveraging oracle explain utility and SQL tuning.
• Created PL/SQL packages and Database Triggers and developed user procedures and prepared user manuals for the new programs.
• Extensively working onDataModeling tools ErwinDataModelerto design thedatamodels.
• Consolidated existing SSRS reports to Micro Strategy reports without losing the functionality.
• Worked with DBA group to create Best-Fit PhysicalDataModel from the LogicalDataModel using Forward engineering using Erwin tool.
• Responsible for Metadata Management, keeping up to date centralized metadata repositories using Erwin modeling tools
• Documented logical, physical, relational and dimensionaldatamodels. Designed theDataMarts in dimensionaldatamodeling using star and snowflake schemas.
• Worked withDataArchitects andDataModelersextensively sharing knowledge and ideas in designingDataModels.
• Worked between the application team and thedatateam in order to gather the business requirements and build the database objects accordingly

Environment: Erwin 7.0, Metadata, SSRS, OLAP, OLTP, Oracle 9i/8i,, Oracle SQL Developer, PL/SQL, Business Objects, MS office suite.