SUMMARY:

• Extensive experience in managing complex business intelligence and data analytics projects/programs in both Enterprise Architect and Project Manager Roles.
• Results oriented technology leader and architect with 20 years of experience in planning, designing, developing, implementing and managing Big Data, Data warehouse, Business Intelligence and Analytics organizations.
• Extensive experience in requirement solicitations, documenting functional and business requirements in enterprise setting.
• Excellent technical, communication, facilitation skills and proven ability to collaborate with senior leadership to solve complex problems.
• Equally adept managing multi - year engagements with large teams as well as taking on active role as architect designing complex analytics solutions.
• Extensive experience with Models & Architectural Frameworks such TOGAF and DAMA.
• Expert level skills in data modeling - both relational (3NF) and multidimensional star-schema data modeling (Kimball approach) in a multi-terabyte environments and hands on expertise with Erwin, ER Studio and Enterprise Architect modelling tools.
• Expertise in using Cloud based managed services for data warehousing/analytics in Microsoft Azure (PowerBI, Azure Data Lake Analytics, Azure Data Lake Storage, Azure Data Factory, Azure Table Storage, U-SQL, Stream Analytics, HDInsight, etc.)
• Business Analytics, Data warehousing, OLAP, Operational Data Stores, and Data Marts on both Oracle and SQL Server Platforms.
• Extensive experience in implementing Enterprise Information Management solutions with Data Governance, Master Data Services and Data Quality Services.
• Implementing Master Data Management solutions with Informatica MDM and Microsoft Master Data Services.
• Experience in building cloud based business intelligence systems - Machine Learning, Predictive and prescriptive analytics.
• Engaging leader and team member that builds and inspires loyal, high performance, cross-functional global teams that drive for results.
• Hands on experience with a variety of reporting and data visualization tools such as Power BI COGNOS, Business Objects, Microsoft SSRS/Performance Point and Tableau.
• Extensive experience in building Ad-hoc models for enabling self-service Business Intelligence.
• Metadata management using end-to-end lineage of data definitions from source to target.
• Agile/Scrum & Waterfall Development Methodologies
• Expert level skills in building web based applications.

SKILL:

Certified Data Management Professional | Project and Program Management | Enterprise Data Architecture|| Application Development | Business Intelligence & Analytics| Big Data | Data Science | Data Lake | Data Warehouse | Data Integration | Master Data Management | Vendor Management and Relationship.

TECHNICAL SKILLS:

Data Modelling Erwin (7.x, 8.x, 9.6), ER Studio/ Data Architect 7, Enterprise Architect (10.x, 11.x)

RDBMS: Oracle 8i, 9i, 10g, SQL Server 2000, 2005, 2008 R2, 2012, 2014, 2016 SQLite and DB2

No SQL Databases: Azure Cosmos DB, HBase and Mongo DB

Extract, Transform and Load: IBM Infosphere Data Stage, Microsoft SSIS and Kettle

OLAP Modelling: ROLAP and MOLAP models with COGNOS 10 BI and SQL Server Analysis Services (in Both Multi Dimension and Tabular including MDX).

Big Data & Cloud: Azure, HD Insight, HDFS, Spark, Hive, HBase, Azure Data Factory, Azure Data Warehouse and Azure Storages.

Data Science: SPSS, ‘R’ and Azure Machine Learning Studio.

BI/Reporting/Visualization: Power BI, Tableau 8.x and 9.x Desktop and Server, COGNOS 9.x and 10.x Query Studio, Report Studio and Analysis Studio, Microsoft - MS Performance Point, MS SSRS and Business Objects

SQL: DDL (Data Definition Language), DML (Data Manipulation Language), Stored Procedures, Triggers, User Defined Functions and complex queries in both PL/SQL and T-SQL flavors.

Languages and Others: C#, Visual Basic, Java Script, ASP.NET, REST Services and Web Services and Jira for collaboration.

WORK EXPERIENCE:

Confidential, Austin, Texas

Enterprise Data Architect and Technical Project Manager

Responsibilities:

• Responsible for overall direction, design, development and deployment of the Analytics platform for the Institutional Research group at UT Austin.
• Manage the team resources, scrum planning and backlog grooming.
• Coordinating the stakeholder meetings and identifying the business requirements.
• Creating Logical/Physical data models using ERWIN based on functional requirements
• Defining Information Governance Effort, Data Stewardship and maintaining Metadata Information.
• Data profiling and Data Standardizing of source data
• Designing data flows end to end for MDM systems
• Designing Probabilistic/Deterministic matching rules to identify suspects in student data.
• Importing and creating server level metadata for all the source systems using Metadata Asset manager and designing ETL Metadata layer and QA/QC validation
• Creating relationships to assets using Governance Catalog/Glossary Anywhere to derive meanings of database level objects to users and business analysts.
• Led Data warehouse project proposal, architecture, technologies, cost estimates, resources, team resources
• Delivered proof of concept and strategic direction to executives for Azure SQL, SQL MI, and SSIS in Azure
• Setting up PowerBI Environment, creating app workspaces, publishing apps and setting up PowerBI Gateway.
• Utilized Power Query in Power BI to Pivot & Un-pivot the data model for data cleansing and data massaging.
• Performance tuning, version upgrades and migrations of all versions of SQL Server.
• Drive Architecture for migration from flat-file solutions to REST service based solutions

