TECHNICAL SKILLS:

Confidential 8.3. Confidential Report Studio, Confidential Query Studio, Confidential Analysis Studio, Confidential ReportNet, Confidential Impromptu, Confidential Power Play, Confidential Transformer OLAP Modeling, Confidential Report Authoring, Confidential Framework Manager, Oracle Developer 2000,Oracle Forms, Oracle Reports, Actuate Reports, Gasp 6.5, Loftware, MS Office.Business Objects 5.0, Web Intelligence 2.6, Crystal Reports, Oracle 8.0,8i Reports, Informatica, Pascal, QBasic, AUTOCAD, XML, DHTML, Macromedia Flash 4, Microsoft Visio/PowerPoint, Web Design, COBOL, CAD/CAM

WORK EXPERIENCE:

DBA/DBP/ SQL/IBM - DataStage Admin/Analyst

Confidential, Carlsbad, CA

Responsibilities:

• Microsoft SQL S erver 2003/2008 , SSIS, PL - SQL, Confidential 10.2 Business Intelligence Software and Oracle database technologies
• SQL ETL and warehousing development and administration work.
• Microsoft Office SharePoint Server 2013 : installing, configuring, troubleshooting, and custom
• SalesForce Enterprise Systems for IT Helpdesk ticketing/cases and storing in GITHUB
• GITHUB cloud repository for source version control with GIT VCS 1.0 using GIT Bash commands (CVCS/DVCS) and SSH key authentication.
• Warehousing using IBM Infosphere Data Stage 8.7 for ETL.
• Created, refreshed and supported Confidential Transformer 10.2.2 BI/Analytics to support timely sales operations.
• Confidential Dashboard designs and Report Bursting to Clients all over the regions.
• Database Administrator and Developer for ORACLE 11G/12c databases.
• Health Care data warehouse application development, support and maintain activities using previous transitions from Oracle 11G to 12C and CPU patch updates
• Oracle CPU patches installation maintenance and database scripting.
• Performed Confidential administrative functions such as creating user accounts , user classes and roles using Access Manager .
• Data warehousing with Integra architecture data into the Confidential machines and servers
• Responsible for analysis,design,coding,component and assembly testing of warehousing owned by the application team.
• Involved in maintenance work (including production support), enhancement and development work
• Integra Life Sciences and SurgioSoft systems and portal usage for BI reporting
• Create, modify and publish Confidential packages using Confidential Transformer/Framework Manager .
• Design the production rollout process for Confidential applications.
• Promoted packages to Production using Import/Export utility.
• Deployed packages from PRODUCTION server to DEV server as well if required.
• Used override selections and new user changes clauses during exports.
• Create,modify and maintain SSIS jobs and Oracle packages .
• Database ETL warehousing and implementation
• Experience with ETL and Data Modeling in IBM Infosphere environment and Confidential Framework Manager.
• Invoice and Order inventory reporting from Integra Stars BI models and analysis
• Develop Confidential 3 tier models using Confidential FM for reporting purposes
• Develop and execute SQL code to meet business requirements for data extracts in MS SQL 2012
• Develop new models for Enterprise Data Warehouse and Reporting tools
• Work with DBA teams to create databases, database objects ( schemas, indexes, triggers , etc)
• SSIS 2008/2012 ETL development, migration and maintenance on the DEV and PROD servers
• SSIS 2012 SSDT updates and conversions from previous DTSX packages
• Using ORACLE 12C database for Confidential systems using ORACLE SQL Developer interface.

SQL DBA Confidential - SQL/DBP/BI Developer/Admin/Analyst

Confidential, San Diego, CA

Responsibilities:

