Enterprise Data Architect Resume
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
