Summary

• Over 20 years of experience in the Information technology Industry.
• Successfully managed projects by delivering quality solutions on time and within budget.
• Designed and built several RDB applications utilizing a structured methodology.
• Led Data Modelling design of six applications via JAD sessions and interviews.
• Performed extensive tuning of three applications achieving outstanding results.
• Expertise in architecting distributed, highly available, high performance, scalable solutions.
• Ability to combine strong analytical and communication skills with technical competence.
• Expertise in data modelling using ER/Studio, Erwin and Power designer tools.
• Expertise in implementation and design of electronic commerce applications.
• Expertise in OLAP, Data Warehouse Design, Modelling, DSS and ETL development.
• Expertise in Netezza Data Warehouse Appliance and Teradata data Warehouse.
• Administration of Software Configuration management and quality measurement tools.
• Expertise in Oracle, Teradata, Netezza and SQL Server database management.
• Expertise in Enterprise Data Architecture and Data Management.
• Expertise in Software life cycle development of RDBMS with emphasis on Oracle.
• Managed successful implementations of Oracle CRM, ERP and SCM Applications.

Areas of Specialization

Enterprise Architecture:

• Big Data Algorithm, Unstructured Datasets, Data Architecture, Data Governance, Master Data Management, Data Services, Data Warehouse, Data Marts, Logical and Physical Data Modeling and Business Intelligence.
• Applications:
• CRM, Financials, Manufacturing and Distribution.
• Business Processes:
• Customer Relationship Management, Financial Management, Procurement, and Order Fulfillment. Requirements Analysis, Gap Identification and business process mapping.
• Business Requirements:
• Business Process Modeling, Definition and Documentation

Technical Development:

• Hadoop, Oracle, Netezza, Teradata and SQL Server Database Administration, OEM, Netezza Performance Server Administration, Aginity, SQL, PL/SQL, SQL Loader, NZ SQL, SAS DIS, SAS EBI, Shell script, Oracle Discoverer, Workflow, EDI Gateway, XML Gateway, XML Message Designer, Informatica, ETL, OWB, Brio, Microsoft VSS, SCCS, Bugzilla, ER/Studio, Erwin and Power Designer.
• Change Management Processes:
• Systems Development Life Cycle and TAR/SR Management.

Confidential

• As a Data Architect, performing data analysis, data modelling for Digital Data Warehouse applications, ELT/ETL development, business intelligence reporting and database administration.
• Platform: Windows XP, Hadoop, HDFS, MapReduce, Hive, Pig, Java, Netezza, Oracle RDBMS 10g/11g, SQL Plus, ER/Studio Data Architect 9.0.1, SAS DIS 4.2, SQL Server, Pentaho, Netezza Performance Server, SQL, Aginity, and UNIX/Linux/AIX.
• Worked at the following clients as a Data Warehouse Consultant using various technologies:
• Designed the Data Warehouse Technical Framework and vision, delivered the blue print for EDW and scoping out the next steps. Reviewed JCAPS vs ETL tool in a buy vs build analysis and provided recommendations. Oracle database administration, provided data modelling advice, and leadership to the teams.

Confidential

Platforms and Technologies used: Windows XP, SUN Solaris SPARC 64 bit , Teradata, BTEQ, Fastload, MLoad utilities, Oracle RDBMS 11g,10g, SAP, Information Builder WebFocus, Data Migrator SQL Plus, ER/Studio, Erwin, Informatica Power Center 8.6, PL/SQL, SQL, and TOAD.

Confidential

• In the role of a director, managed teams and projects and provided direction for the senior data architects, and BI developers. Reported to the CIO, and performed project reviews with the IT and the business stakeholders. In the role of a Senior Data Architect in the Architecture group for the Resort Management System designed an ODS based on Subject area Enterprise Data Modeling. Performed Database design, development, Data Modeling, conceptual and logical solution and provided technical direction on architectures that address business requirements. Provided Information delivery roadmaps to the Senior IT Management on data services for the Data Warehouse, Data Marts and Business Intelligence programs. Designed OLAP Cubes, created materialized views and ODS objects to store consolidated and debugged transaction data.
• Platform: Windows 2003, UNIX, Oracle RDBMS 10G, ER/Studio, Power Designer, SQL Plus,
• TOAD, Developer 10G, Discoverer, Oracle Enterprise Manager, MS Project, Word, Excel and PowerPoint.

Confidential

