We provide IT Staff Augmentation Services!

Epic Business Intelligence Architect/consultant Resume

4.00/5 (Submit Your Rating)

CA

SUMMARY:

  • Dynamic, result oriented Technical design developer with extensive years of software experience and experience in Data Warehousing, Business Intelligence and Client Server applications & Reporting
  • Experienced in Data Warehouse Life Cycle: requirement analysis, understand trade - offs between different schema designs and their implementation, worked with DBA to implement data models in RDBMS and support enhancements.
  • Worked in ETL Development involving SAP Data Services Objects like Real-Time / Batch Jobs, Workflows, Dataflows, ABAP Dataflows, Scripts, Variables (Global/Local/Parameters), Transformations (Query, SQL, Table Comparison, Validation, Pivot, Hierarchy Flattening, Case, Merge, Row-Generation, History Preservation, Global / USA Address Cleansing, Data Cleanse, Match).
  • Expetrise creating reports and SQL queries on Epic Clarity data for Hospital Billing, Profisional Billing, Willow, Radiant and Cupid,Ambulatory and Inpatient related modules.
  • Expertise creating EPIC RADAR dashboard and EPIC Reporting Workbench Reports and assigning security.
  • Expertise in Data Cleansing using SAP Data Services /Data Quality and installing and configuring data quality address directories for cleansing various country related data.
  • Extensive experience using Business Objects 4.X, Web Intelligence 4.x Business Objects Designer 4.x, Xcelsius, Crystal Reports 2011, Business Objects Developer Suite (Designer, InfoView, CMC, CCM, Import Wizard, Business View manager).
  • Expert developing and issues resolving on Crystal Report, Business View, Universe, and Xcelsius development.
  • Experience in installing and configuring WEBI Servers and performance tune the BO Servers and clusturing.
  • Experience in Dashboard manager, HR Intelligence, Supply chain and Finance Intelligence
  • Strong data processing experience in designing and implementing Data Mart applications, mainly Transformation processes using ETL tool Informatica Power Center (Repository Manager, Designer,Workflow Manager, Workflow Monitor, Informatica Metadata Manager) 8.x.x/7.x, Informatica PowerExchange.
  • Strong working experience in the Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Extraction, Data Transformation and Data Loading (ETL).
  • Participated in discussions with Project Manager, Business Analysts and Team Members on any technical and/or Business Requirement issues.
  • Extensive experience in Dimensional modeling techniques.
  • Strong experience in coding using SQL, PL/SQL Procedures Functions, Triggers and Packages.
  • Extensive experience in writing UNIX Shell Scripts for loading data and PL/SQL scripts for validating data. These Shell scripts were called from the scheduler to automate the process.
  • Extensive experience in server side programming. (Writing Packages, Stored Procedures, functions and Database Triggers in Oracle).
  • Creative, independent thinker, self-starter; attention to detail and ability to work independently as well as within a team, demonstrated ability to multi-task work assignments and mentored other ongoing projects.

TECHNICAL SKILLS:

Languages: PL/SQL, C, VB6.0, HTML, JAVA, ASP, JSP, .NET

RDBMS: Oracle 11g/10g/9i/8i, SQL 2008/2005/ 2000, DB2,UDB, TERADATA, Sybase

ETL Tools: SAP Data Services 4.X,Informatica Power Center 8.6, Informatica Power designer 8.6, Informatica Repository Manager 8.6, Informatica Workflow Manager 8.6, Informatica Workflow Monitor 8.6, Informatica Metadata Manager, Informatica PowerExchange.

Reporting Tools: Business Objects XIR3, CMC, Designer, Performance Manager, Xcelsius, Voyager, WEBI XIR3, Crystal Reports XIR3, Power Analyzer 4.x/ 5, Cognos Report Net 7.x, Cognos Power Play 7.x

Tools: & Utilities: ERWIN, ER Studio, PowerDesigner 12, TOAD, Rapid SQL, VISIO, Excel, JDBC, ODBC, OLE DB, CVS version control, VSS, PL/Sql Developer, MS Office

Oracle Tools/utilities: SQL *Plus, SQL *DBA, Svrmgr, Exp/Imp, SQL *Loader, SQL *NET, PL/SQL, Forms 4.5, Reports 2.5

Operating Systems: Windows 2008/ 2003, NT, 98, UNIX, Solaris, AIX, HP-UX

PROFESSIONAL EXPERIENCE:

Confidential,CA

EPIC Business intelligence Architect/Consultant

