SUMMARY:

• Currently working as Solutions Architect at Confidential . As a part of architect team, responsible for
• Deploying capabilities that help GMF earn customers for life
• Provide consultation on proposals for new and updated applications
• Contribute and present project solution for Architectural Review Board
• Contribute and present project solution for Cyber Security Review Board
• Work with business to understand - the requirements, interfaces and user provisioning,
• Help grow GM/GMF brand by entering new lines of business, new markets and adding products that meet customer demands and improve sales effectiveness
• Lead in technology and innovation by deploying new solutions and capabilities that allow GMF to grow its business, operate more effectively and work in more collaborative manner
• Ensure that GMF has the appropriate controls, risk management and security in place to ensure an effective, stable and secure business environment
• Validate requirements as well as oversight on adherence to architectural principals, standards, patterns and strategies
• Validate data privacy and data security and governance requirements
• Create a solutions design which consists of solution overview and high level design that supports low level designs and feed into infrastructure, engineering designs
• Experienced in planning, coordinating and leading multiple complex, high-profile, mission critical projects with onshore and off-shore teams.
• 15+ years of experience in DW data architecture, data analysis, data modeling, detailed design specification using fact tables and a star schema dimensional model, data extraction, formatting and processing using Oracle PL/SQL.
• 17+ years of experience in developing and delivering BI solutions using pl/sql, Business Objects, Cognos and Crystal Reports
• 10+ years of broad experience in project management, application design, reporting capabilities and systems development life cycle that encompasses -
• GAP Analysis,
• Scope and risk planning
• Impact Analysis
• Functional, Technical and Security Requirements gathering
• Developing schedules and budgets
• Functional Design
• Development
• Product and Performance testing, implementation and support.
• 6+ years of experience in Integrated Supply Chain, Market Sell, Customer Profitability, Supplier Diversity and Financial Dashboard.
• Consistently high ranked team member. Received multiple People Developer and Value Creator awards. Coached and mentored many new comers to the team and worked as carrier counselor.
• Proven self-starter, quick learner, capable of leading multiple projects with team members across the globe, Good interpersonal relations, high level of motivation, Confident and comfortable with critical problem solving and communicating with different levels personal, Sincerity, hard work and commitment to job are my greatest strengths.

PROFESSIONAL EXPERIENCE:

Confidential, Detroit, MI

Solutions Architect

• Solution architect for IO BI Migration project. After GMF sold EUR operations, GMF IO needed to migrate all LAO data (Commarcial and Retail DW), DataStage transformation jobs, Cognos reports and Exstream templates/configuration to the new GMF BI infrastructure in Arlington, TX. Completed data DPIA, strategy for code/ report changes for version upgrade for Oracle, Datastage and Cognos and onboarding sustain team along with interface migration, scheduler migration, testing strategy, data masking (CA TDM) in Pre-prod for PII data and implementation approach.
• Solutions architect for AU CALMS project. GMF is reentering in the Australian Market in the 4th Quarter of 2018. The goal of the project is to implement the CALMS modules Front & Middle Office (‘FMO’) and Contract Management (‘CMS’) in a AWS hosted environment so that on the launch date the Dealers and business users will have a system to perform day to day operations.
• Solutions Architect for CIW Web Service Integration with ASTRA project. Currently Commercial DW receives data from CARRS (Credit Analysis and Risk Rating System). GMF is replacing CARRS application with ASTRA. This project will update existing DataStage jobs to get data from ASTRA using web services instead of files. Designed strategy for ETL/data base changes aligning with ASTRA sprints and testing strategy agile project.
• Solutions Architect for Customer Data Platform (CDP). To support the business on Customer Retention Management Campaigns (CRM) in the Latin American Operations (LAO), Customer Data Platform was created which provided precise analysis and insight at the customer level. Additionally, it provided visibility for end to end tracking, management, and reporting of CRM campaigns. This in turn would drive GMF’s ability to provide customized campaigns at the customer level, and extend data integration capabilities with 3rd party data sources such as GM and the LAO call centers.
• Solutions architect for Medallia project. To provide better customer experience, a new Customer Experience Management (CEM) process is designed to receive customer voice in Brazil, Mexico, Chile, Columbia, UK and Germany market. For this process designed the solution to get customer relationship and transaction data from various systems e.g. SRS and Oracle HR, customer center and create an extract that will generate customer feedback and in turn provide voice of customer along statistic by division, country and roll.

