SUMMARY

• Possess over 20 years of strong, comprehensive and in - depth experience in the Information Technology (IT) industry across the globe - U.S.A, United Kingdom, Japan and South-East Asia.
• Specialization and hands-on expertise in Business Intelligence, Data Analytics, Data warehousing, Data Analysis, Data Modeling, Data Integration, ETL, Reporting & OLAP areas with a flair of Data Quality improvement process.
• Expertise in working with top management executives, business sponsors, business users, stake holders and data stewards in collaboration with IT department.
• Experienced in managing and executing Enterprise level Data Warehouse and Data Management projects such as SAP Data Warehouse, Metadata Management, Data Migrations, Data Analytics, Data Visualizations, Data Integration, Data Quality and Data Profiling. Assisted Data Governance and Master Data Management(MDM) teams.
• Performed roles of a Data Architect, Data Modeler, BI/DW Consultant, Business Intelligence/Data Warehouse Developer, ETL Architect/Developer, Report Developer and Data Quality Analyst.
• Understanding of Big Data using Hadoop and other Cloud technologies using AWS and Azure.
• Worked in Insurance(P&C), Education, Retail, Healthcare, Finance and Banking domains.
• Fluency in Japanese language.

TECHNICAL SKILLS

Data Warehousing: Azure - Data Factory, Databricks, Data Lake, Data Catalog, Power BI, Tableau, Snowflake, SSIS, SSRS, SSAS, Informatica, Microstrategy, IBM DataStage, IBM QualityStage, Business Objects, Cognos.

Databases: CosmosDB, MS SQL Server, Netezza, Oracle, Sybase, Teradata, IBM DB2, MS Access

Data Modeling/Case Tools: ERWin, Navicat, Oracle SQL Data Modeler, SAP PowerDesigner, Rational Rose

Development/Productivity Tools: Business Intelligence Studio, Oracle SQL Developer, Oracle SQL Plus, TOAD, Aginity Workbench, AquaStudio, Visual Studio, Oracle Developer Suite.

Web Technologies & Programming Languages: PL/SQL, Unix Shell Scripts, C/C++, HTML, CGI, Perl Scripts, Visual Basic.

Domains: Banking, Healthcare, Finance, Insurance(P&C), Education and Retail.

Project and Content Management Tools: Confluence, Jira, Microsoft TFS (Team Foundation Server)

PROFESSIONAL EXPERIENCE

Senior Data Architect

Confidential, Richmond, VA

Responsibilities:

• Created conceptual data models which involved analyzing and profiling data sources from different source systems, identifying relationships and business keys for subject areas like Customer, Finance/Leasing, Banking Products, Mobile Deposits, Credit/Debit Card Controls, Online Account Openings, PPP(Pay-check Protection Program).
• For SBA-PPP and Credit Card Controls projects, processed Big Data using Azure Databricks.
• This Big Data was loaded into Azure Blob Storage and then processed using Azure Databricks to analyze and profile millions of rows.
• Created data visualizations like charts and graphs on raw Big Data using Azure Databricks.
• Created logical/physical data models and integrated these with existing enterprise data model.
• Forward engineered physical data model to create DDL scripts. Reverse engineered existing databases to create conceptual design.
• Built dimensional data model using star schema for subject areas of Customer, Banking Products, Leases, Loans and Deposits.
• Designed framework for Data Quality projects for federal regulations like AML/BSA(Anti Money Laundering-Bank Secrecy Act) which checked for the quality of data in the source systems.
• Leveraged Azure Data Catalog to ingest metadata and to create standard business definitions across the enterprise.
• Created Data Glossary which was searchable by the business users across the enterprise to understand the availability of data within the EDW.
• Interacted with business leaders, business users, data governance & MDM teams and helped developers in troubleshooting issues. Working in an Agile environment.

Environment: Azure - Data Factory, Data Lake, Databricks, Azure Data Catalog, Navicat Data Modeler, Microsoft - SQL Server, SSIS, SSRS, Power BI, TFS

Data Architect

Confidential, Richmond, VA

Responsibilities:

