SUMMARY:

• I am a senior Analytics Solution Architect with 20 years of professional experience in Information technology.
• I have 15 years of experience providing analytical solutions to the Confidential and has spent the past four years as a senior architect for the Deputy Chief Management Officer (DCMO) and DCIO.
• I have detailed expertise in setting up analytics platforms and solutions, data warehousing and advance extract, transform, and load (ETL) and Data Integration processes.
• I have deep understanding of Confidential ’s Big Data Reference Architecture (BDRA) and have experience leveraging Watson Explorer Advance Analytics to develop analytic solutions for unstructured data content that transforms text into structured data that can be easily visualized in tools like Tableau.
• I have current Confidential secret and interim top - secret clearance.
• Finally, I am PMP certified from Project Management Institute and experienced in data analysis, requirements analysis, data quality, data governance, MDM system development, deployment and post implementation support.

SPECIALTIES:

• Solution Architecture.
• Watson Explorer Advance analytical components.
• Informatica PowerCenter and Data Quality.
• Informatica B2B Data Transformation.
• Informatica Master Data Management.
• ETL migration from Oracle PL/SQL to Informatica.
• Migration from SQL Server Integration services (SSIS) to Informatica.
• SQL server Polybase to extract data from Hadoop.
• Data warehousing.
• Project Management.
• Business Intelligence.
• SQL, T-SQL and PL/SQL.
• Unix Shell scripts.
• Oracle Development tools.
• Tableau Desktop

TECHNICAL SKILLS:

Advance Analytics: Watson Explorer.

Data warehousing: Informatica, Data Quality, MS SSIS, SQL server data tools, SQL server polybase.

Programming: PL/SQL, T-SQL, PL/SQL web toolkit, Unix shell scripts, DHTML.

Database Systems: Oracle 11g, Microsoft SQL Server, MS Access

Operating Systems: UNIX, Linux, Windows.

Development tools: Informatica PowerCenter, MS Visual Studio, MS management Studio, SQL Sentry, Oracle development tools, Oracle Discoverer, Toad, secure FTP, Tortoises SVN

Project Management: PMI Project Management Professional (PMP)

EXPERIENCE:

Confidential, Virginia

Solution Architect

Responsibilities:

• Supporting the Confidential Chief Information Officer ( Confidential CIO) as a Solution architect in the development of an enduring Advance analytics environment that will allow repeatable, verifiable analytics based of the Department’s Business Mission Area on the available IT enterprise services.
• I am supporting the IT Business Process and System Review ( Confidential ) team and Portfolio Analysis Division (PAD) to identify and analyze inefficient Confidential business processes and their IT systems, develop potential courses of action and solutions to resolve the identified inefficiencies, and determine the potential return on investment.
• Integrating and analyzing data from multiple Confidential IT systems, including DITPR, DITIP, SNAP-IT, DCIM, IBF-DAP, CAPE, ACBIS, FPDS-NG etc. Data integration is performed using MS SSIS, SQL data tools. Desperate source and destination types and formats used; including Oracle 11g, SQL Server 2012, xml and other unstructured formats like pdfs and text files.
• Watson Content analytics is used for advance analytics on structured data (database and XML) and unstructured data (pdf).
• Confidential studio is used for creating parsing rules and annotation to be exported to Confidential server.

Confidential, Reston, VA

Solution Architect

Responsibilities:

• Supported Confidential with improving end-to-end business processes and Planning, performance and assessment directorate (PPA) specific tasks.
• Created processes and metrics for measuring and tracking performance of Confidential agencies comparted to budget utilized. Created backend and front end architecture for capturing performance data from agencies and reporting to Confidential .
• Supported Confidential -MRA and EBI in specific task to address business capability gaps for the forward deployed war fighter. Data integration execution for current state operating model while designing solution towards the desired state.
• Designed and developed Operational Contract Support Drawdown Cell (OCSDC) Common Operating Picture (COP) Tool. The primary mission of the OCS DC COP tool was to provide a unified picture of contractor data and information pulled from SPOT and other geographically dispersed databases to present a cogent, simplified view of complex data sets to OCSDC and USFOR-A decision.
• Data transformation of XMLs from comptroller’s office for Budget data analysis. Working on architecture of Performance Management Analytics to integrate Budget Exhibits, EBAS, FPDS-NG, OP-5 etc.
• Data Integration, standardization and reporting based on contract activity across six Geographic Combatant Commands (AFRICOM, CENTCOM, EUCOM, PACOM, SOUTHCOM and NORTHCOM).

