SUMMARY:

• A highly experienced, results - oriented, business leader, skilled enterprise/Solution architect, and published thought leader who has demonstrated the ability to lead cross-functional teams of professionals in achieving mission critical results in a variety of highly competitive industries, cutting-edge markets, and fast-paced environments.
• A broad professional background and an excellent provide a solid foundation to solving challenging business problems with innovative enterprise solutions that leverage and align IT capabilities with evolving business needs. Seeking a strategic and challenging technology senior leadership role in a dynamic organization where my diverse skills can be optimally utilized to add value.

TECHNICAL SKILLS:

Languages: Proficient in: HTML, SQL,PL/SQL, XML, MDX, UML, JavaScript .Terra dataFamiliar with: Java, VB Script, Ajax, CSS and SOAP, C/C++

Database: MySQL and Microsoft SQL Server2005, SQL Server 2008 R2, MS. ACCESS.NoSQL Technologies (combination of Hadoop, CouchBase, Cassandra and MongoDB ).Hadoop eco system (PIG,zooker,HBASE,YARN,HIVE,SQOOP,Impala,Storm,Flume)

Modeling and Designing Db Tools: IBM Rational Rose, MS. Visio, ERWin 7.3-,8,9.5, Quest TOAD.

Data Warehouse: Informatica ETL Power Builde7.1,8.6r, SSIS,SAP BODI,ODI, Pentaho

Oracle WebCenter,Oracle PBM, Oracle BPEL,Oracle Legacy Adapters, Oracle BAM, and Oracle ESB

BI Tools: SAP BO,IBM COGNOS 10 BI, SSAS,SSRS

Platforms: Microsoft Windows 2003/2008, Mac OSX, and Linux

WEB Server: Apache HTTP Server 2.2.17, MS. IIS 7.5.

Other: Adobe Photoshop, Microsoft Visual Studio, ASP.NET, Eclipse IDE

Requirement Management Tools: IBM Rational Requisite Pro V 7.1.2, Rational DOORS 9.0.

Visualization & Analytics: Dashboards, Strategic maps, Balance Scorecards,CliqviewData Mining, Predictive Analytics, Heat Maps

Testing Tools: Confidential Quick Test Pro 8.2-11.0, Confidential LoadRunner 8.0-11.0, Confidential Service Test 11.0, JMeter 2.4,Selenium RC, JUnit.Configuration Management: Microsoft VSS, CVS, IBM Rational ClearCase.

SDLC METHODS: Agile,RUP,Waterfall,Spiral.

ERP: Oracle e-Business suite, SAP ERP 6.0

Statistical Software: IBM SPSS 19.0.0, SAS 8.2-9.2.

Other Tools: MS. Project, MS. Office, MS Sharepoint, MS Frontpage, Adobe Dreamweaver,Photoshop CS, Microsoft OCS and WPF, Altova XML spy.TIBCO Object Designer.

PROFESSIONAL EXPERIENCE:

Solution /Data Architect

Confidential, Detroit, MI

Responsibilities:

• Led discovery sessions to understand the existing and desired business processes, serving as a liaison between multiple departments to facilitate project scoping, requirements gathering for new business processed by conducting deep analysis and data profiling that helped architect a new solution for Large Group Business with the Confidential Plan. Built a roadmap, cost estimates and implementation plan to deploy the Confidential Solution.
• Member data from their social site provided real time and offline analytics to different business departments. Existing EDW implementations were struggling with rinsing data volumes, causing performance concerns and impacting a business’s ability to meet SLA’s. Provided solution and led Developers and Architects to design Enterprise Information architecture Big Data Customer 360 use case. Organization of all the existing data models, data flows and data dictionaries into a Metadata Repository. Created physical models of all databases and logical models of strategic customer and product databases.Designed a Information architecture comprising of Hadoop ecosystem and Mongodb using streamlined Data Refinery (SDR) Broad data integration strategy to accommodate existing architectures plus a powerful array of self-service analytics and visualizations for all end users, they be business users, analysts, or data scientist.
• The solution significantly reduced development time for (more than 10 X) met all SLA’s time limits while linking business strategy to applications,data,architecture principles, and technology solutions for new development for a variety of use case.
• Performed design reviews across company and collectedenterprisearchitecture performance metrics to assure continuous improvement. Conducted evolution planning for systems and technologies and maintained application life cycle inventory. Ensured development and in corporation of businessarchitecture with other layers.
• DevelopedEnterpriseDataPrinciples and Governance structure and a set of implementation and management guidelines. Developed theEnterpriseDatawarehousedataand ETLarchitectures and models. Enterprisedata integrations from multiple and complex financial sources such as S&P, SEC, Corporate activity data, Corporate Litigation, company Accounting investigation and inspectiondata.
• Performed entrepreneurial management skills including leadership, problem analysis and decision-making, planning and organizing, interpersonal, adaptability/flexibility, stress tolerance and time management. Skills included staff and work planning, personnel appraisal, motivation and team-building, and delegation. Developed and implemented effective long-term plans and programs.
• Developed strong MDM practice, client relationships, new opportunities, resources, and center of excellence for MDM practice.

