SUMMARY:

• Skilled professional with more than 9+ years in Business Intelligence Systems Analysis, Design, Development, Implementation, and Maintenance.
• Expert in multiple Business Intelligence platforms like SAP Business Objects, Design Studio, Lumira, Tableau, SAP Dashboard Design, Xcelsius, Qlikview, DOMO and Microstrategy.
• Expert in multiple Data Integration platforms like Informatica, DOMO and IBM Data Stage. Have overseen the mapping of multiple data sources, data movement, interfaces, and analytics with the goal of ensuring data quality. Well versed and experienced with SDLC Life Cycle Process and Agile Development methodologies, as well effective at building relationships with Business Process Owners, Leads, and individual contributors to deliver value added reporting tools.

TECHNICAL SKILLS:

Business Intelligence Tools: SAP Business Objects 4.1/3.X, Xcelsius, Tableau,Qlikview, DOMO,Microstrategy and Crystal Reports

ETL Tools: Informatica and IBM Data Stage

Databases: Netezza, DB2, Oracle, SQL Server, Sybase, Teradata, SAP HANA

Data Modelling Tools: ERwin and Power Designer

Cloud and Data Science Technologies: Python and R Programming.

Test Management and Scheduling Tools: Manual Testing, TOAD, SQL Developer, HPQC, HPALM, CQSR, Control M and IBM Rational Team Concert

Versioning Tools: Borland Star Team, PVCS and Ebiexperts Version Manager

Methodologies: Waterfall, Agile Methodology, SDLC and Scrum

Industries: Engineering, Pharma, Sales/Marketing, Medical, Learning &Development, Aviation and Federal

Operating Systems: Windows and UNIX

PROFESSIONAL EXPERIENCE:

Confidential, washington dc

BI Architect/Business Objects Lead

Responsibilities:

• Gather requirements and analysis of multiple source systems data like Relational, Click Strems and portals
• Interacted with the business users to understand the requirements.
• Analyzed the business requirements and designed the best suited solution.
• Prepared the project proposal documentation and implementation plan as per Agile methodology.
• Preparing Business Objects - Database mapping document.
• Act as an SME for BI reporting team for resolving technical complexities.
• Provide support to Business Objects(BOBJ) enterprise environment.
• Provide support in building and tuning complex SQL statements.
• Involving in dimensional data modeling.
• Involved in developing Business Objects universe using SAP Business Objects Universe Design Tool.
• Involved in creating OFLC management reports using SAP Business Objects Web Intelligence (WEBI) reporting tool.
• Developed Tableau dashboards for higher management in Agile methodology.
• Provide expertise in advance analysis, SOA design, development, implementation, deployment, and maintenance of BI applications
• Support application development and architecture using Business Objects.
• Designed and developed QlikView dashboards and DOMO dashboards as part of an organizational IT initiative.
• Create PDF push reports using Qlikview report editor.

Datawarehousing / SAP Business Objects Lead

Responsibilities:

• Gathered business requirements and understood the existing business processes related to HR Employee Services (HRES) business.
• Analyze the requirements and Create URS and SOW documents, estimation sheets and getting sign off from the end users.
• Involved in analyzing and development of the Data Warehouse.
• Involved in Relational and Dimensional Data Modeling Techniques to design ERWIN data models.
• Created technical design specifications for mappings, sessions, workflows, etc.
• Worked on different OLTP data sources such as Oracle, SQL Server and Flat files for data extraction.
• Created complex mappings in Informatica PowerCenter Designer using Aggregate, Expression, Filter, Sequence Generator, Update Strategy, Rank, Sorter, Lookup, Joiner transformations etc.,
• Implemented Type II slowly changing dimensions using date-time stamping.
• Created reusable transformations and mapplets to reuse while creating ETL mappings.
• Configured and used the Debugger to troubleshoot the Informatica mappings.
• Proficient in using Informatica workflow manager, workflow monitor, pmcmd (Informatica command line utility) to create, schedule and control workflows, tasks, and sessions.
• Worked on Data Stage 9.X to create Data Stage jobs for populating the data into the Datawarehouse constantly from different source systems and scheduled the same using DataStage sequencer for SI testing.
• Worked with DBA team to fix performance issues at Database.
• Wrote SQL, PL/SQL, stored procedures for implementing business rules and transformations.
• Preparing BO-Database mapping document.
• Change the existing Universe to support development of the new WebI reports using Business Objects.
• Developed 50+ Web Intelligence reports and 20+ Dashboards.
• Testing and supporting UAT for the developed reports.
• Followed best practices and guided the client in preparing their BI road-map.
• Prepared user guide for SAP Business Objects application.
• Trained client side end users to be the power users in creating adhoc reports.
• Created Lumira analytical views for higher management using multi data sets.
• Promoted the content to Production environment and supported Production validation.
• Providing post-production support after promote.
• Created PL/SQL packages to support development of highly summarized management dashboards.
• Developed KPI dashboards using Xcelsius 2008, Microstrategy and Tableau.
• Designed Tableau workbooks, tableau reports and dashboards.
• Developed Reports and Dashboards in Agile methodology.

