SUMMARY:

• 17 years of experience in developing BI Architecture solutions for Financials, Healthcare, Telecom, Insurance & Real Estate, Logistics, Civil Service and Pharmaceutical industries.
• Extensive implementation of database application architecture which includes requirements gathering, data modeling, ETL, development for OLTP and OLAP RDMS, Cloud applications (SaaS), data governance, and virtualizations via Apache Hadoop and Spark analytics from project inception to delivery per business specifications
• Experience in designing Mid to Large level Data Warehouse Systems utilizing Star and Snowflake Schemas for RDBMS systems using Oracle Warehouse Builder, Informatica 10.1.x/9.6.x, SQL Server SSIS 2008/2005/2000, and custom - built modeling and development
• Implementation of Extract, Transformation, and Loading (ETL) of data with customized solutions, and/or tool facilitated with Informatica, DataStage, SAP Data Services, SQL DTS packages for ETL
• Worked extensively in developing Procedures, Packages, Triggers, Views, Materialized View Logs on databases like Oracle 12cR2, 11gR2, 10g, 9i, 8i, SQL server 2008/2005/2000 /7.0, MySQL, IMB DB2, Pervasive and Access
• Lead development team on Oracle applications architecture using UML tools Visual Paradigm 11, Erwin for Financial Trading platforms (Waterfall, SDLC)
• Assist in large migration projects from proprietary databases into Oracle 11gR2 warehouse using combination of Oracle Golden Gate replication, custom ETL framework, Informatica 10.1x, SQL Server Reporting (SSRS), Business Objects Data Integrator
• Expertise in planning, implementing and delivering business intelligence solutions for CRM/ERP projects
• Working extensively in developing and implementing BI reporting solutions on SAP Business Objects R4.x/R3.1/XI R2/, SAP Crystal Reports Server 2011/2008/XIR2,4.x, SAP Crystal Reports IDE 2016/2011/2008/ XIR2/ 10/9/8.5, Web Intelligence 4.2/3.1/XI, Desktop Intelligence, BO Information Design Tool, SAP BOE Universe Designer, Tableau 2018.1, Microsoft Power BI using M-scripting
• Implementation of customized processes for rule extraction, rule analysis, rule flows, and rule base design for database applications/architecture with detail storage for both qualitative and quantitative analysis
• Installed and configured Tableau 2018Server, SAP BOE Server R4.2/R3.1, SAP Crystal Reports Server 2011/2008/XI R2 on Windows 2008/Linux Servers.
• Knowledge of programming/script languages like PL/SQL, SQL, T-SQL, Visual Basic, J2EE, Python, Perl+
• Knowledge of interactive dashboard tools: Tableau 2018, Xcelcius 2008, Crystal Reports Dashboards on stand-alone reporting and/or web portal/server integration
• Expertise in gathering and preparing project specifications, database design, modeling, system requirements.
• Experienced in documenting different stages of developing database applications and/or reports and setting them up on Oracle/SQL server databases, and/or SAP Business Objects XI R4.x/R3.x Server or SAP Crystal Reports 2016/2011/2008/ XI R2 Server respectively
• Fair knowledge of web-based tools: JSON, DHTML, XML, Javascript, M-Scripts, JSP,HTTP/HTTPS, SSL, REST/SOAP
• Active team player and as an individual. Excellent Communication and interpersonal skills, innovative, self- motivated, fast learner, and articulate

TECHNICAL SKILLS:

Languages: SQL, PL/SQL, T-SQL, Java 2.0, Python 3.6-2.7, Visual Basic 2008/6.0, Structured Query Language (SQL). PL/SQL

Reporting Tools: Tableau 2018.1.2, SAP Crystal Reports 2016/2008/ XI/ 10/ 9/ 8.5; SAP Business Objects R4.x/3.1/XIR2, SAP BO Edge, Crystal Analysis 8.5,Visual Basic Crystal Reports, Oracle Reports 2.5. Business Objects XI/ 6/ 5, Crystal Decisions, Microsoft, Oracle Microsoft Visual Basic. Business Objects XI R2/ R3.x/ Crystal Reports Server 2008 / XI R2, Cognos 8.3 BI Server, Pentaho 3.0/3.5 BI Suite, Pentaho 3.0/3.5

