Summary of Experience

I am well-known for my strong analytical skills, computational algorithms, number crunching, pattern matching, attention to technical detail, focus on long-term objectives, and commitment to my project, team, peers, and management. My credentials also include a strong academic background MS in Computer Science MS in Mechanical Engineering . I am an US Citizen with authorization to work anywhere in USA.

Professional Experience:

Confidential

Data Architect / Sr. Software Engineer

• Technical lead for Price Quote application. Web based secure quoting tool that facilitates the entering and tracking of price quote activities between Intel and Distributors in real time. Developed physical data model and data layer for web based multi-tier application. Developed inbound and outbound ETL SSIS packages for SQL Server 2008 R2. Created custom solution to store and manage rapidly changing product cost. SQL Server 2008 R2, SQL, SSIS, C and .Net Framework4.0, Java Script, HTML4.0, CSS, XML, Web Services, Selenium WebDriver 2.0. Used agile/scrum development methodology .
• Data Design team lead for Enterprise Customer Master Data program Creation of master data record of distributor, end-customer and external contact. The gold version of master record is made of unique distributor identifier for Intel, standardized address elements ISO-country, sub-division, postal code, currency, vat, preferred communication language and more. The single version of the truth optimizes sales processes globally across all sales teams and enables 360 degree view of the Distributor. Created information blue print. Created Value Cost Chain VCC diagrams. Created logical and physical data models. Championed data standardization effort. Created data lineage from CIM Hub SAP-CRM SAP-BI EDW. Reverse engineered SAP-CRM physical schema to validate it's compliance with Intel's Enterprise Customer Logical data model. SilverRun, ERStudio, SAP-CRM, SAP-ECC, SAP-BI, MDM, CPM, EDW-Teradata, SQL, PERL, C, ETL-processes SSIS
• Data Design team lead for Intel Channel Management data warehouse that provides data foundation for business analytics on Channel Sales, Sales Documents, Billings, Inventory and Revenue. The data warehouse was built on EDW-Teradata platform. Daily batch jobs bring several millions of transactional data from SAP, CPM, MDM, Web Quote, COSR, NEXT into EDW. Designed logical and physical data models to store current and historical data. Created standardized data dimensions for Distributor, Product, Calendar. Designed star-schemas for Sales-Out, Inventory reports for Microstrategy BI platform. Developed data mapping between source database SAP-CRM and Teradata. Used Silverrun data modeling tool for data modeling and forward engineering. Created data definitions and metadata for Logical and Physical entities. Create data validation SQL scripts to check the data integrity. SAP-CRM, SAP-ECC, SAP-BI, CPM, EDW-Teradata, COSR, NEXT SilverRun, ERStudio, SQL, SSIS
• Registered Data Modeling mentor at Intel. Continuously provided mentoring to data analysts coming on board.
• Acted as Project manager and individual contributor for Management Leadership database application. Designed physical data model, server side stored procedures and DTS packages. Management Leadership database is a repository that stores employee confidential data for grade 10 and above employees. SQL Server 2005, DTS, SQL
• Designed and implemented batch job monitoring system for Oracle rollup jobs for SPCView application. Programmatically corrected rollup job failures and automated the process ORACLE, PL/SQL, SQL, PERL
• Lead member of ARIES data warehouse team. ARIES data warehouse was built on ORACLE database. The system stores current and historical data about microchip electrical characteristics generated by semiconductor testing machines in the factories. Created data extraction application from flat files. Designed and implemented database stored procedures. Developed ETEST-Checksum application that validates electrical test data. Implemented project configuration management for ARIES system to co-ordinate parallel development of different releases. Used Microsoft-VSS as code repository and branching of source code for parallel development. Handled CCB responsibilities for each release of ARIES through CAS-CCB. Widely used CMM Capability Maturity Model to manage the projects and mitigate risks.

Confidential

Senior Software Analyst

• Tech-lead for development of Intergraph/SmartPlant suite of products. Supervised the work of 4 software engineers. Developed the physical schema to store plant engineering data. The physical schema contained 62 tables. Implemented data layer on Oracle database and business layer for Intergraph/SmartPlant suite of products. Used Oracle Designer, C , VB, XML 1.0, Active data objects and implement middle tier.
• Developed design specifications for Intergraph/Smart Plant Manager. Implemented ActiveX components Middle layer using VC , VB. Also used ADO/RDS to communicate with backend database engines like Oracle and MSSQL Server.
• Developed AIM family of products AIM/Express based on COM /OLE using Visual Basic, Visual C and MFC programming environments. This product is designed, based on Object Model Framework technology provided by Metaphase Technology Inc.
• Designed and programmed RIS Relational Interface System server components using DBMS specific API Oracle Proc-C, Informix API . RIS provides uniform interface to heterogeneous databases like Oracle, INFORMIX, DB2 and Sybase.

Core Skills:

• Design of ERP systems, OLTP systems Proven Technical Leadership
• Logical Physical Data Modeling Project Management PLC
• Master data design and Standardization Scrum and Agile Methodologies, CMMI
• MSSQL Server, Oracle, IT Building codes Reuse
• SilverRun, Erwin data modeling tools Data Governance
• Teradata, SAP-CRM, SAP-BI Business Process Modeling ProVision
• Stored procedures, Functions, SQL Data Quality, Data Monitors
• Data Export/Import, Archive/Restore OOP, C .Net, Java Script, JQuery, HTML
• DBA, Performance tuning PERL, KSH, CSH, BSH
• SQL Loader, T-SQL Data Structures Algorithms
• Windows, UNIX and Linux Scrum and Agile Methodologies
• SSIS ETL tools ODBC, JDBC
• TFS source control systems IIS, HTML, ASP.Net, XML
• HP-Quality Center ALM Automated Testing - Selenium Web Driver/Grid