PROFILE:

A multi - skilled Data Warehouse Architect with comprehensive experience in designing, developing and administering cost-effective Enterprise Business Intelligence applications. Leadership of BI projects within complex client environments. Extensive qualifications in all facets of project lifecycle development. Integrates out-of-the-box thinking and problem-solving analysis to improve processes, systems and methodologies. Possess excellent project management, communication and team-building skills coupled with a passion for client satisfaction.

PROFESSIONAL SUMMARY:

• 15 years of overall IT experience
• 13 years of experience as a Data Warehouse Architect specializing in Business Intelligence and ETL development
• Experience with multiple verticals - Healthcare, Insurance, Finance, Pharmaceutical, Telecom, Sales & Marketing
• Architected data warehouse from requirements gathering to creation of data marts using Inmon and Kimball methodologies
• Experience in Enterprise Data Warehouse/DataMart Design, Enterprise Data Modelling, Data Quality and Data Governance
• Proficient in ETL development using various tools such as Informatica, SnapLogic and SQL Server Integration Services
• Experience in Query Optimization and Performance Tuning strategies
• Possess creative and analytical problem-solving skills to design innovative business and technical solutions

TECHNICAL SUMMARY:

ETL Tools: Informatica Power Center, SnapLogic, ODI 11g, Azure Data Factory, SSIS, Zeppelin Notebooks, PySpark

Business Intelligence Tools: OBIEE 11g/12c, OBIA 7, BI Publisher, Power BI, SSRS, Cognos Analytics

Visualization Tools: QlikView, Google Analytics

Virtualization Tools: Tibco TDV

Database: Oracle 12c/11g/10g/9i, SQL Server 2012/2017, IBM Netezza, Teradata 10, Sybase

Cloud Database: Amazon Redshift, Microsoft Azure Data warehouse, Apache Hive

Data Modeling Tools: ER Enterprise Studio, Erwin, Toad Data Modeler, Oracle Data Modeler

Development Tools: SQL Developer, Toad, SQL *Plus, Oracle JDeveloper

Oracle Fusion Middleware: Oracle WebCenter 11.x Spaces/Portal, Oracle Enterprise Manager, WebLogic

CRM Tools: Siebel Converge 6, Siebel 7.7 enterprise, Oracle EBS

Change & Defect Management: Win CVS, Visual source safe, HP Quality Center 10, Rational Quality Manager

Languages: C, C++, Java, Perl, AUTOIT scripting, Unix Shell Scripting

Web Technology: Oracle APEX, HTML, XML, Java Script, PHP

Operating Systems: Microsoft Windows, Linux, Unix

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Data Warehouse Architect

Hardware/Software: SnapLogic 4, SSIS, Visual Studio, Informatica Power Center, IBM Cognos Analytics, IBM Netezza, SQL Server, AWS RedShift

Responsibilities:

• Involved in gathering, understanding and validating the project requirements and specifications.
• Designed ETL architecture to move data from SQL Server OLTP sources to Netezza OLAP data warehouse.
• Created and executed Snaps to connect to Amazon Redshift cloud databases to extract data via pipelines.
• Developed SnapLogic pipelines to achieve data loads into target database tables.
• Created SSIS package to move patient record data to Insurance carriers in csv format via ftp on a monthly schedule.
• Customized existing Informatica power center mappings and altered transformations to add additional columns.
• Set up Audit tracking strategy for each new ETL development.
• Report Developer
• Participated in requirement validation sessions to understand reporting requirements.
• Designed Cognos reports using Report studio & Analysis studio per specifications.
• Developed List & Drill through reports.
• Created Ad-Hoc reports using Query studio.

Confidential

Sr. Data Warehouse Architect

Hardware/Software: Teradata Studio, Informatica Power Center, BTEQ utility, Unix

Responsibilities:

