SUMMARY:

• Consummate DataWarehouse Architect with excellent written and verbal communication, expert in gaining information and knowledge from data as technical partner to the business.
• A problem solver and change agent, equally proficient with people, process and products to deliver right solution (or no solution) for the right problem. Expert in:
• OLAP / OLTP Data Governance Master Data Management (MDM) SOA
• Logical / Physical Data Models Dimensional / Star Schema Denormalized and Normalized
• ETL Architecture Tuning Oracle ERWIN INFORMATICA Netezza
• PL/SQL Packages Stored Procedures Materialized View Partitioning Bitmap Indexes
• Acquainted with Hadoop, Hive, Cassandra, and Data Virtualization
• Experienced in Finance, Banking, Healthcare, and Public Sector industries.

TECHNICAL SKILLS:

Database: Oracle 7.x - 11g, PL/SQL, SQL, MS SQL Server, Stored Procedures, Triggers

Big Data/Appliance: Hadoop, MapReduce, Hive, HDFS, Netezza, Cassandra

Case Tool/Method: ERWIN, PowerDesigner8, UML (use case, sequence, activity diagram), Rational Rose

Tools: Informatica, MS Project, SVN, TOAD, Oracle Developer, SQL-Programmer IX

PROFESSIONAL EXPERIENCE:

Confidential, WOODCLIFF LAKE, NJ

Data Warehouse/BI Lead

Responsibility:

• Lead Data Warehouse Center of Excellence for Data Warehousing and Business Intelligence
• Lead design of ETL generation platform to help non-ETL developers and auditors to participate in accelerating the development
• Explored use of Big Data and NoSQL technologies such as Hadoop, Hive and Cassandra for rewrite of the platform
• Led development of new Extract, Load, Transform (ELT) environment using Netezza TwinFin.
• Hands-on experience in creating KPI dashboard using QlikView
• Reverse engineered existing data model using ERWin to facilitate deeper discussions
• Helped establish naming conventions and setup efficient procedures to refactor in existing and newly developed code
• Guided development of tools to enforce commonality in development (e.g. database comparisons for common objects between the tracks; automated PK/FK/index generation scripts with option to override)
• Identified data discovery patterns used by ERP experts and exposed them to data discovery using QlikView. Also setup SQL template scripts to use for simpler scenarios thus reducing burden on onsite SQL developer.
• Reengineered development process by arranging Knowledge Transfer of existing SAP code by Confidential IT to help Orion teams working on revised SAP code and also Oracle EBS and Microsoft Dynamics Navision.
• Realigned SQL developer teams on basis of functionality rather than ERP to develop SMEs and realize benefits with quicker development cycles
• Provide guidance and expertise on SQL performance tuning to SQL development team.

Software: ERWIN, Oracle R11g, Netezza, QlikView, HBase, Hadoop, HDFS, Cassandra, MS Project, Aginity for Netezza

Confidential, NEW YORK, NY

Datawarehouse Architect

Responsibility:

• Extensive experience in logical and physical modeling using ERWin
• Led data governance, data quality, data modeling and data integration for a DW/BI
• Worked in both 3NF and Dimensional modeling approach.
• Member of architectural review board, responsible for ensuring that project teams adhered to architectural guidelines.
• Created and maintained enterprise data documentation, including data dictionaries, E/R diagrams, and data flow diagrams.
• Provide guidance and expertise on SQL performance tuning to SQL development team.
• Designed and developed several ETL mappings to load transactional data from OLTP databases to data warehouse database.
• Package the ETL code into deliverables and create Run Books
• Design Work Flows, Activity Hierarchies & Process Flows
• Design and schedule jobs through Autosys
• Data Cleaning, Validation and reconciliation with source system data
• Responsible for providing resource estimates and resource assignments based on project priorities.

Software: MS Project, ERWIN, Informatica, Autosys, Oracle, Netezza, Cognos, IBM MQ Series

Confidential, NEW YORK, NY

Project Lead

Responsibilities:

• Participate in Data Source analysis to understand the source system data and dig up relationships.
• Participate in and contribute to the development of traceability matrix (Source Target mapping) for data elements from source files to reports
• Liaise between ETL Team and business users to identify required data elements and incorporating them into the model & traceability matrix (Source Target Mapping). Secondary contributions to ETL Development using Informatica
• Implemented TIBCO MDM for standardization and consumption of master data by various IBK applications.
• Reverse engineered data model for OLTP applications from existing installation
• Oracle Database Tuning and Performance - usage of TKPROF and AWR
• Enhance the Business/Functional requirements and data models into ETL design
• Design and Build of ETL framework for source acceptance, staging, validation, exceptions, loads & reloads
• Conduct ETL design walkthroughs
• Build complex ETL’s for Type-2 Slowly Changing Dimensions
• Extensive use of triggers and packages in OLTP applications for state tracking, auditing and error logging
• Implemented access security based on complex business rules driven by data
• Data dictionary was queried every day to compare against changes made to the database objects and to back it up to SVN
• Through use of knowledge-share, role rotation, and effective use of Share Point; higher availability of contingent resources, motivated teams and increased product quality.

Software: MS Project, ERWIN, Informatica, TIBCO CIM (MDM), Oracle 10g/9i, PL/SQL, Visual Studio 2005, ASP.NET, C# 2.0, ADO.NET, SVN, IBM MQ, SOA

Confidential, Jersey City, NJ

Sr. Analyst

Responsibility:

• Helping DBAs in reducing their workload by automation (e.g. partition rollover script; parallel analyze script, loading script).
• Reduced monthly jobs run time up to 75% using process improvement.
• Introduce data warehousing concepts to team of frontend developers to train the mindset.
• Redesign crucial “transaction” tables in star schema format to gain simplicity and performance required for querying such tables.
• Used Oracle features such as analytical functions, partitioned tables, materialized views, Oracle collections, Bulk Fetch, Subquery Factoring
• Maintained E/R models for the Retail CAMP, Web CAMP, CAMP ARL.
• Defined database naming standards and created scripts to identify non-compliant DDLs.

Software: Project, ERWIN, Oracle 8i, PL/SQL, PowerBuilder

Confidential, FL

Application Development Manager

Responsibilities:

• Set-up multi-location team on Onsite - Offshore model.
• Heading multiple software development projects (both internal and outsourced).
• Project proposals, project and resource planning, client interaction, requirement gathering, functional and system architecture, test plan preparation, installation, post-production support.
• Creating class library or common code, setting up the environment, project scheduling and tracking, mentoring junior developers.
• Virtual Office for BCBS of FL
• Incentive Compensation System for BCBS of FL

Environment: Oracle 9i/8i, PL/SQL, ERWIN, PowerDesigner 8, ASP .NET, ASP, Visual Basic .NET/6.0, C#, ADO .NET, COM+, MS SQL Server, SQL Programmer IX, TOAD, PVCS, MS Visual SourceSafe, HTML/DHTML, PowerBuilder v6.5-8.x, MS Project, Windows NT/2000, AIX.