SUMMARY:

• Confidential has over twenty five year experience as a Data Warehouse Architect/Data Modeler and Business Intelligence ETL/Reporting implementation professional.
• Confidential has extensive experience in architecting and developing Data Warehousing and OLAP reporting solutions, logical/physical data modeling, database administration, ETL Design and development for relational and multi - dimensional databases for variety of projects. She has worked as a Data Architect/Data Modeler in diverse Industries (Pharmaceutical, Telecommunication, Health Care, Insurance and Finance) utilizing Azure Synapse, Azure Data Factory, Data Bricks, Business Objects,
• Tableau, Oracle, Microsoft SQL Server, Informatica, Data Stage, Erwin and RDA. Her functional experience includes the development of Business Requirements gathering, Systems Analysis, Design, Development, QA and Acceptance Testing and Production Deployment and Implementation. She has provided leadership, mentoring, and best practices to client development staff.
• Confidential continues to specialize in the functional, technical and the project management roles of the implementation of Data Warehouse and Business Intelligence Solutions.

TECHNICAL SKILLS:

Databases: Microsoft Azure Synapse, Azure SQL DB, Oracle 10g/9i/8i (SQL, OEM), Sybase, Microsoft SQL Server, Teradata, MS Access

Analytical Tools: Microsoft Power BI, Tableau, SAP Business Objects BI 4.2, Web Intelligence, Crystal Report, Microsoft SQL Server SSAS, SSRS, OLAP, OLTP, Toad

Data Integration Tools: Azure Data Factory, Azure Synapse, Informatica Powercenter9.2, Informatica IDQ, Autosys, SAP BODS, Microsoft SQL Server SSIS and Data Stage

Languages: SQL, PL/SQL, Python/Pyspark, DAX, Shell Scripting, JAVA, C/C++, VBA

Operating Systems: Azure Cloud Platform, UNIX, Windows Server, Windows NT

Other: Azure Data Lake, Git, Devops, Erwin, Power Designer, IBM RDA, MS Access

PROFESSIONAL EXPERIENCE:

Confidential

Senior Data Architect/Data Warehouse development lead

Responsibilities:

• Designed/developed Affinity data warehouse to support student claim data dashboard, using IBM Power Designer as data modeling tool, Microsoft Azure Synapse and Azure Data Factory as ETL/ELT tool, Data Bricks as data cleansing tool, Power BI as reporting tool. Have used Logic Apps for email distribution, Data Lake for source file storage, Git integration for version control, DevOps for release pipelines to automatically release code to next level environment.

Confidential

Senior Data Architect/Data Warehouse development lead

Responsibilities:

• Designed/developed Sales data warehouse using SSIS and PL/SQL to support dashboard view of sales data. Setup and maintain real time replication system using Mimix Share. Developed SSAS Cube to help data analysis.
• Designed/developed Inventory data warehouse using Toad as data modeling tool, Azure Data Factory and PL/SQL as ETL tool, Azure Trigger to schedule jobs. Control table design to control load/reload of data at any given time. Automated job load close to real time.
• Data governance from multiple data sources to ODS data center, ensure data integrity between source and target tables.
• Developed Sales/Inventory reports using Tableau.
• Worked with Tableau user group to collect requirement for Tableau extraction and migrate under new license framework. Help business users develop Tableau dashboard.
• Migrated Sales data warehouse from to Azure environment using Microsoft Azure Data Factory, Data Bricks, Data Lake and Power BI.

Confidential

Senior Data Architect/Data Warehouse development lead

Responsibilities:

• Designed/developed business object universes and reports for HR recruiting data warehouse to support high level management on recruiting need using SAP Business Objects BI 4.2. Supported daily ETL process from Peoplesoft into recruiting data warehouse in Sybase.
• Designed/developed Asian payroll reporting system using star schema in Sybase; Massive data profiling using IDQ (Analyst Tool) prior to data staging. Used IDQ to complete initial data profiling and removing duplicate data. ETL check points using control table; automated daily loads and backup files using Autosys job and shell scripting.
• Re-built HR recruiting data warehouse to get data from Taleo. Data element mapping between two systems as a business analyst; Implemented metadata standards, data governance and stewardship, row level security, data modeling/ETL best practice to pull Taleo data into recruiting data warehouse without impacting existing reports.
• Generated campus recruiting management dashboard and KPI Dashboard with quick/context/global filters, parameters, calculated fields, interactive views, trends and drill downs along with row level security using Tableau.

Confidential

Data Warehouse Analyst/Lead ETL Developer

Responsibilities:

• Lead data modeling and ETL architect in a data warehouse re-architecture effort. Involved in business requirements gathering, understanding pain points. Re-architected existing sales data mart to offer flexibility, extensibility, better hierarchy management and solutions to current reporting bottleneck.
• Designed/Developed ETL mapping processes populating existing sales data mart using Informatica 8.6. Involved in data discrepancies analysis and troubleshooting.

Confidential

Data Warehouse Analyst/Business Objects Universe/Cystal Report Developer

Responsibilities:

• Data analysis and data comparison between old system and new system.
• Universe design and report development to support a proof of concept of total report development estimate
• Report development for booking system using Crystal Report.

Confidential

Data Warehouse Architect/Designer and Lead Data Modeler/ETL Developer

Responsibilities:

• Designed multi-dimensional logical data model, data marts to support the new logistics system using Erwin 7.1.
• Created DDL from Erwin physical models and created physical tables in SQL Server using the DDLs.
• Designed ETL architecture guidelines, documented best practices to guide offshore ETL developers and developed ETL processes in tour subject area.

Confidential

BusinessObjects Designer/Developer

Responsibilities:

• Responsible for the design, development, implementation and administration of Data Warehouse and BusinessObjects Reporting tools throughout the organization. This includes database table and query design, extracts, data modeling, use of report query tools, BusinessObjects Universe design, and both web and desktop distribution.

Confidential

Production Server Infrastructure Support

Responsibilities:

• Helped developers with complicated universe and report issue. Maintained existing domains and create new domains when necessary, database connection management.
• Responsible for setting up and configuring production systems to support WebIntelligence and Broadcast Agent, identification and rectification of weak points in existing infrastructure.
• Monitored server performance; troubleshoot server issues and log-file/trace file analysis, development of more supportable, more resilient server environments. Upgrade server to newest server pack.
• Repository migration to Oracle 9i database.
• WEBi application customization using WEBi SDK in J2EE Environment.

Confidential

Lead Data Integrator Developer

Responsibilities:

• Developed ETL processes to load healthcare user claim historical data into data warehouse using SAP BODS.
• Automated the ETL processes using shell scripts.

Confidential

Lead Data Warehouse/Business Objects Developer

Responsibilities:

• Developing universes, reports for RRS for FCC and MPSC using Business Objects (designer, report writer, WEBi, and supervisor modules), PWE and ORACLE 8i.
• Scheduling of monthly production reports using Business Objects Broadcast Agent Server.
• Monitoring and checking daily load processes to UNIX based RRS ORACLE 8i database Staging area.
• Designed and developed time duration calculation database procedures using Oracle PL/SQL.

Confidential

Data Warehouse Developer

Responsibilities:

• Developed universes, reports and materials using Business Objects to support Animal Care research and manufactory.
• Developed the Yield data entry/ Tylosin Purification and Pen-V Purification application for Protein Development Manufacture using MS Access and ORACLE