PROFESSIONAL SUMMARY:

• Reports Developer/Data Analyst with 9 years of professional experience in IT industry developing, testing, administrating and supporting for Business Intelligence Data Warehouse environment.
• Queried the databases, wrote test validation scripts and performed the System testing. Worked with the developers during coding and while doing the remediation of the software.
• Build reporting data mart and build complex source SQL for building DW tables. Heavy on data analysis and understand the data flow and designing DW tables (Fact/ Dimension).
• Documented the complete process flow to describe program development, logic, testing, and implementation, application integration, heavy coding.
• Adept at extracting data from different databases such as Oracle 11G/10 G/9i, SQL Server 2000/2005, MS Access - 2010 with strong competency in Data Mart, Star Schema, Snowflake Schema, data requirement analysis.
• TEMPEffective co-ordination/communication between Business users and other Technology team such as database administrators, business object administrators. Lead off Shore team and had active communication for report development and production support.
• Excellent understanding of technical trends, architectures and highly motivated to know more about latest technology, new software and products and outstanding ability to manage and deliver results on multiple tasks by TEMPeffectively managing time and priority constraints.
• Expert in full life cycle of Business solution development with outstanding capabilities in analysis, problem definition and requirements gathering.
• Complete implementation of the SDLC life cycle in the projects.
• Experience in training developers and advising technical groups on reporting best practices.
• Expert in presenting reports/dashboard to business managers/executives.

TECHNICAL SKILLS:

Operating Systems: Windows 2010/2012 Server, UNIX, Linux and Solaris, Windows NT4.0, Windows XP Professional.

Languages: SQL, T-SQL, PL/SQL

BI Tools: Business Objects BI 4.0/4.1,BO Supervisor, Universe Designer XI 3.0/R2, Webi XI/6.5.x/4.0 Dash Board Manager XI, Performance Management, Auditor 6.5.1, Webi SDK, ZABO, BCA, Live Office, Query as web service, Import Wizard, Business View Manager, Data Integrator, Crystal Reports Explorer, Report Conversion tool, Upgrade Management Tool, Version Control Management, Promotional Management, Query Builder, Query as a Web Services, CMC, CMS, Information Design Tool, Information Steward. Tableau 7.x/8.x.

Databases: Oracle 11G/10G/ 9i, SQL Server 2000/2005, MS Access-2010

Web/Application Servers: IIS6.0, Tomcat 6.5, Apache 7.x

ETL Tool: Informatica Power Center 8.x/9.x, SQL Server Integration Services (SSIS) 2010.

Other Tools: Crystal Xcelsius, Visual Source Safe, Vision, MS Project, MS Office, MS Word, MS Excel, MS Power point, TOAD,SQL Developer

PROFESSIONAL EXPERIENCE:

Confidential, CA

Responsibilities:

• Worked with business users hand in hand to improve the data process flow.
• Responsible for translating the Business requirements into technical specifications.
• Analyzed data flow and business requirements to create High Level Design document and Detail report document.
• Developed business objects reports to analyze financial, billing processes.
• Defined data requirements and report layouts for the business to review. Created testing plans and scripts based on requirements.
• Formulated the process of reports to improve the business intelligence of the organization.
• Documented the complete process flow to describe program development, logic, testing, and implementation, application integration, heavy coding.
• Worked with internal architects and, assisting in the development of current and target state enterprise data architectures
• Defined the source to target data mappings, business rules and data definitions.
• Developed and tuned all the Affiliations received from data sources using Oracle/SQL Server tested with high volume of data.
• Interacted with the End Users, Business Analysts and responsible for Involved in training sessions to impart knowledge on designed universes (IDT) and published reports.
• Responsible to process Data mining activities to gather data and compile it to make a thorough analysis.
• Build DW reporting DataMart and expert in building complex SQLs.
• Extensively worked on Views, Stored Procedures, Triggers and SQL queries and for loading the data (staging) to enhance and maintain the existing functionality
• Provide database coding to support business applications using T-SQL.
• Responsible for design and build data mart as per the requirements.
• Designed the Dimensional Model of the Data Warehouse Confirmation of source data layouts and needs.
• Extensively used Oracle ETL process for address data cleansing.
• New Implementation of Business Objects 4.1 and build new universes/reports.
• Worked on migrating legacy reports to BI 4.1
• Worked on ad-hoc and canned Web Intelligence reports/Dashboards.
• Created graphs/charts for the reports, Created Master Detail and Cross Tab Reports.
• Responsible for writing the SQL queries for the data validation and testing the reports.
• Recommended standards of good practices of report development and maintenance of universes.
• Developed and managed overall performance tuning of reports/universe.
• Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Responsible for interaction with business stake holders, gathering requirements and managing the delivery.
• Creation of metrics, attributes, filters, reports, and dashboards created advanced chart types, visualizations and complex calculations to manipulate the data for detail Tableau Dashboard
• Build Complex Tableau Dashboard 8.x

