We provide IT Staff Augmentation Services!

Data Architect / Big Data Hadoop Developer Resume

2.00/5 (Submit Your Rating)

Wellesley Hills, MA

SUMMARY

  • Having 12 Years of Experience in Data Architectural Design Power Designer 12, 15, 16, 16.5, Erwin 4.1,8, BI Development SAP BO, Crystal and 3 Years of Experience in Hortonworks (HDP) Hadoop Development.
  • Has experience in working with Application development team to implement data strategies, data flows and developed conceptual, logical and physical data models using best practices to ensure high data quality and reduced redundancy.
  • Has good experience in Fact - Dimension creation (Dimensional Modeling) and Implemented Ralph Kimball and Bill Inmon Data warehousing methodologies using Top-down and Bottom-up approaches based on the Busienss Strategy.
  • Has good experience in Normalizing and De-normalizing databases for OLTP (Online Transaction Processing) and OLAP (Online Analytical Processing).
  • Has designed databases for various Architectures.
  • Has good experience in implementing Slowly Changing Dimensions (SCD) of Type 0,1,2,3.
  • Has good experience in implementing Sub Type and Super Types for various object categories.
  • Has good experience in implementing databases in 3NF
  • Has good experience in implementing Star Schema and Snow flake schema
  • Has experience in Model optimization and has created number of Relational and Dimensional Models.
  • Has developed and followed best practices for Standard Naming conventions (Glossary) and coding practices to ensure consistency of data models.
  • Has good experience in supporting various database applications by various vendors.
  • Has experience in Meta-Data Integration between ERwin and SAP BusinessObjects, ERwin and Informatica PowerCenter .
  • Has good experience in creating mapping docs and ETL specifications for source and target databases and shared with Informatica development team.
  • Has worked on different hardware platforms IBM, Apple.
  • Has good experience in developing Databases for various front end application like .NET, Java, MainFrames.
  • Has good experience in dealing with Database Administrators of various RDBMS databases (Oracle, SQL Server and DB2)
  • Has experience in Forward Engineering, Reverse Engineering from Data Model to DDL script and vice versa.
  • Has experience in Model Validation using much sophisticated External tools and ensured Accuracy and Completeness.
  • Has direct Client Interaction experience for End-to-End solutions and conducted review and status meetings.
  • Has good experience in complete life cycle of End to End Data Lineage (Both forward lineage and backward lineage) along with Metadata Management.
  • Has applied Data Governance standards for availability, usability, integrity and security of data for entire organization.
  • Has good experience in Sequence generation of tables across the database.
  • Has experience in generating Dependency Matrix of Model components and creating Domains.
  • Has experience in generating reports using List Report Wizard and applied import techniques on excel files and created models from the requirement documents.
  • Has experience in generating ERwin reports using Crystal Reports.
  • Has experience in creating Data Marts (Subject Areas) to differentiate various application modules.
  • Has handled Tool Migration of PowerDesigner from 16.0 to 16.5 with proper testing and dealt with SAP Technical Support team directly.
  • Good experience in Universe Designing, BusinessViews, LOVs and Report Bursting.
  • Has experience in SSRS and developed number of reports.
  • Has experience in developing Tabular Reports, Cross-tabs, Sub-reports, Mail Labeling Reports using Command Object, Tables, Views, BusinessViews, Stored Procedures and Universes.
  • Has experience in using Custom Functions, Alerts, Hyper-linking, Highlighting Expert, Summary fields and Running Totals
  • Has experience in working with Section Expert, Record Sort Expert, Group Sort Expert and Select Expert.
  • Has experience in creating Static, Dynamic, Cascading Prompts (Prompt Groups) and Formulas.
  • Has experience in designing complex and Pixel perfect reports using Guidelines and export formats as per the requirements.
  • Has good experience in Informatica PowerCentre by creating and moving data to Data warehouse as per the requirements.
  • 3 Years of Experience in Hortonworks (HDP) Hadoop Development
  • Has experience in designing data marts for Statistical analysis by using Machine learning technologies like SAS Analytics
  • Has experience in Hive Databases, Internal, External Tables and complex queries using Hive SQL.
  • Has experience in writing Map-Reduce Programs using Java.
  • Has experience in using complex data types Map, Array and Structs in Hive Shell Scripts.
  • Has experience in applying Partition techniques (Static, Dynamic), Joins, Bucketing on Hive tables.
  • Has experience in writing PIG Latin commands and Scripts for huge data loads to HDFS.
  • Has experience in writing Oozie workflows and job controllers for job automation
  • Has experience in Hue and HCatalog.
  • Has experience in importing and exporting data from RDBMS to Hadoop using SQOOP.

