Project Sql Server

Indu Bettada

** ********* *****

McMurray PA **317

Cell No: 724-***-****

Email:********@*****.***

Summary Over 13 years of experience in the IT industry (including 11 years in financial industry), working as a highly motivated business intelligence professional as a developer/technical consultant or technical lead on various projects from building OLAP cubes in SAP Business Planning and Consolidation, Business Objects/Crystal Report XI, Hyperion Essbase, Microsoft SSIS/SSAS/SSRS along with MDX queries and management level report analysis using all the above technology along with working on server/client-side web technologies, database design/interface, development and implementation, component-based system architecture, analyzing/tuning performance of web applications.

Technologies that I have been working over the years and are Visual Basic, C#.NET 1.1, 2.0, VB.NET, ASP.NET, OLE, COM/DCOM/COM+, VB, ASP, IIS3.0/4.0/5.0, HTML, DHTML, Front Page, XML, XSL, CSS, VBScript, JavaScript, SQL Server 6.5/7.0/2000/2005/2008.Key player in the design and coding of web based financial applications with sound knowledge of the database. Good team player, great reviews from peers, excellent communication skills and an extremely quick learner.

Education

Bachelor’s in Engineering (Electronics)

Trained in

Business Objects, Advanced C#, XML Web Services by “Learning Tree”

Hyperion Essbase by “MTG”

Business Planning and Consolidation by “SAP”

SQL Server Analysis Services by “Hitachi Consulting”

Performance Point by “Microsoft Consultants”

ASP.NET 2.0 by “Develop Mentor”

Technical Skills:

• Business Intelligence Tools – Business Planning and Consolidation, SQL Server Integrated Services(SSIS) ,SQL Server Analysis Services(SSAS), Hyperion Essbase, MDX Queries

• Reporting Tools - Business Objects 6.5/Crystal Reports(Including Crystal Enterprise), MS SQL Server Reporting Services

• MS-SqlServer 2005/2000/7.0 (writing stored procedures, design, performance tuning, indexing etc)

• ASP.NET(1.0,20)/ASP, C#, VB.NET

• Visual Studio 2005/2003/ Visual Interdev .NET(6.0)

• Visual Basic 6.0/5.0

• DHTML/HTML, Scripting Languages(Vbscript, Jscript, JavaScript), XML/XSL/XSLT, COM/DCOM (middle tier objects)

• Platforms - Windows XP/2003/2000/NT server Platforms.

• Packages / Tools –Team Foundation Server (Version Control)/ Visual SourceSafe.

Functional:

Over 11 years in the Banking industry in New York ranging from Chase Manhattan, Citigroup, Morgan Stanley, Prudential Financial, Credit Suisse and at present as a Sr. Analyst at Computer Science Corporation for Westinghouse Electric in Pittsburgh, PA.

Managed and mentored all SAP BPC projects in all the environments along with data movement from old Essbase cubes into SAP BPC.

Ongoing support, design and development of new OLAP cubes based on Business Warehouse extracts and consolidating actual data and preparing scenarios for Planning and Budgeting purpose

Worked as assistant vice president (technology) in Private Banking Division, Investment Banking Division and Private Equity (Alternative Capital) divisions over four bank

Experience with full software life cycle, from gathering requirements, design, code and delivery to go-live support.

Mentored IT team in India/Singapore while working hands on the same projects/initiatives

Lead member in the team provide technical training and supervise delivery of the project.

Design and code implementations based on Object oriented methodology.

Created and Maintained cubes in Hyperion Essbase. Also, created reports in Excel off the

Essbase cubes

Worked with SSIS to develop ETL packages to load data from Relational Databases to a central data warehouse

Worked and developed SSAS cubes from Data Mart. Created reports

Used MDX queries extensively to build the reports in Reporting Services under the guidance of

Microsoft Field Engineers

Created a Universe in Business Objects and created reports to help analyse Security Valuations for Fund Accountants. The reports were web based.

Worked as project/technical lead in managing small projects.

Communicating & coordinating with business users, team of developers and the managers.

Use of SDLC & SDLC+ standards within the applications.

Always kept up to date with technology by going to trainings in renowned Technical Institutes