Development Tools: SQL Developer, Home-Site, SQL Programmer, TOAD, ISQL, SQL Navigator, Visual Age 3.5. Visio, SQL Modeler, Visual Paradigm, Erwin Visual Caf, Rational Rose, TOAD, dbVisualizer 6.0, Visual Studio 2005/2008

RDBMS: Oracle 12c-8i, SQL Server 2008-2000, Sybase, DB2 Pervasive, Access, Hypersonic 1.8.3, Oracle, Microsoft SQL, IBM, Pervasive, Teradata, Oracle Warehouse Builder, Oracle Golden Gate

Web Expertise: JSON, HTTP/S SOAP/REST, ASP.NET, DHTML, XMLJavaScript, J2EE, C#, VS.NET, PHP, Flex, HTML, JAVA 2.0, JSP, ASP.NET,XML

Web/Application Servers: IIS4.0/5/6.0, Tomcat, Apache Server, BEA Weblogic 5.1/6.1, Windows 2003-2016 Server, BEA Weblogic 4.5/5.1/6.1

Operating Systems: Windows Server 2016-2008, Windows 7-10, UNIX, Red Hat Linux 5.11-2.6, IBM AIX, Ubuntu, Microsoft, Kernel, Red Hat

Other Tools: Salesforce CRM, Siebel, SAP BW, WebEx, GotoMeeting, Symantec Pc Anywhere, Vantive. TCP/IP, IPX, Putty, Siebel, Salesforce, SAP, Windows. Cisco, TS Client

PROFESSIONAL EXPERIENCE:

Confidential, Brooklyn, NY

Business Intelligence Architect

Technologies: Tableau 2018.1.x - 10.5, Oracle 11gR2, SQL Plus, Toad Data Point, Erwin, MS.NET 4.7.x, Informatica 10.2, QlikView, QIP, Red Hat Linux 6, Windows 7, JIRA, Business Objects 4.2, Control-M, GIT, XML, JSON, Alteryx, Info Works, IIS

Responsibilities:

• Lead the technical aspect and scope of the project for migration of the current legacy reporting and metrics data into OSKAR data warehouse for Tableau consumption
• Contribute to developing the new Tableau dashboard portal architecture (End-to-End) for each LOB
• Agile methodology/Waterfall approach
• Conduct daily SCRUM calls with project manager, SME’s, and development teams in associations with Sprint plans
• Coordinate and gather requirements via Skype calls with operations and development teams for individual lines of businesses in APAC, EMEA, and N.A regions
• Produce scalable planning and estimates to project managers, SMEs, and stakeholders within scope of the current requirements for each LOB’s and their product deliverables
• Conduct and participate in bi-weekly status calls with key stakeholders, and executive management
• Act as liaison between product team, operations team, and developments teams: - guide the technical requirements to the different development teams
• Create technical specs and stories using JIRA for development teams (Sprints, SCRUM)
• Engage in high and low level analysis for data mappings from SharePoint, QIP, Business Connect, QlickView reports that would progress into Tableau dashboards
• Create JIRAs and assigned other tasks to Ref Data teams primarily for data integration into data warehouse
• Code and Implement data integration jobs using Informatica 10.2 from source systems, SharePoint sites, and flat files into the data warehouse
• Create Control-M jobs for end-to-end, i.e., source file generation to warehouse to dashboard
• Utilized Alteryx to update .TDE files for instant data updates to the Tableau dashboards
• Lead technical requirements/scope with .NET development team for portal utilization, filter creation, and also developing and implemented data-security modelling around the dashboards
• Create support Universe and reports using Business Objects 4.2 for dashboard validations
• Generate documentations for data analytics ecosystems currently using with Tableau 2018.1.3/10.5, Client/Server, MS .NET web integration, Alteryx, Informatica and Business Objects 4.2

Confidential, New York, NY

BI/Data Architect