Confidential, Detroit, MI

ETL Technical Lead

• Working as architect to design and build Surgery data mart that will integrate data from different sources for pre-op, intra-op and post-op phases of patient care. This data mart will calculate various time lines related to surgery, medication administered, lab results, blood transfusion and CPT4/ICD Procedure/ Diagnosis codes to help build canned and on request reporting based on encounter and/or HAR level.
• Worked as architect to design and develop CAD (Clinical Analysis Database) that will integrate clinical data from about 150 sources for more than 40 clinical services. Created Requirement document, User interface document, source mapping and verification document. Developed Logical and Physical Data models using ERStudio. Created interfaces for automatic data updates from SQL server and other sources using ETL tools like Pentaho and ETL Manager.
• Participated in efforts on converting and integrating clinical data across different clinical databases, including Confidential 's Clarity databases.
• As part of large MIChart conversion project participates in various projects in designing new data marts and analytical reports using pl/sql developed long term strategy for data warehousing for the analytics group analyze business requirements, created logical and physical database design; created data model generated reports to review and validate data loaded into the data warehouse for accuracy designed and developed complex reports (conversion from SAS, and new report development) using PL/SQL and Crystal Reports
• Interacts effectively with business analysts to produce analysis results and analytics requirements

Confidential, Southfield, Mi

Senior Systems Analyst

• Architecture Specialist for Sales Trend and Pulse Dashboard project. Sales Trend is a web tool that enables Field Sellers as well as Sales manager to monitor/analyze sales by business, geography and other attributes. Pulse Dashboard gives the KPIs related to Sales and for DOW’s executives. These tools are the only tools available for business community in DOW to track combine sales of DOW and Rohm and Hass after merger.
• Architecture Specialist for REACh project. REACh (Registration, Evaluation and Authorization of Chemicals) is a new EU regulatory system for chemicals management. It represents a significant opportunity for DOW, Dow’s suppliers and customers to work together to protect the environment. This project not only was important for DOW to continue business in EU countries but also enabled DOW to be a leader in Chemical industry by setting example and helping vendor/customers to comply with the regulation.
• Architecture Specialist for Oracle Upgrade project. SDN upgraded Oracle 9i to 10g version.
• Architecture Specialist for multiple Joint venture projects to provide Market Sell, Transfer Price and Cash Management reporting capabilities to Joint Ventures. DOW went through series of joint ventures and each JV had different legal requirements to secure the history data and provide reporting capabilities.
• Developed and maintained various Business Objects universes (Market Sell, Orders, Freight & Logistics, Pricing, Purchasing, Inventory and Customer Attributes).
• Architecture Specialist for multiple small projects to help improve reporting capabilities, improve support quality, minimize support price and re-org projects with DOW.
• Lead Developer for FAST project. 3. FAST (Global ForecAsting SysTem) tool helps facilitate accurate forecasting to achieve good customer service at low cost. Forecasts are a critical input to the Integrated Supply Chain and Produce Product Processes. Accurate forecasting is very important in sourcing optimization decisions and inventory management planning. Data is displayed and manipulated in the tool through three components: web application (FAST Online), Microsoft Access application (FAST Planner), and statistical forecasting software (Forecast Pro). FAST Online is a web-based user interface to capture market intelligence and allow for integrated reporting of the market intelligence combined with Demand, Guidelines, Statistical forecast and Demand Plan.