• As a BI/EDW Architect, worked on building an Enterprise wide data warehouse on Snowflake using Azure.
• Analyzed and profiled the source data in SAP-HANA and created data dictionaries, data mappings and lineage documents.
• Interacted with the business users to gather requirements and designed ETL specifications based on the business rules.
• Created logical and physical data models to hold data for subject areas like Purchase Orders, Contracts, Items, Sales, Rebates etc. and integrated them into the enterprise data warehouse.
• Built dimensional data model(star schema) for Purchase Orders, Sales and Rebate subject areas.
• Interacted with business leaders, IT teams, developers and other teams to educate them and understand the vision of the enterprise data warehouse and got them on board.
• Worked in an Agile environment and was involved in PI planning sessions.

Environment: Snowflake(on Azure), Tableau, Netezza, Aginity Workbench, SAP-HANA, Toad, Oracle SQL Data Modeler

Data Architect-Modeler

Confidential, Richmond, VA

Responsibilities:

• Interacted with Confidential regional executives and IT leads to understand their regional business needs. Built a road map for the RDW.
• Profiled source systems and assessed the data quality at source level. Made sure that data from multiple sources fits into the data model and then flows through the ETL’s.
• Analyzed source data and created source to target mapping document and data dictionary. Met with the business and designed the data transformation rules.
• Created logical and physical data models based on the data mapping, data profiling and data analysis results. Forward engineered physical data model to create DDL scripts.
• Created data lineage document showing the data flow from the source systems into the data warehouse and going into the data marts and other data access layers.
• Worked with Data Governance teams.

Environment: Azure - Data Factory, Data Lake, Databricks, CosmosDB, MS SQL Server, ER-Win, SSIS, SSAS, SSRS

Business Intelligence / Data Warehousing Consultant

Confidential, Houston, TX

Responsibilities:

• Provided Data Warehousing Architecture, Data Analysis, Data Modeling and ETL consulting along with the development of reports and dashboards for Confidential .
• Analyzed school and student data coming from sources such as Chancery and Grade Speed.
• Identified requirements and designed prototypes for dashboards using data visualization techniques.
• Designed the conceptual and logical data models. Designed new database structures, created data maps, data dictionaries and metadata repository.
• Provided Data Warehouse development methodology and created the architecture and dimensional model to support the dashboard requirements for Confidential .

Environment: Informatica PowerCenter 9, MS SQL Server 2012,ER-Win 7, Cognos 10.

Business Intelligence / Data Warehousing Consultant

Confidential, Dallas, TX

Responsibilities:

• Interacted with principals, teachers, school administrators to analyze and consolidate the requirements and presented them with different dashboard design ideas.
• Performed Dimensional Data modeling and created Star Schema data model to meet the OLAP needs.
• Created the ETL architecture for data integration and designed reports to be integrated into the final dashboards.
• Converted Informatica jobs into SSIS packages.
• Created job schedulers to execute SSIS packages based on file watch events, specific wait times and job dependencies.

Environment: Informatica PowerCenter 9, SSIS, MS SQL Server 2008, Microstrategy 8, ER-Win 6, Oracle 10g, DB2.

ETL Architect

Confidential, Richmond, VA

Responsibilities:

• Consulted as an ETL Architect and developed processes to extract, transform and integrate data into data warehouse.
• Designed ETL jobs for the data movement between source, staging and EDW area.
• Tuned ETL jobs and workflows to reduce the load time for sessions and workflows.
• Understood the requirements, analyzed the data in the current data warehouse and identified new sources that had to be pulled in and integrated them into existing data warehouse.
• Created and updated existing data models to accommodate new data warehouse reporting requirements.

Environment: Informatica PowerCenter 8, MS SQL Server 2000, Oracle 9i, ER-Win 6, DB2 UDB 8.1.

Data Warehouse Lead / Technical Lead

Confidential, Boise, ID

Responsibilities:

• Worked as a Data Quality consultant where the responsibility was to reduce the of loss of revenue in the refund process at the POS (Point Of Sale).
• Implemented a POS (Point of Sale) enhancement project which reduced millions of dollars in annual shrink associated with the refund process.
• Designed profiling techniques to identify data quality issues across different subject areas and helped data owners and data stewards realize issues in the quality of data.
• Presented data quality issues with recommendations to the business to improve the quality of data.
• Designed ETL jobs to and load cleansed data into the data warehouse.
• Updated data models based on the findings from data profiling.
• Developed Data Quality Monitors to monitor the quality of data over a period of time and analyzed the data trends.

