Professional Summary:

• A seasoned software professional intensely involved in Business Intelligence and Business Warehouse teams, providing leadership in Data Modeling & Analytics. Bringing 17 years of experience in Software development life cycle with cutting edge technologies to deliver user centric solutions.

Previous Positions Held:

• Sr. SAP BI (BW & BOBJ) Team lead– Played a key role in delivery of SAP BI(BOBJ/BW) solutions at City of Burnaby. (Dec 2006 – Current)
• Strategic Business Analyst as a liaison between Siemens and Cisco Systems for business development and building OEM relationship.
• Senior Customer Problem Resolution Engineerat Cisco Systems, interfacing clients like New York Mayor’s office, US Department of Education, Group Dekko, Bank of America, Manufacturing companies and International Banks.
• Sr. Software Engineer at Cisco Systems, Voice Technology group using .NET, Microsoft and JAVA technologies building VOIP Products Cisco Unity.
• Business Analyst and programmer at AEGON USA, working on building Financial, Insurance and Mutual Fund applications.
• Master’s degree in Computer Science, Southern Polytechnic State University, Atlanta GA.USA
• Doctor of Veterinary Medicine, Sri Venkateswara Veterinary University, Hyderabad, India

Detailed Work Experience

Confidential - Sr. SAP BI Team Lead Dec’ 2006 – Current

• Played a key role in Business requirements, design, blue printing, QA & training, working closely with PMO teams to ensure smooth implementation of SAP BI (SAP BW 7.0/7.3, BOBJ 3.1 and 4.0).
• Lead the team to roll out Standard & Custom BI analytics to various city departments focussing on FICO, HR, Payroll, SRM, REFX, Assets, PM and PS.

Technical Leadership:

• Worked closely with Finance department (FICO) in automating and delivering complex departmental Budget to Actual, Cost Center Accounting reports, City Annual/Provisional Budget documents for trend analysis and future projections using BEX, Information Broadcasting, Web Intelligence, Dashboards(Xcelsius), Live Office & Crystal Reports.
• Worked on delivering end to end Analytic solutions for HR, Payroll and SRM.
• Participated in BOBJ 3.1 and 4.0 system administration, Performance tuning, defining End User Access Levels, applying SAP BW security (SSO and SNC), Portal Integration, system upgrades, Upgrade Management tool, SAP integration kit for 3.1, resolving connectivity and publishing issues.
• Expertise in front-end BW Components like Queries, Formula, Variables, Calculated Key figures, restricted key figures, Structures, Selection, Exceptions, and Conditions.
• Worked with BW Administrators in Modeling (PSA, DSO’s, Info Cubes, DTP, Info package, transformation & Multiproviders.), Extraction and Loading (Full/Delta upload), performance monitoring (Process chain monitoring, Monitoring and Error handling in PSA), identifying and activating the necessary Business Content.
• Participated in Data Validation process for Go Live process and future Audits.
• Worked closely with PMO/QA team in verifying all the Test plans & conducting UAT (User Acceptance tests).

Project Management:

• Conducted regular meetings with City Management (CIO, Directors of City Depts. and City Manager) to identify current operating procedures and clarify program objectives.
• Managed a team of business analysts, working closely with them to implement the technology.
• Participated in Budget planning and resource allocation sessions with Project managers.
• Tracked Cross Project dependencies, forecasting outcomes and being proactive to align teams for on-time delivery.
• Communicated effectively between various project teams to identify and mitigate risks involved with time and resource conflicts.
• Prepared detailed business requirements, specifications and participated in the development of system solution design for existing and new capabilities using gap analysis and other technical considerations. Followed and implemented ASAP methodology.
• Participated in positive performance feedback loops for continuous improvement of peers and team members.
• Worked on creating Report development process & guidelines, Prototyping, Implementation methodology, Business process & design documentation, and go live project plans.
• Worked on day to day tracking of issues from End users, resolving issues and updating management with Defect/Work order statistics in management team meetings.
• Conducted Post-Implementation Project review meetings and used the data & feedback for continuous improvement of later projects.
• Worked with Training teams in creating End User training documentation and user guides by writing, presenting and participating in training sessions on a regular basis.
• Worked closely with Change management team & QA managers to handle changes in data, systems and version upgrades effectively with least impact to end-users.
• Worked on evolving best practises and UI guidelines for Report development team.