EXPERIENCE:

Computer Science Corporation (For Westinghouse Nuclear Energy (Toshiba)) Sep 2008 Till date

Senior Analyst

• Westinghouse embarked on this project to globally unify and upgrade the SAP R3 System to SAP ECC 6.0.

• The new SAP ECC system brought in the Business Warehouse which would in turn feed into BPC

• Managed and worked on the redesign and development of Planning and Consolidation Applications to move all data from Hyperion Essbase to SAP Business Planning & Consolidation (BPC) to a successful completion

• Mentored and coordinated upgrade efforts from an older version of BPC to a newer much different one. The team included SAP members as well.

• Data Analysis and a all round support of the application as well as data inconsistencies as well as new development to accommodate consolidation rule changes or incorporating new elimination rules were quite challenging sometimes as it is an OLAP cube and not an open ended system which can take changes more easily.

• BPC uses Excel as a reporting tool and is based on SSAS cubes. SQL server holds the FACT tables and SSIS packages with wrappers around them need to be maintained regularly.

• Worked to develop a few custom SSIS packages to run from BPC and also monitor the already existing custom packages that are available.

• I was able to manage the whole project along with a couple of remote resources very effectively baring time differences.

• Worked closely with the business users to integrate the custom requirements into the new BPC system

• Worked with Westinghouse Financial department to perform and analyze monthly and quarter end closings

• Worked with various products like Hyperion Financial Management and Financial Data Management all from the Oracle Suite of products

• Involved in fine tuning Hyperion Financial Management to quickly and effectively merge data and produce extracts needed for further analysis.

• Developed and maintained reports in Hyperion Enterprise Reporting

• Interacted with Westinghouse users on regular basis

• Writing and Maintaining complicated Calc Scripts in Essbase

• Involved in working on evaluating systems and provide a strategy for system wellness with backup and disaster recovery strategies.

Some highlights of the above role is mentioned below-

Extensive data analysis and reporting along with immense user interaction and continuous support along with were highlights of this project. It was also very interesting and a learning experience to work with a new product called BPC. We were trained by SAP to work on SAP BPC for Westinghouse.

Working with Hyperion Essbase and the Financial Management product was very involved in itself. Performing the close process and churning out the desired reports every month was one of the highlights of the project.

Credit Suisse, NYC, NY July 2004 till Aug 2008

Senior Programmer Analyst

Asst. Vice President (Alternative Capital, IT)

• Took part in Enterprise level design across Alternative Capital Division

• Responsible for requirements, analysis, design and development of web based systems developed to help the business run more efficiently and provide better accountability and reporting ability. Responsibilities include analyzing the performance of hardware and software interfaces and identifying alternatives for optimizing the usage of computer resources. Participating in architecting, designing, coding, testing, debugging, configuring and documenting specifications, and providing emergency response as needed to system failures

• Interacted with Bankers/ business users on regular basis

• Taking up the lead role by being responsible to setting up .NET framework for all applications in the team and guiding successful migration of existing ASP applications to .NET. Also setup the application to use Crystal Enterprise for reporting and exporting reports to PDF format.

• Writing and managing complicated Quarter end reporting Algorithms

• Code UI with ASPX/ASP/XML/XSLT transformations, COM components in the middle tier with C# and backend with stored procedures and triggers in SQL Server. Other database activities include writing and scheduling DTS packages and optimizing application procedures.

• Develop .NET web/ windows services on the application server to process time and resource intensive user requests and send notifications via email upon completion.

• Integrate and develop .NET components and .NET Web Services.

Developed SSIS packages for the ETL from the relational database to the data warehouse

• created a cube off the data mart for reporting purposes and also to provide drill down ability to the users

• Worked Hands on with Hyperion Essbase to provide better data visibility to the business users by creating an application outline in Essbase and reports in Excel. Users could drill down to the lowest levels of any hierarchical expense data.

• Audit existing systems and provide a strategy for system wellness with backup and disaster recovery strategies.

• Work with users and provide solutions and support to clients.

• Held presentations of the new features and enhancements of SQL 2005 over SQL 2000 among the group of developers.

Some significant projects in the above role is mentioned below-

