SUMMARY:

• PMI certified Project Management Professional (PMP) with technical and project leadership expertise. Coordinated and conducted many brownbag sessions. Team player, with strong technical and management skills.
• Architected, designed and developed multiple OLTP applications, Operational Data Store, Integrated data store, Enterprise Data Warehouse, Data Marts and BI Solutions. Data expert specialized in the following Data Management areas:
• Big Data | Analytics | Business Intelligence | Enterprise Data Governance | Enterprise Data Warehousing
• Master Data Management | Data Integration | Data Quality Improvement | Enterprise Architecture
• Familiar with the fundamental concepts of various data warehouse platforms such as Teradata, Netezza, Hadoop (Big Data), various reporting tools. Performed reporting strategy study for the agency. Familiar with Insurance Application Architecture (IAA).

TECHNICAL SKILLS:

Operating Systems: MVS/ESA, UNIX, WINDOWS servers

RDBMS: ORACLE, SQL Server, DB2, PL/SQL, Transact SQL

Tools: Hadoop - HDFS, Pig, HBase,Java MapReduce, Shell Scripting (Perl, AWK), Python

ETL: Microsoft SSIS/DTS, Informatica, Oracle Data Integrator (ODI)

Data Modeling Tools: ERWIN, Embarcadero

BI Tools: Business Objects, Crystal Report, Oracle OBIEE, SSRS, SSAS

Visualization Tools: Xcelsius, Tableau

Programming: Java2, JavaServlets, JavaBeans, JSP, Applets, JDBC, JFC Swing, XML, UML, Enterprise Java Bean (EJB), Struts, Castor, Weblogic Server, WebSphere Server, Rational JAZZ, Tomcat, IIS, HTML, JavaScript, Active Server Pages (ASP), CICS, COBOL-VS II, CLIST, REXX, JCL, C, SQL

Tools: Visual Caf, Visual Age, Websphere Studio Application Developer (WSAD), Rational JAZZ

PROFESSIONAL EXPERIENCE:

Senior Data Architect

Confidential

Responsibilities:

• Developed architecture for Enterprise Data Management. Defined enterprise Data Governance strategy. Developed short term and long term technology roadmap. Developed security policy. Developed and maintained naming standards, subject areas, conceptual entities, data flows and meta data. Developed conceptual models, logical and physical data models.
• Instrumental in setting up Enterprise Data Governance practices. Worked as Prime Data Information Strategist withstakeholders/business decision makers and technology managers, Build relationships with business stakeholders and partner to understand information needs.
• Designed and implemented Data Warehouse SQL Server hardware architecture. Designed and implemented Business Objects hardware and software architecture. Designed and developed operational data store, integrated data store, enterprise data warehouse, data marts and business objects universes.
• Responsibilities included data profiling, data cleansing, and creation of analytical reports. Architected systems to empower business to dynamically create formula to derive financial elements and table driven data quality process to identify data issues.
• Designed and developed several ETL framework to support near real time data, Type 1, Type 2 and Type 3 data for warehouse and dimensional model data marts. ETL solution includes auditing, data quality framework, error handling framework, and notification framework.
• Architected, designed and implemented metadata solution. Developed Master Data Management solution.
• Data Warehouse/Data Marts/BI solutions were developed using Business Objects, Crystal Reports, xCelsius, SSRS and SSIS.
• Installed and configured Apache Hadoop, Hive and Pig environment on the prototype server. Configured SQL database to store Hive metadata. Loaded unstructured data into Hadoop File System (HDFS). Created ETL jobs to load data into the Data Warehouse. Created reports and dashboards using structured and unstructured data.

Solution Architect

Confidential

Responsibilities:

• Involved in business requirements collection, Data warehouse design, Report requirements, ETL development and Report Development. Designed and built data warehouse (MDD) using OBIEE 11g. Lead team and architected/designed MDD data warehouse. Created conceptual/logical/physical models.
• Developed ETL interfaces, packages, load plans using ODI (Oracle data Integrator). Migrated, built and managed OBIEE RPD - physical layer, business model, and presentation layer
• Manage user securities, group roles, and data access privileges within OBIEE 11g.

Chief Technical Officer

Confidential

Responsibilities:

• Created and implemented a back-up plan for all servers, databases, source code, project documents and repositories to prepare the company for Disaster Recovery. Also responsible for inventorying all hardware and software and assigning to staff as required. Trained project leads on CMM/CMMI and documented life cycle processes.
• As a Database Administrator for Verizon, performed analysis, design, backup/recovery and performance tuning of Oracle databases. Created various reports using PL/SQL and SQL*PLUS. Installed Oracle 9i and migrated databases from Oracle 8i to 9i. Tuned memory structures and SQL queries for optimal performance using Explain plan and optimizer parameters.
• As a Data Architect for Verizon, performed analysis and design for the Long Distance service request warehouse. Also designed various processes for loading data from the mainframe on a daily basis.
• As a senior consultant, responsible for developing websites for various commercial clients including Verizon, International Reading Association, Attorneys Healthcare Collections, Community Connections and Career Rewards. Websites were developed using J2EE, Java, JavaScript, EJB, JSP, Servlets, DB2, Tomcat and IIS. Responsibilities included data modeling, database design and creation, and performance tuning.

Programmer Analyst

Confidential

Responsibilities:

• Developed software for various IBM Mainframe and Intranet financial projects including Y2K, Common Account Maintenance (CAM), Guarantor Reporting, and Concord.
• The Guarantor Reporting system user interface was implemented using JSP & Servlets, Business Services & Data Services using JavaBeans.
• The Concord (Data Warehouse) system was designed to observe the customer profile changes and store the data used for analysis and marketing. The Data Propagator tool was used to identify changes in the data and Cobol programs processed data and wrote messages to MQ Series. These messages were sent to an NT Server where the MQSI application was running. MQSI converted the fixed format messages from Mainframe to XML format and wrote to MQ Series queues. These messages were read by a Java application running on a UNIX machine which parsed the XML message and updated the Concord database (DB2 UDB), used for analyzing the data.

Programmer Analyst

Confidential

Responsibilities:

• As a consultant for Confidential, maintained and enhanced various modules for the ATM debit card project. As a consultant for Discover, designed and developed software for the Merchant Transaction Logging, Editing & Reformatting (LEAR) project and the Settlement Calculation & Routing (SCAR) project. The system was developed in mainframe using Cobol 2 and JCL.

Project Leader

Confidential

Responsibilities:

• Responsible for the Accounts Payable and Purchase Order systems for the Y2K Mainframe conversion project. Performed analysis and code change review for COBOL programs and Millennium programs. Provided technical & application guidance to the team and also scheduled tasks and monitored progress of various activities.

Programmer Analyst / Team Leader

Confidential

Responsibilities:

• Performed analysis, enhancements, production support and scheduling of the Purchasing System and Inventory System. Performed analysis, specification development, testing and client technical reviews for the Electronic purchase order project. All of the systems were written in COBOL using CICS and DB2.