TECHNICAL SKILLS

Data Architecture Tools: ERwin Data Modeler 4.1,8, SAP Power Designer 16.5

BI Reporting & ETL Tools: BOXI 3.1, BI 4.1, Crystal Reports XI, XI R2, 2008, 2013 and Informatica PowerCentre 9.1,9.5, 9.6.1, Tableau

Dashboard (Data Visualization) Tools: QlikView Desktop

Big Data Hadoop & Data mining Tools: Hortonworks Hadoop HDP 2.X, R Statistical Analysis

Configuration Tools: VSS 6.0, Serena Dimensions 10.1.3, SVN

Scripting language: VB Script, Java Script, Shell script

Operating Systems: Windows, Linux, Mac OS X

Cloud Technologies: AWS EC2, S3, Redshift

RDBMS: DB2 9,10.5, Oracle 10g, 11g, SQL Server 2008, 2012, Teradata

Database Tools: DB2 Data Studio 4.1, Toad 9, WinSQL

E-mail Client: IBM Lotus 9, Outlook 2010 and MAC OS X Mail.

Document Repository: Sharepoint

Web Technologies: .NET Framework 2.0, ASP.NET, C#.NET

Packages: MS-Office 2003, 2007, 2010

DOMAIN EXPERTISE: Insurance, Manufacturing, Investments, Finance, Human Resource and Enterprise Management

PROFESSIONAL EXPERIENCE

Confidential, Wellesley Hills, MA

DATA ARCHITECT / BIG DATA Hadoop Developer

Responsibilities:

  • Has gathered requirements for various modules including Customer and Product designed Logical and Physical data models as per 360-degree view of a Customer.
  • Has attended meetings and prepared the strategies to collect the data from various sources like online streams, log files and feedback forms using Flume
  • Has stored the raw data from HDFS to Hive tables.
  • Has created Pig Latin scripts to perform sequential data store operations.
  • Has created shell scripts for Hive and Pig statement execution.
  • Has transferred bulk data between Hadoop and Structural data store like RDBMS using Sqoop
  • Has developed Map Reduce programs using Java to support complex data operations.
  • Has used R for analytics on data in Hadoop Ecosystem.
  • Has created Dashboards using QlikView
  • Has reviewed DB2 Database design using DB2 Data Studio regularly.
  • Has worked on Insurance, Investment and Financial Services domains as part of the Modeling design and Hive database design.

Environment: Sybase Power Designer 16.5, Hortonworks HDP 2.3(Hive, Pig, Sqoop, Map Reduce, Oozie), R Analytics, QlikView, Java, MainFrames, DB2 10, BI 4.1, DB2 Data Studio 4.1, WinSQL, SQL Server 2012, Serena Dimensions 10.1.3, Informatica PowerCenter 9.6.1, Oracle 11g

Confidential, Wellesley Hills, MA

DAT ARCHITECT / LEAD SAP BO DEVELOPER

Responsibilities:

  • Has designed number of Logical & Physical data models for lot number of applications and participated in discussions with DBAs and Project Analysts and Clients.
  • Designed and developed complex BOXI reports using Business Views and Stored procedures. Worked on performance optimization on existing reports too.
  • Designed Universes for complex Projects.
  • Has developed Custom Functions to reduce the redundancy
  • Has reviewed the database design using DB2 Data Studio 4.1
  • Has collected the meta data and maintained the sync between Informatica Repository Server and Power Designer Repository Server.
  • Has created Dimensional Data Models and Relational data models and provided End-to-End support for Data warehouses.
  • Created Objects, Predefined Conditions, joins in the Universe and Created Cardinalities, Contexts, Joins and Aliases for resolving Loops and checked the Integrity of the Universes.
  • Applied aggregate awareness to speed up query time.
  • Did multi-dimensional analysis using slice & dice, drill (up, down, through and across) by setting up different hierarchies and defining the scope of analysis.
  • Extensively used Crystal reports functions like Barcodes, Maps, Dynamic Cascading, Grouping, Hierarchies, and Sub reports, Charts, Variables and Sorting etc...
  • Created Report Templates for consistency in the look and feel of the reports.
  • Involved in all BOXI Migration phases and ensured that everything is working fine with proper testing.
  • Involved in testing reports before publishing them to the repository (query optimization & performance).
  • Used Short Cut Joins while designing the universe to increase the performance.
  • Published/Scheduled reports using Business Objects Enterprise / Crystal Server.
  • Has worked on Insurance, Investment and Financial Services domains as part of the Modeling design.

