Bi Project Lead resume
Summary:
- 10 + years of experience in Leading a Project, development of Application Software Design and Development of Business Objects,Crystal Reports 9, 10, XI, 2008, Cognos and BIRT.
- Experienced in the development and deployment and Testing of Reports for Retail, Healthcare Manufacturing, and Software companies.
- Worked extensively in developing and implementing Crystal reports/WebI on Business Objects Enterprise XI, XI REL2, Crystal Enterprise 8.0 thru 10, Business Objects Universe Design, Info View
- Expertise in designing Universe(s) from scratch, migrating to different environments
- Defined, designed & developed the use of Reports by blending the knowledge of the client with the available technical know-how.
- Expertise over preparingreport specifications, database designsto support the reporting requirements.
- Experienced in migrating reporting fromCOBOLmainframe to Web based Reports usingCrystal Enterprise 8.0/8.5/9/10
- Experienced with multiple RDBMS including Oracle 10g/8i/8.x/7.x, MS SQL Server 2005/2000/7.0/6.5, and associated SQL Dialects such as PL/SQL.
- Strong interpersonal skills, with demonstrable verbal and written communications to maintain effective work relationships with all levels of personnel.
- Capable of working as an individual as well as a part of team.
Computer Knowledge:
Reporting: BusinessObjects XI R2, Crystal Report 2008, XI/10/9, Cognos, BIRT
RDBMS: MS SQL Server 7.0/2000/2005, Oracle7.x/8/8i/10g, MS-Access2000, MYSQL
Languages: SQL, SQL*Plus, T-SQL C, C++, Pascal, FORTRAN, Java, Visual Basic 5/6.0
Web Technologies: HTML, XML, JSP, TOAD, Macromedia Dreamweaver, MS FrontPage, Java Script
PERSONAL SKILLS
- Excellent Project Management Skills
- Excellent verbal and written communication skills
- Ability to interact professionally with a diverse group of executives, managers, and subject matter experts
- Ability to work well both independently and as part of a team
- Ability to manage difficult situations within tight project time frames
- Very strong relationship management skills.
- Excellent organizational skills and attention to detail
- Ability to interact with individuals and groups across all levels of an organization
- Ability to be flexible and adaptable when dealing with change
- Ability to allocate time efficiently, handling multiple demands and competing priorities
- Strong problem solving skills and analytical ability
Professional Experience:
Confidential 01/11 – Present
Role: BI PROJECT LEAD
Responsibilities:
- Lead people and teams. Manage, guide, mentor, motivate, and lead company personnel toward
- accomplishment of project goals
- Experience in IT Project Management to include: Scheduling, Coordination, Control, and/or Project/Process Documentation
- Further the company capabilities in PMO and SDLC processes and principles
- Develop detailed project plans, including work breakdown structures, schedule creation, effort
- and resource planning, and synthesizing of plans across multiple projects
- Scope and estimate various phases of project lifecycle work during both business development
- and project execution
- Oversight and management of an endtoend project budget.
- Keep meticulous time records against specific project management tasks
- Develop, document, and implement best practice processes across a variety of projects
- Be persistent and professional in pursuit of all project deliverables and documentation
- Represent and support PMO policies, procedures, and best practices to various projects and key
- business stakeholders
- Proactively communicate with all stake holders regarding project management status and
- deliverables
- Ability to clearly and articulately convey project constraints, risks, and plans to all levels of audiences
- Demonstrated ability presenting to small work groups on both technical and functional requirements
- Ability to thrive under production pressure and deadlines
- Team oriented with good interpersonal skills and the ability to collaborate effectively with Coworkers and product management team
- Comfortable challenging peers in a healthy, constructive way
- Knowledge of Business Intelligence solutions and implementations
- Knowledge of data warehousing and data management practices
- Knowledge of application development, including business requirements gathering,
- Development, testing, and implementation
- Business analysis experience
- Knowledge of data models and relationships between data elements
- Experience writing datadriven reports, working with data to create reports
- Familiarity with ETL processes
Confidential 11/10 – 12/10
Role: Sr.Data Analyst
Responsibilities:
- Actively involved in gathering end user requirements, user/system documentation, user training, and testing of crystal reports for final deployment. Interacted directly with the user for getting specs, draft specs, and generated new reports according to the specs and gave it to the user for verification.
- Developed Cross Tab Reports, Sub Reports, and Parameter Reports by using Crystal Reports versions 2008.
- Tested the developed crystal reports and created test cases for the testing team.
- Involved in transformation of the existing Crystal Reports to meet user requirements.
Environment: Crystal Reports 2008, Adobe Omniture Sitecatlyst, SQL Server 2000.
Confidential, Fox borough, MA 09/09 – 08/10
Role: BI Developer
Responsibilities:
- Developed Crystal Reports XI to address diverse levels of the organizational requirements ranging from Individual employees to a complete line of operations.
- Actively involved in gathering end user requirements, user/system documentation, user training, and testing of crystal reports for final deployment. Interacted directly with the user for getting specs, draft specs, and generated new reports according to the specs and gave it to the user for verification.
- Developed Cross Tab Reports, Sub Reports, and Parameter Reports by using Crystal Reports versions XI.
- Tested the developed crystal reports and created test cases for the testing team.
- Involved in transformation of the existing Crystal Reports to meet user requirements.
- Developed PIE and BAR Charts with Drill down option using Drill down Report Expert.
- Applied heavy formatting for reports and developed reports with essential Formulas and Parameter fields.
- Involved in inclusion of linked as well as unlinked Sub-Reports along with the primary reports.
- Involved in Architectural decision-making process and assisted other programmers in coding as well as for other problems that were raised during the development process.
Environment: Crystal Reports XI, SQL Server 2000.
Confidential, Waltham, MA 01/08 to 06/09
Role: BI Developer
Responsibilities:
- Developed Crystal Reports to address diverse levels of the organizational requirements ranging from Individual employees to a complete line of operations.
- Actively involved in gathering end user requirements, user/system documentation, user training, and testing of crystal reports for final deployment. Interacted directly with the user for getting specs, draft specs, and generated new reports according to the specs and gave it to the user for verification.
- Developed Cross Tab Reports, Sub Reports, and Parameter Reports by using Crystal Reports versions.
- Tested the developed crystal reports and created test cases for the testing team.
- Involved in transformation of the existing Crystal Reports to meet user requirements.
- Developed PIE and BAR Charts with Drill down option using Drill down Report Expert.
- Applied heavy formatting for reports and developed reports with essential Formulas and Parameter fields.
- Created and Documented Crystal Reports Standard used in this application.
- Tested the developed crystal reports and created test cases for the testing team.
- Involved in transformation of the existing Crystal Reports to meet user requirements.
- Applied heavy formatting for reports and developed reports with essential Formulas and Parameter fields.
Environment: Crystal reports XI, Cognos, MS SQL Server 2005
Confidential, Princeton, NJ 11/05 to 01/08
Role: Programmer Analyst
Responsibilities:
- Developed Production reports using Crystal Reports Developed various report formats including Sub Reports, Cross Tab Reports, OLAP Reports and Standard Reports.
- Developed reports using Seagate Crystal which could be accessed from the Visual Basic 6.0 application. Customized various Reports after the upgrade process.
- Used TOAD and SQL*Plus for writing the Stored procedures, Views, Functions in Oracle as the client.
- Developed Cross Tab Reports, Sub Reports, and Parameter Reports by using Crystal Reports versions 9/8.5.
- Tested the developed crystal reports and created test cases for the testing team.
- Involved in transformation of the existing Crystal Reports to meet user requirements.
- Created numerous Alerts that are executed based upon certain conditions
- Developed PIE and BAR Charts with Drill down option using Drill down Report Expert.
- Fixed bugs and enhanced existing reports. Converted reports that were created in earlier versions to Crystal Reports 8.5/9.0 with appropriate change.
- Applied heavy formatting for reports and developed reports with essential Formulas and Parameter fields.
- Developed Graphic Reports, Pie charts for the statistical representation of the data
- Designed and developed custom Reporting solutions and Re-Engineering solutions to enhance existing frameworks to work with newer technologies.
Environment: Crystal reports XI,,MS SQL Server 2005
Confidential 01/05- 06/05
Role: Reports Developer
Responsibilities:
- Developed Crystal Reports10.0 to address diverse levels of the organizational requirements ranging from Individual employees to a complete line of operations.
- Actively involved in gathering end user requirements, user/system documentation, user training, and testing of crystal reports for final deployment. Interacted directly with the user for getting specs, draft specs, and generated new reports according to the specs and gave it to the user for verification.
- Deployed Reports on web by using components of Crystal Enterprise.
- Designed around 50-60 Views /Stored Procedures in Microsoft SQL Server 2000 to be deployed in the reports for better performance. Used these Procedures and Views in numerous reports.
- Developed Cross Tab Reports, Sub Reports, and Parameter Reports by using Crystal Reports versions 9/8.5.
- Tested the developed crystal reports and created test cases for the testing team.
- Involved in transformation of the existing Crystal Reports to meet user requirements.
- Created numerous Alerts that are executed based upon certain conditions
- Developed PIE and BAR Charts with Drill down option using Drill down Report Expert.
- Fixed bugs and enhanced existing reports. Converted reports that were created in earlier versions to Crystal Reports 8.5/9.0 with appropriate change.
- Applied heavy formatting for reports and developed reports with essential Formulas and Parameter fields.
- Involved in Architectural decision-making process and assisted other programmers in coding as well as for other problems that were raised during the development process.
Environment: Crystal Reports 10/9.0/8.5, Crystal Enterprise 9.0, Seagate Info 7.0, SQL Server 2000, T-SQL, MS Access 2000/Reports, Windows NT, Windows 2000.
Confidential 03/03 to 12/04
Role: Developer
Responsibilities:
- Involved in the execution of Reports on Crystal Enterprise 8.0 & Crystal Reports 8.5 on Windows NT 4.0 Operating System and Oracle 8i database.
- Deployed Reports on web by using components of Crystal Enterprise.
- Developed Production reports using Crystal Reports 8.5. Developed various report formats including Sub Reports, Cross Tab Reports, OLAP Reports and Standard Reports
- Customized the Crystal Enterprise 8’s ePortfolio to suit the company’s requirement.
- Developed reports using Seagate Crystal 8.5 which could be accessed from the Visual Basic 6.0 application. Customized various Reports after the upgrade process.
- Developed Graphic Reports, Pie charts for the statistical representation of the data
- Worked with Seagate Analysis tool for analysis of ad-hoc queries and Reports.
- Designed and developed custom Reporting solutions and Re-Engineering solutions to enhance existing frameworks to work with newer technologies.
- Involved in recruiting and mentoring offshore team and Training Users.
Environment: Crystal Decisions Crystal Reports 8.5, Crystal Enterprise 8.0, HTML, TOAD7.2, Oracle 8i, SQL*Plus, Windows NT, Crystal Query.
Confidential 02/01 to 06/02
Role: Reports Developer
Responsibilities:
- Gathered user requirements, drafted specifications, and designed, deployed, and documented reports using Crystal Reports Designer, Crystal Query.
- Involved in the creation of Cross Tab Reports and Sub Reports using Crystal Report Designer in Seagate Info Version 7 environment.
- Developed various Charts and Graphs like Bar chart (Side By Side, Stacked), Line graphs, Pie Charts etc by using Chart expert of Crystal Reports.
- Involved in the implementation and maintenance of Info Server, Info Desktop on Windows NT operating system.
- Created Tables, Views, Stored Procedures, and Queries to meet the reporting needs by using SQL Server 7.0, SQL Server 6.5, and MS Access.
- Worked with Info Administrator for creating Users, User Groups, assigning rights, roles etc.
- Developed several Complex Reports (various features used include multiple groupings, drilldowns, parameter fields, formulas and conditional formatting) using Crystal Reports.
Environment: Crystal Reports 8.0, MS-SQL Server 7.0, Windows NT
Education:
- Master Degree in Computer Science
- Advanced Certification in Information Technology
- Trained by Siemens in Soarian Financial Systems
- Trained by Siemens in Soarian Clinical Systems.