SUMMARY

• Over 11+ years of total IT experience and expertise in data modeling for data warehouse/data mart development, Data Architecture, Data Analysis and business Intelligence (BI) applications.
• Experience in developing Map Reduce Programs using Apache Hadoop for analyzing the Big data as per the requirement.
• Extensive experience with various data processing platforms and languages including Apache Spark(Scala), Apache Drill, Python, Oracle PL/SQL, and PostgreSQL PL/pgSQL.
• Experience in data analysis using Hive, Pig Latin, Impala.
• Extensive experience in shell scripting Python, Perl, Ruby, or any other scripting language
• Strong experience with architecting highly performant databases using PostgreSQL, PostGIS, MYSQL and Cassandra.
• Well versed in Normalization / De - normalization techniques for optimum performance in relational and dimensional database environments.
• Experience in importing and exporting data using Sqoop from HDFS to Relational Database Systems (RDBMS) and from RDBMS to HDFS.
• Good experience in machine learning algorithms for Kaggle data sets
• Experience with JAD sessions for requirements gathering, creating Data Mapping, documents, writing functional specifications, queries.
• Experience in working with Business Intelligence and Enterprise Data Warehouse(EDW)
• Experience in various Teradata utilities like Fastload, Multiload, BTEQ, and Teradata SQL Assistant.
• Good experienced in Dimensional and Relational Data Modeling using Star and Snowflake Schemas, Fact and Dimension tables, Conceptual, Logical and Physical data modeling using Erwin.
• Efficient in enterprisedatawarehouses using Kimballdatawarehouse and Inmon's methodologies.
• Experience working withdatamodeling tools like Erwin, Power Designer and ER Studio.
• Expertise in Normalization (1NF, 2NF, 3NF and BCNF)/Denormalization techniques for effective and optimum performance in OLTP and OLAP
• Experience in Database Creation and maintenance of physical data models with Oracle, Teradata, Netezza, DB2 and SQL Server databases.
• Excellent experience in writing and executing unit, system, integration and UAT scripts in a data warehouse projects.
• Expertise in SQL Server Analysis Services (SSAS) and SQL Server Reporting
• Excellent experience working on Netezza/Teradata and writing heavy SQL queries and expertise in various Teradata utilities like Fastload, Multiload, BTEQ and TeradataSQLAssistant.
• Experienced in working on both Agile methodology and Waterfall methodology.
• Experienced in generating and documenting Metadata while designing OLTP and OLAP systems environment.
• Experienced in Extract Transform and Load (ETL) data from spreadsheets, database tables and other sources using Informatica and well-versed in writing SQL queries to perform end-to-end ETL validations and support Ad-hoc business requests.
• Strong understanding of principles of data warehousing, fact tables, dimension tables, Slowly Changing Dimensions (SCD) Type I and Type II.

TECHNICAL SKILLS

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

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

Languages: Unix Shell Scripting, HTML, T-SQL, Data Structure, Algorithms.

OLAP Tools: Tableau, SAP BO, SSAS, Business Objects

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

Operating System: Windows, Dos, Unix

Reporting Tools: Business Objects, Crystal Reports8/9.0

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

Big Data: Hadoop, YARN, SQOOP, Flume, Kafka, Splunk, Hive, Pig, Oozie, Storm, Cassandra, HBase, MapReduce, Impala, AWS AWS, EC2, S3.

Other tools: SQL PLUS, SQL LOADER, MS Project, MS Visio, UNIX, PL/SQL etc

PROFESSIONAL EXPERIENCE

Confidential - Chicago, IL

Sr. Data Architect/ Data Modeler

Responsibilities:

