Profile

I have over nineteen years of experience building information technology solutions with specialization in large and complex data centric projects involving enterprise data architecture, data warehousing, data integration, data mining, data prediction and data migration. I have extensive experience in designing and implementing enterprise class business solutions for both private and public sector enterprises with proven record of accomplishments in architecture, strategy, methodologies, processes, and program management.

Professional Experience

Sr. Data Architect Confidential

IGS Energy is an energy supplier Gas/Electric with over one million customers spread US wide. My responsibilities as a data architect included Strategy, Data Modeling, Design, Development and Planning of:

• Party Model: Master data management and consolidation of all customers, leads, prospects, companies or person, and contacts in one central location.
• Account Model: Master data management and consolidation of all accounts across all lines of business in one central location.
• Communication Model: Communication model stores and tracks all communication between IGS and Parties in one central location.
• Opportunities Model: Opportunities model stores and tracks all Opportunities for current and future customers in one central location.
• Data Matching: Researched several a data matching technologies Argo,IBM, and Others and finally recommended, acquired, and implemented MatchIt tools set.
• Modified/Customized Universal Data Models for IGS specific data requirements and needs.All the data models are in 3nf form and used model right for creating the data models.

Sr. Data Architect Confidential

Pondera solution is a leading provider of Fraud detection solution and they focus on finding Medicaid, Unemployment Insurance, Food stamps, SNAP, and other social programs fraud. My responsibility at Pondera included:

• Overall product vision and strategy
• Data acquisition strategy, design, implementation
• Design, Development of Pondera Enterprise Data Model
• Staging Layer Replica of source
• Integration Layer 3NF
• Computation Layer 3NF, Dimensional, and Star Schema
• Delivery Layer 3NF, Dimensional, and Star Schema
• Design, Development of the ETL
• Design, Development of Fraud Detection processes and routines using advance data mining and prediction technologies including Google Prediction API, Mahout, RapidMiner. Weka, R, Knimes, Clustering, market basket analysis, decision tress, and Logistic Regression.
• Mentoring, couching and training of Data Modelers and ETL developers.
• Design and Implementation of data exchange/integration with Experian, Dunn and Bradstreet, TLO Public and Criminal record search , Appriss Incarceration check and other third party data providers
• Design and implementation of Google Maps api integration for geo codes processing and address cleansing.
• Design and implementation of Google Prediction API for advance data mining and analytics.
• Over owner of Enterprise Data Model
• Technologies used: Oracle Database, SQL Server, SSIS, SSAS, SSRS, .Net, Google Prediction, Big Query, Map , Hadoop Platform Mahout, HDFS, Map-Reduce
• Data modeling for logical physical, databases with 3NF, Dimensional, and Star Schema

Sr. Data Architect Confidential

Capitol Impact is a Community Development Financial institution CDFI . I am responsible for managing and delivering the Information Assessment/Strategy project for Capitol Impact.

Deliverables:

• Enterprise level information and reporting requirements
• High level business process
• Enterprise Data Model in 3nf
• Strategy Document
• Enterprise Roadmap

BI Architect Specialist Confidential

Responsible for retail and whole-sale energy business units' data architecture, planning strategy for various OLTP projects, SaaS/cloud based projects and data warehousing. Working in conjunction with the enterprise architecture group, I owned the technology and process standardization, data modeling, design reviews, performance and capacity designs and overall business value from innovative pilots utilizing Big data and predictive analytics.

Sr. Solution Architect Confidential

Confidential

I served on multiple positions including Project Engineer and Database Administrator. Architected and developed application code deliverables as well as supported multiple development and clustered production n-tier web application systems for a Learning Management System and Learning Object Repository as part of QSI's Solutions Delivery.

Technology Manager Confidential

• As the technology Manager of Saber Government Solutions, I was responsible for driving the future technology direction, system architecture, technical implementation and governance of all the products and solutions for the division. Saber Government Solutions provided turnkey solutions for department of motor vehicle, child support, child care, unemployment insurance, and voter registration and campaign management. In March 2009, Saber was acquired by HP.
• Worked on several OLTP projects and was responsible for logical and physical data modelling in 3nf.
• Worked on several Data Warehousing projects was responsible for overall data architecture.
• Worked on several Dara Migration Projects and pioneered the use of ETL for data migration.
• I delivered the following projects during my 10 years at Saber:

Confidential

Role: Data Architect

