SUMMARY:

• Above 9+ years of experience in Data Analysis, Data Modeling, System Analysis, Data Architecture and Development, Testing and Deployment of business applications.
• Expertise in reviewing business requirements and technical design documents to develop effective database design solutions.
• Develop architecture plan to improve the quality of thedataand integrate diverse sourcedatato achieve business objectives.
• Complete knowledge ofDataWarehouse Methodologies Ralph Kimball & Bill Inmon Methodologies.
• Experience in building ODS, EDW, Staging and maintaining metadata repository.
• Strong experience with architecting highly performs databases using PostgreSQL, PostGIS, MYSQL and Cassandra.
• Experience in designing star schema, Snowflake schema forDataWarehouse, ODS architecture.
• Specialization inDataModeling,Datawarehouse design, Building conceptualArchitect,Data Integration and Business Intelligence Solution.
• Experience in designing EnterpriseDataWarehouses,DataMarts, Reportingdatastores (RDS) and Operationaldatastores (ODS).
• Strong understanding ofDataWarehousing andDataModeling concepts.
• Extensive experience with variousdataprocessing platforms and languages including Apache Spark(Scala), Apache Drill, Python, Oracle PL/SQL, and PostgreSQL PL/pgSQL.
• Experienced in developing Conceptual, Logical and Physical models using ERWIN, Sybase Power designer and Embarcadero ER Studio.
• Experienced in various Teradata utilities like Fastload, Multiload, BTEQ and Teradata SQL Assistant
• Experience in conducting Joint Application Development (JAD) sessions with SMEs, Stakeholders and other project team members for requirements gathering and analysis.
• Experienced as aArchitectUML models and leverage the advanced executable code generators to target different domains.
• Experience in integration of various relational and non - relational sources such as DB2, Teradata, Oracle, Netezza, SQL Server, NoSQL database.
• Experience in Agile/Scrum, iterative and waterfall SDLC methodologies.
• Good experienced in Dimensional and RelationalDataModeling using Star and Snowflake Schemas, OLTP/OLAP system, Fact and Dimension tables, Conceptual, Logical and Physicaldatamodeling using Erwin.
• Experience in Hadoop ecosystem components like Hadoop MapReduce, HDFS, HBase, Oozie, Hive, Sqoop, Pig, Zookeeper, Flume including their installation and configuration.
• Hands on experience working and applying design considerations of 3rd Normal Form for OLTP Databases and Models.
• Experience working on Business Intelligence tool like Business Objects, SQL Server Reporting and Cognos.
• Strong experience in writing SQL and PL/SQL, Transact SQL programs for Stored Procedures, Triggers and Functions.
• Extensively worked on ERWIN tool with all features like REVERSE Engineering, FORWARD Engineering, SUBJECT AREA, DOMAIN, Naming Standards Document etc.
• Expert in developing effective working relationships with client team to understand support requirements, develop tactical and strategic plans to implement technology solutions, and effectively manage client expectations.

TECHNICAL SKILLS:

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

Databases: Oracle 12c/11g, Teradata R15/R14, MS SQL Server2014/2012, MS Access, Netezza

BI Tools: Tableau, Tableau server, Tableau Reader, SAP Business Objects

Operating System: Windows, Unix, Sun Solaris

ETL/Datawarehouse Tools: Informatica 9.6/9.1, SAP Business Objects XIR3.1/XIR2, Web Intelligence, Talend, Tableau, Pentaho

DataModeling Tools: Erwin9.6/9.5,ER Studio9.7, Star-Schema Modeling, Snowflake-Schema Modeling, FACT and dimension tables, Pivot TablesTools & Software: MS Office, BTEQ, Teradata SQL Assistant

Project Execution Methodologies: Ralph Kimball and Bill Inmondatawarehousing methodology, Rational Unified Process (RUP), Rapid Application Development (RAD), Joint Application Development (JAD)