Skills Utilized: Business Objects Enterprise 4.1 SP5, Web Intelligence, Explorer, Dashboard Designer BI 4.1, Oracle 11G,SQL Server 2010, Informatica Power center 8.6 (Power Center Designer, workflow manager, workflow monitor, Power Connect), Enterprise Data warehouse EDW oracle 11G, Windows Server 2008, Central Management Console CMC, Central Management Server CMS, Information Design Tool, Explorer, Query Builder, BIAR, Upgrade Management tool BI 4.1, Promotional Management tool BI 4.1, Tableau Dashboard 8.x.

Confidential, CA

Responsibilities:

• Responsible for translating the Business requirements into technical specifications.
• TEMPEffective interacting with Business users and managers in gathering business requirements and enabling business users informative and interactive reporting tool.
• Evaluated a centralized database and recommended changes for building an TEMPeffective DW DataMart for day to day reporting.
• Conducted quantitative analyses on available metrics and briefed management enabling them to improve and maximize visibility for data.
• Worked with the reporting developer and business users to gathered requirement, created and provided tests plan
• Build business dashboards to conduct trend analysis on retail metrics, especially relating to driving sales revenue, customer retention and salesperson productivity.
• Expert in Data analysis, Heavy SQL and building complex report SQL/views.
• Build DataMart, DW Fact and dimension tables and worked with Data Molder and Informatica experts.
• Worked with project team representatives to ensure dat logical and physical data models were developed in line with corporate standards and guidelines.
• Involved in defining the source to target data mappings, business rules and data definitions.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Oracle and Informatica Power Center.
• Analyzed, documented business requirements, functional requirements for developing universes and reports.
• Extensive Data analysis in order to create appropriate reports/universe for the users.
• Validated with business owners and stakeholders the current business rules to determine functional and technical requirement.
• Designed and maintained complex universes, resolved loops by creating aliases and contexts.
• Implemented object level security universe to incorporate security for sensitive information.
• Customized Universe level Prompts, filters, aggregate awareness as per functional requirements.
• Managed user row level security at universe level to customize data access for user groups.
• Wrote complex views, SQL, to be used in reports development on Enterprise Data warehouse EDW oracle database.
• Worked on ad-hoc and canned Web Intelligence reports.
• Design and developed information space and explorer views using explorer in BI 4.0.
• Coordination and work along with the ETL team to ensure the timely execution of feeds to the reporting tables as well as testing the quality of data and providing inputs to them.
• Responsible for migration of reports and universe between the environments through promotion management
• Consolidate the Business Objects repository before migrating to BI 4.0.
• Migrated Web Intelligence reports and Universes from Business Objects 3.1 to BI 4.0 environment.
• Experience in Training & Supporting end-user reporting needs using Business Objects.
• Designed and developed dashboard using Xcelsius 2008.
• Perform quality assurance and testing of SQL server environment.
• Creation of metrics, attributes, filters, reports, and dashboards created advanced chart types, complex calculations, visualizations using Tableau reporting tool.
• Implemented advanced geographic mapping techniques and use custom images and geo coding to build spatial visualizations of non-geographic data for Tableau Dashboards.
• Build Complex Tableau Dashboard 7.x