• Michigan MI Business Applications Modernization BAM project was aimed at replacing Department of State's mainframe system with more modern .Net based solution. The new system's data architecture was based on Microsoft SQL Server database technology with 1000 database entities and more than 500 GB of data. BAM also has several, real-time and batch, data interfaces with internal and external agencies. BAM solution included implementation of real time operational reports and analytical reports based on historical data. My responsibilities included: Data Modeling and Interface Design
• Vermont VT Comet implementation project was aimed at implementing more modern .Net based DMV solution The Michigan and Vermont DMV solutions were developed simultaneously using reusable components. I was responsible for understanding the overlap between the two solutions and align the solution design for consistency of integration, reporting framework and data migration from their legacy systems

Confidential

Role: Project/Account Manager

As a Project Executive I was responsible for technical management and program management of the overall project. The Enterprise wide Invoice and Service management system EIM/ESM for the Executive Office of Health and Human Services for the Commonwealth provided a single agency-wide billing and reporting service for purchase of service provider networks within the state healthcare domain. Recruiting, staffing, design review, data modeling and the overall project delivery was my responsibility

Confidential

Role: Application Architect/PM

Employer Resources Information Center ERIC was a web based application being developed to replace the Employment Security Tax Accounting System ESTAS . The ERIC application improved business processes within the Bureau of Unemployment Compensation Tax. ERIC was developed using Java and SQL Stored Procedures. The database was DB2 running on an IBM z/OS mainframe interfacing with the application layer via IBM DB2 Connect services running on an IBM AIX server. I was the overall Architect and the Project Manager responsible for managing scope budget and staffing along with integration designs, mapping between mainframe and RDBMS as well as data migration at Go-Live

Confidential

Role: Application Architect/PM

I was responsible for the design, implementation and governance of the South Carolina child support. The system was developed using DOTNet Oracle. The data migration and testing of the two systems legacy new had to be done running in parallel and I designed the overall process and managed the successful execution and certification of data integrity for Go-Live. Also acted as the account manager working with the state government

Confidential

Role: Data Architect

As data architect I was responsible for overall design, implementation, and governance of the data architecture of the Help America Vote Act compliant voter registration and election management software. HP's enterprise-class voter registration and election management software provided voter list management and election management functionality for more than 40 million voters in the following states: Colorado, Idaho, Iowa, Maryland, Mississippi, Missouri, Montana, New Hampshire, New Jersey, New York, Oregon, Rhode Island and Wyoming. Overall, approximately one in five American voters registered using Saber's election software. This was built on Oracle cluster and I had a dual role as supporting and customization the client implementation as well as designing the data model for the voter application as a product

Confidential

Role: Data Architect

Strategy phase Worked with the LAUSD executives and mid management and developed the LAUSD business intelligence dash board strategy. Mr. Ahmed developed the LAUSD business intelligence dashboard strategy by analyzing shortcomings of current solution and future needs. The management approved the strategic approach and the solution phase commenced. The solution used Oracle BI Business Intelligence tool set Oracle OLAP Online analytical processing service and Oracle Discoverer/Drake , Oracle portal, and Single Sign On, which LAUSD is currently using. I was responsible for the data warehouse and the ETL design and development

Confidential

Role: Data Architect

• Strategy Phase Worked with Environmental ESD executive and senior staff to develop ESD data warehousing and business intelligence strategy.
• I lead the effort to create a data warehouse that kept track of the day-to-day activities of the Environmental Service Department ESD . This phase of the data warehouse provided data marts based on refuse collection business process to track and accurately report key performance indicators. This phase delivered accurate and useable analytics for the entire department with over 200 users.

Sr. Systems Analyst Confidential

Arbitron is a leading Radio Ratings Survey and Publishing Corporation. In the capacity of an Enterprise Data Architect, was responsible for building the ELDM, functional architecture, data modeling standards, metadata, development processes around data quality and integration. Arbitron was in a very data intensive industry and therefore laying down the foundation for a strong Enterprise Data Architecture discipline was the key. Frequently worked with senior management to ensure the data strategy's alignment with corporate strategy

Data Integration

Arbitron collects and purchases radio listening statistics and demographics from a variety of 3rd party sources. The data integration from all these sources and then storing that in a consistent manner without losing the value added information coming from vendors was a challenge. This was met by building an Enterprise Data Integration framework driven by metadata repository and supported by functional modeling of the data using Designer 2000. Extensive ER modeling in 3nf and data quality rules were designed and implemented to successfully achieve these tasks

Data Analysis Reporting

Once this data has been loaded into an integrated database, several business focused applications were developed using Developer 2000 for users to analyze and access this data. Responsible for the entire supply chain of data from user requirements to distributed storage and collection

Tools, Technology Skills