We provide IT Staff Augmentation Services!

Data Modeler Resume

Columbus, OH

SUMMARY:

  • Proactive, insightful, innovative, collaborative, results oriented, and recognized as Thinker
  • Data driven individual with passion to design solutions that fit the business purpose
  • Established Data Modeler with expertise in building designs tailored to drive strategic and tactical intelligence
  • Distinguished Business Analyst competent in analyzing business requirements, modeling business processes, building functional specifications, thus acting as a liaison for business and IT
  • Astute Data Analyst with proven ability to discover data patterns, establish correlations, develop hypothesis, and build prototypes for business and IT
  • Recognized Facilitator proficient in driving JAD sessions with cross functional teams of end business users, app developers, architects, quality analysts, data modelers, and administrators

SKILL:

Data Modeling: Erwin, Ralph Kimball framework

Databases/Languages: Teradata, Oracle 8i/9i, MS SQL Server, MS Access, DB2, PL/SQL

Metadata: Ab Initio Metadata Hub

SQL Tools: TOAD, Teradata SQL Assistant

ETL: Informatica

Quality Control: Quality Center, QTP

Business/Data Analysis: IBM Doors, Use case, Sequence Flow, and UML diagrams, Wire frames

SDLC Methodology: Agile, Waterfall

Operating Systems: UNIX, Linux, Windows 2003/XP/7, Ispace

Microsoft Tools: MS Word, Excel, Project, Office, Outlook, SharePoint, Power point, Visio

WORK EXPERIENCE:

Confidential, Columbus, OH

Data Modeler

Responsibilities:

  • Designed Logical Data Model for Confidential (Home Confidential Disclosure Act) in order to be compliant with Fair Lending Practices mandated by Federal Government
  • Built Physical Data Models in Teradata and Hadoop in alignment with firms Data Management strategy
  • Facilitated Dimensional Data Modeling sessions with Confidential Business SME’s & Operations to gather BI data requirements. Built semantic data models used for analysis, dashboards, and reporting
  • Drove a portfolio of PI classification and Role Based Access Control across Confidential Line of business
  • Partnered with Metadata Governance Council to build an end to end lineage of an attribute in ecosystem of diverse systems, tools, and technologies
  • Contributed to Big Data Architecture for next generation enterprise data warehouse that comprises Hadoop and suite of BI & A tools for consumption, discovery, and self - servicing
  • Built DW BUS Matrix, ETL maps, Attribute Data Dictionary, and DDLs in order to pass DRB (Data Review Board) - firm’s Database Controls and Governance council
  • Crafted Logical & Physical data models for Auto LoB (Line of Business) to fulfil regulatory and compliance reporting requirements by BCBS (Basel Committee on Banking Supervision)

Confidential, Lake Forest, IL

Business Analyst

Responsibilities:

  • Led requirement gathering sessions with the Marketing team to analyze the current need of customers
  • Facilitated meetings with stakeholders and engineering team to conduct requirement feasibility and brain storm possible design options
  • Successfully negotiated the scope with senior leadership based on feasibility outcomes and value add
  • Conducted requirement walk-throughs and secured sign off from executive level stakeholders
  • Built use cases to validate the design and partnered with business to conduct UAT

Confidential, Columbus, OH

Lead Business Analyst

Responsibilities:

  • Conducted sessions with business and technology stake holders of each line of business to understand their function and prepared Business Requirement Documents (BRDs)
  • Acted as Data Analyst to collect, profile, analyze, and validate data needed to be attested for legal entity capabilities
  • Testing coordinator responsible to build and maintain test cases, document test plans, and track results and releases in ALM
  • Volunteered for an elevated role and acted as a PM to conduct weekly status meetings, document progress, and send status reports to leadership

Confidential

Business Analyst

Responsibilities:

  • Led requirement gathering sessions with business to understand their needs and prepared Business Requirements and Functional Specification documents (FSD)
  • Acted as a liaison between business and IT to ensure design conforms to business needs and meet essential quality standards
  • Served as a translator - prepared detailed specifications for application developers, assisted in clarifying discrepancies in requirements, validated source to target mappings, and helped design and test the user interface

Confidential

Business Analyst

Responsibilities:

  • Tasked to identify and engage application owners across all LOBs and educate/onboard them about migration from EDW to ICDW.
  • Conducted numerous working sessions with business / app owners to itemize, scope, schedule, and document the migration plan of each application
  • Single point of contact to coordinate and communicate the progress to senior leadership. Published weekly status reports and prepared executive level summaries using power points and pivot tables

Confidential

Business Analyst

Responsibilities:

  • Reverse engineered CDI data model and prepared ETL specs and mapping documents for IT
  • Performed Data Analysis and Data validation by writing simple SQL queries using Teradata SQL editor
  • Used Subversion and home grown ITSM (Information Technology Service Management) tool to manage change

Confidential

Business Analyst

Responsibilities:

  • Assisted senior BAs from LSS (Litigation Support Services) and RFS (Retail Financial Services) in conducting JAD sessions with business
  • Proposed a standard FSD template that was adopted as a basis for functional design across community of BAs from LSS, RFS, and Navigant.
  • Worked directly with business SMEs and application owners to build business glossary for end user consumption

Confidential

Business Analyst

Responsibilities:

  • Acted as a PM to prepare, monitor, and track plan to decommission schemas on the current production environment
  • Coordinated the effort to build an extra node on existing Informatica servers to accommodate new loans
  • Anchor to hold daily project status meetings with internal users and external vendors
  • Mentored users/customers/clients on ‘Archiving and Data Subset Services’ feature in Informatica ILM (Life Cycle Management) and TDM (Test Data Management) suite of tools
  • Authored Run Book and created a Functional Specification Document template that was adopted as a standard by Archiving team
  • Identified, proposed, instituted, and documented a cross functional process around ‘Archiving & Data Subset Services’ to provision production level data into lower environments Process resulted in significant efficiency gains reducing the cycle time from days to hours
  • Periodically published Dashboard reports on client issues - current status and future opportunities

Hire Now