• SSIS 2005/2008/2012 ETL development, migration and maintenance on the DEV and PROD servers
• Develop Confidential 3 tier models using Confidential FM for reporting purposes
• Developer and troubleshooter in Confidential Report Studio / Query Studio /Cubes( Transformer )
• Created, refreshed and supported Confidential TM1 10.2.2 BI/Analytics to support timely sales operations.
• Create, modify and publish Confidential packages using Confidential Framework Manager .
• Design the production rollout process for Confidential applications.
• Built /Modified and maintained Confidential S ecurity/Administration/Configuration
• Promoted packages to Production using Import/Export utility.
• Deployed packages from PRODUCTION server to DEV server as well if required.
• Used override selections and new user changes clauses during exports.
• Create,modify and maintain SSIS jobs and Oracle packages .
• Database Administrator and Developer for ORACLE 11G/12c databases.
• Previous transitions from Oracle 10 to 11G and CPU patch updates
• Oracle CPU patches installation maintenance and database scripting.
• Performed Confidential administrative functions such as creating user accounts , user classes and roles using Access Manager .
• Data warehousing BRAC Budget data into the NMCI machines and SPAWAR NEDC servers
• BRACMIS / KMS Data warehouse application development, support and maintain activities using Microsoft SQL S erver 2003/2008/ 2012 ,Profiler, SSIS, PL SQL, ERWin,BRD,SSAS,SSRS, Confidential 8.0/10.2 Business Intelligence Software and Oracle database technologies
• Responsible for analysis,design,coding,component and assembly testing of warehousing owned by the application team.
• Involved in maintenance work (including production support), enhancement and development work
• SPAWAR/SABRS NAVY SYSTEMS and portal usage for BI reporting
• Created and deployed Confidential projects for US MARINE CORE( MC ) and user requirements gathering.
• BRACKMS/BRACMIS Database ETL warehousing and implementation
• Experience with ETL and Data Modeling in SAP BO XI R2 environment and Confidential Framework Manager.
• Environmental property Disposals, GPRA, GSA and BRAC Budgeting analysis
• Develop and execute SQL code to meet business requirements for data extracts in MS SQL 2008
• Develop new models for Enterprise Data Warehouse and Reporting tools
• Work with DBA teams to create databases, database objects ( schemas, indexes, triggers , etc)
• Microsoft Office SharePoint Server 2007: installing, configuring, troubleshooting, and custom
• SSIS 2012 SSDT updates and conversions from previous DTSX packages
• Using ORACLE 11G(11.2.0.3) database for KMS systems using ORACLE SQL Developer interface.
• Worked on Team Foundation Server (TFS), SharePoint including RDBMS (Oracle, SQL, DB2, MS Access) Database Administration / Application Design and Development -- Implementation, Design, Administration, DB security, Performance Tuning, Data Modeling, migration.
• Extensive OEM, DDL/DML design and implementation.

SQL BI Developer/Admin/Analyst

Confidential, Irvine, CA

Responsibilities:

