Poonam Sood ⋅Page 1 of 3
2/37 Carrington Street • Granville NSW 2142
0469 854 509 • poonam.sood@hotmail.com.au...
Poonam Sood ⋅Page 2 of 3
• Delivered over 300 reports in less than a month’s time for an urgent requirement in CoreCard In...
Poonam Sood ⋅Page 3 of 3
Project: DeMATrix, a back office software forDepositoryParticipantsinIndia
of 3


Published on: Mar 4, 2016
Source: www.slideshare.net

Transcripts - PoonamSood_Resume_SAPCrystalBIDev

  • 1. Poonam Sood ⋅Page 1 of 3 POONAM SOOD 2/37 Carrington Street • Granville NSW 2142 0469 854 509 • poonam.sood@hotmail.com.au http://www.linkedin.com/in/poonamsood Australian Permanent Resident EXPERIENCED AND TALENTED SAP BO/BI/SQL DEVELOPER Expertise: Crystal Reports • BI • SQL Server •.Net Competent IT professional with more than 10 years of hands-on experience in software and database development, reporting and project management with wide ranging experience in designing, coding, reporting, testing and implementationof softwares;consistently demonstrating essential attributes of a positive, energetic, self motivated, analytical team member on IT projects. CORE COMPETENCIES  Extensive knowledge of SAP Business Objects, Crystal Reports, BI, SQL Server, .Net Technologies: C#, ASP and VB.Net, .Net Compact Framework.  Strong experience in database, universe, dashboard and publication design, development, manipulation and customization.  Areas of expertise are Crystal Reports, BI, SAP BO, SSRS, Java script, Microsoft technologies and project management.  Knowledge of Business data warehouse, web intelligence, BI Launch pad and CMC.  Significantdevelopmentexperience inproducts,servicesandsolutions. Worked on various software development projects and held a broad range of hands-on technical positions.  Dedicated, self motivated achiever who is committed to success and quality with proven team building and interpersonal skills. TECHNICAL COMPETENCIES Programming Languages/Scripts C#, AJAX,JQuery,WCF,VC++,VB Script,Visual Basic, SQL,PL/SQL, C++, C,XML, HTML 5, JSON and JavaScript. RDBMS/ DBMS SQL Server2008, 2005, 2000, 7.0, MS Access,Oracle 11, 8.0, 7.x,FoxPro. GUItools/ Interfaces SAP BusinessObjects, Crystal Report 11, 8.5, 8.0, 7.0, SAP Crystal Reports for Enterprise, BO Module,SSRS, SAP Dashboards, BusinessUniverse,Informationdesigntool,CMC, BI Launch Pad, businessdata warehouse,WebIntelligence,Data analysis Software MicrosoftVisual Studio2010/2008, MS Office (Word,Excel,PowerPoint),Adobe Photoshop Technologies/Concepts .Net(C#, ASP and VB.Net) .NetCompactFramework,ProjectManagement,SDLC, AGILE, DesignPatterns, ObjectOrientedProgrammingSystem(OOPS),ClientServerTechnology. NOTABLE ACHIEVEMENTS • Designed and developed the BI reporting solution for a retail company in Sydney having more than 100 stores across Australiaand NewZealand. Designedthe database,businessuniverse, Crystal reports, dynamic dashboards and publication to replace the existing manual reporting process. • Standardised the process of developing the programs and reports by designing a template along with coding standards/guidelinesto follow, resulting in increase in efficiency and quality of reports, which was appreciated by the management at ISC Software Pvt. Ltd. And is still in place at CoreCard Inc. (USA) Offices.
  • 2. Poonam Sood ⋅Page 2 of 3 • Delivered over 300 reports in less than a month’s time for an urgent requirement in CoreCard Inc India Office, on account of which promoted as a Team Leader of Reporting team at ISC Software Pvt. Ltd. • Selected to train new recruits and other staff in DBBIDE, a platform developed by Corecard Inc, USA in VC++ to developcomplex webapplicationsforbank/creditcard/mastercardsolutionsafter shown exceptional performance during training at CoreCard Inc. Atlanta (USA). PROFESSIONAL EXPERIENCE Freelance Software Consultant Aug 2014 – Current Sydney Currently working as a freelance software consultant, database analyst, Crystal report/BI Universe and dashboard developerandwebdesigner;providingtechnical andreportingsolutions,software and reports development, database and website design to local businesses. Project: BI reporting solutionfor a retail company having more than 100 storesacross Australia and NewZealand Software: SAPCrystalReports, SQLServer2014, CMC,BusinessLaunch Pad,Informationdesign tool,Businessuniverse Challenge: To replace the existing manual reporting system to automated BI reporting system. Actions: Designed and developed Reporting database, business universe, complex queries using information design tool; developed reporting structure, dynamic dashboards and publication to schedule and send reports directly to stockholders by mails. Prepared business requirement document, project plan and estimates. Results: Improved and efficient automatic reporting system catering all the business needs for decision making and analysis. Analyst Programmer (.Net) Oct 2008 – Nov 2013 Ash Software Pvt. Ltd., Pune, India A wholly owned subsidy of Villa Plus, a leading tour operator in UK Project: NIMBUS,a project to improve performance of VillaPlus,UK website (www.villaplus.com) Software:CrystalReports, C#4.0, ASP.Net,SQLServer2008, XML, JQuery,WCF, LINQ, Ajax Challenge: To improve the performance of the existing website of Villa Plus Actions: Redesigned and developed databases and UI of ‘Booking Engine’ and related user interfaces such as Amend flights, insurance, Car Hire, transfer and extra features; developed technical solutions to improve efficiency and effectiveness of existing processes. Prepared project plans (MPP), deadlines, milestones, coding standards and guidelines. Results:Robustdesign,betteruserfriendlylook,new advancedfeatures,completely online booking, balance payment and SEO based development practices. Project: VIPER, a project for migration to .Netof existingwebsite ofVillaPlusfrom classic ASP (VillaPlus,UK) Software:C#3.5, ASP.Net,SQLServer2005, XML Challenge: Identify and redesign various sections/modules e.g. Insurance, Logging, Flights, Car hire, Transfer etc. of Booking System Actions: Analysed,designedanddevelopedthe database of modulesof ‘LoggingService’and‘Insurance service’ for the Project VIPER. Also as an ‘Operation Group Lead’, worked on new bugs and enhancements of existing website and monitored the work done by fellow developers; prepared the High Level Design Document (HLD), Detailed Design Document (DD) and other design documents such as Task-Kick Off (TKO), Task Plan (TP), sequence diagrams, impact analysis, functional and unit test cases, code review and Task Close Out (TCO) documents. Results:The newwebsite of VillaPlus was fast and more user friendly, thus increased user web traffic and generated more revenue to company. Senior Software Developer/ Module Leader June 2008 – Sep 2008 Winsoft Technologies (I) Pvt. Ltd., Pune, India A global supplier of enterprise software solutions to financial organisations
  • 3. Poonam Sood ⋅Page 3 of 3 Project: DeMATrix, a back office software forDepositoryParticipantsinIndia Software:SQLServer2005, CrystalReports11.0, ASP.Net Challenge: Digital SignedEmail Handler,E-Billing&Outstandingsmodules. Actions: Identifiedandtranslatedthe requirementsintosoftware solutiondesign;designedmodulesfor‘Digital Signed Email Handler’and‘E-Billing&Outstandings’forsome clientspecific requirement and provided accurate estimates for design and development of identified modules; maintained all technical documentation and technical support. Results: Both the modules were successfully implemented and resulted in repeat business to company. Senior Software Developer/ Team Leader Mar 2004 – May 2008 ISC Software Pvt. Ltd., Bhopal India office of Corecard Inc, an MNC at Atlanta, USA Project: Reporting System for Mashreq Bank, Dubai, which is an issuer as well as acquirer bank Software: SQL Server2005, CrystalReports11.0 Challenge: Complex stored procedures to derive data in various reports. Actions: Lead the Crystal Reporting team (India) of 10 persons, designed more than 100 reports and developed the stored procedures (Sql) for the same; conducted meetings and code reviews. Results: Won the client appreciation and recognition from the company. Project: Reportingrequirementsof Bright Now,USA. Withalmost300 officesin18 states,BrightNow!Dental affiliated dentistsdelivergeneral, specialtyandcosmeticcare tomore than2.5 millionpatientseachyearinthe USA Software:SQLServer2005, CrystalReports11.0, VB Script Challenge: To deliver over 300 reports in a month’s time. Actions: Plannedthe project,assignedthe worktoteam membersanddeveloped a template to deliver more than 300 reports; provided training & support to fellow team members. Results:Reporttemplate designed by me is used for future report development. I was promoted as a Team Leader of Crystal Reporting Team (India). Project: Acquiring (Merchant account management system), USA, a full featured merchant account management and transaction processing system for financial services organizations that acquire credit card purchases for merchants. Software:DBBIDE, SQL Server,CrystalReports8.0 Challenge: Complex financial transaction processing system. Actions: Developedvariousprograms,storedproceduresandcrystal reports.Alsodesigned and developed the various user interfaces and functionalities using 'DBBIDE', platform developed by Core Card Inc. USA using VC++. Results: Developed the advance systems in DBBIDE, selected to train other employees on the same platform. QUALIFICATION AND TRAINING  Master of ComputerApplications(M.C.A.),India(2000) (Assessed ascomparableto an AQFMaster Degreewith a majorin computing by ACS)  Advance DiplomainSoftware Technology&SystemManagement ,NIIT,India(1997)  Bachelor of Science (B.Sc.) in Statistics,Jiwaji University,Gwalior,India(1995)  MPM (MasterProject Manager) certification awardedbyAmericanAcademyof Project Management(AAPM) http://www.projectmanagementcertification.org  Dulyelectedasa memberof the AmericanAcademyof Project Management(AAPM) and alsodesignatedasa Fellowof the AmericanAcademyof Project Management(FAAPM).  Projectassignmentandtraining inAtlanta,Georgia,USA onDBBIDE (a platformdevelopedby CorecardInc.,USA inVC++ to developcomplexwebapplicationsforbank/creditcard/mastercardsolutions) whileassociatedwith ISC Software Pvt.Ltd. REFERENCES AVAILABLE ON REQUEST

Related Documents