Environment: MS SSIS, Informatica PowerCenter, MS SQL Server, Tableau, visual studio, Management Studio, T-SQL

Confidential, Reston, VA

Technical Architecture Manager

Responsibilities:

• Data Warehouse/ETL design and development.
• Analyzed functional requirements, created mapping documentations.
• Informatica Administrator
• Design ETL and BI solution
• Mentored junior developers.
• Worked with architectural groups from different organizations and stakeholders to get consensus on design and to deliver effective solutions.
• Assisted in technical specifications and other deliverable documents
• Informatica Master Data Management.

Environment: Informatica PowerCenter 9, Informatica IDQ, Data Transformatioin, Linux, Oracle 11g.

Confidential, Falls Church, VA

Data Warehouse Architect

Responsibilities:

• Review customer’s current environment, perform Environment Sizing, Capacity planning and propose robust future Data Integration environments.
• Help customer layout blue-print of the end-to-end Data Integration infrastructure including hardware, software, services.
• Review and Analyze functional requirements, created mapping documents and using velocity methodology, assist in problem solving and trouble shooting.
• Designed ETL and BI solution.
• Created mapping template and mentored junior developers.
• Work with different application groups and architecture, design and deliver effective solutions.
• Assist in technical specifications and other deliverable documents
• Performance Tuning of Informatica Mappings, processes and load routines.
• Data Warehouse/ETL design and development.

Environment: Informatica 9 PowerCenter, Linux, Oracle 11g.

Confidential, Arlington, VA

Data Warehouse Manager

Responsibilities:

• Migrated data warehouse ETL process from Informatica to SQL server Integration Services (SSIS).
• New data model was created using star schema and snow flake schema. Converted all existing Informatica mappings, workflows, post and pre processes to SSIS packages.
• Used SQL Sentry for job scheduling.
• Led a team of developers to design and develop a new data warehouse based on new OLTP system migrated from legacy system.
• Designed and developed data warehouse concurrently while OLTP was being developed.
• Directed ETL and Reports developers to meet or exceed requirements.
• Received requirements and input from end users.
• Created data model using ErWin and MS Visio. Visual Source Safe and MS SharePoint were used for tracking and change management.

Environment: Informatica 8.1 server on Windows, MS SQL Server 2008, Reports Server, Hyperion.

Confidential, Herndon, VA

Sr. Consultant

Responsibilities:

• Led a software development team of 15 members. Designed and Developed ETL process for Confidential ’s Global Business Solution ( Confidential ) system to extract data from legacy systems and load into data warehouse.
• ETL system leveraged on Oracle external tables for loading source data.
• PL/SQL Bulk loading methods were used to improve load process time.
• Complex source data ranging from flat files to mainframe EBCDIC files were loaded into the Data warehouse.

Confidential, Washington, DC

Sr. Consultant

Responsibilities:

• Designed, developed and maintained ETL system for Veteran’s Benefits Administration VETSNET system.
• Mappings included complex transformations using parameters files and PL/SQL procedures.
• Created workflows for entire ETL process using complex sessions and Unix command tasks etc.
• Leveraged Oracle database and ETL process by using materialized views.
• Performed trouble shooting and performance analysis of existing mappings and overall ETL process.
• Created Unix shell scripts to automate tasks.
• Worked in a team environment to improve performance for some existing Informatica mappings.

Confidential, Fairfax, VA

Team Lead / ETL Architect

Responsibilities:

• Designed, developed and implemented a central automated management information system for all Confidential passenger travel data worldwide. Main responsibilities included design and development of multi-dimensional data model and ETL using Informatica PowerCenter 7.1.3. Oversee all phase of life cycle.
• Redesigned Interactive Training Web Application for NPDB-HIPDB (National Practitioner Data Bank, Healthcare Integrity and Protection Data Bank).
• Provided detailed impact analysis that outlines the resources required to develop a replacement Business Intelligence Solutions for the existing Confidential (Statistical collection) system for Confidential passenger movement statistical reports.
• Supported Passenger and Personal Property System Branch (PPPSB) by creating reports requested by Defense Travel System (DTS) and DoDIG.
• Supported PPPSB by analyzing large amount of passenger travel data received from Bank of America.
• Developed Business Intelligence platform for Surface Deployment and Distribution Command (SDDC).
• Developed and supported client-server and web applications for PPPSB.
• Developed and maintained Confidential System to supports the Directorate of Operations by producing Confidential passenger movement statistical reports.