• Creating and maintaining integrated project schedules, monitoring project performance, generating accurate and timely reports and analyses
• Experienced with TM1 server maintenance, environment setup, cube design, and application design
• Experienced with using TM1 in conjunction with SQL databases and developing OLAP objects using Confidential, Applix TM1
• Experiance Writing simple client applications using Confidential and TM1 SDK/API
• Maint e nance of TM1 database, including dimensions, cubs and processes using Architect
• Experience in developing TM1 models including cubes, dimensions, TI processes, rules and feeders along with writing reports using both TM1 Excel add-in and TM1 Web.
• Experience with Confidential products such as TM1 and Enterprise Planning
• Familiar with TM1 9.5 cube environment development
• Developed source files and reports in Confidential applications.
• Created Confidential Database Catalogs.
• Designed model files in Confidential Transformer .
• Created Confidential multidimensional cubes for users to be able to get business information from Confidential Power Play.
• Developed and modified Power Play reports and graphs with different layouts according user requirements.
• Prepared documentation and performed user training.
• Performed trouble shooting for Confidential applications by user requests
• DTS packages to DTSX conversion and job scheduling using MSSQL 2005 and MSSQL 2008
• MS SQL Reporting Services (SSRS) dataset modifications to IBM Confidential 8.4 Environment.
• Support Confidential team to migrating reports from the Confidential 8.1 to 8.4 Environment
• Develop reports based on business requirements within Confidential Reporting tool.
• Using SERENA TEAM TRACK for Project tickets management and using BMC SERVICE DESK EXPRESS for helpdesk ticket management.
• BMC CONTROL-M/Desktop and CONTROL-M/Enterprise Manager tool for Job batch processing /monitoring for SSIS/DTS package job scheduling.
• Develop templates for self service reporting within Confidential Reporting tool
• Experience with ETL/ Data Modeling in SAP BO XI 3.1 R2 enviroment and Confidential Framework Manager
• Develop Confidential 3 tier models using Confidential Framework Manager for reporting purposes
• Develop and execute SQL code to meet business requirements for data extracts in MS SQL 2008
• Develop new models for Enterprise Data Warehouse and Reporting tools
• Work with DBA teams to create databases, database objects ( schemas, indexes, triggers , etc)
• Microsoft Office SharePoint Server 2007: installing, configuring, troubleshooting, and custom development along with Content Management Server Documents upload and assigning.
• Works with business analysts, software architects, network engineers, middle-tier, server systems, and security and production support groups to ensure that all aspects of the technical architecture have been addressed.

BOXI R3.1 Migration Specialist/BI /SQL 2005

Confidential, San Diego, CA

Responsibilities:

• Evaluate Confidential ’s BO 5.1.8 environment and plan the migration to the BO Enterprise XI environment.
• Support the Confidential team migrating reports and queries from the 5.1.8 to the Enterprise XI R 3.1
• Support the Confidential team developing and configuring reports and queries in the BO Enterprise XI R3.1
• Unit testing of assigned development, configuration and migration work for BO Environment
• Setting up and Installation of BO XI R3.1 Environment on Dev/QA/Production servers.
• Migrated previous versions of DESKI FINANCIAL reports to DESKI XI version.
• Conversion of DESKI reports to WEBI XI/CRYSTAL 2008 reports.
• Implementation of ROW LEVEL and ACCESS LEVEL SECURITY in the SAP R3/BO XI Portal
• Setting up User Group with RIGHTS and their appropriate ACCESS LEVELS.
• Conversion/Migration of BO 5X UNIVERSE to BO XI UNIVERSE using Universe Designer along with their universe connections and constraints.
• Created and updated technical specifications according to development work being done.
• Setup ODBC/FILE/ORA DSN connectivity for ORACLE 10G /XE for BO UNIVERSE Environment.
• Created or modified other project documentation as identified by the Confidential team.
• Documented development and troubleshooting results for all migration, configuration and development work, includes updated technical specifications and weekly Progress reports
• Developed Hyperion reports using HYPERION BI 9 REPORTS STUDIO and report migration to BO XI R 3.1 Web I and Desk I reports.
• Support creating and modifying test scripts and perform testing tasks for development and/or configuration work done by the Confidential team or consultant.
• Service Pack /hot fix installations on BO XI R 3.1Environment using the SAP PORTAL
• Developed reports using Confidential ReportNet Experience using Confidential 8 BI v3

BI /SQL 2005 Engineer/Analyst

Confidential, Woodland Hills, CA

Responsibilities:

• Creating Financial reports using Confidential ReportNet and CE XI R2 for Talon sub divisions.
• Converting QLICKVIEW BI reports integrated with GO ERP systems with Backend ORACLE and SQL DB into Crystal XI reports.
• Converting ORACLE DISCOVERER reports to Crystal XI server reports.
• Installing and implementing setups and administration rights for end clients in Crystal Info View manager using CMC/CMS in Business Objects Reports Server XI R2
• Creating and modifying store procedures, views using Microsoft SQL 2005 server.
• Implemented BO Views/logical/physical tables using business view manager ( BVM) in CE Repository
• Used Crystal XCelsius 4.5/2008 for BI widgets creation.
• Working with different departments on various report strategies on modifications within existing reports and requirements gathering techniques.
• Creating complex Crystal reports from the existing Qlickview BI tools for top sales and other forecasting reports.
• Worked with SAS Display Manager .
• Experience in Table generation statements using SAS
• Worked with SET/MERGE statements, INPUT/INFILE statements in SAS environment.
• Scheduling jobs and creating User/server AUTHENTICATIONS/AUTHORIZATIONS for various departments using CE XI R2
• Migrating Microsoft Access 2007 database reports to Crystal XI reports. worked with Adobe LiveCycle Designer ES to design forms
• Adobe LiveCycle Designer V8.0 Software & JavaScript
• LiveCycle Designer, Lifecycle Form Manager, LiveCycle Reader Extension, · LiveCycle Barcode LiveCycle Workflow (Not required but a plus)
• Development and implementation of the following PDF forms for electronic submittal using Adobe LiveCycle V8.0 & JavaScript development and implementation of Electronic Forms (eForms) using Adobe LiveCycle Software V8.0 (i.e. Designer, Reader Extension, Barcode, Form Manager) for development

CR/CE/BO XI R2-R3/BI /SQL 2005 Engineer/Analyst

Confidential, La Jolla, CA

Responsibilities:

• Implemented BO Views/logical/physical tables using business view manager ( BVM) in CE Repository
• Used Crystal Xcelsius 4.5/2008 for BI widgets creation.
• Experienced with Reporting and other BI tools ( Confidential /NetWeaver).
• Analyzed and documented data elements, data dictionary, and other responsibilities to develop and implement tools. Interacted with user group, reports creation and defined BI strategy for different tools
• Written different tools and wrote functional specifications and created strategy statements.
• Created Business v/s Database FLOW CHARTS using Microsoft VISIO 2007
• Migrated Seagate and older version of Crystal to Crystal XI/Crystal 2008.
• Comprehensive working knowledge of development, implementation and maintenance of relational database management systems, graphical user interfaces ( GUI) and reporting systems and Dashboards
• Ability to handle a high-stress and dynamic environment. Project Management skills
• MS PROJECT 2007:Created project calendars and resources; appropriately identify, enter, organize, and relate project tasks; assign resources and costs; baseline projects; use different views within the software to understand budget, status, and allocations; and run standard and customized reports
• Implemented KPI measures within SSAS and deployed OLAP and used EXCEL PIVOT/AD-hoc reports
• Deployment and Utilization of Microsoft SQL Server /ACCESS Database Server and Analysis Services.
• Migrated BO R2 reports to BO XI R3 reports experienced using Migration services for conversions.
• Strong analytical, troubleshooting and problem resolution skills including team building with members.
• Worked with BO XI R3 Business View Manager ( BVM) for business views and Data Foundations .
• Converted BO XI R3 - WebI reports using BO R3 Info View/CMC/CMS and Crystal 2008
• Experience in BO XI R3 architecture and installed BO XI R3 on multi-server environment s.
• Migrated BO reports and UNIVERSE from BO ver. 6.5 /XI R2 (full/thin client) to BO XI R3.
• Worked in User/server AUTHENTICATIONS/AUTHORIZATIONS in BO XI R3/Crystal Server 2008
• Integrated BO XI/CR XI reports with .NET portal/Environment for component and icon updates.
• Worked on converting Siebel Analytics repository objects to BO universe environment.
• Used existing BO Universes for logic conversion to SQL 2005
• Utilizing SSRS, Dashboard SSRS reports under report server projects and published SSRS reports.
• Creating SSRS Data Model projects and used Report Builder for report server reports.
• Implemented Administration/Scheduling of mailing subscriptions on SSRS Reporting Server.
• Creating d ata Model Projects on Reports Builder using MS Visual Studio 2005
• USER SECURITY/ROLE MANAGEMENT for SSRS Reports Server
• Deployed SQL Analysis Services (SSAS) Model projects to the client servers.
• Create a MS SharePoint Gantt Project Management Chart, Calendar Appointment,
• Utilized Confidential (R) ENTERPRISE Business Intelligence tool.
• Deployment and Utilization of Microsoft SQL Server / ACCESS Database Server and Analysis Services.
• Worked on the Performance Tuning of queries and database optimization using SQL Profiler
• Peer-to-peer Replication (new in SQL Server 2005): SQL QA: Server Tuning, Log Shipping, Mirroring, SQL Log Shipping

