SUMMARY

• TOGAF(9) certified Data, Solution and Enterprise Architect wif AWS / Azure Cloud and Project Manager experience in data governance, ETRM (Solarc Right Angle) solutions and fifteen years’ experience in managing, designing and implementing applications and systems wif web - enabled, REST and client server technologies and relational databases (on Redshift, Oracle/UNIX, DB2, SQL Server and Teradata platforms).
• 4 years of Ab-initio experience, 2.5 years of Informatica and 1 year in OWB to implement high performance integration for data warehouses and 5 years of Business Objects.
• 3+ years’ experience in SAS DM Studio (Dataflux) and IBM Optim (TDM and archiving) and 3+ years in Tableau reporting/Power BI dashboards.
• Worked on System Architect and Orbus iServer for EA.
• Built datamarts leveraging Databricks, EventHub and Python for Marketing, Financial and Sales CRM databases in Oil/Gas, Financial, Retail, Healthcare and Telco industrial areas.
• Specialization in Business Intelligence Customer Relationship Management (CRM) including Salesforce, Data Warehousing, Data Mining and Oracle Financial Applications.
• Worked wif JIRA for issue and time management.
• Strong technical and communication skills. Goal oriented, client focused, team player and bottom line oriented.
• Published two research papers in international computer journals.
• Managed and delivered US$10+ million solutions to customers and have generated multimillion dollar sales for consulting companies.

TECHNICAL SKILLS

• Languages Python, Angular, Ab-initio, C, C++, ProC, PL/SQL, Pascal, FORTRAN, Basic
• Operating Systems Sun SOLARIS, HP-UX, AIX, WINDOWS, DOS
• Platforms IBM RISC/6000, SPARC 630 MP, SPARC 2000, IBM x86, HP 9000, Sequent SE 80, NUMA-Q, NT
• Network TCP/IP, UDP, Client-Server, FIFOS, Semaphores, ESCON
• Database Oracle, SQL Server, DB2, Teradata
• Tools ER/Studio, ERWIN, Business Objects, Cognos, Discoverer, Ab-initio, Informatica, Oracle Warehouse Builder, Dataflux, Optim, Orbus iServer, Tableau, Alteryx, Power BI, JIRA

PROFESSIONAL EXPERIENCE

Confidential

Enterprise Architect

Responsibilities:

• Architected end-to-end SAP (S4/HANA) Finance for global solution - lead teh data migration, integration and reporting/analytics workstream to develop Architecture and Strategy for global implementation. Used Azure Data Lake, Databricks and ADF as part of teh platform. In addition, leveraged MuleSoft connectors to deliver near real-time data integration from S4/HANA. Created Integration Design patterns and decision tree for teh program including IIB, Mulesoft, Pub/Sub, API, etc. Used Power BI and FiorI for developing reports
• Engaged wif CFO and VPs of business to build solutions dat would enhance teh retail landscape

Confidential, Houston, TX

Sr. Solutions Architect

Responsibilities:

• For Academy Sports + Outdoors (Retail company), implemented Riversand MDM SaaS solution on Azure using EventHub, Apache Kafka and DB wif Python. Leveraged Azure BLOB for storage.
• Lead team of 10 designers/developers/BAs/QA to gather business requirements, develop user stories (JIRA), and quick (less TEMPthan 4 months) implementation of MDM PIM solution on SaaS.
• Integration using ETL and hub/spokes architecture implemented and Data Migration aspects designed and implemented in short period.
• Developed Conceptual/Logical data model as well as reference data in teh system.
• Implemented Python AI and ML libraries to normalize attributes like color/size/etc. based on web scraped data over teh web. Also created taxonomy using AI/ML.
• Stood up Informatica practice and delivered data management strategy for teh company. Involved in presales and solutioning for myriad customers

Confidential, Houston, TX

Enterprise Data Architect

Responsibilities:

• Architecture developed on AWS Redshift using S3 Data Lake as teh source from a variety of systems. Used Informatica and AWS Kinesis to integrate. iDQ for data quality and Tableau for dashboard reporting.
• Stibo Master Data Management solution for Product/Vendor enhanced. Created customer Master data solution for sourcing 25 systems in Federated MDM solution using Stibo and integrated wif Salesforce.
• Worked wif Data Science team to develop forecasting models and built Ontologies and knowledge graphs for customer information
• Developed Conceptual/Logical data model for Enterprise Data Architecture. Build integration patterns for batch/real time integration to leverage standards
• Used Feld Enterprise Architecture framework to come up wif target state Data and Integration Architecture
• Modeled Canonical Model in ER/Studio for integration in near real time using Mulesoft, Kinesis on AWS.

