Database Architect / Technical Lead Resume FL - Hire IT People

SUMMARY:

Bachelor'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 Confidential.
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, MongoDB, DB2

Management: Software Project Management, Project Delivery, Agile Methodologies

IDE: Eclipse

Source Control & Build Tools: SVN, CVS

PROFESSIONAL EXPERIENCE:

Confidential

Database Architect / Technical Lead

Responsibilities:

Conceptualizing and architecting the database in ERwin to suit business needs.
Development of PL/SQL Packages, Procedures and Functions to meet business requirements.
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.

Confidential, FL

Database Architect

Responsibilities:

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, NY

Database Architect / Technical Project Manager

Responsibilities:

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

Sr. Database Modeler

Responsibilities:

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.

Confidential, Orlando, FL

Senior Consultant

Responsibilities:

Design, develop and maintain various modules of the Evolution LCMS application. Manage the data-movement module that helps exchange data between Evolution servers. Work with Support and QA to research issues reported by clients. Develop stored procedures and/or triggers for mass data updates as a one-time solution for various clients. Perform code optimization.

Confidential, LA, CA

Tech Lead

Responsibilities:

Design, develop and maintain various modules of the DataDental application. Worked extensively on creating the GUI screens using PowerBuilder 5.04. Maintain various modules in the Informix 4gl character based Unix interface. Research issues reported by clients and offer a feasible solution. Perform debugging, code optimization and documentation.