BO/CE Engineer/Analyst

Confidential, La Jolla, CA

Responsibilities:

• Familiarity in modeling applications using BI Kit.
• Familiar with integration with BI Info Providers(e.g. InfoCubes, BEx queries and Query views, BEx Web applications ) via WeB API , data sources such as OLAP / relational data sources via java connectors
• Utilizing Crystal Server XI R2 from different source formats and satisfying clients by representing reports, business objects.
• Involved with in ETL & Business Intelligence using Business Objects 5i, XI.
• Experience with Business Objects Xcelsius or other dashboard generator.
• Implemented Crystal Xcelsius URL Auto Trigger using Crystal Xcelsius 4.5
• Familiar with Crystal Xcelsius Voice recognition
• Operating on Business View Manager to develop Business Views in CE Repository and maintenance.
• Customizing Business Objects to create advanced level reports, Data Modeling and architecture planning.
• Using Crystal Publishing Wizard for publishing Crystal XI reports to Crystal Enterprise XI
• Deployment and Utilization of Microsoft SQL Server 2005 /ACCESS Database Server and Analysis Services.
• Working with ASP.NET 2.0 for coding purposes for various report server projects
• Set package configuration in SSIS to redirect path from test environment to production environment
• Utilizing SIEBELCRM for all customer contact management and service ticket tracking management.
• SIEBEL QA for testing purposes
• Responsible for the overall design and deployment of corporate reporting tools.
• Experienced using ESRI suite of products including ArcGIS, ArcIMS, ArcSDE, ArcServer
• Working with AJAX for various report server /VB projects

ERP Specialist, CR XI R2, BO dev, DB Admin, SSRS Developer

Confidential, Chino, CA

Responsibilities:

• Utilization of SYSPRO 6.0 ERP System from different source formats and satisfying clients by representing reports, business objects and cubes.
• Extensive Knowledge of XML/XSL/SOAP used in SYSPRO ERP using XML/XSL tags/XSD Schema
• SQLXML, Native XML input / output, SQLXML 3.0.
• Remote Scripting, MSXML 3.0/4.0 Parsers, XML DOM, XSLT, XPATH. Early adopter of WS-Security W3C Recommendation and WSE toolkit for XML Signature, authorization, attachments and routing of XML Webservices. Extensive experience with XPath and XSLT in database operations.
• Created Business Intelligence objects in the form of Reports, OLAP, Cubes, views and extracts.
• Data Migration / ETL / Custom applications and business intelligence.
• Involved with in ETL & Business Intelligence using Business Objects 5i, XI.
• SYSPRO Reporting services development and maintenance.
• Deployed reports to Crystal Enterprise and Crystal reports XI
• Deployment and Utilization of Microsoft SQL Server 2005 Database Server and Analysis Services
• Utilization of in-house CRM for all customer contact management and service ticket tracking
• Responsible for the overall design and deployment of corporate reporting tools.
• Working with Microsoft Visual Basic 2005 for software updates
• Implementing C/C++ codes using current existing projects
• Hands on development experience with Informatica or other ETL development tools.
• Familiarity in development and support on high-end server systems using Informatica Power Center, Confidential, Oracle Warehouse Builder, and Oracle Data Miner.
• Knowledge and 2 yrs experience with Data Warehouse ETL tools such as Informatica Power Center or other Warehouse Builder.
• Experience with data warehouse development, Informatica and other Business Intelligence reporting tools.
• Experience in leading complex database integration projects (using .NET/MS SQL , Informatica)
• Deployment of report server projects using Microsoft Visual Studio 2005
• Working with ASP.NET 2.0 for coding purposes for various projects
• Conversion of PL/SQL statements MS SQL/T-SQL nested select statements and procedures.
• Created Confidential Cubes for clients.

