We provide IT Staff Augmentation Services!

Data Architect / Big Data Hadoop Developer Resume

5.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.
  • Have 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.
  • Have 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.
  • Have good experience in Normalizing and De-normalizing databases for OLTP (Online Transaction Processing) and OLAP (Online Analytical Processing).
  • Have designed databases for various Architectures.
  • Have good experience in implementing Slowly Changing Dimensions (SCD) of Type 0,1,2,3.
  • Have good experience in implementing Sub Type and Super Types for various object categories.
  • Have good experience in implementing databases in 3NF
  • Have good experience in implementing Star Schema and Snow flake schema
  • Have experience in Model optimization and have created number of Relational and Dimensional Models.
  • Have developed and followed best practices for Standard Naming conventions (Glossary) and coding practices to ensure consistency of data models.
  • Have good experience in supporting various database applications by various vendors.
  • Have experience in Meta-Data Integration between ERwin and SAP BusinessObjects, ERwin and Informatica PowerCenter .
  • Have good experience in creating mapping docs and ETL specifications for source and target databases and shared with Informatica development team.
  • Have worked on different hardware platforms IBM, Apple.
  • Have good experience in developing Databases for various front end application like .NET, Java, MainFrames.
  • Have good experience in dealing with Database Administrators of various RDBMS databases (Oracle, SQL Server and DB2)
  • Have experience in Forward Engineering, Reverse Engineering from Data Model to DDL script and vice versa.
  • Have experience in Model Validation using much sophisticated External tools and ensured Accuracy and Completeness.
  • Have direct Client Interaction experience for End-to-End solutions and conducted review and status meetings.
  • Have good experience in complete life cycle of End to End Data Lineage (Both forward lineage and backward lineage) along with Metadata Management.
  • Have applied Data Governance standards for availability, usability, integrity and security of data for entire organization.
  • Have good experience in Sequence generation of tables across the database.
  • Have experience in generating Dependency Matrix of Model components and creating Domains.
  • Have experience in generating reports using List Report Wizard and applied import techniques on excel files and created models from the requirement documents.
  • Have experience in generating ERwin reports using Crystal Reports.
  • Have experience in creating Data Marts (Subject Areas) to differentiate various application modules.
  • Have 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.
  • Have experience in SSRS and developed number of reports.
  • Have experience in developing Tabular Reports, Cross-tabs, Sub-reports, Mail Labeling Reports using Command Object, Tables, Views, BusinessViews, Stored Procedures and Universes.
  • Have experience in using Custom Functions, Alerts, Hyper-linking, Highlighting Expert, Summary fields and Running Totals
  • Have experience in working with Section Expert, Record Sort Expert, Group Sort Expert and Select Expert.
  • Have experience in creating Static, Dynamic, Cascading Prompts (Prompt Groups) and Formulas.
  • Have experience in designing complex and Pixel perfect reports using Guidelines and export formats as per the requirements.
  • Have 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
  • Have experience in designing data marts for Statistical analysis by using Machine learning technologies like SAS Analytics
  • Have experience in Hive Databases, Internal, External Tables and complex queries using Hive SQL.
  • Have experience in writing Map-Reduce Programs using Java.
  • Have experience in using complex data types Map, Array and Structs in Hive Shell Scripts.
  • Have experience in applying Partition techniques (Static, Dynamic), Joins, Bucketing on Hive tables.
  • Have experience in writing PIG Latin commands and Scripts for huge data loads to HDFS.
  • Have experience in writing Oozie workflows and job controllers for job automation
  • Have experience in Hue and HCatalog.
  • Have 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:

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

  • Have 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.
  • Have developed Custom Functions to reduce the redundancy
  • Have reviewed the database design using DB2 Data Studio 4.1
  • Have collected the meta data and maintained the sync between Informatica Repository Server and Power Designer Repository Server.
  • Have 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.
  • Have 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:

  • Have 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
  • Have developed crystal reports using Command Objects, Universes, BusinessViews
  • Have 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.
  • Have 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:

  • Have developed Crystal Reports for complex requirements and integrated with .NET Web application.
  • Have designed logical and physical models in ERwin as per the client requirement.
  • Have maintained the meta-data and standard naming conventions for various modules.
  • Developed complex Crystal Reports which had high visibility from the user perspective.
  • Have developed setup files for applying customized settings to models.
  • Developed charts, Mail Label reports, sub reports
  • Have 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.
  • Have 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:

  • Have developed Crystal Reports for complex requirements and integrated with .NET Web application.
  • Have designed tables in ERwin as per the client requirement.
  • Have developed Crystal Reports for complex requirements and integrated with .NET Web application.
  • Have designed logical and physical models in ERwin as per the client requirement.
  • Have maintained the meta-data and standard naming conventions for various modules.
  • Developed complex Crystal Reports which had high visibility from the user perspective.
  • Have developed setup files for applying customized settings to models.
  • Developed charts, Mail Label reports, sub reports
  • Have 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.
  • Have 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:

  • Have created Logical and physical data models for 4 modules using ERwin
  • Have developed Crystal Reports for complex requirements and integrated with .NET Web application.
  • Have designed tables in ERwin as per the client requirement.
  • Have developed Crystal Reports for complex requirements and integrated with .NET Web application.
  • Have designed logical and physical models in ERwin as per the client requirement.
  • Have maintained the meta-data and standard naming conventions for various modules.
  • Developed complex Crystal Reports which had high visibility from the user perspective.
  • Have developed setup files for applying customized settings to models.
  • Developed charts, Mail Label reports, sub reports
  • Have 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.
  • Have 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.
  • Have designed tables in ERwin as per the client requirement.
  • Have 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:

  • Have 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!