Confidential, Houston, TX

Lead Enterprise Architect/Sr. Manager

Responsibilities:

• Established Enterprise Architecture across teh Enterprise for Business, Application, Information, Integration, Technology and Security Architecture. Setup Review Board and Governance around teh EA practice including setting up standards and principles for teh company. In addition selected EA tool Orbus iServer to build EA repository to include business processes and TOGAF viewpoints for teh CIO and CxO level executives. Setup Segment Architectures including baseline and target for Information, Business and Application Architecture dat fed teh Reference Architecture repository. Mapped Technical architecture like servers/databases to teh Applications which map to teh Business Functions for TCO and chargeback to teh departments.
• Used Power BI for building Dashboards on analytics data mart and integrated data using Dell Boomi and SSIS from diverse sources into teh system repository including Cloud applications like ADP, ServiceNow, etc. Established business case for Master Data Management and created roadmap
• Led teh implementation of Power BI from POC to a full-fledged Power BI environment at Confidential . Power BI was initially used in isolated pockets wifin teh company as a desktop tool. Established teh Power BI environments (dev/qa/prod) and connected via gateway software to teh Cloud and mobile environments. dis enabled teh subscription and sharing of dashboards company wide
• Created Strategy documents for Self Service BI, Cloud (Amazon v/s Azure), etc. to facilitate decision making. Helped decide replacing SAP for Mainframe SCM in 12 weeks project. Worked wif multiple vendors to decide teh best integration platform for teh company and selected Dell Boomi. In addition, established standards for teh company. Migrated onprem applications to AWS and also from AWS to onprem where necessary.

Confidential, Houston, TX

Enterprise Architect/Data Architect

Responsibilities:

• Setup Enterprise Architecture across teh Enterprise for Business, Application, Information, Integration, Technology and Security Architecture.
• Setup Review Board and Governance around teh EA practice including setting up standards and principles for teh company.
• In addition build Orbus iServer based EA repository to include business processes and TOGAF viewpoints for teh CIO and CxO level executives.
• Also, worked towards an Enterprise Logical Data Model using Oracle Modeler and built a Master Data Management system and CMDB to develop maturity in teh organization.
• Setup Segment Architectures including baseline and target for Information, Business and Application Architecture dat fed teh Reference Architecture repository.
• Mapped Technical architecture like servers/databases to teh Applications which map to teh Business Functions for TCO and chargeback to teh departments.
• Used Power BI, SSIS and Tableau v10 for building Dashboards on analytics database. Test Data Management (TDM) used for enabling testing.
• Responsible for JIRA issue management systems delivery and support.
• Migrated some applications and infrastructure to Azure over a period of 2 years and integrated wif Azure based SaaS applications.
• Initiated Data Science using python to analyze data for Oil and Gas.
• Developed scripts for predictive analytics in teh company.
• Experienced in creating POCs for IoT Data Warehousing at Confidential . Confidential uses infrared based tracking devices wifin their LNG Plants sending data to datacenter.
• dis feed was associated wif OSI PI, a real time data historian tracking multiple sensors and tags, along wif Maximo based asset tracking system.
• dis information was used to create Power BI Datawarehouse and Tableau and Power BI based dashboards built KPIs for CEOs and Business Leaders at Confidential to use and track common pain points.
• Developed .Net based website using Visual Studio and embedded JavaScript code to generate dashboards utilizing graphs and charts. Data Integration from various sources implemented.

Confidential, Houston, TX

Enterprise Architect

Responsibilities:

• Established Data Foundation for Business Units and Petro technical Functions (Reservoir Management, Drilling and Completions, Base Business and Facility/Equipment) by engaging stakeholders, setting expectations and employing strategy and architecture guidelines and governance.
• Documented design instructions for deploying Enterprise wide standards (System-of-Records, Application & Information Standards) like Wellview 9.0 for Reservoir Pressure tests, etc.
• Setup Architecture Maturity for Confidential and engaged wif overall architecture community to develop Target Architecture for Petro technical Functions for future years.
• Created roadmaps and processes for transitioning to teh Target Architecture using Gap Analysis and Planning Portfolios. Created Taxonomy of products in Enterprise Architecture.
• Worked on System Architect (tool) as an enterprise architecture repository to maintain artifacts and models/diagrams.
• Developed Upstream strategy for using System Architect as a system of record for EA artifacts.
• Used UPAP process to help incorporate standards.
• Additionally developed Upstream Data Elements having enterprise Information objects and architecture related information usable by teh business and teh IT management team.
• Used python to analyze data.

Confidential, Houston, TX

Solution Architect

Responsibilities:

• Solution Architect for Request to Pay e-commerce OLTP system dat handled customer requests in real time for products and services inside Confidential and supported tens of thousands of customers and integrated wif 15 other systems internally and externally.
• Used BizTalk for real time messaging,
• SQL Server and .Net for teh application.
• Assured End to End Requirements Management, Capacity & Configuration Management responsibility as well as functional specifications, design and development for 2 parallel releases.
• Drove performance, scalability and quality improvement through teh tooling aspects of teh project. Business Architecture, Information Architecture and Application Architecture as well as Reporting Architecture developed and presented to teh leadership team.
• Gained Stage Gate approval through Architecture Review Board. Risks/Issues documented and driven towards resolution. Implemented SharePoint FastSearch for advanced searching capabilities and used ProVision for business processes.
• Helped in Operational Management and analyzed teh end to end business processes, integration bottlenecks and master data management improvements by enabling metadata, documentation and process management.
• Helped ensure end to end reporting and monitoring capabilities were established and agreed upon. Engaged wif K2 Monitoring CoE.
• Analyzed performance and scalability issues in teh analytical Datawarehouse (Traced) and suggested improvements on teh data model and business processes to gain performance and data quality.

Confidential, Houston, TX

Data Architect

Responsibilities:

• Assessed ETRM vendors e.g. Allegro, Openlink, TriplePoint, SolArc, etc. and recommend solution for least cost and highest benefit - chose Solarc. Developed methodology for Functional mapping to Data Systems used in selection of Vendor.
• Managed a team of data analysts and developers to gather requirements, create design artifacts and deliver code in Informatica ETL to create a BI data warehouse solution. Created data model, logical and Informatica mappings and managed 4 downstream project integration requirements and delivery considerations. As Project manager, created and managed teh project plan.
• Facilitated Data migration and Integration experience to produce best of class results in Confidential IST. Finalized scope for Integration Architecture and obtained buy in from business. Managed teh Reporting and Business Intelligence efforts for teh program and outline teh strategy and planning around it.
• Lead teh data quality initiative inside Confidential using Dataflux. Deployed Dataflux in our project using Shared Services and used it for Master Data Management between SAP, Solarc, ETC and other applications. Encouraged teh use of data quality best practices to achieve high performance results in project.
• Drove teh archiving and purging best practices using Optim throughout Confidential . Manage teh archiving and purging architecture for teh Oasis program including its requirements, driving teh solution. Used Advanced custom Data Subsetting and Archiving functions using Optim Basic. Developed Optim Discovery and Analysis processes. Information Life Cycle Management (archiving) of production systems and reporting off teh archived repository on cheaper storage. Implemented requirement to archive tables containing multibillion rows wif minimal impact to production. Solution required automation of archive files and loading into a secondary archived repository and then used Attunity to integrate Business Objects wif it.
• Encouraged use of ER/Studio for data lineage wifin teh data architecture community.
• Lead wif teh role of Data and Integration Architect on teh NAGP NGL Oasis program. Drove teh strategy and architecture for teh Data Migration activities in teh program from Select to Define and Execute in 2010. As Delivery Lead for teh Data Migration and Integration work stream ensured teh program objectives are met wifin budget and time.
• Identified technology, methodology and type of integration for each Integration point using ETL, IL, SAP/PI where needed. Engaged in leadership role to drive teh SAP/BW solution for teh NGL Portal. Drove teh solution for teh ETL integration including Credit Risk, Market Risk, etc. Estimated teh Integration Delivery effort hired resources as needed.
• Responsible for end to end solution and for building and architecting a Star Schema data mart sourcing from teh OLTP database and delivering a reporting solution for teh project. Designed teh Business Objects Universe and lead team to develop reports and deploy to production. Tool selection criteria for data analytics and ETL were part of teh project.
• Delivered a project wif Informatica to source data from source into target using both batch and real time (Change Data Capture). Master Data Management in real time was implemented using messaging and a universal TIBCO bus.
• Architectural responsibility for driving teh functional requirements by means of Use cases and Change Requests to deliver Scheduling and Logistics/Inventory Management of Physical Operations for Confidential . Analyzed requirements and lead effort to create, design and development artifacts as well as architecting highly available and top performing solution. Performance, Availability, Usability criteria were placed into teh design considerations wif balance of each criteria and cost/benefit analysis done for different options.
• Integrated SAP and Oracle (NextGen) systems in real time wif messaging and data conversion/cleansing activities for Master Data Management using Dataflux. Also, deployed teh Dataflux tool in our project using teh shared Services Architecture. Understanding of teh NextGen and SAP data models as well as teh data was an important primary activity. Physical Deals, Exchange Deals, Shipments, Parcels and Master Data were culled for loading into teh application (IMOS) database.
• Managed a team of 3 data modelers and 4 ETL programmers as well as guided a team of data analysts and business analysts to deliver data architecture for a US$ 125M project. Used MS Project to deliver solution and implemented standards, guidance and tools across teh project and teh enterprise.
• Lead teh design of XML message structure used in teh real time data movement by means of Canonical Data Model. Responsible for delivery of quality data model, data integration and data quality. Used metadata repository to keep source-target mappings and delivered real time data movement from multiple sources into OLTP database. Delivered high quality transactional and master data from SAP, etc. sources into target environment using ETL automation for Data Conversion and Cleansing.
• Drove data quality expertise and architecture using standards and best practices in Confidential .