• Involved in meeting with the stakeholders and understanding the various validation issues currently being faced.
• Discovered the four mediums or channels of transactions AEO utilizes such as Store sales, online sales etc.
• Identified solutions for each of the validation issues being faced.
• Based on State and Local Tax laws, divided the sales transactions into taxable and nontaxable transactions.
• Designed staging tables on Teradata to load sales transaction and tax data into taxable and nontaxable tables.
• Wrote BTEQ scripts to load the 10 staging tables needed to process the ETL load into Vertex.
• Reconciled the tax summations with the General Ledger on store level and state level for every fiscal month.
• Designed ETL architecture to move sales transaction data from Teradata to Oracle using Informatica mappings and workflows.
• Utilized Mload capabilities of Teradata to do a write back update with status and errors after vertex processed the sales transactions during the daily load.
• Wrote unix scripts which processes the BTEQ scripts, ETL loads and the Mload updates in sequence.
• Fixed performance issues faced during ETL process by appropriately tuning SQL.
• Optimized Teradata stage tables by applying appropriate indexes.
• Documented entire solution and the operation of the various pieces as part of the hand off to the IT department at AEO.
• Supported the application and fixed defects and issues as raised.

Confidential

Sr. Data Engineer

Hardware/Software: SSIS, Azure Data Factory, Visual Studio, Tibco TDV, Tibco Spotfire, Tableau, Apace Hive, ER Enterprise Studio, SnapLogic, Zeppelin, PySpark, Python

Responsibilities:

• Analyzed existing data model and identified the data elements and redesigned the new data model for Hive.
• Used ER studio to connect to existing database and create Entity Relationships diagrams.
• Designed a conceptual, logical and physical database models in ER studio based on requirements.
• Big Data Architect
• Identified the third party data streams from financial services such as Refinitiv, Tax Reform, Maponics and Preqin.
• Designed and implemented Azure Blob storage to consume third party data periodically.
• Implement database solutions in Azure SQL Data Warehouse using Azure SQL
• Setup connections to Apache Hive for data to be migrated using zeppelin notebook PySpark code.
• Recreated existing ETL logic in the new environment using Azure Data Lake & Azure Data Factory.
• Utilized Tibco Data virtualization to create objects for easier access in various applications.
• Designed reports and graphs using visualization tools such as Tableau.
• ETL Architect
• Identified existing SSIS and Informatica ETL solutions in the older systems to be replaced in the newer environment.
• Established connection between Azure Blob storage and SnapLogic to facilitate ETL.
• Designed ETL code in SnapLogic to load data from various third party data streams.
• Coded in Zeppelin to load data from specific third party services by moving data and invoking SnapLogic pipelines.
• Developed python code to automate ETL from SQL Server tables to External Tables for staging and preprocessing.

Confidential

Data Warehouse Lead Architect

Hardware/Software: MS SQL Server 2017, SSIS, SSRS, SSAS, Power BI, Visual Studio 2017, SharePoint, Google Analytics, Windows 2017 Server.

Responsibilities:

• Lead Data Warehouse project at various stages from requirements gathering and business rules analysis from stakeholders to designing the physical warehouse and implementing reporting metadata.
• Utilized Normalization and Dimensional Modelling techniques to design the Star and Snowflake model.
• Instrumental in designing the processes and policies for an insurance Data Mart model for Confidential in SQL Server.
• Designed and developed the architecture for extraction, transformation and loading (ETL) on facts and related dimension tables using SQL Server Integration Services (SSIS).
• Developed, modified, and optimized complex queries for data retrieval from multiple sources to load the DW tables.
• Oversaw the Data Governance Policies and setup Data Quality Rules to consolidate data from multiple sources and eliminate duplicate member information.
• Implemented multiple levels of hierarchies to meet reporting requirements.
• Created and scheduled SQL jobs to run SSIS packages daily.
• Spearheaded the architectural design of the Marketing Analytics project.
• Configured multiple marketing data sources such as Google Analytics, LinkedIn, Twitter, Hootsuite.
• Consolidated source data to feed dimensional & fact tables using SSIS transformations and mappings.
• Developed Power BI reports and dashboards based on Google Analytics model for internal Marketing Analytics use.
• Database Administrator
• Installed, configured and maintained SQL Server 2017 on Development and Production environment.
• Created T-SQL scripts for tables, views, stored procedures, functions, triggers, indexes as necessary.
• Created and managed users, groups and permissions for access to the designed warehouse.
• Involved in monitoring and fine-tuning of database for better performance.

Confidential, Philadelphia, PA

Data Warehouse Architect

Hardware/Software: Informatica Power Center9.x, OBIEE 11g, OBIA 7.x, QlikView, Oracle 11g, Unix

Responsibilities:

• Implemented Oracle Business Intelligence Apps-HR Analytics using Informatica 9.5, DAC and OBIEE 11.x.
• Designed ETL customizations on facts and related dimension tables for SDE, SILOS & PLP mappings to load Oracle E-Business Suite (EBS) data into BI Data warehouse.
• Configured Informatica mappings in Data Warehouse Administration Console (DAC) to manage the data load process.
• Modified existing mappings to improve query performance and fix failures.
• Customized Business Model Layer, Presentation and Physical layer of the OBIEE repository to meet requirements.
• Implemented data-level, object level, user level security for HR analytics users.
• Created application roles, application policies in enterprise manager to map to the LDAP groups while implementing Single Sign On (SSO).
• Developed ad hoc reports, dashboards, drilldowns and scheduled delivery of the catalog objects using iBots.
• Deployed RPD and Catalog changes to the QA and Production environment.
• Enabled OBIEE usage tracking at the enterprise level for HR Department.
• Trained client on the use of OBIEE front end.
• Worked on creating data mart for applicant tracking system (ICIMS) involving reports & dashboards using QlikView.
• Implemented multiple levels of hierarchies to meet reporting requirements.
• Designed QlikView model to support various KPIs and time comparison.
• Integrated Applicant Tracking system (ICIMS/QlikView) with HR analytics to capture end to end employee information.
• ETL Architect
• Analyzed requirements and worked with the business teams to design ETL solutions.
• Designed Logical Data Model and Physical Data Model using Toad Data Modeler.
• Created Database schemas, tables, views, links, groups & stored procedures to implement the requirements.
• Modeled the business rules into mappings to load the target tables/files using Informatica 9.6.
• Utilized reusable transformations and mapplets to maintain development standards and manage audit tables.
• Developed various transformations like Joiner, Lookup, Router, Filter, Union, Aggregator, Sorter to build load strategies such as Append, Update & Truncate Reload.
• Developed Unix scripts as a part of post load process to move output files to desired destination via ftp.
• Maintained metadata, security and deployment of new code to QA/Prod environment using Repository Manager.
• Scheduled ETL jobs using Autosys by creating Job Information Language (JIL) scripts.
• Designed and Developed Unix script to automate Informatica code Migration involving minimal human intervention.
• Worked on Point of sale analytics project involving SnapLogic ETL tool.
• Configured ground plex and cloud plex nodes to use with pipelines.
• Developed various transformations based on business rules to load data into flat files.

Confidential, North Wales, PA

Business Intelligence Architect

Hardware/Software: OBIEE 11g, OBIA 7.x, Oracle 11g

Responsibilities:

• Participated in requirements gathering meetings to collect & streamline deliverables.
• Designed OBIEE metadata repository by designing the physical, business and presentation layers.
• Developed OBIEE reports to meet reporting requirements.
• Created OBIEE Dashboards with prompts, reports, graphs and drill downs.
• Designed reports in BI Publisher utilizing OBIEE metadata to burst output to multiple locations.
• Analyzed performance issues and design strategy to resolve at all levels.
• Provided support to business users on reported bugs and worked on debugging issues.

Confidential, Albany, NY

Data Warehouse Architect

Responsibilities:

• Modeled target data structures using ERwin data modeler.
• Custom built the ETL architecture and Source to Target mapping to load Hyperion data into Oracle Data Marts.
• Developed Informatica mappings with precomputed target columns for better query performance.
• Built various transformations strategies like Source Qualifier, Joiner, Router, Filter and Expression.
• Tuned performance of Informatica session for large data source by increasing block size, data cache size, sequence buffer length and target-based commit interval.
• Developed PL/SQL Procedures/Functions to build business rules to load data.
• Modified existing mappings for query performance enhancements.
• Database Performance Tuning Analyst
• Conducted Performance Review of Oracle Database for Tax audit queries.
• Utilized Explain Plan, Oracle hints and indexes to improve the performance of SQL statements.
• Analyzed SQL statements, reorganize database objects and design indexes to improve query response.
• Created and refresh materialized views.
• Implemented Database Partitions (List and Range partitions) to enable faster truncate of data subsets before ETL.
• Developed PL/SQL programs (Functions, Procedures, Packages and Triggers).
• Created Database links, Views, and Sequences.
• Managed users, granting and revoking rights as and when required

Confidential, Albany, NY

Business Intelligence Architect

Responsibilities:

• Developed OBIEE deliverables for the Research Foundation - State University of NY (SUNY)
• Participated in weekly meetings to establish requirements and deliverables.
• Collaborated with ETL developers to design database changes and load strategy.
• Developed OBIEE metadata repository by designing the physical, business and presentation layers.
• Developed OBIEE Dashboards with reports and prompts based on designed repository.
• Developed best practices including project plan development, defect resolution and code migration.
• Performed thorough unit testing on developed reports.
• Trained client on the use of OBIEE front end.
• Analyzed performance issues and design strategy to resolve at all levels (dashboards, repository and database).
• OBIEE Administrator
• Installed OBIEE components and updates on aix servers
• Maintained the enterprise BI server on different environments including Dev/QA/Prod. Setup and monitored usage. tracking and take necessary steps for performance improvement. Performed periodic upgrades and patches to fusion. middleware and relevant development tools.
• Updated and maintained custom OBIEE skins, cascading stylesheets, images and Javascripts.
• Created and manage users, roles, groups; assign permissions using WebLogic Enterprise Manager and Console.
• OBIEE Research Analyst
• Researched Oracle Business Intelligence Map Viewer and integrated custom Google map of NY state.
• Administrator for Map viewer configuration to test and deploy Map Data.
• Researched and developed BI Publisher to schedule and deliver reports to remote ftp site.
• Researched OBIEE SmartView as an alternative to BI Office tools.
• Researched ODI 12c and its features as an alternative to Informatica.
• ETL Architect
• Captured data structure metadata for target database using data modelling tool Erwin.
• Performed DDL operations to create database objects based on data model.
• Reused and shared model metadata using ERwin Model Mart.
• Designed ETL mapping to load data into Oracle Data warehouse using Informatica Power Center 9.6.
• Developed Source to Target mapping to load transactional data into Data warehouse.
• Implemented Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.

Confidential, Albany, NY

BI Technical Architect

Responsibilities:

• Researched Oracle Business Intelligence Publisher and develop report bursting solution. Trained developers to configure and implement BI Publisher and oversaw developed code. Created documentation for BI Publisher standards, best practices and common errors to avoid.
• Researched and developed WebCenter Spaces to host OBIEE reports. Setup connection to integrate OBIEE and Web Center. Developed Java code to allow ETL process to upload xml files onto Spaces using REST API. Implemented custom page templates with Javascript for visual effects.
• Researched Oracle APEX as a no-cost alternative for internal website development. Implemented an existing portal website using APEX.
• OBIEE Administrator
• Maintained and supervised the enterprise BI server on different environments including VM/Dev/QA/Prod. Setup and monitored usage tracking and take necessary steps for performance improvement. Performed periodic upgrades and patches to fusion middleware and relevant development tools.
• Updated and maintained custom OBIEE skins, cascading stylesheets, images and Javascripts.
• Performed technical code review for developers. Merged reviewed repository and catalog with Master Repository and performed the migration and deployment. Updated repository seeds for future development cycles.
• Implemented OBIEE content and data level security. Created and manage users, roles and groups; assigned permissions using WebLogic Enterprise Manager and Console.
• Developed and deployed WebCenter Spaces and sites to host various OBIEE dashboards.
• OBIEE Developer
• Developed current Oracle Discoverer portal reports in OBIEE 11g.
• Participated in functional design workshops to establish requirements and deliverables.
• Collaborated with data modelers and ETL developers to design and implement table structure changes and load strategy.
• Constructed end-to-end BI model from metadata repositories to reports. Developed OBIEE metadata repository by designing the physical, business and presentation layers. Developed OBIEE Dashboards with reports and prompts based on designed repository.
• Performed thorough unit testing on developed reports.

Confidential, Phoenix, AZ

DW Architect

Responsibilities:

• Project Leader for Data Warehouse and OBIEE Projects with American Express
• Directed the overall process of the migration of Sybase DW to Teradata DW from conception through deployment.
• Involved in requirement analysis, database design, coding, testing, implementation and maintenance of Teradata DW during the complete migration process.
• Communicate with the clients and business analysts and set realistic expectations towards project completion.
• Develop and design Extraction Transformation and loading of data from source systems into staging by applying various transformation rules.
• Used BTEQ, FLOAD, MLOAD Teradata utilities to export and load data to/from Flat files.
• Design the OBIEE metadata repository, configure the data model, web catalog objects and report dashboards.
• Coordinate with QA for test data setup during system testing, defect analysis, defect resolution and code review.
• Resource and task allocation and mentoring of the team.
• Conduct periodic review meetings to monitor progress of project and budget, as well as ensuring timely completion of the project and satisfaction of the client.