BI Lead Developer / Senior Business Objects Consultant

Responsibilities:

• Collaborate effectively with operations Managers and Business Analysts to gather requirements.
• Design, Develop and test Crystal Reports based on detailed specifications.
• Creating project related documents and testing documents, release notes, Change request forms as per industry standards.
• Develop and test PL/SQL code for developed crystal reports using Oracle PL/SQL Developer.
• Propose and design optimized solution for complex reports using analytical and specialized technical skills.
• Modifying existing complex reports based on functional changes.
• Create parameterized crystal reports using tables, queries and verify joins between them.
• Created crystal reports for Details, Summary, Cross-tab reports using filters, Sorting, Groupings based on different fields.
• Participate and contribute in daily SCRUM meetings to achieve organizational goal as team and as an individual.
• Worked on modification of Universes.
• Developed WebI reports using various functions, operators, report filters and variables.
• Developed the WebI reports and created live office objects to these reports.
• Worked on Conceptual design of the Dashboard.
• Involved in Data Connectivity to the databases using Query as a Web Service (QaaWS) connections and XML connections.
• Worked on the Performance tuning of the Dashboard.
• Worked on Designing the Dashboard according to Color style guide given by client.
• Conducted Unit Testing of the Dashboard.
• Worked on Change Requests of the existing Dashboards.

Senior Business Objects Analyst

Responsibilities:

• Creating WEBI reports according to the business requirements/ rules using Business Objects WEBI.
• Communicating with the onshore people in understanding the healthcare requirements.
• Involved in developing the Business Objects universes and implementing the universe features to improve the performance using Business Objects Enterprise universe designer tool.
• Making change in the Business Objects universe level to add more objects or to do some modifications in the universe level.
• Involved in creating web intelligence (WEBI) reports.
• Implementing CRP Changes as per client.
• Linking universes as per the end user requirements.
• Involved in ST / UAT phases and resolving bugs for the tickets raised through JIRA.

Senior BI Developer

Responsibilities:

• Gathered business requirements from Business users.
• Designed and implemented appropriate ETL mappings to extract and transform data from various sources.
• Designed and developed Informatica ETL mappings to extract master and transactional data from multiple source systems.
• Installed and Configured the Informatica Client tools.
• Worked on loading of data from several flat files to XML Targets.
• Designed the procedures for getting the data from all systems to Data Warehousing system.
• Created the environment for Staging area, loading the Staging area with data from multiple sources.
• Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems.
• Used workflow manager for session management, database connection management and scheduling of jobs.
• Monitored sessions using the workflow monitor, which were scheduled, running, completed or failed. Debugged mappings for failed sessions.

BI Developer

Responsibilities:

• Analyzed the business requirements and functional specifications.
• Extracted data from oracle database and spreadsheets and staged into a single place and applied business logic to load them in the central oracle database.
• Used Informatica Power Center 8.6 for extraction, transformation and load (ETL) of data in the data warehouse.
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression and Lookup, Update strategy and Sequence generator and Stored Procedure.
• Developed complex mappings in Informatica to load the data from various sources.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Parameterized the mappings and increased the re-usability.
• Used Informatica Power Center Workflow manager to create sessions, workflows and batches to run with the logic embedded in the mappings.
• Created procedures to truncate data in the target before the session run.
• Extensively used Toad utility for executing SQL scripts and worked on SQL for enhancing the performance of the conversion mapping.
• Used the PL/SQL procedures for Informatica mappings for truncating the data in target tables at run time.
• Extensively used Informatica debugger to figure out the problems in mapping. Also involved in troubleshooting existing ETL bugs.
• Created a list of the inconsistencies in the data load on the client side so as to review and correct the issues on their side.
• Created the ETL exception reports and validation reports after the data is loaded into the warehouse database.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Created Test cases for the mappings developed and then created integration Testing Document.