SUMMARY

• 10+ years of experience in gathering Business Requirements, Analysis, Design, Development, Testing, Implementations and Documentation of various functionalities of Data Warehouse / Data Marts and Business Intelligence
• Expertise in complete lifecycle Implementation of Business Intelligence with Star and Snow flake Schemas using Ralph Kimball and Bill Inmon Methodology
• Extensive Business Intelligence and Data warehousing experience using OBIEE 11g/OBIEE 10g/Siebel Analytics 7.x, Oracle BI Apps7.9.x OBIEE Prebuilt, BI Publisher 11g, Informatica 7.x/6.x and DAC.
• Strong Experience in implementing the Oracle BI Financial, Sales, Marketing, HR,SCOM Analytics in respect with integrating ERP Systems like PeopleSoft, Oracle EBS.
• Extensive Experience in OBIEE Administrative Tool, OBIEE Answers/Analysis, OBIEE Dashboards, OBIEE Delivers and BI Publisher in designing, developing and with prebuilt.
• Very strong experience in developing Siebel/OBIEE Analytics Repository (.rpd) - three layers (Physical Layer, Business Model & Presentation Layer), Time Series Objects, Siebel/OBIEE Interactive Dashboards with drill-down capabilities using global & local Filters, Siebel/OBIEE Security Setup (groups, access / report level and object level), configured Analytics Metadata objects (Subject Area, Table, Column), Web Catalog Objects (Dashboard, Pages, Folders, Reports) and scheduling iBots/Agents.
• Good Experience in managing the OBIEE 11g Web logic Console and Enterprise Manager.
• Very strong in developing Informatica Mappings / Mapplets using various Transformations for Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse and creating Workflows with Worklets & Tasks and scheduling sing both Workflow Manager and Unix Shell scripts (using pmcmd)
• Expertise in database Performance Tuning by implementing Parallel Execution, Partitions, materialized views with query rewriting, creating appropriate indexes, usage of hints, re-building indexes and also used the Explain Plan and SQL Tracing. Good Experience in Map Builder and Map Viewer.
• Good Knowledge in Hyperion Essbase, ODI 11g and Tableau.
• Good Working Knowledge in creating KPI’s and Scorecards in OBIEE 11.1.1.3/.5/.6.
• Good Knowledge in PL/SQL Procedures, Packages, Functions, Triggers and other objects.
• Experience in working with different operating systems like HP UNIX, Solaris and Windows NT/2000/XP.
• Excellent interpersonal and communication skills, and is experienced in working with senior level managers and developers across multiple disciplines.
• Experience in all phases of the System life Cycle including project definition, analysis, design, coding, testing, implementation and Production support.

TECHNICAL SKILLS

