SUMMARY:

• 14+ years of experience as a Big Data Architect/ Developer, Data Modeler, DWBI Data Architect and Developer working with Confidential. In my recent projects working extensively on Big Data move from traditional DWBI. Worked extensively in both Data Warehousing (ETL, OLAP, and Dimensional Modeling) and high availability online transaction processing systems (OLTP). Well versed with RDBMS, OODBMS and OS concepts. Involved in Analysis, Design, Development and Testing.
• Special skills in Analysis, Modeling, Designing and documenting data bases, Depth knowledge of Agile, Scrum, BPM and database modeling, Knowledge of Object, relational and multi - dimensional database development of extraction, transformation and load processes Testing/Test Results Capturing Troubleshooting Informatica Jobs and PL/SQL Process Learn rapidly and apply it to the working environment, Strong analytical and problem solving skills
• Big Data experience in Scala, Spark and Hive.
• Proficient in usage of tools like Erwin 9.5/8.3/7.1/4.1 (Data Modeler, Model Mart, navigator), ER Studio Data Architect, IBM MetaData Workbench, Oracle data profiling tool, Informatica 9.1/8.1/7.x/6.x, Oracle Forms, Reports, SQL*Plus, Toad, Crystal Reports.
• Solid Experience in Oracle 11i, 10g, 9i, 8i, Writing PL/SQL scripts
• Solid development skills in Informatica v8.1, v6.1 and Cognos ETL tool
• Solid Programming skills in UNIX Shell Scripting and CGI script.
• Exposure to development and designing reports in COGNOS and Crystal Report version 10, 9, 8.5
• Demonstrated ability to adapt to ever changing technologies and methodologies.
• Proficient in analyzing and translating business requirements to technical requirements and architecture.
• Excellent interpersonal skills, quick learner and a good team player.
• Self confident, hard working and dedicated individual, honest and resourceful in completion of projects.

PROFESSIONAL EXPERIENCE:

Confidential

Technology/Software: Spark, Scala, Spark MLlib (machine Learning), Cloudera Hadoop, OrientDB, Hive, Sqoop, Impala.

Lead Architect/Designer/Developer

• Created Technical Solution in Scala to process HDFS file in avro file format using Spark RDD, Dataframe, Transformations and Actions. Explored Spark Lazy value evaluation feature.
• Participated in all phases of the Project Initiation Phase including Business Walk-through, requirements gathering, design, development, troubleshooting, debugging and documentation.
• Interfaced with business customers, business analysts, data analysts, other developers, and IT support staff to validate that the requirements and specifications are complete, consistent, concise, and achievable and ensure all these are documented.
• Participated in the discussion on which Big Data technology would be the right fit.
• Performed small POC to validate the assumption and facts for any decision taken regarding big data technology stack selection
• Created all required documentation (Architectures, Metadata and data dictionaries) to support, communicate, and validate the data model.
• Worked directly with clients, developers, and other technical source team members and Big Data Infrastructure administrators to design and develop high performing System.
• Participated in the development standards and conventions, data dictionaries and data element naming standards for spark / scala development process.
• Conducted a POC using OrientDB, HBase and MongoDB to identify best fitting NoSQL database for Huron project
• Assisted as scrum master in Agile process when required.
• Coordinated with QA team and the Production Deployment Team

Confidential

Technology/Software: Erwin 9.5/9.1/8.3 (Data Modeler, Model Mart, navigator), ER

Lead Data Modeler/Data Architect

