| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
PHONE NUMBER AVAILABLE EMAIL AVAILABLEWork Authorization: Green CardClearance: Public Trust with FDAPROFESSIONAL SUMMARYSeasoned Business Intelligence BI Lead/Admin with 15+ years of experience in Federal, and private sectors within extremely sensitive environments; quickly understands the business issues and data challenges of client's organization and industry.Currently holds the Human & Health Services/Food & Drug Administration Public Trust Clearance, working at the Center for Drug Evaluation and Research on their BIMO project.Expert in Business Intelligence (BI) & Data warehouse (DW). Implemented projects utilizing ETL component for supporting data extraction, transformations and loading processing, utilizing enterprise-wide-ETL Solutioning tool and build Data-warehouse, Operational Data Stores and Data marts.Over 15+ years of experience in Software Design, Development, Implementation, Maintenance and production support of Business Intelligence and Database solutions and platforms Well rounded experience in architecture, development, migration, administration (management) of different Business Objects (BO) versions including 5.0, 6.5, XI R2 and XI R3, R3.1, 4.0, 4.1. Extensive experience in several turnkey Business Objects upgrades and migration projects.Strong knowledge in Relational Data Modeling Concepts Relational Data Sources, Database Design, Star schemas, Extended star schemas, Multi-Dimensional Modeling OLAP Data SourcesExperience in creating Tableau Dashboards with interactive views, trends, and drill downs along with user level security. Generated Tableau Dashboard with quick/context/global filters, parameters, and calculated fields on Tableau (7.x / 8.x)Strong knowledge in ETL tools experience of using Informatica 9.1/8.6.1 Power Center Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools Informatica Server, Repository Server manager.Extensive experience using DataStage such as Lookup, Join, Merge, Funnel, Remove duplicates, Aggregator, DB2 Enterprise, Oracle Enterprise, Sequential file, Dataset, File Set. Experienced in setting up Repository, querying the metadata using Query builder.TECHNICAL SKILLSReporting Tools: Tableau 9.0 (Desktop & Server), BO 4.1 SP3,SP2, BO 4.0 SP5,SP4, FP3, SP2, SP1/ XI R3.1/R3//XI R2/6.5, Webi, BOBJ Xcelsius, Crystal 2011/XI R2/CR 2008, BO Explorer, Crystal Enterprise 10.0/9.0/8.0,Dashboard Design, Design Studio, Business Explorer, BPC NW 7.0/7.5/10.0/10.1, SEM BW-BPS 6.0, SAP BW 3.5, 3.1, 3.0ABEx Query Designer, BEx Query Analyzer, BEx Web application Designer, Power BI, Power BI ProDatabases: SAP HANA, Oracles 11g,10g/9i/8i/7.x, DB2, Teradata, Teradata SQL Assistant, WMS, IMS/DB, SAP BW, MS SQL Server 2005/2000, SnowflakeOperating Systems: Windows, UNIX SUN Solaris, LINUX.Cloud Platform: Amazon Web Services (AWS), Azure, OpenStackLanguages: SQL, T-SQL, PL/SQL, HTML, C, VB Script, ASP, JAVA. Visual Basic, .NET. COBOL, JCL, VSAM, REXX, C, C#Web Servers: IIS, Apache, TomcatTools/Packages: WF Dev Studio 7.x, SQL LOADER, DTS, SSIS, Erwin Data Modeler, MS Visio, TOAD, SQL Plus, Microsoft VSS, Rational Clear Case, Informatica, iSQL, MS Project, CA 7/CA 11 Scheduler and MS Office, HANA Design Studio.Data Modeling: ERwin 4.0/3.xETL Tools: Data Integrator, SAP BODS 3.X,4.X, SSIS, Informatica 8.4, 9.6, 10.2 and Data Stage 8.5PROFESSIONAL EXPERIENCEFood & Drug Administration (FDA) Rockville, MDContractor BO Lead Jan 2021 - CurrentWork with the customers and Stakeholders to understand the system and data analysis work products and Specifications for Business Intelligence and Data warehousing applications and work with customers and other developers to determine the most efficient and cost-effective approach to meeting business requirements.Built the mission critical AESI Business Objects reports and Tableau dashboards for COVID vaccine monitoring with complex logic and used the reporting linking feature for summary and details reports.Built the database views for the new critical requirements for COVID vaccine symptoms for multiple scenarios from FDA key health advisors.Administer and maintain SAP BusinessObjects BI platform, including installation, configuration, and server management.Manage BO user roles and permissions, implementing security policies and ensuring data confidentiality.Provide technical support and training to end-users on BusinessObjects tool.Built Business Objects reports based on the new business requirements and developer complex dashboards in Power BI using the latest features and DAX measures and enhance the existing dashboards andWorked on the building the new staging schema and modified the informatica mappings, worklets, sessions and workflow for the VAERS data loadDesigned and implemented interactive dashboards that provided real-time insights into trial progress, subject enrollment, data discrepancies, and regulatory compliance metrics.Monitored the critical informatica jobs on daily basis and worked on the performance tuning for the slow running jobs.Consulted with DevOps team to integrate business intelligence assets into future development lifecycles.HHS (Health & Human Services) Rockville, MDContractor BO Lead May 2020 December 2020The Business Intelligence and Analytics Support Services Information System (BIASS) project aimed to develop a robust platform to enhance data-driven decision-making across the organization. The system integrated various data sources to provide comprehensive analytics, reporting, and visualization capabilities, supporting strategic initiatives and operational efficiency.Collaborate with Customers and Stakeholders to understand the system and data analysis work products and Specifications for Business Intelligence and Data warehousing applications and work with customers and other developers to determine the most efficient and cost-effective approach to meeting business requirements.Development of new, or modification of existing, metadata describing data structures and encodings to facilitate end-user discoverability and understanding.Responsible for designing, developing, and maintaining management, clinical and analytical reports using Business Objects CMC, Info view, Web Intelligence, Deski, and Universe Designer.Work with business analysts and users to create 128 Standard, Crosstab, Sub, and link SAP Business Objects Report (Creating new reports and update or convert existing reports).Develop Business Objects reports and Tableau dashboards for customer requirements, providing advice and insight into different metrics, validating the accuracy and completeness of data captured in customer systems, troubleshooting data outliers, analyzing complex data sets, and automating reporting and data requests.Established data governance practices to ensure the accuracy, security, and compliance of data used in reporting and visualizations.Monitored Tableau dashboard performance and user engagement, using analytics to inform iterative improvements to the reporting and visualization processes.Participating in defining data quality, data warehouse, Data Migration and Data Integration, Star/Snowflake Schema Designs with requirements analysis-definition, database design, testing and implementation, and Quality process.Building reusable SSIS ETL Jobs across Data Conversion, Data Migration, Data Integration, Data Warehousing and BI projects with good planning, estimations record.Active role in quality assurance (QA), Perform load testing and performance testing, integration testing and user acceptance testing (UAT) for data and solution initiatives by providing test plans and testing support, attending team meetings, and providing required documentation.USAA Plano, TXBO Lead Contractor June 2018 March 2020Collaborate with application developers, business owners, and operations to ensure the creation of production Business Intelligence designs and implementations.Designed and implemented data warehouse for UDA (User Defined Application). Subsequent data marts, extracts and reports were sourced from the architecture of conformed facts and dimensions.Develops strategies for Report implementation, data acquisition, and archive recovery. Participate in development and configuration projects for a broad set of solutions including transactional and repository reporting applications.Designed, developed, and tested SAP Bex, Web Intelligence (WebI), and Design Studio reports, for multiple USAA customers. Converted reports from Deski to WebI. WebI reports were against SAP BW and Oracle RDBMSperformance of campaigns and in-market tactics Build reports using ETL functionality and data visualization tool (SAP Business Objects)Involved in performance tuning and optimization of Business Objects Universes by creating Aggregate tables.Delivered Business Objects Universe for the GSD group using Information Design Tool which included semantic layer, dimension, measure, Navigation paths, @Prompt filter, LOV.Created reports using Business Objects functionalities like Multiple Data Provides (Merging), Prompts, Slice and Dice, Drill Down, Cross Tab and Master Detail. Created complex queries in Desktop Intelligence and Web Intelligence including complex conditions (wildcard characters, In list, different from), subqueries and grouping conditions.Consolidated multiple Tableau workbooks into single workbook for PnC group single source Tableau report central.Created Crystal reports and Tableau dashboards to identify deltas in actual metrics vs. forecasting for different lines of business.Developed Sales Funnel dashboard using SAP Design Studio. Resolved the data challenges required for the Sales dashboard and provided a single source of data for visualization.Designed, developed, and implemented a BI solution for Sales, Product and Customer KPIs.Created scripts to migrate workflows from Informatica version 9.6 to version 10.2, while migrating database to Snowflake environments with dry run testing.Managed both onsite and offshore development team and resolved defects in dashboards and reports by 90% depending on business requirement.Quickly and effectively diagnose and respond to service desk requests regarding data integrity and functional or interactive issues in existing dashboards.Change Healthcare (Mc Kesson) Alpharetta, GAContractor - Business Objects Architect June 2017 - May 2018Migrated from Business Objects 3.1 to BO 4.2 on a ten-node server including Business Objects metadata from Oracle 10g to SQL Server 2011 Database to help with the migration to BO 4.2.Administer Business Objects setup and maintain security model for business objects, set up authorization and authentication. Successfully configured HANA to connect to BOBJ.Supported the development and validation required through the lifecycle of the DWH and Business Intelligence systems, maintain user connectivity, and provide adequate security for data warehouse in high transaction environments.Created Tableau Landing page for the Server, using multiple Tableau JavaScript API like User Authentication, retrieving all user information including Images from Tableau Server.Performed application-level DBA activities creating tables, indexes, monitored and tuned Teradata BTEQ scripts using Teradata.Developed data interfaces for BW HANA using SLT, BODS and ODP technologies.Developed various HANA Information Models, Attribute Views, Analytical Views, Calculation Views, SQL Scripts.Integrated Tableau Dashboards on web application with the help of Tableau JAVA Script API. Administered user, user groups, and scheduled instances for reports in Tableau.Troubleshoot and solve Ad-Hoc requests by solving problems using Tableau and Microsoft SQL server.Extracted data from flat files and then transformed according to the requirement and loaded into target tables using various stages like sequential file, Lookup, Aggregator, Transformer, Join, Remove Duplicates, Change capture data, Sort, Column generators, Funnel and Oracle Enterprise.Developed processes using the ETL tool and PL/SQL scripts to build and populate the fact and dimensions tables for the data marts used in the BI projects so that the Acuity application can perform reasonable sizing. Ensure timely delivery of Impact Analysis Statements.Performed BW back-end Requirements gathering, Data Modeling, Extracting, and loading data into SAP BI Query designer consumed by BOBJ Webi BO.The World Bank Group Washington D.C.Contractor - Senior BI Contractor Dec 2016 - May 2017Developed simple queries to more complex reporting queries using Business Objects.Involved in design and architecting landscape of the complete BW system and solutioned challenges of business users utilizing SAP Business ObjectsGenerated multiple Enterprise reports (SSRS/Crystal/Impromptu) from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports etc.Monitored and tuned database resources and activities for SQL Server databases.Defined Business Objects Classes, Objects, in the Universe, defined Cardinalities, Contexts, Joins and Aliases and resolved loops in Universes using Table aliases and contexts.Responsible for developing new reporting applications and enhancements of the existing applications. These applications were built using SAP Business Objects, Crystal reports Business Objects Data Services and TableauCreated parameter files for all the designed mappings and used parameter files for defining all the connection values (Source, Target, Lookup) and mapping parameters used in the Informatica sessions.Provided Production support for existing reports and dashboards requiring extensive analysis and troubleshooting of reported issues including performance enhancements.Configuration of SSO from R/3 to Portal and between Portal systems.Food and Drug Administration Rockville, MDContractor - Sr.BI Contractor Mar 2016 Dec 2016Developed Business Objects Universes & reports of varying complexity having multiple views serving multiple audiences of FDA project. Contributed to detailed design documentations for Business Objects /Crystal Reporting.Created several complex Web Intelligence (on demand Adhoc Reports, Frequency Reports, Summary Reports, Sub Reports, Drill-Down, Crosstab, Graphs/Charts) reports to help management to track and monitor contract, and compliance by using Business Objects functionalities like Queries, Drill down, @Functions, Cross Tab, Master/Detail, Slice and Dice, User Response function and different Formulas etc.Designed and deployed rich Graphic visualizations with Drill Down and Drop-down menu option and parameters using Tableau. Prepared Dashboards using calculations, parameters in Tableau.Created Crystal Reports with a back-end Oracle Database. Writing SQL queries for reports used for Credentialing.Developed jobs processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse databases.Implemented the Object-Level Security and Row-level security in Universe. Implementing the Table Mapping in Universe to restrict certain data in a table to only one group of users.Bloomberg BNA Arlington, VAContractor - Business Objects Lead Dec 2014 - Feb 2016Led the effort to in building data warehouse for Forecasting, Marketing, Sales performance reports. The data is obtained from Relational tables and Flat files, involved in cleansing, and transforming the data in the staging area and then loading into Oracle data marts. This data marts/Data warehouse is an integrated Data Mine that provides feed for extensive reporting.Managed Enterprise Reporting portal housing 700 critical reports hosted on the SAP Business Objects platform. Continually enhances KPIs and dashboards.Created and modified Applications by adding new Members and updating Dimension properties.Developed BAdI for Master data enhancement using the standard BAdI implementation UJD ROUTINE.Created the Input Forms using EPM functions EPMDIMENSIONOVERRIDE, EPMMEMBERID, EPMCONTEXTMEMBER, EPMMODELCUBEID, EPMSAVE, EPMMEMBEROFFSET, etc.Proper analysis of data included identification and enforcement of standards to ensure consistent and maintainable queries and reporting SQL data through Excel.Develop and maintain Tableau dashboards to specifications provided by Application and Data Managers as well as end users. Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.Successfully developed user concept strategy for internal and external users accessing SAP Enterprise Portal to access BOBJ live reports from WEBI, Office Analysis and Tableau from BW and HANA DATABASE.Involved in testing the Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.Created new universes using IDT 4.0 i.e., creating local project, connection and publishing, Data foundation layer and Business layers. Maintaining existing universes (.unv) using IDT and universe designer across different business domains.Developed customized Web Intelligence reports which included merged dimensions, sections, breaks, graph, sub-reports, unions, sub-queries, report filter, breaks, and custom sorts.Performed various database programming tasks such as creation of views, stored procedures, and user functions on Microsoft SQL server using T-SQL.Worked with Crystal Reports XI for creating complicated reports including sub-reports, parameter-based reports, graphical reports, formula based, well-formatted reports, drilling reports, analysis reports, data reports along with LOV.Developed Complex mappings in Informatica to load the data from various sources using different transformations like Source Qualifier, Look up (connected and unconnected), Expression, Aggregate, Sequence Generator, Joiner, Union, Filter, Update Strategy, Rank and Router transformations.Utilized Informatica Team based development (Versioning). Used Informatica versioning to check in and check out the objects in designer and workflow manager.Designed Web based Crystal Reports user interface, security system interface, and parameterized reporting Used Web intelligence to create, edit and set different options for the corporate documents.Federal Aviation Administration Oklahoma City, OK, Washington DCContractor - Business Intelligence Lead /Admin June 2008 Nov 2014Implement and modify Business Object Central Management Console and management of complex reporting environments. Lead the development of SAP Business Objects Performance Management solutions with Xcelsius or Design StudioResponsible for successful delivery of functional and technical components of Business Intelligence (BI) reporting solutions using SAP HANA In-Memory Computing with data from existing legacy environment.Led the migration of Business Objects Environment from 6.5 to XIR2 and XIR2 to XIR3 and XIR3 to BI 4.1 using migration tool.Facilitated meetings across departments for implementing a standard architecture for deploying Business Objects across the enterprise.Developed Complex mappings in Informatica to load the data from various sources using different transformations like Source Qualifier, Look up (connected and unconnected), Expression, Aggregate, Sequence Generator, Joiner, Union, Filter, Update Strategy, Rank and Router transformationsTranslated the logical models into an optimal physical model that performs efficiently under various load profiles is critical for the successful data integration initiatives.Designed Business Objects Universes for star schema and snowflake schema data models.Developed Hierarchies to support drill down reports in Desktop Intelligence tool.Create Business Objects reports utilizing functionalities like Queries, Slice and Dice, Drill down, @Fucntions, Cross Tab, Mater/Details and Formulas etc.Created solution driven dashboards by developing different chart types including Crosstab, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau Desktop.Plan, design, and implement application database code objects, such as stored procedures and views.Implemented the URL reporting for crystal reports from different web applications for FAA.Design and Development of Custom Infocubes, ODS objects, Multi Providers, Infosets and master data objects.Worked with Informatica Labels in labeling the designed components for deployment of code to TEST and PROD.Create ad hoc queries, scripts, and macros, update existing queries, create new ones to manipulate data into a master file.General Cable Highland Heights, KYBusiness Objects Developer / Administrator April 2007 June 2008Developed Webi reports which include summary reports with higher level data and detail reports which can drill down from the summary reports.Involved in Building the replica of the PROD box on a VM for testing purposes which included building the new CMS and configuring the Windows AD with Business Objects Enterprise using Kerberos.Migrated universes and reports from 6.5 to XIR2 using single pass using the Import wizard.Involved in implementing the single signon for the Business Objects Enterprise using Windows AD and VintelaVerinon Technology Solutions Chicago, ILBusiness Objects Developer Oct 2006 Mar 2007Developed a universe that contains the detail and summary tables. Worked extensively with @functions (@select, @prompt, @where and @aggregate aware) in the process of building the universe.Developed Canned Reports, which includes Trending reports, Drill-Down Reports, Drill across Reports and published them as Corp Documents.Generate complex reports (Crystal Reports) to application development management on a regular and timely basis.EDUCATION: MS Electrical Engineering, University of Hartford; 2006 |
