Database Architect / Technical Project Manager Resume

SUMMARY

Confidential 's degree in Computer Engineering with rich experience in delivering optimal results in database arena, project delivery & coordination, and business value in high - growth environments. Over 13 years in client-facing roles in USA, Canada and Ireland. Experience working with clients like Credit Suisse, CNN, KPMG, Delloitte and Touche, Tyson Foods, CNN, IBM and SeeBeyond Inc in Financial Services, Insurance, eLearning and Food Manufacturing domains.
Results driven and focused with immaculate work habits, people-management, time management and leadership skills.
Actively involved in architecting databases, map-gap analysis, mentoring junior teammates, development, analysis and estimations, and project management. Very good knowledge of project SDLC. Played various roles as Database Architect, Technical Consultant, Rollout, L3 Support and Implementation.

TECHNICAL SKILLS:

Data Modeling: ERwin

Language: SQL, PL/SQL, Shell

Database: Oracle, DB2

Management: Software Project Management, Project Delivery, Agile Methodologies

IDE: Eclipse

Source Control & Build Tools: SVN, CVS CAREER GLIMPSE

PROFESSIONAL EXPERIENCE

Confidential

Database Architect / Technical Project Manager

Responsibilities:

Conceptualizing and architecting the database in ERwin to suit business needs.
Developing data acquisition strategy to source data from heterogeneous sources for common consumption by management and regulatory reporting engines.
Coordinating with the customers for business requirement analysis and understanding technical & functional specifications to come up with an optimum database design.
Collaborating with major stakeholders and business analysts/SMEs to understand data requirements and conduct data-model walk-throughs.
Work closely with the ETL, UI and BI teams to make sure all relevant data is acquired, captured and reported as necessary to management.
Map and Gap analysis for data demand attributes
Maintain organizational naming standards
Performance tuning of critical batch modules.
Mentoring the team and set out performance parameters/deadlines, hold review meetings and monitor the progress of the deliverables as per schedule.
Carrying out analysis, development, and implementation of strategic business plans & policies.
Collaborating with major stakeholders.
Estimation for all technical streams and planning for new projects

Confidential

Data Architect

Responsibility:

Requirement analysis and estimation for new data demand requests
Map and Gap analysis for the data demand
Data modelling for the data demand using ERwin, and preparing DataBridge metadata to create subscriptions.
Deploying data model to development database to test data subscriptions.
Data modeling for Rule Automation to process Enrichment Rules
Managing Weekly deployments using RLM and Service Now

Confidential

Database Architect / Technical Project Manager

Responsibility:

Experience covers entire SDLC from requirement specifications, systems analysis, database design, construction, unit/module/integration testing and delivery in Waterfall/Iterative and Agile set-up. Support QA and UAT operations.
Extensive Data modeling using Erwin to capture all data requirements and reporting needs.
Performance tuning and continuous batch improvement.
Mentor junior team members on efficient PL/SQL coding.
Liaise with the onsite team to capture data requirements and clarify doubts on behalf of the offshore team.
Delegate development assignments to individual team members and review their code. Provide design details to team members and explain required functionality before assigning any development task.
Manage the project team. Track all KPIs, generate monthly time-sheets, invoicing and monthly reports.

Confidential

Database Architect

Responsibility:

Work with the SMEs to understand the functional requirements and implement them in the data model.
Estimate effort required for modeling the requirements and model the database in ERwin.
Delegate modeling work to team members.
Perform requirement and impact analysis for change requests.
Coordination and interaction with customer and business user community.
Guide the Tactical MI team to extract data from HiPLUS for MI reporting.