PROFESSIONAL PROFILE
Accomplished Senior IT professional with a background in business intelligence software design and full life-cycle development. Capable of managing numerous projects while leading cross-functional teams to meet and exceed overall IT initiatives.

Highlights of skills:

• Business Intelligence
• Data Warehousing
• Process Improvement
• Team Leadership & Effectiveness
• Strategic Planning & Analysis
• Reporting Systems Architecture
• Process Implementation
• Software Design & Development

Summary:

• An experienced Business Analytics professional with a proven history of delivering complex analytics projects including requirements analysis
• Excellent work experience as Report Analyst, Database Analyst and Business Analyst from gathering requirements to deployment.
• Excellent knowledge in relational database management system (RDBMS), database designer; database development, including design, normalization, and optimization
• Expertise in defining Queries, test the queries, performance tuning and query optimization. Generated reports on Ad-hoc basis during all projects.
• Expertise in generating drill-down report, Parameterized report, Sub report, Cross Tab, OLAP, Query based reports, Custom made template, Report scheduling and publishing.
• Performed Data Modeling using Informatica 7.1, familiar with transformation, Mapping. Performed Reports and Database migration jobs
• Studied the system Design, development and deployment of traditional and operational business Intelligence reporting architectures.
• Excellent reputation with end-user and clients, providing high quality, attentive and effective design, development and support of their systems.
• Strong analytical and problem-solving skills coupled with excellent written, verbal and inter-personnel communication skills with ability to interact with end-users, managers and technical personnel.
• Extremely diligent, strong team player with an ability to take new roles.
• Excellent knowledge of Database administration which includes creation of database, views, indexes, stored procedures, functions, table spaces, control & log files, hot & cold backup, recovery, performance tuning at database & reporting level, grant privileges, monitoring.

Education:
BS in Statistics

Software/Hardware:

Crystal Report 2008/xi/10/9/8/6, Business Object, SAP Business Intelligence, Xcelsius, Universe, Web Intelligence, Informatica 7.1, Oracle 8i/10g, SQL, PL/SQL, DB2, MS SQL Server 2005 & 2008, Teradata, EPIC, Visual Basic, Window XP/2003/NT, Unix, Office suites(Word, Access, Excel, Project), VISIO, XML, Qlik View, SSRS, SSIS, ECC, Toad 9.0, Visual studio.

Experience:

Confidential,Louisville, KY Feb 12 - Cont
Business Object Developer
Role involved study and analyzes the requirements. Create reports, support end client & prepared technical/functional documents. End client is Trover solutions Inc.

• Design, development and deployment of traditional and operational business Intelligence reporting based on BRD.
• Studied technical detail and design specification documentation for the new reports and went through whole SDLC methodology.
• Managed users/groups/reports on CMC, scheduling reports

Confidential,Cary, NC Jan 11 – Feb 12
Business Object Developer
Role involved study and analyzes the system, prepared BRD, technical & functional documents and generates required report and support globally.

Responsibilities:

• Helping companies make better, faster, more informed decisions by thoroughly analyzing their data and constructing custom, insightful, easy-to-understand, and highly visual analytic displays and dashboards
• Drove improvements to the customer acquisition process via improved tracking, reporting, and reduced timelines using business intelligence/data analysis techniques
• Worked with Oracle Database to create and maintain views, functions and stored procedures.
• Discussed business requirements and mapped business needs. Designed Complex reports using sub reports, manual cross tabs using Crystal syntax with extensive usage of Local, Global and Shared variables at report formulas.
• Controlled version and end user’s requests/incidents through ECC
• Created user profiles for new business users and also trained in using of Business Objects Reporter module and support remotely including overseas site

Environment
Business Object 3.1, BI, Crystal Report 2008, XI, 10, Oracle 11g, SQL Server 2005, Xcelsius Visual Studio, Qlik View, ECC

Confidential,New York, NY Apr 2010 – Dec 2010
Business Object Developer

Confidential, involved in financial services facilities in multiple locations in the U.S. and overseas. DTCC provides clearance, settlement and information services

Project involved to Design, development and deployment of traditional and operational business Intelligence architectures of Time management and Project management reports

• Design, development and deployment of traditional and operational business Intelligence reporting based on BRD.
• Worked with the IT team to bring in the data required into Business Objects Universe so as to make available for super users to create Adhoc reports
• Involved in the analysis, design, develop, testing, deployment and user training of analytical & transactional reporting system.
• Involved in Creation of ad-hoc Crystal Reports, Created ODBC Connections, database Connections, stored procedure using oracle.
• Designed Complex reports using sub reports, cross tabs using Crystal syntax with extensive usage of Local, Global, and Shared variables at report formulas.
• Modified report content and export reports in multiple formats based on user input.
• Involved in Writing SQL Queries, Views and Stored Procedures on SQL Server.