Responsibilities:

  • Administer the production and development SAP Business Object Enterprise environments, including security, performance and maintenance.
  • Creating and Monitoring clarity Reports on SAP BOE Jobs.
  • Creating templates in Epic Hyperspace for RW Reports for viewing reports output to users.
  • Creating RADAR Dashboards for end users
  • Creating reports and dashboard using Epic Clarity data on Ambulatory data, ED Department Data and Billing Data Using SAP Business Objects Tools.
  • Creating universe using Business objects IDT Tool of Epic Clarity and Cogito datawarehouse database.
  • Created and Modified Epic Provided Universe of Hospital bulling, Profissional billing, Willow, inpatient and Ambulatory Universe
  • Modified Epic Provided Cube of Hospital Billing and Profissional Billing
  • Created Universe for SSAS Cube as datasource.
  • Monitoring ETL Jobs through console to load data from chronicals to Clarity database and clarity to Epic EDW warehouse tables.
  • Worked in planning, developing, implementing and managing data warehouse project deliverables, design documents and high level data mapping for ETL specifications.
  • Handled Performance Tuning the SQL stored Procedure jobs for better performance, optimization of the resources and fit in the allocated Timeframe window for Clarity Datawarehouse tables.
  • Creating Reports using Crystal report, WEBI for schedule and on-demand
  • Creating charts and drilldowns for different types of charts like line charts, pie charts and bar charts.
  • Developed Daily, Weekly, Monthly and Yearly Reports.

Environment: SQL Server 2014, SQL, EPIC Clarity 2015, Business intelligence tools, Crystal Reports 2013, Business Objects XIR 4.x, SAP Dashboards 4.x,MS Office, Visio, Unix, Windows 2008

Confidential, FortWorth TX

Clarity Report writer/Business objects Architect

Responsibilities:

  • Administer the production and development SAP Business Object Enterprise environments, including security, performance and maintenance.
  • Creating and Monitoring clarity Reports on SAP BOE Jobs.
  • Creating templets in Epic Hyperspace for viewing reports output to users.
  • Creating reports and dashboard using Epic Clarity data on Ambulatory data, ED Department Data and Billing Data Using SAP Business Objects Tools.
  • Monitoring Epic ETL Jobs through console to load data from chronicals to Clarity database and clarity to Epic EDW warehouse tables.
  • Worked in planning, developing, implementing and managing data warehouse project deliverables, design documents and high level data mapping for ETL specifications.
  • Handled Performance Tuning the SQL stored Procedure jobs for better performance, optimization of the resources and fit in the allocated Timeframe window for Clarity Datawarehouse tables.
  • Creating BOE Universe and implementing User security
  • Creating Datamart of Hospital Billing and Profissional billing as per the users requirments and made easy for their analysis Reports performence.
  • Creating Reports using Crystal report, WEBI for schedule and on-demand
  • Developed dashboards using Dashboard builder and Xcelsius.
  • Using Xcelsius creating charts and drilldowns for different types of charts like line charts, pie charts and bar charts.
  • Building and publishing Xcelsius visualizations Using Live Office and QaaWS.
  • Working with SAP HANA prototype for demo,
  • Developed Daily, Weekly, Monthly and Yearly Reports.

Environment: SQL Server 2008, SQL, EPIC Clarity 2012, Business intelligence tools, Crystal Reports 2011, Business Objects XIR 4, SAP Dashboards 4.x, Xcelsius 2011,MS Office, Visio, Unix, Windows 2008

Confidential, Dallas, TX

DataWarehouse Architect

Responsibilities:

  • Administer the production and development SAP Business Object Enterprise environments, including security, performance and maintenance.
  • Implemented / Customized the Data Marts’ design, develop/customizing jobs for Warranty enhancements to populate the Dimensional and Fact tables to accommodate the business requirements for Claims for Finance
  • Worked in planning, developing, implementing and managing data warehouse project deliverables, design documents and high level data mapping for ETL specifications.
  • Handled Performance Tuning the ETL jobs for better performance, optimization of the resources and fit in the allocated Timeframe window, design Staging Area (Persistent and Transient) for data from SAP, Custom Applications (MACS) using DBMS (Oracle), XML files and flat files.
  • Worked in implementing industry best practices and tuning of the Out of the Box Migration processes, in Administration of Servers in DEV/QAS environments, automated process for Local Repositories’ for Compact / Backup processes, command level imports / exports and defining a process to synchronize the deliverables by the team and promotion between the environments.
  • Created Reports and Dashboards on Epic Clarity data for Ambulatory clinic for Adult, Pedi and Family practice related data.
  • Creating Universe and developing reports based on users requirements for the Inpatient, ambulatory, willow and Hospital Billing data.
  • Developed extraction for UHC requirments from Epic Clarity data for monthly submission.
  • Worked with clarity Compass to load data from Cache database to clarity table in Oracle database.
  • Monitoring jobs and troubleshooting if failed when on call rotation.
  • Checking upgrads and isuues in NOVA which is maintain by Epic.
  • Developed dashboards using Dashboard builder and Xcelsius.
  • Using Xcelsius creating charts and drilldowns for different types of charts like line charts, pie charts and bar charts.
  • Building and publishing Xcelsius visualizations Using Live Office and QaaWS.
  • Developed Daily, Weekly, Monthly and Yearly Reports.

