OBJECTIVE:

• Over 20 years of data processing experience on client/server and large scale mainframe
• platforms with progressive experience designing and developing custom analytical and reporting solutions using Cognos, Microsoft BI, Business Objects, MicroStrategy, QlikView, Tableau, Datawatch, Informatica, Datastage and other BI/ETL analytical, and data discovery tools.
• Obtain a strong, challenging and emerging position in a company that can utilize a creative mind, an enthusiastic thirst for knowledge and a desire to exceed the expected standard of performance. Personable and exceptionally rapid in learning coupled with a strong work ethic. Creative and persistent problem solver, who thrives on challenges, excels under pressure and gets the job done. Confident and passionate technology leader.
• Earned a track-record of success in managing complex business initiatives in diverse organizations and achieving exceptional rather than expected results.
• IBM Professional Certificaions:
• IBM Cognos 10 BI Administrator C2020-622 . Passing score 84 .
• IBM Cognos 10 BI Author C2020-612 . Passing score 82 .
• Member of Mid-Atlantic IBM Cognos user group.

HARDWARE/SOFTWARE EXPERIENCE:

• ETL/BI Microsoft BI, Cognos BI Suite 10.2.x, Cognos BI Suite 10.1.x, Cognos Framework Manager
• 10.x, Cognos Workspace Advanced 10.2.x, Cognos Business Insight 10.1.x, Cognos Cube Designer 10.2.x, Cognos Dynamic Query Analyzer 10.2.x, Cognos Disclosure Management, Cognos BI Suite 8.1.x 8.4.x, Cognos Series 7, Cognos Enterprise Planning EP 8.2 8.3, Cognos SDK, Cognos TM1 9.5, Cognos TM1 10.1.0, Cognos GoDashboard, Cognos Go Office, IBM Mashup Center, Powerplay, Transformer OLAP Modeling , Cognos Now, Cognos Express, Business Objects XI R2/R3 Designer, WEBI, Full client , Xcelsius, Crystal Reports Enterprise Edition 10 and XI, Microstrategy 9.x, QlikView, TIBCO Spotfire, Datawatch, Pentaho, Tableau, Informatica 8 x and 9.x, IBM DataStage.
• Languages/
• tools SQL, PL/SQL, Oracle SQL Plus, Oracle Reports, ModelN, IMPACT Clinical trials, Toad, SQL Navigator, COBOL, CICS, TSO/ISPF, VSAM, JCL, IBM Utilities, SPUFI/QMF, Rexx, Clist, Focus, EZtrieve Plus, SAS, SORT DFHSORT/SYNCSORT , WebSphere MQ, J2EE, Java, JSP, JDBC, JBuilder, Dundas, Citrix, Servlets, Struts, JavaScript, HTML, XML, XBRL, DHTML/Style Sheets, Tomcat, ODBC, Perl, Dreamweaver, Python, Adobe Action Script, EDI ANSI x.12, Mercator, Paperfree, Sybase HIPAA Studio, MHS, Lotus Notes, Microsoft Frontpage, Microsoft Sharepoint, Microsoft Otlook, Microsoft Excel, Microsoft Project, Microsoft Visio, Visual SourceSafe, Microfocus COBOL/CICS, FTP, Abend-Aid, IBM Fault Analyzer, Expediter, Intertest, BMC, Platinum, File-Aid, Endevor, Librarian/CCF, Panvalet, Tesseract, Viasoft, UCC7, OPC, ZEKE, Control-M, Autosys, RACF, ACF2, Infoman, Documentum, IIS 6/7.
• Databases DB2, ORACLE 9i,10g and 11g, SQL Server 2005, 2008 and 2012, Microsoft Access,
• TERADATA, IMS, Datacomm, Adabase, Supra, mySQL.
• OS IBM MVS, IBM z/OS, DOS, UNIX, LINIX, WINDOWS, WINDOWS Server 2003 and 2008.

EMPLOYMENT:

Confidential

BI Solution Architect and Analytics team leader Consultant

