Manager Developer
Resume:
Chandra Ramireddy
*************@*****.***
SUMMARY:
. 15 plus years IT experience, as a Business Intelligence professional, I
was responsible for creative problem solving, technical proficiency,
understanding business processes, management, development, and product
delivery.
. In-depth understanding of maintaining successful employee relations,
ensuring timely delivery, navigating complex development environments,
testing, conducting and coordinating trainings.
. Expert RDBMS knowledge and programming experience, esp. in
Oracle7/8/9/10/11g, SQL, PL/SQL, Triggers, Stored Procedures, Functions
and Packages.
. Extensive experience in SQL and PL/SQL Packages, Procedures and
Functions, Collections, Ref cursors, pipelined functions, Reference
partitioning, Triggers, Auditing, Fine Grained Access Control, Query
Tuning using hints and load java.
. Knowledge in Oracle features like Automatic Storage Management, Real
Application Clusters (RAC), Data Pump Utility and Flash back
Technologies.
. Excellent technical and analytical skills with clear understanding of the
difference in design goals of ER Modelling for OLTP and Dimension
Modelling for OLAP.
. Expertise in Data Warehousing, ETL, Star and Snowflake Schema, Fact &
Dimension tables and hands on with PL/SQL, Informatica and Cognos tools.
Excellent knowledge in Data integration, loading and reporting
techniques.
. Excellent knowledge in Business Intelligence OLAP reporting tools such as
Cognos Report Net, Impromptu 6.0/ Power play, Transformer 6.6/ Power play
6.6 / IWR, Scheduler and Upfront.
. Experience in developing custom ETL code using PL/SQL, ETL
transformations using Informatica's mapplets, transformations and
workflows.
. Expertise in intra-day transactions (near real-time), point-in-time and
auditing.
. Experienced in developing database applications in agile SCRUM
methodology.
. Business knowledge and expertise in the areas of Telecom, HR, Materials
Management and Electric Utilities.
. Hardworking, self-motivated, self-learning abilities with admirable
interpersonal skills and efficient team player.
TECHNICAL SKILLS:
Operating Systems MS Windows NT/95/98/2000, HP/AIX UNIX, MS-DOS
Languages SQL, PL/SQL, C, Shell scripts, Visual Basic
5.0, Perl, Java
4GL Forms 4.5/5.0, Reports 2.5/3.0
ETL/DW Tools Informatica 4.7/6/8/9.5, Cognos IWR 6.0/ Power
Play6.6, Transformer, Maestro, AppWorx
Database Oracle 7/8/9/10/11g, SQL Server
Database tools Pl/sql Developer, Toad, SQL * plus, SQL
Navigator.
Replication Shareplex, Golden Gate 10/11.2
Web Technologies HTML, ASP, IIS, Netscape Directory Server, TIBCO
JMS
Case Tool ER Win
Others Eclipse, CVS, Quality Center, Remedy, JIRA
and Confluence
PROFESSIONAL EXPERIENCE:
Solutions Architect/Sr. Database Developer - ERCOT
Austin, TX
Mar' 12 - Present
. Currently working on ICE (Information Content Exchange) project with
extensive integration of TIBCO JMS, JAVA, and Oracle database
applications using Agile SCRUM methodology.
. Built triggering mechanism for approval based data extracts involving
golden gate replication and Data delivery module.
. Performance tuning of AMS (Advanced Metering Service ) interval data
extract.
. Functional enhancements and bug fixes in SMD (Systems Model Design)
application.
. Lead development of shadow settlements extracts to support the activities
of the Texas NODAL Energy Market.
. Established working relationships with business partners to facilitate
and promote effective interdepartmental relationships with Subject Matter
Experts (SMEs) to ensure all affected parties are included in issue and
implementation management.
. Provided technical consulting to developers of various database and
reporting applications and review their code.
. Developed Cognos Report Net reports on a replicated (near real-time)
Operational Data Store (ODS)
. Worked on Golden Gate replication tool to replicate data from OLTP source
systems to the Data warehouse.
. Worked on replication triggers in oracle to implement PIT's (point in
time) logic to store the data historically in ODS.
. Developed Monthly TDSP Load, Day Ahead and Real Time Market Activity
Graph Reports.
Environment: Informatica 9.5, Cognos Report Net 8.4, Framework Manager
8.4.1, Oracle 10/ 11g, PL/SQL, UNIX,
pl/sql Developer, App worxs, JIRA, CVS, Eclipse, Golden Gate 11.2.
Technical Lead/Sr. Database Developer - ERCOT
Austin, TX
Apr'07- Mar' 12
. Majorly involved in the development efforts for nodal systems like
LODSTAR, SEIBEL and CMM in ODS
. Majorly involved in defining the technical specs for ILM (Information
Life Cycle Management) architecture process.
. Played team lead and developer roles working on DDM extracts, Cognos
reports, Informatica ETLs (Non-spin and RMR Lift reporting) and
replication work.
. Involved in Zonal decommissioning of databases and products post Nodal go-
live.
. Siebel/EIF database and extract transition to ISM from Data Archive. This
was a switch from batch ( Informatica ) to near real time ( Shareplex )
architecture.
. Responsible for gathering complete requirements for Collateral
calculation application from the Finance team.
. Performed extensive sql tuning utilizing SQL Trace, TK Prof, Explain
plan, V$ views to optimize database and application performance.
Environment: Informatica 6/8/9.5, Cognos Report Net 8.4, Framework Manager
8.4.1, Oracle 10/ 11g, PL/SQL, UNIX,
pl/sql Developer, App worxs, JIRA, CVS, Shareplex, Golden Gate 10.
Sr. Database Analyst - ERCOT
Austin, TX
Apr'02- Mar' 07
. Provided the technical specifications to the ongoing development efforts
of real time architecture ISM and Data delivery module.
. Involved in the initial ODS architecture design discussions regarding
heartbeat, Point - in - Time(PITS), record flagging for ILM and data
movement between the partitions, naming conventions etc.,
. Worked on Data Archive for Siebel upgrade 7.7 project that involved high
volume data updates based on the source activity.
. Developed most of the EMS/MMS/OS Data Archive Informatica extracts and
Cognos Impromptu/ Power play reports post Texas Zonal Market Go-Live.
. Supported the legacy systems that were batch based - Informatica, Cognos,
Power play, Perl and Maestro tools.
. Created ETL mappings for slowly changing dimension tables using
Informatica.
. Modelled and designed a standardized set of data delivery applications.
. Cognos Transformer was extensively used to create Power play cube and
Cube groups to retrieve the data from Local Data Marts. Created,
maintained and published power cube, Impromptu and Power play web reports
to Upfront through PPES Administration. Automated the updating of cubes
through Scheduler.
. Involved in designing catalogs, user classes and some reports for
analyzing the business in many ways to "Slice and Dice" the data.
. Extensively used Power play Transformer to generate multi-dimensional
cubes, which were queried upon using Power play. Introduced User Class
security with power cubes and trouble shoot various reports, IWR and
PPES. Impromptu 6.0 was used to produce transaction level reports.
Environment: Informatica 4.7/ 6, Cognos Impromptu 6.0 and Power play 6.6,
Transformer, Oracle 8i/9,
PL/SQL, UNIX, pl/sql Developer, Maestro, CVS, Shareplex.
Admin/Sr Developer - IP Communications
Dallas, TX
May '00 - Dec 01
. Worked on PowerMart, Repository Manager, Designer (Source Analyzer,
Warehouse Designer, Transformation Developer and Mapping Designer) and
Server Manager. Source Analyzer tool was used to analyze various sources
from relational database, flat files and to create new source definitions
into the Repository.
. Involved in design and documentation of mappings and sessions to build
and run them in scheduler and monitor for the successful loading of data
into Data Mart.
. Involved in Data analysis of existing operational data source and target
tables to build Informatica maps and transformations used in final
Loading of data into Local Data Mart by scheduling through Informatica
Sessions.
. Maintained Production schedules and database updates via PL /SQL scripts.
Responsible for Business requirements analysis, Data Migration,
designing, developing and documentation of Informatica ETL
implementation.
. Installed various Cognos tools, ODBC drivers and set up data source and
organize data into dimensional maps and transformer model by establishing
joins between multiple queries.
. Informatica Designer was used to create target table definitions by
various methods.
. Mapping designer was used to connect source and target tables through
combination of different transformation objects e.g. Source Qualifier,
Expression, Filter, Aggregator, Update Strategy, Lookup, Joiner, and
Sequence Generator.
Environment: Power Center1.7/ Power Mart 4.6, Cognos Impromptu 6.0 and
Power play 6.6, Transformer, Oracle 8i,
SQL *Plus, PL/SQL, Windows NT/2000, UNIX, SQL Navigator, Toad, IIS,
Netscape Directory server.
SW Engineer/Database consultant - DIS, Inc.
Helena, MT
Nov. '98 - Jan'00
. Involved in building Decision Support System as per the functional
requirement, defining strategy for Star schema with Fact and Dimension
tables with Detail, Summary, Look-up tables, Indexes and Views.
. Data warehouse techniques were extensively implemented in Extraction,
Transformation and Loading of data from multiple source databases into
EDW. Database triggers, Sequences, Indexes and fact tables were widely
used in providing data integration and security.
. Successfully built SQL and PL/SQL scripts to maintain Order information
consistently in DW system with great accuracy. Procedures and Functions
were extensively used to improve the functionality of the program.
. Successfully carried out the migration of an unemployment
Insurance/Benefits application (from Forms4.5 and Reports 2.5 to Forms
5.0 and Reports 3.0) and enhanced the application functionality by
implementing all typical properties and functions using Client/Server
methodologies.
. Interacted with the users extensively in understanding the business rules
to provide consistency in the application by using Stored Procedures,
functions and Packages.
. Also both database and front-end triggers were extensively used wherever
needed. Used SQL*LOADER for porting of data from flat files to Oracle
database.
. Successfully used Oracle Standard Packages while developing some of the
complex reports like Master/Detail, Drilldown, Matrix types etc.,
Involved in SQL Tuning and Report Tuning.
Environment: Power Center1.7/ Power Mart 4.6, Oracle 7.3/8/8i, SQL Plus,
PL/SQL, Windows NT/98, UNIX, SQL Loader, SQL Navigator, Toad, Forms
5.0, Reports 3.0
Programmer/Analyst-Regency InfoTech.
India
Mar.'97-Jul.'98
. Involved in analysis, design and development of database application and
transactional screens for warehousing system. The final deliverables
being in Visual Basic 5.0, the system generates reports (daily sales,
sales invoice, reorder level, non-moving items reports etc using
Crystal Reports .
. Involved in unit testing and integration testing of the transactions
developed. To improve the performance of the system Oracle database
triggers and stored procedures were written at the database level
providing data security.
. In addition to the usage of Windows API functions, ActiveX COM and OOP
methodologies were successfully implemented.
. Designed and developed a business application for Order Entry processing
using Oracle, Visual Basic 5.0 and Crystal Reports. The system keeps
track of information related to vendors, products, orders and customers.
. Performed analysis, design Interface layouts & programming, unit &
system testing, and system documentation etc
. Wrote database- triggers and stored procedures to maintain security and
to support database checks and validations.
. Developed Login screens for different applications thus enforcing system
security to allow only the privileged user access. Created object models
and developed OCX's and DLL's according to customer needs using
ActiveX COM and MTS technology.
Environment: Visual Basic 5.0, Crystal Reports, Oracle 7.x, SQL*
Plus, UNIX, WIN95/NT, MS-Access
Programmer/Analyst - Anicad Systems
India
Sep. '95 - Feb. '97
. Involved in the design, development and implementation of a Material
Management System. This system is used to automate the process of
material transactions and inventory for a manufacturing concern.
Alerts, Stored procedures and triggers were extensively used to
analyze financial situation and to enforce business functionality.
Oracle reports 2.5 were used to generate daily inventory report,
MTD/YTD reports, Sales Invoice report, Order status report etc. by
customer.
. Designed and developed a Data Management Systems using Oracle 7.1 and
Oracle Forms 4.5. Created database related tables and indexes.
Designed and developed Login Screens for different applications to
enforce the security for the system. Only the users having proper
privileges were allowed to access the system.
Environment: Oracle 7.1, Oracle Forms 4.5, SQL *Plus, PL/SQL
and Windows NT
EDUCATION: B.S in Engineering, University of Mysore, India
Technical Trainings:
. Cognos Developer /Admin (IBM Cognos),
. IBM Cognos Framework Manager (IBM Cognos),
. Informatica Developer (Informatica Corporation)
. SQL performance tuning and (Hotsos )
. Dimension Modelling (Kimball University)
. Java (Oracle Corporation)
. Golden Gate (Oracle Corporation)
REFERENCES : Available upon request.
Contact this candidate