SUMMARY

• Around 10 years working experience as Data Architect/Data Modeling, Data Analysis, Data Development, Implementation and Maintenance of databases and software applications.
• Extensive experience in Online Applications, Solution Lead for Architecting Data Warehouse and Business Intelligence Applications.
• Experience in drafting and implementing data warehouse and data architecture principles and best practices.
• Experience in setting up connections to different Databases like Oracle, SQL Server, DB2, NoSQL databases, Teradata and NETEZZA according to users requirement.
• Experience in Hadoop ecosystem components like Hadoop MapReduce, HDFS, HBase, Oozie, Hive, Sqoop, Pig, Zookeeper, Flume including their installation and configuration.
• Strong experience with architecting highly performance databases using PostgreSQL, PostGIS, MYSQL and Cassandra
• Experience in SQL, PL/SQL package, function, stored procedure, triggers, and materialized view, to implement business logics of oracle database.
• Experience in importing and exporting data from different relational databases like MySQL6.x, Netezza, Oracle into HDFS and Hive using Sqoop.
• Experience in SAS interacts with third party software such as databases (DB2, SQL SERVER, ORACLE)
• Adept in statistical programming languages like R and also Python including Big Data technologies like Hadoop, Hive.
• Excellent knowledge of industry standard methodologies like Software Development Life Cycle (SDLC), Iterative Software Development Life Cycle Process, and Agile Scrum methodology.
• Expertise in Data Analysis, Data Migration, Data Profiling, Data Cleansing, Transformation, Integration, Data Import, and Data Export through the use of multiple ETL tools such as Informatica Power Center.
• Extensively experience on EXCEL PIVOT tables to run and analyze the result data set and perform UNIX scripting.
• Experience with SQL Server and T - SQL in constructing Temporary Tables, Table variables, Triggers, user functions, views, Stored Procedures.
• Used Tableau Desktop for blending databases and creating different interactive views and dashboards.
• Experience in designing star schema, Snowflake schema for Data Warehouse, ODS architecture by using tools like Erwin, Power Designer, Embarcadero ER Studio and Microsoft Visio.
• Good knowledge of Data warehouse concepts and principles like Kimball/Inman, Star Schema, Snowflake, SCD, Surrogate keys, Normalization/De-Normalization for relational and dimensional database environments.
• Strong hands on experience using Teradata utilities like BTEQ, Fast-Load, Multi-Load, Fast-Export, Tpump, Teradata Manager and Visual Explain.
• Lead data architecture design and review processes, including planning and monitoring efforts, reviewing deliverables and communicating to management
• Responsible for leading the architectural development of project/metadata and reporting framework.
• Experience in building data quality/data validation processes and actively worked with source systems and users to improve data quality.

TECHNICAL SKILLS

DataModeling Tools: Erwin 9.6/9.5 IBM InfosphereDataArchitect, ER Studio 9.7, Power Designer

Databases: Microsoft SQL Server 2016/2014, Teradata 15/14, Oracle 12c/11g, Netezza, DB2 and NoSQL databases, Amazon Redshift

BigData: Hadoop, HDFS 2, Hive, Pig, H Base, Sqoop, Flume.

Operating Systems: Windows 10/8/7, Linux, UNIX (Sun Solaris 10), MS DOS (CMD)

Languages: SQL, PL/SQL, SQL, T-SQL, SQL Server, C, C++, HTML, UNIX shell scripting

Big Data & NOSQL: Hadoop, YARN, SQOOP, Flume, Kafka, Splunk, Hive, Pig, Oozie, Storm, Cassandra, HBase, MapReduce, Impala

Project Execution Methodologies: Ralph Kimball & Bill Inmon data warehousing methodology, Rapid Application Development (RAD), Joint Application Development (JAD), Agile and Waterfall

Reporting Tools: Cognos 8/10, Oracle Reports, CRYSTAL, Tableau, Business Objects and IDQ.

PROFESSIONAL EXPERIENCE

Confidential, Union, NJ

Sr. Data Architect/ Data Modeler

Responsibilities:

