SUMMARY

• 10 Years of experience in database development, data warehousing, data management, and design across Banking, Insurance, Finance, and retail commerce industries.
• Worked with several clients in creating a high performance analytical platform for business intelligence.
• Experienced in converting business objectives into information architecture.
• Experienced in implementing data governance principals by way of naming standards, entity relationships and semantic data models.
• Database Administratorwith SQL Server, Oracle,andNetezzaonIntel - Windows-Linux Platforms
• SeasonedDatabasedeveloperwith10Years of experience encompassing various Database andWarehouse projectsacross industry segments
• 5Yearsof Experience inData Management, Architecture and Modeling
• ExperiencedinKimball’s and Inmon’sMethodologies
• Developed Conceptual, Logical andPhysical models for OLTP and OLAP methodologies.
• Implemented Relational and Multi-dimensional models for data base and warehousing applications.
• Created Star Schemas for BIApplications.
• Converted data from one platform to another.
• Expert at Performance Tuning on RDBMS
• Implemented Server Clustering for failover safety for SQL Server Databases.
• Presented Database size estimations.
• Defined data transformation business rules.

TECHNICAL SKILLS

• Conceptual Modeling
• Relational Modeling
• Dimensional Modeling
• Logical Modeling
• Physical Modeling
• Kimball’smethodology
• Inmon’sMethodology
• SSIS
• Oracle10g/11i/12c
• SQL Server2005/2008 R2
• ERWIN
• Netezza
• Linux
• Microstrategy

PROFESSIONAL EXPERIENCE

Confidential, Wilmington, DE

Data Modeler

Responsibilities:

• Monitored and updated source, operational, data management access, and analytical layers of teh datawarehouse
• Monitored, updated, reverse-engineered and complete compared several models in OLTP systems
• Actively participated in JAD sessions with Java Architects, ETL Leads, and Technical Leads.
• Actively participated in grooming sessions with project team and business representatives
• Used Erwin 9.2 on a daily basis to create logical/physical models, followed corporate naming standards via classwords at teh entity and attribute level, custom designed physical traits of objects specific to teh rdbms they were being deployed in, updated .nsm file as required, maintained metadata at teh entity and attribute level, and delivered mapping documents to teh ETL team as needed.
• Represented teh data architecture group in a data governance project dat aimed to deliver an enterprise wide solution by integrating data from multiple payment processing merchants
• Modeled operational and analytical solution for CAD(Collision Avoidance Detection) System
• Modeled an end-to-end solution to capture system of records for PACE system
• Worked as an architect for Project Milestone which provided incentives for high risk customers. Teh solution was designed using Event Sourcing and CQRS as teh preferred methodology. Teh platform for teh required operation was Hadoop via SQOOP, PIG, and HIVE as a data store
• Worked as a modeler for Project Catalyst which involved integrating with a credit counseling company targeting high risk customers
• Worked as an architect/modeler for several Fraud Detection and Prevention related projects by working with processors such as TSYS CardGuard and partners such as Ethoca for CNP transactions
• Worked closely with production DBAs to monitor several OLTP databases ranging in size from GB and teh datawarehouse weighing in at 70 Tera Bytes. Teh environment was primarily Oracle 10g/11i

Confidential, Philadelphia, PA

Data Warehouse Architect

Responsibilities:

• Maintained teh physical Databases by monitoring Performance, Space utilization and Physical integrity
• Reverse Engineered existing source systems into Erwin Data Models.
• Reviewed business requirements documents and developed Conceptual, Logical and Physical Models using ERWIN.
• Facilitated JAD sessions to understand scope, capture business requirements and defined business rules.
• Developed a 3rd normal form relational database design for Operational Data Store(ODS).
• Developed three Data Marts with de-normalized table structures.(Monthly Sales, Customer Profitability and Campaign TEMPEffectiveness).
• Implemented integrated data repository and single version of teh truth approach.
• Designed teh Logical and Physical database architecture for Insurance business.
• Reviewed and improved existing Naming standards of Confidential Financial for implementation as “Best Practices”through .NSM file.
• Developed Subject Area Level, Conceptual Level and Key Based Models using ERWIN.
• Conceptualized teh Design & Development of semantic layer model for data access.
• Mentored application designers and business analysts in process modeling, application and presentation layer design and data conversion.
• Actively used salesforce.com to monitor data governance processes, usage and adoption at teh application level.
• Expert at using DMV’s for data profiling, analysis and performance tuning purposes.
• Analyzed long running/slow queries and tuned teh same to optimize application and system performance.
• Managed and scheduled daily jobs relating to data transfers, backup and recovery, and transaction log dumps.
• Used tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.

Confidential, Hopewell, NJ

SQL Server DBA

Responsibilities:

• Involved in teh requirement gathering and analysis of Executive Stock Options system.
• Helped design and develop teh EXSOP Data Model
• Administered SQL Server security by Creating User Logins with appropriate roles, monitoring user accounts, granting teh privileges to users and groups.
• Performed Full Backups and Transaction Log Backups, restore them whenever necessary and created back up strategies and scheduled them for execution.
• Applied teh Database Maintenance Wizard to make necessary changes and keep teh performance of teh server at acceptable levels.
• Created alerts, notification and emails for system errors, insufficient resources, fatal database errors, hardware errors.
• Migrating data from Access 2000/2003, Excel 97/2000/2003 to MS SQL server 2000 by using Export/Import wizard and create DTS packages.
• Wrote complex stored procedures as well as coding, creating tables, indexes, triggers and documentation.
• Used SSIS Package to transfer teh data from Production servers to teh Centralized server and used dat server for reporting purpose.
• Created complex SSIS packages dat deliver multiple data formats using LOOP and conditional sequential containers and .Net script tasks.
• Used SQL Profiler for root cause analysis and troubleshooting and resolved teh issue.
• Designed, modified, migrated, and normalized databases for real-time data collection. Imported and exported data into Microsoft Access databases and debugged VBA scripts linked to said databases.
• Worked with teh project management team to ensure teh quality and schedule of teh applications. Addressed and resolved internal and production issues.

Confidential - Jacksonville, FL

Oracle Applications System Administrator

Responsibilities:

• Administered over 350 users across several departments in 5 different locations in USA and Mexico including any functional users and developers as well.
• Extensively used SQL to write custom queries for various team leads.
• Communicated with teh functional users and teh developmental team to configure teh Daily Business Intelligence modules so Management could get their reports according to their business requirements without having overlapping/conflicting data according to SOX (Sarbanes-Oxley) regulations.
• Created application security for users by assigning roles and privileges.
• Running sessions with functional team leads, systems engineers and application developers to discuss and analyze teh transaction sizes, access paths and application code to ensure data access and database designs are efficient as possible.
• As an Applications System Administrator, worked on and resolved several user/technical related tickets on teh Confidential -Transportation ticketing system. When teh problems required further assistance, Tars (Technical Assistance Requests) were opened through an Oracle Meta link account and solved.
• Extensively used tools like Oracle Enterprise Manager, Oracle Applications Manager, SQL*Lab and TOAD for Performance monitoring. Teh environment was based on Oracle 9i.