• Providing consulting services to Teva Pharmaceuticals. Responsible for multi-tier installation, configuration and customization of Cognos 10.2.1 Business Intelligence software in development, QA and production environments. Responsible for keeping all Cognos components up-to-date by applying Cognos Fix Packs and Hot Fixes.
• Utilizing Cognos 10 Framework Manager to build Framework Manager models semantic layers database, transformation and presentation layers , relationships/cardinality and query subjects , and packages. Update existing Framework Manager models based on the business requirements created aliases, relationships, shortcuts, calculations, filters, prompts, incorporated database functions and store procedures . Implemented packages security and published packages to Cognos connection. Developed Relational and Multidimensional models DMR . Work closely with business stakeholders to understand business requirements.
• Designed, developed and Implemented SSIS Packages to import and export data from SQL
• Server 2012, MS Excel and Flat files for Teva Drug Safety DW system.
• Involved in complete SSIS life cycle of creating SSIS packages, building, deploying and executing packages in Development and Production environments.
• Configured and loaded Drug Safety data into slowly changing dimensions using Slowly Changing Dimension SCD wizard.
• Utilized advanced reporting skills using SQL Server 2012 Reporting Services SSRS .
• Developed dashboards for C-Level executives using SSRS. Designed, developed and deployed report templates, bar graphs and pie charts based on TEVA Drug Safety data.
• Design, develop and test Cognos reports utilizing Cognos Report Studio features such as Conditional formatting, Conditional page layout, Sections, Master-Detail relationship, Drill Through, Bursting and many more .
• Use Cognos Cube Designer to model and deploy Cognos Dynamic Cubes DQ to IBM Cognos Connection utilizing Teva Sales and marketing DW data for analytical reporting across the enterprise. Utilized IBM Dynamic Query Analyzer to analyze DQ to enhance performance.
• Utilize JavaScript for complex Cognos report prompts validation and format customization.
• Design, develop and implement complex Cognos reports using ModelN contract, bucket line and rebate data.
• Troubleshoot report performance by performing report tuning by analyzing and comparing the benchmark execution times between native Oracle SQL and Cognos generated SQL.
• Extensively using Cognos Transformer to develop Powerplay Power Cubes and Cube
• groups by designing Dimension Maps and Transformer Models. Cubes contain Teva clinical studies data for online analytical processing OLAP by clinical trial managers.
• Provide in-depth training to corporate Cognos users on how to use Cognos Workspace Advanced 10.2.1 to perform self-service reporting using locally stored files in XLS, CSV and XML formats.
• Environment: Cognos 10.2.1 BI, Oracle 11g, IIS 7, BSP Meta manager, Windows Server 2008 R2.
• Utilize XBRL communication method for electronic business reporting for IBM Cognos Disclosure Management to produce FDA regulatory reports.
• For Teva Clinical Trials project utilize data discovery and ETL tools such as Datawatch and Pentaho for analytical purpose.
• Participated in migration of Teva Drug Safety metadata content including Impromptu reports and catalogs from Cognos Series 7 to Cognos 10.1 BI. Developed complete migration plan based on IBM Cognos best practices. Migrated active PowerPlay 7 applications and users to IBM Cognos BI PowerPlay.
• Utilize Cognos 10.2.1 Theme designer to develop a new portal skin to match Teva corporate colors and web standards.
• Developed and support IBM Cognos TM1 models through all stages of the project life cycle. Utilize Cognos TM1 10.1.0 suite of products TM1 Rules, Turbo Integrator and Performance Modeler to deliver solutions to Teva.
• In Cognos Report Studio developed over 120 Active reports for sales force for Mobil iPad consumption. Utilized Cognos 10.2.1 Business Analytics Visualizations AnalyticsZone.com such as heat map, tree map, Gantt chart and box plot.
• Participated in POC proof of concept and successful implementation and integration ofTableau in Teva BI environments.
• Demonstrate broad system level expertise across multiple computing platforms and technologies with the ability to influence direction around information management at the Enterprise Level. Effectively interface with user community, analyze problems and propose optimum solutions.

Confidential

BI Solutions Architect and Analytics team leader Consultant

