SUMMARY:

• Around 8 years of extensive experience in Oracle9i/10g/11g, MS SQL Server SQL Server 2005/2008 Data Modeler /Data Architect with major focus on ERWIN, Oracle 9i/10g/11g and Hadoop. 6 years of sound experience as a Data Modeler in financial sectors, insurance, marketing and IT. Sound knowledge of software development life cycle (SDLC) and agile methodology with substantial experience with object oriented analysis and design methodologies. Possess experience in independently handling design, development, documentation and testing phases in a project environment.
• Profound knowledge and Ability to convert requirements to design Normalizing and De - normalizing the tables and maintaining Referential Integrity by using Triggers, Primary and Foreign Keys. temporary tables, views, indexes, triggers when required and complex queries including correlated queries and queries with complex joins and aggregate functions. Expertise with DDL and DML statements, RDBMS’s, data dictionaries, normal forms and System Development Life Cycle (SDLC), Agile methodology.

WORK EXPERIENCE:

Confidential, Wilmington, DE

Data Modeler/Data Architecture

Responsibilities:

• Created conceptual design of the Enterprise platform, common for Consumer and Business Card offerings.
• Capable of processing large sets of structured, semi-structured and unstructured data and supporting systems application architecture
• Familiar with data architecture including data ingestion pipeline design, Hadoop information architecture, data modeling and data mining, machine learning and advanced data processing. Experience optimizing ETL workflow
• Data modeler for bank-wide Data Warehouse redesign effort. Designed universal Purging / Archiving strategy. prepare technical document based on requirements
• Involved in Impact analysis from data modeling perspective and production support for quality data loading and data governance on different application and systems at enterprise level
• In the Data modeler role, consulted various projects on physical database design and query tuning having the design sign-off by architects. Created ERDs for various projects subject areas and generated production DDL.
• Analyzed bank-wide privacy data access protection solution and data encryption approach, which was reviewed by VeriSign for PCI compliance and accepted as company standard.
• Maintained multiple architectural best practice and standards documents for database design and developments, including Data Modeling, Database Naming, PL/SQL Naming and Coding, DDL generation, indexing and partitioning.
• Represented Data modeling and Architecture as a member of Enterprise Architecture Workgroup

Environment: Oracle 10g/11g RAC, SQL / PL/SQL, ERwin 7.2/9, Ms Visio, ETL, Hadoop, MapReduce, HDFS, HBase, Hive, Pig, Sqoop.

Confidential, Farmington, MI

Software Programmer

Responsibilities:

• Interact with client and Customers for data processing and involved in all stages of Software development life cycle(SDLC) analysis, design, development, testing and Deployment Activities.
• Proactive monitoring for minimum downtime and troubleshoot bottom neck performance. Design and develop oracle objects and store procedure for frontend .NET application.
• Established naming standards, database software rollout procedure, proposed security schema, view creation policy. Managed and assigned multiple IT Help Desk requests.

Environment: Oracle 9i / 10g, SQL, PL/SQL, ERwin7.2, MS SQL and DTS on Windows 2000

Confidential, Southfield, Mi

Data Modeler

Responsibilities:

• In a true start-up opportunity, designed Operational and Data Warehouse Model from scratch and developed them into mature well-performing systems with over a hundred major tables.
• Designed and developed multiple key concepts for the Survey systems, Physician information, Rx and HCFA data, which defined insurance software systems and vocabulary.
• Responsible for presentations to Senior management. Participated in database design, application, disaster recovery / high availability planning, project management, ERP/3rd party software evaluation.

Environment: Oracle 9i/10g, MS SQL Server 2005,TOAD, SQL Navigator, ctrl M, Microsoft visio, Terradata, VB 6.0,Nasscom, IBM Rational, IBM web sphere

Confidential, Ann Arbor, MI

Data Modeler

Responsibilities:

• Created best practice and standards documents for database design and developments, including Data Modeling, Database Naming, DDL generation, indexing and partitioning.
• Analyzed and resolved complex technical problems, including performance tuning, and application design and debugging.
• Supported and Monitor administration, database backups and maintain recovery problems and followed Oracle Standards and other security standards
• Designed client and Customer Service support projects, which utilized .net and Java technologies with DTS (DTS packages) and transactional SQL language (T-SQL).
• Contributed to Information Management and Data Profiling initiatives creating road maps, time and back-end project management

Environment: MS SQL Server 2005/2008, Microsoft visio, Tortoise SVN, SQL * Loader, PL/SQL, Windows Server2003, SAINT, ETL Controller

Confidential, Woodland Hills, CA

Programmer Analyst

Responsibilities:

• Designed Logical and Physical Database design for various applications. Performed T-SQL System Administration functions, including device allocation, security, data loading.
• Used Erwin macro language to generate custom triggers to implement business rules and maintain referential integrity.
• Worked on the system performance tuning, including index selection, de-normalization, physical data placement.

Environment: Oracle10g,SQL Server 2005 Enterprise Edition, T-SQL, Enterprise manager, ERWIN, MS Office & Windows 2K platform.

Confidential

Data Analyst

Responsibilities:

• Analyzed all business functionality related to back end database interfaces
• Developed technical specifications for various back end modules from Business Principles.
• Specifications are made according to standard specification formats.
• Developed various Oracle sub functions like Stored Procedures, Functions, and Packages using PL/SQL as per the Design Documents.
• Involved in Monitoring Data Synchronization Through quarries and Triggers
• Participated in development of software to extend features

Environment: Oracle 9i, SQL*PLUS, SQL, C#, k-shell, SQL Developer, crystal reports.