• Worked as Data Architect to implement it in the data model.
• Conducted Integrated Data Warehouse (IDW) project business requirement sessions with business users to understand the requirements.
• Designed, created and maintained QlikView applications
• Assigned tasks among development team, monitored and tracked progress of project following Agile methodology.
• Established data architecture strategy, best practices, standards, and roadmaps
• Developing full life cycle software including defining requirements, prototyping, designing, coding, testing and maintaining software.
• Responsible for Big data initiatives and engagement including analysis, brainstorming, POC, and architecture.
• Designed both 3NF data models for ODS, OLTP systems and dimensional data models using Star and Snowflake Schemas.
• Used Erwin Data Modeler and Erwin Model Manager to create Conceptual, Logical and Physical data models and maintain the model versions in Model Manager for further enhancements.
• Worked with Hadoop eco system covering HDFS, HBase, YARN and Map Reduce.
• Used forward engineering to generate DDL from the Physical Data Model and handed it to the DBA.
• Performed the Data Mapping, Data design (Data Modeling) to integrate the data across the multiple databases in to EDW.
• Working on Amazon Redshift and AWS and architecting a solution to load data, create data models and run BI on it.
• Designed the Logical Data Model using ERWIN with the entities and attributes for each subject areas.
• Ensured high-quality data and understand how data is generated out experimental design and how these experiments can produce actionable, trustworthy conclusions.
• Responsible for technical data governance, enterprise wide data modeling and database design.
• Lead the development and implementation of the logical data model and physical data design utilizing data architecture and modeling standards.
• Handled importing data from various data sources, performed transformations using Hive, Map Reduce, and loaded data into HDFS
• Develop TSQL scripts to create database objects and perform DML and DDL tasks and wrote and executed unit, system, integration and UAT scripts in a data warehouse projects.
• Developed reports using SQL Server Reporting Services (SSRS) and involved in the validation of the OLAP Unit testing and System Testing of the OLAP Report Functionality and data displayed in the reports.
• Interaction with Business Analyst, SMEs and other Data Architects to understanding Business needs and functionality for various project solutions
• Populate or refresh Teradata tables using Fast load, Multi load & Fast export utilities for user Acceptance testing and loading history data into Teradata.

Environment: Erwin 9.6, Teradata 15, QlikView, Amazon Redshift, AWS, Hive, MS Excel, PL/SQL, SSRS, SSIS, Java, Informatica 9.5, Tableau, Teradata SQL Assistant 12.0, UNIX, Hadoop, Hive, HBase, Pig, SQL, T-SQL.

Confidential, Washington, DC

Sr. Data Architect/ Data Modeler

Responsibilities:

• Developed strategies for data acquisitions, archive recovery, and implementation of databases and working in a data warehouse environment, which includes data design, database architecture, and Metadata and repository creation.
• Designed and developed architecture for data services ecosystem spanning Relational, NoSQL, and Big Data technologies.
• Provide support in database architecture of the organization through database design, modeling and implementation and develop plans, strategies and standards for data within the enterprise
• Monitored and measured data architecture processes and standards to ensure value is being driven and delivered as expected.
• Worked with Data governance, Data quality, data lineage, Data architect to design various models and processes.
• Designed the new Teradata data warehouse with star schema & snow flake schema for most efficient use of Micro Strategy & Teradata resources.
• Work with the business analysts to build the business requirements documents.
• Perform data analysis which includes researching source data and communicating with the source SME.
• Connected to Amazon Redshift through Tableau to extract livedatafor real time analysis.
• Designed and Developed Oracle12c, PL/SQL Procedures and UNIX Shell Scripts forData Import/Export andDataConversions.
• Applied a dimensional model structure or relational model structure to achieve an appropriate solution for the requirements.
• Analyze business process, involved in requirement gathering, template creation, Design and create the conceptual, logical, and physical data models utilizing data Warehousing components
• Provide maintenance and support for SAS products during deployment, upgrade and any changes to SAS products and during other enterprise activities that impact SAS infrastructure.
• Used BTEQ and SQL Assistant (Query man) front-end tools to issue SQL commands matching the business requirements to Teradata RDBMS.
• Involved in the daily maintenance of the database that involved monitoring the daily run of the scripts as well as troubleshooting in the event of any errors in the entire process.
• Participated in data governance processes, author data transformation scripts, perform data cleansing actions, and execute data integration/consolidation processes
• Developing Database Architecture using design standards and tools.
• Designed and build relational database models and defines data requirements to meet the business requirements.
• Worked with DBA to create Best-Fit Physical Data Model from the logical Data Model using Forward Engineering in Erwin9.5.

Environment: Erwin 9.5, Teradata 15/14, Oracle 11g, Metadata, NoSQL, MS-Office, DBA, OLAP, SQL T- PL/SQL, Agile, NoSQL, MS-Office, QlikView, ODS, Hadoop, OLTP, ETL.

Confidential, Lincolnshire, IL

Sr. Data Architect/ Data Modeler

Responsibilities:

• Responsible for Big data initiatives and engagement including analysis, brainstorming, POC, and architecture.
• Handled importing data from various data sources, performed transformations using Hive, Map Reduce, and loaded data into HDFS.
• Developed long term data warehouse roadmap and architectures, designs and builds the data warehouse framework per the roadmap.
• Designing normalized and star schema data architectures using Erwin and forward engineering these structures into Teradata
• Translating high level business requirements into solution, infrastructure architectures, involved enterprise architects to align strategic view.
• Worked in generating and documenting Metadata while designing OLTP and OLAP systems environment.
• Perform reverse engineering of the dashboard requirements to model the required data marts.
• Designed and developed the conceptual then logical and finally physical data models to meet the needs of reporting
• Manages the flow of information between departments through the use of relational databases.
• Worked with other key roles such as Business Analysts, Data Architects, DBAs, ETL developers to achieve the set goal
• Performed problem assessment, resolution and documentation of the data mart models.
• Participate in code/design reviews and provide input into best practices for reports and universe development.
• Managed, designed, and created the Star Schema and Snowflake Schema for a financial data mart using Erwin and DB2 using Ralph Kimball dimensional modeling techniques.
• Handled importing data from various data sources, performed transformations using Hive, Map Reduce, and loaded data into HDFS.
• Performed Logical & Physical Data Modeling and delivering Normalized, De-Normalized & Dimensional schemas
• Interaction with Business Analyst, SMEs and other Data Architects to understanding Business needs and functionality for various project solutions
• Involved in translating business needs into long-term architecture solutions and reviewing object models, data models and metadata.
• Handled importing of data from various data sources, performed transformations using Hive, Map Reduce, loaded data into HDFS and Extracted the data from My SQL into HDFS using Sqoop