Senior Data Architect

Confidential, Roseville, CA

Responsibilities:

• With Traditional EDW solutions always ensured compliance with the EDA standards for Data Quality. Designing Data Warehouse by implementing Ralph Kimball Dimensional Modeling approach of star schema method. Financial services Business Architecture and develop plan to build integrated, TOGAF compliant, Business Architecture documentation.Led large teams of enterprise architects involved in planning, development and implementation of infrastructure improvement strategies, providing recommendations and implementation expertise for a variety of Big Data technologies, leading product evaluation and selection processes.
• Trained middle and top management who was stakeholder in Enterprise wide projects. Served as the liaison between the data consumer representatives and data solution development, integration and governance teams.
• Manage and evaluate proof of concept implementations and champion platform strategies across Architecture, Engineering, Strategy, Product Development, and Marketing organizations. Architect reusable Data of program and enterprise or operational scope

Senior Data Architect

Confidential, Alaska

Responsibilities:

• Interface with a variety of business and technical stakeholders to gather and solidify requirements for data analysis and report generation, create the queries to extract data, interpret data, and develop test and deliver the report Data.
• Managed Project budgets, risk analysis and mitigation, issue management, root cause analysis, project schedule development and tracking using MS. Project.
• Customer Support Strategic Dashboard Project is to build a Corporate Dashboard to help the Customer Support Managers to analyze the performance of the Technical Support Engineer based on various Key Performance Metrics at World Wide and also at the different regional level. Designed and developed the metric universe for the Dashboard project.
• Led the business team in specifying the requirements for ETL Datas that implemented Sybase replication for change data capture on the source systems.
• Delivering major BI Data into implementation within large structured enterprise environment. Working with cutting edge application of architecture frameworks, formal SDLC and Application Development methodologies. Demonstrated comprehensive knowledge of BI Data Architecture development, including related process, information and technology architecture concepts.
• Utilizing Cognos 10.1 as the Business Intelligence reporting tool, while MS SSIS being used for ETL packages. Building high quality Logical and Physical Data Modeling, including relational, dimensional and flat-file data structure. Created Metadata layer with IBM Metadata Workbench.
• Predictive analysis performed using IBM SPSS Modeler. Based on an intuitive visual data flow process of analysis, models and reports created to tackle otherwise difficult and time consuming problems. The data represents a sample of customers with descriptors such as number of minutes on long distance and local calls, financial information such as billing types and payments methods, some demographics such as age, sex, and income. The final field “Churned,” indicates whether the customer has ceased usage on their own accord, etc. The task was to profile those customers most likely to be voluntary churners.

Senior Data Architect

Confidential, San Francisco, CA

Responsibilities:

• Served as data warehouse architect for the 1,000,000+ consumer data warehouse, designed to provide timely mitigation efforts for improving response time to any discrepancies identified, this improved profitability for the wholesale / corporate customers. The data warehouse provided statistical analysis, data mining, ranking, segmentation, tiling and other analysis capabilities. Roles included the logical and physical design of a multi-terabyte data warehouse database. Installed and upgraded a variety of technologies, including SQL Server, WebTrends, Oracle, Informatica, Alterian, and SPSS. The overall technology and data architecture ensured that it all worked together smoothly and effectively.
• The data warehouse database was deployed to support the Profitability Reporting Facility (PRF) application for the financial analysis community. Tasks included the design, development, and the administration of several Oracle database applications exceeding 50 Gbytes in data, Oracle performance tuning, and translation of business requirements into database application design and data models, and migration of various database schemas between databases.
• Developed a Conversion Component in Projects Accounting Module to migrate data from a Legacy System to Oracle Applications. Assisted in developing and publishing data management standards, policies and procedures, including the management and maintenance of related tools and environments. Collaborated with Oracle Database Administrators for the Warehouse database design, data model, and storage, security, performance and data environment requirements. Performed maintenance and support of existing applications. Established, maintained and adhered to ELT and Data Integration Standards. Participated in peer reviews on specifications, design and code. Validated the data in the database and also responsible for testing the routines developed. Worked closely with QA and Operations to ensure smooth QA and deployment of applications. Worked with project teams to plan integration and implementation strategies.