Technologies: Oracle 11g R2, Oracle Golden Gate, SQL Plus,Toad, Java 2, Visual Paradigm 11.2, Erwin, Informatica 10.1, Red Hat Linux 6, Windows 7, JIRA, Telnet/FTP, Business Objects 4.2, Crystal Reports 2016,Tableau, Control-M, GIT, Python 2.7.3, XML, JSON

Responsibilities:

• Gathering requirements from the finance team’s Head of Finance, Commercial and Strategy Quant analysts, Billing Manager, and application users which contributed to data model design
• Translating and developing high level and in-depth forex billing rules around Relationship Trading, Active Trading, Settlement Center, Swap Exchange Facility (SEF), and most recently, Markets in Financial Instruments Directive (MIFID) for EEA countries into a technical requirement for both data and interface.
• Engineered functions, procedures, types, triggers, python shell scripts, xml/json script files for web apps, partition and support tables to create detail level data for contractual billing and internal/external reporting use. Data used to generates raw invoice files that were securely FTP to Global SAP Billing system (enterprise billing system)
• Collaborated with DBA for optimizing performance and maintenance of PL/SQL code
• Performed ETL of source data into data marts using real-time Oracle Golden Gate and Informatica to support OLTP and warehouse schemas. Data migrated from Trust (Salesforce), Siebel over to OLTP schemas and further downstream to SAP BW for sales, and reporting
• Directed database developer, and java developer on requirements from business users for major or minor changes or fixes
• Contributed efficient and effective data analysis and/or solutions to resolve any internal or external financial queries, data integrity issues, or any discrepancies brought back to the business for further transparency.
• Point of contact for yearly financial audits and compliance reports using XML & JSON to export data
• Engineered internal and external reports using Tableau 2018, Crystal and Web-I on Business Objects 4.2 for Billing Users, Commercial & Strategy, and Finance team specifically revenue by volume allocations and trend reporting
• Supported Reporting team as secondary Business Objects Administrator
• Made Python shell scripts on Linux to automate/parse flat files with data from cloud via REST protocols
• Used Jira to upload updated scripts, new installation builds, source control files, and other files for sharing with assigned teams on projects
• Intimately involved in unit testing, user acceptance testing, quantitative and qualitative data analysis with documentation primarily with Commercial and Strategy team
• Used JIRA with Agile methods for managing project sand expected future milestones
• Communicated with stakeholders in New York, London, Belgium and Spain on major project developments and/or providing solutions to new market requirements via Webex meetings

Confidential, Jersey City, NJ

Business Intelligence Developer / Data Warehousing, ETL Developer

Technologies: IBM DB2 v9.7, Oracle 9i, Erwin, Informatica, Linux, Windows XP, JIRA, Autosys, SpotFire, Clarity PPM, Sharepoint

Responsibilities:

• With the database architect, contributed to model design and development of a transformation rules engine to utilize the new meta-data driven model.
• Developed supporting processes such as functions, procedures, types, triggers, partitioned and support tables to create a source-to-target load objective.
• Used ETL views a source system, developed a meta-data driven procedure in the staging environment to apply certain transformation rules while generating the insert and load execution simultaneously
• Contributed effective analysis and solutions to resolve any data integrity issues. Any discrepancies are brought back to the business for further transparency
• Aided in the engineering of a scalable and customized framework to facilitate transformation and loading (ETL) of data from source views to the target position tables on the fly
• Strong development in IBM’s DB2 language for creating database objects with dependent and independent functionality
• Documented all unit testing cases implemented through Linux shell script and Autosys jobs
• Supported Reporting team with data on position table (presentation layer) for SpotFire application reporting
• Used Jira to upload updated scripts and source control files, other files sharing utilized with Sharepoint
• Used Clarity PPM to get business’ perspective on managing project and expected projected milestones
• Utilized Informatica Powercenter 8.6 to gather source ledger feeds and transformed data. Feeds were uploaded into existing Oracle 9i database (separate foreign server). Data was then moved via custom ETL process in necessary format over to DB2 position tables for reporting requirements

Confidential, New York, NY

Business Intelligence Developer

Technologies: Oracle 11g, Business Objects XI R3.1,Erwin, Visual Paradigm, Resultspace, CVS

