Manager Sql Server
Resume:
Gopal Chalasani
****.****@*****.***
PROFILE
. 7+ Years of Total IT Experience
. 3+ Years of OBIEE
. 3+ Years of DW-Informatica
. 6+ Years of Oracle
. 5 Years of SQL Server
PROFESSIONAL SUMMARY
> Over 3 years of excellent experience in the design and development
of business applications as an OBIEE Developer.
> Expert in configuring Interactive Dashboards with drill-down
capabilities and drill-across capabilities using Dashboard Prompts,
Contextual Navigation, Guided Analytics, Business Rules with User
Identity and Roles, Profiles & Personalization.
> Highly experienced in creating metadata repositories (.rpd) using
Administration tool.
> Strong in creating proactive agents (iBots) in Delivers to send
alerts to the recipients on occurrence of a business event or at
the specified time.
> Expert in implementing the Oracle BI Security Setup (groups, data
access/query privileges).
> Extensive Experience in Developing and Designing the layout of
reports as per the business requirements.
> Excellent Experience in writing the Functional Specification
documents and assisting the Technical team in finalizing the
Technical Design Document.
> Strong Experience in developing and modifying reports in Oracle BI
Publisher.
> Extensive experience in designing Star/Snow flake schemas, Business
Model Development with Dimensions, Hierarchies, Measures,
Aggregation Rules, Time Series, Caching & Mapping.
> Expert in data warehousing concepts like OLAP, Dimensional
modeling, Data modeling using Normalization, Ralph Kimball and Bill
Inmon methodologies, Dimensional Data Modeling, FACT & Dimensions
tables, Physical & Logical Data Modeling, Aggregate persistence
wizard.
> Very good in Debugging, Optimizing and Performance Tuning of Oracle
BI / Siebel, Analytical Dashboards / Reports.
> Excellent Hands on experience in installing, configuring OBIEE.
> Extensive experience with various databases Oracle 8i/9i/10g/11i,
SQL Server 2000/2005.
> Experience in developing Stored Procedures/Packages, Database
Triggers, Cursors using SQL, PL/SQL.
> Profound Knowledge of SDLC and Software Testing Life Cycle.
> Excellent team member with problem solving and trouble shooting
skills.
> Results oriented, self starter looking for challenges, ability to
rapidly learn and apply new technologies and good interpersonal
skills.
SKILLS SUMMARY
. BI Tools: Oracle Business Intelligence OBIEE 10.1.3.3 (Admin,
Presentation Services), Siebel Analytics 7.x (Admin, Web, Answers,
Dashboards), Scheduler, DAC, Informatica Power Center
8.6/7.x/6.2(Repository Manager, Designer, Server manager, Workflow
Monitor, Workflow Manager, Power Mart 5.x, Star & Snowflake Schema.
. Databases: Oracle 10g/9i, DB2 v8.0, MS SQL Server 2000/7.0.
. Data Modeling: Physical Modeling, Logical Modeling, Relational
Modeling, Dimensional Modeling (Star Schema, Snow-Flake, FACT,
Dimensions), Entities, Attributes, ER Diagrams, ERwin, OLAP, Star
Schema.
. Testing Tools: Win Runner 7.6, QTP, and Test Director 8.0.
. Miscellaneous Tools: SQL Developer, TOAD, AQT, SQL*Plus, SQL*Loader.
. Operating Systems: Windows XP/2000/98/NT, UNIX.
EDUCATION
Bachelor of Engineering: Sri Ram Engineering College
(Chennai), India.
PROFESSIONAL EXPERIENCE
Standard and Poor's, NY
(Jul'09 - Till
Date)
OBIEE Developer
Responsibilities:
. Interacted with Management and subject matter experts to identify
key Dimensions and Metrics of Scorecard for business performance.
. Interacted with Systems Engineering team to design - Facts and
Dimensions for Financial, Operations, Customer, and Service
Repository.
. Developed proof of concept to check the functional feasibility of
the Performance project.
. Prepared Detail Design Document for Finance, Operations, Customers,
Claims, policies and Services Repository.
. Developed Metadata repository by configuring physical layer,
business model and mapping layer and presentation layer using OBIEE
Admin Tool.
. Created different Premium level based measures using dimensional
hierarchies.
. Improved query performance by Aggregating Premiums paid, Premium
Revenue amount, and Claims incurred tables.
. Identified claim, policy, Premium granularity level of the data
required to be available for analysis.
. Developed Time Series Objects for comparing the policy variations
between the current and previous years and months.
. Developed Condensed Summary of Operations reports using different
Analytics Views (Pivot Table, Chart, View Selector, Title, Legend,
Filter and Table view).
. Extensively used page prompts and dashboard prompts.
. Created reports using drill-down and drill-across Policy, Premium,
and claim.
. Configured Assets, liabilities, capital and surplus Union reports
for implementing complex report requirements.
. Customized Performance Reports look and feel using Column
formatting and conditional formatting.
. Provided end-to-end business intelligence solution by dimensional
modeling design, building business models, configuring OTB
metadata, Answers, Delivers / iBots, creating Interactive
Dashboards with drill-down and drill-across capabilities, Security
(groups, access / query privileges), Web Catalog Objects
(Dashboard, Pages, Folders, Reports), cache monitor, and building
Repository consisting of three layers (Physical Layer, Business
Model & Presentation Layer) using Oracle BI .
. Used SQL queries and database programming using PL/SQL (writing
Packages, Stored Procedures/Functions, and Database Triggers).
. Performed Unit testing, integration testing to verify the report
functionality and debugged dashboard reports to verify data matches
as expected.
Environment:
OBIEE 10.1.3.3, Informatica Power Center 8.6.1, DAC, Oracle BI
Applications 7.9.3, Oracle 10g, Toad, ERwin, UNIX.
Pfizer, NY
(Apr'08 - Jun'09)
OBIEE / DAC Consultant
Responsibilities:
. Participated in Requirements gathering of the various work streams
by meeting with the business user and base lining the details.
. Assist in performance of Gap Analysis related to Data Models and
data extracted in ETL, and map client requirements into OBIEE/
Siebel Analytics functionality.
. Worked with Revenue Fact and Geography Dimensions using Oracle BI
EE 10.1.3.2 for generating reports for managers, executives and
individuals.
. Worked with the physical layer to create Connection pools and imported
physical tables and defined joins.
. Worked on Oracle BI EE Administration tool for customizing the
Physical layer, Business layer, Presentation layer and modifying it
according to the business requirements.
. Design, build and test reports, Dashboards, BI Publisher and Microsoft
Integration and other functionality within the OBIEE suite.
. Worked and developed Repository (.rpd), configured metadata objects
(Subject Area, Table, Column) and Web Catalog Objects (Dashboard,
Pages, Folders, Reports).
. Created Dimensional Hierarchies for the Drill Down functionality
and implemented Business Logics for Facts.
. Created customized reports using Answers from the existing Subjects
Areas & incorporated Global Prompts, Cascading Prompts & Filters.
. Enhance performance of Reports / Dashboards by implementing the
Aggregate tables, Table execution path by making use of hints,
Creation / Re-building of Indices and Cache Management.
. Tested & validated repository using Siebel Analytics ODBC Client Tool.
. Created Reports using different Analytics Views (Pivot Table, Chart,
Column Selector and Table) using filters.
. Created different types of Customized Reports (Drilldown, Aggregation)
to meet client requirements.
. Worked on Oracle BIEE Delivers and Configured iBots to deliver
Analytics content based on schedule.
. Also worked with Security of the Oracle BI Administration Tool to
define Users and Groups, set permissions, Group Inheritance,
Authentication Methods, Query Limits, Timing Restrictions, and
Filters.
. Implemented security by creating roles & web groups, checks with
External tables and LDAP.
. Performed migration of Siebel Analytics RPD and Webcat to OBIEE.
. Performed Unit, Integration, and User Acceptance testing of various
Dashboards / Reports and Repository.
Environment:
OBIEE 10.1.3.2, Siebel Analytics 7.8.5, DAC 7.8, Oracle10g, Informatica
PowerCenter7.1.3, TOAD, Putty, Linux, Windows.
Guardian Life Ins. Co. of America, New York, NY
(Jul '07- Feb '08)
OBIEE Developer
Responsibilities:
. Used the Siebel Analytics Administration tool to develop and
enhance meta-data.
. Worked extensively with Physical Layer, Business Layer and
Presentation Layer.
. Created numerous executive level reports. 'Dashboards' were
generated to provide insight into the financial reporting for
insurance industry.
. Created different types of Customized Reports (Drilldown,
Aggregation) to meet client requirements.
. Build geographical report drill down from state maps to county maps
to zip code maps.
. Involved with requirement gathering and interacting with Business
Analyst and Business users.
. Used Answers to create queries, format views, charts, and added
user interactivity and dynamic content to enhance the user
experience.
. Installed and Configured the OBIEE 10.1.3.3 on Windows.
. Extensive experience working with views including charts, pivot
tables, and narratives. And also, created selectors to drive
interactivity in Business Intelligence requests.
. Worked extensively with dashboard prompts to filter dashboards and
populate variables.
. Implicated in the specification and design documentation.
. Troubleshooted the tickets in the OBIEE Software.
. Design the Data Mart model using Dimensional Modeling methodology
in conjunction with data architects and ETL team.
. Designed and implemented Physical and Logical Star Schemas/Diagrams
using Fact, Dimension, Alias and Extension tables as well as
Foreign and Complex joins.
. Configured and enhanced Repository using Siebel Analytics
Administration Tool
. Organized dimension attributes into hierarchical levels that
represent the organizational rules and reporting needs required by
the business.
. Created dimensional hierarchies, assigned levels and custom
aggregation rules for each level, and configured cross-dimensional
drill downs to get more detailed views of the data.
. Used Security setting in Siebel Administration tool to set up
external database authentication for users.
. Configured Row Level Security and Object level security to allow
users to view their respective data only according to the
requirement.
. Implemented cache purging and seeding script and corresponding
iBots.
. Upgraded from Siebel Analytics 7.8.4 to OBIEE 10.1.3.3.
Environment:
Siebel Analytics/OBIEE, Oracle Application Server Release 3
(10.1.3), OBIEE 10.1.3.3, Oracle 9i/10g, SQL, PL/SQL, Windows 2003
Sever.
Daiichi Sankyo Inc., Parsippany, NJ
(Aug' 05 - Jan' 07)
ETL/Informatica Developer
Responsibilities:
. Worked on Informatica Power Center tools-Source analyzer, Warehouse
Designer, Mapping Designer and Transformation developer.
. Extracted, transformed data from various sources such as Oracle,
Flat files, MS SQL Server, COBOL, and loaded into the target data
warehouse Oracle.
. Used update strategy and Lookup transformation to insert, delete,
update or reject the records based on business requirements.
. Developed several complex Mappings, Mapplets and Reusable
Transformations to facilitate one time, Weekly, Monthly and Yearly
Loading of Data.
. Utilized the Aggregate, Join, Router, Look up and Update
transformations to model various standardized business processes.
. Created Stored Procedure, Functions and Triggers as per the
business requirements.
. Developed Shell Scripts and SQL Queries.
. Used SQL * Loader for bulk loading.
. Worked with Scheduler to run the Informatica session on daily basis
and to send an email after the completion of loading.
Environment:
Informatica Power Center 6.x, Oracle, Flat file, SQL Server 2000, SQL*
Loader, PL/SQL, UNIX, Windows 2000.
Baxter Healthcare, Chicago, IL
(Aug' 04 - Jun' 05)
Informatica Consultant
Responsibilities:
. Designed data models to support user's business requirements.
. Designed and developed complex aggregate, join, look up
transformation rules (business rules) to generate consolidated
(fact/summary) data identified by dimensions using Informatica ETL
Power Center 5.1/6.0 tool.
. Used the Slowly Changing Dimensions wizard (type 2) to update the
data in the target dimension tables.
. Created sessions, database connections and batches using
Informatica Server Manager/Work flow Manager.
. Optimized mappings, sessions/tasks, source, and target databases as
part of the performance tuning.
. Configured the server and email variables using Informatica Server
Manager/Work flow Manager.
. Used command line program pmcmd to communicate with the server to
start and stop sessions and batches, to stop the Informatica server
and recover the sessions.
. Used all types of caches like dynamic, static and persistent caches
while creating sessions/tasks.
. Used Metadata Reporter to run reports against the repository.
. Created and populated the intermediate aggregate tables to make the
reporting efficient and fast.
. Designed the physical structures necessary to support the logical
database design.
. Designed processes to extract, transform, and load data to the Data
Mart.
. Involved in Informatica mappings development using Power Center
designer and server manager /Work flow Manager to create the
sessions and did lot of testing and data cleansing.
. Performed impact analysis, remedial actions and documented on
process, application failures related with Informatica ETL and
Power Analyzer.
. Performed developments and changes using ETL tool (Informatica), BI
tool (Power Analyzer) and Oracle database/data warehouse.
. Performed regular backup of data warehouse, backup of various
production, development repositories including automating and
scheduling processes.
. As part of optimization process, performed design changes and
changes in Informatica mappings, transformations, sessions.
Involved in development of complex mappings.
. Interacted with external, internal users and DBA in troubleshooting
problems reported in huge Volume testing (100-200 Million records
Data) systems.
Environment:
Informatica Power Mart, Power Center 6.x/7.x, ETL, Cognos 7.0, Oracle 8i,
SQL Server2000, MS Access, Erwin 3.5, SQL, PL/SQL, TOAD 7.x, Windows NT.
Informatica Power Center 6.x, Oracle, Flat file, SQL Server 2000, SQL*
Loader, PL/SQL, UNIX, Windows 2000.
Sahithi Systems, Hyderabad, India
(Jun'03 - Jul'04)
Oracle Developer
Responsibilities:
. Developed Procedures, functions, packages and Triggers for
enforcing the business rules using PL/SQL.
. Designed the user interface screens using Oracle Forms 4.5 and
generated reports using D2K reports 2.5.
. Developed Program Libraries for storing of Procedures that were
used frequently in the System and user security package,
integration and user acceptance testing. Prepared technical
documentation and user specifications.
. Involved in creation of Schema Objects like indexes views, and
stored procedures. Involved in the Analysis of how the purchase
order process is organized.
. Involved in a team in designing the Database Schema, for the
metadata for storing the informative queries that are generated
dynamically.
. Identifying integrity constraints for tables.
. Involved in writing the Triggers which internally calls procedures
and functions.
. Involved in testing the database for the queries that are generated
and handled the performance issues effectively.
. Involved in documenting the entire process.
. Involved in Implementation and Testing phases of the system.
Environment:
Windows 98, UNIX, Oracle 7.x, PL/SQL, SQL *Plus Reporting, SQL *Loader.
Contact this candidate