• Worked at the following clients in the roles of an Oracle database developer consultant:
• Micros, and SF Water Management District
• Platforms and Technologies used: Windows XP, SUN Solaris, and Oracle RDBMS 10G, 9i, 8i, J2EE, Oracle Forms 6.0.8, Reports, PL/SQL, and SQL Plus, TOAD, Jinitiator, JDeveloper, HTML, XML, and SCCS.
• Confidential As a Team Lead and hands-on Techno/Functional developer implemented Oracle Applications, SFA, CRM, GL, AP, AR, FA, Oracle 9i Portal development, Custom Pharmacy and Medical Billing applications. Designed and Developed Custom extensions to Oracle Application Forms, Custom PLL, Oracle Reports, Workflow, JSP, JAVA, HTML, Discoverer Reports, extracts and loads for the Oracle Data Warehouse and EDI mappings. Worked with the Oracle Standard Public API's in Oracle Receivables. Created transactions XML files for the adjudication process and mapped data between XML schemas and DTD's, and Involved in the change control process, bug, enhancement and TAR/patching strategy. Platform: Wi ndows XP, LINUX, Oracle RDBMS 9.0.2, Oracle Applications version 11.5.9, AOL 11.5.0, JAVA, JSP, Oracle Forms 6.0.8, Reports, PL/SQL, SQL Plus, TOAD, Jinitiator, HTML, XML, Message Designer, XMLSPY, Oracle Developer Suite 10g, Developer 9i, Discoverer 9i, Workflow Builder 2.6.3, Microsoft VSS and Bugzilla. Confidential Worked as a team lead and a hands-on developer at the following clients: QualServ Corp and Aventine: Implemented Oracle Applications, designed and developed conversion data mappings, AR Invoice interfaces, standard API's, Payables Invoice Import to import expense reports, Inventory Items, Purchase Orders, Order Management and conversion load programs.

Confidential

• Responsible for benefits and New Matter Services modules in an Oracle 9i/Java environment. Performed installation, Repositories Configuration, Created mapping of OWB Process flows, implemented Configuration Management, change management, and performance
• tuning on OWB generated package. Created portal forms and integrated reports into the Oracle
• portal. Created workbooks, Business Areas and End User Layers for the business. Designed several reports for benefits Aetna Long term disability, health, dental, dependent, life, International life, and Partner Distribution. Managed a team of seven designers and developers.
• Platform: Windows 2000, SUN Solaris, Oracle9i, Oracle 9iAS, Oracle Portal 9.0.2.2.14, IASDB
• middle tier, SQL Navigator, Oracle Developer 9i Reports Server, JAVA, JSP, Citrix/Metaframe,
• Oracle Forms 9.02, SQL, PL/SQL, OWB, and Oracle Discoverer 9i Server Administrator, Desktop and iManage.

Confidential

• Worked as a Team lead and a hands-on developer at the following clients:
• Credit Acceptance Corporation - Managed a technical team of eight developers and worked with both business users and the IS team in an Application Outsourcing engagement. As a Team
• Lead, I Performed code walkthroughs, peer reviews, database design and development and the overall team management. Developed interfaces for the General Ledger, Payables, Receivables
• and integrated with the Loan Servicing System. Generated Financial Statements for the higher
• management using Financial Statement Generator FSG . Created Reports and performed analysis, budgeting and planning to manage and measure decisions across the enterprise using the Financial Analyzer. Built Summary, detailed, Lineage and Impact Analysis Reports and imported transferred data into Discoverer using Warehouse Builder.
• Platform: Windows 2000, HP UNIX, Oracle 9i, 9iAS, Oracle 11i, Oracle Applications 11.5.7, Auto
• Sys Job Scheduler, TOAD, SQL Navigator, AOL, Warehouse Builder, Oracle Discoverer 3.1, SQL
• Loader, PL/SQL, SQL, Forms 6i, Reports 6i, Oracle Financial Analyzer, FSG, Brio, Citrix
• Metaframe, and MKS.
• Blue Cross Blue Shield Worked in the role of a Data Architect, and was responsible for the CDW Data Warehouse Design and development. Designed a 20 Terabyte Enterprise data warehouse for BCBS to manage and analyze data effectively in a Complex, multi-tiered Environment. Designed and developed the data transformations for source system data extraction, data staging, movement and aggregation, information and analytics Delivery and handling data quality. Designed both logical and physical data models and used Baker and IDEF1X notations. Written UNIX shell scripts designed an error reporting utility and worked on the HIPPA project. Developed Custom Forms to input customer data and reports and administered SCM and quality measurement tools used throughout the Development lifecycle.
• Platform: Windows NT, IBM SP2-AIX 4.3.3, Oracle8i, Oracle Applications 11i V11.5.5 DB2,
• AS/400, BMC Control-M, SAS, TOAD, Warehouse Builder, Financial Analyzer, Discoverer 3.1,
• AbInitio, and PVCS.
• Worked as a consultant at the following clients in the role of an Oracle Consultant:

Confidential

• Platform and Technologies used: Windows NT, HP UNIX V11, Oracle8i V8.1.6.1.0, Oracle
• Applications 11i V11.5.2, Oracle Manufacturing 10.7 Forms 6.0, Reports 6.0, AOL 11.5.0, API's,
• EDI, OFA, PL/SQL, TOAD, Discoverer 2000, Flint60, HTML, JAVA and CCC Harvest 4.1.0 Client.