Environment
Business Object 3.1, Crystal Report 2008, XI, 10, Oracle 10g, SQL Server 2008, Dashboard, WEBI

Confidential,Detroit, MI Mar 2009 – Mar 2010
Report Analyst / Developer

Confidential,is pioneer hardware and software solution provider for car parking industry on air port or major car parking spots. Role involves generating new reports using Crystal report on SQL Server databases including gathering requirements and analysis.

• Studied and analyze requirements, databases sources, applied parameters to control database for performance.
• Customization of application data capture for business end user reporting.
• Design and develop Crystal reports as per company’s need, maintaining implementation, quality control testing and deployment
• Performed as a Business Analyst to gather requirements simultaneously studied databases resources. Implemented software development life cycle (SDLC).
• Interacted with business analyst, project manager, and other report developer.
• Migrated whole parking reporting system from old (Sybase) to new (SQL Server 2008) with new advancement and criteria.
• Transformed data in visualization form to forecasting business using Business Object Xcelsius Dashboard & Web Intelligence

Environment
Crystal Report 2008, SQL Server 2008, Business Object 3.1, Xcelsius SSRS, Visual Studio, SSIS, Web Intelligence, Sybase

Confidential,Pittsburgh, PA Oct 2007 – Feb 2009
Report Developer & Database Analyst

Confidential,have been providing consulting services and software to the Pharmaceutical industry since 1990.
Role involved creating reports using clinical and financial data. Directly interacted with business user to understand the requirements and gathering requirements by conducting meeting.

Responsibilities:

• Interacted with the users for understanding and gathering business requirements.
• Studied technical detail and design specification documentation for the new reports and went through whole SDLC methodology.
• Created Standard reports, Cross-tab, Sub reports, drill down reports, on demand sub reports using Crystal reports XI Oracle 10g on demand and ad-hoc basis.
• Developed various charts and Graphs like bar chart, line charts, pie charts etc by using chart experts.
• Involved in the analysis, design, develop, testing, deployment and user training of analytical & transactional reporting system.
• Discussed business requirements and mapped business needs.
• Used stored procedure to return a value (like a function call) and created a result set in the same way as an SQL SELECT statement.
• Performed role as a Database administrator for day to day backup, database monitoring.

Environment:
Crystal report XI, Business Object 3.1, Xcelsius, Oracle 10g, Toad 9.1, SDK, XML, Visual SourceSafe, Visual Studio, C#, Informatica 7.1

Confidential,Silver Spring, MD Mar 2006 – Sep 2007
Report Developer

Confidential,is the largest nonprofit health care plan in the United States. Company serves the health care needs of 8.2 million members in 9 states and the District of Columbia.
The project was creating required report by interacting with business users, production support, publishing and scheduling report on enterprise. Create business users.

Responsibilities:

• Managing and publishing Crystal Reports using Crystal Enterprise
• Actively participating in the design and review of the new reports standards.
• Responsible for developing and maintaining Crystal Reports, development cycle of client requirements, analysisclient needs
• Educated end-user about database construction through Data Dictionary
• Create business users(Doctors, Radiologist, Microbiologist etc), grants privileges
• Interact with business users and support them if any problem arise
• Running and testing required queries and reports before publishing and test the performance
• Maintained high level of customer satisfaction with custom reporting services from both internal and external customers.
• Involved in Creation of ad-hoc Crystal Reports, Created ODBC Connections, database Connections, stored procedure using oracle.
• Customized data by adding Filters Calculations, Prompts, Summaries and Functions
• Performed Data Modeling using Informatica 7.1

Environment:
Crystal reports 10 & Xi, Business Object 3.1, Teradata 7.1, DB2, Excel, Remedy, Epic, Lotus Notes, Informatica

Confidential,Toronto Feb 2002 – Feb 2006
Reports Developer/Analyst

Confidential,involved in fire log production and sales with having 60% share in North America. Company is also involved in other products like candles, garden lamp (torch), adhesive tape, glue.
Role involved developing, maintaining and providing support on various applications.

Responsibilities:

• Closely interacted with designers and software developers to understand application functionality and navigational flow and keep them updated about Business user’s sentiments
• Performed reports migration from version 8 to 10 covering all criteria
• Created different type of reports including Cross-tab, Conditional, Drill-down, and Sub reports.
• Created reports include formatting options such as Grouping, Sorting, and Drill-down.
• Performed team leader role in few projects
• Modified report content and export reports in multiple formats based on user input.
• Involved in Writing SQL Queries, Views and Stored Procedures on SQL Server 2000.
• Involved in all team meetings involving users and other team members.
• Designed Complex reports using sub reports, cross tabs using Crystal syntax with extensive usage of Local, Global, and Shared variables at report formulas.

Environment:
Crystal Reports 8.0 & 10, SQL Server 2000/2005, Business Object, Visual Basic 6.0, MS Access, MS Excel, XML and Windows NT, SSRS, SSIS