Data Administrator Resume
STRENGTHS
- Total 18 years of experience in IT Industry out of which last 15 years is US IT Experience.
- Worked with relational databases like Oracle, Sybase, MS-SQL Server, IBM DB2 and Informix.
- Proficient with System Development methodologies like System Development Life Cycle (SDLC).
- Possess good domain knowledge of commercial applications such as Inventory, Banking & Finance (Indicative, Corporate Actions, Pricing, and Mutual Funds), Insurance, Education, Sales, Hotel industry, Oil and gas industry, Payroll, Financial Accounting, Re-Insurance, Pharmaceutical, Syndicate and Licensing
- Proficient in Database Object programming like PL/SQL,T-SQL Stored Procedures, Functions, Triggers, Packages, Cursors, Tables, Constraints, and Rules.
- Excellent presentation, communication, analytical, organizational and interpersonal skills. Good team player.
TECHNICAL SKILLS
Languages: Pascal, Cobol 74/85, C, Assembly (8086/8088), SQL, PL/SQ, T-SQL.
RDBMS: Oracle 6.0,7.3, 8.0, 8i, 9.i, Sybase, MS-SQL Server, IBM DB2, Informix, SQL anywhere.
WEB: C# .net 2.0, 3.5, 4.0 using Visual Studio 2005, 2008 & 2010, ASP.net, html, JavaScript, Web PB
GUI: PowerBuilder 3.0a, 4.0, 5.0, 6.0, 6.5, 7.02, 8.0, 9.0, 11.0, 12.5 with Jaguar, EA Server.
OS: Sun Solaris, UNIX on U6000, Novel, DOS, Windows 95, 98, 2000, Windows NT, Windows XP, 7.
Case Tools: Riverton's How 3.0 for Distributed Computing, S - Designer, Erwin, PowerDesigner.
Quality: ISO 9001 Quality Control Methodologies, CMM Level 2, SOX Compliance
Others: Version controls such as Clear Case, SourceSafe and PVCS, Win-Install, MS-Access.
RECENT EMPLOYMENT HISTORY
Company: Confidential
Technology: C# with .net 2.0, 3.5, 4.0 ASP.net, ADO.net, XML, Web Services, HTML, JavaScript using Visual Studio 2005, 2008 & 2010 with MS-SQL Server 2008 & Sybase.
Duration: May 2010 Till Date.
- Support & Enhance in-house application E-Inquiry written in C# .net 3.5, web services
- Roles and Responsibilities- Fulltime Senior Developer - Design, Coding & Development, Code Review, Unit Testing, Client Support, Estimation, Handling of Production Issues / Investigations.
Company: Confidential
Environment: C# with .net environment 3.5 using Visual Studio 2008, ASP.net with Sybase, ADO.net, XML, HTML
Duration: Sept 2008 till May 2010.
- Reed Business Information has a custom-built order management and invoicing system called Cahners Customer Information System (CCIS). CCIS application was developed to support the Customer Service operation and information needs of the internal (Publishers, Salespeople, etc.) and external (Advertisers, Agencies) customers in order to attain superior customer service. The system is a core business application of Reed Business handling contracts, orders, production and related invoicing information.
- Worked on Inventory mgmt. and also worked on CRM Application using ASP.net.
- Roles and Responsibilities -Mid Level .net Developer fulltime- Design, Development and Unit Testing.
Company: Confidential, Warren, NJ.
Environment: C# .net environment 2.0, Visual Studio 2005, ADO.net, XML, HTML, JavaScript, SQL Server 2005.
Duration: Sept 2007 till Sept 2008.
- The Project Tracking System exists as a tool to provide senior management with standard project reporting around the glove and as the basis for Technology's allocations to Citi's clients. PTS provides a simple platform for program and project managers to conduct their program, project and SDLC activities including creating initiatives, programs, projects and forecasting project work etc. PTS is also used by Senior Mangers and Financial Analysts to monitor the progress of these IT projects as well as the actual spending versus budget/forecast for each Division.
- My assignment was to code & enhance PTS.
- Roles and Responsibilities -Junior .net Developer Consultant- Design, Coding & Development and Unit Testing.
PROJECTS as Senior PowerBuilder Consultant - June 1997 till Aug 2007.
Confidential Of NY and NJ, New York Mid-Town, NY - The Employee Scheduling Program (ESP) is an application used at JFK, LaGuardia and the Newark airports for planning employees work schedules in the Aviations area. The ESP system reduces the time and paperwork required to plan and schedule months in advance, and to quickly retrieve past schedules and current status such as number of overtime or vacation days taken. My main responsibility was to do entire analysis of existing ESP System going thru' existing code and communicating with users and create Analysis documents. It involved identifying various problems the current ESP system is having and based on the knowledge of the system recommend a new solution to Port Authority Technical Service Department.
Confidential, New York Mid-Town, NY-- Confidential is leading information and Entertainment Company that syndicates and licenses popular properties worldwide. It is one of the largest licensing agencies in the world, representing brands and creative content in the development and management of licensed merchandise and promotional programs. Financial Applications deals with the contracts with United Media and their clients about these comic strips, their subscriptions and commission to the Talent. I worked on these financial applications.
Confidential subsidiary, Jersey City, NJ - Global Equity Trading System is used to trade a foreign security on the international market. It maintains the securities/issues that are traded internationally for Confidential & account information. It has three main modules Portfolio Management, Trading Desk and Trading support. Various trade orders are inputted thru' Portfolio Management with variation of one security and many accounts or one account, many securities. Once the order is released from Portfolio management, it shows on trading desk. International Trading team then selects the broker and FX Rate and executes the trade vie broker. Order then appears on Trading Support which settles the trade on settlement date. The money transaction between Broker, US Trust and Client takes place at settlement. My major assignment was to work extensively on this project.
Confidential, New York Downtown - The Security Master Database (SMDB) provides a comprehensive repository of information regarding all existing security instruments, sub-instruments and legal entities. You can create new pricing subscriptions at the sub-instrument level, create new industry and instrument classifications in addition to the default BNY classification, review foreign exchange rates and create reports detailing specific information to suit your requirements. It has three major modules: Security Instrument (Indicative), Corporate Actions and Pricing. I was involved into coding and enhancement of all 3 modules.
Confidential, Ethicon - Summerville, NJ - I worked on Web Totem Pole which was developed under WebPB where sales reports were viewed by Regional Managers, Division Managers and Sales Reps. Developed Oracle stored procedures & triggers for Ethicon Pricing Maintenance System. Converted Affiliate Pricing System project from PowerBuilder 4.0 to PowerBuilder 6.5.Also worked on Cognos Reports.
Confidential, reinsurance Firm - Stamford, CT - General Colonial Re is re-insurance firm. They have in-house application called Eddie And a web based app called Fac-World to support their daily business. I worked on new application ‘Eddie To Fac-World Mapping App, a batch application, which basically provides whatever data the web Based application Fac-World needs from Eddie. This includes data such as released certificates and endorsements, released renewal clearance, renewal quote or binder and renewal letters for expiring certificates. Bought this data from Eddie, mapped it into Fac-World specification and transferred into Xml format for Fac-World to read it.
Confidential, Austin, TX - Job Corps is the nation\'s largest & most comprehensive residential education and job training program for at-risk youth, ages 16 through 24. It is responsible for education, employment, training, accommodation & wages during education for those students who could not offered admissions to regular schools & universities. I worked on application CIS which was fully distributed app using PFC at client Side, Open frame of Riverton's How & Jaguar EA Server at server side, supporting its 120 centers throughout U.S.
Confidential, Charlotte, NC - First Union Home Equity Bank had 7 major applications running on Sql Server 6.5 to support its daily operations. The bank decided to go for oracle as its backend. Main responsibility was to get all these service modules up and running smoothly against oracle backend. Converted Stored Procedures, Triggers, embedded SQL queries in Oracle required for the conversion of service modules.
Confidential, an oil and gas company, Fort worth, TX - Burlington Resources is oil and Gas Company which leases/buys a piece of land for oil production. DOI is a division order information system, which tracks all the activities of oil land its owners, its leases, oil wells, & the profit from the oil, % to distribute among the oil well owners. Actively involved in the module of well and landowners as a enhancement, coding, integration, testing. I was involved in SQL Performance tuning. Optimized & built SQL queries and wrote PL/SQL stored procedures, triggers, rules and packages.
Confidential, Las Colinas, TX. - The Associates is into financing vehicles, consumer (Ford motors financing) home loans etc. Its major area is Commercial (financing/leasing of transportation, heavy-duty trucks & construction equipment). Was responsible for design, coding, testing, implementation of major separate module called \'batch\' which runs every night. It uses extensively PFC.
Confidential, Steel Manufacturing Company at Mansfield, TX - Actively involved in the module inventory, pricing and work orders. Designed and implemented database triggers & procedures for inventory. Inventory keeps track of raw material in terms of bundles, cut steel that is used in work-in-process and the finished steel parts that are shipped to the customer partly or fully. Pricing is price for different type of steel material used in prod determined on steel grade.
Confidential, Newport Beach, CA - Power Agent is a full-featured shareholder accounting product, which provides access to current & historical shareholder information. Actively involved in designing and developing of module fund/serve where Mutual Fund Companies download their tread transactions (regular orders, as-of orders etc.) & send back the confirmations, rejections or settlements back to firms.
PROJECTS for Confidential, Bombay - May 1995 till June 1997Financial Accounting System forAmbassador Flight Kitchen, Bombayon PowerBuilder 5.0 with Informix as backend duringthe time frameFeb 1997 to May 1997 consisting of 7 team members. I was responsible for a Design, coding & testing. Reports were viewed in AutoCAD.
Function Point Analysis, measurement of the application software functionality based on the end-user view was done as a in-house project on PowerBuilder 5.0 with Oracle 7.0 as backend duringthe time frame Dec 1996 to Jan 1997 consisting of 4 team members.
HOST 2000 - is basically a product meant for international hotel & catering industry was done during July 1996 to Dec 1996 on PowerBuilder 5.0 with Oracle 7.0 backend consisting of 8 team members. It was also implemented at Hotel Shalimar, Kems Corner- Bombay.
Hotel Management System wasan integrated system catering to many parts of Hotel Industry. Such as Front Office Mgmt, Material Mgmt, Food & Beverage Service & Production, House Keeping, Maintenance, A/C, Banquet Mgmt.Was done during Oct 1995 to Jun 1996 onPowerBuilder 4.0 with Oracle as. I was responsible for a SDLC.
Payroll Management System wasdone for clientPratap Bright Steel, Nariman Point, Bombay onPowerBuilder 4.0 with Sybase as backend during Apr 1995 to Sep 1995. I was responsible for a complete life cycle.
Inventory Management System was done for client Pharmex International, Khetwadi, Bombay onPowerBuilder 3.0a with Sybase as backend during Jul 1994 to Mar 1995, which involved the complete life cycle of a project.
ACADEMIC PROJECTS
ANSI C Preprocessor as per DOE A- LEVEL specification developed under C/Unix:
It handles the pre compilation of C program by replacing all # statements. Data structures and concepts used are Hashing, Stacks, and Queues, Symbol table generation, lexical analysis with various searching and sorting techniques.
QUALIFICATION
Bachelor of Science (Mathematics)
A-Level