SUMMARY:

• Over 15+ years of IT experience as a Data Architect with deep knowledge in Infrastructure Architecture, Application Architecture, Data Architecture, Data Modeling, Database Analysis & Design, Development, Implementation, Documentation & Maintenance at various levels
• Well versed in SDLC to support Application Project Management (Agile/Scrum), Data Architecture, Database Administration, Tuning & Monitoring databases using CA ERWin, Embarcadero ER/Studio, Toad & OEM
• Hands on experience with Administration, Integration & Migration of Oracle, MS SQL Server & MS Access
• Create Conceptual / Logical / Physical data models for staging, data integration and reporting using relational or dimensional approach
• Provide hands - on data modeling / development support for a variety of applications and have a quick grasp of new business environments, conduct Technical Design & Development Reviews with project team members
• Developed MDM & RDM solutions addressing source identification, data collection, data transformation, normalization, rule administration, error detection and correction
• Perform data analysis activities including data profiling, data cleansing & creation of data dictionaries
• Hands On: Data Mapping, Data Validations wrt BRD (business/data requirements) as well as SRS
• Investigate, analyze and address reported defectsusing data cleansing techniques, code change, data updates, or configuration modifications while applying data standardization policies
• Lead requirements definition, analysis, and design of data related solutions,collaborate with ETL & DBA team to create data structures and analyze data sizing that facilitate data integration effort across organization
• Develop governance models, policies & procedures, data cleansing, migration, retention, data migration strategies and tasks for retiring legacy systems into modern information systems
• Identify, propose and influence IT and business solutions including hardware & software; ensuring effective use of technology to enable development and growth of the enterprise
• Exposure to development, implementation and maintenance of ERP solutions, including database application systems in Web Based, Client Server, Virtual, Cloud and High Performance Computing Environments
• Skilled in Enterprise Architecture Structures (The Open Group Architecture Framework - TOGAF)
• Excellent verbal, presentation, communication, time management and organizational skills. Proven team player with strong ability to multitask

TECHNICAL SKILLS:

Operating Systems: Red Hat Enterprise Linux, Windows Family

Databases: Oracle, MS SQL Server & MS Access

Tools: & Technologies: Oracle SQL Developer (PL/SQL), Oracle AS, Oracle Developer, Oracle Reports, Crystal Reports (Business Objects), OEM, TOAD, ERWin for Relational & Dimensional Modeling, ER/Studio, Optima, MS Visio, MS Project, Embarcadero Change Manager, SSIS, SSRS, QlikView, Shell Scripting, Autosys.

Domain Knowledge: Finance (Development Financial Institution & Commercial Banking), Healthcare, Insurance & Reinsurance, Telecommunication, Hospital Management, ERP, Entertainment, Customer Relation Management & Workflow Based Applications

PROFESSIONAL EXPERIENCE:

Confidential, NJ / NY

Architect

Responsibilities:

• I worked for various clients and developed/implemented the following applications:

Confidential, New York, NY & Berkeley Heights, NJ

Data Architect

Responsibilities:

• Customize, implement, analyze & support globally used multiple vendors’ Catastrophic Modeling scientific application software and hardware. Develop custom database in house software solution using ERWin and write ETL specifications for conversion of data (a.k.a Data Transformation) among different applications hosted on heterogeneous platforms using Agile methodology. Design the Software & Hardware Infrastructure including Application Architecture as part of the Global Exposure Solution for Multi-Vendor Expansion project, Center of Excellence & Probable Maximum Loss projects. Manage, plan and lead new release of hardware & software upgrades. Work directly with 3rd party vendors including ESRI, RMS, AIR, EQE, Dell, Trend Micro, Towers Watson and Microsoft for Tier 3 & Tier 4 support for resolution of complex ongoing issues and new initiatives. Conduct various Proof of Concept environments for ECM Igloo application.

Confidential, Morristown, NJ

Data Architect

Responsibilities:

• Analysis & Design (using ERWin) of Reinsurance Reporting Module and write ETL specifications for developers. Normalize bulk data coming from Insurance Universal Reporting System & Direct System Interface to make a Data Mart (Data Modeling) for use in company-wide reporting (Dimensional Modeling), using Oracle and SQL Server databases on heterogeneous platform using Agile approach.

Confidential, Morristown, NJ

Data Architect

Responsibilities:

• Analysis & Merge large quantities of data from numerous sources (Oracle, SQL Server, Spreadsheets, XML & Flat Files) into a single relational database (Data Modeling using ERWin) for use in company-wide reporting, using Oracle and SQL Server databases on Windows platform. An effective ETL process made the project successful while practicing Agile/Scrum.

Confidential, New York, N Y

Data Architect

Responsibilities:

• Automate & architect the ETL Process for Migration & Integration of Raw Data into the database to facilitate users see the data in a unified view (Data Modeling) using Agile. It enabled the higher management to do the Budgeting & Forecasting of Applications & Resources based on the data. The users could generate management reports like Timesheet, Head Count, Trend Analysis and Total Cost of Application used by the resources or the departments for further analysis.

Confidential, Rockleigh, NJ

Data Architect

Responsibilities:

• Analyzed, Designed & Developed Laboratory Ordering & Labeling System (Data Modeling) along with integration of HLAB Systems & Data Warehouse (Dimensional Modeling). The application is used to generate printing labels, order samples, track Confidential ts’ records and their draw test outcomes & results. Use of ERWin made easy to create & maintain the data dictionary.

Confidential, Montpelier, VT

Data Architect

Responsibilities:

• Performed data analysis activities including data profiling, creation of data dictionaries, data transformation rules and integration requirements. Migrated/Converted (Data Transformation) MS Access & Oracle Database to SQL Server databases (Data Modeling); converted Access/PDF Writer to Crystal Reporting to support end-user Sales Reporting in such a way that current environment was up and running and supportable until strategic database architecture project was completed.

Confidential, Lyndhurst, NJ

Data Architect

Responsibilities:

• Enabled the Supply Chain Management (SCM) Planners to handle Material Management (MM), built a Bill of Materials (BOM), created a Price Summary (PS) for Finished & Non-Finished Goods and provided an interface to SAP for loading the pricing tier.

Confidential

Sr. Software Engineer

Responsibilities:

• At the bank I successfully deployed & supported PIBAS (Pioneer International Banking Application System). I performed Implementation; End User s; provided the Backup Support for Core Banking; Online Banking; Signature Verification System; Loan & Micro Finance; Collateral Management System; Business Relationship Module; Test Key Generation System & Anti Money Laundering modules.

Confidential

Software/Database Developer

Responsibilities:

• Service Readiness Action System
• Acceptance Tracking & Monitoring System
• PMIS Ver. 2.0 & Ver. 3.0 (Project Management Information System)

Confidential

Software Engineer

Responsibilities:

• Fauji Software CompanySW-CMM Manual (in the light of SW - CMM up to Level 3)
• Confidential - RawalpindiBusiness Process Re-Engineering
• Confidential - LahoreHospital Management System
• Pakistan Institute of Medical ScienceSurgical Audit & Research System

Confidential

Database Consultant

Responsibilities:

• As my post graduate degree project I developed Confidential Information System ( Confidential ) for Confidential Pvt. Ltd. The successful implementation made