• Firm Reporting Layer

This is a suite of small applications which churn out reports to enable the users during the month end and quarter end process. The basis of the Reporting Layer is a Transactional Module where data is entered by the users pertaining to Fund Activities and movements. The other entities involved along with Fund are the Deal, Investor/Partnership, Investment, and Security. The application also maintains the Organization Structure and the Reporting Structure to make Profit and Loss calculations at different levels of the Structure on the basis of the Firm to the Fund investments or vice versa. Few of the calculation engines that make up the Reporting Engine are:

Non-Mark: To calculate the market value of investments not marked for market i.e. private.

Lead Sheet: To calculate the market value of Public Securities pertaining to each deal involved of every fund in the system.

Capital Statements: Firm Statements in the form of reports which show the Realized/Unrealized and the OID (Original Issuer Discounts) if any with respect to a certain Fund and investor partnership

Fin46 Rule: This is a normal rule of consolidation when varied interests take part in an investment. It is an Accounting Rule and the rules which were defined by the users.

General Ledger: The General Ledger expense data is imported into the FRL system using a windows service and the data finally appears on Financial Reports. This is also loaded into Essbase cubes to do Trend Analysis.

Financial Packages: These are a book of reports which are used to close the month end processes. The package contains sections for Revenue, Expenses, Balance Sheet and Headcount. Impacts on bonus structure, employee compensation, departmental budgets and expense allocation are also parts of the packages.

• Deal System & Security Valuation

This system is used by the users to enter share cost and valuation data for the deal entity. The information later flows into the Firm Reporting Layer

• Headcount

This is an HR transactional system where we track the numbers of headcounts per division and the number of headcounts in the pipeline to be hired. This data also is made use of in the Financial Packages.

• Fincast(Budgeting & Forecasting)

This system is in the process of rewrite as it is one of the most complicated systems. The existing system has ways to calculate various Forecasting models according to changing business speculations and standards. The system is being redesigned to use Tools like ‘Performance Point’ to run the model calculations.

Prudential Financial, Newark, NJ June 2003 Till July 2004

FDCS (Financial Data Collection System)

I was working, as a Senior VB6.0 (front end) and Sybase (database) Developer and was extensively involved in

• Creating the Systems Specifications and Detailed Design Documents for applying security to all the above mentioned applications

• Designing and develop VB forms, develop classes (COM) to be used in dlls to incorporate the business logic

• Created a prototype in VB.net of a part of OLQT, and used ADO. NET to access the Sybase database

• Coding of Stored Procedures using DBArtisan Editor.

Morgan Stanley Dean Witter, NYC, NY February 2002 Till May 2003

Morgan Stanley – Time Tracker Systems

Time Tracker Systems are used to manage the time of employees and also the hours worked by them. There are at present IBD Optime, CS Optime and Repro Optime systems basically handling the same functionality but also diversifying into different functional aspects of the departments, which use them. All the Optimes are divided into two parts the Administrator software and the Clocking Software.

CS Optime (Admin) is basically used by the Creative Services and is a massive application having modules like Employee Management, Workflow Management, and Billing. The Employee Management deals with every aspect of an employee joining the department through Compliance, Training and Scheduling to different jobs. Workflow Management deals with the jobs, projects that the operators work on. The Bankers bring in the requests for the jobs, which are basically Publishing and Studio jobs. The Billing Module as the name suggests deals with the billing of each and every job. The jobs are invoiced against each cost centre that the request comes in from. The Clocking Software allows the user to Clock in/out for the day, take a break and print timesheets for a week. Data and Business Rules porting from legacy MS-Access databases to new Sybase data stores was an integral part of this venture.

IBD Optime is a similar to the above, but it only specializes in the Management of Employees. It has a different interface and is used by the Investment Banking Division of the Bank.

Repro Optime has an Employee Management Module, Inventory Management and the Billing Module. The software is used to track the inventory on different floors like Paper, Faxes etc. It keeps track of jobs like Printing, Faxing etc. and also the costs involved in each process.

