Manager Sales
Resume:
Summary of Qualifications:
Shilpa Chakravarthy
Business Intelligence Tools:
MicroStrategy 9.x, 8.1.1, 8.0.2, 8i and older, Cognos Power Play, Cognos
Upfront
Languages:
Visual Basic V6.0/ V5.0, ActiveX, Cold Fusion V4.0, ASP, JavaScript,
Java, J2EE, PL SQL, SQL Plus, K Shell
RDBMS:
NCR Teradata, Oracle 8.0, Oracle 9i, Oracle 10g, Retek, MS SQL Server
7.0, Sybase, MS Access
Tools:
Viisual Interdev, Visual SourceSafe, Rational Rose 98, Rational Robot,
MS Transaction Server, Internet Information Server, Seagate Crystal
ReportsV4.5/7.0 and Seagate Crystal Reports Web Server, TOAD, Informatica
7.1
Operating Systems:
Unix, Windows NT 4.0, Windows 95
EXPERIENCE
CABLEVISION, New York
08/2008 - Date
Microstrategy Architect/Sr. Developer
Creation of Microstrategy metadata for ad hoc reporting, dashboards to
measure HH TV Viewing (hours per day/week of aggregated tv viewing), HH TV
Viewing of specific Channels/Networks, Programs
. Analysis - Involved in Business requirement gathering of projects from
Sales and Marketing users, provide project estimates.
. Involved in the Data modeling phase for the logical data model of the
database. Design of Dimension, fact, transformation tables using star
schema.
. Architect Tasks - Preparation of Microstrategy Report Metadata and
Schema Design document,
. Architect Tasks - Designed and developed Schema objects (attributes,
facts, Transformations, User hierarchies). Creation of schema objects
(attributes, facts, transformations) to support Ad-Hoc Reporting.
. Development - Designed project from scratch creating a clean metadata,
hierarchies, relationships between attributes in order to handle Ad-
Hoc reporting. Creation of public objects - Dashboards using v9.x,
creation of complex metrics, reports, Report Services documents
working on several complex datasets along with XSL changes.
. Designed metrics to handle drill downs to different hierarchies.
. VLDB properties - handle outer joins, global optimizations, optimize
SQL statements using Oracle hints, performance tuning SQL statements
for good performance.
. Organize, test and adjust metrics and attributes. Create standard
report templates for ad hoc reporting.
. Design and development of dynamic Dashboards using MSTR v9.x using
panel stacks, element selectors, metric selector. Narrowcast Weekly
Dashboards to end user community.
. Administration - Implemented Integrity Manager, Enterprise Manager
usage for performance. Microstrategy Object Manager to migrate between
projects and environments and Report Tuning for performance. Creation
of Enterprise Manager custom reports for email delivery of Weekly User
Activity reports of Microstrategy project and report usage.
. Production Support -Narrowcast - Implemented service weekly and
monthly jobs using static subscriptions.
. Production support - Support of Microstrategy project for marketing
and sales user group, resolve helpdesk tickets.
. End User Training - Creation of End user training document. End user
training and production support for user build reports, canned reports
and narrowcast reports for Sales and Marketing group.
Environment:
MicroStrategy 9.x, MicroStrategy NarrowCast 9.x, Microstrategy
Administrator, Microstrategy Integrity Manager, Microstrategy Architect,
Oracle 10g, Windows 2000
PFIZER, New Jersey
05/2007 - 08/2008
Microstrategy Architect
Worked on multiple projects including global item view of Sales, Forecast,
Budget, Inventory data across the various locations (Market, DC) throughout
the network including visibility to market, plant level and replenishment
planning data.
. Analysis - Involved in Business requirement gathering of projects from
end client, provide project estimates. Involved in the Data modeling
phase for the logical data model of the database. Design of
Dimension, fact, transformation tables using star schema. Preparation
of Reporting Design document, Test Cases. Review and Signoff from
Business users.
. Architect Tasks - Designed and developed Schema objects(attributes,
facts, Transformations, User hierarchies).
. Development - Creation of schema objects (attributes, facts,
transformations) to support of Ad-Hoc Reporting. Creation of public
objects - Reports(Grid, graphs), Report Services documents working on
several complex datasets along with XSL changes, filters, prompts,
metrics, complex metrics, report filters. Design and development of
dynamic Dashboards using MSTR v8.1.1 using panel stacks, element
selectors, metric selector. Narrowcast dashboards to end user
community.
. Creation of events, schedules to plan caching of reports with respect
to data load.
. Administration - Implemented Integrity Manager, Enterprise Manager
usage for performance. MicroStrategy Project and Report Tuning for
performance. Perform cleanup of objects using Scan MD. Upgrade to
8.1.1 from 8.0.2. Designed and development of the Security filter
implementation using Command Manager scripts. Creation of users, user
groups, object migration.
. ETL Support: Support helpdesk tickets for Informatica ETL objects and
enhancements.
. Production support - Performance tuning, resolve helpdesk tickets.
Environment:
MicroStrategy 8.1.1, MicroStrategy NarrowCast 8.1.1, Microstrategy
Administrator, Microstrategy Integrity Manager, Microstrategy Architect,
Microstrategy Office, Oracle 9i, Informatica, Windows 2000
Metlife, New Jersey
09/2006 - 03/2007
Lead Microstrategy Architect
A single reporting application having policy details information for the
years 2004,2005,2006 thereby eliminating the present cross reporting
process. The new reporting applications will provide all the necessary
information about Leads and Sales required by Marketing Home Office and
Field Management.
. Worked with Business Analyst to identify Microstrategy Security
related Requirements in Requirements Document.
. Preparation of Technical Specifications of Microstrategy Schema
objects. Architect: Involved in the Data modeling phase for the
logical data model of the database.
. Supervised two junior offshore Microstrategy developers and one onsite
developer.
. Faced many challenges involving but certainly not limited to MSI tool
limitations, altering dimensional models to suit the business
reporting, proper metrics calculations, and especially justifying the
causes for having other teams to build the Aggregates
. Review of Microstrategy objects and hands-on development of complex
Microstrategy metrics and schema objects.
. Creation of several report services documents having several datasets,
complex format changes to combine reports to look like one report.
. Designed and development of the Security filter implementation using
Microstrategy SDK and Command Manager scripts.
. Migration to Security SDK implementation to Production.
. Architect Tasks - Designed and developed Schema objects(attributes,
facts, Transformations, User hierarchies).
. Administration Tasks - Migration from Development to UAT PRODUCTION
using Object Manager. Enterprise Manager usage for performance.
MicroStrategy Project and Report Tuning for performance.
. Applied Microstrategy ODBC patch for DB2 supported database drivers.
Environment:
MicroStrategy 8.0.1, MicroStrategy NarrowCast 8.0.1, Microstrategy
Administrator, Microstrategy Architect, Microstrategy SDK, Microstrategy
Office, DB2, SQL Server, Informatica, Windows 2000, SiteMinder
Toys R Us, NJ 04/2006
- 09/2006
Sr. Microstrategy Developer
Design, development, implementation of vendor Microstrategy reports for Web
users.
. Business Analysis - Analyze merchandise retail microstrategy requirements
into reporting requirements.
. Creation of database views for building attributes.
. Architect: Microstrategy development - Build schema objects, prompts,
filters, metrics. Build Reports - Delivery Variability, Item Performance
by Location, Market Basket, ASN Compliance & Week To Date Sales.
. Development of reports, report services documents (dashboards)
. Performance tuning using VLDB properties.
. Administration - Migration of Reports to UAT for user sign-off.
Environment:
MicroStrategy 8.0.2, Microstrategy Architect, Teradata
Bank Of America, New York City
06/2005 - 04/206
Microstrategy Architect/ Administrator / NarrowCast Specialist
MicroStrategy reporting for Phoenix Asia and Phoenix Portal
projects(Equities and FX). This project will provide Market Risk
calculations for Fixed Income (FI) business globally along with complete
functionality for Asia businesses (including FX and Rates products)
sufficient to retire the current ARMS II system application. This project
will implement a major module of the global Market Risk Management system -
PhoeniX.
. Gathering user requirements from Asia users.
. Supervised two junior onsite Microstrategy developers. Supervised
Microstrategy offshore developers in India.
. Deployed and managed 3 Projects to PRODUCTION.
. Design of MicroStrategy Project from scratch and designed and developed
schema and public objects.
. Learning of PhoeniX equities and FX functionalities
. Architect: Complete design and development of 40 MicroStrategy reports.
These reports replace existing old legacy system reports.
. Microstrategy Desktop tasks - Complete design, development and deployment
of 200 Reports for FX Desk, Portfolio Desk and Canada Desk.
. Designed and developed HTML Document. Developed XSL files for formatting
of reports on HTML Document.
. Microstrategy Desktop tasks - Designed and created Report Services
Document.
. Administration Tasks - Migration from Development to UAT to PRODUCTION
using Object Manager.
. Web and Desktop administration for the Project. Administration for
performance using Enterprise Manager. Performed Administrative tasks in
a Project life cycle.
. Trouble shooting and fine tuning reports in PRODUCTION.
. Designed NarrowCast reports for the project. Configuration of Narrowcast
Server for file transmission and e-mail transmission. E-mailed users
Excel Workbook with formatted excel worksheets. Email reports to
different email distribution list depending upon the users that need to
see the reports using dynamic subscription sets.
. File delivery of NarrowCast Reports to different file servers and
archiving of old Excel reports using Schedule and dynamic subscriptions.
. Writing BAT file to call Command manager to execute Service. Web
customization using XSL for formatting of reports
. Web customization using Java 1.2.X, J2EE and XML.
. Trouble shooting and fine tuning reports using VLDB properties in
PRODUCTION.
Environment:
MicroStrategy 8.0.2, MicroStrategy 8.0.1, MicroStrategy NarrowCast,
Microstrategy Administrator, Microstrategy Architect, Sybase
Bank Of America, NYC 05/2005
- 06/2005
Microstrategy Architect/ Administrator
MicroStrategy reporting for Credit Dashboard - Credit Dashboard is an
application for viewing and comparing the credit worthiness of
companies/clients and examining the market spreads for bonds and CDS
relevant to these companies. It is rich in fundamental data and market
data.
. Creation of MicroStrategy reports for the Proof of Concept for Credit
Dashboard and successful presentation of POC to the user.
. Microstrategy Project Design of schema, tables
. Creation of Schema object, metric, prompts, filters, templates, drill
maps, page by, document object using Report Services.
. Created complicated graphs - bar, stacked, line and consolidated graphs,
reports, metrics as document using Report Services, OLAP Services.
. Created Query page, Search page with graphs and grid results on the same
report.
. Designed reports for efficient SQL generation and good performance (VLDB
properties) using moderate normalization.
. Designed Ad Hoc Reports
. Administrative tasks - Moved Microstrategy objects using Object Manager.
Environment:
MicroStrategy 8.0.1, SQL Server, Windows 2000
Forest Labs, NYC (PHARMA) 11/2004
- 04/2005
Microstrategy Administrator/ Sr. Microstrategy Developer
MicroStrategy reporting for multiple datawarehousing projects - Market
Research, Weekly Data and Forest Sales Datawarehouse projects
. Interact with the users to gather requirements for reporting
(Microstrategy) and data structure to load data using Informatica.
. Loading Weekly, Daily, and Monthly Data into fact tables for Market
Research Team using macros and procedures. Loads used K Shells, PL SQL
and Informatica
. Designed datawarehouse tables for efficient SQL generation and good
performance using moderate normalization.
. Created Microstrategy hierarchies, metrics, advanced metrics (level
metrics, non-aggregatable metrics, transformation metrics, conditional
metrics, count metrics).
. Design and implement Microstrategy Schema objects. Created Microstrategy
report objects.
. Created Microstrategy document objects, custom groups, filters etc. for
reports.
. Creation of graph reports for different markets (AD, ARB, SSRI, Pain,
Cold Cough etc) that contain Sales, Prescription data that are scheduled
to execute weekly every Monday.
. Implemented Intelligence Server administration including backups of
metadata.
. Moved Microstrategy objects using Object Manager within different
iServers.
. Administration of performance using Microstrategy Enterprise Manager.
. Created Excel macro to process data files to required format. r
. Creation of Presentation Decks for Brand Team by updating the slides that
contain Microstrategy report graphs and Microstrategy documents. These
reports are presented to the CEO every Monday morning. Production support
for these Presentation Decks.
. Analysis of Data when new products or families are introduced in the
market.
. Performed Administrative tasks like Cache and Job monitoring, Database
instance creation, user creation.
. Used Narrowcast Server to schedule reports, which have Excel information
objects. Used Excel macros to "format" some of the data to meet user
requirements.
. Trouble shooting (looking at the SQL generated for reports) and
performance tuning using VLDB properties.
. Weekly Data project - Maintenance of reports and user group. Creation of
Prescriber reports, Top 100 Prescribers, CP/ALC TRX, Mkt Shr by Decile
LTD when new products are launched in market after getting user
requirements every alternate month
. Forest Sales Datawarehouse - Maintenance of reports and user groups.
Schedule Monthly Reports to be delivered to the user community.
Environment:
MicroStrategy 7.5.3, NarrowCast Server, Oracle 9i, TOAD, PL SQL, MS -
Excel, K Shell, Informatica 7.1, UNIX
C3i, NJ (PHARMA) 08/2004 -
10/2004
Microstrategy Administrator/ Sr. Microstrategy Developer
The release includes IMS Monthly Xponent Rx data and Pharmagistics Call
Activity data.
. Creation of users, user groups, security roles and object access. Created
users (Home Office Analysts in Sales and Marketing Services) and Regional
Managers.
. Created security filters for delivering reports to Region Name.
. Administrative tasks - Performed schedules to generate reports, idle and
resume projects.
. Created hierarchies, metrics, advanced metrics (level metrics, non-
aggregatable metrics, transformation metrics, conditional metrics, count
metrics).
. Used Narrowcast Server to schedule reports, which have Excel information
objects. Used Excel macros to "format" some of the data to meet user
requirements.
. Created schema objects
. Created reports for Rx, Call Sample Detail, Alignment, Professionals.
Reports such as Rx Trend Summary (Territory), Effort vs Result, Impact
Report, Physician Profile Report, Sample Distribution Report, Target
Physician Listing, Regional Call Activity Report and Activity Threshold
Report.
. Trouble shooting and bug fixing of Phase I project.
. Loading data, created mappings and transformed data into fact tables
using Informatica PowerCentre 7.1
. Data modelling of Phase II project for design of the project.
. Testing Phase II project
Environment:
MicroStrategy 7.5, NarrowCast Server, SQL Server 2000, Informatica 7.1
Aventis Pharma, NJ 08/203
- 06/2004
Microstrategy Administrator/ Sr. Microstrategy Developer
. Involved in designing the architecture of the application with other
members of the team.
. Transferred business knowledge to teammates and trained teammates on
Microstrategy.
. Installation of Intelligent Server, NarrowCast Server. Configuration of
Web Server.
. Performed administrative tasks such as creation of metadata connectivity
and database connectivity, security, Caching and Datamarts. Used MSTR
Object Manager, Merge Manager, Project Merge, Web administration and VLDB
Properties.
. Created security filters for delivering reports to US users and Puerto
Rico users.
. Creation of users, user groups, security roles and object access.
. Performed schedules to generate reports, idle and resume projects.
. Migrated project from the Development to Staging to Production using
Object Manager.
. Migrated reports built in MSTR 7.2.3 to MSTR 7.5
. Troubleshooting database errors in Microstrategy reports.
. Fine-tuned reports for faster performance using VLDB Properties and
Report Data Options
. Created schema objects (attributes - for Time, Sales Organization,
Reporting Division and Associate), facts related to Call Sample Detail
and Sales reports.
. Created hierarchies, metrics, advanced metrics (level metrics, non-
aggregatable metrics, transformation metrics, conditional metrics, count
metrics).
. Created filters, prompts (Object prompt, Value prompt, Level prompt,
filter definition prompt) for creation of microstrategy reports. Created
drill to templates using template editor. Embedded templates in reports.
. Created reports for Call Sample Detail and Sales for all levels of Sales
Team in AT, PC and Endo.
. Created documents containing reports and sub reports. Customized XSL to
format sub reports to hide report links, page-by, metric headers and
align all reports in the document.
. Created Custom Groups, Sub-totals based on metrics, used Pass-through
functions like ApplySimple, ApplyComparison
. Designed reports using the schema and public objects.
. Created Intelligent cubes and Published reports on Microstrategy Web.
. Used Narrowcast Server to schedule reports, which have Excel information
objects. Used Excel macros to "format" some of the data to meet user
requirements.
. Provided users with the ability to subscribe to each report and specify
the report frequency.
. Created reports with the ability to sort in ascending/descending order by
all columns.
. Created reports with monthly, weekly and yearly frequency.
. Troubleshooting and fine-tuning.
Environment:
MicroStrategy 7.5, MicroStrategy 7.2.3, NarrowCast Server, Oracle 9i,
Informatica
VISA USA, CA
10/2002 - 07/2003
MicroStrategy Administrator/ Sr. Microstrategy Developer
. Involved in designing the architecture of the application with other
members of the team.
. Involved in evaluating guidelines and establishing the prescribed
standards.
. Collating user requirements, business analysis, creating functional specs
and delegating appropriate tasks to team members.
. Transferred business knowledge to teammates and rained team mates on
Microstrategy.
. Configuration of MicroStrategy Intelligence Server and administration of
the Intelligence Server(Start and Stop).
. Creation of Project Source, Projects under the Project Source.
. Establishment of Metadata and Warehouse connection
. Creation of Database Instance, Database Connection, Database Login and
user connection mappings.
. Creation of users, user groups, security roles and object access.
. Administration of MicroStrategy Intelligence Server.
. Monitored Caching (object, element)
. Performed project duplication into two-tier using Project Duplication
Wizard.
. Used Microstrategy Object Manager to move objects, copy objects, delete
and rename objects.
. Administration of web users using MicroStrategy Web Administration.
. Created attributes, hierarchies, metrics, advanced metrics (level
metrics, non-aggregatable metrics, transformation metrics, conditional
metrics, count metrics).
. Created filters, prompts (Object prompt, Value prompt, Level prompt,
filter definition prompt) for creation of microstrategy reports. Created
drill down maps for reports.
. Fine-tuned reports for faster performance using VLDB Properties and
Report Data Options
. Created Custom Groups, Sub-totals based on metrics, used Pass-through
functions like ApplySimple, ApplyComparison
. Designed reports using the schema and public objects.
. Created Intelligent cubes and Published reports on Microstrategy Web.
. Used Narrowcast Server to schedule reports, which have Excel information
objects. Used Excel macros to "format" some of the data to meet user
requirements.
. Migrated from Microstrategy 7.2.1 to 7.2.3
. Provided users with the ability to subscribe to each report and specify
the report frequency.
. Created reports with the ability to sort in ascending/descending order
by all columns.
. Created reports with monthly, quarterly and yearly frequency.
. Create daily and monthly data loads, which also back tracks previous
failed data loads.
. User training and documentation.
. Troubleshooting and fine-tuning.
Environment:
MicroStrategy Desktop 7.2.2, NarrowCast Server, Informatica
VISA USA, CA 10/2000
- 09/2002
Sr. Web Developer
. Involved in evaluation of available reporting tools and selecting
Microstrategy as the standard reporting tool for all Data warehousing
projects.
. Involved in logical database design.
. Conducted training for teammates on Microstrategy and Data warehousing
concepts.
. Initial point of user contact for the implementation of Data Warehouse.
. Created System Design Document SDD from Business Requirement Document
BRS.
. Translated business requirements into further development.
. Created Microstrategy data warehouse, fact tables and schema objects like
attributes and hierarchies, metrics, advanced metrics, Create drill maps
and drill paths for reports
. Created filters, prompts (Object / Value / Level prompt, filter
definition prompt).
. Designed reports using the schema and public objects.
. Fine-tuned reports for faster performance using VLDB Properties and
Report Data Options.
. Fine-tuned reports for faster performance.
. Published reports on Microstrategy Web.
. Used Narrowcast Server to run reports, which have Excel information
objects.
. Used Administration tools like Object Manager, Cache Monitor.
. Create daily and monthly data loads, which also back tracks previous
failed data loads.
. Extensive user interaction and training, Fine Tuning and troubleshooting.
Environment:
MicroStrategy Desktop 7.2.2, NarrowCast Server
VISA USA, CA
04/2000 - 11/2000
Sr. Web Developer
. Involved in gathering business requirements., design document and
Business Req. Specification.
. Involved in logical and physical design of the database using ERWin.
. Created ASP Pages for Admin - Threshold, Exception Analysis, BIN, MCC
and State Maintenance.
. Implemented table driven security for Team Manager and team Members
using ASP Pages.
. Generated ASP Pages to manage new requests, send Email notification to
team members who were assigned requests. Reassign requests also
notifies the new assignees.
. This Application uses Crystal to generate reports like Summary Reports,
Team Member Load Reports, Open Requests, Closed Requests and various on
the fly reports.
. Fully tested and implemented the website on VISA intranet.
. Improved the performance of all stored procedures.
. Added new functionality using ASP Pages to search by Date Range
. ASP Pages that performs user login validation, ASP pages that perform
search results for search criteria range for a Bid Name, Merchant Name,
Industry type etc. parameters.
. Created ASP Pages to implement the Lookup for MCC, BIN, Merchant
Category, and Fraud.
Created ASP Page to manage security to access the Oasisweb website.
Build ActiveX COM Objects for Database Access and Stored Procedure
execution
Environment:
Active Server Pages 2, Visual Basic V6.0, MS SQL Server V7.0, MS Access,
Seagate Crystal Reports V7.0, Crystal Reports Web Server, and Windows NT 4
ICRG, CA 01/2000
- 04/2000
Sr. Consultant
CTG Tracking System is a web based testing application.
. The CTG Tracking System (CTG-TS) is available for the IST, IAT, and CUAT
environments. Its purpose is to capture application information and
testing status for integrated testing execution and management reporting
purposes (IAT and CUAT only).
. It has 4 components: Application Milestone Tracking, Script Totals, Code
Notification, Problem Tracking, Reports and administration Task.
. Created Web pages using Cold Fusion for implementing the functionality of
Creation, Updation and Deletion of Release and its associated business
functionality module.
. Report Development - Actuate BIRT - Provided ability to cost-effectively
deploy enterprise database driven reports to a wider audience.
Programmatically control report behavior using JavaScript.
Actuate - Data access directly to SQL databases, CSV files s as data
source.
Environment:
ACTUATE BIRT, Cold Fusion V4.0, Visual Basic V6.0, MS SQL Server V7.0,
Seagate Crystal Reports V7.0, Crystal Reports Web Server, and Windows NT
4.0
SILVERLINE INDUSTRIES LTD., INDIA 10/1999
- 01/2000
Programmer Analyst
Prepared ASP Pages for user profile and invoice generation modules and
functionality.
Created ActiveX COM Visual Basic Objects, ADO objects to connect to MS SQL
Server database .
Responsible for ASP Pages that handled user profile, security and invoice
modules.
. Designed and developed Seagate Crystal Reports for user security module
and print functionality for the invoice module using Seagate Crystal
Reports V7.0 and Crystal Reports Web Server.
. Implemented functionality of exporting reports to HTML, MS Word and Excel
format using API calls of Seagate Crystal Reports.
Environment:
Visual Basic V6.0, Visual SourceSafe, MS SQL Server V7.0, Active Server
Pages 1.0, JavaScript, Seagate Crystal Reports V7.0 and Crystal Reports Web
Server, IIS, MS Transaction Server and Windows NT 4.0
PRINCETON, India 02/1999
- 09/1999
Consultant
. Part of a team to prepare Use Case and Trace diagrams, generated
framework for classes included in COM Objects/ ActiveX DLL's using
Rational Rose 98.
Developed an error handling ActiveX code component.
Developed COM Object to connect to database and execute stored procedures.
Developed a COM Object for subject and subject addition, subject delete and
search functionality.
Used Rational Rose 98 to Create data level diagrams for subjects, data
menus, user preferences and db classes
. Created ActiveX control for the GUI that handled the various subjects,
data menus. The ActiveX control built the Tree Structure of branches on
the fly populating the topmost menu item with values.
Responsible for database design., Creating databases, tables, indexes, new
logins, users etc.
Integrated ActiveX DLLs, Actives OCX, Classes, VB Application project and
tested it. Was responsible of the first release. Successfully implemented
the first release.
Environment:
Rational Rose 98, Visual Basic V6.0, Visual SourceSafe, Seagate Crystal
Reports V7.0, Sybase, MS Transaction Server and Windows NT 4.0
NODS, India 04/1998 - 01/1999
Consultant
Participated on a team to develop reports for Credit Suisse Bank based on
RAPP Parameters and scenario
Database design, Creating databases, tables, indexes, new logins, users
etc, and tuning.
Developed visualization forms.
Developed COM Object for report generation for various parameters and
scenarios, group wizard.
Developed COM object to connect to database, to return result sets
implementing code reuse.
MTS was used as middle tier.
Environment:
Visual Basic V5.0, Visual SourceSafe, SQL Server, Microsoft Transaction
Server, MS FrontPage, Seagate Crystal Reports V4.5, MS Help WorkShop
Windows NT 4.0
Micro Associates, India 06/1997 - 03/1998
. User requirements and system study to automate NSDL's Admin, Training
and Insurance department.
. Participated in analysis, systems study and physical and logical
database design using ERWIN.
. Creating databases, new logins, users, Stored Procedures, Tables,
Indexes, Rules, and Defaults etc.
. Report Development - Actuate BIRT - ability to create a conditional
drill-through.
. Prepared more than 15 forms, developed reports using Seagate Crystal
Reports V4.5.
. Developed application module for Master and Transaction modules.
. Created VB COM Object using API calls for changing fonts and colors of
objects
Environment:
Visual SourceSafe, SQL Server, Seagate Crystal Reports V4.5, Windows 95,
Windows NT 3.51, Visual Basic 5.0, SQL Server, and Chartist. Erwin
Education
Bachelors Engineer in Computer Science
Certification in Microstrategy Architect, Administration, Advanced Report
Development
Strong Team Leader (supervised MicroStrategy and Senior Web Developers)
with 13 years of total IT experience in Analysis, Design, Development,
Testing, Administration and Support of large databases/Data warehouses in
financial environments.
10 years plus experience in Microstrategy Admin/Architect/
Desktop/Narrowcast/SDK
Extensive Business Knowledge in Pharmaceutical, Sales and Marketing and
Banking industry and has been involved in Business Analysis, functional
database design, and hardware and software assessment.
9 years Data warehousing experience using MicroStrategy v9.x, 8.1.1 and
older, Microstrategy Administrator, Microstrategy Desktop, Microstrategy
Architect, Microstrategy Web Universal, Microstrategy OLAP Services,
Microstrategy SDK, MicroStrategy NarrowCast Server 8.0.1, SiteMinder 6,
Crystal Reports 8.5/8.0/7.x/6.x, OLAP, and Erwin.
SQL Server experience in Stored Procedures, Triggers, Materialized Views
and Performance tuning of Oracle, Sybase Databases, Applications and
Queries.
Strong Data Modeling experience using ERWIN 3.5.5/3.5.2.
Strong understanding of Datawarehouse modelling tool such as Snowflake,
Star Schema.
Proficient at Enterprise Database Integration and Management. Well versed
in Web development
Proven technical skills, good communication, and a corporate presence and
represents excellent consulting value
SHILPA CHAKRAVARTHY
Contact this candidate