Manager Sql Server
Resume:
Yasaswini Mohapatra
***********@*******.***
Summary
8+ years experience supporting Enterprise Level data warehouse and delivering projects of
technical complexity. An effective leader and member focused on identifying efficient solutions for
all users and internal clients. 8+ years of experience in Cognos 8.2,8.3,cognos EP series 7.0,
Cognos Reportnet MR1, MR2 and MR3, Cognos Impromptu6, 7x, 7.3 (admin and User versions),
Power play 7/6.x, Transformer, IWR 7x, 6.x (with IIS, Netscape directory server 3.x/4.x, ticket
server), Upfront, Access Manager, Cognos Scheduler, Cognos server admin, Erwin.
Cognos8 .2,8.3BI, Business Objects, Report Net MR2 and MR3, EP
7.0/7.1/7.2/7.3 Series, Cognos Impromptu, Power play transformer, Power
BI Tools play Reports, IWR, Upfront, Cognos Script, Cognos Query Crystal, Enterprise
Crystal reports Designer
Security Access Manager,SUN one Directory Server
Data Modeling Erwin
ETL Informatica, Decision Stream
RDBMS Oracle 9i, 8i, (PL/SQL), SQL Server 2000(T-SQL)
Project Management Rational Unified Process (RUP), Rational Rose, Rational Requisite Pro,
Tools/Methodology Rational Clear Case
GUI Visual Basic6.0, Visual C++
Internet Tools ASP (3.0), VB Script, HTML (4.0), DHTML, XML
Technologies C,C++, COM
Other Tools Visual InterDev (6.0), Visual Source Safe (VSS), MS Office
Operating Systems Sun Solaris, HP 11i (Superdome), Win NT, Win2000
Design Methodologies Unified Modeling Language (UML), Six Sigma
Professional Experience:
Avaya Telecom Inc, Basking ridge, NJ May2005-Till now
As Senior Cognos Consultant/BI Lead
• Senior Data warehouse Lead responsible for defining, leading high-impact data
warehouse projects.
• Modeling the Central Data Warehouse tables for different data marts (like
finance,HR,Sales) and created Cognos packages based on the star schema.
• Designed Cognos series 7,8.2,8.3 Framework models, Report studio Reports for the Central
Data Warehouse used FACT and dimension tables and store procedures in the model.
• Adding security macros, filters in the Framework model to implement in the report.
• Developed highly secured powerplay cube for HR in collaboration with IBM to make sure
the security is properly implemented. Used shell scripting to automate the cube builds
from one server to other.
• Involved in the process of integrating the web portal and Cognos reportstudio/query
studio reports for business partners through API. Set up user class for Business
Partners to successfully retrieve the reports through different cascading prompts.
• Create complex cognos8.2and 8.3 report studio reports which includes drill through,
Cross tab, Dashboards, conditional reporting. Used Analysis studio for cognos 8 products.
• Modify 100 + ad-hoc and standard reports for business users.
• Email Bursting of the Series 7,8.3/8.2 reports to different business uses.Scheduled
reports to users mailbox.
• Strong in Cognos8.3 and series 7Report studio and query studio reporting,Powerplay
Transformer and Analysis studio. Published cubes both in PPES and Framework manager for
Cognos series 7 and Cognos8.2 and 8.3.Migrating reports from series 7 to cognos8 versions.
Maintain Proper technical documentations in source safe.
• Refresh Powerplay cubes Cube and secured the HR cube based on the Hierarchy.
• Developed and highly secured Power play cube for HR in collaboration with IBM.
• Involved in the Cognosseries 7,8.2/8.3 SDK reporting .
• Provide ongoing architectural and performance improvements in Data
Warehouse reporting, through the optimization of multi-dimensional models, other
database optimizations, infrastructure. Also provided regular, frequent and detail-
appropriate reports back to leadership team.
• Monitor data warehouse data quality and investigate issues as they arise. Get
involved with business to find out the root cause from source system to target.
• Awarded for BI stabilization effort and worked with the IT Infrastructure team
for server consolidation effort. Involved in the process of integrating the web portal and
Cognos reports for business partners through API. Set up user class for Business
Partners to successfully retrieve the reports.
• Architecture behind the Cognos application and SSO integration on the webservers
using ASP in cognos BI products.
Security and administration
• Creating users in Access Manager based on their position. Used LDAP security.Implented
Sun one Directory server. Maintained Access Manager back up .Exporting the LAE files.
• Implementing Package and Report security on the Cognos Portal.
• Multiserver configuration for cognos servers. Provide maintenance improvements,
upgrades and defect patches to existing web applications. Perform day-to-day Cognos
administration and production support activities. Upgrade from Cognos MR2 environment
to MR3 and DST patch installation in all 15 production servers.
• Performance Tuning & Optimization: Regularly evaluate and monitor databases and
stored procedures to identify and resolve performance and reliability issues.
Environment: MS Office Suite,MS Visio, MS Share Point, Business Objects, Oracle 9i, 10i/g,
SQL/PLSQL, RUP, UML, Windows XP / 2000,UNIX,Tomcat,Java J2EE, SQL
server200/2005,Cognos,Powerplay,Transformer,SunOneDirectory server,Planning, Siebel, SAP,
ODS-Oracle 9x, ETL-Informatica Reporting-Cognos ReportNet, XML, HTML.
Johnson & Johnson, NJ
Senior Cognos consultant (Jan2005-May2005)
Johnson & Johnson is the world's most comprehensive and broadly based manufacturer of health
care products. The project dealt in the migration and data consolidation of a system data from
Impromptu to Cognos7.3 series.
Responsibilities:-
• Work closely with developers of reports and analytical cubes, ETL developers, data
architects, application developers and others to insure that the wide range of rapidly-
changing data sources are being used in the most efficient manner.
• Installed and configured Report Net, Framework manager and created a database for
Content Store.
• Created packages from the model and published it to the Report Net Portal.
• Involved in full life cycle of report design, development, and implementation for
manufacturing dept. Supporting and maintaining the manufacturing module of the company ERP
system
• Involved in full life cycle of report design, development, and implementation.
• Perform day-to-day Cognos administration and production support activities
• Publish report sets and cubes on the web server(s). - Manage queues and reports using
Server Administration. Published 400 IWR reports on 7.3 Report Administration. Set up security.
• Run the user defined scripts for Power play cubes on UNIX.
• Published visualizations data on upfront portal.
• As a lead … work with designers, project managers and client to create the scope and
timeline for the project. Comprehending the functional requirements to translate into
technical approaches.
• Deploy and support the implementation of Cognos Series 7 suite in HP UNIX
2
(11iSuperdome) and Midrange (Application server - WIN2K) environments.
• Publish report sets and cubes on the web server(s). - Manage queues and reports using
Server Administration. Published 400 IWR reports on 7.3 Report Administration. Set up
upfront security.
• Run the user defined scripts for Power play cubes on UNIX.
Environment: UML,Oracle, PL/SQL, Windows NT, Java, Java Script, Unix Shell Scripts, Cognos 7.3
series, Cognos Queries,Visio, Rational Suite (Rational Test Manager).
GURUS IT (Ward Products), NJ
Senior Cognos Consultant (April2004-Oct2004)
The Client Request Procedure system of Ward Products, a leading Manufacturer of Car Antenna,
Sub Parts and Cables etc. in US provides accurate and timely response to client inquiries.
Responsibilities:
• Created models in Framework Manager with imported catalog as Data Source and also with
other Data sources.
• Created packages from the model and published it to the Report Net Portal.
• Created Reports using Report Studio using the packages.
• Involved in full life cycle of report design, development, and implementation for manufacturing
dept.
• Good Expertise in Cognos Reportnet, Framework manager, Report Authoring, Query Studio.
• Involved with the users on their rigorous testing and solving their issues pertaining to the
reports and cube.
• Used Access Manager for User classes’ security. Security on Report sets.
• Creating, managing and administering all catalog libraries, Impromptu reports, Web
reports and OLAP cubes on Oracle and SQL server database
• Design and Development of Business Models using Power play Transformer to generating
Cubes, and Cube Groups from them.
• Created BI reports using Cognos Impromptu 7.0 and Power Play 7.0
• Used Access Manager Administrator 7.0 to provide security for Cognos Applications
• Used Cognos Scheduler to schedule the reports.
• Managed both UAT and Development Environment simultaneously allowing the users to
compare both the environments in turn having both the environments in sync.
Environment: Report Net 1.x (Framework Manager, Report Studio, Query Studio) Impromptu 7.0,
IWR, Upfront 7.0, Power play 7.0,PowerPrompts 7.0, Power play Transformer, Access Manager,
Windows 2000, SQL Server 2000,Oracle9i.
Dow Jones & co, NJ
Application Consultant/ Cognos consultant (Jan2001-July2003)
Scope:- The goal of the (XMS)Travel Expense System (web-based system) is to reduce the costs
and delays inherent in the current, largely manual, travel reimbursement process.
Roles and Responsibilities
• Experience in Requirement gathering, analysis, design and proposing solutions to the
customers. Involved in projects from the proposal phase through project completion.
• Developing catalogs with Impromptu administrator for use with Cognos impromptu
reports and Impromptu web reports and Power Play cubes. Assisting users in setting up
and accessing reports. Used security for user classes.
• Developed Ad-Hoc reports using Oracle database and Cognos Impromptu. Experienced in
Database development skills using Oracle PL/SQL to write stored procedures, functions,
packages.
• Developed Cognos Impromptu and Powerplay reports and Cognos Scripts to automate
the creation of Custom Template Reports.
• Performance Tuning – Optimized queries for minimal query time in Impromptu. Indexed
tables to improve performance.
• Analyze and Track the existing problem, prepare necessary documentation and carefully re-
modify the program
• Developed Cognos Impromptu and Powerplay reports over Oracle and SQL server
database.
3
• Development, maintenance and trouble shooting of Cognos Impromptu reports against
various oracle databases. Provided production support, on-call support.
• As a production lead was fully responsible for posting and publishing of Impromptu reports
on the web.
• Extensively used PL/SQL programming in backend and front-end functions, procedures,
packages to implement business rules.
Enviornment: Cognos Impromptu 5.x.6.x(admin and User versions), Powerplay 6.x, IWR 6.x
(with IIS, Netscape directory server 3.x/4.x, ticket server)Oracle 8.x/,SQL Server
2000,PL/SQL,SQL,SQL*PLUS,SQL*LOADER,ERWIN 3.5,TOAD,Shell Scripting using AWK/ SED,
Scripting on Unix Sun OS 5.6/5.7/NT
New York life Insurance company
Programmer Analyst (1998-2000)
Scope: The Employee’s Whole Life (EWL) policy is a traditional life product that is sold at the
workplace to employees via payroll deduction.
Responsibilities:
• Involved in all requirement gathering, design, development, testing, training and rollout to
the field users.
• Migration of data from C++ to COM.
• Developed new system in COM and writing the business rules in C++.
• Documented and delivered Functional Specification Document to the project team.
• Collaborated with development architect and the business to develop both high-level and
detailed application architecture to meet the business needs.
• Working with the business users, developed the system and Unit Testing, integration testing
and preparation of test plans.
• Developed stored procedures, functions and database triggers.
Environment:-visual C++,C,BORLAND,COM,DCOM,Oracle,Windows SDK,Mainframe.
• Certification & Training:
• Cognos Reportnet 1.1 Administration Product Professional
• Cognos Reportnet 1.1 Product Professional Metadata Modelling
• Cognos Reportnet 1.1 Product Professional Reportnet
• Impromptu Administration, Cognos Corporation New Jersey.
o Impromptu Report Building, Cognos Corporation New Jersey.
o Cognos Powerplay, Cognos Corporation, New Jersey.
o Cognos Reportnet 1.0, Cognos Corporation.
o Informatica 6.2 Training from Informatica Corporation
• Education:
• Middlesex county college,NJ
• Radiant Systems,NJ
• M.S, Mass Communication, India.
• M.S, Political Science, India
4
Contact this candidate