SUMMARY

• Expertise in BIG DATA (Hadoop) technologies - Hive, Sqoop, Hbase, Map Reduce and HDFS, Kite SDK, Avro Schema evolution
• Expertise in Data Virtualization - Denodo
• Expertise in Dimensional Modeling - Star and Snowflake
• Expertise in Conceptual, Logical and Physical data models - OLTP and OLAP.
• Expertise in ETL Architecture, Design & Development - INFORMATICA 9.x
• Strong experience in developing home grown ETL frameworks - PL/SQL and T-SQL programming
• BI Schema Architecture- Schema objects, Public objects, Report service documents - MICROSTRATEGY 9.x
• Business Intelligence in Cloud based Environment
• Demonstrated expertise in EDW Solution and Data Architect
• Data Analysis, Data governance and Data quality reporting
• Published, updated, and provide training on data standards, polices, and procedures.
• Extensive experience in RDBMS - ORACLE 11g/10g/9i, MS SQL SERVER, DB2 UDB and MySql
• Strong Experience in Data Model - Erwin and MS Visio
• Good understanding of MPPs -Teradata
• Good at scripting languages - Perl, Unix shell
• Good at programming languages/frame work - Core Java, JSP, Struts
• Strong Experience in Agile-Scrum Delivery model

PROFESSIONAL EXPERIENCE

Confidential - Columbus, OH

Project Lead Architect

Responsibilities:

• Define the project-level architecture including the design of the technical architecture consisting of application, infrastructure and data architecture
• Safeguards the design integrity of the system and ensures that application designs adhere to architectural and product standards defined by Architecture Review Board (ARB) and Technical Standards Board (TSB)
• Ensures the successful completion of TQA (Technical Quality Assurance) for the project
• Provides technical guidance and resolves questions for all aspects of the architecture, taking an end-to-end view
• Coordinates design of interfaces between subsystems and with external systems
• Often performed by Systems Architect responsible for the particular Solution Area impacted by Project deliverables
• Accountable for Data Conversion Plan, Data Conversion Strategy and Data Conversion Requirements
• Resolves architectural conflicts across project to ensure consistency and alignment with project and corporate standards

Confidential - Eden Prairie, MN

Solution Architect

Responsibilities:

• Provide architectural solutions and services for data intake, integration and enrichment covering meta data, data quality and data security
• Architect solutions for key business initiatives ensuring alignment with future state analytics architecture vision
• Work closely with the project teams as outlined in the SDLC engagement model to provide guidance in implementing solutions at various stages of projects
• Engage constructively with project teams to support project objectives through the application of sound architectural principles
• Develop and validate that the proposed solution architecture supports the stated & implied business requirements of the project
• Review technical team deliverable for compliance with architecture standards and guidelines
• Adopt innovative architectural approaches to leverage in-house data integration capabilities consistent with architectural goals of the enterprise
• Create architectural designs for different stakeholders that provide a conceptual definition of the information processing needs for the delivery project
• United Health Group, intended to create a platform which is implemented on top of Pivotal Hadoop Stack to support various data intake mechanism from multiple sources, provide data catalog, implement watermarking, security tagging and other post ingestion transformation. The platform also provides facility for on demand service to extract original data files from the transformed files.
• Solution architect participation in data intake, data ingestion, data organization and data prepare layers of the platform using Hadoop eco systems and Zaloni Bedrock.
• Prepare the data abstraction layer by formatting the files into Avro format and maintain the schema evaluation in metastore.
• Designing the HDFS directory structure for data organization
• Building Hive tables on top of Avro files for data analysis
• Adopting and Architecting Analytic solutions using Big Data technologies (i.e. PivotalHD and Bedrock Data Management Platform, MapReduce., Kite SDK, Avro Schema evolution, Hbase, Hive, PIG)

Confidential - Oakland, CA

Technical Architect

Responsibilities:

• Responsible for building scalable distributed data solutions using Hadoop
• Installed and configured Hive, Pig, Sqoop, Flume and Oozie on the Hadoop cluster
• Setup and benchmarked Hadoop/HBase clusters for internal use
• Developed Simple to complex Map/reduce Jobs using Hive and Pig
• Optimized Map/Reduce Jobs to use HDFS efficiently by using various compression mechanisms
• Handled importing of data from various data sources, performed transformations using Hive, MapReduce, loaded data into HDFS.
• Extracted the data from SQL Server & DB2 into HDFS using Sqoop
• Analyze and aggregate the data by performing Hive queries
• Loading Aggregated data into HBase tables
• Accessing HBase tables through Phoenix framework

Confidential

Technical Architect / Lead

Responsibilities:

• Responsible for identifying and controllingBIprojects scope, quality, and schedule. Worked on strategic initiatives
• Implementing Business Intelligence and Data Warehousing principles, ETL methodologies, Approaches, Technologies and architectures including the concepts, designs and usage of data warehouses and data marts
• On-site interaction with Product Management
• Responsible for Dimensional Data Modeling
• Developed ETL solutions using Informatica PowerCenter 9.x
• Involved and managed an ETL conversion project to convert existing ETL logic in Legacy stored procedures to Informatica PowerCenter
• Worked alongside BI team, DBA team and the application development team to identify and fix performance bottlenecks and data quality issues
• Created a pilot environment for the development team to test Informatica Data Quality tools
• Mentored team members with velocity methodologies on coding and naming standards
• Coordinated releases and liaison with Production Support team on issues logged during batch loads
• BI Schema Architecture - Large Scale Multi Enterprise, Multi-Tenant Environment
• BI Deployments - Setting up process
• BI Administration - Data security and User accessibility
• Adhere to Agile Development
• Agile - Scrum Master
• Deployment Strategies
• Produced technical artifacts including Data dictionary, Bus Matrix, Data Flows, ER diagrams, Data Interaction Diagrams, Mapping Documents etc.

Confidential, Mountain view, CA

Data Architect

Responsibilities:

• Developed project plan to support the business process reengineering effort, the development of the business architecture, and the supporting artifacts to the complete the logical layer of an data warehouse implementation
• Responsible for Dimension Modeling
• Responsible for Logical and Physical data model
• Architect and Design of home grown ETL framework
• Developed ETL using database programming PL/SQL
• Develop logical and physical design for variety of data formats to process very large amounts of data, including batch and real-time data.
• Worked closely with DBAs, Product development teams, infrastructure and project managers in agile environment to produce deliverables
• Responsible for “prototyping” for each model as POC to technical team
• Extensive involvement in performance tuning and Query Tuning (Explain Plan, Optimizer with Hints, Analyze, Indexing strategy, db2advice)
• Worked on Documenting Data Models, logic, coding, testing, changes and corrections.
• Maintenance of data warehouse, data fixes, fixing existing bugs
• Produced technical artifacts including Data Flows, ER diagrams, Data Interaction Diagrams etc.

Confidential - Bellevue, WA

Sr. Database Analyst/ Project Lead

Responsibilities:

• Responsible for Dimension Modeling
• Responsible for Logical Model and Physical implementation
• Architect and Design of home grown ETL framework
• Developed ETL using database programming PL/SQL
• Develop logical and physical design for variety of data formats to process very large amounts of data, including batch and real-time data.
• Worked closely with DBAs, Product development teams, infrastructure and project managers in agile environment to produce deliverables
• Extensive involvement in performance tuning and Query Tuning (Explain Plan, Optimizer with Hints, Analyze, Indexing strategy, db2advice)
• Worked on Documenting Data Models, logic, coding, testing, changes and corrections.
• Maintenance of data warehouse, data fixes, fixing existing bugs
• Produced technical artifacts including Data Flows, ER diagrams, Data Interaction Diagrams etc.
• Support all production oracle issues as needed and participate in emergency on call support activities

Confidential

Sr. Database Analyst/ Project Lead

Responsibilities:

• Involved in complete product life cycle.
• Responsible for system study, requirement analysis, converting high-level requirements of the core system into detailed requirements documentation for the technical phase of the project.
• During the different phases of project execution, I have solicited input and feedback from the clients to determine application needs.
• Designed & Pipelined the log data from different components to the database using log4j 1.2.9 as a pug-in.
• Designed the database schema using Erwin.
• Designed, developed and integrated back end using Oracle PL/SQL procedures/packages (development using Toad 8.2)
• Responsible for maintaining the testing, integrity, and availability of data throughout the project life span.

Confidential

Sr. Database Analyst

Responsibilities:

• Involved in complete project life cycle.
• Responsible for system study, requirement analysis, converting high-level requirements of the core system into detailed requirements documentation for the technical phase of the project.
• Designed the database schema using Erwin/ERX 3.5.2
• Designed, developed and integrated back end using Oracle PL/SQL procedures/packages (development using Toad 8.2)
• Designed and developed the front end using JSP, Struts 1.2
• Responsible for maintaining the testing, integrity, and availability of data throughout the project life span.

Confidential

Database Analyst

Responsibilities:

• Working with Oracle databases to manage data for development, training and production environments.
• Created database objects such as tables, views, synonyms, indexes, sequences and database links as well as custom packages tailored to business requirements.
• Developing and Tuning SQL, PL/SQL triggers and stored procedures.
• Developed SQL *Loader scripts, conversion scripts for the conversion of the data for schema design changes.