Responsibilities:

• Worked with the database architect, contributed to model design and development of customized code to create the new dimensional model and supporting processes. These consisting of tables (both supporting and metadata driven), views, functions, procedures for both the staging and presentation layer
• Utilized database links, joined several data sources to the designated staging area, and creating supporting views to merge the incremental difference in data from source system into metadata driven staging tables in the staging environment. Transformation was implemented in functions and using other inline functions to push the new data to presentation
• Contributed effective solutions to resolve any data integrity issues, creating new and keeping existing business rules in new warehouse environment
• Collaborated with database architect for better solutions when reverse or forward engineering existing models to achieve best practice solutions
• Aided in the engineering of a scalable and customized framework to facilitate extraction, transformation and loading (ETL) of data from source to staging to presentation layer environments. Thus, introducing a standardized approach in development
• Strong development in PL/SQL language for creating database objects with dependent and independent functionality
• Created Business Objects Universes with Designer for Web Intelligence use with client users
• Traveled commute between New York and West Virginia for client and security meetings. Worked with Federal Reserve Information Technology (FRIT) for secure hardware and software platforms that needed configuration to support overall implementation.

Confidential, New York, NY

Crystal Report 2008 / Business Objects 3.1 Lead Developer

Technologies: Business Objects 3.1 Edge Server, Web Intelligence Rich Client, Crystal Reports 2008 Server, Crystal Reports 2008 SP2, SQL Developer, Oracle 10g, SQL Management Studio 2005, SQL Server 2000 & 2005 w/SSIS, Windows 2008 server, JavaScript

Responsibilities:

• Developed complex ETL mappings using MS SQL Server 2005 SSIS from source to target tables for reporting environments
• Created custom Crystal Reports using Crystal Reports 2008 which includes developing Business Views, Crosstabs, Cascading pick-lists, Drill-downs, sub-reports etc, functionality into these reports.
• Problem solving: One such problem resolved was introducing an efficient and cost-savings approach to pass multiple parameters to a report using a dynamic pick-list or list of values creating Business Views, and also developing custom and complex stored procedures from Oracle and/or SQL Server databases which includes supporting both application and custom tables, views, triggers, and functions to aid in the design of these reports. Another was developing an Adhoc (Web Intelligence) solution for Abbott laboratories using BO Edge series 3.1 Universe Designer. Project was developed and deployed by myself via SDLC, and integrated within the application using the BO Java SDK in collaboration with Tech services of Confidential .
• Deployed custom Crystal Reports and Web Intelligence document deliverables to clients on time in a packaged build which included a Business Intelligence Archive Resource (BIAR) file and SQL scripts with documentation. This was accomplished using the Crystal Reports 2008 server client tools between host and client servers
• Modified and/or re-creating existing reports from excel requirements.
• Integrated custom crystal reports into the Profiler application with JSP calling the Crystal Reports Viewer functionality for user acceptance testing before deploying to production
• Created Universes using Designer for group web meetings for demonstrating the powerful functionality of Business Objects Enterprise with Ad-Hoc reporting (Web-I). Thus, also responsible for constantly communicating updates between business users and local management
• Worked on multi-tasking two projects for new designs and development of reports for both Confidential & Confidential and EISAI pharmaceuticals to support their internal applications. Weekly meetings to streamline and define requirements and business rules to arrive at a general consensus between the analysts, business users, and software development team. Recommendations for cost mitigation solutions brought to the table with design approaches with the software development team to effectively represent the required data for analysis
• Documented for ERDs, Crystal Report Templates, and Universe Schema Designs

Confidential, New York, NY

Pentaho Business Intelligence Developer

Technologies: SQL Server 2005, SQL Server SSIS, Visual Studio 2005, Access, Windows 2008 server, Pentaho Report Designer v3.0, v3.5, Pentaho Business Intelligence Suite 3.5, dbVisualizer 6.0, MDX

Responsibilities:

• Designed various types of reports with Complex Formulas, Custom Functions, Javascript Expressions, Drill Down and Sub Reports. Also assisted in constructing reports UI with Java Eclispe SDK to include parameter values to be passed to reports. Developed Cross Tab Reports and Java (BHE) expressions in the reports. Also designed the reports with multi-level of groupings (hierarchies)
• Facilitated in the strategic mappings and ETL processes using MS SQL Server 2005 SSIS with Visual Studio
• A great deal of my assignment was in creating standard templates while designing reports with to work with conditional formatting, sorting and running totals, converting old reports from MS-Access and Excel to Pentaho reports (prpt files), and creating functionality for a smooth export into various formats like EXCEL, PDF, HTML, and RTF per user requirements
• Spent time working with business users on getting specifications for reports and build prototypes developed for implementation on Pentaho Enterprise Server for User Acceptance Testing(UAT). This would involve constant analysis, regression testing, and iterative solutions before published it on Pentaho Enterprise Server production environment. In some cases, the responsibility of assuring scheduled reports got to intended recipients’ email for quarterly ends.

Confidential, New York, NY

Business Objects XI R3.x / Crystal Reports 2008 Developer

Technologies: Windows XP, IIS 6.0, Business Objects XI Release 3.1, Crystal Reports 2008, Oracle 10g, SQL Developer, Clear Case, AIX, Oracle Native Drivers

Responsibilities:

• Established weekly update-meetings with project managers, database team, UI development team, and quality assurance team for consensuses on any enhancements/new requirements needed by both existing and then new client, Telcel Mexico Communications. Telcel project development was top priority
• Given an aggressive timeline learning curve to be applied for all business rules and implementation into these new reports. Developed crystal 2008 reports that facilitated billing/invoice, and decision-making by the clients, and for other Inter-Carrier Messaging Systems (ICMS)
• Collaborated daily with the database team to implement most feasible ETL techniques for best performance and data mapping. Reports were formed from aggregated partitioned tables, functions, procedures, and dynamic PL/SQL. Attained Loading Bench mark of 100 million records < 7 minutes.
• Project completion and technical documentation for all the reports was two weeks earlier than deadline for code freeze. Successful cost mitigation. Confidential ecstatic that delivery was going to be earlier than schedule.

Confidential, Rockleigh, NJ

Crystal Reports Engineer III / Business Objects XI R3

Technologies: Crystal Reports XI R2, Crystal Reports 9.0, Business Objects XI R3.0, AS400, Oracle 10g, TOAD, SQL Developer, Legacy, Unix, Win XP Pro, Linux

Responsibilities:

• Oracle database and application was development by third-party. My approach on project was to understand the functionality and implement some systems analysis. Thus, constant communications with the third-party vendor, and Spectra management took place.
• Established weekly meetings constantly with users attained requirements for new reports utilizing the new system. Report drafts were distributed and pended approvals for development stage. Also developed documentation at both the technical, and functional level for project reporting status meetings
• Assisted in conversion of Cobol 85 V02 code to Oracle 10g logical structures in Accounts and Billing databases. Also developed tables, views, procedures, triggers to support new requirements and future report development. This exposed several logical bugs not complying with business rules by the third-party vendor. Implemented solutions in resolving logic programming in Oracle 10g database schema objects to comply with business rules requirements.
• Worked extensively with Oracle SQL Developer to test and verify the target databases and devised strategic implementations of ETL code working parallel with the third-party vendor for the legacy database tables to the new Oracle Unix environment specifically for Billing and Accounting databases
• Created tables, views, and stored procedures to facilitate report development of the newly migrated data until taken over by hired Oracle DBA. Also, a ssisted staff in creating some interface modules from Cobol85 via text file format and dumping data into external tables created in Oracle 10g.
• Installed, and configured Crystal Reports Server XI environment to support my teams’ reports (later replaced with full BOE installation). Trained users how to access reports, run, test and export them in to PDF, Excel and Word formats via email or hard-copy format
• Assisted Java and VB programmers with migrating existed crystal 8.5 reports to XI reports and integrating them using both Java and .NET SDK’s for their user applications. Also, proof of concepts: Universe and Web Intelligence reports (ad-hoc) created to answer user questions. This concept created several other new projects and teams for HLAB, Scorpion projects.
• McKesson’s Horizon Laboratory (HLAB) application was chosen as the labs systems. My role was to create custom reports using Crystal Reports 9.0 against the database schema that was critical for go-live. Also assisted in mapping data from HL7 files to the application and database. This was crucial in delivering the right data in joint effort between the interfaces of Initiate, Ensemble, Billing into Horizon Labs as this would affect both the HLAB application and Insurance Billing.
• Weekly meetings on all applications issues with project managers, IT directors of both Billing and HLAB teams, and Upper Management. Key issues were data integrity and cost mitigation thus proposed solutions of which some were applied.
• Created a population of about 25 reports for laboratory data and research pharmaceuticals department. Reports included compliance, management, and internal reports.