Data Architect

Confidential, San Francisco, CA/Milwaukee, WI

Responsibilities:

• Confidential ’s Corporation is one of the biggest retail companies in US. Confidential ’s stores and its ecommerce site Kohls.com feature nationally recognized brand-name merchandise, exclusive labels, and private-branded goods. The purpose of the project was to redesign its ecommerce site KIohls.com with new features and a clean navigation of the site. The project also involved a complete revamp of the site search, zoom features and its shopping lifecycle.
• Created artifacts defining key architectural considerations for Confidential ’s Enterprise Business intelligence (BI) and data warehouse system that provides data import, ETL, data analytics, and data mining services for the 40 states Sales force.
• Designed, developed, and implemented a Decision Support System (DSS) for the Personal Product Division at Confidential ’s Inc. The DSS application was designed in a two-tier client/server environment that integrated various platforms - OS/2, Windows 2003, IBM 3090, and AS/400. Tasks included the design and development of a Graphical User Interface (GUI) using Commander Builder (EIS), the design and developmentof a multi-dimensional database (MDDB) application using Essbase that stored and maintained company's financial, marketing, and sales data, and the loading and manipulation of the data into the database using ADL and Essbase SQL Interface. Additional tasks included installation, configuration, and support of package software, users, documentation, and production support.

Data Architect

Confidential, Dallas TX

Responsibilities:

• Confidential wanted to have this application to increase efficiency levels in working and to have better and closer interaction with the Nissan customers. Over 700 employees will be using the Siebel system to manage customer and dealer accounts and relationships. The application provides a common platform for many different departments like collections, transaction processing, Lease customer network, Legal etc. to process various business processes and customer requests.
• Served as a Data Warehouse Specialist/Consultant in the enhancement and development of enterprise data warehouse/business intelligence application for the automotive services at Nissan Corporation. Primary focus and/or development efforts were in the reengineering of the ETL processes using the Oracle Data Integrator (formerly known as Sunopsis) tool. Analysis, design, and construction of the enterprise data warehouse environment for retail analytics (marketing, sales, financials credit, etc.). The overall architecture included a staging area for the near-real-time import of source and external data, an operational data store aimed at data reconciliation, data normalization, data cleansing and business rule enforcement, and a data mart structure intended for the bulk of the reporting needs upon periodic snapshots (and aggregations) of ODS data.

Data Architect

Confidential, Middletown NY

Responsibilities:

• The Project was to enhance and integrate Commercial off the shelf (COTS) web based Electronic Health Record (EHR) NextGen 5.5 software system and provide a better approach to documentation then conventional, paper based system. This software system increased access, eliminated illegible handwriting related errors, improve quality of care and security, reduced documentation expense and mitigate malpractice liabilities. The main features in this software included powerful search, virtual sticky notes, encounter based documentation and template text. Specialty module includes Allergy, Cardiology, Gastroenterology, General Medicine, pain management, OB-GYN and pediatrics. Analyzed plan requirements and then contributed further defining the plan requirements with client Data Architect. Observed the compliance of the requirements with federal and state government regulations Medicaid, Medicare, and accreditation body requirements.
• Brought changes for system design, methods, procedures, policies and workflows affecting Medicare/Medicaid claims processing in compliance with government compliance process like HIPAA/EDI formats and accredited standards like ANSI.

Data Architect

Confidential, Sunnyvale CA

Responsibilities:

• As Confidential was one of the pioneers of the SCRUM methodology, I was involved in software development as part of the SCRUM team, and later became SCRUM master for various different builds.
• Project responsibility Involved in creating the User Interface Specification Document and User Manual as per project specification with the help of development team.
• Gather BRD after conducting JAD sessions with business users and other stakeholders.
• Elicited functional requirement documents, WBS,RTM,SRS.
• Analyzed requirement and created Activity Diagrams and context Diagram.
• Acted as a liaison involving stakeholders, system users, client and managers, and the software development team to gather requirement.
• Written Test cases for system test and user acceptance testing (UAT) to improve overall quality of the application.
• Worked closely with the product managers and developers to resolve issues.
• Defined high level system actors and converted the business requirements into Use Cases.
• Used Sql queries to extract data from different databases including testing and production for data validation and data analysis. Participated in testing software by conducting User Acceptance Testing (UAT).
• Followed UML methodology to create UML Diagrams including Use Case Diagrams, Activity Diagrams, Data Flow Diagrams, ER diagrams using Rational Rose and MS. Visio and thus defining the Business Process model and Data Process Model.
• Worked with programmers to formulate design specifications and structured analysis models.