SUMMARY

• 19+ years of experience in database applications, enterprise data architecture and solution architecture.

• Strategic Database Architect with an extensive background in project management and delivery management. Expertise in DB performance tuning and database application development, extraction, transformation and load (ETL) techniques on various database platforms and operating systems.

• Expert level skill set on modeling tool Ervin and Power Designer.
• Full understanding of Hadoop Ecosystem and Implementation knowledge of Hadoop stack (MapReduce, Sqoop, Pig, Hive, HBase and other emerging technologies).
• Experience in Organization level data governance and data standardization processes.
• In - depth expertise in data security, storage solutions, database virtualization and replication as well as other sophisticated technical tools and solutions.
• Expert level skill set on implementation of Teradata Financial Services Data Model (FSDM) for Banking Domain.
• Undertook leading roles in planning; execution and management of several applications upgrade, inclusive of database upgrades.

PROFESSIONAL EXPERIENCE

Confidential - Mt. Laurel, NJ

Data architect/modeler

Responsibilities:

• Creates and maintains 70+ Physical Data Model on RRDW platform, using SAP Power Designer.
• Establishes data model governance, standards, policies and best practices for TD logical and physical models.
• Coordinates design and development effort from source to target Data Mappings for TD US Commercial Banking data sources such SHAW, ACBS, Lease Works, and LOAN IQ.
• Forms target physical mappings by analyzing the requirements for 800 + data elements based on business logic.
• Ensures built-in traceability to all requirements to the Core layer, and Core Extension view layer helping the testing and user community more easily identify data requirements.
• Collaborates with solution leads to multiple projects (RRDW W2, CL3, RLOS, IHC Liquidity) on the physical model, helping to adjust the model mappings as necessary based on changed requirements.
• Enables enhanced delivery of performance and customer experiences, suggesting alternatives to improve design.
• Manages project initiatives, directed assigned resources, communicated status and ensured timely issue escalation.
• Performs development Oracle DBA role on a daily basis to help 20 + team with various DB related Issues such as permissions, DB Links, query performance, deadlocks, data loading issues for SQL.
• Coordinates of all NPID requests for new schemas, service accounts, and user accounts and DB permissions
• Develops and implements Partition and Data Compression strategy for optimal database performance.
• Designs Oracle Schemas for performance, stability, scalability, reusability, and flexibility by incorporating the latest Oracle 12c Exadata features.
• Resolves production issues and troubleshoots production issues, working closely with production support team.
• Addresses design related issues/questions, and performance optimization issues related to data loads.
• Streamlines the code generation process from the PD model to ensure DDL generated from the model is 100% ready for migration, independent of any additional manual changes.
• Executes coordination of code migrations for all RRDW projects in a smooth, and efficient manner.

Confidential

Sr data architect/modeler

Responsibilities:

• Designed conceptual level of data models across projects; defined logical and physical data models and data mapping.
• Architected data solutions for DDEP services; monitored and identified issues and risks.
• Defined data landscape for projects direct channel projects.
• Facilitated scope and communications management; conducted risk identification and mitigation.
• Defined and prepared scope boundary with stakeholders and business leaders
• Performed in Scrum methodology, supporting sprint planning; participated in daily scrums, retrospectives, stakeholder meetings, and software demonstrations.

Confidential

Lead it data solutions consultant/architect

Responsibilities:

• Led 15 offshore team developers to develop ETL batch process to load the data feeds from other systems such as Enrollment, Workflow, Strategy, and KD into ML1 Reporting data mart.
• Provided translation of business and systems requirements for creation of the GIRT models, using Erwin.
• Studied and analyzed legacy data sources and created functional data mapping for the GIRT.
• Executed Reverse engineering of multiple data sources to define physical model specifications.
• Monitored and maintained application interaction with databases; led implementation to improve query response.
• Created metadata in Oracle DB to set report parameters, column names, column mappings and user permissions.
• Map sourced data elements from various systems, including IPX, KD(client data), Workflow, DQ, GDPP and EAO and develop, test, and support ETL load processes.
• Developed full-scale project plans and associated communications documents; estimated resources and participants needed to achieve project goals.

Confidential

LEGACY DATA/SOLUTION ARCHITECT

Responsibilities:

• Coordinated development, system testing and integration testing, working with team of 20-25 off-shore developers.
• Created DB models, process flow diagrams, data flow diagrams, and metadata management; used ERWIN and Visio.
• Developed 25+ SSIS (SQL Server Integration Services) Packages to replace Mainframe DB2 load/unload functionality.
• Produced over 35 SSRS (SQL Server Reporting Services) to replace the Mainframe based reports used to be generated by COBOL programs exclusively ran for this purpose.
• Collaborated with technology service group to create new websites for migrated CICS applications.
• Migrated mainframe jobs to run on Windows server environment using Neobatch.
• Coordinated with DBA’s to convert mainframe DB2 databases to SQL SERVER databases
• Utilized Autosys scheduler to create and monitor the job flows in the windows distributed environment.
• Established Oracle PL/SQL procedures, functions, views, packages to change RAS application interface from SAP to Oracle apps; Monitored and resolved the Legacy application performance issues.