DB Admin, SSRS Developer

Confidential, San Diego, CA

Responsibilities:

• Developed Microsoft SQL 2005 Reporting Services (SSRS) reports in Report Designer and Microsoft ACCESS 2003 reports for specific client requests.
• Created Ad Hoc reports by building models in Report Builder using SQL 2005 Model Designer and Report Builder in SSRS
• Worked with dashboard tools such as Xcelcius
• Used Microsoft SQL Server 2005 Analysis services for Administrative usages
• Administrating user roles and managing Jobs scheduling for DTS/DTSX packages for SQL SERVER 2000/ SQL SERVER 2005 Integration services
• Familiarity with SQL Server including log shipping, mirroring, and replication;
• Worked with complex store procedures, views, triggers , data import/export and creating scripts and ER diagrams for new databases using Microsoft SQL 2005 Query Analyzer
• Usage of Microsoft Visual Source Safe (VSS ) 6.0 and higher for storage purposes.
• Worked with Microsoft SQL 2005 Reporting Services (SSRS) as well as Microsoft ACCESS 2003 reports and customizing them client requests.
• Worked with BO Crystal Reports XI using Business Objects Platform.
• Implemented Business Objects Enterprise XI for Business Objects Enterprise XI on BI platform.
• Used AJAX control for coding purposes for various report server /C++ /C# projects
• Working with Microsoft Visual Basic 2005 for coding purposes for various VB/C# projects
• Installation/Setting of Web Intelligence and Broadcast Agent server
• Scheduled full client reports and Webi reports through BCA.
• Customized web pages using front page by HTML, VB, Java and ASP.
• Design and development of UNIVERSE in Business Objects XI/6.2
• Worked with Confidential 8.x including Report Studio, Query Studio, Metrics Studio, Event Studio, Access Manager, Portal Administration, Server Administration, Content Administration for clients

DBA, SSRS Dev/Admin, CR XI R2 Developer, .NET Programmer

Confidential, Carlsbad, CA

Responsibilities:

• Worked with Microsoft SQL 2005 Reporting Services (SSRS) as well as Microsoft ACCESS 2003 reports and customizing them client requests.
• Developed and deployed of OLAP /MOLAP CUBES using Microsoft SQL 2005 Analysis services for Administrative usages
• Administration of user roles and managing Jobs scheduling for DTS/DTSX packages for SQL SERVER 2000/2005 Integration services
• Worked with complex store procedures, views, triggers, data import/export and creating scripts and ER diagrams for new databases using Microsoft SQL 2005 Query Analyzer
• Designed and developed with Do Not Call Registry DNC audit checking and updating using SQL 2005
• Usage of Microsoft Visual Source Safe 6.0 (VSS ) and higher for storage purposes.
• Created windows services and web services using Microsoft VB.NET 2005
• SALES /MARKETING TEAM PROJECTS
• Design and coded INFRAGISTICS grids in Microsoft Visual Studio VB.NET & ASP.NET for Client purposes for the Marketing & Sales team.
• Interacted with clients on issues related to software, website and report issues.
• Developed and troubleshoot Business Objects Crystal Enterprise X/XI and Crystal Reports version XI
• Installation/Setting of Web Intelligence and Broadcast Agent server
• Created and customized WebI reports worked with Adobe LiveCycle Designer ES/Adobe LiveCycle Designer V8.to design forms
• Worked with Advanced charts and designs using BO Crystal Reports. X / XI
• Usage of Intuit TRACK - IT 6.5 Technician Client/ WIKI for task management with the team employees & client issues.
• Experience with data replication on a large scale (transactional and log shipping at a minimum)
• Experience with Database tuning; SQL Profiler