• Provided consulting services to Cephalon Pharmaceuticals. As a Business Intelligence BI Solution Architect and team leader of 7 developers, lead Cephalon BI start-up project that include proof of concept, determination of the BI development strategies and methodologies, identification and preparation of data sources, selection of BI tools, design and implementation of BI solution, discover new informational business needs and practices. The BI infrastructure was flexible, rapidly implemented, and independent of their hardware and software platforms, scalable and based on the latest technologies.
• Responsible for multi-tier installation, configuration and customization of Cognos 10.1 BI Suite in development, UAT and production environments. Upgraded Cognos 8.4.1 content store to Cognos 10.1 instance. Utilized Cognos Lifecycle manager to compare Cognos 8.4.1 to Cognos 10.1 content upgrade results.
• Routinely utilize Cognos Framework Manager to develop, maintain and support full range of metadata models Relational and DMR .
• Provide in-depth training to corporate Cognos users on how to use Cognos Insight 10.2 to perform self-service reporting using locally stored files in XLS, CSV and XML formats.
• Environment: Cognos 10.1 BI, Cognos 10 SDK, Cognos Business Insight 10.1, Oracle 11g, IIS 7, Windows Server 2008 R2.
• Responsible for installation of Cognos 8.4.1 Business Intelligence Suite, ongoing support of Cognos development and production environments that include software upgrades and hardware configuration, in-depth portal customization and rebranding, creation of groups and users, roles, package deployment, access permissions, report and job scheduling, report bursting and troubleshooting. Monitor and maintain system performance and provide statistical and audit reporting to upper management. Routinely work with IBM Cognos Support to address and resolve problem cases PMR .
• Responsible for TM1 server installation, configuration and maintenance. Installed TM1 portlets and set up security utilizing the same Cognos Namespace as Cognos BI portal. Lead TM1 cube design and development effort.
• Environment: Cognos 8.4.1 BI Suite, Cognos TM1 9.5, Cognos SDK, Oracle 10g, IIS 6, JRE 1.5.x, Windows Server 2003.
• Lead design, development and ETL effort of Cephalon Clinical trials DW data warehouse . Work with business community to ensure that the data mart support metrics and reporting needs of the business. Interact on daily bases with Cephalon corporate executives, clinical trials managers and FDA officials.
• Provide project and programming leadership, demonstrated ability to take initiative, exercise judgment and act independently with other Cephalon BI team members and the business clients located in the US, Europe and Japan.
• Environment: Oracle 10g, IMPACT Clinical trials, Informatica 8.x, Windows Server 2003, Erwin.
• Converted 50 TIBCO Spotfire safety reports to BO reports.
• Orchestrated and implemented conversion from Cognos Series 7 to 8.2 and then upgrade to 8.3 , and 8.4.1 release. Implemented Single Sign On SSO with LDAP security. Installed and configured GoDashboard add-on on 8.4.1 platform. Provided hand-on training to corporate users and off-shore resources on how to use Cognos Query Studio, Cognos Go Office and CAF .
• Responsible for keeping all Cognos systems up-to-date by applying Cognos Fix Packs FP .
• Design, develop and maintain Cognos metadata model reporting structures using Framework Manager. That includes import Data Warehouse DW metadata objects into Framework manager, setting up the relationships, creating prompts by utilizing prompt macros, creating filters and setting security layers. Actively involved in the data minding effort across the enterprise.
• Provide development and hand-on assistance with Business Objects XI R2/R3 Universe design and report development process for Cephalon Global Safety System.
• Designed and developed Universes utilizing OALP and relational data sources.
• Designed, developed, and conducted full cycle of testing and deployed dashboards utilizing Xcelsius.
• Actively involved in report development effort, utilizing WEBI and full client version.
• Environment: Oracle 10g, Business Objects XI R2/R3, Xcelsius, Crystal Reports Enterprise XI, Windows Server 2003.
• Design, develop, maintained broad spectrum of dashboards and reports for various users in Corporate management, Clinical, Data Management and Global Product Safety groups. Total number of the reports developed over 350. Total number of dashboards developed over 30. Total number of Operational, Tactical and Strategic scorecards 12.
• Utilized Cognos Transformer to design OLAP Models.
• Demonstrate expertise with Cognos 8 and 10 Software Development Kit SDK to customize front-end interface portal and reports using Java programming language.

Confidential

Sr. BI Administrator and Solution consultant

