SUMMARY:

• Confidential possesses over 19 years combined experience in public and private sector consulting and management in the areas of financial, commercial, federal, business, and marketing.
• He has specialized expertise in the areas of operations research and data analytics, Data modeling, Data governance, business intelligence, including ETL, visualizations utilizing various technical tools such as Tableau, Expert choice etc.

AREAS OF EXPERTISE:

• Data Warehouse/BI Development
• Data Profiling/Data Modeling
• Software Design and Development
• Data Conversion/Migration
• Data Analysis and Data Integrity
• Technical support and troubleshooting
• Database change management
• Meta Data Management
• Project/People Management
• Quality Control and Assurance
• Leadership and Team Building

WORK HISTORY:

BI Architect

Confidential, Washington, DC

Responsibilities:

• SME/Lead and Point of Contact for Data warehouse/BI deliverables & Support.
• Architected/Developed End - To-End BI Solutions from scratch.
• Worked on Data modeling implementing multiple data marts.
• Worked on Data profiling
• Worked on Source to Target Mapping from multiple sources within Confidential organizations.
• Created SQL Server Environment for AJI from scratch using AWS Cloud based Server
• Created ETL Architecture to pull/transform data from multiple sources which includes Pre-Stage, Stage, Warehouse and Data Mart
• Worked on SQL Server T-SQL (Stored Procedures/Functions/Triggers) which were utilized in SSIS Packages.
• Developed various visualizations/dashboards using Tableau 10.x Desktop/Server versions.
• Obtain MOU for Data consumption and verify compliance.
• Worked as a Tableau Site Administrator for AJI
• Worked on Development of Tableau Dashboards and assisted developers
• Worked on Performance tuning of Tableau Extracts/SQL Server.

BI Consultant

Confidential, Washington, DC

Responsibilities:

• SME and Point of Contact for Enterprise data warehouse deliverables & Support.
• Worked on Data modeling implementing multiple data marts.
• Worked on Source to Target Mapping from requirements.
• Worked on Large Data Migration/Conversion from Legacy to newly designed data marts
• Worked on SQL Server T-SQL (Stored Procedures/Functions) which were utilized in SSIS Packages.
• Worked on Data Validations in the Pre-Stage to Staging using SSIS/SQL and produce report to be sent for the source data team.
• Developed various visualizations/dashboards using Tableau 8.x/9.x/10.x Desktop/Server versions.
• Working on implementing Expert Choice - Decision making/Risk Assessment project.

BI Architect

Confidential, Arlington, VA

Responsibilities:

• Responsible for Overall Development effort for Expense Allocation Reporting/BI System.
• Business Objects 4.0 Installation and upgrade from 3.x to 4.x using upgrade management tool
• Responsible for Business Objects Report design (BOXI 3.X & 4.X), Universe Design, development & Unit Testing.
• Troubleshoot Issues and provide solutions for Business Objects Tickets created by the users.
• Established Data Architecture for ETL which includes Pre-State, Staging, Warehouse and Data Mart,
• Responsible for creating LOE, ETL and Business Objects Tasks.
• Designed/developed ETL data load in to data warehouse from various sources using Oracle PL/SQL.
• Worked on Data Validations in the Pre-Stage to Staging using Oracle/PL-SQL and produce report to be sent for the source data team.
• Developed Production Insertion Guides (PIG) for deploying ETL/Business Objects releases.
• Worked on ATO (Authority to Operate) for Oracle and Business Objects findings to comply with findings.

Data Warehouse/BI Architect

Confidential

Responsibilities:

• Worked with the Enterprise Data warehouse team as Data warehouse architect
• Established Data Architecture to create BI, ETL Standards and Procedures to meet Business Unit’s needs.
• Responsible for Requirements gathering, analysis, Design and Development of Star schema/Data Mart using ER/Studio.
• Responsible for creating LOE for the overall project.
• Responsible for Data profiling/Data Analysis, Data Governance and Data Cleansing.
• Worked on Data Mapping - Source to Target (Multiple Source to Target)
• Designed/developed ETL data load in to data warehouse from various sources using SQL Server/SSIS and performance tuning of ETL jobs.
• Worked on Meta Data Management for the Enterprise Data warehousing project.
• Designed and developed Business Objects Universe and reports using Webi reports.
• Provide troubleshooting and consulting services to the project team members.
• Responsible for Define and enforce common Data warehouse best practices.
• Provided support for Business Unit after the implementation.
• Developed Dashboards using Tableau for Data Analysis for Examiners/Analysts to analyze the Credit Under Writing Standards for National Banks.
• Worked on Tableau Desktop and Server versions. Which includes Dynamic/responsive dashboards based on selection.
• Responsible for Master Data Management Changes.
• Scheduled Tableau reports to be sent to examiners on a weekly basis.