Environment: Erwin 9.0, Teradata 13, Oracle 10/11g, Metadata, NoSQL, MS-Office, DBA, OLAP, SQL T- PL/SQL, Agile, NoSQL, MS-Office, QlikView, ODS, Hadoop, OLTP, ETL.

Confidential, Atlanta, GA

Sr. Data Analyst/Modeler

Responsibilities:

• Created logicaldatamodel from the conceptual model and it's conversion into the physical database design using Erwin 8.
• Interacted with users for verifying User Requirements, managing Change Control Process, updating existing Documentation.
• Developed dimensional model forDataWarehouse/OLAP applications by identifying required facts and dimensions.
• Worked with Architecture team to get the metadata approved for the newdataelements that are added for this project.
• DevelopedDataMigration and Cleansing rules for the Integration Architecture (OLTP, ODS, DW)
• Designed a Star schema for the detaileddatamarts and Plandatamarts involving shared dimensions (Conformed)
• Generated DDL (DataDefinition Language) scripts using Erwin 8 and supported the DBA in Physical Implementation ofdataModels.
• Performed data analysis and data profiling using SQL queries on various sources systems including Oracle and SQL Server 2008
• 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.
• Dataanalysis of existingdatato understand the current patient'sdataand business rules was applied to Differentdatabases by SQL.
• Experience in Data Extraction/Transformation/Loading (ETL), Data Conversion and Data Migration by using SQL Server 2008 Integration Services (SSIS) and PL/SQL Scripts.
• Facilitated meetings with the business and technical team to gather necessary analyticaldata requirements.
• Worked on Oracle PL/SQL and Shell Scripts, Packages, Scheduling,DataImport/Export,Data Conversions andDataCleansing
• Development of database objects like Tables, views and materialized views etc using SQL.
• Assisted in designing test plans, test scenarios and test cases for integration, regression and user acceptance testing.

Environment: Erwin 8.0, OLAP, OLTP, SSIS, ODS, PL/SQL, Metadata, SQL Server 2008, Star Schema, Oracle 9i

Confidential, Chicago, IL

Sr. Data modeler/Data Analyst

Responsibilities:

• Involved in analysis of Business requirement, Design and Development of High level and Low level designs, Unit and Integration testing
• Gathered and transferred business and functional requirements for enhancement of the system documentation.
• Performeddataanalysis and data profiling using complex SQL on various sources systems including Oracle and SQL Server..
• Interacted with business users to clarify on business logic required for thedatamodels.
• Monitored and improved Identifieddataquality through the use of internaldatatools.
• Used reverse engineering for a wide variety of relational DBMS, including MS Access, Oracle and Teradata to connect to existing database and create graphical representation using Erwin.
• Tuning all database via indexing of tables, MS SQL Server 2005 configuration parameters and stored procedures SQL code optimization.
• Worked with Clients to gather and document business requirements, conduct extensivedata exploration, author technical specifications and coordinate the release and acceptance testing of new development.
• Designed the Data Marts using Ralf Kimball's Dimension data mart modeling methodologies.
• Designeddatamodel, analyzeddatafor online transactional processing (OLTP) and Online Analytical Processing (OLAP) systems
• Used Sybase Power Designer in designing thedatamodel.
• Cleansed, extracted and analyzed businessdataon daily basis and prepared ad-hoc analytical reports using Excel and T-SQL
• Optimized and update logical and physicaldatamodels to support new and existing design requirement.
• Worked with SQL Server Reporting (SSRS) team to come up with reporting requirements.
• Analyzed OLTP source systems and OperationalDataStore and research the tables/entities required for the project.
• Developed PL/SQL packages, stored procedures, functions, alerts for ensuring the warehousedata integrity checks and shell scripts to balance thedatabetween source and target tables after each ETL process
• UsedDataVault technique and achieved many advantages ofDataVault approach some of them are simplified thedataingestion process
• Removed the cleansing requirement of a star schema and easily allowed for the addition of newdatasources without disruption to existing schema
• Handled performance requirements for databases in OLTP and OLAP models.
• Conducted meetings with business and development teams fordatavalidation and end-to-enddata mapping.

Environment: Sybase Power Designer, PL/SQL, SQL Server 2005, Oracle 8i/9i, OBIEE, OLAP, OLTP, Crystal Reports, ODS,, XML, Visio, ClearQuest, MS Excel.