CAREER SUMMARY:

• Seasoned IT professional with experience in all phases of SDLC
• 10+ years of experience providing consultative and technical leadership focused on requirements gathering, solution architecture design, Data warehouse, Data Integration, Data Analysis, ETL, Data Modeling, Data Strategy and Roadmaps, and Data management, Big Data
• Proven successful experience in creating solutions for enterprise data initiatives having led onshore/offshore team including junior architects
• Big 5 Consulting firm experience
• Strong experience in creating reference architecture, architecture framework, data flow diagrams and solving complex business problems.
• Experience in developing analytical solutions including predictive, prescriptive, and descriptive analytics.
• Experience in developing data lake, data hub, and functional data ponds using Hadoop and its ecosystem.
• Sound knowledge in developing Machine Learning models including linear and logistics regression using R programming language.
• Deep understanding of Python.
• Sound experience in Agile methodology
• Provide technical thought leadership on developing Big Data Reference Architecture, Strategy and Roadmaps.
• Hands - on experience with Architecture/Implementation of Data Lake’s and AWS Big Data Analytics platforms on cloud using Hortonworks Hadoop ecosystem.
• Expert level understanding of open source technologies around Hadoop ecosystem.
• Successful delivery of the projects from conceptual phase to the final product.
• Involved in the full life cycle of the data integration building process including architecture design, ETL primarily using Informatica 8x, Talend 5x, and Confidential Information Server (DataStage 8.0.1).
• Strong Knowledge of Ralph Kimball’s Dimensional modeling methodology including designing the STAR schema.
• Deep knowledge and implementation experience of TOGAF and Zachman Architecture framework
• Involved in sales bid including RFP response, solution presentation and closure of sales.
• Managed project scope, schedule and budget of $3 million.
• Maintain a broad industry perspective on relevant best practices for creative data solutions.
• Understanding and implementation experience of governance process, best practices in Data Management and database technology.
• Understanding of how best to measure success with regard to data warehouses, marts, data mining, profiling, ETL, integration, distributed data file systems.
• Establish strong working relationships with the business and IT partners.
• Create and maintain strong formal line of communication on approaching issues with an ability to assess quickly and respond with a sense of urgency.
• Use active listening to understand business needs and recommend the appropriate solutions.
• Demonstrate ability to work in a team environment and foster collaboration.
• Inspire a sense of urgency with regard to data design solutions and develop support and a culture of quick problem assessment and resolution.
• Ensure documentation around data is captured appropriately and is accessible to others.
• Passion to learn new tools around Big Data, statistical reporting.
• Possess creative approach to problem solving.
• Strong influencing and negotiation skills.
• Proven technical leadership, written and verbal communication skills.
• High service orientation and ability to measure delivery and implementation success.
• Ability to understand a problem from multiple perspectives and different points of view.
• Experience in leading the technical team onshore and off-shore.
• Experienced in Data Integration of Advanced Metering System (AMS) Smart Meter system applications.
• Experienced in project management using MS Project, Confidential Rational Project Management

AREAS OF EXPERTISE:

Demonstrated capabilities: Solution Architecture | Project Management | Technical Leadership | Pre - Sales | Proposal Solutions | Resource Planning | Mentoring | Onshore/Offshore Team Coordination

Data Management areas: Data Architecture | Information Architecture | Enterprise Data Warehousing | Business Intelligence | Data Governance | Data Analysis |Master Data Management | Data Integration | Big Data (Hadoop and eco system) | Data Science

Industry Specialties: Electric utility AMI/AMS Smart Metering | Insurance | Non-profit | Education | Retail | Telecommunication | Big 5 consulting ( Confidential, Confidential, Confidential and Confidential )

TECHNICAL SKILLS:

Tools: Description/Vendor

Project Management: MS Project, Rational Portfolio Manager

ETL: Confidential Information Server 8.0.1, Informatica PowerCenter 6.2/7.1.2/8x/9x

Data Replication: Informatica Power Exchange

Data Quality: Develop custom tool in PL/SQL, Informatica Data Quality, Confidential QualityStage

Data Modeling: Embarcadero ER/StudioXE7, ERWIN4.1,7.x, Enterprise Architect 7.1(SPARX), ModelSphere (Open Source), Confidential Infosphere Data Architect

Databases and NoSQL Databases: Microsoft SQL Server 20xx, Oracle 12c,11g,10g,9.2,8i,7.x, Informix Time Series, Cassandra

BIG DATA distribution and eco system tools: Hadoop, Hortonworks, cloudera, Hive, PIG, Sqoop, Kafka, Apache Spark

Shell Scripting: KORN Shell

Languages: SQL, TSQL. PL/SQL, Python, XML

Meta and Business Glossary: Informatica Meta Data and Business Glossary, Confidential Infosphere Meta data and Business Glossary

Operating Systems: UNIX, AIX, Confidential p6, SUN Solaris 5.2, Windows, Linux

PROFESSIONAL EXPERIENCE:

Confidential

Enterprise Data Analytics Architect

Responsibilities:

• Responsible for assessing business use case for Big data, Data warehousing and Business Intelligence and defining the strategy and roadmap, and technical architecture
• Hands-on and management experience implementing the Big Data, Data warehouse and Data solutions
• Implemented Data Lake Analytics platform using Hive data model on AWS cloud and Hadoop Cloudera distribution .
• Involve in data analysis and data mapping
• Involve in data modeling and customizing insurance industry model to meet the farmers business requirements
• Develop End-End Solution Architecture design document
• Hands-on experience implementing Reconciliation framework for data certification
• Managing and mentoring onshore/offshore technical team