Environment: Oracle 11/10g, SQL, TOAD, SAP DataService 4, Business intelligence tools, Crystal Reports 2011, Business Objects XIR 4, Xcelsius 2011, EPIC Clarity 2010/2012, MS Office, Visio, Unix, Windows 2008

Confidential, Washington,DC

Business Objects Architect

Responsibilities:

  • Administer the production and development Business Object Enterprise environments, including security, performance and maintenance.
  • Created reports for the existing DCStat universe which includes drill down reports up to 3 levels of drilling data.
  • Created summary reports for transparency web site.
  • Developed Peoplesoft, Pass, Capstat Analysis and CAD universes and solved loops by creating aliases, contexts and resolved traps.
  • Worked in Requirement Gathering, Data Model and ETL for the Disbursements part of the Enterprise Data Warehouse.
  • Worked in performance tuning of the existing ETL jobs to handle the high data volumes because of mass updates.
  • Worked in customizing / defining process for De-Duplication, Filter, Validation, Address and Data Cleansing and Enrichment stages to handle data from various source systems, apply validation rules and apply the enrichment rules using Informatica transformations (Country ID, Global / USA Address Cleansing, Data Cleanse, Match) and custom built cross reference tables.
  • Worked in defining the Staging Area (Transient) for Data Migration process of data from multipule source systems like Databases and Flat Files Using Informatica.
  • Developed dashboards using Dashboard builder and Xcelsius.
  • Using Xcelsius creating charts and drilldowns for different types of charts like line charts, pie charts and bar charts.
  • Building and publishing Xcelsius visualizations Using Live Office and QaaWS.
  • Developed Daily, Weekly, Monthly and Yearly Reports for CAD data.
  • Maintained the securities for more than 100 users in Business Objects Environment.
  • Installed the upgrades for Business Objects software both in Production and Development environment.
  • Created Report Templates for consistency in the look & feel of the reports.
  • Created packages for scheduling large amount of reports.
  • Involved in migration of Crystal reports from old version to new version.
  • Experience in dealing with BO tech support to resolve the BO environmental issues.

Environment: Oracle 11/10g, SQL, TOAD, Business intelligence tools, Crystal Reports 2008, Business Objects XIR3, Designer XIR3, Xcelsius 2008,Informatica 8.6, MS Office, Visio, Unix, Windows 2003

Confidential, Herndon, VA

Sr. Data Warehousing Developer

Responsibilities:
  • Implemented a strategy to keep the Business Objects positions product focused for project effectiveness and value.
  • Successfully design, build and implement the BO clusters infrastructure from ground up which uses LDAP SSO customized security solutions.
  • Creating and published as a web service from SQL statement that has been built on a BusinessObjects universe Using Query As A Web Service (QaaWS) tool.
  • Building and publishing Xcelsius visualizations in SWF file format.
  • Using Xcelsius creating charts and drilldowns for different types of charts like line charts, pie charts and bar charts.
  • Changed the universe parameter settings to optimize the performance of universe.
  • Created the reports using Business Objects functionality's like Queries, Slice and Dice, Drill Down, Functions, Cross Tab, Master Detail, Charts and Formula's etc.
  • Created @Aggregate Awareness and @prompt functions used very extensively in the process of creating objects in the universes.
  • Created Web I reports with multiple data providers and synchronized the data using Merge Dimensions option in BO XI R2.
  • Created complex reports by linking data from multiple data providers.
  • Created new Universes and applied row level and object level securities to restrict the data.
  • Train/Mentor a team member, Business User and top level management on Business Objects XI 3.1/XIR2.
  • Scheduling of the report on successful event and save on specific servers using FTP or File System Configuration in Business Objects XI 3.1/XIR2
  • Created Joins, Contexts, and Aliases for resolving Loops, Chasm & Fan traps and checked the Integrity of the Universes.
  • Actively participated in gathering Business Requirements and System Specification from system users.
  • Involved in created newly data model.
  • Developed various Complex Queries, Views for generating various SQL.
  • Developed packages, procedures and functions in PL/SQL for data loading and data processing.
  • Developing and handling the PL/SQL Procedures, Packages, Cursors and Database Triggers.
  • Modified and created Unix shell scripts as required, to improve the handling of incoming data files, automation of the process.
  • Creating and Managing Materialized Views for reporting database.
  • Implemented various AutoSys scripts for scheduling batch jobs, diagnostics and loading process. Maintained the batch processes using Scripts.