Confidential, Austin, Texas

Principal, Project Manager

Responsibilities:

• Set-up and initiate projects using PMI guidelines.
• Establish work plans, milestones and phase approach.
• Coordinate resources necessary to ensure appropriate project coverage.
• Serve as liaison between project sponsor, top executives, subject matter experts and end users.
• Manage and report overall project scope, schedule, resources, and budget
• Backlog grooming and risk mitigation strategies.
• Followed Kimball methodology for building the initial Data Warehouse Bus Matrix to map the business processes to the entities that participate in those processes. Sources include ERP systems for HR, Financials and Operations.
• Designed various components of DW/BI systems, these include - ETL system, BI system, security system, audit and maintenance systems.
• Create knowledge base’s for data quality services
• Defining architecture for Information Governance Platform
• Designing HBASE/Hive tables and creating ETL architecture
• Creating Data Migration plans from Premise to Cloud
• Designing structured, unstructured, semi structured foundation layers on Azure Data Lake and Big Data Pipelines using Azure Data Factory
• Designing structured, unstructured, semi structured foundation layers on Azure Data lake and Big Data Pipelines using Azure Data Factory
• Designing Dashboards, Reports, KPI's in Power BI Cloud/Server
• Experience in writing Direct query, creating relationship between imported entities, derived column, measures, (visual, page and reports) filters, Role level security using DAX functions.
• Maintained existing PowerBI reports and dashboards and made changes onto the same as per new and changing business requirements.
• Creating HDInsight framework to manage Hadoop clusters
• Utilize U-SQL for data analytics/data ingestion of raw data in Azure data lake and Blob storage
• Run U-SQL for Data validations on structured data on SQL Data Warehouse
• Followed Kimball methodology for building the initial Data Warehouse Bus Matrix to map the business processes to the entities that participate in those processes.
• Developed the business process dimensional model in conjunction with business system analysts and business users. Created conceptual model for review with business users.
• Worked with Database Administrator to develop overall physical design including disk layout, partitioning, and indexing for faster retrieval of data. Used various partitioning and indexing features including multi-dimensional clustering, range partitioning, and dynamic in-memory columnar technologies.
• Worked with BI Developers to map ad hoc and canned reporting capabilities to requirements from internal and external business users.
• Visualizations with Tableau and Power View.
• Design, Install and Configure the Analytics platform for the university including the hard ware configuration.
• Set the SharePoint 2013 farm including Kerberos authentication.
• Mentored and worked with the University staff to create conceptual, logical and physical models based on Kimball methodology for the data marts.
• Set up Proof of Concept for Business Intelligence Semantic Model connections.
• Design and Develop Cubes in both Multi-dimensional mode and Tabular mode.
• Requirements gathering and analysis to implement interfaces between Legacy systems and the new GRM COTS solution.
• Source target mapping.
• Metadata management.
• Design and create data model for the Data Marts.
• Design and develop OLAP cubes.
• Design and develop the data driven framework with SSIS for the interfaces.
• Design and develop the logging and notification for the data driven framework.
• Create SSRS reports for providing the feedback on the data driven framework.
• Install and configure SSRS in SharePoint integrated mode to deploy SSRS reports.
• Requirements gathering, analysis for Charter Schools - School First web based application and analytics solution.
• Produce design artifacts such as Architecture diagram, class diagram, sequence diagram and Deployment diagram for the project.
• Used Tivoli Identity Manager and Tivoli Access Manager for security.
• Abstract the business rules for calculations in ILOG- Business Rules Management system.
• Performed detail data analysis including data profiling of various source systems to develop detailed logical dimensional model using IBM Infosphere Data Architect. Identified the facts and dimensions for the dimensional model.
• Designed various components of DW/BI systems, these include - ETL system, BI system, security system, audit and maintenance systems.

Confidential, Austin, Texas

Team Lead

Responsibilities:

• Redesign and upgrade the legacy system to a web based application on .NET platform.
• Organize JAD Sessions to design the logical and physical data models using ERwin.
• Designed star schema data model, defining a new hardware architecture and physical database implementation, and redesigned the ETL process.
• Built a meta-data management system as part of the re-design effort.
• Manage team size of six developers.

Confidential, Austin, Texas

Technical Lead

Responsibilities:

• Led the team in design and development of web based application for School Finance
• Led the team of eight developers.
• Design and build interfaces for seamless data transfer to PeopleSoft financial system.
• Design and build processes to calculate funding ($13B) for over 800 school districts on Texas.