We provide IT Staff Augmentation Services!

Data Architect / Modeler Resume

Battle Creek, MI

SUMMARY

  • A lateral thinking and successful Data Architect, Modeler and BI Technical Architect that has worked on full life cycle projects.
  • 3+ years of experience to collect and document user's requirements, Design and develop database architecture for information systems projects in EDW/Big data architectural environment.
  • Design, construct, modify, integrate, implement and test data models and database management systems.
  • Conduct research and provide advice to other informatics professionals regarding the selection, application and implementation of database management tools. Operate database management systems to analyze data and perform data mining analysis.
  • Data Modeler: 10+ years of experience with strong Conceptual and Logical Data Modeling skills using ERWIN or UML similar tools for requirements gathering, creating data mapping documents, writing functional specifications, RDBMS Concept, Logical Model, Enterprise Data Modeling (Relational, Dimensional, Multi - Dimensional, MDX Queries) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables. Data Analysis experienced in Online Transaction Processing (OLTP) and Data Warehousing (OLAP)/Business Intelligence (BI) applications
  • Report Development: Skilled with Tableau, Cognos BI, BO, MS Power BI, BOXI, and Crystal Reports in big data and data warehouse environments.
  • Extensive knowledge of writing Complex SQL queries, working with back end tools such as Toad for data validation and verification.
  • Well experienced in Extract transport and Load (ETL) data mapping from spreadsheets, database tables and other sources using Informatica, Pentaho and Talend.
  • I possess a multiple technical background, gained through hands-on experience in all areas of IT and more importantly in Telecom, Retail, Banking, HealthCare, Financial and Insurance domains.

TECHNICAL SKILLS

ROLES: Data Architect, Data Modeler, Data Analyst, Requirement Analysis (BA), BI Technical Architect (Report Development & ETL Mapping), Project Delivery Management (Onsite/Offshore)

Databases: Oracle 11g, SQL Server 2008,Teradata, My SQL, NOSQL Cassandra, Mongo DB, Maria DB, MemSQL

Data Modelling Tools: Erwin Data-Modeler, Erwin 9.6.1, ER/Studio, UML, MS Power BI 2.4x

Data Profiling Tools: OSDQ, Data Cleaner, Talend Data profiling, ETL Validator

Big Data Technologies: Hadoop, Map Reduce, HBASE, HIVE, Cloudera, Horton Sandbox

ETL Tools: Informatica PowerCenter 9x/8x, Pentaho, Talend

Script Languages: C#, Perl, VB Script and Java Script

Reporting Tools: Crystal Report 11 / Crystal Report 2008, BO Server XI R2/R3 InfoView/BO UNIVERSES/Dashboard/score board. Business Object 6.5 and BO server 6.5.,Cognos BI reporting 10.2,Toad, PL/SQL, SQL LOADER, Tableau 8.0., MS Power BI 2.4x

Planning Tools: Cognos Planning 10.1

CRM: SIEBEL 7.8, 8.1 (COM, Configuration & EIM)

Operating Systems: Windows, Linux, Unix

GUI: Visual Basics 6.0,VBA, ASP, VB.net, ASP.net, Delphi

Domain: Telecom, Banking, Finance, Healthcare and Insurance

PROFESSIONAL EXPERIENCE

Confidential, Battle Creek, MI

Data Architect / Modeler

Responsibilities:

  • Design system architecture to implement the Technical requirements. Map the Technical Requirements to sub-systems.
  • Gathering Business and Specification Requirements from the Business users and also with the Technical team.
  • Providing a high level Conceptual Data Model to the Business Users. Create source to target mapping documents involving the Business rules and transformation rules.
  • Create Logical Data Model (LDM) and Physical Data Models (PDM) using Erwin data modeling tool.
  • Provide the solution of EDW, Big Data Environment, MemSQL with Data Analysis and data model.
  • Provide expert knowledge in creating Enterprise data Model for existing EDW systems & applications for interoperability.
  • Create a detailed design implementing Data warehouse for quick integration capability with security.
  • Provide inputs and create reusable models for increased interoperability.
  • Writing Complex MDX queries, stored procedures for data profiling / governance.
  • Develop security policies for Authentication, Authorization & Auditing data models.
  • Coordinating Project activities and tasks, as well as dependent deliverables.
  • Managing tasks, issues, and risk retirement.
  • Provide documentation support and best practices.
  • Provide production deployment guidelines and execution plan.

