SUMMARY

• Project Development Manager (supervised MicroStrategy, Senior Web Developers, ETL developers) with 20 years of total IT experience in Analysis, Design, Development, Testing, Administration and Support of large databases/Data warehouses in financial environments.
• 16 years plus experience in Microstrategy Administration/Architect/ Development/Narrowcast/Distribution Services/SDK customization/Command Manager automation/Enterprise Manager Statistics gathering and reporting/OLAP Cube based reporting/Cognos/SSRS/Crystal Reports
• Extensive Business Knowledge in Finance, Pharmaceutical, Sales and Marketing and Banking industry and has been involved in Business Analysis, requirement gathering, functional database design, and hardware and software assessment.
• SQL Server experience in Stored Procedures, Triggers, Materialized Views and Performance tuning of Netezza, 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, slowly changing dimensions
• Proficient at Enterprise Database Integration and Management. Well versed in Web development
• Proven technical skills, good communication, and presence with high visibility across teams interacting in an Agile environment

TECHNICAL SKILLS

MicroStrategy 10.x, 9.x, 8.1.1, 8.0.2, 8i and older, Cognos, SSRS

Languages: Visual Basic V6.0/ V5.0, ActiveX, Cold Fusion V4.0, ASP, JavaScript, Java, J2EE, PL SQL, SQL Plus, K Shell

Databases: Netezza, NCR Teradata, Oracle 8.0, Oracle 9i, Oracle 10g, Retek, MS SQL Server 7.0, Sybase, MS Access

Tools: Visual 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

PROFESSIONAL EXPERIENCE:

Confidential

BI Project Manager

Responsibilities:

• Microstrategy Project Manager for all Global Market Risk projects representing LOB’s for Equities, Credit, Mortgage, Issuer Risk, Rates and Currencies, CCAR, Fed Reporting in Microstrategy, interacted with warehouse and production teams.
• Built innovative solutions for complex Value at Risk calculations on a multi - billion row tables in a high performance Netezza environment. Automation of report jobs using autosys and Command Manager for Daily Reporting to Risk Managers
• Development and support of approx 50,000 MSTR reports currently and 200 users Portal deployment of reports using SDK customization
• Enhancement of complex queries from 10 minutes to few seconds using Netezza and MSTR best practices.
• SSIS Cubes conversion and implementation in Microstrategy with drag and drop reporting.
• Interactive Dashboards, Visual Insight analysis using cubes and MDX reports
• Upgraded all reports/processes in Microstrategy from version 8.x to 9.x to 10.x
• Work Management and support of Microstrategy Administration and Development activities

Environment: MicroStrategy 10.x, 9.4.1, Microstrategy Administrator, Microstrategy Architect, Netezza, SSRS, UNIX

Confidential

Microstrategy Architect

Responsibilities:

• Administration and Development - Created customized enterprise manager reports for metadata cleanup, narrowcast subscriptions, personalization’s cleanup
• Advanced User modification implementation using Command Manager scripting.
• Architecture of 3 Confidential projects per requirements, dashboard development
• Narrowcast implementation of Confidential projects for user email subscriptions
• Guide junior MSTR developers for best practices in project and administrative work.

Environment: MicroStrategy 9.0.1, Microstrategy Administrator, Microstrategy Architect, SQL Server, Teradata, UNIX

Confidential

Manager

Responsibilities:

• Administration and Development - Command Manager Script for provisioning users, use of SDK code - creation, modification, updates user, user groups, and security filters.
• Implementation of security filters to existing SAP users using roles.
• Implementation of security filters to existing Reports and Dashboards, Testing.
• MSTR Migration of code from DEV to QA to PROD.

Environment: MicroStrategy 9.0.1, Microstrategy Administrator, Microstrategy Architect, Teradata, Windows XP

Confidential, New Jersey

Microstrategy Architect

Responsibilities:

• Design, development of metadata for Dashboards, Reports by conversion of SSRS Reports into Microstrategy Dashboards and Reports.
• Design of Db tables for Microstrategy schema objects.
• Architect - Design and development of 30 Reports (includes Dynamic dashboards and Reports) using V9.0.1
• Testing of Dashboards using Panelstacks, graphs, dynamic dashboard functionality implementation and Reports as per Requirements.
• Administration - Migration of Microstrategy project from DEV to QA to PRODUCTION
• Production support of MSTR Projects and user support for MSTR Reports and Narrowcast issues.
• Administration - Installation of MSTR 9.0.1 on UNIX environment in a clustered environment.

Environment: MicroStrategy 9.0.1, MicroStrategy NarrowCast 9.0.1, Microstrategy Administrator, Microstrategy Integrity Manager, Microstrategy Architect, SQL Server, UNIX

Confidential, New York

Microstrategy Architect/Sr. Developer

Responsibilities:

• 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.
• Team Lead Role - Team supervision and performance management, monitoring and advising on operational costs, Implementing management policies and directives. Working with user interface development, DBAs and Support team. Mentoring junior microstrategy developers and full-time manager using market standards and best practices in order to provide end product.
• 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, and 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

Confidential, New Jersey

Microstrategy Architect

Responsibilities:

• 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.
• Cognos reports and cubes migration to Microstrategy Desk Reporting
• 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, COGNOS, Oracle 9i, Informatica, Windows 2000

Confidential, New Jersey

Lead Microstrategy Architect

Responsibilities:

• 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.
• Team Lead tasks - Supervised two junior offshore Microstrategy developers and one onsite developer to deliver end client product using best practices.
• 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

Confidential, NJ

Sr. Microstrategy Developer

Responsibilities:

• 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

Confidential, New York City

Microstrategy Architect/ Administrator

Responsibilities:

• MicroStrategy reporting for Phoenix Asia and Phoenix Portal projects ( Confidential ). 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.
• Team Lead tasks - Supervised two junior onsite Microstrategy developers. Supervised Microstrategy offshore developers in India. Was a liaison between offshore team and onshore team for Microstrategy product delivery to the client.
• Deployed and managed 3 Projects to PRODUCTION.
• Design of MicroStrategy Project from scratch and designed and developed schema and public objects.
• Learning of PhoeniX Confidential 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

Confidential, NYC

Microstrategy Architect/ Administrator

Responsibilities:

• 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

Confidential, NYC

Microstrategy Administrator/ Sr. Microstrategy Developer

Responsibilities:

• 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 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

Confidential, NJ

Microstrategy Administrator/ Sr. Microstrategy Developer

Responsibilities:

• 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

Confidential, NJ

Microstrategy Administrator/ Sr. Microstrategy Developer

Responsibilities:

• 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

Confidential, CA

MicroStrategy Administrator/ Sr. Microstrategy Developer

Responsibilities:

• 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

Confidential, CA

Sr. Web Developer

Responsibilities:

• 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

Confidential, CA

Sr. Web Developer

Responsibilities:

• 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

Confidential, CA

Sr. Consultant

Responsibilities:

• Confidential Tracking System is a web based testing application.
• The Confidential Tracking System ( Confidential -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

Confidential

Programmer Analyst

Responsibilities:

• 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

Confidential

Consultant

Responsibilities:

• 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

Confidential

Consultant

Responsibilities:

• 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

Confidential

Responsibilities:

• 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