SUMMARY

• 15+ years of IT experience in designing and developing Business Intelligence and Data warehousing solutions using SAP BOBJ, SAP HANA, SAP BW, MS - BI (SSIS, SSAS, SSRS),MDX, SAP Dashboards, SAP Lumira, SAP design studio, Predictive Analytics, QLIKVIEW, Crystal Reports, Informatica Have 4+ Years into Powerful In-Memory data visualization tool Qlikview/Qliksense
• Dash Board Manager/Xcelsius2008,Universes (UDT,IDT),Web Intelligence, Central Management Console(CMC),Central Management Server(CMS),Central Configuration Management(CCM),Query as a Web Service(QwaaS), Live Office, Business Explorer/Polestar, Publishing Wizard, Import Wizard, Life Cycle Manager and Report Conversion Tool
• Experience in writing Stored Procedures, Packages, Functions, cache managementand materialized views using PL/SQL, T-SQL
• Expertise in E-R Modeling. Multi-Dimensional Data Modeling techniques like Star Schema Modeling, Cube-processing, Dimension modeling
• Experienced in Agile / SCRUM and waterfall and well versed wif all phases of SDLC
• Solid business and technical acumen to understand the business requirements, architect, design and deliver end to end BI solutions, having the ability to meet deadlines, work under pressure and quickly master new technologies and skills.

TECHNICAL SKILLS

Business Intelligence: SAP BOBJ 4.1/4.0, XI R3.1/R2/6.5, Xcelsius, SAP Dashboard 4.0, SAP Crystal, SAP Design Studio, SAP Lumira, SAP BI/BW 7.0, MS-BI, Live Office, Predictive Analytics, QlikView, QlikSense

BIG Data: Hadoop Ecosystem: HDFS, MapReduce, Sqoop, Pig, Hive, Nosql

ETL Tools: Informatica (Power Center), MS-BI (SSIS, SSAS, SSRS),MDX, SAP Data Services

Web Technologies: . Net, C#,JAVA/J2EE, VB, Angular JS, HTML5,Web logic, SOA, Web Services

Databases: Oracle 11g, SQL Server 2012/2008, Teradata, SAP Hana, DB2

Operating Systems: Windows 2008/XP, Linux/Unix, AIX, SOLARIS

Scripts & Other Tools: Shell, Python, ERWIN, Source safe, Clear case, Toad, SharePoint, JIRA

PROFESSIONAL EXPERIENCE

Confidential, VA

BI ARCHITECT/SR.ANALYST DEVELOPER

Responsibilities

• Analyzed business requirements and built logical and physical data models that describe all the data and relationships between the data
• Involved in Business requirement gathering and Participated in Joint Application Development (JAD) process wif different Business Segments in designing SAP BO/SAP Dashboard, Qlikview/Qliksense Applications
• Createdcomplex webi reportsUsed Variables, User defined objects, Scope of analysis, Drill mode, Slice and dice mode, Prompts, and Conditions to make reports accurate and easier for analysis.
• Created Various complex dash boards in SAP Dashboards using Various selectors, Used Hyperlinks to Webi reports & URL's.
• Expertise inpredictivemodeling, data mining and related scenarios, data integration and mashing, and model optimization for testing
• PredictiveMaintenance, Forecasting Service/Maintenance Costs
• Administered Business Objects via CMC in terms of Access levels, Folders and Security Profiles in conjunction wif Active directory.
• Deployed BO Reports and its output in excel files to SharePoint portal for Non BO users.
• Scheduled and Published Webi reports in to emails.
• Developed several multi-source IDT universes referencing relational databases & Datamarts.
• Experience inQliksenseManagement Console in adding users, assigning tokens, creating security rules, streams, upgrading license and etc.
• Proficient in SET ANALYSIS to provide customized functionality inQliksenseApplications
• Implementation of security inQliksenseApplications at Document and row level.
• Used Functions Expressions and Set Analysis Expressions for data Analysis and used on various Visualizations.
• Worked on Document chaining inQliksensewif dynamic variables.
• Involved in full project life cycle implementation of QlikView dashboards. Designed & developed QlikView/Qliksense dashboards for Project Centers and delivered the End reports to the users using the Nprinting reporting tool wif QlikView
• Implemented ETL- Extraction Transformation and Loading by using QlikView three-tiered QVD architecture.
• Designed application for Finance & Marketing Modules that Generates GUI Report for easy access through the data
• Gathering data sources like QVD files, Excel, Oracle & SQL Server DM's, binary QVW, Inline and .txt files in developing the QlikView Data Models
• Engaged in developing Dashboard standards such as Template designs, User Interface and Navigation Design patterns. Worked on Demo of Prototypes (QlikView and QlikSense)
• Involved in Dashboard migrations from QlikView toQlikSense
• Developed dashboards included customer wif detail drilldowns, Cyclic grouping of measures, threshold gauges and alerting mechanisms.
• Implemented incremental load by creating QVDs and optimized the periodic data additions
• Created weekly PDF report distribution for a set of users using PDF Distribution functionality in QV Publisher
• Created tables, views, users, logins, indexes (indices), check constraints and business rules using T-SQL and maintained databases
• Fine Tuned Data Warehouses including the creation of materialized views, bitmap indexes and partitions
• Used SSIS Packages to extract transform and load data from multiple input sources like Excel files, Production SQL Servers into SQL Server Staging Database
• Extensively used various SSIS Objects such as Dataflow Components, Control Flow Elements, Connections Managers, Log Providers etc.
• Used SSIS tools like Import and Export Wizard for developing the packages, Performed data mapping and transferred data from staging tables to database tables using SSIS transformations.
• Implemented SSIS transformation like Lookup transformation, Derive Column, Conditional Split, Merge Join, OLEDB Command, and Row Count
• Involved in writing T-SQL stored procedures, functions for generating various customer review SSRS & SSAS reports

