Gopal K. Email & Phone Number

San Diego, Ca, Us

Englewood Cliffs, New Jersey, Us

Englewood Cliffs, New Jersey, Us

San Diego, Ca, Us

Integral part of transition from On-Prem to Cloud Centric model. Helped establish Snowflake as an Enterprise Cloud Database. Introduced new technologies like Fivetran, Looker, and DBT to transition away from legacy application to more Cloud focused architecture.

San Diego, Ca, Us

Achievements:- Zero defect Go-Live on BI side for EBS R11 to R12 upgrade.- Nominated for and was one 4 finalists for “Employee of the Quarter” in less than a year of my joining.Responsibilities:- Owned the Informatica Stack and define the ETL standards and development processes- Informatica Administration too.- Maintained ownership of the legacy ETL system- Performed data Integration from multiple sources to provide meaningful analysis for the Pricing/Marketing team.- First level of contact for all urgent issues related to Informatica/ETL processes- Data Modeling (both Dimensional and Relational) for the projects being undertaken using ERWIN- Infrastructure specification planning for the ETL systems.- Handling multiple projects concurrently. Project prioritization based on needs and constraints for resource/effort allocation etc.- Liaising with business users to define the scope, timelines and expectations for projects requests- Writing design documents, system requirement documents- Developing the development plan with detailed steps.- Estimating/planning and tracking the development/testing effort- Hands on involvement in development/maintenance of code in Informatica - Mentoring of team members for Informatica and ETL best practices- DDL/DML/Stored Procedures/Functions in Oracle - Performance tuning, troubleshooting issues faced by the Development team in Informatica/Database.- Performing code reviews / Standards enforcement- Managing onsite/offshore Development teams- Setup of new environments and POCs (Informatica Metadata Manager etc).- Responsible for quality and meeting project objectives.- Developed templates to be used for future development for capturing Audit/Incremental load information- Expertise in performing data analysis, research and profiling. This was helpful while defining/clarifying business rules during implementation.- Hands on development of reports/dashboards using Cognos and Tableau and occasional cubes

Pasadena, California, Us

During the last ~7 yrs of tenure with Trinus Corp, I had the pleasure of working with multiple clients. During this time, my role grew from working as a Sr Software Analyst to more of a Solution Architect with involvement in Pre-Sales engagements and writing client proposals.My role was to understand the client's business and systems and then help them set up a roadmap for meeting their goals. This may have included design/development or enhancement of data warehouse and information system architecture. The whole solution approach involved both ETL and reporting portions to quite an extent, thus giving me valuable experience in looking at the end to end picture.In all, the various roles and responsibilities I have shouldered are listed below, but is not an exhaustive list..- Understanding the client business process and data source systems.- Understanding overall business objectives and Project/Business Requirements.- Developing a solution roadmap or architecting a solution framework for implementation.- Involved in Project Initiation and development of project charter, where applicable.- Liaising with business users to better define the scope and the business asks.- Providing the knowledge input for design of Business Model.- Convert business requirements into technical requirements.- Designing the logical/physical data model .- Defining the data flow aspect.- Estimating/planning and tracking the development effort- Responsible for quality and meeting project objectives.

Los Gatos, Ca, Us

Clients:Mitchell, San Diego.Sento, UtahSenior Developer (BI) Responsibilities:- Low-level design and development of the ETL process.- Data Modeling - Production Rollout of the data warehouse - Historical Data loading- Ongoing production support.- Writing stored procedures using embedded cursors, Session Contexts and XML Queries.- Created Universes to handle detailed and aggregated data by using Embedded Functions like @Prompt, @Aggregate Aware, @Select, @Where in the Designer.- Supporting and managing the Business Objective Related Issues in the organization, which includes answerable for all the Business Object queries and supporting business community and technical users.- Involved in all the review phases to make sure that all Business Object Reports and Universe follow development standards.- Analysis of the existing business processes and Data Warehouse. - Created reports with drill down features using Desktop Intelligence.- Created reports with nested dependent prompts in the report using Desktop Intelligence.- Involved in knowledge transfer/training to client personnel for generation and usage of ad-hoc reports.- Acting as prime knowledge contact between offshore and onsite team.- Development, Support, Modification and Enhancement of existing Universes by working with development team and user community.- Performance Tuning of the generated reports, which included overwriting standard query with a custom one.Configuration Controller Responsibilities:- Handing Source Control and versioning of the code.- Handling the quality aspect, overseeing the testing of the code and defect ratio report generation.- Phased code rollout/Build generation for testing/client inspection.Environment: Data Integrator 6.5, Business Objects XI R2, Microsoft VSS, Oracle 10g, MySQL, Sybase.