Environment: Erwin Data Modeler9x, SQL Server 2016, MemSQL, Tableau 8.0, Hadoop, Map Reduce, HBase, Hive and Horton Sandbox.

Confidential, Atlanta, GA

Data Architect / Analyst / Modeler

Responsibilities:

  • Design system architecture to implement the Technical requirements. Map the Technical Requirements to sub-systems.
  • Prepare System Feature Design (SFD) Document and co-ordinate with other development teams to develop Interface Agreements (IA).
  • Design components to meet Technical requirements.
  • Prepare Detailed Design Specifications (DDS), Review and baseline Detailed Design Specifications (DDS).
  • Map design components with User, and Technical Requirements, i.e. Prepare Requirement Traceability Matrix (RTM).
  • Prepare Technical and Business processes documents for Bug-Fix, Maintenance, Stabilization and development work.
  • Prepare documents for Technical design processes and post implementation documents
  • Facilitated data requirement meetings with business and technical stakeholders and resolved conflicts to drive decisions.
  • Gathering Business and Specification Requirements from the Business users and also with the Technical team.
  • Providing a high level Conceptual Data Model to the Business Users once the Business Requirements are evaluated and finalized.
  • Create source to target mapping documents involving the Business rules and transformation rules.
  • Create Logical Data Model (LDM) and Physical Data Models (PDM) using Erwin data modeling tool.
  • Reviewing the High Level Design (HLD) Document and Design Specification Documents provided to the ETL technical team once the Logical Data Model is reviewed and approved by the business users.
  • Further Implementation Logical Data Model and Physical Data Models are also reviewed with the Application/Platform DBA was the models are created in the assigned environment.
  • Implementing the Data management strategies across the various database domains and products with respect to each business units.
  • Providing data sets to the user queries on day to day bases to determine the performance and quality of the test data.
  • Design and direct the implementation of security requirements for the data warehouse and direct the information access and delivery effort for the data warehouse.
  • Direct the data warehouse Meta data capture and access effort and also define Meta data standards for the data warehouse.

Environment: CA Erwin Data Modeler 9x, Oracle 11g, My SQL, Teradata13.0, PL/SQL, Toad, Informatica 9.6, Talend, Tableau 8.0, BO, MS Power BI 2.4x, CCR-R, CCR-LDAP, DATA ROUTER, DMaap, DTI, GRID-GDDN, GRID-AC, MSGRTR, eCDW, Hadoop, Map Reduce, Data lake NOSQL ->Hive, Cassandra.

Confidential

Sr. BI Technical Architect / Data Modeler

Responsibilities:

  • Analysis the existing modules from legacy systems and identify the short coming of the product features and provide the design/technical solutions for the same.
  • Involved in design phase for to create high level & low level technical design document for all business scenarios.
  • Involved in development phase to create complex mapping between dimension & fact tables for all complex business scenarios.
  • Involved in session monitoring for performance issues get it resolved.
  • Liaise with client on technical architecture related issues and solutions
  • Conductedquantitativeanalysisoffinancialdatatoforecastrevenue,identifyfuturetrends,andassessrisk for each stores.
  • Associatedwithcapitalexpenditures,acquisitions,andjoint­ventureprojectsforlargerealestateinvestment firm.
  • Compiledandreviewedcomplexdatatoassessmultimillion­dollaraccountsandbusinessunits.
  • Designedcomprehensivereports,abstractsandchartstopresentdataandguideinvestment strategies.
  • Designed Cubes. MDX queriesad­hocanalysisandreporting for all stores by region wise.
  • Gathering Business and Specification Requirements from the Business users and also with the Technical team.
  • Providing a high level Conceptual Data Model to the Business Users once the Business Requirements are evaluated and finalized.
  • Create source to target mapping documents involving the Business rules and transformation rules.
  • Create Logical Data Model (LDM) and Physical Data Models (PDM) using Erwin data modeling tool.
  • Involved in various scenarios related toData Modeling, System/Data Analysis, Design and Development for both OLTP and Data warehousing environments.
  • Involved in various complex SQL Query tuning and provided tuning recommendations, time/CPU consuming queries. Perform root cause analysis on failures. Resolve performance tuning related issues and queries.