Tools SAP Business Objects (BOBJ) 4.1 sp05, Web Intelligence, IDT, UDT, CMC, SAP Dashboards, SAPPredictiveAnalytics, Qlikview 11,Qlik Sense 2.1.1, QlikNPrinting, SQL Server 2014, SSIS, SSAS,SSRS, Sharepoint,JIRA

Confidential, Fanniemae, VA

SR.ARCHITECT/ANALYST DEVELOPER/Production Support

Responsibilities

• Done Fit gap Analysis and Analysed likely impact of Process modification, Gathered and analysed the requirements for dashboard and reporting, Built data models to support DB/ ETL teams.
• Good experience in Business Objects (BOBJ) Administration, Installations, Security Design, User & Content Management / CMC, Server Management, Migrations / Upgrades.
• Worked on Business Objects (BOBJ) Reporting & Universes - Universe Design (UDT), Information Design Tool (IDT), WEBI Reporting, & Xcelsius, Dashboards.
• Converting Universes .UNV to .UNX and setting up Universe security in Information Design Tool (IDT).Creating Multi-source universes and established Dynamic data connections in IDT.
• Migrated content from previous versions of - BO XI 3.1 to BO 4.0 / 4.1
• Converted Crystal Reports and Dashboards to Tableau
• Worked on Promotion Management to migrate WEBI reports from DEV - QA - PROD environments.
• Security implementation, creating Custom Access Levels (CAL) & assigning these levels to user groups.
• Troubleshooting issues and providing L2 & L3 support for the BO users & ITIL.
• Addressing the tickets opened in Remedy & ServiceNow for Process changes and reporting,
• published Webi Reports and Xcelsius dashboards to BO Platform and scheduled to the users Inboxes.
• Written Materialized views, Packages and Procedures, Functions in Oracle and Created ETL Mappings and Transformations in Informatica Power centre.

Tools SAP Business Objects (BOBJ) 4.0/4.1 - BO XI R3.1 SP11, Xcelsius 2008, Tableau, Remedy, Service Now, Informatica 9.5, Web logic, MS SharePoint, Clear Case, Oracle 11g

Confidential, DC

PROJ LEAD/ETL-DATA ARCHITECT

Responsibilities

