PROFESSIONAL SUMMARY:

• 10 plus years of experience in design, development and implementation of data warehousing applications for multiple domains like healthcare, life sciences, Banking, Manufacturing and retail industries.
• Worked with clients to design and implement solutions on areas like data acquisition, batch and real time data integration, data cleansing and master data management.
• Involved in EDW design, self - service BI enablement and the creation of BI reports and dashboards using market leading tools and technologies.
• Hands on experience in using big data technologies and the Hadoop eco system.
• Present area of interest includes analysis of unstructured data and its integration with a conventional data warehouse.
• Building customer centric data warehouses for the healthcare and life sciences industries
• Master data management, match and merge, de-duplication and data cleansing
• Data modeling (OLAP and OLTP)
• Source system analysis and standardization across disparate systems
• Analysis of unstructured and semi-structured data using big data technologies and the Hadoop eco system
• Working with high volume and varied data sets to derive analytical value from them
• Batch and real time data integration
• Performance tuning and benchmarking for analytical and transactional applications
• Self-service and mobile BI using industry leading tools and technologies
• Strong in SQL and PLSQL scripting
• Lead projects for developing and implementing data warehousing solutions
• Responsible for building a consulting practice to service clients from multiple domains.
• Strategic planning and sales enablement.
• Project Management and thought leadership skills
• Solution Architect and technology brainstorming
• Part of the consulting team responsible for customer engagements for multiple BI/DW solutions.
• Part of multiple “deal-winning” proposals and defense meetings amounting to millions of dollars.
• Driven the re-use of key concepts across different products and built consistent architectures from ground up
• Presented ideas at conferences and architectural forums which were well received

SUMMARY OF TECHNICAL SKILLS:

BI & Visualization Tools: QlikView, iDashboards, OBIEE, Cognos, Business Objects, MSBI

ETL& Data Integration Tools: Pentaho, Talend, Informatica power center, Oracle Data Integrator, SSIS

Big Data Technologies: Hadoop Ecosystem (HDFS, Hive, HBase, sqoop), Windows HD Insight, IBM Big Insights

Predictive and Pattern Based Analytics: Quantum Leap Analyst (QLA) tool for pattern based and predictive analytics

Databases: Oracle, SQL Server, DB2

Design/Development Tools: Erwin, Toad, Oracle SQL Developer, Oracle SQL Developer Data Modeler

Languages: SQL/PLSQL, C, C++, Java, C#

Operating System: Windows, UNIX, Solaris

PROFESSIONAL EXPERIENCE:

Confidential

Solution Architect

Tools: Oracle 11g, Informatica 8x, Business Objects

Responsibilities:

• Designing the data aggregation, storage and manipulation modules for the project.
• He also worked on the metric calculation platform design and the BI analytical reports module
• Data Integration and data mapping with source systems
• Master data management schema design
• Code review and unit testing
• Data governance activities
• Project management activities

Confidential

Solution Architect

Tools: Oracle 11g, Hadoop eco system (HDFS, Hive, Sqoop), Pentaho, Qlikview

Responsibilities:

• Working with the customer to analyze the source systems and define the mapping between the source and target tables
• He worked on design and implementation of the ETL jobs to load data into HDFS
• He also worked on analysis of the data and finally loading the processed data from HDFS into the database
• Define standard BI reports out of the processed data using Qlikview
• Code review and unit testing
• Project Management activities

Confidential

Data Architect

Tools: Oracle 11g, OSDM 3.0, Informatica 8x, OBIEE 11g

Responsibilities:

• Working with partners and customers to identify patterns in their use cases and map them to the conceptual data model design
• Creation of conceptual, logical and physical data model
• Data Integration from sources to staging and from staging into the warehouse
• He added various components during the design phase and also worked with senior architects in the team to decide on the partitioning and indexing strategies.
• He built prototypes using OBIEE and informatica to demonstrate the flexibility of the model which were used to drive important POCs
• End user training
• Product release notes and installation document creation
• Data Model Design review

Confidential

Data Architect

Tools: Oracle 11g, OSDM 3.0, Informatica 8.6, OBIEE 10g

Responsibilities:

• Designing key architectural concepts like MDM and de duplication
• Part of the design team that worked on HDWF data model from its inception.
• Modeled some of the clinical and non-clinical subject areas of HDWF logical and physical data models.
• Data model review
• User training, release notes and installation guide preparation
• Worked with the sales and consulting teams to help customers and partners understand and implement HDWF.

Confidential

Data Modeler

Tools: Oracle 11g, OSDM 2.0, OBIEE 10g

Responsibilities:

• Ujjwal worked with Oracle product strategy and product managers to define the conceptual model.
• He oversaw the extension of the conceptual model into logical and physical designs.
• He defined the partitioning and indexing strategies that proved to be the key for meeting all customer performance SLAs.
• Performance tuning of user queries
• Design of the reporting module using OBIEE
• Data integration from disparate sources
• Code review and unit testing

Confidential

Data Architect, Data Modeler

Tools: Oracle 10g, OSDM 2.0, OBIEE 10g

Responsibilities:

• Developing the conceptual, logical and physical data models for the product.
• Worked with the reporting and ETL teams to ascertain a smooth transition of the design to the development teams.
• Generation and maintenance of DDL scripts for the physical deployment
• Data model review
• .Product technical documentation