• Provided consulting services to Right Management Consultants. As a Cognos administrator developed and implemented conversion from Cognos Series 7 to 8.2.
• Design, develop and maintain Cognos metadata model reporting structures using Framework Manager.
• As a leader of Enterprise Planning BI team responsible for developing and implementing Cognos Enterprise Planning and Forecasting applications and BI integration for all business units worldwide.
• Designed and developed Cognos EP Macros to execute D-Links to load EP Analyst models with Actual Gross Profit GP and Profit and Loss P L data from 27 countries from Peoplesoft financial system utilizing Microsoft SQL Server SSIS packages. Designed and developed process to automatically move data between Analyst and Contributor via D-Links and data within the Contributor utilizing Admin links. Developed and implemented D-Lists that include complicated BiF logic.
• Environment: Cognos 8.2 BI, Cognos Planning 8.2, Cognos SDK, Microsoft SQL Server 2005, Windows Server 2003 R2, IIS 6, JRE 1.4.1
• Responsible for integrating Cognos Planning and Forecasting models into existing Cognos ReportNet reporting environment. Developed sophisticated budgeting, 2 7, 5 7 and 8 7 forecasting and headcount reports that include burst, sub-reports, parameters, formulas, graphs and drill-downs. Ensure compliance with company's Software Development Life Cycle SDLC methodology.
• Provide ongoing Microsoft SQL Server 2005 support in development and production environments that include monitoring, fine tuning and troubleshooting.

Confidential

Sr. ETL/BI Developer Consultant

• Provided consulting services to Merck and Company. As an ETL Architect of US Human Health Sales and Marketing data warehouse group, developed database architectures, dimensional data models, mappings, workflows to extract, transform and load ETL data from legacy systems, IMS and other company vendors using complex business logic. Utilized Erwin Data Modeler to develop logical and physical data models.
• Environment: Informatica PowerCenter 7.1, ORACLE 9i, PL/SQL, Crystal Reports XI, ErWin, UNIX, IBM Mainframe, JCL, COBOL II and Autosys.
• Developed ETL strategy to migrate legacy prescription data to Oracle Data Warehouse. Set up automated procedures to monitor daily, weekly and monthly Data Warehouse load processes.
• Designed document scripts and stored procedures for Sales and Marketing data warehousing processes. Performed fine tuning of ETL tools for parallel loads and cache optimization. Created Data Marts utilizing Star and Snow flake schema models. Documented ETL processing according Merck's ETL standards and architecture.
• Was responsible for identifying, architecting and developing complex Business Objects Crystal Reports XI reporting solutions for various business clients. Interacted daily with clients and responsible for managing their expectations.
• Strong hands on experience with Business Objects XI installation, server configuration, server scaling, administering Single Sign On SSO with LDAP security managing folders and objects rights, administering Repository including Business Views and Universes.
• Provide production control support, monitor, administer and optimize Crystal Enterprise and Business Objects server environments.

Confidential

Sr. ETL/BI Developer Consultant

• Provided consulting services to Verizon Communication Corporation. As a member of Winback IT marketing team was responsible for design, development, testing and support of Verizon Marketing Customer Information system. That system validates and integrates the data into analysis-ready form for the Verizon business clients to develop effective local, long distance, DSL and FIOS strategies locally and nationwide. Interact with five Direct marketing vendors.
• Environment: ORACLE 9i, PL/SQL, JSP, Struts, TERADATA, Microstrategy, MQ Series, UNIX/AIX, FTP, MVS JCL, COBOL II, DB2, FOCUS and NDM.
• As a member of Data Warehouse team was responsible for analysis of the structure and quality of data from source systems, resolution of data quality problems, mapping data between source systems and target data marts, coding Extract, Transformation and Load ETL components.
• Participated in effort to develop, maintain and fine tune multiple ETL processes utilizing Datastage. Utilized Cognos business intelligence tools to design and develop scheduled and ad-hoc operational, and management reports and cubes.
• Provided assistance to Database Administrator in transitioning from logical data models to database schemas. Developed ETL processes-extract DB2/COBOL mainframe load staging tables, write PL/SQL transformation processes to target an Oracle warehouse.
• Environment: Datastage, ETL, Oracle 9i, PL/SQL, Teradata,, UNIX, Korn shell scripts, ERWin, JSP, Struts, MVS, DB2, IMS and Cognos.
• Designed, developed and tested batch processes to compile and transmit Verizon marketing data from Winback DB2 database to secure FTP servers and WebSphere MQ. Worked with MQ Series administrators to benchmark and fine-tune the process.
• Utilized Microsoft Project to analyze and estimate project schedule and costs. Develop numerous innovative cost saving initiatives, including redesign of Winback core customer targeting sub-system. Total savings exceeded 100,000 in CPU and DASD costs.
• Automated processes in cost effective manner and translated business requirements into technical specifications. Provide technical training and assistance to other team members.