Environment: ERWIN data model, SQL Server 2014, Oracle 12, Informatica 9.x, Visio, MS Project Plan, Cognos, Tableau, AWS Cloud, Sqoop, Cloudera

Confidential, Seattle WA

Big Data Solution Architect

Responsibilities:

• Provided technical thought leadership on Big Data strategy, adoption, architecture and design, as well as data engineering and modeling.
• Hands-on implementing hive data model using AWS cloud and Hadoop distribution to serve the data as a service to data scientists and key business users.
• Led workshops, meetings with clients and key stakeholders to gather requirements, analyze, finalize and have formal sign-offs from approvers.
• Proven track record to drive rapid prototyping and design for new projects.
• Ability to translate broader business initiatives into clear team objectives and concrete individual goals, aligning appropriately with other groups for efficient, coordinated action.
• Defined and implemented the strategy and roadmap for enterprise data (structured and unstructured, implementation and data management for new data sources, publicly available data, business-to-business partnerships and advanced Data Analytics systems.
• Draws conclusions and effectively communicates findings with both technical and non-technical team members.
• Worked with business and IT community to understand the business requirements and business processes, design data warehouse (DW) schema and define extract-translate-load (ETL) and/or extract-load-translate (ELT) processes for DW and Data lake.
• Developed technical design document, architecture artifacts, data flow diagrams, standards and best practices document, audit, balance, control framework
• Provided active leadership skills across project team and business community including mentoring to technical team.
• Experience in and understanding of a wide variety of analytical processes (governance, measurement, information security, etc.).

Environment: Embarcadero ER/Studio, Hadoop (Horton Works), hive, Kafka, Sqoop, SQL Server 2014, Talend 5x, Visio, MS Project Plan, MicroStrategy, Tableau, AWS Cloud

Confidential, Phoenix, AZ

Enterprise Data Architect

Responsibilities:

• Responsible for assessing business use case for Big data, Data warehousing and Business Intelligence and defining the strategy and roadmap, and develop Modern Data Architecture
• Involved in projects implementing Data Lake, Big Data Analytics and Modern Data warehouse applications
• Provide architecture recommendations, strategy, data architecture and implement enterprise data solutions
• Evaluation of best of breed Big data, Hadoop and cloud based products for various types of data integration and processing implementations
• Build data warehouse using hive to meet the requirements of business users
• Successful delivery of the projects right from conceptual phase to the final product
• Implement TOGAF architecture framework
• Manage onshore/offshore architecture and development team
• Involve in establishing a Data Governance team
• Interface with client senior management to report on project and program milestones and to present project needs
• Develop framework for audit, balance, control, business glossary and meta data, Archival and Retention policies

Environment: Erwin data model, Hadoop (Horton Works), MS SQL Server 2012, Oracle 12c, Informatica 9x, Visio, MS Project Plan, Cognos, Tableau, Elastic Search, Sqoop, Hive

Confidential, Dallas, TX

Enterprise Data Architect Lead

Responsibilities:

• Establish processes for governing the identification, collection, and use of corporate metadata.
• Establish methods and procedures for tracking data quality, completeness, redundancy, and Improvement.
• Conduct data capacity planning, life cycle, duration, usage requirements, feasibility studies, and Other tasks.
• Create strategies and plans for data security, business continuity, and archiving.
• Ensure that data strategies and architectures are in regulatory compliance.
• Create and communicate of IT plans, policies, roadmaps, and technology Initiatives
• Design data warehouse project of Transmission Asset-Location system with the sources Maximo Asset Management System, ePeople (HR), Oil Analysis system, Vehicle Management System etc.
• Led the technical team of both onshore and off-shore. The primary responsibility includes project planning, staffing, periodic assessment, and delivering the work.
• Solid experience in utility Transmission Assets.
• Solid experience in data integration architecture.
• Solid experience in Data warehouse and Data Marts.
• Involved in requirement gathering through face-to-face meetings, workshops, and interviews.
• Involved in designing a Dimensional Model of large Data Warehouse.
• Implemented Star Schema type 2-dimensional method.
• Involved in preparing work orders, provide technical solutions to new pursuits
• Identified project risks and develop mitigation plan

Environment: Erwin data model, Oracle 12c, Informatica 9x, Visio, MS Project Plan, Cognos, Tableau

Confidential, Dallas, TX

Solution Architect

Responsibilities:

• Developed solution for utility Meter-Cash and Customer Care analytics.
• Ability to manage technical team and client expectations
• Worked as Data Architect/Informatica Architect at various clients
• Hands-on experience in Informatica Power Center 8.x
• Experienced in SDLC process
• Experienced in leading onshore/offshore teams
• Involved in writing the response to request for proposal
• Involved in firm development projects

Environment: Erwin data model, Oracle 11, Informatica 9x, Visio, MS Project Plan, Cognos

Confidential, Seattle, WA

Senior Technical Architect

Responsibilities:

• Responsible to generate the revenues by providing the technical solutions to the client’s requirements.
• Managed the team of data architects/application architects at on-site and off-site.
• Involved in writing the response for the proposals.
• Managed the scope of the project, budget, and delivery.
• Identify Risks and prepare mitigation plan.

Environment: ModelSphere, MSQ SQL Server 2012, Oracle 11, Informatica 9x, Visio, MS Project Plan