Environment: Cognos Planning 10.1, Cognos BI Reporting 10.2, Power play, Erwin r7.1/7.2, ER Studio V8.0.1, Pentaho, PL/SQL and Oracle 11g

Confidential

BI Technical Architect

Responsibilities:

  • Analysis of Inventory module and identify the short coming of the product features and provide the design solution for the same.
  • Provide design solutions for the Performance Metrics utility of Prime Order Fulfillment suite.
  • Provide design solutions for the Embedded Oracle installation, as part of Prime Order Fulfillment suite.
  • Involved in various scenarios related toData Modeling, System/Data Analysis, Design and Development for both OLAP and Data warehousing environments.
  • Involved in development phase to create complex mapping between dimension & fact tables for all complex business scenarios.
  • Involved in various complex SQL Query tuning and provided tuning recommendations, time/CPU consuming queries.
  • Perform root cause analysis on failures. Resolve performance tuning related issues and queries.

Environment: Pentaho, Erwin, PL/SQL, UNIX, VBA, BO and Oracle 11g

Confidential

BI Technical Consultant / Architect

Responsibilities:

  • Understands complex technical architecture of the project and effectively utilizes the resources to meet project standards.
  • Designed and written a complex interface between Siebel application and Crystal Reports server to printer works order/Invoice.
  • Understood the client server architecture of Crystal Reports Xi R2 and provide technical solutions to the client and development team
  • Extensive experience in Relational and Dimensional Data modeling for creating Logical and Physical Design of Database and ER Diagrams using multiple data modeling tools like ERWIN, ER Studio.
  • Worked extensively on forward and reverse engineering processes. Created DDL scripts for implementing Data Modeling changes. Created ERWIN reports in HTML, RTF format depending upon the requirement, published Data model in model mart, created naming convention files, co-coordinated with DBAs to apply the data model changes.
  • Reviewfinancialstatementsandanalyzesalesrevenues,costs,expenses,andtaxratesforallbusiness unitsofleadingprocessautomationcompany.Developdetailedspreadsheetstoidentify trendsanddevelopforecasts.
  • Consolidateandanalyzemonthlyresultsandbudgets.Createanddeliver presentations, providingrecommendationsonshort­andlong­rangeROI.
  • Spearheadedduediligencefor$5.2­billionjointventure,identifyingkeyriskfactorsandforecasting investmentviability.
  • Establishednewforecastingtrackingandmanagementreportingsystemtoimproveavailability and accuracyoffinancialdata,triggering15%increaseinaccuracy.
  • Involved in design phase for to create high level & low level technical design document for all business scenarios.
  • Involved in development phase to create complex mapping between dimension & fact tables for all complex business scenarios.
  • Involved in various complex SQL Query tuning and provided tuning recommendations, time/CPU consuming queries.
  • Used Explain Plan, Oracle hints and creation of new indexes to improve the performance of SQL statements.
  • Provided tuning recommendations and future memory requirements to DBA team to make the changes in Database like table reorg, add enough spaces to database
  • Created a purge script to remove the old data based on purging retention periods.
  • Perform root cause analysis on failures. Resolve performance tuning related issues and queries.

Environment: Siebel 8.1, Geneva Billing System, Informatica, VBA, Business Objects XIR2-R3, Crystal Report, UNIX, Erwin, ctrl+M, My SQL, Teradata13.0 and Oracle 11g

Project Lead / Product Administrator

Confidential

Responsibilities:

  • As a Project lead, Conducting scrum call on daily basis, KT session within the team, assign the tasks, track the team member, Conduct Show & Tell session to client, and deliver the modules on time by agile methodology.
  • As a Product Administrator develop & deliver the products on time.
  • As a Data modeller - Worked extensively on forward and reverse engineering processes. Created DDL scripts for implementing Data Modeling changes. Created ERWIN reports in HTML, RTF format depending upon the requirement, published Data model in model mart, created naming convention files, co-coordinated with DBAs to apply the data model changes
  • Involved in various complex SQL Query tuning for various scenarios.

Environment: Siebel 8.1, Geneva Billing System, VBA, PLSQL, Erwin & Oracle 10g

Hire Now