Candidates About

 

Syed

Sr. Data Architect / Data Modeler

Professional 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 enterprise data warehouses using Kimball data warehouse and Inmon's methodologies. 

·         Experience working with data modeling 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.

Tools & 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

Work Experience:

 

AIM Specialty Health- Chicago, IL                                                                                     Sep 16 – Till Date

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 Master data Management (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 QlikView Data Models by extracting and using the data from various sources files, Excel, and Big data, 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

 

Pacific Life- Newport Beach, CA                                                                            May 15  - Aug 16

Sr. Data Architect/ Data Modeler

Responsibilities:

·         Researched, evaluated, architect, and deployed new tools, frameworks, and patterns to build sustainable Big Data platforms 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 in Data profiling and data analysis to understand the business process and implement the functionality in EDW through dimensional modeling. 

·         Built Logical and Physical data models and Data Dimensional Modeling using ERWIN 

·         Responsible for technical Data governance, enterprise wide Data modeling 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.

·         Developed Data Mapping, Data Governance, Transformation and cleansing rules for the Master Data 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

 

Comcast - West Chester, PA                                                                                                Mar 14  - Jan 15

Sr. Data Analyst/Data Modeler

Responsibilities

·         Documented logical, physical, relational and dimensional data models. Designed the Data Marts in dimensional data modeling using star and snowflake schemas. 

·         Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD (Object oriented Design) using UML and Visio 

·         Preparation of data dictionary / business glossaries and also integrating Data dictionary into data models. 

·         Data analysis of existing data base to understand the data flow and business rule applied to Different data bases by SQL 

·         Used ERWIN Data Modeler for Generating DDL, Stored Procedure and Trigger Code for Source to Target database. 

·         Worked extensively on Data Migration by using SSIS. 

·         Data Profiling of source using Oracle and Hue(Hadoop/Hive UI) and supporting developers by testing the target on Teradata and Hadoop 

·         Involved in the mapping of data sources and analytics, with the goal of ensuring data quality. 

·         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 the data which 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 complex data from 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). 

·         Data governance functional and practical implementation and also responsible for designing common Data governance frameworks 

·         Worked closely with Business, DBA team, ETL and Reporting teams to define data requirements. 

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.

 

Vangaurd- Malvern, PA                                                                                                      Nov 10 – Apr 14

Sr. Data Analyst/Data Modeler

Responsibilities

·         Created logical data model 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 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. 

·         Developed Data Migration and Cleansing rules for the Integration Architecture (OLTP, ODS, DW) 

·         Designed 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. 

·         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 analytical data requirements. 

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

·         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

 

Gap Inc- SFO, CA                                                                                        Aug 06 – Sep 10

Data Analyst/Data Modeler

Responsibilities

·         Analyzed Data sources and requirements and business rules to perform logical and physical Data Modeling 

·         Created a logical design and physical design in ER/Studio. 

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

·         Creating data trace map and data quality mapping documents, Performing Data Profiling and Data Quality. 

·         Executed the UNIX shell scripts that invoked SQL loader to load data into 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 developing data model 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 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. 

·         Performed Data Analysis and data profiling using complex SQL on various sources systems including Oracle 9i/8i and Teradata, to ensure accuracy of the data between the warehouse and source systems. 

<p class="MsoNoSpacing" s