• Developed full life cycle software including defining requirements, prototyping, designing, coding, testing and maintaining software.
• Define strategy for new data platform, focused on its architecture and a strong business case for leveraging big data technologies for more sophisticated consumer analytics.
• Worked closely with the business and IT partners to deliver the data systems to meet their needs and understand the future direction of business.
• Loaded and transformed large sets of structured, semi structured and unstructured data using Hadoop/Big Data concepts.
• Extracting Mega Data from Amazon Redshift, AWS, and Elastic Search engine using SQL Queries to create reports.
• Used Model Manager Option in ER Studio to synchronize the data models in Model Mart approach.
• Normalized the database up to 3NF to put them into the star schema of the data warehouse.
• Worked on MasterdataManagement (MDM) Hub and interacted with multiple stakeholders.
• Worked on NoSQL databases including HBase, Mongo DB, and Cassandra. Implemented multi-data center and multi-rack Cassandra cluster.
• Installation and Configuration of other Open Source Software like Pig, Hive, HBase, Flume and Sqoop.
• Collaboratively worked with the Data modeling architects and other data modelers in the team to design the Enterprise Level Standard Data model.
• Designed both 3NF data models for ODS, OLTP systems and dimensional data models using star and snow flake Schemas.
• Worked closely with the development and database administrators to guide the development of the physical data model and database design.
• Developed various QlikViewDataModels by extracting and using thedatafrom various sources files, Excel, and Bigdata, Flat Files.
• Designed and Developed SQl PL/SQL and Shell Scripts, Data Import/Export, Data Conversions and Data Cleansing.
• Implemented Dimensional Modeling Identified Facts and Dimensions, Physical and logical data modeling using ER Studio.
• Lead technical design for new products, focusing on data assets, data flow, and data analytics
• Forward Engineering the Data Models, Reverse Engineering on the existing Data Models and updates the data models.
• Handled importing data from various data sources, performed transformations using Hive, Map Reduce, and loaded data into HDFS.
• Worked on Data governance, data quality, data lineage establishment processes.
• 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.
• Directing and overseeing data quality tests, including providing input to quality assurance team members.
• Recommending solutions regarding data systems, storage and lifecycle management.
• Worked with DBAs and the security coordinators to get access to the team members.

Environment: ER Studio 9.7, NoSQL, T-SQL, QlikView, MS Excel, Flat Files, Hadoop, Hive, Map Reduce, MDM, PL/SQL, OLAP, OLTP, DB2, ODS

Confidential - Newport Beach, CA

Sr. Data Architect/ Data Modeler

Responsibilities:

• Researched, evaluated,architect, and deployed new tools, frameworks, and patterns to build sustainable BigDataplatforms for the clients.
• As a Architect implement MDM hub to provide clean, consistent data for a SOA implementation
• Responsible for Big data initiatives and engagement including analysis, brainstorming, POC, and architecture.
• Involved in the validation of the OLAP Unit testing and System Testing of the OLAP Report Functionality and data displayed in the reports.
• Worked on Business Intelligence solution using Redshift DB, and Tableau.
• Involved inDataprofiling anddataanalysis to understand the business process and implement the functionality in EDW through dimensional modeling.
• Built Logical and Physicaldatamodels andDataDimensional Modeling using ERWIN
• Responsible for technicalDatagovernance, enterprise wideDatamodeling and Database design.
• Designed and implemented complex highly scalable statistical models and solutions that comply with security requirements.
• Manage technical documentation and artifacts providing architecture, logical and physical data models, technical standards and project support
• Worked on building the Logical data model from the scratch from the XML as the data source.
• DevelopedDataMapping,DataGovernance, Transformation and cleansing rules for the MasterData Management Architecture involving OLTP, ODS
• Worked on building the data models to convert the data from one data Application to another in a way that suit the needs of the target database.
• Redefined many attributes and relationships in the reverse engineered model and cleansed unwanted tables/columns.
• Produced 3NF data models for OLTP designs using data modeling best practices and modeling skills.
• Designed data models for mission critical and high volume data management, real-time and distributed data process aligning with the business requirements.
• Created data models for different databases like Oracle, Teradata.
• Enforced Referential integrity in the OLTP data model for consistent relationship between tables and efficient database design.
• Involved in the creation, maintenance of Data Warehouse and repositories containing Metadata.
• Created Source to Target Mapping Documents to help guide the data model design from the Data source to the data model.

Environment: Erwin r9.6, Oracle 12c, Teradata 15, MDM, Pig, HBase, Sqoop, ODS, SQL Assistant, MS Visio, Spark, AWS Redshift, Agile, Windows 8, Tableau 9.3, ETL, PL/SQL, Metadata, SSAS, OLAP, OLTP

Confidential - West Chester, PA

Sr. Data Analyst/Data Modeler

Responsibilities:

• Documented logical, physical, relational and dimensionaldatamodels. Designed theDataMarts in dimensionaldatamodeling using star and snowflake schemas.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD (Object oriented Design) using UML and Visio
• Preparation ofdatadictionary / business glossaries and also integratingDatadictionary intodata models.
• Dataanalysis of existingdatabase to understand thedataflow and business rule applied to Differentdatabases by SQL
• Used ERWINDataModelerfor Generating DDL, Stored Procedure and Trigger Code for Source to Target database.
• Worked extensively onDataMigration by using SSIS.
• DataProfiling of source using Oracle and Hue(Hadoop/Hive UI) and supporting developers by testing the target on Teradata and Hadoop
• Involved in the mapping ofdatasources and analytics, with the goal of ensuringdataquality.
• Designed the Logical Model into Dimensional Model using Star Schema and Snowflake Schema.
• Enforced referential integrity in the OLTP data model for consistent relationship between tables and efficient database design.
• Extracted data from the databases using Informatica to load it into a single data warehouse repository.
• Analyzed thedatawhich is using the maximum number of resources and made changes in the back-end code using PL/SQL stored procedures and triggers
• Developed SQL Queries to fetch complexdatafrom different tables in remote databases using joins, database links and bulk collects.
• Worked on multiple Data Marts in Enterprise Data Warehouse Project (EDW) involved in designing OLAP data models extensively used slowly changing dimensions(SCD).
• Datagovernance functional and practical implementation and also responsible for designing commonDatagovernance frameworks
• Worked closely with Business, DBA team, ETL and Reporting teams to definedatarequirements.

Environment: Erwin 9.0, Teradata13/14, MS SQL Server 2008,Hadoop, Hive, OOD, PL/SQL, OLAP, OLTP, SSIS, Oracle 10g, Star Schema, Informatica, MS Office, MS Visio.

Confidential - Malvern, PA

Sr. Data Analyst/Data Modeler

Responsibilities:

• Created logicaldatamodel from the conceptual model and it's conversion into the physical database design using ERWIN.
• 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 STAR schema for the detaileddatamarts and Plandatamarts involving shared dimensions (Conformed)
• Generated DDL (DataDefinition Language) scripts using Erwin 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 reverse engineering to connect to existing database and create graphical representation (E-R diagram) 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.
• Worked on 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.
• Documented the source to target mappings for both data integration as well as web services Utilized Erwin's forward/reverse engineering tools and target database schema conversion process.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and Bulk collects.
• Assisted in designing test plans, test scenarios and test cases for integration, regression and user acceptance testing.

Environment: Erwin 9.0, OLAP, OLTP, SSIS, ODS, PL/SQL, Metadata, SQL Server 2008, Star Schema, Oracle 10g

Confidential

Data Analyst/Data Modeler

Responsibilities:

• AnalyzedDatasources and requirements and business rules to perform logical and physicalData Modeling
• Created a logical design and physical design in ER/Studio.
• Communicated with users and businessanalyststo gather requirements. Involved in business process modeling using UML through Rational Rose.
• Reverse Engineered theDataModels and identified theDataElements in the source systems and adding newDataElements to the existingdatamodels.
• Worked ondataprofiling anddatavalidation to ensure the accuracy of thedatabetween the warehouse and source systems.
• Creatingdatatrace map anddataquality mapping documents, PerformingDataProfiling andData Quality.
• Executed the UNIX shell scripts that invoked SQL loader to loaddatainto tables.
• Developed Star Schema and Snowflake Schema in designing the Logical Model into Dimensional Model.
• Involved in Data modeling and design of Data Mart's using ER Studio
• Extensively used ER Studio for developingdatamodel using star schema methodologies.
• 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 inDataProfiling,DataCleansing and make sure thedatais accurate and analyzed when it is transferring from OLTP toDataMarts andDataWarehouse.
• Involved indataextraction, validation, analysis of thedataand the store indatamarts.
• PerformedDataAnalysis anddataprofiling using complex SQL on various sources systems including Oracle 9i/8i and Teradata, to ensure accuracy of thedatabetween the warehouse and source systems.
• Created LDM, PDM in NF using ER Studio tool and converted the logical models to the physical design.
• Dataanalysis of existingdatato understand the current patient'sdataand business rules was applied to Differentdatabases by SQL.
• 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.
• Involved in creating Sessions, worklets and Workflows and scheduling workflows using Workflow Manager.
• Created Entity Relationship Diagrams, grouped and created the tables, validated the data, identified PKs for lookup tables.

Environment: ER Studio, Star Schema, Oracle 9i, Teradata Oracle SQL Developer, PL/SQL, Business Objects, OLAP, OLTP, Workflow Manager.