ETL Lead/Architect

Confidential, Washington, DC

Responsibilities:

• Worked with the development team Confidential project for the Statistics Department of the Confidential
• Develop conceptual, logical and physical data models that reflect the requirements
• Responsible for Data profiling/Data Analysis and Data Governance and Data Cleansing.
• Responsible for Analysis, Architect, Design and Development of ETL using Business Objects Data Services (BODI/BODS).
• Managed team of 3 and responsible for assigning tasks, mentor, schedules and oversea staff performance.
• Define and implement Data Quality standards using Data Services Data Quality.
• Provide troubleshooting and consulting services to the project team members.
• Responsible for Define and enforce common ETL best practices.

Principal Technical Lead

Confidential, Vienna, VA

Responsibilities:

• Developed and Implemented Enterprise Software solution/Data Warehouse solutions and act as a Principal Technical lead for various projects.
• Worked as a Technical Lead/Manager on various Confidential project implementations.
• Expertise in modules like CRM, MRM, Membership, Subscription, Meetings, Products, Orders, Financials etc...
• Expertise in developing and customizing Confidential Batch processes using VB.Net
• Worked in various versions of Confidential and TIMMS (Legacy version of Confidential )
• Responsible for Analysis, Design, Development of Enterprise software application.
• Developed logical and physical data modeling of Data Warehouse solution for membership based associations using tools such as Business Objects.
• SME and Point of Contact for Commercial/Enterprise data warehouse deliverables & Support.
• Defined Data and Requirements based on Business Process and/or Business Requirements Analysis.
• Responsible for design and development of transactional database models for custom application development.
• Managed team of 1 to 10 and responsible for assigning tasks, mentor, schedules and oversea staff performance.
• Responsible for Writing Data Integrity scripts.
• Responsible for providing database implementation support for custom application development efforts and Perform operational data management for existing applications.
• Developed data conversion/migration tools and responsible for Data Conversion/Migration of large volumes of data using Data Integrator tool from Business Objects (ETL).
• Responsible for data reconciliation between integrated systems and converted database.
• Mentored programmers for project implementation and providing solutions to various projects when needed on unusually complex areas or problems.
• Prepared scope documents and estimates for Enterprise Software system.
• Developed Interfaces and testing of interfaces like USPS Group1, Oracle Financials, Great Plains, VeriSign Payment Server, Universal Payment Handler, Pitney Bowse Shipping, Pearson VUE, Boxwood etc.
• Involved in developing Data Conversion methodology for PA-DSS and PCI compliance, SSO and Identity Management.
• Designed and developed Data Replication of Confidential CRM with Gold Vision system using DTS/Oracle and SQL Server.
• Involved in the regression testing and unit testing of projects before major releases, preparation of test cases for unit and regression testing.
• Extensive experience in software tools such as SQL Server, Business Objects, Informatica, Oracle, T-SQL, SSIS/DTS, SQL, PL/SQL, VC++ and Pro *C
• Received Employee of the Quarter Award as a recognition for outstanding performance on multiple projects

Senior Programmer Analyst

Confidential

Responsibilities:

• Designed, Developed and Implemented Payment Gateway software system for Online Credit Card purchase. Implemented Payment Gateway in India and Czech Republic.
• Worked with VeriSign Web Security Analysts for Web Server/System Security.
• Developed batch processes for Credit Card settlement process (End-of-Day) using Software such as Oracle, PL/SQL, Pro*C under UNIX and Linux environments.
• Developed and Interfaces that are consumable by the external vendor and assisted in integrating applications.
• Involved in the regression testing and unit testing of projects before major releases, preparation of test cases for unit and regression testing.
• Involved in Performance tuning of the application and documentation of trouble-shooting.