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.
• Oracle e-Business suite, SAP ERP 6.0, MS Business suite,NASSCO (healthcare0
• Other: Adobe Photoshop, Microsoft Visual Studio, ASP.NET, Eclipse IDE
• IBM Web Sphere Date Stage / Quality Stage v 8.0
• EDW, CDW, Data marts, OLAP & ODS
• Web Reports, Mobile Reports & dashboards, Mash-ups
• Database/ BI Support (DBA, ETL,E-LT, Reports/ Dashboard Monitoring)
• Database: MySQL and Microsoft SQL Server2005, SQL Server 2008 R2, MS. ACCESS.NoSQL Technologies (combination of Hadoop, 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.
• Requirement Management Tools: IBM Rational Requisite Pro V 7.1.2, Rational DOORS 9.0.
• Dashboards, Strategic maps, Balance Scorecards, qlikview
• Data Mining, Predictive Analytics, Heat Maps
• HP Quick Test Pro 8.2-11.0, HP LoadRunner 8.0-11.0, HP Service Test 11.0, JMeter 2.4,Selenium RC, JUnit.
• Configuration Management: Microsoft VSS, CVS, IBM Rational ClearCase.

TECHNICAL SKILLS:

Database: MySQL and Microsoft SQL Server2005, SQL Server 2008 R2, MS. ACCESS.NoSQL Technologies (combination of Hadoop, CouchBase, Cassandra and MongoDB

Concepts: Zachman Frameworks, TOGAF

Engagement Experience: Multi-million Dollar projects . Client Facing Techno Functional Consultant for fortune 500 companies.

Query Tools: Apache Drill,SSMS,TOAD

Methodologies: SCRUM,AGILE,RUP,Waterfall

Microsoft Tools: MS. Project, MS. Office, MS Sharepoint, MS Frontpage,MS VISIO

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Solution Architect/Big Data Engineer

Environment: NASSCO-ERP,Michigan Operating System, Hadoop (Map Reduce, HDFS, Hive, Pig, Java, SQL, Scoop, Flume, Oozie, Eclipse, informatica).

Responsibilities:

• Conducting extensive study that helped architect a new solution for Large Group Business with the Highmark Plan. Build a roadmap, cost estimates and implementation plan to deploy the Highmark Solution.
• Lead 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 process by conducting deep analysis and data profiling that helped architect a new solution for Large Group Business with the Highmark Plan.
• Build a roadmap, cost estimates and implementation plan to deploy the Highmark Solution.
• Organization of all 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. Building high quality Logical and Physical Data Modeling, including relational, dimensional and flat-file data structure.
• Designed and implemented an adhoc POC for the BCCM (BCBSM Consolidated Customer Master data - Clinical Trial Relationship Management System data) using IBM Web Sphere Date Stage / Quality Stage v 8.0 including Address Doctor to demonstrate additional capabilities within Address Standardization for future upgrade.
• Provided solution and led Developers and Architects to design Confidential Big Data Customer 360 use case.
• Lead the open-source development of company's flag-ship project, NonStop HBase. Defined and delivered Hadoop platform stack including data storage and high-performance in-memory processing technologies.
• Design the next generation data architecture for the unstructured data at BCBSM as well as writing, debugging, and analyzing the performance of many map reduce jobs to realize that architecture.
• Design an Information architecture 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, whether they be business users, analysts, or data scientist.
• Setup Big Data infrastructure and built batch/real time processes, deploying Hive,Ooozie and MySQL customization for batch data platform. Implemented Sqoop to import data from MySQL .
• Perform 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.
• 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.

Confidential

Sr. Enterprise Architect

Environment: SFDC, SAP ERP, Hadoop, Map Reduce, HDFS, Hive, Pig, Java, SQL, Scoop, Flume, Oozie, Eclipse & informatica.

Responsibilities:

• Create a single repository that avoided single view integrations, and enabled quicker insights and improved access to metrics.
• In a Senior Enterprise Data Architect role regularly communicated Business Intelligence and Data Warehousing concepts to both our corporate Business managers and Technology partners. Blending a variety of operational & transactional (CRM and Vendor’s) data sources to create an on-demand analytical view across customer touch points to better surface the customer experience.
• Provided customer-facing employees and partners with information made available inside everyday line-of-business applications.
• Ensuring 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. Building high quality Logical and Physical Data Modeling, including relational, dimensional and flat-file data structure
• Lead 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.
• Assist with the addition of Hadoop processing to the IT infrastructure. Devised and lead the implementation of the next generation architecture for more efficient data ingestion and processing.
• Analyze the data by performing Hive queries and running Pig scripts to combine data set. Implementing business logic by writing PIG UDF’s in java and handle ingesting of data from various data sources, using FLUME and SCOOP and performing transformation using Hive, Map Reduce, while loading data into HDFS
• Train middle and top management who were stakeholders 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
• Worked with qlikview developers and architected Data models for their extensive reports using combination of charts and tables.

Confidential

Sr. Data Architect

Environment: Oracle EBS

Responsibilities:

• Interface with a variety of business and technical stakeholders to gather and solidify requirements for data analysis and report generation, create profilic queries to extract data, interpret data, and develop test for projects.
• Manage Project budgets, conduct risk analysis and mitigation, issue management, root cause analysis, project schedule development and tracking using MS. Project.
• Build Dashboard Project to help the Customer Support Managers, analyze performance of the Technical Support Engineers based on various Key Performance Metrics at World Wide location at different regional level.
• Lead the business team in specifying the requirements for ETL Data that implemented Sybase replication for change data capture on the source systems.
• Deliver Major BI Data into implementation within large structured telecom enterprise environment. Working with cutting edge application of architecture frameworks, formal SDLC and Application Development methodologies.
• Utilize 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.
• Participate in peer code reviews to ensure proper documentation on features and interoperability within the entire system. Ensure new code, feature or software product meets performance goals and does not adversely impact the performance of existing subsystems.
• Perform predictive analysis using IBM SPSS Modeler. Based on an intuitive visual data flow process of analysis, models and reports to create and 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.
• DevelopEnterpriseDataPrinciples and Governance structure while setting of management guidelines.

Confidential

Data Architect

Environment: Oracle EBS

Responsibilities:

• Design, develop, and administration of several Oracle database applications exceeding 50 Gbytes in data, Oracle performance tuning, translation of business requirements into database application design and data models.
• Develop Conversion Component in Projects Accounting Module and migrate data from a Legacy System to Oracle Applications.
• Assist in developing and publishing data management standards, policies and procedures, including management and maintenance of related tools and environments.
• Collaborate with Oracle Database Administrators for the Data Warehouse design, data model, storage, security, performance and data environment requirements.
• Perform maintenance and support of existing applications. Establish, maintained and adher to ELT and Data Integration Standards. Participate in peer reviews on specifications, design and code.
• Validate data in the database and test design workloads. Work closely with QA and Operations to ensure smooth deployment of applications.
• Work with project teams to plan integration and implementation strategies.

Confidential

Data Architect

Environment: Microsoft Business Suite

Responsibilities:

• Design and develop a Graphical User Interface (GUI) using Commander Builder (EIS).
• Solution Design Document
• Requirement gathering from Business Users
• Analyzing scope and requirements
• Data Quality Management Document
• Source to Target mapping Documents
• Data Dictionary and Glossary of Data elements
• Design Framework ETL, RPD and Reports
• Develop various processes, forms and reports to suffice business needs
• Coordinate with Offshore Team to develop reports
• High and Low level design documents.
• Migration to Production Documents
• Design and develop of a multi-dimensional database (MDDB) application using Essbase that stored and maintained company's financial, marketing, and sales data, while loading data into a database using ADL and Essbase SQL Interface.
• Install, configure, and support of package software, users, documentation, and provide production support.

Confidential

Data Architect

Environment: Oracle E-Business Suite

Responsibilities:

• Serve as a Data Warehouse Specialist/Consultant in the enhancement and development of enterprise data warehouse/business intelligence application for the automotive services.
• Re-engineered of the ETL processes using the Oracle Data Integrator tool.
• Analyze, design, and construct the enterprise data warehouse environment for retail analytics (marketing, sales, financials credit, etc.).
• The overall architecture include 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.
• Requirement gathering from Business Users
• Analyzing scope and requirements
• Data Quality Management Document
• Source to Target mapping Documents
• Data Dictionary and Glossary of Data elements
• Design Framework ETL, RPD and Reports
• Develop various processes, forms and reports to suffice business needs
• Coordinate with Offshore Team to develop reports
• High and Low level design documents.

Confidential

Data Architect

Environment: Microsoft Business Suite

Responsibilities:

• Analyzed plan requirements and then contribute further defining the plan requirements with client Data Architect. Observed compliance of the requirements with federal and state government regulations Medicaid, Medicare, and accreditation body requirements.
• 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.
• Develop and implement corporate-side and client-side short and long-term technology security solutions to meet the evolving Information Technology needs of organizations.

Confidential

Data Architect

Environment: Microsoft Business Suite

Responsibilities:

• Create 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.
• Elicit functional requirement documents, WBS,RTM,SRS.
• Analyzed requirement and created Activity Diagrams and context Diagram.
• Act as a liaison involving stakeholders, system users, client and managers, and the software development team to gather requirement.
• Write Test cases for system test and user acceptance testing (UAT) to improve overall quality of the application.
• Work closely with the product managers and developers to resolve issues.
• Follow 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.