Skills Utilized: Business Objects Enterprise XI R3.1/BI 4.0, Universe Designer, Info view XIR3/ BI launch pad BI 4.0, Web Intelligence, Explorer, Desktop Intelligence, Dashboard Designer BI 4.0, Xcelsius 2008, Report conversion tool XI 3.1, Informatica Power Center 8.1 (Power Center Designer, workflow manager, workflow monitor, Power Connect), Oracle 10G,SQL Server 2008, Enterprise Data warehouse EDW oracle 10G, Windows Server 2008, Central Management Console CMC, Central Management Server CMS, Information Design Tool, Information Steward, Explorer, Query Builder, BIAR, Upgrade Management tool BI 4.0, Promotional Management tool BI 4.0, Import wizard (BO 3.1), Tableau Dashboard 7.x.

Confidential, NY

Responsibilities:

• Responsible for defining the key identifiers for each mapping/interface.
• Responsible for defining the functional requirement documents for each source to target interface.
• Documented, clarify, and communicate requests for change requests with the requestor and coordinate with the development and testing team.
• Worked with business users to define product feature requests, business requirement specifications and change request, documented requirement and transformed them into functional and technical requirement specifications. Experience and proficiency in preparing planning documents.
• Develop complex universe and fine tuning the performance of universes.
• Designed, Developed and Maintained Universes by defining joins, cardinalities between tables applying contexts and alias tables to remove cyclic dependencies
• Maintained developed applications, and handled the change requests to modify existing Deski, Webi reports and universes.
• Developed Web intelligence reports with complex calculations, Variables, Breaks, Sorting, Drill down, Slice and Dice and Alerter.
• Used Xcelsius to build Dashboard reports for top level management
• Created and maintained several web intelligence reports for the client using Business Objects Web Intelligence.
• Worked in a production support role where in typical issues has been resolved.
• Designed, developed and tested reports based upon data generated by enterprise transaction, customer information system using Business Objects
• Monitoring and maintenance and troubleshooting BO server issue.
• Used Life Cycle Manager to create, copy, Edit and scheduled a job and maintained & managed different versions of the same document using Life Cycle Manager.
• Validated the installation by checking the public folders, Reports in Personal folders, Groups, Row level security, Scheduling and by running some sample reports.

Skills Utilized: Business Objects Enterprise XI R3.1, Universe Designer, Info view XIR3, Web Intelligence, Desk top Intelligence, Xcelsius 2008, Oracle 10G, Windows Server 2008, MS SQL Server 2008.

Confidential, VA

Responsibilities:

• Review and study requirements gathering and business analysis and Data analysis JAD and pre JAD session interacted with the end user.
• Formulated the process of reports to improve the business intelligence of the organization.
• Utilized statistical tools, based on historical data, to forecast the outcome of implementing certain business strategies
• Review Physical design, defined data types, Constraints, Indexes.
• Designed the Data Mart defining Entities, Attributes and relationships between them.
• Build Complex SQLs/View in order to create reporting data mart in DW
• Involved in requirement gathering and performed ETL Process.
• Created Dimension Tables and Fact Tables based on the warehouse design.
• Integrated various sources in to the Staging area in Data warehouse to Integrate and for Cleansing data.
• Performed Data Profiling and Data Quality.
• Used ERwin for data modeling.
• Involved in building of the Data Warehouse which includes the Design of Data mart using Star Schema
• Created and maintained several custom reports for the client using Business Objects
• Generated reports using BO tools querying database.
• Created List Reports and Cross Tab Reports and Drill Through reports.
• Worked on Dimensional modeling to design and develop Star Schemas in Universe Designer.
• Worked with the Business users in generating Canned & Ad-Hoc reports for business use.
• Developed complex SQL codes at the database level Oracle 10g and Teradata.

Skills Utilized: Business Objects Enterprise XI R3.1, Informatica Power Center 7.1,Universe Designer, Infoview XIR3,Web Intelligence (Webi), Oracle 10G, Teradata, Apache Tomcat, and Windows Server 2008, Import wizard.

Confidential, NY

Responsibilities:

• Studying the Data model during requirements gathering and interacted with end user for through understanding of the business requirement and creating reports.
• Extensively used SQL for accessing and manipulating database systems
• Participated in Design walk-through with SME's to baseline the business architecture.
• Worked closely with QA and Developers to clarify/understand functionality, resolve issues and provided feedback to nail down the bugs.
• Used sessions, workforce for running and loading the data from source to target data warehouse.
• Designed, created and maintained Universes and created complex reports in DeskI and WebI.
• Created and maintained the universes and reports with formulas and techniques, migrated from development to test and to production environment.
• Created standard and Ad hoc reports using Business Objects
• Worked the Import Wizard extensively to import existing user accounts, groups, categories, WebI documents, universes, connections and universe restrictions to move from one environment to other.
• Maintained the users and groups within multiple Global projects for application level security management.
• Published and scheduled reports/documents in Business Objects environment.
• Utilized performance tuning of reports in production environment, by tuning queries.
• Converted Deski reports to Webi Report using Report conversation tool.
• Created documentation for developed reports and simultaneously worked on multiple projects.
• Developed parameterized reports, which can be emailed and exported to User in Excel and PDF formats.
• Manage promotions between environments, version control and rollback functionality and dependency checking using CVS
• Xcelsius Various other forms of dashboard development, Data from Universe using QAAWS, Data from Webi reports, Crystal Reports using Live Office etc.
• Scheduled and maintain reports using CMC

Skills Utilized: Business Objects Enterprise XI R2/R3.1, Web Intelligence (Webi), Desktop Intelligence (Deski) Universe Designer, Info view XIR3/R2, and Oracle 10G, Apache Tomcat, and Windows Server 2003.

Confidential, NY

Responsibilities:

• Participated in Requirements Gathering and Business analysis
• Created and maintained complex Universes, classes, objects, conditions, joins and prompts.
• Converted the data mart from Logical design to Physical design, defined data types, Constraints, Indexes
• Maintained developed applications, and handled the change requests to modify existing Deski, WebI reports and universes.
• Developed reports with complex Calculations, Variables, Breaks, Sorting, Drill down, Slice and Dice and Alerter.
• Migrated Business Objects Universe and Reports from versions 6.5.x to Business Object Enterprise XI R2 version.
• Created users and groups and applied row level and objects level securities and object securities using CMC.
• Managed and configured Servers (File Repository Server, Report Application Server, Web Intelligence Server, Destination Job Server, Program Job Server, Event Server)
• Created reports using Business Objects functionalities like queries, slice and dice, drill down, cross tab, master detail reports, formulas, etc.
• Scheduled the reports to run daily, weekly and monthly, distributed the reports to the users via e-mail.
• Monitored failed reports. Exported reports in Excel, PDF and saved on Shared Network drive, e-mailed to users as per the requirements.

Skills Utilized: Business Objects Enterprise 6.5/XI R2, Info view XIR2, Web Intelligence (Webi), Desktop Intelligence(Deski), Universe Designer, SQL Server 2005,SQL,IIS6.0, Visual Source Safe and Visual Studio.Net 2005,Windows Server 2003.

Confidential, New York City, NY

Responsibilities:

• Developed full client and WebI reports using Business Objects version 6.5.
• Gathered user-requirements/feedback, implementing them in reporting applications, testing, QA and delivery.
• Designed, created and maintained Universes.
• Trained power users to take advantage of the Business Objects environment for Ad Hoc query and report development.
• Created reports using two universes and multiple linked queries, Calculations, Variables, Breaks, Sorting, Drill down, Slice and Dice, Alerters, and Formatting Presentation Styles (Graphical).
• Documented report functionality for production support.
• Designed and developed reports using commands in report designer and passed data dynamically to designed reports using record set. The record set contains the user-selected parameters in the query. The reports generated run very quickly, as the query is applied at run time to the report.
• Created custom reports me.e. passed data to Excel application based on run time parameter selection from VB Application.
• Created Complex Universes and linked with the existing universe as needed.
• Managed cluster environment for better load balancing of various jobs for better server response times.
• Scheduled the reports using BCA.
• Handled Reporting Help desk support. Managed User cases using User Ticket Management System Software and escalated cases to other groups.
• Administered of Business Objects Enterprise Production Environment.
• Extracted data from various databases for developing reports.

Skills Utilized: Business Objects Enterprise XI, Business Objects 6.5,Webi 6.5,Infoview, Crystal Reports 7.0/ XI, SQL Navigator, Oracle 10 G, Crystal report 7.0, IIS6.0,Windows Server 2000.