## BIO
SANDIPAN GHOSH KEY SKILLS: ? Experienced in team managing and business development ? Microsoft Certified Technology Specialist for SQL Server™ 2005 - Implementation and Maintenance ? Worked on SSIS, SSRS, SSAS and SQL server 2005 and Business Object ? Excellent knowledge in RDBMS and MultidimentionDatabase and OLAP ? Excellent knowledge of Coldfusion application server ? Have Developed a numbers of Business specific rules for Reporting using SQL ? Developed, Install, Configure and managed System testing Environment ? Installing, configuring and Managing SQL Server on Live sites and in-house Server ? And Make sure SQL server related Services are running fine in Auto Start mode ? Worked on DTS Packages ? Creating and scheduling SQL Job ? Providing Recorded Training for New employees TECHNICAL EXPERTISE: Software Languages: Primary skills: MS SQL Server 2000, 2005, DTS, T-SQL, Stored Procedure, SSIS, SSRS, SSAS Secondary skills: Oracle 9i Application Developer, XML, C, C++, ORACLE 9i (SQL,PL/SQL), Oracle 10g, Report, forms, Business Object Operating System: DOS, Windows 98, NT, XP and Server, Linux Others: Microsoft Office XP EMPLOYMENT HISTORY : 1) Presently I am working as a Senior Software Engineer, at SLK Software Services Pvt. Ltd, NEW BEL Road, SanjayNagar Bangalore –94, Karnataka Project Name: mTrack system Client: M&T Bank Team Size: 10 Description: mTrack is an incentive and award system for M&T bank. This system used database engine as MS SQL Server (2005 & 2000) and application server as Coldfusion. The main purpose of this system was to calculate the incentive amount need to pay and the awards need to give to the bank employee. Now the system is waiting for major technology and functionality up gradation. Currently mTrack support only Retail Banking and Telephone Banking. We are redesigning the system to support all other banking system for M&T Bank. Responsibilities: ? Responsible for planning, processing and performing all jobs in an efficient manner with no assistance from the supervisor ? Managening the team of software engineers through the full development life-cycle ? Working closely with business team of M&T bank ? Design and develop programming systems making specific determinations about system performance. ? Conduct system analysis and development, with the changing technologies ? Analyze, design, coordinate and supervise the development of software systems ? Analyze system specifications and translate system requirements to task specifications for junior programmers. ? Responsible for analysis of current programs including performance, diagnosis and troubleshooting of problem programs, and designing solutions to problematic programming ? Responsible for development of new programs, analyzes current programs and processes, and making recommendations which yield a more cost effective product ? Writes, edits, and debugs existing program for more efficient output ? Tests new programs to ensure that logic and syntax are correct, and that program results are accurate; assists lower-level programmers with programming assignments ? Assist documentations of code consistently throughout the development process by listing a description of the program, special instructions, and any changes made in database tables on procedural, modular in database level ? Making presentations to customer or client audiences or professional peers ? Provide general administrative support to the organization/business specially DBA related task ? Research and recommend software tools to management ? Provide assistance to testers and support personnel as needed to determine system problems. Achievements: ? Installed major business rules changes for year 2008 and 2009 ? Installed provident fund baking system ? Installed archive process for databse to speed up the system ? Introduced new coding stander for programming ? Introduced system testing and integration testing phase 2) 15 months associate as a Software Engineer with NOUS INFOSYSTEM Koramangala, Bangalore -34 Designation: Software Engineer Duration: October 2006 to March 2008 Project Name: Pure Safety Data Load Client: Pure Safety Team Size: 8 Description: Pure safety is changing its data load model to universal data load model using XML format. Instead of sending text, csv or other file format, they will send the entire file format as XML. This XML will have the table definition and the column mapping. The ETL (SSIS) has to read the XML file and create the table dynamically, the load the data as per the mapping and do the business verification. If the verification error cross the define error ignorance value, it must stop the process and will wait for user input. Project Name: WRAP LSS Replacement Data Mart Client: ANZ bank Software Development services Team Size: 15 Description: Lending Statistics Australian Prudential Regulation Authority (APRA) reports are currently generated in the Global Information Warehouse (GIW). The existing system has limitations. The business requirement is to merge and rewrite the existing Lending Statistics system and incorporate that into the Web-Enabled Reporting to APRA Project (WRAP) reporting environment. This will provide the ability to drill down on the reported items and respond within specified timeframes to APRA. All the data running on Mainframe system and the data will extract from Mainframe in to GIW file share. We have use Star Schema in this Data Mart, where TblFormLSSAPRADataDetail is fact table and all the data, reference and rule tables are dimensions tables. All the input files are colon separated CSV file. There are three type of input file. 1. Parameter Rules (only 1 file) 2. Reference Files (11 files) 3. Data Files a. CAP Data files (DDA, ILS and OLL type. All are Monthly & Weekly) b. MOS Data file (All are Monthly & Weekly) c. CACHE Data file (DDA and LA type. All are monthly & weekly) d. CBIG Data file (Only Monthly) e. Origin Data file (Only Monthly) All the
## Area of Expertise
MS SQL Server 2000, 2005, DTS, T-SQL, Stored Procedure, SSIS, SSRS, SSAS, Oracle 9i Application Developer, XML, C, C++, ORACLE 9i (SQL,PL/SQL), Oracle 10g, Report, forms, Business Object, DOS, Windows 98, NT, XP and Server, Linux, Microsoft Office XP
