Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Gopala Chandra

Edison,NJ

Summary

Over 19+ Years of IT Development experience in the areas of Health Care,Finance ,Retail ,Pharmaceutical and Telecom

Over 19 Years of Oracle SQL, PL/SQL and Microsoft SQL Server experience.

Experience in all aspects of Project development life cycle like Requirements,Analysis,Design,Implementation,Testing and Maintenance.

Experience with Data modeling and Dimension modeling.

Strong Working knowledge of Data warehousing concepts.

Highly organized individual and detail-oriented.

Ability to handle multiple projects simultaneously with a high degree of accuracy.

Overview

29
29
years of professional experience
1
1
Certification

Work History

Senior Consultant/Senior Data Analyst/Data Science Specialist

Gopala R
  • With strong Data warehouse/Data Architecture/Data Modeling /CRM/Snowflake and Informatica skills
  • 19 + years of experience in IT industry
  • Extensive experience in Data related projects
  • Data Warehouse, Data Mart and Business Intelligence using OLAP tools
  • Data migration projects using SQL scripts or ETL/Informatica
  • Experienced Relational and dimensional data modeling for creating logical and physical design of database and ER diagrams using data modeling tools like ERWIN
  • Experience in Data Quality Analysis, Data Profiling, Data cleansing and Master data management
  • Effective experience in Complete Software development Life cycle (Iterative, Waterfall methodology, Agile, RUP)
  • Analyzed large amounts of data to identify trends and find patterns, signals and hidden stories within data
  • Performed root-cause analysis on data-related system problems to recommend or execute corrective action
  • Developed and maintained data warehouses and data marts to support business operations
  • Provided technical support for troubleshooting analytics and reporting issues
  • Implemented business intelligence solutions to increase operational efficiency

Senior Data Warehouse Developer / Sr Data Analyst/Data Engineer

NYC Health + Hospitals
10.2014 - Current
  • Worked on several Data related projects
  • Design and develop Data Warehouse Models
  • Design and develop package to load data for fact and dimension tables in Star Schema
  • Create stored procedures, functions and packages to load data from various data source systems
  • Develop ETL procedure for synchronizing data source from EDW System to Stage and Mart
  • Create test cases scenarios to validate data across data warehouse systems
  • Supported Production projects and Development projects
  • Objects and SQL code developed using Oracle and Oracle APEX
  • Partitioned fact tables to enhance performance
  • Experienced frontend programming using java script, CSS and HTML
  • Tune queries, create indexes, views, scheduler job, purge scripts for database performance review and approve queries and store procedures for production release
  • Reports prepared based on requirements
  • Cloud Computing and AWS experience
  • Experienced Snowflake implementation
  • Completed quality reviews for designs, codes, test plans and documentation methods
  • Mapped data between source systems and warehouses
  • Developed and modified programs to meet customer requirements

Senior Data Analyst/Data Engineer/ETL Specialist

New York City Housing Authority
10.2011 - 09.2014
  • Experienced in relational and dimensional data modeling for creating logical and physical design of database and ER diagrams using data modeling tools like ERWIN
  • Design and develop Data Warehouse Models
  • Design and develop package to load data for fact and dimension tables in Star Schema
  • SQL scripts development in Oracle and Oracle APEX
  • Conducted design reviews and validated developed models by interacting with database administrators, business analysts
  • Prepared SQL Procedures, Functions and Packages to migrate data
  • Partitioned fact tables to enhance performance
  • Created complex Informatica mappings using Unconnected Lookup, joiner, Rank, Source Qualifier, Sorter, Aggregator, newly changed dynamic Lookup and Router transformations to extract, transform and loaded data mart area
  • Designed Fact and Dimension Tables
  • Reports generated based on requirements
  • Loaded data from Source tables into Staging and Staging Tables into DW tables.
  • Identified, reviewed and evaluated data management metrics to recommend ways to strengthen data across enterprise

Senior Consultant /Senior Data Analyst

Bank of America Merrill Lynch
08.2009 - 10.2011
  • Participated in Requirement Gathering, Business Analysis, User meetings, discussing issues to be resolved and translating user inputs into ETL design documents
  • Logical and Physical data modelling was done using Erwin for data warehouse database in STAR SCHEMA
  • Using Informatica PowerCenter created mappings and mapplets to transform data according to business rules
  • Created Workflows for all entities
  • Reverse engineered reports and identified data elements, dimensions, facts and measures required for new enhancements of reports
  • Developed Stored Procedures to migrate data
  • Tuned Informatica mappings for optimal load performance
  • Maintained /Supported current Wealth management daily batch jobs (Informatica, Siebel, Siebel Analytics, Data mart and Salesforce.com) Design, documented and developed data process for new requirements for following entities: Bank, Brokerage, Customer, ML Rewards and Profiles
  • Experienced with Oracle/SQL Server, SQL query optimization and Stored procedures
  • SQL Code developed using Oracle and Oracle APEX
  • Architected, Designed, Developed, and Implemented Batch data-load process for new entities.

Senior Data Analyst/Senior Consultant

