SUMMARY:

Over 12+ years of software development experience specializing Business Intelligence Analysis, Design, Development using Business Objects suite of tools on both Relational Database Management Systems and data warehouse. Involve in development of various types of analysis, crystal reports, and web intelligence reports using Seagate Crystal Reports 7.x / 8.0 / 8.5 / 9.2/10/ XI R2/R3/4.0.Develop database Views, Procedures and Functions in support of reports. Excellent high performance reports building and deployment skills along with Installation, configuring (CCM), load balancing, managing objects (CMC) publishing reports (eportfolio), scheduling and ability to train end users and junior programmers as well. BOCP - SABE201 paper completed. Expert knowledge of latest tools and technologies including Big Data (Hadoop, Cloudera flavor) and Splunk

TECHNICAL SKILLS:

Languages: SQL, PL/SQL 2.3, SQL*Plus 3.3. C#.net

Operating Systems: MS-DOS, MS Windows98/95/XP/7, UNIX Sun Solaris, Windows NT, Windows 2000

RDBMS: Oracle Financials11i, Oracle 7x/8.0/8i/9i/10, Ms SQL Server 7.0/2000, Ms-Access 2000/2002

BI Tools: Crystal Reports XI/ 10/9.2/8.5/8.0/7.5 , Seagate Info Server, Crystal SQL designer, Crystal Analysis 9, Crystal Enterprise 8/9/10/XI, CMC, CCM/Business view manager, Universe Designer, SSIS, SSRS, Data Integrator, Netezza in memory database

Web Tools: HTML, ASP, Visual Interdev, Front Page 2000, JavaScript, CSS, Vbscript, adobe Photoshop, Flash

Other Tools: Data Integrator XI, MS Office suite of tools, TOAD, Rapid SQL

Big Data: Cloudera CDH 4

EXPERIENCE:

Confidential

Sr Reports Developer/Analyst

Responsibilities:

• Designing and developing custom, ad hoc and production reports in a Business Objects Enterprise and Oracle database environment. direct within a project team environment, analyzing data requirements and developing application programs to support the Reporting environment of a Financial Services line of business.
• Write and review existing Oracle 10g /PL/SQL with stored procedures on Unix Platform and use Business Objects Enterprise 4.0, including Crystal Reports utilizing both universe and stored procedures as data access methods.
• Review Dimensional data modeling, 0044ata Warehousing to make data is validated correctly
• Write scheduled and on demand adhoc reports using both Crystal Reports, Business Objects Webi and dashboards Integrate data from a variety of sources including BW into Universe for various reports creation Provide data for Business Analysts with their data/functional requirements
• Prepare operational intelligence dashboards using Splunk and assist in POC using Bid Data/ Cloudera.

Environment: SAP BOBJ, Crystal Reports 2008, Business Objects XI 3.1, Business Objects 4.1, Sql server 2012, SSIS, SSRS, Universe Designer, Information Design Tool, Business Views, Business objects Dashboard designer 4, JIRA, Confluence and Agile data warehouse management, IBM Clear Case, Clear Quest, Oracle 10g, Sun Solaris and PL/SQL, SAP BW, Splunk, Cloudera, Hadoop

Confidential, Atlanta, GA

Sr Business Intelligence Consultant

Responsibilities:

• Worked on complex financial reports which include business objects universe, web intelligence
• Helped move the accounting database schema from Oracle 11g to Netezza 6.5 for high performance
• Designed report specifications and mock ups for both web intelligence reports and crystal reports
• Help business choose RIGHT reporting tool for analytical reports and operational reports Quickly build reports, fix defects and help validating data and coordinate with ETL teams in fixing the data issues Migrated business objects universe, Webi documents, crystal reports and coordinate with all the developers and
• Established a standard migration procedure.
• Experienced inData Extraction, Transforming and Loading (ETL) betweenHomogenous and Heterogeneous Systems using SQL Server tools like SSIS, Bulk Insert, BCP and XML Experienced in creating Jobs, Alerts and scheduledSSISPackages Designed and implemented complex SSIS package to migrate data from multiple data sources for data analyzing Assist in developing business objects migration plan from BO XI 3.1 to 4.1

Environment: Crystal Reports 2008, SAP BOBJ, Business Objects XI 3.1, Business Objects 4.1, Sql server 2012, SSIS, SSRS, Universe Designer, Information Design Tool, Teradata, Business Views, Business objects Dashboard designer, JIRA, Confluence and Agile data warehouse management, IBM Clear Case, Clear Quest, Netezza, SAP Data Integrator

Confidential, Johns Creek, GA

Business Intelligence Consultant

Responsibilities:

• Wrote high level dashboards for C level managers and present them as well.
• Converting the legacy crystal reports and deski reports to webi documents Solved various crystal reports, Web intelligence reports performance issues
• Conducted report analysis for future enhancements Wrote technical specifications based on system functional specifications.
• Extracted crystal reports which were embedded in Microsoft Visual Studio custom application and making them
• Mentored better reporting practices to a team of report developers both onsite/offshore
• Recommend various reporting solutions to the team based on transactional and analytical systems Helped automate reports delivery and customization
• Chose various business intelligence products based on the stakeholder needs.
• Built migration plan to migrate business objects XI to business objects 4.1 which include report conversion, adhoc reporting, universe development/migration, data mapping and defining various ETL needs

Environment: SAP BOBJ, Crystal Reports 2008, Business Objects XI 3.1, Business Objects 4.1, Sql server 2012, SSIS, SSRS, Universe Designer, Information Design Tool, Teradata, Business Views, Business objects Dashboard designer, JIRA, Confluence and Agile data warehouse management

Confidential, Brentwood, TN

Sr. Business Intelligence Developer

Responsibilities:

• Working as senior business intelligence developer responsible for various reporting solutions, business objects server maintenance, customer support, user creation & system security, report development and system upgrades, coordinating with SAP on service requests.
• Coordinate with ETL team and data modelers to make accurate data available for reports
• Write Complex reports for various business requirements and mentor new report developers.
• Prepare report templates for a variety of users to save time and bring uniformity to the reports across the board Service Requests (Report, universe migration between environments) Made various forms of reporting tools and technologies available for users and vendors.
• Streamlined power user and gatekeeper security in business objects using active directory.
• Security management using both Enterprise and Active Directory Server Administration (Startup / Shutdown, managing the services) System Maintenance & Monitoring (Log analysis, backups and archival) Creation, Deactivation and decommission of new/old projects/folders
• Work with vendor SAP in obtaining fix for the product bugs/outstanding issues and apply fix provided by the vendor on
• Prepare technical documentation for various procedures and business requirements
• Usage analysis of System, User, Reports and others System performance Metrics capturing and analysis and share best practices Applying Fix Pack and Service Pack Periodic environment assessment and preparing performance improvement plan Manage Promotions of reports through the Development, Test and Production process Perform as a member on projects where Business Objects infrastructure expertise is required Coordinating tier1 and tier2 supports groups and providing them necessary support documentation to meet various
• Complete ownership of business object semantic layer.
• Build universes around Netezza in memory database and rebuild universe in business objects 4.1 to use Netezza
• Work with data modelers on redesigning data warehouse/data marts on Netezza database

Environment: Business Objects XI 3.1/4.2, Web Intelligence (Rich Client/Thin Client), SQL Server 2005/2008 DB2, AS 400, Universe Designer, Data Integrator, Talend, CMC, Remedy, Jira, Confluence, Oracle, Cisco Call Management, Crystal Enterprise, Crystal reports XI/2008, IBM Netezza and Aginity Workbench for Netezza

Confidential, Rochester, MN

SR Business Intelligence Developer

Responsibilities:

• Design, develop, implement and maintain data marts using Kimball’s data mart model
• Collect system requirements from various customers and stakeholders
• Create data models for various datamarts HR, Finance, SCM and generate DDL using Power Designer respectively Architect the report delivery architecture for webi, crystal, desk intelligence and dashboards
• Plan the interfaces using openDoc, c#.net and created parameter pages for complex reports Model the data mart for Internal
• Review Board which would help evaluate research papers and possible patents
• Create eRecruiting application for Human Resource for federal government equal opportunity employment provider Requirement
• Craft agile data warehouse project for human resources based on Lawson ERP Successfully implement Lawson 9.0 upgrade Designed “how to” training materials for various reporting tools ex: crystal reports, web intelligence Exclusively responsible for design, develop and implementation of semantic layer using business objects universesBusiness views, Sql server cubes and .net interfaces.
• Write ETL code using data integrator for HR, Finance modules of Magic project Associate SQL Server app DBA for Administer business Objects’ row level and column level security for the Magic projects integrate windows Active directory with Business Objects XI maintain active directory user groups using custom made .net application named EEA Testing the business objects xi environment using HP Quality center Preserve multiple versions of ETL code, semantic layer objects using IBM Clearcase
• Use IBM ClearQuest and Remedy to track various service requests
• Fashioned dashboard based on universes for C level managers Lead a group of 5 BI developers Actively testing Business Objects 4.0 before migrating to it from XI

Environment: SAP BOBJ, Business Objects XI R2, Crystal Reports XI, Data integrator XI, SQL Server 2000/2005, DB2, BO OLAPI, BO WEBI, Universe Designer, Data Integrator XI, Infoview, CMC, Business View Manager, EEA, visual studio 2005.net and C#.net, ASP.Net, SSIS, SSRS, entity frame works, Linq to SQL and SSAS, Qaws, agile dw/scrum methodology, SAP Data Integrator