Confidential

Sr. Programmer/Analyst Consultant

• Provide consulting services to Independence Blue Cross. As a member of EDI team responsible for creating, modifying and testing of ANSI X12 EDI transaction sets eligibility 834 , claims submission 837 , claims payment/advise 835 , services review information 278 , invoice 810 and UB92 Uniform bill 92 formats to ensure full compliance with Health Insurance Portability and Accountability Act HIPAA requirements. Assist with the development of e-Business implementation guides for EDI transaction sets and EDI Gateway scripts.
• Work with Sybase EDI Gateway EDI communications and EC Map EDI translation/mapping software products on the translation/mapping of elements.
• Environment: MVS, COBOL II, CICS, DB2, JCL,AS/400, MHS, UNIX, MQ Series/MQSI, Sybase and Neon PaperFree.
• For MHS claim adjudication systems analyzed, developed and coded online and batch interfaces with Claim Information System utilizing MVS JCL, IBM utilities, REXX, CLIST, UNIX, DB2-Connect and FTP. Created pseudo code and data flow diagrams to optimize systems performance. Actively participated in MHS 6.0 conversion.
• Demonstrated ability to analyze business requirements and develop EDI mapping specifications with strong organizational skills and ability to handle multiple project assignments based upon defined priorities.

Confidential

Sr. Programmer/Analyst Consultant

• Provided consulting services to American Re-Insurance company. Heavily involved in database design and development of the American Re-insurance Claims Data Warehouse project. Developed input forms using Oracle Forms v4.5. Extensively use SQL scripts and store procedures to extract data from Oracle 8i database. Performed scheduled data load utilizing SQL Loader. Used Platinum and ERwin tools for data modeling. Provided on-going production support .
• Environment: Oracle 8i, Oracle Forms v4.5, Cognos, JAVA, JSP, Servlets, JDBC, UNIX, Perl, DB2, COBOL II, JCL and MVS.
• Analyzed and extracted data from DB2, Oracle and MS Access databases by using a variety of software languages such as COBOL II, SAS, PL/SQL, VB and Focus. As a result produced user-friendly statistical reports in numerous formats for Am-Re clients worldwide.
• Created a large number of interactive reports for Claims Tracking system using Cognos Impromptu. Detailed data modeling and SQL queries were used against Oracle database running in UNIX environment to get the desired output records.
• Extensively used case tools such as Oracle Developer 2000 to perform data modeling and design on an Oracle 8i database. Analyzed business requirements with clients to design appropriate data models, defined database entries and establish its relationship. Defined and code database queries, triggers, store procedures and functions using SQL Plus.
• Worked with DBA to analyze SQL queries, maintain database schema, create Oracle instances, tables and indexes, load data with SQL loader, write import/export scripts and perform database tuning with Oracle tools.

Confidential

Sr. Programmer/Analyst Consultant

• Was responsible for analysis, design ,coding and support of the Pennsylvania Electric Choice project to allow PECO Energy customers choose different electric suppliers. Assure that programs are written according to specification and all phases of testing are conducted based on the client approved test plans.
• Environment: Oracle 8i, SQL Plus, Visual C , MVS, COBOL II, CICS, DB2, VSAM, SAS, MQ Series and FTP.
• As a member of e-Commerce team was involved in development and maintenance of new and existing business-to-business 4010a X.12 EDI transaction sets 810, 814, 850, 855, 856, 867 and etc. . Obtained, reviewed and exchanged EDI implementation guides with 28 trading partners. Developed interfaces between EDI and PECO Customer Information System CIS . Performed data mapping utilizing Mercator tool set, mailbox and communication setup.
• Analyzed, coded and tested more then 30 COBOL II programs to extract existing Accounts Receivable/billing data from PECO Legacy system and migrated it into Oracle Internal Data Repository IDR .
• Was responsible for writing PL/SQL packages, procedures, triggers and views. Coordinated the activities as needed to Oracle DBA and outside vendors. Was heavily involved in logical and physical design of the database. Utilized ERWin for data modeling. Created middleware processes to map Legacy files into Oracle tables using UNIX. Was responsible for writing UNIX Shell scripts.
• Environment: Oracle 8i, SQL Plus, SQL loader, MVS, COBOL II, CICS, IMS and FTP.
• Performed business area analysis and developed functional requirements definition of the existing PECO Legacy system. As a result gained a broad and integrated knowledge of all aspects of the system.