Environment: Informatica PowerCenter 8, Informatica Data Explorer, Informatica Data Quality, Teradata V2R6, Teradata SQL Assistant 7.0, Teradata Fast Load & Fast Export Utilities, Unix, Shell Scripting, Oracle 10g, PL/SQL, MS SQL Server 2000. ER-Win 6.

Confidential, Federal Way, WA

Responsibilities:

• Functioned as Data Migration and Data Integration consultant for SAP data migration project to load legacy data into SAP data warehouse.
• Responsible for complete design and development of extraction routines from various source/Legacy systems pertaining to PR, FI-CO, PM, MM modules of SAP.
• Developed cleansing and extraction routines for Vendor Master data.

Environment: IBM ( Ascential ) DataStage 6.0 & IBM ( Ascential ) QualityStage 6.0, MS SQL Server, SAP PowerDesigner 9.5, SAP R/3, SAP BIW

Confidential, Portland, OR

Responsibilities:

• As a Team Leader, designed and developed the ETL frame work to load data into SAP data warehouse for a Decision Support System.
• Designed ETL jobs to load data from relational databases & flat files into SAP Targets-SAP BW.
• Implemented complex data transformation rules using PL/SQL.
• Designed Bex reports using Bex Analyzer.

Environment: Informatica 6.0, Oracle 8i, PL/SQL, SAP / SAP BW.

Confidential, Eden Prairie, MN

Responsibilities:

• Functioned as a Module Leader for an Enterprise Entertainment Portal.
• Involved in system study and requirement gathering to develop ETL jobs to load data from various sources into staging area and thereafter into the data warehouse.
• Designed shell scripts to massage source data files on the Unix box and developed cron jobs to execute Informatica sessions through Unix.

Environment: Informatica 6.0, Oracle, PL/SQL, UNIX, Maestro Scheduler.

Data Warehouse Consultant

Confidential

Responsibilities:

• Worked as a Data Warehouse consultant and designed a data warehouse solution by developing a “Digital Cockpit”.
• Created conceptual data model after the initial requirements gathering followed by creation of logical and physical data models.
• Designed a star schema model for this data warehouse solution.
• Developed data mappings and ETL transformations using Informatica to load aggregated data.
• Developed reports using Web-Charts (a chart displaying tool ) using Visual Basic as the programming language.

Environment: Informatica 5.0, Business Objects 5.0, ER-Win 3.5, Oracle

Confidential

Responsibilities:

• As a programmer/analyst, gathered requirements and created design specifications for the “Master DB” project.
• Developed pilot screens using Visual Basic as programming language and SQL Server as the database.

Environment: ER-Win 3.0, Visual Basic 5.0, SQL Server.

Confidential

Responsibilities:

• As a programmer/analyst, handled production support for CATS system.
• Managed support calls and tickets for production issues.
• Enhanced the CATS system to in corporate changes and new features.
• Made changes to existing database design to add new tables and make modifications to existing tables.

Environment: SQL Server 2000, MS Access.

Programmer/Analyst

Confidential

Responsibilities:

• Developed IMPACT, a network shopping system used in Accounting, Marketing and Sales.
• Responsible for initial requirement gathering.
• Developed the data flow diagrams and created specifications in Japanese.
• Created Visual Basic programs to manage the product inventory.

Environment: Visual Basic 5.0, Sybase.

Confidential

Responsibilities:

• Used HTML’s and product called "Webbase-2000", developed by Soft, Japan.
• Developed dynamic HTML's to access the database which stored the search results.

Environment: HTML, Web-Base 2000, Oracle.

Programmer

Confidential

Responsibilities:

• As a programmer, developed a CSS ( Control System Simulator ) system.
• Developed programs in C/C++ to send commands to the CSS.
• Developed socket programs in C/C++ to communicate CSS results to different units.

Environment: Microsoft C/C++ V4.0

Confidential

Responsibilities:

• As a programmer, developed Visual Basic programs for “Sampling Planner” system which was used to find out the sampling results before producing a product ( chip ).

Environment: Microsoft C/C++ V4.0