Environment: Sybase Power Designer 16.5, CA ERwin Data Modeler 8, Main Frames, Informatica Power Center 9.5, BOXI 3.1, BI 4.1, Crystal Reports XI R2, 2008, 2013, DB2, SQL Server 2008, Serena Dimensions 10.1.3, DB2 Data Studio 4.1, Oracle 11g

Confidential, Chicago, IL

DATA MODELER / LEAD SAP BO DEVELOPER

Responsibilities:

  • Has created Logical and physical data models for different modules
  • Requirement analysis for Database design and Clarity Project Universes and Reports using BusinessObjects XI R2 and Crystal Reports XI
  • Has developed crystal reports using Command Objects, Universes, BusinessViews
  • Has created Static, Dynamic and Cascading Prompts for advanced report filtering
  • Developed complex Crystal Reports which had high visibility from the user perspective.
  • Developed Sub Reports, Charts, Mail Labeling reports for the business analysis.
  • Developed Universes, Dashboards as per the requirements.
  • Created Objects, Predefined Conditions, joins in the Universe and Created Cardinalities, Contexts, Joins and Aliases for resolving Loops and checked the Integrity of the Universes.
  • Applied aggregate awareness to speed up query time.
  • Did multi-dimensional analysis using slice & dice, drill (up, down, through and across) by setting up different hierarchies and defining the scope of analysis.
  • Extensively used Crystal reports functions like Barcodes, Maps, Dynamic Cascading, Grouping, Hierarchies, and Sub reports, Charts, Variables and Sorting etc...
  • Created Report Templates for consistency in the look and feel of the reports.
  • Worked on complex requirements and created Queries, Stored Procedures and BusinessViews.
  • Worked on Model Validation, Model comparison, Reverse Engineering and Forward Engineering
  • Used automated external tools for Model validation and worked on Model Deduplication process.
  • Maintained metadata of BusinessObjects in the Repository.
  • Has developed setup files for applying customized settings to models.
  • Prepared Glossary (Data Dictionary), applied and maintained Naming Standards and Data Management Standards throughout the respective models.

Environment: Sybase Power Designer 15, Erwin 7, Business Objects XI R2, Clarity PPM, BOXI R2, Crystal Reports XI R2, JAVA, Oracle 10g, SQL Server 2005, MainFrames, TOAD

Confidential, Allenton, WI

DATA MODELER / LEAD SAP CRYSTAL DEVELOPER

Responsibilities:

  • Has developed Crystal Reports for complex requirements and integrated with .NET Web application.
  • Has designed logical and physical models in ERwin as per the client requirement.
  • Has maintained the meta-data and standard naming conventions for various modules.
  • Developed complex Crystal Reports which had high visibility from the user perspective.
  • Has developed setup files for applying customized settings to models.
  • Developed charts, Mail Label reports, sub reports
  • Has worked on query optimization and code review to meet the standards.
  • Extensively used Crystal reports functions like Barcodes, Maps, Dynamic Cascading, Grouping, Hierarchies, and Sub reports, Charts, Variables and Sorting etc...
  • Worked on Command Objects, Dynamic Data sets for report development.
  • Hands on writing stored procedures, views, functions, custom functions.
  • Created Report Templates for consistency in the look and feel of the reports.
  • Has developed stored procedures in Oracle and SQL Server 2005
  • Developed Sub Reports, Charts, Mail Labeling reports for the business analysis.

Environment: CA ERwin Data Modeler, ASP.NET, C#, Java Script, Oracle10g on UNIX, Crystal Reports 11.5, AJAX, Toad, SQL Server.

Confidential, Wakefield, MA

DATA MODELER / LEAD SAP CRYSTAL DEVELOPER

Responsibilities:

  • Has developed Crystal Reports for complex requirements and integrated with .NET Web application.
  • Has designed tables in ERwin as per the client requirement.
  • Has developed Crystal Reports for complex requirements and integrated with .NET Web application.
  • Has designed logical and physical models in ERwin as per the client requirement.
  • Has maintained the meta-data and standard naming conventions for various modules.
  • Developed complex Crystal Reports which had high visibility from the user perspective.
  • Has developed setup files for applying customized settings to models.
  • Developed charts, Mail Label reports, sub reports
  • Has worked on query optimization and code review to meet the standards.
  • Extensively used Crystal reports functions like Barcodes, Maps, Dynamic Cascading, Grouping, Hierarchies, and Sub reports, Charts, Variables and Sorting etc...
  • Worked on Command Objects, Dynamic Data sets for report development.
  • Hands on writing stored procedures, views, functions, custom functions.
  • Created Report Templates for consistency in the look and feel of the reports.
  • Has developed stored procedures in Oracle and SQL Server 2005
  • Developed Sub Reports, Charts, Mail Labeling reports for the business analysis.

