We provide IT Staff Augmentation Services!

Enterprise Data Architect Resume

4.00/5 (Submit Your Rating)

Atlanta, GA

SUMMARY:

Seasoned professional with 11 years of IT experience in various domains and business processes and expert in database technologies, data modeling, data analysis and data - warehousing. Proficient in SQL, PLSQL, Erwin, Cognos reporting tool, Microsoft Office and managed/lead several BI projects to successful completion with reputed clients. Strong communication skill and fast learner.

PROFESSIONAL EXPERIENCE:

Confidential, ATLANTA, GA

Enterprise Data Architect

Responsibilities:

  • Understand business process and identify key data flow
  • Analyze source data, data integrity and granularity, involved in multiple session with source system teams to ensure data integrity and accuracy.
  • Logical and physical database designing in Erwin 9 and review with BA before detailed implementation
  • Involvement in database change impact analysis
  • Work with DBA team in implementing the same.
  • Work with ETL team in supporting for load and transform processes.

Confidential

BI Technology Lead

Responsibilities:

  • Identify basic requirements from stakeholders and prepare the business requirement document for signoff
  • Involvement in database change impact analysis and work with development team in implementing the same.
  • Cognos report layout design and necessary design documentation as per specifications
  • Deployment and testing support
  • Project status monitoring and driving status meetings with stakeholders regularly.

Confidential, DALLAS, TX

Data Analyst

Responsibilities:

  • Analysis of data from existing Teradata EDW
  • Identify the existing business logic of each data attributes and work with business users to identify the additional derivation logic
  • Device the final business logic using complex SQL that would be used by ETL team to implement mapping
  • Document finalized business requirement document
  • Write testing queries to be used post migration process

Confidential, NJ

BI Technology Lead

Responsibilities:

  • identify the basic requirements from stakeholders and document business requirement document
  • Cognos report layout design and manage turn-around time for each (performance tuning)
  • Database design changes for performance tuning and writing complex PLSQL stored procedure
  • Deployment and testing support
  • Scheduling of report based on need.
  • Project status monitoring and driving status meetings with stakeholders regularly.

Confidential

BI Technology Lead

Responsibilities:

  • Requirement gathering and analysis
  • Finalize Cognos report layout design and database enhancement design
  • Work with database team to identify report data availability in database, identify report dependencies
  • Report and database changes and unit testing
  • Regular project status monitoring and status reporting to client
  • Troubleshooting and root cause analysis during warranty support

Confidential

BI Technology Lead

Responsibilities:

  • identify the basic requirements from stakeholders and document business requirement document
  • Cognos report layout design and manage turn-around time for each (performance tuning)
  • Database design changes for performance tuning and writing complex PLSQL stored procedure
  • Deployment and testing support
  • Scheduling of report based on need.
  • Project status monitoring and driving status meetings with stakeholders regularly

Confidential

BI Technology Lead

Responsibilities:

  • Analyzing the data flow and granularity; Documentation of requirement clarifications from business users
  • OBI report layout designs as required and creating mockups to be signed off from selective business users
  • Working with data modeler for effective extraction, transformation and loading of data marts (Oracle) to be used for reporting purpose
  • Technical specification documentation and user manual preparation
  • Testing support

Confidential

BI Developer

Responsibilities:

  • Understanding of business requirements and changes required in database (Oracle)
  • Development of Oracle stored procedures and other complex database sql queries
  • Technical specification documentation code deployment, testing support

We'd love your feedback!