We provide IT Staff Augmentation Services!

Data Architect, Data Modeler Resume

EXPERIENCE SUMMARY:

  • Over 15 years of IT experience in complete design and development lifecycle.
  • Hands on experience of Data Migration in Oracle and SQL Server data bases
  • Hands on experience of Informatica ETL Tool
  • Hands on experience of Application Migration in VB and .Net technologies
  • Worked in a variety of roles such as Data Modeler, Offshore & Onsite Team Lead, Application Architect and Data Architect.
  • Knowledge of Data warehousing, Health - Care, Insurance, CRM and Pharmacy domains.
  • Exposure to data modeling techniques and using data modeler tool like ERWIN and MS Visio
  • Designed and developed PL/SQL procedures, packages, triggers, functions, views, materialized views in Exadata, Oracle and SQL Server.
  • Performance tuning -
  • Application - Avoid memory leakage, Control binding & disposing objects and business logic implementation with proper coding standards.
  • Data bases - Create indexes, Query tuning, Query re-writing to improve performance, gather stats, DB health checkup, normalize / de-normalize data structures wherever required.
  • Excellent analytical and troubleshooting skills and ability to trace performance issue.

TECHNICAL SKILLS:

Operating Systems: Windows 7/2008/2007/2005/ NT/XP, UNIX, MS-DOS

ETL Tools: Informatica Power Center 9.1/8.6/8.5/8.1 (Designer, Workflow Manager, Workflow Monitor and Repository manager)

Programming Languages: C & C++, C#, VB 6.0, ASP, Microsoft Visual Studio .Net

Databases: Oracle Exadata, Oracle 11g/10g/9i, MS-SQL Server 2005/2003 and MS Access 2000/2003/2007

Programming Languages: Oracle Exadata, Oracle PL/SQL Programming, SQL, Stored procedures, functions, Triggers, Packages, C & C++, C#, VB 6.0, ASP, Microsoft Visual Studio .Net and XML

Technologies: Data warehousing, Enterprise Resource Planning (ERP), Relational Database Management Systems (RDBMS), Object Oriented Analysis & Design (OOAD), Client server Technology, Supply chain Management, Configuration and Web Application development

MIS Reporting Tools: Cognos 8.x: Learner, Crystal Reports and MS Access reports

Utilities: TOAD, SQL Developer, Control: M

Scripting Languages: VB Script, JavaScript, HTML, ERWIN, MS Visio, Health care, Pharmacy, CRM, Retail, HIPPA Eligibility Files, NCPDP Process

PROFESSIONAL EXPERIENCE:

Confidential

Tools: Toad, SQL Developer, ERWIN, MS Visio, HP Quality Center

Data Architect, Data Modeler

Responsibilities:

  • Analyze and document complex systems
  • Data Architect for the Oracle Data warehousing projects
  • Prepare Logical and Physical Data models, design Databases Architecture design document preparation
  • To design data model and consider performance parameters in an OLAP (Data warehousing & Business intelligence), OLTP (Data transition to one application to another) environment and minor enhancements within the project.
  • Application Detail design document preparation
  • Mitigate risks and ensure security
  • Handling the database team for the SDLC
  • Project planning and estimations.
  • Interact with business key stake holders to resolve queries raised by Dev team.
  • Do stop gap analysis
  • Data Migration.
  • Table Partition and Achieving.
  • Performance tuning - Suggested indexes and partitions, query tuning to improve performance, de-normalize data structures where required for performance.
  • Email sending functionality from Oracle stored procedures
  • File handling from database.
  • Delivered the deliverables on time with minimal or no defects.

Confidential

Operating System: Windows 7, Windows XPTools C#, ASP.Net, VB.Net, SQL Server 2008, SSAS, Toad, SQL Developer

Database: SQL Server 2008, Oracle 11g

Application (.Net) Architect, Data Architect, Data Modeler, ETL Lead and Offshore & Onsite Team Lead