Environment: Oracle 11/10g, SQL Server 2000, SQL, Stored Procedures, ER Studio, DBArtisan, MS Access, Business intelligence tools, Crystal Reports 2008, Business Objects XIR3, Business View Manager XIR3, Designer XIR3, Xcelsius 2008, Voyager,Business Objects Data Insight, First Logic, IBM Exeros, MS Office, Visio, HTML,XML, Autosys, Unix, WindowsNT/ 2000.

Confidential, Rochester, MN

Sr. Data Warehousing Developer

Responsibilities:
  • Implemented a strategy to keep the Business Objects positions product focused for project effectiveness and value.
  • Managed by servant leadership, Crystal, Web Intelligence and Semantic Layer development.
  • Logically architect reports that were developed by Crystal reports and Web Intelligent reports developers.
  • Implemented a Crystal Report optimization strategy for report development to obtain optimal performance on Enterprise.
  • Collaborated with developers in order to develop technical specifications out of business specifications and apply it to the suite of Business Objects products (in order to achieve certain specifications, we had to use a suite of products, not just one product).
  • Created Custom SQL and Stored Procedures in DB2 and SQL Server Data Bases.
  • Creating Views, Procedures, Functions, Triggers and Packages.
  • Developed OLAP Reports using Business Objects OLAP Intelligence tool.
  • Creating OLAP Cubes using MS analysis Services.
  • Participated in installing the Business Objects, Web Intelligence (Webi), and Application Foundation, Created Business Object Repository and Application Foundation Repository and User Groups.
  • Configured Application Foundation system setup - Connection, System User, Settings, Time configuration, Calendar, Parameters, Publish repository Analytics.
  • Tuned the Application foundation clusters to improve performance, to improve we tried both cluster nodes and cluster managers
  • Successfully design, build and implement the BO clusters infrastructure from ground up which uses LDAP SSO customized security solutions.
  • Creating and published as a web service from SQL statement that has been built on a BusinessObjects universe Using Query As A Web Service (QaaWS) tool.
  • Building and publishing Xcelsius visualizations in SWF file format.
  • Install, configure and maintain BO servers for all Prod and Non-Prod environments.
  • Test and fine tune the entire BO infrastructure, including server parameter configuration and tuning, sizing the environment based on the business requirements, customizing front-end Crystal, Universe and Webi applications.
  • Conduct network impact assessments, capacity planning and testing on infrastructure and all BO components to ensure environment and report to meet SLA.
  • Created Business View and Universes using Business View Manager and Business Objects Designer.
  • Created various reports using Web Intelligence and Crystal reports.
  • Orchestrated a proof-of-concept of BO’s Xcelsius, Performance & Dashboard Manager in order to resolve navigation and user load issues.
  • Particiapted the design and development effort for the Corporate and Department Dashboards using BO’s Web Intelligence, Performance and Dashboard Manager.
  • Created Unix shell automating stored procedures and etl Jobs.
  • Creating Metric, trend analytics, Goals, Rules and Alerts Using Performance manager.
  • Proactively and reactively resolved BO product issues for the developers and administrators.
  • Creating User, Groups, Folders and Managing security using CMC.
  • Administrating Business Objects enterprise using CMC.
  • Transferring system and report debug & optimization knowledge for BOE and CR to internal report developers.
  • Worked on Data Integrator tool - Source Analyzer, Data warehousing designer, Mapping Designer and Transformations.
  • Participated in the development of Data Integrator mappings and tuned existing mappings for better performance.

