Published on: Mar 4, 2016
Transcripts - PoonamSood_Resume_SAPCrystalBIDev
Poonam Sood ⋅Page 1 of 3
2/37 Carrington Street • Granville NSW 2142
0469 854 509 • email@example.com
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.
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
Areas of expertise are Crystal Reports, BI, SAP BO, SSRS, Java script, Microsoft technologies and project
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
C#, AJAX,JQuery,WCF,VC++,VB Script,Visual Basic, SQL,PL/SQL, C++, C,XML, HTML 5,
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,
• 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.
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).
Freelance Software Consultant Aug 2014 – Current
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
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
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
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
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)
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