Confidential

Sr. Programmer/Analyst Consultant

• For the SmithKline Beecham Pharmaceuticals conducted on-going support of the Sales and Marketing Information Center system SMIC . That system validates and integrates the data into analysis-ready form for the SB users to develop effective marketing strategies worldwide.
• As a result gained a broad knowledge of SB Pharmaceuticals Sales and Marketing system.
• System utilized: COBOL II, CICS, DB2, MVS, Focus, Oracle, SQL Plus, VB and Unix.
• As a part of HR group was involved in Tesseract installation process, database conversion, JCL changes, unit and system testing.
• As a part of Millennium team participated in analysis, design and testing payroll related
• subsystems to accommodate year 2000 changes.
• Provided on-going product and application support using Tesseract software to several SB key user areas such as: Employee Benefits, Payroll, Human Resources and General Accounts systems.
• Used structured development methodology to implement and coordinate all phases of product development, including analysis, design construction, testing and roll out. Coordinated development with customers and other IR departments.
• Demonstrated effective oral and written communications with clients, team members and SmithKline Beecham management. Maintained in-depth knowledge of business operations, disciplines and appropriate development technologies.

Confidential

Sr. Programmer/Analyst Consultant

• Was involved in design and analysis of a Conrail Employee Benefits sub-system. The system is designed to donate money to schools, colleges and universities by Conrail and it's employees and contains 10 CICS transactions, 12 COBOL II programs and 5 Easytrieve Plus programs.
• System utilized: COBOL II, CICS, MVS, Adabase/Natural, DB2 and Easytrieve Plus.
• Indicate knowledge of Database design and applications in area of Payroll, Employee Benefits and Inventory systems.
• Participated in meetings with department managers, project leaders and programmers to improve Quality Assurance process and productivity. As a result productivity was increased by 7 .
• Wrote specifications, diagrams, data descriptions and documentation following Conrail Application Development Methodology for technical personnel and users needs. Heavy user contact was involved.

Confidential

Sr. Programmer/Analyst Consultant

• Provided computing consulting services for SmithKline Beecham pharmaceutical company.
• Worked closely with project leaders and managers to provide support to the clients.
• Successfully completed a variety of projects and tasks independently and as part of a team across many business functions, some of which included Human Resources, Benefits, and Payroll.
• Participated in the conversion of a new business sector SmithKline Beecham Clinical Laboratories to the Tessaract Integrated Human Resource, Benefits, Payroll and
• Pension system.
• Environment: MVS, COBOL II, CICS, SAS, JCL, VSAM and FTP.
• Was responsible for analysis, design and development of the FSA Healthcare/Dependentcare Reimbursement Account interface for outside venders.
• Routinely use Work Flow Methodology as a tool to organize and document my research and planning activities.

Confidential

Programmer/Analyst Consultant

• For Keystone Insurance Company designed, developed and coded an Accounts Receivable History System. The system was designed to provide historical records and audit trails for agents, underwriting staff and claim adjusters. As a result, number of phone inquires received by Accounts Receivable staff dropped by 20 and savings per month increased by 7,245.00.
• Designed and developed a new Keystone Auto Insurance Scoring KAIS subsystem to calculate annual premium based on policyholder information. Was involved in production support and troubleshooting.
• Environment: MVS, COBOL II, CICS, DATACOM, JCL and VSAM.
• Conducted unit and system testing.

Confidential

Programmer/Analyst Consultant

• As a member of conversion team, for the Prudential Insurance Company of America worked to identify missing or erroneous data in the NEA National Education Association Insurance database.
• Designed, developed and tested programs to extract the erroneous records and to produce statistical reports. The programming involved COBOL II and VSAM files to be converted prior to loading into DB2 tables. These extracts were downloaded to MS Access to be merged with a form for the production of letters requesting update information.
• Wrote specifications, diagrams, data descriptions and documentation following LBMS Methodology for technical personnel and users needs. Heavy user contact was involved.