Trade Tracking is a system meant to provide effective tracking of Bonds details for Fixed Income Bond traders. The application provides dynamic search and sort functionality. Other validations and functions were needed for the reports that were generated out of the application. Most of the reporting was done using Excel. Application gets trade data periodically from Fixed Income Division, mainframe database and then stores the data locally in a Sybase database and allows traders to manipulate various Bond related information through an intuitive web interface.

Remote Submission is an intranet web application developed for investment banking division (IBD) employees. This application accepts various printing jobs of large size documents like presentation documents, word documents and images. This application targets users located in America, Europe and Asia. Application provides highly interactive web GUI to input data and upload large size files, which can be submitted to the printing department

I was working, as a Senior VB/VBA Developer and was extensively involved in

• Interaction with Investment Bankers/Traders/Clients for requirement gathering, analyzing requirements and developing various technical documents like Requirements Specifications, Technical Architectural documents.

• Created the Systems Specifications and Detailed Design Documents

• Designing and develop VB and ASP pages for various application modules including Remote Order Submission

• Designing and Maintaining VBA forms and the application as such in MS Access (7.0) and MS Access2002.

• Creating reports in MS Excel using Excel VBA and also using VB to create reports in Excel.

• Designing and developing modules, querydefs and stored procedures for migration of data from legacy MS-Access and Excel Sheets.

• Designing and developing generic database handler objects to reuse stored procedures and other database objects for reporting/data mining using Seagate Enterprise and Crystal Reports 8.5

• Coding of Stored Procedures using DBArtisan Editor.

• Creating Reports using Crystal Reports and MS Access (7.0) and MS Access2002

• Used Visual Source Safe to help in version control and to keep backups on a weekly basis

• Maintenance of the applications after rollout.

Citibank, LI City, NY April 2001 Till January 2002

EAB Conversion

European American Bank merged with Citibank, the client a conversion process had to be undertaken to convert all EAB customers to Citibank i.e. changing the profiles of customers to match Citibank standards. Two parts to the project were

a) Report Generation:

• Analyzing Data by downloading files from the mainframe and then creating High level Management reports using MS Access 7.0. The reports were basically to give an idea as to how the conversion was going on and as to how many programs had been converted. Conversion was to take place in stages but the final production conversion would take place in just 3 days time.

b) Script Input Modification Utility:

• Involved in creating an application in Visual Basic (6.0) to allow users to maintain information regarding testing of systems as Citibank has merged with EAB.The project involved writing various COM Modules. Using these system testers could generate and store scripts for later use. Thus enabling them to standardise testing as per the Banks standards. This application existed in a very basic form in MS Access(7.0).

• The database used was SQL Server 2000/(7.0). Involved in writing a number of Stored Procedures and triggers.

IPB Conversion:

International Private Bank, which was a part of the Citicorp group but had a different structure of its own, was merged with Citibank. The client a conversion process had to be undertaken to convert all IPB customers to Citibank i.e. changing the profiles of customers to match Citibank standards. This project also involved analyzing data by downloading files from the mainframe and then creating High-level Management reports using MS Access 7.0. Some reports were also created using MS Excel. The reports were basically to give an idea as to how the conversion was going on and as to how many programs had been converted. This involved in creating an automated process to create reports. Downloading the files from the mainframe was manual.

Chase Manhattan, NYC, NY September 1999 to March 2001

a) Chase Messenger: (Automated Push)

This Application is used for automatically pushing the files (Reports) from the database and FTP Servers onto the User’s machines without any user interaction.

• Involved in writing the COM Module for downloading reports from the FTP Server automatically and also Check some File System Checking on the user’s machine using the WIN INET API calls in VB 6.0

• Involved in creating Active X controls to read the file system on the users desktop.

• Design system architecture

• Involved in writing the ASP pages, this makes some server calls to display on the user’s Machine. And used Web Control as medium of Interface.

• Used the Wise Package Studio to create an application package for distribution of the application to different desktops.

b) GISNET: (Internet/Intranet Website)

Utilized Client / Server, Internet/Intranet & Database skills to design and develop Chase’s secured Global Custodial Services Internet/Intranet Web site. This site is designed using ASP with SQL Server(6.5) in Visual Interdev Environment to provide corporate clients with information crucial to their investment strategy (i.e. Late breaking News flashes, Taxation & Investment regulations, Accounting Reports, Portfolio performance data).