Technology: SAP ECC 2005, SAP BW7.0/7.3, Bex Query Designer, Bex Analyzer, Web Application Designer, Information Broadcasting, SAP Business Objects XI 3.1, SAP BOBJ Integration Kit for 3.1, Crystal Reports 2011, Crystal Enterprise, WEBI, Xcelsius, Dashboards, LCM, Advanced Analytics, SAP BOBJ 4.0

Confidential, Seattle. Strategic Business Analyst/ Sr. Software Engineer March 2000 – Mar’ 2006
- Had been associated with Enterprise Communication Software Business Unit under Voice Technology Group that provides Unified Communications solutions building VOIP products like Unity, Call Manager and Cisco PCA.

• Worked as a Strategic Business Analyst between Siemens and Cisco Systems in developing the requirements and customizing the software for Siemens to build OEM relationship.
• Use Case analysis was done using UML and Rational tools.
• Created activity diagrams, flow of events diagrams, sequence diagrams, class diagrams, identified methods and attributes using Rational Rose. Created technical specifications.
• Translating the Technical specifications to the development teams and participating the meeting to explain the data flow diagrams and class diagrams to accommodate the requirements in the design phase of the project.
• As a part of UI team, conducted usability testing of the User Interfaces (GUI and TUI) and documented the results and conveyed the appropriate changes to the development teams.
• Participated in the GEM process, a customised Life cycle development process at Cisco and made sure that all the required documentation is in place for ISO reviews annually.
• Worked as a Senior Customer Problem Resolution Engineer, troubleshooting Critical problems of high profile customers like New York Mayor’s office, Department of Education, New York, Bank of America, DOW Jones, and many American Universities and Banks that installed Cisco Unity.
• As a part of Critical problem resolution, Traveled and interacted with various users at their locations, participated in the meetings, understood their requirements and documented them. Later perform use case, feasibility, gap and data analysis.
• Write Functional and Technical specifications and deliver the specifications to the architect teams in accommodating the new specifications in the later releases.
• As a part of Sustaining team, constantly dealing with Product Management team and addressing the issues that customers/users come up with and understanding the scope in the next releases and enforcing the requirements in form of hot fixes and roll-overs.
• Worked closely with Documentation Teams in making sure the product installation guides and User Manuals are appropriate and up to the needs of the user. Created a Knowledge bank kind of Document managing system for users and administrators to get latest updates on the product features, hot fixes and new releases.
• Participated in creating video demonstrations of the product and feature usability for the customers and System Analysts.
• Worked closely with Database teams in transforming the UI requirements into data model.
• Participated in many use case meetings and writing requirement and functional specification documents and enabling the Software product development teams conceive the specs in their design.
• Worked on creating standard templates for many of the Process related documents like Specifications, Architecture, Unit Test Plan and Review documents.
• Used programming methodologies like “Extreme Programming” to drive success using short life cycles and close knit teams with peer code reviews and unit tests in place and develop quality software.
• As an Engineer, Worked on developing Web Services using .NET framework, used as a carrier for Database information for all CRUD operations talking to a SQL Server back end.
• Lead, developed and designed Web based Systems Administration of the Voice mail system using ASP, VBScript and COM interfaces connecting to Access database.
• Built applications for Conversations module of the voice mail system, using C++ and State Transition Model.
• Built a Reports application Interface with Java, JSP, STRUTS framework that would enable the users to generate reports, schedule and view them with an Access Database and SQL server.
• Used Crystal Reports and Business Objects to create the Reports Interfaces and connected them to MS Access and SQL databases. Used Data warehousing concepts and built a multidimensional Reports Database for performing queries on KPIs.
• Designed Reports Database using the data warehouse concepts in creating an OLAP system from OLTP database.
• Worked on writing SQL and Stored procedures on the SQL server for all the database transactions.
• Participated in Performance reviews for Peers and Managers.

Technical Environment: Rational Rose, Visio, Requisite pro, .NET technologies, Visual Basic 6.0, ASP, JavaScript, SQL server, Microsoft Exchange server, Active Directory, C++, Java, Java spaces, JINI, Quartz Scheduler, COM, MAPI, Lotus Domino, Crystal reports, Data warehousing, MS Access, IIS, Tomcat.