Noida, Uttar Pradesh, In

Client: LastMinute.com, London, UK Senior Developer (BI) Responsibilities: - Development of new reports based on business requirements.- Automation of report generation through Broadcast agent.- Making sure of report circulation by configuring BCA to save report to shared file system in pdf form and writing scripts to update Intranet web page with regards to new file.- Defining custom hierarchy in the Universe so that automatic drill down features may be incorporated in the reports.- Created drill down reports for business users.- Supported all ad-hoc queries and report requests.- Provided troubleshooting and problem resolution to technical people for BO problem.- Acted as SME (Subject Matter Expert) for the development team.- Conversion of legacy reports from Excel to Business Object reports.- Conversion of legacy data loading system from PERL to Informatica.- Support for existing system, both ETL and Reports.Offshore Responsibilities:- Liaison with the clients for day-to-day requirement gathering- Clarification of queries posed by the team members.- Work assignment and allocation to the team members.Environment: Business Objects 6.1, Web Intelligence, Informatica 6.0, Broadcast Agent Server, IIS 5.0, Oracle 8i, Informix, POSTGRES.

Boston, Ma, Us

Client: OPODO, London, UKWorked in EDW/M (Enterprise Data Warehouse/Management)Senior Software Developer Responsibilities- Analysis of the existing business processes and Data Warehouse. - Daily support for data loading on informatica.- Involved in analyzing the source data and automating load processes, - Involved in creating reports for bad data and rollover of data load in case of failures.- Daily/Weekly support for BO reports.- Involved in creating ad-hoc reports and queries as and when needed by business users. - Designed fleet of Informatica mappings using filters, lookups, and stored procedure, Joiner, update strategy, expressions and aggregations transformations- Involved in performance tuning of existing mappings for better performance. - Wrote PL/SQL Oracle Database triggers and Procedures/Functions/Packages.- Extensively used ETL to load from operational system (Oracle database) and flat files into the Oracle target database.- Handled the new features of Informatica 6.1 including Workflow Manager to handle work lets.- Universe creation based on the Data mart developed for the Enterprise to embed the entire user requirement.- Handled Embedded Functions like @Prompt, @Aggregate Aware, @Select, @Where in the Designer to handle User requests and aggregation tables for report generators- Supporting and managing all the Business Objective Related Issues in the organization, which includes answerable for all the Business Object queries and supporting business community and technical users scattered across various locations worldwide.- Involved in all the review phases to make sure that all Business Object Reports and Universe follow development standards.- Development, Support, Modification and Enhancement of existing Universes by working with development team and user community.- Performance Tuning of the generated reports. Environment: Informatica, Business Objects, Oracle

The Rarrigini & Rosso group developed 24-7 broking system, which was a totally integrated system that linked brokers, their clients, insurers and other suppliers in real time via a secure private network, using terminal services. However, the application was mainly focused for brokers in the Insurance Sector.Software Developer Responsibilities: - Involved in development and enhancement of Complex Risk module..- Involved in designing and implementation of capturing of insurer quotations and the policy creation.- Involved in functionality of code implementation for Mid Term Adjustments, Cancellation, Renewal and Reinstatements of the complex risk policies.- Involved in reports and document management, for which Active Reports was used.- Translating of business requirements into implemental design.- Designing and coding of the ASP pages as well as COM+ components, as per the requirements of the business flow.- Database table designing and writing stored procedures to access the data from the ASP Pages (server side – using VBScript, ADO/COM+ objects).Environment: ASP, VB/VC++, COM+, XML, XMLHTTP, DHTML, VBScript, JavaScript, SQL Server 7.0 and Active Reports.

In the period of my employment with River Run Software Group, worked on many projects, initially as a programmer. The projects worked on covered various technologies, both in manners of development and base technologies, including Embedded VC++, VB, ASP, Java, HTML, DHTML, Oracle and SQL Server 7.0. All projects needed prototype development with VC++, VB, Java and COM components etc. The project period varied from a period of 2 months to 9 months. The client base, essentially were companies with field personnel and surveyors, which included namely American Express, Texas State Board of Barbers Association and The State of California Transport Department.

Masters In Computer Application, Mca

B.Sc., Electronics (H)

High School