This site is Secured Server (SSL) site. The Staging component and the User Maintenance Component were created in VB (5.0, 6.0) is used to stage the reports to the Database and to Maintain user profiles for the Web site and stored in SQL Server(6.5).

• Design and Development of Web Pages, html as well as asp, for the Web site.

• Maintenance of website on a 24/7 hr basis for clients to be able to contact us in case of an emergency. As clients were from all over the world and their working hours ere generally at 12 hr difference from here.

• Administer the IIS Web Server.

• Interaction with the users for the Requirements

ARC Systems, NJ April 1998 to September 1999

AT&T WorldNet Service

The project involves working with the AT&T WorldNet Service database and creating reports for various departments of AT&T WorldNet Service from the WorldNet database in Oracle 7.1 on Unix platform depending on the requirements.

The project also involves working with a messaging system using Visual Basic (6.0), MS Access (7.0) as the database and tools like Ex-Life, Ex-Hook and Rtv-Reco of the latest versions. The MabryMail, active -X control is used to send mails. The system is automated and is used to send mails on requirement basis to AT&T WorldNet Customers at the rate of 50,000 to 100,000 per day or even more. Initially MSDOS-batch files and MS Access macros (VBA) were used to automate the system but later, converted to a Visual Basic (6.0) application. The system used Class Objects extensively. Involved in preparing the system specification, design document, coding and testing the system.

Involved in creating Active Server Pages, which interact with MS Access (7.0) and Oracle (7.1) databases. The Active Sever Pages were developed using VB Script and Java Script. The Active server pages were compiled using IIS 4.0 on Windows NT server. Involved in creating an application as a visual interface for the IVR system of the client company, with MS Access (7.0) as backend. This was an in-house project. This project also involved creating reports using Crystal Reports (4.6). This project made use of MTS to perform various transactions.

Sonata, Bangalore, India September 1997 to April 1998

UNIWOP (for SystemHaus KONERTZ GmbH, Germany)

UNIWOP (Universelle Wohnung Programme) project involved re-engineering the product UNIWOP from Business Basic to Visual Basic 5.0 & MS Access. There is extensive usage of classes for Printing, Display, and Database Access.

As a Team Member in a team of 20 was involved in the preparation of System Specification, Detailed Design and Development of the Construction Book module.

Human Base India, Bangalore, India January 1997 to April 1998

Car Management System (for Royal Nippon, Japan)

Royal Nippon is a Car Exporting Company based in Nagoya, Japan it Exports used cars to New Zealand, Peru, Chile, India, Bangladesh, Pakistan, Sri Lanka. It purchases cars in auction held at different places in Japan and whenever a purchase order is received from the customers from any of the above-mentioned countries all the cars are registered and are exported. The system includes all the above processes and maintains Stock, Party Ledger, Auction Details, Dealers Information, Customer Details, Customer Visit Details and generates various reports like Sales Report, Purchase report, Customer Visit report, Reminders to customers and so on.

Information Machinery Control System (for Sharp Inc, Japan)

This software developed searches the selected Company, Building and Floor for the exact location of the required system on the corresponding floor layout and displays the individual system information. This project also had one report to display the machine placed in a company, in a particular building . All individual information is entered directly in the Access tables created by the user.

Human Base India Management System

This was an in house project developed for the company to maintain employee history and data and also to maintain the information of the company like correspondence, statistics etc., the whole project has been divided into three modules – Employee, Project Management, Accounts

Duskin Event Rent System

This software is developed for Duskin Inc., to automate the rental of goods. It keeps track of the goods lent to the customers. Different modules that were incorporated in the system were Master Maintenance, Search, Entry

Duskin Health Rent System

This software is developed for Duskin Health Rental Inc., to automate the hiring and rental of hospital goods and services to its customers. Different modules that were incorporated in this system were Goods and Vehicle Management, Customer Management, Worker Management.

Involved in development, integration and testing. Other responsibilities included maintaining GUI standards, Test Scripts for each form. Testing included GUI test, standard checklist, Japanese script conversion test, interface test script, functionality test script, and DB test script.

Contact this candidate