• Participate in all phases of the Data Warehouse development process including in Business Walk-through, requirements gathering, design, development, troubleshooting, debugging and documentation.
• Interface with business customers, business analysts, data analysts, other developers, and IT support staff to validate that the requirements and specifications are complete, consistent, concise, achievable and ensure all these are documented.
• Create, refine or enhance (reverse engineer) the data models within the scope of the business requirements.
• Create all required documentation (Architectures, Metadata and data dictionaries) to support, communicate, and validate the data model.
• Work directly with clients, ETL developers, and other technical data warehouse team members and database administrators to design and develop high performing databases.
• Participate in the development and maintenance of overall data architecture, data management standards and conventions, data dictionaries and data element naming standards to support data warehousing.
• Design Normalized ER-Models(3NF) and Dimensional models (Data Marts)
• Design and implement Data marts from enterprise data warehouse.
• Involve in Data extraction, transformation, loading and ETL metadata management
• Capture and management of model metadata that describes the logical to physical mapping characteristics as well as source to target mapping characteristics for database population
• Develop conceptual data models including categories, subject areas, key entities and entity relationships conforming to the applicable data standards within the scope of the business requirements.
• Create logical data models that extend and attribute the conceptual models to an appropriate level of detail, along with accompanying documentation in conformance with the applicable data standards to meet the business requirements.
• Create physical data models and validates existing physical data models of data sources and targets within the scope of the technical specifications and business requirements.
• Develop mapping spreadsheets that will provide the Data Warehouse Development (ETL) team with source to target data mapping, inclusive of logical names, physical names, data types, volumetrics, domain definitions, and meta-data definitions.
• Maintaining integrity of databases, including referential integrity checking, multiple access schemes, establishing standards, monitor performance.
• Determine appropriateness of data storage, archive, recovery, Load strategy, purge and security
• Conducting peer reviews/Inspections throughout development to ensure quality and traceability to requirements and adherence to all quality management plans and standards.
• Ensure operational and analytical data warehouses are able to support all business requirements for reporting across the organization.
• Tuned the performance of the Data Base, PL/SQL Procedures, SQL queries, Informatica mappings to load the data quicker

Confidential

Technology/Software: Erwin 9.5/9.1/8.3 (Data Modeler, Model Mart, navigator), Oracle 10g, Informatica, Quality Stage, Perl,UNIX, CGI, Cognos ETL Tool, Teradata, PL/SQL, SQL*PLUS, SQL, TOAD,XML, MS Office 2003/2007(MS Project, MS project, MS power point)

Lead Data Modeler/Data Architect

• Participate in all phases of the Data Warehouse development process including in Business Walk-through, requirements gathering, design, development, troubleshooting, debugging and documentation.
• Interface with business customers, business analysts, data analysts, other developers, and IT support staff to validate that the requirements and specifications are complete, consistent, concise, achievable and ensure all these are documented.
• Create, refine or enhance (reverse engineer) the data models within the scope of the business requirements.
• Create all required documentation (Architectures, Metadata and data dictionaries) to support, communicate, and validate the data model.
• Work directly with clients, ETL developers, and other technical data warehouse team members and database administrators to design and develop high performing databases.
• Participate in the development and maintenance of overall data architecture, data management standards and conventions, data dictionaries and data element naming standards to support data warehousing.
• Design Normalized ER-Models(3NF) and Dimensional models (Data Marts)
• Design and implement Data marts from enterprise data warehouse.
• Involve in Data extraction, transformation, loading and ETL metadata management
• Tuned the performance of the Data Base, PL/SQL Procedures, SQL queries, Informatica mappings to load the data quicker

Confidential