CR XI Dev/Admin, BO XI, DBP/SSRS

Confidential, Carlsbad, CA

Responsibilities:

• Developed Microsoft SQL 2005 Reporting Services (SSRS)
• Developed and troubleshoot Business Objects Enterprise XI and Crystal Reports version XI
• Worked with advanced charts and designs using Crystal XI as well as the excluded versions such as Box Plots, Pareto Charts and Waterfall Charts.
• Interacted with XML and JAVA SERVLETS for reporting purposes.
• Working with Microsoft Visual Basic 2005 for coding purposes for various report server projects

Database Developer, Crystal Reports Dev/Writer

Confidential, Carlsbad, CA

Responsibilities:

• Design, generate, and distribute reports utilizing database query tools such as Microsoft SQA using SQL Server 2005 for back-end purposes.
• Responsible for troubleshooting complex store procedures accessing Microsoft SQL server 2000.
• Developed and troubleshooting Crystal Reports version 8.5 - XI
• Administered Business objects Crystal Enterprise 10, XI, and used Crystal Reports v8.5, 10, XI for managing reports and internal management tools like WIKI for other tasks.
• Usage of Intuit TRACK - IT 6.5 Technician Client for task management with the team employees.
• Currently using DLL datasets and store procedures as data sources for Crystal Reports.
• Conversion of PL/SQL procedures to T-SQL statements and store procedures.

Database Developer

Confidential, San Diego, CA

Responsibilities:

• Responsible for troubleshooting tickets using server information on Microsoft SQL server 2000.
• Design, generate, and distribute reports utilizing database query tools such as SQA using SQL Server 2000 for back-end purposes.
• Create, customize and generate database SCRIPTS using T-SQL queries and complex store procedures.
• Used Microsoft SQA for back-end queries for reporting and testing purposes against the client interacting with development and management team on various ticketing issues from supporters providing gifts to various fundraising and non profit organizations.
• Create, merge and maintain database(s) for processing, reporting, specialized file and record maintenance and data entry activities.
• Testing and bug fixing Confidential Sphere

Web/DB Developer/Warehouse Analyst

Confidential, San Diego, CA

Responsibilities:

• Responsible for POS/Inventory data or statistical information into computer database systems ( Access, SQL server 2000, etc.).
• Manage specific account Channel POS (Sales and Inventory) data
• Design, generate, and distribute reports utilizing database query tools such as Crystal Reports, OLAP CUBES, VIEWS (ASP/ASP.NET) using SQL Server 2000 for back-end purposes.
• Create, merge and maintain database(s) for processing, reporting, specialized file and record maintenance and data entry activities. worked with Adobe LiveCycle Designer ES to design forms LiveCycle Designer, LiveCycle Form Manager
• Development and implementation of the following PDF forms for electronic submittal using Adobe
• Using XML Data Islands for ASP and HTML pages.
• Used SQL Query Analyzer for back-end queries for reporting and testing purposes against the client DB as well as daily flat file data-dump send-outs to various clients.
• Using T-SQL queries for generating EXEC statements for store procedures.
• Testing and bug fixing Confidential web-based applications involved.
• ASP/HTML and/or other programming updates to multiple Confidential websites and applications.
• Use of Microsoft Visual InterDev 6.0 for ASP page updates esp. for reporting purposes.
• Modify existing or create new MACROS for departmental Excel templates utilizing Visual Basic (VBA).
• Work with XML development tools such as Xml Spy.
• Mapped data ware house elements into multi-dimensional cubes for Confidential PowerPlay
• Running Confidential Business Intelligence tools and managing them.