Testing and defect tracking Tools: HP/Mercury (Quality Center, Win Runner, Quick Test Professional, Performance Center, Requisite, MS Visio & Visual Source Safe

PROFESSIONAL EXPERIENCE:

Confidential - Union, NJ

Sr. Data Architect/Data Modeler

• Responsible for enhancing and maintaining the AutoZone (AZ) information strategy.
• As aArchitectimplement MDM hub to provide clean, consistentdatafor a SOA implementation
• Implemented dimension model (logical and physicaldatamodeling) in the existing architecture using ER Studio.
• Responsible for Bigdatainitiatives and engagement including analysis, brainstorming, POC, and architecture.
• Involved in all the steps and scope of the project dataapproach to MDM, Creating aDataDictionary and Mapping from Sources to the Target in MDMDataModel.
• Perform ETL on data for maintaining data standards using Java and My-SQL.
• Serving as a technicaldatastrategy expert and leading the creation of technical requirements and design deliverables.
• Performing gap analysis between currentdatastructures and targetdatastructures.
• ImplementedDataGovernance in Hadoop clusters
• Perform administrative tasks, including creation of database objects such as database, tables, and views, using SQL DCL, DDL, and DML requests.
• Generated DDL statements for the creation of new ER/studio objects like table, views, indexes, packages and stored procedures.
• Generated the DDL using forward engineering Worked in merging and complete compare of Physical models.
• Involved in integration of various relational and non-relational sources such as Oracle, XML and Flat Files.
• Extensive experience in PL/SQL programming - Stored Procedures, Functions, Packages and Triggers
• Used BTEQ script to create a sample tables. Redefine the partitioning of a populated table.
• 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.
• Developeddatamodels for applications, metadata tables, views or related database structures
• Developing complex mappings to extractdatafrom diverse sources including flat files, RDBMS tables, legacy system files, XML files, Applications and Teradata.
• Performed testing on adatawarehouse platform, includingdataintegrity anddatavalidation.
• Working with otherarchitectsto help design overall solutions in accordance with industry best practices and AutoZone principals and standards.

Environment: ER Studio 9.7, Oracle12c, SSRS XML, PL/SQL, OLAP, OLTP, ODS, Teradata, Star Schema, MDM, Hadoop, Hive, Metadata, Excel, Access, Visio, Windows XP.

Confidential - Malvern, PA

Sr. Data Architect/Data Modeler

Responsibilities:

• Developed full life cycle software including defining requirements, prototyping, designing, coding, testing and maintaining software.
• Developed newdataarchitecture, including Transformation and Reporting Layers, missing in legacy system
• Interacted with Business Analyst, SMEs and otherDataArchitectsto understanding Business needs and functionality for various project solutions
• Architected and delivered various complex OLAP databases/cubes, scorecards, dashboards and reports.
• Defined the architecture and various phases for the implementation of the transactional anddata warehouse systems.
• Designed components for overalldataarchitecture - Metadata Management, Data,Data Staging, EnterpriseDataWarehouse, and OperationalDataStore.
• Worked onDataIngestion using Sqoop from Oracle to HDFS.
• Used Erwin and Normalization and De-normalization Techniques to design Logical and PhysicalData Models, relational database design.
• Worked with Hadoop eco system covering HDFS, HBase, YARN and Map Reduce
• Reverse-Engineered numerous existing database schemas to get an understanding of existing database architecture.
• Managed, designed, and created the Star Schema and Snowflake Schema for a financialdatamart using Erwin and DB2 using Ralph Kimball dimensional modeling techniques.
• Developed PL/SQL triggers on master tables for automatic creation of primary keys and foreign keys.
• Useddataprofiling automation to uncover the characteristics of thedataand the relationships betweendatasources before anydata-driven.
• Independently coded new programs and design Tables to load and test the program effectively for the given POC's using BigData/Hadoop.
• Extensively involved in analyzing variousdataformats using industry standard tools and effectively communicate them with business users and SME's.
• Involved in the validation of the OLAP Unit testing and System Testing of the OLAP Report Functionality anddatadisplayed in the reports.
• Created SQL scripts and analyzed thedatain MS Access/Excel and Worked on SQL and SAS script mapping.
• Designed the various phases for the development and rollout of the OLTP system.
• 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
• Created DDL for physical model using Erwin and handed over to the DBA team.

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

Confidential - Minneapolis, MN

Sr. Data Architect/Data Modeler

Responsibilities:

• Developed and implemented strategy for the extraction ofdatafrom the different sources and loading into appropriatedata-mart composition.
• Enhancement of enterprisedatamodels (Conceptual, Logical and Physical) for the OperationalData Store, ODS, OLTP and EnterpriseDataWarehouse using 3NF technique.
• Built Cloud architecture on Amazon AWS.
• Created cubes in SSAS based on the developed schemas and developed accompany MDXqueries(Multidimensional Expressions or OLAP databases).
• Involved in AWS Architecture design and modification, gap analysis
• Designed dimensionaldatamodels using Star and Snowflake Schemas.
• Responsible for Big data initiatives and engagement including analysis, brainstorming, POC, and architecture.
• Designed and Developed Oracle PL/SQL and Shell Scripts, Data Import/Export, Data Conversions and Data Cleansing.
• Using Erwin to customize report display and export reports to HTML.
• Advanced SQL programming skills; tune SQL queries to improve performance
• Involved in Teradata utilities (BTEQ, Fast Load, Fast Export, Multiload, and Tpump) in both Windows and Mainframe platforms.
• Using cursor logic to generate a sequence of dynamic SQL statements in Teradata.
• Responsible for reformat and migration of existing security and derivative database information into new SQL Server database.
• Developeddataextraction programs using Business ObjectsDataServices
• Created Logical and Physical models using Erwin tool for oracle and Teradata database designs.
• Responsible for creating OLAP cubes for deep through analysis using SSAS.
• Generated ad-hoc SQL queries using joins, database connections and transformation rules to fetch data from Teradata database.
• Worked with DBA to create Best-Fit PhysicalDataModel from the logicalDataModel using Forward Engineering in Erwin.

Environment: Erwin 9.0, Oracle10g, OLAP, OLTP, ODS, SSAS, Teradata, SSIS, SSRS XML, PL/SQL, MS Excel, Access, Visio, Windows XP, HTML.

Confidential - Richmond, VA

Sr. Data Modeler/ Data Analyst

Responsibilities:

• Involved with BusinessAnalyststeam in requirements gathering and in preparing functional specifications and changing them into technical specifications.
• Created dimensional model for reporting system by identifying required dimensions and facts using Erwin r8.0
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD (Object oriented Design) using UML and Visio.
• Datagovernance functional and practical implementation and also responsible for designing commonDatagovernance frameworks
• Good experience in Normalization and De-normalization techniques intended for the enhanced database performance in OLTP andDataWarehouses/DataMarts.
• Worked with DBA group to create Best-Fit PhysicalDataModel from the LogicalDataModel using Forward engineering using Erwin.
• Responsible for reformat and migration of existing security and derivative database information into new SQL Server database.
• Created and designeddataflow diagrams, developed logical and physical model and generated DDL using Erwin tool.
• Used DataStage as an ETL tool to extractdatafrom sources systems, loaded thedatainto the ORACLE database.
• Designed STAR schema for the detaileddatamarts and plandatamarts consisting of confirmed dimensions.
• Configured report server and report manager scheduling, give permissions to different level of users in SQL Server Reporting Services (SSRS)
• Used Normalization and De-Normalization techniques very much to reducedataredundancy.
• PerformedDatamapping between source systems to Target systems, logicaldatamodeling, created class diagrams and ER diagrams and used SQL queries to filterdata.
• Resolved issues by conducting and participating in JAD sessions with the Business users, development team and Infrastructure team.
• Closely worked with Business Architects and Solution Architects to created source to target mapping documents for the ETL developers and helped them understand complex transformations involving business input.

Environment: Erwin r8.0, SQL, SQL Server 2005, SSRS, OLTP, OLAP, OOD, MS Visio, Star schema, UML, Rational Rose, Windows XP, Oracle 8i, Windows XP/NT/2000.

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.
• Involved in designing and developing High level and Low level designs
• Developed ER and Dimensional Models using Erwin advanced features.
• Involved in extensiveDATAvalidation by writing several complex SQL queries and Involved in back-end testing and worked withdataquality issues.
• Worked with different types of Sources like DB Tables source, Flat File Source, Excel Source and Destinations like DB Tables.
• Designed the table in Normalized form for oracle 9i database.
• Analyzed requirements from end users and identified variousdatasources and created Technical Specification Documents.
• Documented the Stored procedure/Function specification and detail design specification for Oracle 9i database.
• Designeddatalayer schema using Star and SnowflakeDataModels for EnterpriseDataWarehouse using CA Erwin.
• Designed and developed ETL processes usingDataStage designer to loaddatafrom Teradata, Flat Files (Fixed Width) to staging database and from staging to the targetDataWarehouse database.
• Clarified the queries from the QA team (testing team) and helped them in understanding the business requirements.
• Stored procedure and functions are coded for the oracle package in PL/SQL Developer.
• Involved in M-LOAD, Fast-load and T-pump loading to migratedatafrom Oracle to Teradata.
• Extensively used MS Access to pull thedatafrom variousdatabases and integrate thedata.
• PerformedDataAnalysis/Profiling ondataSource using InformaticaDataQuality
• Generated DDL statements by Forward Engineering and run the SQL scripts.
• Testing responsibilities included unit testing, integration testing, and business acceptance testing.
• Extensively used the SET, UPDATE and MERGE statements for creating, updating and merging various SASdatasets for details on mortgage operations
• Working closely with theDataStewards to ensure correct and relateddatais captured in thedata warehouse as part ofDataQuality check.
• Involved inDataModeling (Logical and Physical Design) of new tables using Erwin, and modeling of new attributes in existing tables design and implementation of ReportingDatamart.

Environment: Erwin 7, oracle 9i, Teradata, Star schema, Flat files, MS Excel, MS access, PL/SQL developer, InformaticaDataQuality, MS Visio