SUMMARY:

• Comprehend convoluted business processes and architect IT solutions to streamline them. (15 yrs)
• Cloud solution (AWS, Azure) architecture, design and implementation.
• Model Transactional and Dimensional Data in multiple business domains.
• Data Warehouse and Data Mart architecture, ETL design, Source System analysis.
• Decipher, abstract and aggregate complex CRM/ERP schemas for Business Intelligence.
• Scope assessment, engagement, delivery and mentoring (KT) - technical vendor negotiation

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

Data Solutions Architect

Responsibilities:

• Standardize blob storage for staging.
• Implement Azure feature pack to ETL from on-premise to BLOB Storage, HDInsight and SQL-Azure and back to on-premise.
• Analysis/proofing/performance testing of various Azure tools.
• Define/identify Azure Roles/Users
• Identity/overcome connectivity issues.
• Design Azure VM for package deployment, schedule jobs and ETL Framework control.

Confidential

Responsibilities:

• Architect and implement proactive non-profit focus areas based on sentiment word clouds derived from Twitter (API) and other social networks.
• Process data streams in a horizontally scalable multi node Hadoop cluster, running MapReduce jobs on EC2 as well as ad hoc jobs in Elastic MapReduce (EMR) with uploaded S3 datasets.
• Implement scraping techniques to bypass time constraints on querying historical data; pre-process methods to handle emojis, urls, non-English terminology.
• Data visualization and workflows using Zeppelin notebook (Jupyter was tested, too).
• POC variety of big data processing tools (MapReduce, Spark, etc.) prior to optimizing the project toolset; proofed in VirtualBox for multi-node clusters before migrating to AWS EC2 clusters.
• Leverage CLI to expeditiously spawn and terminate EMR clusters to run jobs on demand.
• Performance tuning (optimize Pig relations), best practices, cloud cost optimization, security..

Confidential, Walnut Creek, CA

Responsibilities:

• Solution architecture including under-the-hood XML techniques to migrate existing cubes with incremental ETL, schema and cube re-design.
• Cube extension design (DSV, DIMs) for incremental features added during migration.
• Exhaustive validation against legacy cube outputs and deployment.
• Performance tuning of legacy overnight SQL batch job sourcing from BST ERP.
• Batch time reduction from 5 hours to 30 minutes - mission critical.
• Analysis of layers that were bandaged over last 10+ years to accommodate evolving business processes
• Build new sql logic, schema re-design and ETL sequencing from ground up.
• Validation and deployment of refactored processes.

Confidential, Redmond, WA

Responsibilities:

• Architect BI solutions (star schema and ETL design) sourced from Dynamics AX (customized to manage the Microsoft Consulting Services planning and operations).
• Architect different approaches to tabular model design for small business functions that depend on them such as Actual and Forecast Revenue, Resource utilization, Engagement validation, etc. to help in Tabular SSAS migration.
• Refactor data model based on legacy report and self-service requirements.

Confidential, Dallas, TX

Responsibilities:

• Architect and draft a data migration specification to facilitate the migration of Enterprise Data to SnapLogic on a Hadoop (HDFS) platform using an ELT/ETL approach into a new Enterprise Data Hub.
• Analyze the 700+ SSIS packages, stored procedures, schemas spread across multiple SQL servers, Tidal enterprise scheduler jobs, Vertica schemas, Cognos dependencies (frameworks)…
• Draft solution architecture specification which details the new data interfaces, target data models, data element mapping, schedules….

Confidential, Dallas, TX

Responsibilities:

• Architect a usage metering solution for Billing/Monitoring features while extending the SDN based Cloud Management platform, built on Xen, Hadoop and open source components.
• Analyze and map data elements from Hypervisors to map metrics for CPU, Memory, Network traffic, Uptime, metering analytics, appliance vs VM traffic across multi-tenant systems;
• Model metering/billing transactional and analytic/aggregated data elements; design/tune large datasets to render aggregations across multiple granularities.
• Design incremental ETL (delta loads) between InnoDB and NdbCluster storage engines to handle daily and hourly jobs for minute, hourly, daily and monthly aggregated charts.
• Crunch data for monitoring charts to identify cloud optimization opportunities; correlate events to root cause analysis, etc.

Confidential, Tulsa, OK

Responsibilities:

• Design Staging, DW and DM schemas; Design ETL to load data between them; mapping specs.
• SAP OIU data elements; Cost/Profit centers and their hierarchies, JVAs, WBS Elements, Customer/Vendor, Master Data, etc.
• Implement BizTalk Adapter to pull data from SAP ECC via SSIS.
• Implement Open Hub based data source to extract data from SAP BW via SSIS.

Confidential, Chandler, AZ

Responsibilities:

• Design SSAS Data Mart; MDM Modeling.
• Computation of Space Utilization at Intel facilities globally to optimize real estate utilization.
• Medians and 85th Percentiles calculations for the utilization metrics across Organization, Geography and Employee Type dimensions for Assigned and Mobile workspaces.
• Distribute the computational load between DB Engine (stored procedures), SSIS and Analysis services, while delivering dashboards in PPS (Performance Point Server).

Confidential, Spokane, WA

Responsibilities:

• Design SSAS Data Mart; Tabular Modeling; Data Mapping; Role-based security implementation, cube partitions & loading (a (>1.5B records/fact table), SQL performance tuning; Agile, SCRUM.
• Re-factor DW to streamline the DB objects for Data Mart; create abstraction layer for cube src.
• Identity and draft mapping between Data Warehouse, Data Mart, cube and reporting data elements
• Cube performance tuning wrt memory management, using DMVs, Profiler, XMLA, DAX tuning...

Confidential

Responsibilities:

• Design an end-to-end Business Intelligence solution for a mission-critical Microsoft program using SQL 2008's DB Engine, SSAS, SSIS and SSRS, dimensional modeling and OLAP cubes.
• Study the source OLTP application and model a star schema with relevant facts and dimension attributes, and aggregations, to facilitate cube based canned and ad hoc reporting requirement specification.
• Optimal schema design using parent-child dimensions for extendable hierarchy levels, many-to-many and recursive relationships for security implementation downstream.
• Implement dynamic security through a combination of schema design and cube MDX expressions, SSAS roles & domain names; SCDs, SSIS Script Tasks to automate role member loading and Active Directory lookup.
• Establish a weekly build cycle subsequent to proofing unknowns, review drops, semi-automated deployment;
• Institute best practices including package configuration, VSS automation, central logging, error handling

:

Confidential

Responsibilities:

• Architected/implemented the transformation of a legacy process into a completely automated information system to facilitate network site conversion to MPLS at the rate of over 10 Kinkos sites per night.
• Negotiate/define/design inbound & outbound data interfaces after deciphering vendor systems.
• Established team communication and process by defining functional and technical specifications.
• Build a data repository to house data from vendors and internal ERP/CRM systems.
• Implement the reusable n-tier Confidential framework (a custom layer over Enterprise Library Application Blocks) for rapid development of the workflow functionality such as work-order processing (HP Global Deploy), purchase order approval (PeopleSoft Financials), trouble ticketing (Salesforce CRM), Customer Service Records (CSR) verification, telecom orders and response, inventory management, financial reconciliation.
• Tiers include ASPX.Net/C#, page classes, C# Business Logic Layer, Data Access Layer, and DB Objects (T-SQL Stored Procedures/Views/Tables)
• Draft deployment scripts and documentation for Confidential IT personnel to guide configuration management between environments.

Confidential

Responsibilities:

• Design Data Warehouse data model upon analyzing source systems, conceptual models and business requirements to warehouse mutating Microsoft Marketing transactional data and BI specifications.
• Established Data Warehouse and ETL best practices, standards, processes and mentoring, within the team.
• Inculcate target systems’ star schema design for BI processing.
• Streamlined process to generate physical schema and updates, after overcoming discrepancies between Visio Architect and SQL 2008.
• Design/Implement complex ETLs with selective data retaining over a 10 year sliding window, by incorporating partitioning schemes and functions, spanning over 250 million records

Confidential

Responsibilities:

• Design a data warehouse schema to house relational data from three different data sources containing consumer generated media (CGM) type data, weighing half a terabyte.
• Designed to accommodate initial data load as well as incremental extraction.
• Utilization of ETL components for Incremental Extraction such as Slowly Changing Dimension and custom Incremental and Package Log tables.
• Design package configuration to centralize common data/ parent package variables to transmit data to child packages.

Confidential

Responsibilities:

• Design a data mart to populate data from an existing OLTP schema and proofing SQL Integration/ Reporting Services to aggregate/generate summarized usage metrics across various demographics.
• Extend web application features over the DotNetNuke platform.
• Co-ordinate with Set-Top Box team to design the core architecture using WPF, XAML to drive the display station and capture video simultaneously.
• Analyze bulk upload of large files via HTTP and other transport protocols.

Confidential

Responsibilities:

• Analyze legacy application comprising of differing client-specific Rx formularies and the hooks with external systems such as Medispan, First Data Bank and Argus.
• Streamline the process and depict through a formalized Business Requirement Document and sign-off.
• Draft the Technical Specifications comprising of Data Model, Object Model, UI and specialized features such as dynamic PDF generation, dynamic Localization, proprietary authentication, formulary duplication.
• Implement a middle class Business Logic Layer using C# class libraries, Data Tier using SQL Server DB objects (Tables, Stored Procs, Views, DTS packages) and Presentation Tier using ASP.Net inheriting C# classes.
• Implement parts of BRD by segmenting and selective off-shoring; bundling code-drops, integration testing and deployment.

Responsibilities:

• Analyze security and compliance architecture requirements revolving around controls - definition, types, categories, regulations and frameworks and their mapping.
• Design a Data Model to depict the architecture requirements with Visio; generate Data Dictionary.
• Re-factor the data model to conform to Microsoft server tools and other dependencies such as Service Manager, SCOM, SCCM, CMDB, SML/CML base classes.

Confidential

Responsibilities:

• Analyze existing customized n-tier Onyx CRM implementation and design components/extensions to facilitate new business requirements revolving around the quoting phase of the CRM cycle.
• Analyze thoroughly the customized Onyx schema, middle tier COM+ objects and Web Server tier prior to.
• Architect/Design Cryptography component to implement DPAPI provider.

Confidential

Responsibilities:

• Architect/Build a SQL Server Data Warehouse of historical and current data for 130 financial instruments including equity, metal, commodity and interest rate futures using SQL Server 2000, Visio Architect, Visual Studio to enable testing of custom quantitative financial models.
• Comparison of procured vendor data (CBOT, CME, SFE, Bloomberg, TickData, FutureSource) for accuracy; implement Bloomberg and FS API to customize data pull.
• Automated calculation of quarterly and non-quarterly (for commodities) contract expiration dates.
• Merging of Pit and Electronic data as well as boot-strapping pertinent instruments (ex: DM with Euro) after analytical determination of bootstrap points.
• Normalization of historical data to accommodate coupon changes for interest rate instruments. (ex: Gilt 9% before Mar-98 contract; 7% till Dec-03 contract; and 6% then on).
• Facilitate processes to manually insert/update data and build an audit trail to go with it.

Confidential

Responsibilities:

• Engagement in the regulated SDLC process of designing and developing a Multi-tier application, from a raw .Net toolset, to facilitate seamless online Drug Sampling.
• Study the existing business process and legacy application, which includes faxing to fulfill online orders.
• Analyze and study the new requirements/use-cases for the new paperless Drug Sampling process.
• Collaborative Design/development of Data Model and Object Model of the new enterprise application.
• Detailed 4-tier design documentation of the individual use cases, such as 'Update Medical Licenses' and 'Enable Electronic Ordering' after proofing uncertainties. (Tiers include ASPX.Net/C# Code-Behind files, C# Business Logic Layer, Data Access Layer, and DB Objects (T-SQL Stored Procedures/Views/Tables)
• Design/build the Business Objects Layer using Lhotka's scheme and custom Business Base & Collections classes.
• Utilize/wrap the .Net Enterprise Library App Blocks for Data Access, Exception Handling, Logging and Security.
• Switch to Visual UML from Visio (overcoming Visio's shortfalls) to define Business objects, Sequence diagrams....

Confidential

Responsibilities:

• Analyze existing customized n-tier Onyx CRM implementation and design components/extensions to facilitate new business requirements revolving around the quoting phase of the CRM cycle.
• Analyze thoroughly the customized Onyx schema, middle tier COM+ objects and Web Server tier prior to.
• Architect/Design Cryptography component to implement DPAPI provider.

Confidential, Mountlake Trrc, WA

Tech Lead (Consultant)

Responsibilities:

• Study/analysis of Premera healthcare insurance products, services, cost-share models, benefit limits, networks including analysis of a legacy Excel application which prototyped the business process.
• Compilation of business and technical specs, design/development at Pivotal (vendor) site, monitor implementation.
• Implement/customize Pivotal’s eSelling suite (formerly, Exactium) and integrate with Pivotal eRelationship 2000, the CRM application via the Pivotal Life Cycle Engine; customize Pivotal Agents, Forms and Active Scripts for both ‘Active client’ and ‘Windows client’
• Analyze/design inbound/outbound data interfaces between eRelationship and Facets.
• Present HTML after parsing XML using XSL, ASP and Javascript; store business logic in VB/COM; establish three way handshake between InterDev, IIS and VSS.
• Configure Product/Service hierarchy and Medical Plan/Network Rules using Pivotal eStudio, a rules-based engine.
• Transition of technology from Pivotal to Premera, set-up of Development and Authoring environments in the Premera data-center, while establishing a repeatable and restorable software development process.
• Decipher eStudio and eRelationship schema to design ad-hoc SQL reporting and formally using Crystal Reports.
• Design/development of proprietary functionality and extensions in-house.

Confidential, Mountlake Terr, WA

Senior Consultant

Responsibilities:

• Design/develop ‘Group Billing’, ‘Cash Receipts’ and ‘HIPAA s’ interfaces/reports during Facets implementation after analyzing the 700+ tables and 9000+ stored procedures in the Facets schema.
• Discover Facets data elements using RUBI and SQL Profiler that would map to existing OS/390 data elements.
• Design/develop mapping docs, Class, Collaboration and Sequence Diagrams using Select Enterprise (UML Tool) to convert business requirements into design specification.
• Design Mercator maps, type trees, MDQs and MQ Series Queues to facilitate data sync’ing between systems.
• Develop test harness using VB 6.0 to comparatively study the interface outputs at various nodes.

Confidential, Seattle, WA

Senior Consultant

Responsibilities:

• Develop/maintain n-tier application to enable wireless handheld connectivity to Onyx SQL Server database using Site Server Commerce Edition.
• Conversion of SQL record-sets to XML and thereby transforming to HTML using XSL to port with PALM V, VII, iPAQ and Blackberry.
• Creation of wrapper stored procedures to map Onyx functionality to each Sales Force Automation action.
• Perform SQL trace and related sleuthing to decipher Onyx proprietary structure to expedite application development.
• Help application migration to an EJB platform.

Confidential, Vancouver, BC

Integration Engineer

Responsibilities:

• Design/model eCharge NetAccount Merchant API Libraries using Rational Rose 2000 (using UML and Design Patterns) and develop using Visual Age 3.5 to implement eCharge Secure Transaction Protocol (ESTP) which comprises of XMLizing, extracting (de-XMLizing), digital signing and verifying, encrypting and decrypting (using Baltimore PKI encryption tool-set) messages between applet (browser), merchant and eCharge Transaction Server to enable secure payment transactions.
• Design/architect eCharge Net Account adapter (VB/VC++ COM objects) for Site-Server Commerce Edition using Pipeline architecture and generic IIS situations including installing/configuring test merchant scenarios.
• Create/maintain multiple SQL Server 7.0 database instances for development/testing of NetAccount and myPhone products.
• Design/develop install packages using InstallShield 5.5/6.0 for seamless eCommerce engine integration.
• Interviewed/built Integration team including keeping team inspired for optimal teamwork and productivity.
• Study/analysis of IBM WebSphere, BroadVision and BEA WebLogic to facilitate eCharge Merchant API Integration.

Confidential, Vancouver, BC

Technical Architect

Responsibilities:

• Re-engineer SportMart.ca e-Commerce site using a modular rebuild approach using Site-Server 3.0 Commerce Edition/NT 4.0/IIS 4.0/SQL Server 7.0 for Login/Registration/Checkout/Admin modules.
• Design/deploy a new ‘Affiliate Program’ for SportMart.ca
• Design of entities/attributes, stored procedures, web files and data modeling.
• Planning/Implementation of new modules into the production system.In-House Work-Flow/Routing/Tracking Systems
• Design rapidly deployable Enterprise suite of applications including Purchase Order app, and Budgeting app using the Exchange Server 5.5 w/sp3 and Outlook 2000 tool-set.

Confidential, Seattle, WA

Senior Consultant

Responsibilities:

• Study/decipher proprietary data model of a Billing System (Portal's Infranet) to design SQL-based reporting out of the same system as well as maintain data validity and concurrence to other custom-built applications.
• Developed a reporting interface using Versata JADE (Java Application Development Environment - formerly Vision Soft) Developer Studio 4.0 to generate reports after setting 'sort' and 'select' criteria.
• Performed myriad IT activities such as ad-hoc reporting, data extracts to populate accounting system, help develop project plan, user requirement verification and implementation.

Confidential, Dallas, TX

Senior Consultant

Responsibilities:

• Develop/Optimize Data Warehouse/DSS using Sybase SQL Server (System 11.5)
• Stored procedure development using dynamic SQL to iterate date-suffixed entities in the Data Warehouse
• Query Plan analysis, stored procedure optimization and designing indexes to fine-tune performance.
• Process and Data Flow automation to generate periodical reports from very large tables.

Confidential, Rochester, NY

Technical Lead (Consultant)

Responsibilities:

• Development of the primary application using VB 5.0 accessing Oracle 8.0 database via custom-built ODBC-API module, while transferring most business logic into views, stored procedures and triggers, after user sign-off.
• Development/Utilization of ActiveX controls (DLLs and OCXs) to enhance reusability, maintainability, efficiency…
• Development of a web-based intranet application to mimic the VB app using HTML 3.0/ASP 2.0/ IIS 3.0 for smooth worldwide deployment, default version control and ensuring cross-browser compatibility.
• Usage of VBScript and server side components (VB DLLs) to contain partial Business Logic, invoked by ASP, while restricting to JavaScript for client-side scripting.
• Development of a Web reporting interface using HTML/ASP to drive Crystal Reports engine, customized to help user pick a report from a list as well as set Selection and Sorting criteria, before report generation.
• Design, development, scheduling and sequencing of custom feeds during the phased-approach implementation, to maintain the legacy system data to be in sink with the new SEAR.
• Scrutinize/extract Oracle ERP data to match SEAR inventory against Oracle MRP to enable Push process.

Confidential, Rochester, NY

Technical Lead (Consultant)

Responsibilities:

• Application Migration from Legacy system (XBMS) to VB 4.0/Access 2.0/Oracle 7.3.
• End-User/Champion Interaction to continually review and update prototype.
• Design and deployment of a "Main Menu" program to control launching of individual applications, taking into account security of user access for individual applications, along with transparent updating of applications.
• Design and Develop computation-intensive decision-oriented reports, using Crystal Reports 5.0 within a Visual Basic user-interface (Report Wizard) to set Sort and Selection criteria, along with capability of users to save templates of pre-selected criteria.
• Back-end Upsizing from MS-Access 2.0 to Oracle 7.3 on NT 4.0.
• Develop computation-intensive reports using Crystal Reports 5.0.
• In corporation of three levels of security, namely, application level, form level and network level.
• Modification of the application to be compatible with both 16 and 32 bit (Windows NT) environments.

Confidential, Texas City, TX

Senior Software Consultant

Responsibilities:

• Migration of Mainframe Legacy applications to Client-Server (REXX/VM to Visual Basic/Oracle).
• End-User Interaction to study requirements and functional modifications.
• Extensive use of VB macros in Excel to develop computation algorithms, data manipulation and generate reports.
• Develop MS-Access front-ends to help data manipulation and update Oracle 7.0 database.

Confidential, Houston, TX

Software Consultant

Responsibilities:

• Implementation of temporary tables to enhance data retrieval/update performance and enable 500*500 grid flip.
• Utilization of third party tools such as VB Assist, version-control using Visual Source Save and Spread.vbx and other custom controls.
• Interaction/Analysis with functional analysts and end-users to study requirements.
• Rapid development of a modification database using Access 2.0 for use by the project team, to pinpoint bugs and necessary modifications in the TIS application.
• Migration of data-access method from DB-Lib to ODBC, as per security specification.
• Technical documentation ( Spec. Pack) for every developed window and stored procedure including Window ID, Window description, CAR (Control, Action, Response) table, deviation from standards, stored procedures accessed, description of controls used, using Excel 6.0.