Environment: CA ERwin Data Modeler, ASP.NET, C#, Java Script, Oracle10g on UNIX, Crystal Reports 11.5, AJAX, SQL Server 2005, TOAD

Confidential

DATA MODELER /LEAD SAP BO DEVELOPER

Responsibilities:

  • Has created Logical and physical data models for 4 modules using ERwin
  • Has developed Crystal Reports for complex requirements and integrated with .NET Web application.
  • Has designed tables in ERwin as per the client requirement.
  • Has developed Crystal Reports for complex requirements and integrated with .NET Web application.
  • Has designed logical and physical models in ERwin as per the client requirement.
  • Has maintained the meta-data and standard naming conventions for various modules.
  • Developed complex Crystal Reports which had high visibility from the user perspective.
  • Has developed setup files for applying customized settings to models.
  • Developed charts, Mail Label reports, sub reports
  • Has worked on query optimization and code review to meet the standards.
  • Extensively used Crystal reports functions like Barcodes, Maps, Dynamic Cascading, Grouping, Hierarchies, and Sub reports, Charts, Variables and Sorting etc...
  • Worked on Command Objects, Dynamic Data sets for report development.
  • Hands on writing stored procedures, views, functions, custom functions.
  • Created Report Templates for consistency in the look and feel of the reports.
  • Has developed stored procedures in Oracle and SQL Server 2005
  • Developed Sub Reports, Charts, Mail Labeling reports for the business analysis.

Environment: WINDOWS, UNIX, CA ERwin Data Modeler, SAP Business Objects XI, ASP.NET, C#, Java Script, Oracle10g on UNIX, Crystal Reports 11.5, AJAX.

Confidential

DATA MODELER /LEAD BOXI DEVELOPER

Responsibilities:

  • Developed all levels of Complex reports and integrated with the application using Crystal Reports XI, ASP.Net, AJAX and Web Services.
  • Direct communication with all levels of technical and business resources.
  • Developed charts, Mail Label reports, sub reports
  • Worked on Command Objects, Dynamic Data sets for report development.
  • Understand requirements from use case and functional specification documents.
  • Participate in technical design review meetings with client.
  • Has designed tables in ERwin as per the client requirement.
  • Has conducted design and development reviews
  • Extensively used Crystal reports functions like Barcodes, Maps, Dynamic Cascading, Grouping, Hierarchies, and Sub reports, Charts, Variables and Sorting etc...
  • Worked on Command Objects, Dynamic Data sets for report development.
  • Hands on writing stored procedures, views, functions, custom functions.
  • Created Report Templates for consistency in the look and feel of the reports.
  • Created stored procedures, Functions, Custom Functions and BusinessViews for complex requirements.

Environment: WINDOWS, CA ERwin Data Modeler, SAP Business Objects XI, ASP.NET, C#, Java Script, Oracle10g on UNIX, Crystal Reports 11.5, AJAX

Confidential

DATA MODELER / LEAD CRYSTAL DEVELOPER

Responsibilities:

  • Has created logical and physical data models for various modules using ERwin.
  • Developed all levels of Complex reports and integrated with the application using Crystal Reports XI Release 2, ASP.NET, AJAX and Web Services.
  • Developed charts, Mail Label reports, sub reports
  • Worked on Command Objects, Dynamic Data sets for report development.
  • Worked on various modules like Marine, Cargo, Human Resource and Finance
  • Developed various high priority Invoice Reports for Finance Module
  • Extensively used Crystal reports functions like Barcodes, Maps, Dynamic Cascading, Grouping, Hierarchies, and Sub reports, Charts, Variables and Sorting etc...
  • Worked on Command Objects, Dynamic Data sets for report development.
  • Hands on writing stored procedures, views, functions, custom functions.
  • Created Report Templates for consistency in the look and feel of the reports.
  • Worked on Stored Procedures, Functions and Views to satisfy the client requirement
  • Involved in Database design and package design.
  • Direct communication with all levels of technical and business resources.

Environment: WINDOWS, CA ERwin Data Modeler, ASP.NET, C#, Java Script, Oracle10g on UNIX, Crystal Reports 11.5, AJAX, TOAD, SQL Server 2000

We'd love your feedback!