Confidential, Tampa, FL Programmer/Business Analyst March 1999 – March 2000

- Provided solutions for creating the application software for the Life Insurance Business.

• Participated in requirement gathering and writing specifications using UML for consolidating the data that is spread around in discrete systems all over.
• Performed Gap analysis in different systems, and participated in many meetings with users from different systems to collect every possible requirement.
• Performed use case analysis and created consolidated Requirements for a Unified Information System for Mutual funds and Insurance Business.
• Used Visio to create data flow, system flow and Class diagrams.
• Used ERWIN to create Data Models and design the data bases.
• Worked on collecting requirements gathering by spending time with the users of various reports, including senior management and business users.
• Participated in writing Specifications, Design and Use case documents along with helping the QA in writing Test plans
• Worked on developing application for Life Insurance Agents, using Visual Basic 5.0, MS Access and Oracle database.
• Used Crystal Reports for generating reports for Managers to get the details about Employees and various business processes.
• Worked on documenting the test processes of all these systems and worked with QA team very closely to come up with Unit and Integration testing plans.
• Worked on creating an Internet based application for entering the New Employee Hire details using ASP and ORACLE database.
• Provided leadership and guidance for members of the team with regards to Software methodologies and systematic approach to Software development.
• Participated in Performance reviews for the co workers and Managers.

Technical Environment: Visio, ERWIN, Rational tools, Visual Basic 5.0, Oracle, MS Access, SQL server, ASP, Crystal Reports, MS Access, VBA, Visual Source safe.

Confidential, Tampa, FL . Software Engineer October 1997 – March 1999

Solution provider as a Consultant and Business analyst in creating cutting edge and smart applications in the Banking and Manufacturing Industry.

• Worked on analysis, requirement gathering and creating specifications for developing Payroll applications.
• Interacted with the users from Human resources, Finance and Administration teams in understanding the business requirements.
• Created Functional and Technical specifications using Use case analysis.
• Worked closely with software development teams in conveying the specifications for creating a robust design and creating good usable products with better quality.
• Worked on developing a payroll system for Employees using Visual Basic 4.0, Oracle and MS Access.
• Created report related templates for the company and different departments to trap the KPIs for decision making.
• Used Crystal reports for generating reports for the payroll system

Technical Environment:Visual Basic 4.0, Oracle, MS Access, Crystal Reports, PVCS.

Confidential, Tampa, FL Part-Time Faculty Jan 1999 – March 1999
Worked as a part time Faculty, teaching Software Engineering, Design Methodologies and programming languages like C++, Visual Basic, and databases like MS Access and Oracle.

Awards & Other Accomplishments:

• Winner of various CAP awards for outstanding contributions in building better software and providing quality and timely service to the leading customers of Cisco like New York Mayor’s office, Group Dekko and many more high profile customer installations.
• Received Customer appreciation awards from different customer teams for successfully understanding their requirements and transforming them into Products.

Formal Education

• MS, Computer Science
• Doctor of Veterinary Medicine

Formal Training

• Leadership Training: Cisco Leadership Training from Stanford Business School and also Management consulting firms about Change Management and Project Management.
• Influencing People: Training by Cisco Leadership Center.
• SQL Server Training: Microsoft SQL Server Training
• JAVA: On week training on Introduction of Java technologies along with STRUTS framework and Servlets
• .NET: Microsoft training about .NET Framework and fundamentals
• Windows Debugging and Security: Microsoft Training about using different Debugging tools and analysing user dumps.

Technical Summary

• Tools: Rational Rose, Visio, Clear Case, CVS, MS SourceSafe, Install Shield, ERWIN, Requisite pro, SAP BW Query Designer, SAP Bex Analyzer, SAP Business Objects, Crystal reports, WEBI, XCelsius
• Programming Languages: Visual Basic, VB.NET, XML, ASP, VBScript, JSP, JavaScript, .NET technologies, VBA, Java, C, C++.
• Databases and Operating systems: SAP BW 7.0, BEx tools, SQL, Ingress, MS Access, Oracle, MS SQL Server.Windows (95, 98, 2000, NT, 2003)
• Methodologies: OOPS, UML, Use cases, Entity Relationship Modelling, Star Schema
• Technologies: .NET Framework, Web Services, COM, DCOM, SOAP, STRUTS, MVC