• Responsible for Overall Project Management activities like Project Plan, Requirements Approvals, Weekly Status reports, meeting minutes/Action items etc
• Requirement gathering and elicitation for ETL andBOReports, Performed development or maintenance work on data models, data dictionaries, CRUD matrix, or other artifacts to maintain currency wif corporate standards, integration wif enterprise data architecture.
• Designed and developedInformaticamappings to load data from source systems to Staging and tan to Data Mart.
• Implemented ETL techniques like Update/Insert/Rollup while loading the data from staging to target
• Built Data marts in MS Sql server 2012 using SSIS, for Dashboard purposes.
• Actively involved in writing T-SQL Programming for implementing Stored Procedures and Functions and cursors, views for different tasks
• Performed tuning of SQL queries and rewriting queries to improve the performance of database
• Extensively worked wif SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Derived Column
• Involved in package migration from DTS to SSIS, running upgrade advisor against DTS Packages before migration, troubleshooting issues and conversion into SSIS through wizard and manually.
• Configured package logging, error logging and event handling to redirect error rows and fix the errors in SSIS.
• Development and installation of SAP BOBJ on a multi tier environments thus setting up Clustered deployments. Server administration, Installation of service packs and fix packs and Low availability fixes. Setting up SSO, Trusted Autantication
• Migrated All BO Web Intelligence Reports, Universes, Folders and users from BO XI 3.1 to BOBJ 4.0
• Setting up Access level permissions for Groups and Users and Implementing security.
• Implemented Section access security in Qlikview and Qliksense
• Designed and implemented Advanced security in QMC in terms of Rules and Conditions
• Used Functions Expressions and Set Analysis Expressions for data Analysis and used on various Visualizations.
• Used various data sources like QVD files, Excel, flat files in gathering data to develop the QlikView Data Models.
• Have been involved on modeling data as per business requirements.
• Dealt and eliminated synthetic keys, ambiguous relationship and circular loops.
• Created Dashboard using different components of QlikView like listboxes, multiboxes, slider, buttons, charts (Bar, Line, Combo, Gauge, Scatter, Straight/Pivot table)
• Built complex expressions using set analysis and functions in support of the dashboards
• Have knowledge of many QlikView Functions (Date and Time, Keep, Join, Mapping, String & input Fields etc ) used in projects to create Data Models.
• Used QlikView functions to load data viz Load, resident load, concatenate and so on
• Used QlikView Scripting and Complex SQL coding for loading, and transforming .

Tools SAP Business Objects (BOBJ) 4.0- BO XI R3.1 SP5,, Dashboard Designer 4.0,QLIKVIEW 11, Qlik Sense 2.0, Informatica 9.5, Power center, SQL Server 2008/2012, SSIS, SSAS, Tomcat, Web logic, Oracle 11g

Confidential, TN

ARCHITECT/SR.ANALYST DEVELOPER

Responsibilities

• Gathered and analyzed the requirements to replicate the ECC content using data provisioning.
• Established the best modelling and recommended strategies for BOBJ environment and architecture for SAP HANA.
• Installed BOBJ 4.0 and configured SAP and Windows AD autantication for Business objects enterprise, Integrated BOBJ 4.0 and BODS 4.0 wif SAP HANA1.0.
• Performed data modelling and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio.
• Provide global sales enablement for the BusinessObjectsanalyticssuite of products wif high emphasis on advancedAnalyticsincluding HANA and SAPPredictiveAnalytics
• Created web services for querying HANA database from external end user report portal using real time jobs in data services 4.0 designers.
• Developed the security model, Naming conventions, folder structure for HANA 1.0 and BOBJ 4.0 and established the recommended SAP best practices for developing Universes, reports and dashboards from HANA data sources.
• Created Universes on top of HANA calculation views and developed the Webi reports and dashboards using IDT (Information design tool).
• Resolved Chasm traps, Fan traps and Loop problems, Defined Hierarchies in Universe to provide the users wif Drill down option in reports and Predefined Conditions to use in Business Objects
• Identified the Metrics and sub metrics, Key performance indicators (KPI’s) for Dashboard development, Created Dashboards to monitor business performance, insightful analytics, and role based dashboards wif Xcelsius 2008.

Tools SAP BI/BO4.0, HANA 1.0 SP2, Xcelsius 2008, SAPPredictiveAnalytics, SAP ECC 6.0 and SQL server 2012, SSIS, SSAS, Oracle 11g

Confidential, DC

TEAM LEAD/BO ADMINISTRATOR/PRODUCTION SUPPORT

Responsibilities

• Participated in project planning sessions wif project managers, business analysts and team members to analyze business requirements and outline the proposed solution. Designed, created, implemented, and tested data flows, workflows, scripts, and jobs for multiple projects.
• Generated database monitoring and data validation reports in SQL Server Reporting Service (SSRS).
• Designed dynamicSSISPackages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Responsible for writing SQL queries, stored procedures, views, triggers, T-SQL and DTS/SSIS
• DeployedSSISpackages and Reports to Production Servers Migrated data using ETL Tool inSSIS.
• Worked on Migration of packages from DTS using SQL Server Integration Service (SSIS).
• Installed and Configured BO XI 3.1 in all the three environments (Dev, QAT, Prod) also Configured LDAP and SSO, Managed all the BO Servers and Clusters through CCM and CMC).Migrated BO content via BIAR files, in three environments (Dev, QAT, Prod) using Import Wizard for deployment purposes.
• Designed and developed Universes and reports in conjunction wif requirements (RDD & RSL),Implemented Role based security in Universe and Administered the CMC
• Worked extensively wif the major functionality of Webi as Breaks, sections, Group values, Sorts, List of values (LOV), Pre-defined conditions, Calculations and Ranking.
• Extracted the data from the Legacy systems and other RDBMS databases into staging area and populated onto Data warehouse.