Confidential, Schaumburg, IL

Manager/Sr. Enterprise Database Architect

Responsibilities:

• Data Model designed and implemented for teh Call Center for dis Prepaid Cell Phone Provider company delivering exceptional service employing KPIs like service times per call, customer satisfaction, etc.
• Enterprise Lead architect for designing Oracle Datawarehouse and ETL processes for teh company. Tool selection, resource allocation, capacity planning and budgetary implementation executed. Designed ODS and Datawarehouse model as well as implanting ETL and BI front end strategy for reporting needs. Implemented reporting solution using Oracle Discoverer.
• Used Optim in Data Archiving and Purging Strategy and tool implemented to reduce cost of EMC storage by 50% leading to cost savings of more TEMPthan US$ 800,000. Drove Optim subsetting for testing requirements as well as for enabling copies (subset) of production. Automated archiving, purging and restore (to a secondary data store wif cheaper EMC storage) using Optim in a scheduled (daily) batch program. Maintained referential integrity between all teh entities in teh archived repository by using Optim.
• Master Data Management implemented for reference and master data across multiple in-house applications. Data Governance was setup for managing master data in teh Enterprise using automation and manual processing where optimal.
• Manager and Lead Enterprise Architect for dev/test/production system of 9i and 10g databases leading a team of 3 DBAs on Oracle 10gR2. Guiding and mentoring teh team and teh company to scalable, high available systems using RAC clusters and RMAN. 2TB sized OLTP production system. Managing 2-3 outside contractors for DBA support and giving direction and setting strategy for teh team.
• Oracle 10g iAS portal/discoverer/reports environments and architecture set up for development/test and production. Change control set up for reporting and scheduling of discoverer analysis.

Confidential, Richmond VA

Project Manager/Team Lead

Responsibilities:

• Leading a team of data architect, Oracle/Teradata DBAs, data modelers and ETL Ab-initio developers to build a collections Datawarehouse. Designed and implemented Database model, physical database on Oracle and Data Movement using Ab-initio to push data from legacy and analytics sources into teh Collections repository. Designed teh star schema database model from business requirements and modified it. Configured development, test and production ETL servers and databases for Oracle 9.2 (9i) and Teradata RDBMS.
• Ab-initio ETL team lead (doing hands on development) of 5 Abinitio developers and designers to develop and implement a banking Financial system Data warehouse. 25 graphs developed to extract data from different sources and transform and load into a central database of Oracle and Teradata. Used EME to do code management and track performance of individual jobs.