Environment: DB2, SQL Server 2000, SQL, Stored Procedures, Power Designer, Rapid SQL, AQT, MS Access, Crystal Reports 2008, Business Objects XIR3, Business View Manager XIR3, Designer XIR3, Performance Manager XIR2, Xcelsius 2008, Voyager, Data Integrator XIR3,Tomcat,MS Office, Visio, Remedy ITSM 6.0, HTML, Unix, WindowsNT/ 2000.

Confidential,Anaheim, CA

Data Warehousing Developer

Responsibilities:
  • Participated in installing the Business Objects, Web Intelligence (Webi), and Application Foundation, Created Business Object Repository and Application Foundation Repository and User Groups.
  • Configured Application Foundation system setup - Connection, System User, Settings, Time configuration, Calendar, Parameters, Publish repository Analytics.
  • Tuned the Application foundation clusters to improve performance, to improve we tried both cluster nodes and cluster managers
  • Use of Designer module to implement Universes, linkages between tables, creating prompts and queries, parsing the Universes, applying contexts and alias tables to remove cyclic dependencies.
  • Migrating universes and reports from 6.1 repository to 6.5 repository.
  • Creation of different types of reports, such as: Master/ Detail, Cross Tab, Chart (for trend analysis) and SDK. Use of filters, conditions, calculations, etc.
  • Testing the existing B.O. reports, scheduler and security functionality with multiple profiles.
  • Developing of Universe and transforming and customizing it to suit Application Foundation 6.x with Dashboard manager.
  • Scheduled BO reports through Broad Cast Agent.
  • Monitored the reports that were scheduled through Broad Cast Agent console
  • Crystal Enterprise Edition is used to design, develop and Implement business analysis reports.
  • Use of Designer module to implement Universes, linkages between tables, creating prompts and queries, parsing the Universes, applying contexts and alias tables to remove cyclic dependencies.
  • Fine tuning of the Universe depending on the users requirements
  • Created user profiles (Supervisor duties)
  • Installation of Business Objects 5.1.6 including upgrade from 5.1.2
  • Provided BO training for end users.
  • Scheduled Documents on daily, weekly, and monthly bases.
  • Monitoring the Broadcast Agent.
  • Writing macros to enhance the performance of broadcast agent by reducing the load on broadcast agent.
  • Co-ordinate with Team members working on Power Center ETL Tool to extract data’s from different OLTP Servers to OLAP Server.
  • Designed and developed complex aggregate, join, look up transformation rules (business rules) to generate consolidated (fact/summary) data identified by dimensions using Informatica ETL (Power Center) tool. .
  • Used the Slowly Changing Dimension wizard to update the data in the target dimension tables.
  • Created pre and post session Stored Procedures Using SQL, PL/SQL to drop and recreate the indexes for better performance while loading the data to the target Data warehouse
  • Scheduled and monitored transformation processes using Informatica Server Manager/Workflow Manager.
  • Worked on Informatica tool - Source Analyzer, Data warehousing designer, Mapping Designer & Mapplet, and Transformations.
  • Creating and managing Materialized Views.
  • Participated in the development of Informatica mappings and tuned existing mappings for better performance.
  • Participated in the design of Informatica mappings, sessions, batches, refresh strategy, scheduling, dependency, event triggers, post/pre batch processing & parallel processing.
  • Various features of PL/SQL such as Dynamic SQL and parameter passing of PL/SQL tables were evaluated. Developed Procedures, Functions, Views, Database triggers.
  • Participated in developing PL/SQL scripts in case bad data is loaded into the Oracle Tables.
  • Wrote UNIX Shell Scripts for loading data and PL/SQL scripts for validating data. These Shell scripts were called from the scheduler to automate the process.
  • Developed Web application for end users using Servlets, JSP, XML, HTML and JDBC to view requested Data/Reports under Weblogic server.
  • Lead and facilitated the effort for transiting Weblogic driven application into Java WebServer environment.
  • Developed Windows fat client application using C# .NET and ADO.NET
  • Conducted Unit, Integration and Stress Test.
  • Translated business requirements into data mart design.
  • Understood basic business analysis concepts for logical data modeling data flow processing and database design. Utilized skills for problem solving
  • Assisted in the analysis, design, coding and development of building a new schema (staging tables, views, SQL files).
  • Performed Data Modeling by using Visio, Erwin.
  • Developed a front-end portal to access data from the data mart in a user-friendly web browser environment.
  • Created real time JMS Queues using ESB as Source and created reports and charts using Informatica Power analyzer.