Responsibilities:

  • To design data model and consider performance parameters in an OLAP (Data warehousing & Business intelligence), OLTP (Data transition to one application to another) environment and minor enhancements with in the project.
  • Prepare Logical and Physical Data models, design Databases
  • Involved in developing System configuration and transactional models by following data model standards and normalization
  • Data Migration.
  • Design and develop Oracle PL/SQL procedures, packages and triggers.
  • Created materialized views (snapshot replication schema) as required by the product management with an on demand refresh method.
  • Table Partition and Achieving.
  • Guidance to the team on writing oracle stored procedures and offer technical support to the team.
  • Performance tuning - Suggested indexes and partitions, query tuning to improve performance, de-normalize data structures where required for performance.
  • Databases health checkup, trace the database for slow running queries, provide the query statistics using explain plan and recommend appropriate indexes, optimizer hints for improving query performance.
  • Email sending functionality from Oracle stored procedures
  • Data Synchronization from four deferent servers into singly server.
  • CFS File (In-Bound and Out-Bound) processing logics.
  • File handling from database.
  • Monitoring informatica jobs and fix the issue due to data failures
  • Delivered the deliverables on time with minimal or no defects.
  • Gather requirements, Analyze, Design, Code, Test highly efficient and highly scalable integration solutions using Informatica, Oracle, SQL, Source systems Oracle10g, MS SQL server databases, flat files.
  • Responsible for Functional design, technical design, coding, testing, debugging, and documentation.
  • Design, development of mappings, transformations, sessions, workflows and ETL batch jobs, shell scripts to load data into Source/s to Stage, Datawarehousing &Datamart using Informatica, PL/SQL, Control - M scheduling.
  • Documentation of Source to Target matrix, mapping specifications, Mapping inventory, Unit test plans and data base sizing.
  • Migration of Informatica workflows using Informatica migration tool from Development to QA and Production
  • Created Informatica maps using various transformations like Web services consumer, XML, HTTP transformation, Source Qualifier, Expression, Look up, Stored procedure, Aggregate, Update Strategy, Joiner, Union, Filter and Router.
  • Adhere to Informatica SDLC, CDW standards, policies, procedures and industry best practices with respect to system design, architecture, naming and coding standards and system development lifecycle steps.
  • Worked closely with business application teams, business analysts, data architects, database administrators and BIS reporting teams to ensure the ETL solution meets business requirements. Performance improvement changes to the existing code of Informatica, queries using explain plan. Well versed with database partitioning and Informatica mappings performance improvement using partitioning. Processed large volumes of data and large files.
  • Scheduling the Informatica workflows using Control-M scheduling tool & trouble shooting the Informatica workflows.
  • Enhancing the existing mappings, workflows with new business requirements and Report the project status to the management
  • Also worked as post go live support/on-call production support consultant to monitor the production support applications.
  • Developed project plans with team members to ensure Informatica solutions are executed and delivered as per the plans with good quality. Mentor the team members in the design and development of mappings & workflows with onsite/offshore execution model.
  • To design data model and consider performance parameters in an OLAP (Datawarehousing & Business intelligence), OLTP (Data transition to one application to another) environment and minor enhancements with in the project.
  • Prepare Logical and Physical Data models, design Databases
  • Design and develop PL/SQL procedures, packages.
  • Guidance to the team on writing stored procedures and offer technical support to the team.
  • Performance tuning - Suggested indexes and partitions, query tuning to improve performance, de-normalize data structures where required for performance.
  • Databases health checkup, trace the database for slow running queries, provide the query statistics using explain plan and recommend appropriate indexes, optimizer hints for improving query performance.
  • SSAS development, data process and generate the reports as per business need.
  • Desktop application Migration for VB into .Net.
  • Designed and developed the business and data access framework
  • Designed and developed ASP.NET web assets including customer-facing web applications
  • Designed a services layer to simplify and standardize performance of all service ‘tasks’ and that would support the ability to plug into 3rd party systems
  • Defined, implemented and enforced development and design standards
  • Performed R&D, built prototypes and POCs to identify and roadmap relevant new technologies
  • Interviewed and hired a development organization of senior, top-notch software engineers
  • Delivered the deliverables on time with minimal or no defects.

Confidential, Westbury, NY

Operating System: Windows XP

Tools: Toad, VB.Net, ASP.Net, C#.Net

Database: Oracle 11g

Team Lead

Responsibilities:

  • Gather Requirement from client and Design the Application framework.
  • Design and develop the Data access layer for all modules with in the application.
  • Design and develop the basic reusable components across the application.
  • Guidance to the team on writing best practice code and offer technical support to the team.
  • Performance tuning - code optimization and tuning the application to better performance like blocking memory leakage and control binding and disposing.
  • Design & Business logic development using .Net technologies.

Confidential

Operating System: Windows XP

Tools: Toad, VB.Net, ASP.Net

Database: Oracle 11g

Module Lead

Responsibilities:

  • Development activity and Team handling.
  • Data Migration.
  • Design and develop the basic reusable components across the application
  • Design & Business logic development
  • Design and develop Oracle PL/SQL procedures, packages and triggers.
  • Guidance to the team on writing best practice code and offer technical support to the team.
  • Performance tuning - Both Front and Back end technologies. Suggested indexes and partitions, query tuning to improve performance, de-normalize data structures where required for performance.
  • Maintain Oracle 11g databases, trace the database for slow running queries, provide the query statistics using explain plan and recommend appropriate indexes, optimizer hints for improving query performance.

Confidential, Louisville

Operating System: Windows XP

Tools: Toad, VB.Net, ASP.Net

Database: Oracle 10g

Team Member

Responsibilities:

  • Control Data file Extraction Using Utility packages.
  • Performance tuning - Suggested indexes and partitions, query tuning to improve performance, de-normalize data structures where required for performance.
  • Maintain Oracle 10g databases, trace the database for slow running queries, provide the query statistics using explain plan and recommend appropriate indexes, optimizer hints for improving query performance
  • Design & Business logic development using .Net technologies.

Confidential, Louisville

Operating System: Windows XP

Tools: Toad, VB.Net, ASP.Net

Database: Oracle 10g

Team Member

Responsibilities:

  • Data Migration.
  • Design and develop Oracle PL/SQL procedures, packages and triggers.
  • Guidance to the team on writing oracle stored procedures and offer technical support to the team.
  • Performance tuning - Suggested indexes and partitions, query tuning to improve performance, de-normalize data structures where required for performance.
  • Maintain Oracle 10g databases, trace the database for slow running queries, provide the query statistics using explain plan and recommend appropriate indexes, optimizer hints for improving query performance
  • Design & Business logic development using .Net technologies.

Hire Now