• OBIEE11.1.1.3/11.1.1.5/11.1.1.7, OBIEE 10.1.3.4.1, Siebel Analytics 7.x (Admin, Web, Answers, Dashboards
• Scheduler, BI Publisher 11.1.1.7, Oracle Discoverer, BI Apps 7.9.x, Tableau Peoplesoft, Oracle EBS R12.
• Informatica 7.x/6.x/5.1 (Power Center / Power Mart & Power Connect), DAC, ODI 11g,
• Essbase-Hyperion, ERWIN, SAS 9.1
• Oracle 8.x/9i/10g/11g, MS-SQL, SQL Server 2008
• SQL*PLUS 8.x/9.x, PL/SQL 8.x/9.x
• C, C++, Java, HTML, Map Builder.
• Windows 95/98/NT/2000/XP, Sun Solaris, HP Unix

PROFESSIONAL EXPERIENCE

Confidential, NJ

OBIEE Lead

Responsibilities:

• Involved in requirements gathering of the various work streams by meeting with the business user, performed Gap Analysis and Data Analysis.
• Implemented projects by using Agile and Waterfall methodology.
• Involved in designing the dimensional model and suggested as per the reporting requirements.
• Created POC based on the Benchmark and Equities projects requirements.
• Converted GEMS and IDSS application reports to OBIEE reports.
• Effectively managed ODBC connections and imported the Physical tables, Primary keys and foreign keys as per the Business Requirements.
• Developed Metadata Layer (RPD) for the different work streams with the necessary logic that involved creating the Physical, BMM and the Presentation layer.
• Created Dimensional Hierarchy for all Dimensions, Weighted Average Logical Columns and Level based Measures in BMM layer.
• Developed Complex Reports by using the Different Views like Table, Pivot, Chart, Link, Narrative View, Column Selector, View Selector and Combined with Similar Requests.
• Configured IBOT’s/Agents for delivering alerts and for Cache Seeding.
• Implemented Event Polling Table for Cache management.
• Used service now for open the Incidents (Tickets) and request for application access
• Enhanced performance of Reports / Dashboards by implementing the Materialized Views, Table partitions, re-building of indexes, managing Cache and following best practices in RPD etc.
• Debugged reports and Dashboards visibility with respect to user’s responsibility and web groups in an integrated environment.
• Performed Unit, Integration testing to validate report and worked closely with the users and QA team to resolve the ongoing production Issues.
• Involved in complete SDLC life cycle by adhering to Client specific quality processes and align them with client quality Standards.
• Created custom Reports in Usage tracking reports for User Acceleration.
• Upgraded OBIEE 10g RPD and Web Catalog to OBIEE 11g by using ua.bat file and Fixed upgraded errors and warnings in RPD, Fixed Style and Skin related issues in Report/Dashboards.
• Deployed OBIEE 11g RPD and Web Catalog by using Web logic Enterprise Manager.
• Compared OBIEE 10g reports/dashboards with OBIEE 11g reports/dashboards and fixed formatting issues.
• Added new Tags and updated existing parameters in Instanceconfig.ini and NQSConfig.ini by manually and using Web logic Enterprise Manager.
• Deployed analyticsRes Folder by using Web logic Console and implemented Query Blocking and Custom Links.
• Duplicated S blaf and SK blaf folders to S FixecIncome and SK FixedIncome folders and modified CSS Tags in View.css as per the Users requirements.
• Improved performance by setting the heap memory and Cache parameters using Web logic console and enterprise manager
• Implemented Object Level Security by creating roles & web groups using External tables and web logic console.
• Opened several Oracle SR’s for product issues and regularly interacted with Oracle support team, development team and worked closely with Oracle in resolving product Bugs.
• Converted Actuate reports to BI Publisher reports by creating complex Queries and Templates.
• Created multiple complex RTF and Excel templates.
• Fixed Production issues, support Production Migration.
• Receive Production INCIDENTs from Team Lead, as per Incidents fix the Production Issues.
• Involved in preparing the TDD’s, UDD’s and Impact analysis document.
• Regularly interacted with Admin team for migrating RPD and Web catalog to higher environments.
• Developed KPI’s and Scorecard’s for users, which help them reviewing their Business performance.

Environment: OBIEE 10.1.3.4.1/OBIEE 11.1.1.5/11.1.1.7, BI Publisher 11g, Oracle 11g, MS Office Visio 2003, Oracle SQL Developer, Mercury Quality Center, Unix.

Confidential, NY

Sr. OBIEE Developer

Responsibilities:

• Interacted with Business Users and Business Analysts for gathering business requirements and also understand the current requirements and Data Analysis.
• Involved in designing the dimensional model for Equity Commission project as per the reporting requirements by using the Microsoft Visio.
• Prepared Technical Requirement documentation based on reporting requirements.
• Designed and Developed OBIEE Repository.
• Worked extensively on OBIEE Repository and Dashboards.
• Created number of Complex measures and Logical columns in BMM Layer as per business requirements by using Different TimeSeries functions like Ago, Todate and other Business logics.
• Created lot of dynamic repository variables and Initialization Blocks for different purpose.
• Developed Complex Reports by using the Different Views like Table, Pivot, Chart, Static View, Narrative View, Column Selector, View Selector, Combined with Similar Requests and GO URL.
• Extensively used HTML Script for Designing the Welcome Page and other customization purpose.
• Enhanced performance of Reports / Dashboards by implementing the Aggregate tables, Aggregate Navigation, Table partitions, Proper indexes, managing Cache and following Best Practices etc.
• Extensively working on Merging and Migration of RPD and Catalog to higher environment on a weekly basis.
• Implemented the Security by creating the Users, Groups, Web Groups In RPD and Web Catalog
• Implemented external tables for Authentications and Authorization by using VPD.
• Performed Unit testing to validate report and fixed the issues opened by QA and BA team.
• Upgraded Institutional Sales RPD and Catalog from OBIEE 10.1.3.4 to OBIEE 11.1.1.5 by using ua.bat file and deployed RPD and catalog by using the Enterprise Manager.
• Resolved Post Upgrade RPD Consistency check issue and fixed all the issue related to reports and dashboard after the upgrade in 11g.
• Created Users and Groups in the Embedded Web logic LDAP Server by using Oracle Web logic Server Administration Console.
• Modified default Configuration settings in NQSconfig.INI by using the Enterprise Manager and added new tags in instanceconfig.INI files as per OBIEE 10g configuration files.

Environment: OBIEE 10.1.3.4.1, OBIEE 11.1.1.5, Informatica 8.6.1, Oracle10g, Microsoft Visio, SQL Developer, Linux and Windows XP.

Confidential, NJ

OBI Lead

Responsibilities:

• Involved in requirements gathering of the various work streams by meeting with the business user and base lining the details.
• Involved in assisting building detailed project schedule, gathering the requirement, completed the proof of concept in translating functional requirements into technical requirements, designed, developed and making Technical designs and Unit test scripts
• Created Technical Requirement based on BRD functional document for (Order Management, Order Fulfillment and Inventory Etc)
• Configured out-of-the box and custom Analytics Reporting functionality of Supply Chain and Order Management Analytics using OBI Answers.
• Expertise in Data Analysis, Performing Gap Analysis, Identification of dimensions (type-1, type-2 and type-3), Facts & aggregate tables, Measures and Hierarchies.
• Involved in designing and development of building Physical Layer, Business model and presentation layer and report development.
• Developed the repository model for the different work streams with the necessary logic that involved creating the Physical, BMM and Presentation layer. Also created hierarchies and variables in the repository
• Defined dimensional hierarchies and associated the proper level of granularity to the fact table.
• Created Time Series Metrics by using Ago and Todate functions.
• Modified many logical Metrics/Columns by duplicating as per the requirements.
• Implemented Multiple Currency metrics for SCOM, POS and Performance dashboard by using Static, Session and Request variables.
• Involved in implementing the Security by creating the Users, Groups, Web Groups In RPD and Web Catalog
• Implemented external tables for Authorization and LDAP for Authentication.
• Created Complex Reports by using Pivot, Table, Chart, Column selector, View Selector and Union view for POS and Performance Reports/Dashboards.
• Enabled Usage Tracking and Dashboards to track performance by updating the NQSconfig.INI file.
• Migrated RPD and Catalog from Dev Windows’s environment to QA Linux environment by using the WinScp and Catalog Manager.

Environment: OBIEE 10.1.3.4.1, OBI Apps 9.6.1, Informatica 8.6.1, DAC 10.1.3.4.1,Oracle11g, Oracle EBS R 12,Siebel CRM, SQL Developer, Linux and Windows Server 2003.

Confidential, GA

Technical Lead/Administrator

Responsibilities:

• Installed OBIEE 11.1.1.3 on Windows Server 2003 Environment.
• Installed Repository Creation Utility on Oracle 11g Database
• Upgraded RPD and Catalog from OBIEE 10.1.3.4.1 to OBIEE 11.1.1.3 by using ua.bat file. Performed Any Required Post-Upgrade Manual Steps for Oracle BI EE.
• Resolved Post Upgrade RPD Consistency check issue and fixed all the issue related to reports and dashboard after the upgrade in 11g.
• Deployed OBIEE 11g RPD and Catalog by using Enterprise Manager.
• Compared OBIEE 10g reports and Dashboards with OBIEE 11g Reports and Dashboards.
• Added new Tags into the OBIEE 11.1.1.3 instanceconfig.xml file resolve the report and dashboard issues like Graph engine is not responding, pivot table/charts display twenty five rows by default etc.
• Opened Service Requests (SR’s) for RPD and Reports issues.
• Regularly coordinated with Oracle support team for resolution of the Issues.
• Created Users and Groups in the Embedded Web logic LDAP Server by using Oracle Web logic Server Administration Console.
• Created Application Roles and Policies using Fusion Middleware Control and mapped Application roles to the Groups.
• Implemented Security by using External table Authentication.
• Created different Views like Table, Pivot, Graph, Narrative, Static, Filter for testing purpose.
• Cleared cache through manually and running the Cache scripts.
• Good knowledge in developing Scorecards and KPI’s.
• Migrated and upgraded RPD’s from OBIEE 10.1.3.4.1 to OBIEE 11.1.1.3 by using UDML Script.
• Migrated Catalog from OBIEE 10.1.3.4.1 QA Environment to OBIEE 10.1.3.4.1 PROD Environment by Using Catalog Manger after that upgraded to OBIEE 11.1.1.3 by using up gradation utility.

Environment: OBIEE 11.1.1.3, OBIEE 10.1.3.4.1, Oracle11g, SQL Developer and Windows Server 2003.

Confidential, PA

Sr.OBIEE Developer

Responsibilities:

• Involved in requirements gathering of the various work streams by meeting with the business user and base lining the details.
• Involved in designing the dimensional model and I have given suggestions as per the reporting requirements.
• Implemented Dimensional modeling in the database and created appropriate views along with DBA to acquire the Metadata for the given requirement.
• Developed the repository model for the different work streams with the necessary logic that involved creating the Physical, BMM and the Presentation layer. Also created hierarchies, variables, and Implicit Fact Column in the repository.
• Developed Dashboards/Reports using the Oracle Business Intelligence Analytics platform for requirement analysis.
• Developed Complex Reports by using the Different Views like Table, Pivot, Chart, Guages, Static View, Narrative View, Column Selector, View Selector and Combined with Similar Requests.
• Extensively used Guided Navigation for user friendly reports.
• Implemented Security by creating roles & web groups using External tables and LDAP.
• Enhanced performance of Reports / Dashboards by implementing the Aggregate tables, Materialized Views, Table partitions, re-building of indexes and managing Cache etc.
• Worked extensively with Custom Style Sheets in the Reporting Environment.
• Duplicated S Oracle10 and SK Oracle10 folders to S Mortgage and SK Mortgage folders and modified CSS Tags as per the Report and Dashboard requirement.
• Deployed Map Viewer and Integrated Map builder with OBIEE by creating the Spatial Data in database and Created different Maps using Different Themes, Colors and Markers.
• Created Data source and Map Meta data Cache in Map viewer console.
• Created Different Themes, Colors, Lines and Advanced Styles in Map Viewer by using Spatial Data.
• Created Bas Maps by Using the Different Themes.
• Extensive Experience in testing and Production Support.

Environment: OBIEE 10.1.3.4.1, BI Publisher, Oracle10g, SQL Developer, PL/SQL, Map Builder, Erwin, Quality Center and Windows XP.

Confidential, CA

BI Apps/OBIEE Developer

Responsibilities:

• Involved in assisting building detailed project schedule, gathering the requirement, completed the proof of concept in translating functional requirements into technical requirements, designed, developed and making Technical designs and Unit test scripts
• Gathered requirements from the users and generated prototype reports to help the business to visualize the design.
• Installed the Oracle BI Applications(informatica, DAC,OBIEE) on distributed environment and configured the OOB Oracle Financial Prebuilt Analytics and responsible for administration and migration of repositories between various environments
• Responsible for all activities related to the development, implementation, administration and support of ETL processes and for scheduling using DAC and reporting using OBIEE
• Customized and developed approach to load data into GL Star, AP Star, AR Star, Budget star Data Models using ETL tool Informatica
• Configured DAC - Data warehouse Access control for running of ETL jobs
• Worked with all three layers in the repository - Physical, Business, and Presentation Layer.
• Worked on security for users based on LDAP Authentication type in Production and also other Authentication types (External table authentication and Database) in other environments.
• Implemented the Cache Purging Strategy and usage tracking of Reports
• Implemented the Implicit Fact column for all Subject areas
• Defined dimensional hierarchies and associated the proper level of granularity to the fact table.
• Added column/data level security at the repository level. The data was restricted with respect to the group user belongs too.
• Created Summary and Detail reports according to user requirements and also created corresponding dashboards for the reports.
• Customized Out Of Box Dashboards and Reports as per the User requirements given by the client.
• Actively involved in deployment and post release support.
• Trained the users on how to use the Dashboards and Answers and also modify the stored reports in Answers.

Environment: Oracle BI Apps 7.9.5/7.9.6, OBIEE 10.1.3.4, Informatica 8.1.1, DAC, OBAW, Oracle10g, SQL Developer, Oracle E-Business Suite 11.5.10, R 12, PL/SQL.

Confidential, MA

OBIEE Consultant

Responsibilities:

• Interacted with Business Users and Business Analysts for gathering new business requirements and also understand the current requirements and Data Analysis.
• Migrated Oracle Discoverer Metadata to OBIEE Metadata (RPD).
• Applied Additional joins between facts and dimensions as per requirements.
• Created new logical columns as per reporting requirements.
• Created new logical columns by using the Time series functions as per specifications.
• Implementing comprehensive Security functionality by importing users and groups from OID, setting up LDAP (OID) authentication and associating catalog objects and web modules with the created users and groups.
• Implemented Authorization by using VPD and External Table.
• Created different reports by using Table, Pivot, Chart, Narrative Views etc.
• Designed Dashboard as per specifications.
• Configured of Scheduler, Delivers and Cache Seeding by using IBots.
• Implemented Write Back Facility for entering the User names and group names into the Database.
• Onsite/Offshore Coordination.
• Migrated Catalog’s and RPD’s from different environments by using PSFTP, Putty.
• Involving in Unit Testing, Validating Reports and production support.
• Working closely with Users, Developers, Administrators and Testers to resolve ongoing Production Problems by reviewing design changes made to production systems and made corresponding changes to Repository.

Environment: OBIEE 10.1.3.4, Oracle Discoverer, Oracle 10g, PSFTP, Putty, Windows XP and UNIX.

Confidential, MA

OBIEE Consultant

Responsibilities:

• Interacted with Business Users and Business Analysts for gathering new business requirements and also understand the current requirements, performed GAP Analysis, and Data Analysis.
• Involved in modifications on the Repository Metadata.
• Developed Logical Columns in Business Model Layer based on Business Requirements by using Time Series Objects and business logic’s, and creating the Presentation catalogs in Presentation Layer.
• Developed different kinds of Reports using Table and Pivot Views, View Selectors, Column Selectors, Narrative Views, Static Views, Chart and Plot Views, Title Views and Interactive Dashboards with drill-down capabilities, charts, tabular using global and local Filters, and Page/Dashboard Prompts.
• Developed different kinds of complex reports using Unions and Flex Edges.
• Developed different kind of reports using BI Publisher.
• Extensively used Dynamic Section Prompts and Guided Navigation in dashboards.
• Debugged reports and Dashboards visibility with respect to user’s responsibility and web groups in an integrated environment.
• Involved in Upgrade process of the entire infrastructure from OBIEE 10.1.3.3.2 to OBIEE 10.1.3.4.
• Performed the Performance Tuning of Dashboards/Reports and made required changes to repository and database.
• Performed Unit testing to validate report.
• Involved in UAT and post Production Support.
• Migrated Web Catalog and RPD from different environments by using PVCS.
• Worked closely with Users, Developers, Administrators and Testers to resolve ongoing Production Problems by reviewing design changes made to production systems and made corresponding changes to Repository.

Environment: OBIEE 10.1.3.4, BI Publisher, Oracle E-Business Suite, Oracle 9i/10g, Flex, PVCS, Windows XP and UNIX.

Confidential, MI

OBIEE Consultant

Responsibilities:

• Interacted with Business users for gathering Reporting Requirements.
• Designed Dimensional modeling based on Requirements and E-R model using Erwin Tool.
• Designed and Developed the OBIEE metadata Repository using OBIEE Admin tool by importing the required objects with integrity Constraints into physical layer using connection pool
• Created Aliases for all physical tables to avoid circular joins and self joins.
• Imported objects from different data sources like Excel and Text files and further created logical columns with them as per the requirement.
• Created Drill-Down Hierarchies and set the estimated levels in Hierarchies, Logical columns & manipulated Fact column in BMM Layer as per requirement using Calculation Wizard like Percentage Change and Index Columns.
• Created Time Series objects for comparing business performance with previous time periods using Ago and ToDate Functions.
• Implemented Security by creating Users and groups and setting the Logging levels for each user.
• Integrated LDAP Server with OBIEE by creating servercert.perm, serverkey.perm and serverpwd files in Config folder and also updated Config file then created LDAP connection.Imported users and synchronized users with LDAP server.
• Enabled Usage tracking in NQSconfig file and also imported prebuilt Usage Tracking Repository.
• Developed Different Reports with different Analytic Views (Tables, Pivot Tables, Charts, Column and View Selectors, Narrative, Tabular with Global and Local Filters) using presentation services.
• Generated Drill down Reports, Drill down Charts, Summary Reports, Navigational Reports, Subreports, Linking Reports etc.
• Configured Scheduler by creating Scheduler tables in database
• Configured iBots by running Crypto tools and delivered reports to users through different devices like email, mobile etc.
• Integrated and Created BI Publisher Reports.
• Imported SAP BW cubes into the RPD and generated reports as per the specifications.
• Installed Briefing Books, Excel Add-In and customized Login screen.
• Performance Tuning of Repository and Reports by setting Cache, limiting the number of initialization blocks, limiting select table types, pushing the calculation to the database, setting the NQSConfig.ini parameters.
• Performed Unit, Integration Testing to Validate the Report.
• Worked closely with Users, Modelers and Administrators to resolve ongoing production Problems by reviewing design changes made to production systems.

Environment: OBIEE, BI Publisher, Oracle 10g, ERWIN, SAP BW, Windows XP

Confidential, MA

Sr. Siebel Analytics Consultant

Responsibilities:

• Interacted with business representatives for gathering the Reports / Dashboards requirements and to define business and functional specifications
• Designed and developed the OBIEE Metadata Repository (.rpd) using OBIEE Server Admin tool by importing the required objects (Dimensions and Facts) with integrity constraints into Physical Layer using connection pool, developing multiple Dimensions (Drill-Down Hierarchies) & Logical & Facts / Measures objects in Business Model Layer, and creating the Presentation catalogs in Presentation Layer
• Developed many Operation Solutions Time Series objects for comparing the usage variations between the quarters
• Developed many Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Cascading Style Sheets, Pivot Table, Chart, Column Selector, Tabular with global and local Filters) using Presentation Services
• Configured iBots to deliver content based reports on schedule, automated iBot queries to obtain daily and weekly reports
• Implemented security by creating roles & web groups, checks with External tables and LDAP
• Involved in developing the Incremental ETL process i.e., Mappings & Mapplets using various Transformations and Workflows with Sessions / Tasks. Executed the workflows through shell scripts using pmcmd
• Performed Unit, Integration, and Regression testing to validate report and mapping functionality
• Worked closely with Users, Developers and Administrators to resolve ongoing Production Problems by reviewing design changes made to production systems and made corresponding changes to the OBIEE Repository