Tools SAP Business Objects Enterprise XI 3.1 (CMS, Designer, WEBI Rich client, CCM, Publisher), Web logic, Apache server, SQL Server 2008( SSIS, SSAS, SSRS), Oracle 10g;Oracle BPM

Confidential, DC

ARCHITECT/PRINCIPAL DEVELOPER

Responsibilities

• Effectively interacted wif the end users for requirement gathering and defined requirement specifications document by access and retrieval of financial and personnel data from one single source
• Identified & Created Facts, Dimensions, and Hierarchies of the business model.
• Designed a Multi-Dimensional DW,DM and Cube (SSAS), SSIS packages
• Converted frequently use scripts into stored procedures and organized code into a structural, easy to follow pattern and standardized all process and coding.
• Designed and automated backup plan—data archive, restore and back-up processes wif simple one-line commands and/or package
• Developed table-driven process for indexing, configurations, development/production switch and incremental/full load processes.
• Developed training materials for end users—report builder and subscription in SSRS
• Created Business Objects Reports using stored procedures, freehand SQL, Excel as the Data providers and writing the complex queries including Sub Queries, Unions, Intersect and Aliases.
• Worked extensively wif the major functionality of Webi in terms of Breaks, sections, Group values, Sorts, List of values (LOV), Pre-defined conditions, Input controls, Drill, Calculations and Ranking

Tools SQL Server 2008 (SSIS,SSAS,SSRS),, Business Objects XI3, Universe Designer, CMC, Teradata

Confidential, MD

BI ARCHITECT/SR.ANALYST DEVELOPER

Responsibilities

• Gathered Business Requirements from Users & Business Analysts for data modeling, identified the gaps
• Designed and Developed Database Objects like Tables, Stored Procedures, Triggers, Rules, Defaults, user defined data types and functions for this project.
• Designed and developed DTS packages for transferring data from flat files and Access files
• Created linked servers between different SQL Servers and also created linked server wif different access files used across various departments
• Performing the ETL operations to support the data loads and transformations usingSSIS.
• Involved in migration from Oracle to SQL Server 2005 usingSSIS.
• Generation of reports from the cubes by connecting to Analysis server from SSRS.
• Used SQL Profiler for troubleshooting, Monitoring, Optimizing SQL Server and T-SQL statements from developers and testers..
• Activated Business Content for Accounts payable (AP), Accounts Receivable (AR), Profitability Analysis (PA), General Ledger (GL), Purchasing (MM), Cost Center Accounting (CO-CA) and enhanced them as per the client requirement.
• Created Multi source capital Reports as Senior Debt Report, Subordinated Debt Report, Equity Allocation
• Various Financial Management Reports have been created in the areas of Benefits, Costs, Funds flow and Cash flow, IRR
• Created Various Investments Reports as Buyouts, Growth, Acquisitions, Rapid Response, and ESOP Reports.
• Used the Import wizard to import existing user accounts, groups, categories, WebI documents, universes, connections and universe restrictions to BO XI r2 environment.

Tools Business Objects XI R2, SQL Server 2005/2008, SAP ECC 5.0, SSIS,SSAS,T-SQL, Crystal Reports 2008

Confidential, DC

ARCHITECT/SR.ANALYST DEVELOPER

Responsibilities

• Installed and configured Business Objects XI r2 using Tomcat and Apache as Application and Web Servers.
• Clusters have been remodeled in terms of their configuration, Backup of source have been done.
• Source and Destination environments have been set up for ETL Processes.
• Used the Import wizard to import existing user accounts, groups, categories, WebI documents, universes, connections and universe restrictions to BO XI r2 environment.
• Security objects have been manually recreated to retain the security model defined
• Gathered Business requirements through User sessions and prepared System requirement document.
• Co-coordinated wif DBA’s to deploy various stored procedures and Views to get the Schema.
• Extensive analysis has been done to design the Universe and assign them to respective groups.
• Various Webi and Full Client reports have developed to support the Red Cross chapter and response teams.
• Created Universe, Reports Documentation for end user training.

Tools B siness Business Objects XI R2 / Business Objects 6.5.1, Designer, Reporter, Webi, Supervisor, Auditor, BCA, SQServw Windows 2k, Siebel CAS, Oracle, Teradata,Informatica