Confidential

Business Objects/Crystal Enterprise XI Report Developer

Technologies: Windows 2000,2003,XP, IIS 6.0, Business Objects XI Release II, Crystal Enterprise Server XI, Crystal Reports XI, Oracle 8i, 10g, VSS, Oracle Native Drivers, Cognos 7

Responsibilities:

• Responsible for speaking with business users and finalize on any enhancements/new requirements needed by reporting department.
• Developed various reports that facilitated business decisions for Confidential ’s consolidated shipping and pricing project. The reports designed were complex stemming from Business Objects Suite, Cognos, and huge data sources.
• Extensively worked with Business Users on regression testing the Monthly/Quarterly Reports and conveyed the errors/issues to team developers. Prioritized fixes on tight deadlines that mitigated company expenditures drastically.

Confidential, Devon, PA

Crystal Enterprise Developer

Technologies: Windows 2003 Server, XP, Crystal Enterprise 8.5, 9, Oracle 9i, SQL Server 2000, Access

Responsibilities:

• Migration project that got ultimately salvaged the company time and money in delivery and scheduling of reports. Also reducing the consumption of paper reports. Developed and proposed solutions from upgrading Crystal Reports to version 9 and use the Crystal Enterprise named to distribute current and new reports within user network.
• Designed various types of reports with Complex Formulas, Custom Functions, SQL Expressions, Parameters, Drill Down and Sub Reports, and Cross Tab Reports. Also designed the reports with multi level of groupings and hierarchies.
• Associated with other project teams that needed development of reports to support both their work and new applications. Some integration

Confidential, North Miami, FL

Business Objects Lead / Solutions Architect

Technologies: Windows 2003,XP, IIS 6.0, Business Objects 5.1, SQL Server 2000, Cisco VPN, Remote Desktop, Unix, Crystal info, Seagate Info

Responsibilities:

• On board at midstream in the project to install Business Objects 5.1 on User Acceptance Testing (UAT) box and train the programmer analyst in installation and troubleshooting in Windows 2003 server.
• My role was constantly liaison with the development team and front users. Thus, installed and configured Business Objects 5.1 for the development environment and testing environments. Documentations written and provided.
• Involved in the designing and building of Universes, classes and objects on the reporting database that were asset management reports.
• Created cardinalities, contexts, joins and aliases for resolving loops and contexts, so the integrity of the Universes can be maintained.
• Upon completion trained users for 80-hour sub project that was done mostly remote and 35 hours on site.

Confidential, Columbus OH

Business Objects / Crystal Report Developer

Technologies: Crystal Reports version 8., Business Objects 5.1.7, ZABO, Info view 2.7.2, IBM DB2 v6.0/v7.1, XML, Broadcast Agent 5.5/ Web intelligence 2.7.2, QMF for Windows V7.1 and BO SDK

Responsibilities:

• Full lifecycle Business Objects development included requirements gathering, designing, scheduling, report building, testing, and assistance with training. Ultimately these reports were needed to elevate tensions and minimize discrepancy between the Sales and Capital Management divisions.
• Designed Business Objects universes included key elements of universe, design and hierarchy building for data analysis and applied to conditions in objects, resolving loops and other SQL problems. This was a huge improvement for the client’s gain - immediate positive impact reducing processing time by 50+ percent.
• Extensively involved between in the Designing, Testing and Production Environments of RCM ProjectWorked with Business Objects tech support in US, Canada and in India through net meeting and teleconferencing.