Environment: OBIEE, Siebel Analytics 7.x, Informatica Power Center 6.x/7.x, Oracle 9i/10g, DB2, HP UNIX

Confidential

Siebel Analytics / Informatica Consultant

Responsibilities:

• Gathered user requirements from business representatives and convert them into functional and technical specifications
• Created/Modified Metadata repository (.rpd) and Configured Metadata Objects using Siebel Analytics Server Admin tool
• Configured measures in the Business Model Layer and mapped to multiple logical source tables
• Worked on Siebel Answers to build Interactive Dashboards with drill-down capabilities
• Implemented dynamic dashboard prompts to zoom into particular segments of the business in a performance-optimized manner
• Created templates for presenting results and Analytics and modified the Siebel Dashboard using cascading style sheets
• Worked closely with Users, Developers and Administrators to resolve ongoing Production Problems by reviewing design changes made to production systems
• Developed Mappings/Mapplets and Workflows using various Transformations (Update Strategy, Router, Expression, and Aggregator)
• Designed and documented the validation rules, error handling and test strategy of the mapping
• Tuned the sessions for better performance by implementing the partitions

Environment: Siebel Analytics 7.x, Informatica Power Center 6.x, Oracle 9i

SAS Programmer

Confidential

Responsibilities:

• Programming in SAS for analyzing data and producing tables and listings for safety and efficacy analysis in specified formats for submission or for other purposes.
• As a Programmer generation of clinical data summary tables/Listings/graphs and reports using SAS.
• Interacting with Data managers, Statisticians and CRA’s in clinical research and development of individual will provide programming support to the Processing of clinical data.
• Extensive experience in ED and Algorithm Development Activities.
• Receiving the UIMS tickets from Team Leader, I read about tickets, Creates the Duplicate protocol and demote the Macro’s from System level to Protocol level and then modify the code in emacs according to the UIMS tickets follows the PDS Data Standards.
• Modifying the System Level Code and Protocol Level Code.
• Extensively used different Base SAS Procedures like Proc Sql, Proc Contents, Proc Print, Proc Sort, Proc Append etc.
• Extensively used different SAS/STAT Procedures like Proc Means, Proc Summary, Proc Univaraite, Proc GLM etc.
• Extensively used PROC REPORT and PROC SQL Procedures.
• Programming with the use of Base SAS and SAS/MACROS.
• Involved in writing Test Plans, Test cases and coordinating the Global Contacts; clarify the observed issues with global contact person and gives the any suggestions is required.