Famers Insurance
02.2009 - 07.2009
  • Design, development and documented the Siebel batch data process
  • Informatica mappings, workflows are created and loaded data from source systems to Stage and Stage to Siebel Interface tables
  • Data loaded from Siebel Interface to Siebel Base tables using Siebel EIM
  • Validated and analyzed loaded data
  • Environment: Siebel Financial v8, ETL (Informatica 8.6), Oracle 10 G, ERWIN

Team Lead / On-shore coordinator

Capgemini U.S. LLC
02.2005 - 02.2009
  • Architected, Designed, Developed, and Implemented Batch data load process
  • Interpreted logical and physical data models for business users to determine common data definitions and establish referential integrity of the system using Erwin
  • Followed Star Schema to design dimension and fact tables
  • Experienced in handling slowly changing dimensions
  • Conducted the design reviews and validated the developed models by interacting with database administrators, business analysts
  • Reverse engineered the reports and identified the data elements, dimensions, facts, and measures required for new enhancements of the reports
  • Extensive experience with PL/SQL in designing, developing functions, procedures, triggers, and packages
  • Developed mappings in Informatica to load the data including facts and dimensions from various sources into the Data Warehouse
  • Review existing code, lead efforts to tweak and tune the performance of existing Informatica processes
  • Experienced with Oracle/SQL Server/DB2,Sql query optimization and Stored procedures
  • Experienced in Data Quality and Profiling

Seniorr Consultant

Seecon Systems Inc
11.2000 - 02.2005
  • Design, development , documented the Siebel data process and involved in Data Modeling
  • Abinito/Informatica used to load data from source systems to Siebel Interface Tables
  • Data loaded from Siebel Interface to Siebel Base tables using Siebel EIM
  • Experience with Oracle/SQL Server/DB2,Sql query optimization and Stored procedures
  • Involved in the ETL technical design discussions and prepared ETL high level technical design document
  • Wrote complex PLSQL scripts /functions/procedures/packages
  • Involved in the performance tuning of SQL/PLSQL scripts based on explain plan
  • Validated and analyzed loaded data
  • Prepared test scenarios for all entities to validate loaded data
  • Jobs are scheduled using Autosys

Sr Siebel Consultant

Ramsoft Systems, Inc
04.1998 - 11.2000
  • Design, development and documented the Siebel data process
  • Data loaded from Siebel Interface to Siebel Base tables using Siebel EIM
  • Experience with Oracle/SQL Server/DB2,Sql query optimization and Stored procedures
  • Wrote complex PLSQL scripts /functions/procedures/packages
  • Experienced with Siebel configurationand scripting
  • Validated and analyzed loaded data.Prepared test scenarios for all entities to validate loaded data
  • Prepared test scenarios for Configuration validations

Programmer Analyst

SRP
04.1998 - 02.1999
  • Implementing all table changes, performing database source code builds, and administering static data migration
  • Code modifications in COBOL for on-line and batch
  • MVS, JCL, VSAM

Programmer Analyst

CT&T
09.1994 - 03.1998
  • Developed SQL Program based on requirements
  • Role: Analysis, Design and Development.

Education

Bachelor of Engineering - Electronics & Communication

Karnatak University
Dharwad India
1993

Skills

  • Oracle 6x/7x/8x/9x/10x/11x/12x/19x
  • SQL Server (60,70 , 8,9,10,11,12,13,14,16)
  • DB2
  • Teradata
  • Languages/Utilities: SQL, PL/SQL,T-SQL , Python ,R ,C , Cobol ,Java
  • ETL Tools: Informatica 5x, 7x/8x/86/9x/10X
  • Reporting Tools: Power BI, Tableau and Cognos
  • Operating Systems: Windows, UNIX
  • Data Modeling: Erwin, Visio, Power BI
  • Cloud Technologies: AWS, Microsoft Azure, GCP
  • Other: Oracle APEX, Informatica Data Quality
  • Scheduling Tools: Autosys
  • Software Used:
  • Oracle 60 with Forms 30
  • Business Intelligence Testing
  • Data Mining
  • Data Mapping
  • Data Profiling
  • Technical Design Documentation
  • Data Quality

Certification

Informatica Training Siebel Analytics/Obiee Siebel CRM Training SAPBW 305 Training Cognos Training Data Modeling /Data Architect Snowflake,Cloud Technologies

Timeline

Senior Data Warehouse Developer / Sr Data Analyst/Data Engineer

NYC Health + Hospitals
10.2014 - Current

Senior Data Analyst/Data Engineer/ETL Specialist

New York City Housing Authority
10.2011 - 09.2014

Senior Consultant /Senior Data Analyst

Bank of America Merrill Lynch
08.2009 - 10.2011

Senior Data Analyst/Senior Consultant

Famers Insurance
02.2009 - 07.2009

Team Lead / On-shore coordinator

Capgemini U.S. LLC
02.2005 - 02.2009

Seniorr Consultant

Seecon Systems Inc
11.2000 - 02.2005

Sr Siebel Consultant

Ramsoft Systems, Inc
04.1998 - 11.2000

Programmer Analyst

SRP
04.1998 - 02.1999

Programmer Analyst

CT&T
09.1994 - 03.1998

Senior Consultant/Senior Data Analyst/Data Science Specialist

Gopala R

Bachelor of Engineering - Electronics & Communication

Karnatak University

Similar Profiles

CREATE PROFILE
Gopala Chandra