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 India1993
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
Informatica Training
Siebel Analytics/Obiee
Siebel CRM Training
SAPBW 305 Training
Cognos Training
Data Modeling /Data Architect
Snowflake,Cloud Technologies
Similar Profiles
Puja GowalaPuja Gowala
Receptionist at Hotel Gopala ResidencyReceptionist at Hotel Gopala Residency
Praveen KukrejaPraveen Kukreja
JMarathon Advisory Services ltd. Financial Analyst at Gopala KrishnanJMarathon Advisory Services ltd. Financial Analyst at Gopala Krishnan
Prabal MukherjeePrabal Mukherjee
Research Assistant at SelfResearch Assistant at Self