Environment: CDARS, DT, Base SAS v8.2, SAS/Macros, SAS/SQL, SAS/Connect, SAS/Access, SAS/Stat, SAS/ODS, SAS/Graph, Oracle Clinical, WINDOWS XP AND UNIX.

SAS Programmer

Confidential

Responsibilities:

• Receives the Report Design Specification (RDS) from the Primary Contact, Distribute the Task to the Team members.
• Extracting the data from Database using SAS/ACCESS, SAS/SQL Procedures and create the Data Set.
• Involved in writing the code using Base SAS and SAS/MACROS to Extract, Clean and Validate data from Oracle and MS Excel tables by using Proc Sort, Proc Freq, Proc Means, Proc Print, Data Null .
• Generate Reports and Adhoc Reports based on the requirements using Proc Sort, Proc Tabulate, Proc Report, and Proc Print.
• Retrieve the data from Oracle and MS Excel received from CRA and converted to SAS Data sets for analysis using SAS/STAT Procedures such as Proc Means, Proc Freq, Proc Tabulate, Proc ttest, Proc Univaraite etc.
• Generate Charts and Plots based on the Requirements using SAS/GRAPH Procedures such as Proc Gchart, Proc Plot, and Proc Annotate.
• By using the Proc Greplay procedure display and manages graphics output is stored in SAS catalogs. Two or more Plots and Graphics output showed in a single Template.
• Extensively used procedures like Proc Sort, Proc Print, Proc Report, Proc Tabulate, Proc Means, etc. and extensively used SET and MERGE statements.
• Coding the Programs with the use of Base SAS and SAS/MACROS.
• Takes various steps to improve efficiency and performance of the programs.

Environment: BaseSAS v8, SAS/Macros, SAS/SQL, SAS/Access, SAS/Stat, SAS/ODS, SAS/Graph, Oracle9i, MS Excel, Windows NT, UNIX, C++ and VC++.