Technology/Software: Erwin 7.1 (Data Modeler, Model Mart, navigator), Oracle 10g, Informatica, Perl, UNIX, CGI, Cognos ETL Tool, Teradata,PL/SQL, SQL*PLUS, SQL, TOAD,XML, MS Office 2003/2007(MS

Lead Data Modeler/Data Architect

• Design and develop the Conceptual, logical and physical ERD’s, Business scenarios, Use Cases and database structures.
• Create all required documentation (Architectures, Metadata and data dictionaries) to support, communicate, and validate the data model.
• Work directly with clients, ETL developers, and other technical data warehouse team members and database administrators to design and develop high performing databases.
• Participate in the development and maintenance of overall data architecture, data management standards and conventions, data dictionaries and data element naming standards to support data warehousing.
• Design Normalized ER-Models(3NF) and Dimensional models (Data Marts)
• Design and implement Data marts from enterprise data warehouse.
• Involve in Data extraction, transformation, loading and ETL metadata management

Confidential

Technology/Software: Erwin 7.1 (Data Modeler, Model Mart, navigator), Oracle 10g,Informatica, Perl, UNIX, CGI, Cognos ETL Tool,PL/SQL, SQL*PLUS, SQL, TOAD,XML, MS Office 2003/2007(MS

Data Modeler/ Data Architect

• Determine and manage application indexes necessary to optimize database performance.
• Create, refine or enhance (reverse engineer) the data models within the scope of the business requirements.
• Create all required documentation (Architectures, Metadata and data dictionaries) to support, communicate, and validate the data model.
• Work directly with clients, ETL developers, and other technical data warehouse team members and database administrators to design and develop high performing databases.
• Participate in the development and maintenance of overall data architecture, data management standards and conventions, data dictionaries and data element naming standards to support data warehousing.
• Design Normalized ER-Models(3NF) and Dimensional models (Data Marts)
• Design and implement Data marts from enterprise data warehouse.
• Involve in Data extraction, transformation, loading and ETL metadata management
• Capture and management of model metadata that describes the logical to physical mapping characteristics as well as source to target mapping characteristics for database population
• Develop conceptual data models including categories, subject areas, key entities and entity relationships conforming to the applicable data standards within the scope of the business requirements.

Confidential

Technology/Software: Erwin 7.1 (Data Modeler, Model Mart, navigator), Oracle 10g,Informatica, Perl, UNIX, CGI, Cognos ETL Tool,PL/SQL, SQL*PLUS, SQL, TOAD,XML, MS Office 2003/2007(MS

Data Modeler/Data Architect

• Participate in the development and maintenance of overall data architecture, data management standards and conventions, data dictionaries and data element naming standards to support data warehousing.
• Design Normalized ER-Models(3NF) and Dimensional models (Data Marts)
• Designed, developed and tested Informatica mappings, mapplets, configuring sessions and workflow to facilitate Extract Transform and Load of data.
• Used transformations like joiner, router, aggregator, normalizer, sorter, update strategy, look ups, filter, expressions, rank, Stored Procedure etc to load data along with handling of complex business requirements
• Addressed performance issues of enterprise ETLs and optimizing the mappings using various performance enhancement features like caching etc
• Developed UNIX Shell scripts to automate repetitive database processes. Enhanced SQL packages to fix production issues.
• Documenting the whole process related information (as per CMMi, ISO and SOX Standards) for the activities performed
• Adhere to the standards and adapt to the software development methodologies in compliance with the established process flow.
• Analyzing business requirements and translating them to technical requirements

Confidential

Technology/Software: Erwin 7.1 (Data Modeler, Model Mart, navigator),Oracle 10g, Informatica, Perl, UNIX, CGI, Cognos ETL Tool, PL/SQL, SQL*PLUS, SQL, TOAD

Developer

• Participate in the development and maintenance of overall data architecture, data management standards and conventions, data dictionaries and data element naming standards to support data warehousing.
• Understand Data Model Concept - Dimensional vs Relational Model.
• Design and develop a custom database (Tables, Views, Functions, Procedures, Packages)
• Written Shell scripts for automating the process of data loading
• Created Oracle Stored Procedures, Packages, Triggers, functions, cursors to implement various complex business requirements
• Created Unix Cron Jobs/Background processes, Unix scripts to run Informatica mappings. Run batch jobs for using SQL*Loader.
• Fine-Tuning SQL Queries using TKprof, Explain Plan, SQL Optimizer.

Confidential

Technology/Software: Java, Swings, AWT, JSP, Oracle, Sybase

Developer

• Coded Stored Procs, Triggers, Packages
• Test planning, Bug tracking and Implementation
• Exception handling and customizing PL/SQL exception messages
• Testing and debugging PL/SQL blocks.