Environment: Oracle 8i/ 9i,SQL Server 2000, DB2, SQL, PL/SQL, Erwin, TOAD, DBArtisan, MS Access, Crystal Reports, Business Objects 6x, Supervisor, Designer,Auditor, Application Foundation 6.x, Reporter, Broadcast Agent, Informatica Power Analyzer 4.x/ 5, Informatica 6.x/ 7.x, HTML,XML,XSL,XSLT,Java,JSP, Weblogic 8.x, Unix Shell Script, Unix, WindowsNT/2000.

Confidential, Tampa, FL

DataBase and Reporting Developer

Responsibilities:
  • Developed Personalized Dashboards with Analytics Alerts and Rules in Application Foundation
  • Created Users, User Groups and Categories.
  • Collected requirements, writing specifications for generation of reports.
  • Extensively used Business Objects, WebI and Application Foundation for Business Intelligent reports
  • Worked on Business objects SDK to create complicate reports.
  • Developed the user interface using JSPs, HTML and front-end validations using Java Script.
  • Designed, developed, maintained and tested universes for supporting adhoc queries and canned reports
  • Supported the users with their Business Objects related problems
  • Developing of Universe and transforming and customizing it to suit Application Foundation 3.0.2 with Dashboard manager.
  • Used the Application Foundation components Dash board manager, Set analyzer, Statistical process control, Developers Suite, Time series Analyzer.
  • Monitoring the Broadcast Agent.
  • Scheduled BO reports through Broad Cast Agent.
  • Crystal Reports are developed using all modes of analytical functionality to achieve and implements business reports.
  • Developing departmental reports for performance and response purposes by using Business Objects, Visual Basic (Macro’s).
  • Created complex reports by linking data from multiple sources, using functionalities like Combined Queries, Slice and Dice, Drill Down, Master Detail, etc.
  • Performed in depth analysis and data & prepared weekly, biweekly, monthly reports by using Business Objects.
  • Designed & developed various departmental reports by using Cognos, Business Objects, SQL, PL/SQL, Ms Excel.
  • Created reports using Universe, Free-Hand SQL, and Stored Procedures Data providers.
  • Created and managed Universes, Joining two Universes and Categories using supervisor module.
  • Resolved the loops using Aliases and Contexts.
  • Supported the data warehouse and resolved the issues in load processes
  • Developed PL/SQL scripts for the data cleansing and to load the data from source system to the staging area.
  • Used Informatica Repository Manager to create the repositories and user groups.
  • Developed mappings using Informatica Power Mart Designer to load the data from the staging database to the presentation database
  • Used Informatica Server Manager to create, schedule, monitor the sessions and to send the notification messages to the concerned personnel in case of process failures.
  • Regular modifications to the Data Model using Erwin.
  • Building the proper relations between the Attributes and tables or Lookup Tables, which are available for every relevant Dimensions.
  • Scheduled and monitored transformation processes using Informatica Server Manager/ Workflow Manager.
  • Used Dynamic, persistent and Static Caching while developing mappings and sessions
  • Interface with users and business analysts to gather information and requirements.
  • Developed databases and data warehouse. Analyzed and specifying specific data requirements.
  • Extraction, Transformation and Loading of the data Using Informatica Power center.
  • Worked on Informatica tools - Source Analyzer, Warehouse designer, Mapping Designer and Transformation Developer.
  • Assisted with the Design and coding and implementation of new production and data storage systems.
  • Understood basic business analysis concepts for logical data modeling, data flow processing and data base design. Utilized skills for problem solving.
  • Created tables, indexes, views, snap shots.
  • Loading data by using SQL*LODER to custom tables.
  • Analyzing data that comes from different sources and to write packages for maintaining a standard format.

Environment: Oracle 8i/9i,SQL Server 2000, Teradata, SQL, PL/SQL, SQL*Loader, ERwin, TOAD, MS ACCESS, Crystal Reports, Business Objects 5/ 6, Supervisor, Designer, Application Foundation, Reporter, Broadcast Agent, Brio 7, SAS, Informatica 6.x, Websphere 4.0, Java, JSP, HTML, Humming Bird, Ftp, Unix, Unix Shell Script, WindowsNT/ 2000

Confidential

Programmer Analyst

Responsibilities:
  • Designed new screens and new tables required for the new requirements.
  • PL/SQL was extensively utilized for coding and writing complex database triggers, stored procedures and packages.
  • SQL*LOADER was used for data loading.
  • Power User was used for interfacing with GUI.
  • Participated in creating reports by using Info reports.

Environment: Oracle 7.3, PL/SQL, stored procedures, triggers and packages & SQL * Loader.

We'd love your feedback!