SUMMARY

• A proven Leader with 20 years of hands - on IT/IS experience that includes over 14 years of expert knowledge in Healthcare & Pharmaceutical Industry supporting various Clinical and Business Systems.
• Business Intelligence & Analytics skill sets include Logical & Physical Database Design, Relational & Dimensional Data Modeling, ETL & ELT Design and Data Load Performance Optimization, Data Analysis & Data Mining, Analytical Cube Design, Executive Dashboard and Scorecard Design, Data Management and Data Governance.
• Have excellent track record in Business & Clinical Systems Implementation and supporting various Systems including: Pivotal CRM and Sales6ix Sales Forecasting System, Medical Claims Processing Systems.
• Have hands on experience in various ERP Systems including PeopleSoft HRMS, Lawson HRIS, Oracle Business Suite and SAP Business Warehouse (SAP BW).
• Subject Matter Expert level functional understanding of Business & Technical Workflows around Provider Relations & Physician Marketing, Member/Patient life Cycle Management, Claim & Revenue Management, Medical Necessity & Utilization Management and Appeals & Grievances.
• A Team leaderwitha provenability to train, supervise, motivate, and evaluatepersonnel witha provenability tobuildand work collaboratively in a strongteamconcept.

TECHNICAL SKILLS

Business Intelligence/ Reporting Tools: Tableau 9.x, 10.x, SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Cognos 8.x, Framework Manager, Transformer, Analysis Studio, Query Studio, Report Studio, Cognos Connection, Cognos Configuration, Cognos Security, Cognos 7.x (Impromptu, Power Play, Transformer) Report Net 1.1 MR2, Crystal Reports 9/10, Crystal Enterprise 9/10, SAP BusinessObjects Report, Sunrise Clinical Analytics (SCA), Confidential Ambulatory Analytics.

ERP Systems: Medical Billing & Claims Processing, PeopleSoft HRMS 8.X, Lawson HRMS 7/8.0, SAP Netweaver 2004, SAP BW 3.5, SAP R/3, SAP ECC 5.0, SAP FI 4.7, Advantage Accounting Information Systems 2.0/3.0, Healthcare Management Systems

Revenue Management Systems: Plexis Authorization & Claims, QNXT Revenue Management System, ILS Claims System, Care Compass Revenue Management System

Databases: SQL Server 2005/2008/2008 R2/2012, Oracle 8i/9i/10g, MS Access, Fast Count

ETL Tools: Talend, SQL Server Integration Services (SSIS), SQL Server 2005/2008/2008 R2/2012 SSIS, DTS, WhereScape RED, SAP BW 3.5

Data Modeling: Erwin, MS Visio 2000/2003, RedGate

Operating Systems: Windows 2012/2008/2000/ NT/XP/7, AIX, Linux Red Hat 7.3, UNIX Sun Solaris

Hardware: AIX, Compaq Proliant DL360, ML350, IBM PC, Sun2500, HP 9000

Software: AIX Vi editor, MS Project 2000/2003, MS Office 97/2000/2003 , FrontPage Visual InterDev, Flash, Dreamweaver, Fire Works

Programming: SQL, HTML, ASP, Visual Basic, VBScript, C/Pro * C, JavaScript, Unix Shell

PROFESSIONAL EXPERIENCE

Lead Data Architect / Asst. Director Data Architecture & Business Intelligence

Confidential, Bronx, NY

Responsibilities:

• Leading a team of Information (Data) Architects, Developers and managing day-to-day End Users expectation around Claims & Clinical Application & Report design and development activities.
• Managing Team & Departmental Annual Budgets and ensuring that the expenses of Team Members and the Vendor Accounts do not exceed the overall allocated budget.
• Understanding business requirements and architecting & designing solutions to meet business needs.
• Meeting with internal and external Business Users, attending JAD sessions to understand business requirements and guiding Business Analysts in transforming the requirements into technical specification (BRD) for Internal Development Team and Vendor Resources.
• Working with internal and external developers and assigning tasks to ensure project deadline and deliverables are met and earns business satisfaction
• Setting up Technical and development guidelines, policies and coding standards for internal & external development Team for them to follow CenterLight IT coding best practices & guidelines.
• Reviewing Company’s internal Business Processes to understand the Current State of the business systems and identifying GAPs for designing future state of the systems.
• Managed and Directed implementation of Care Compass Revenue management & Clinical System and guiding Data Architects and Developers in Integrating Legacy and Newly Implemented system data.
• Implemented Trizetto QNXT System to Manage Provider, Members, Claims, Medical Necessity & Utilization Management, Member Hospitalization and Appeals & Grievance Management.
• Working with internal Business users from Strategy and Planning Team to understand their business requirements and directing developers in designing Dashboards and Analytical reports using Tableau, SAP BusinessObjects Web Intelligence Reporting to provide Decision Support capabilities for Sr. Management Team.
• Architected and provided logical data models for future state of Enterprise Data Warehouse (EDW) by understanding current state of the Data Warehouse and Analyzing existing data Issues
• Designed Logical Data Marts to analyze data on Member Utilization of Personal Care Worker Hours
• Working with Data Architects and Developers and directing them in Integrating Various Data Sources to ensure that documented System Design meets Business requirements.

Business Process Architect

Confidential, Bronx, NY

Responsibilities:

• Gathered business requirements and developed technical design for re-designing Membership Referral and Provider / Referring Organization system to track all Member Referral activities
• Modeling and Supporting Member Data Management and data mapping activities for downstream systems
• Understanding business requirements and developing technical specification to implement Sales6ix, a Sales Forecasting System, and Pivotal Customer Relationship Management System (CRM ) to capture and track business Opportunities, Leads, Activities and Tasks for Physician Marketing and Provider Relations business areas
• Performing Functional Testing of the developed systems before UAT tests are conducted by the Business Users.
• Worked with Development team and created Logical Data model to Design an ETL package using MS SSIS for nightly load of Member Data from Clinical system to Pivotal CRM system
• Identifying and Tracking Systems Issues and working with the development Team to resolve them.
• Working closely with PMs, Project Team Members and other Management Team members assigned to the projects
• Successful Designed and Managed all Analytical & Operational Reports Development for Medical Management, Health Plan Operations and Care Management Team.
• Successful Architected & Designed several internal data feeds to/from various Upstream & Downstream systems as well as data feeds to external Vendors.
• Successfully gathered, documented business and technical requirements for Analyzing Personal Care Worker (PCW) Data and re-designing of existing Enterprise Data Warehouse.
• Successfully gathered Business System requirements for implementing Pivotal CRM & Sales6ix Sales Forecasting tool to track Member Referrals provided by contracted Physicians and other Long-Term Managed Care Providers.
• Gathered and documented Technical and Business Requirements for Designing and Implementing Mobile Computing needs to meet the growing demand from Remote & Field System Users including: Membership Development Nurses (MDRNs), Community Healthcare Nurses (CHNs), Outreach and Physician Marketing Representatives.
• Planned and Coordinated BusinessObjects Report Development training session for CenterLight Team
• Created and Modified PMO Templates for Project documentation

Manager Clinical Systems & Analytics Team

Confidential, New Hyde Park, NY

Responsibilities:

• Managing a team of 11 Systems Analysts and assigning tasks and development activities to production support Analysts and other project team members
• Managing day to day production support issues and managing Clinicians and End User’s expectations
• Assigning tasks and development activities to Developers, Analysts and other project team members
• Conducting weekly Staff meetings as a medium of communication channel to the Staff Members and keeping them updated with project priorities and deliverables, Account & corporate updates
• Holding weekly meetings with Staff Members in 1-on-1 basis to go over their weekly status reports, addressing their questions & concerns and motivating them to be a productive Team player.
• Holding Offsite Team Building activities on a periodic basis for the Staff Members to Motivate, build a strong performing Team as well as to retain Talents.
• Performing Yearly Reviews and providing feedbacks using Oracle HRIS Performance Management System.
• Commending Staff Members during Staff meetings as well as to the Sr. Management Team for their excellence in day-to-day support work and project deliverables
• Identifying Individual Strength and Weakness of the Staff Members and paring them up in projects to overcome the gaps in Staff Member’s skill sets.
• Providing feedbacks and recommendation to the Staff Member’s directly as well as to the Sr. Management Team for Talent Development and Retention purpose.
• Meeting with the Clinical System Users and gathering Business Requirements and Defining Scope for Clinical Data Warehouse Project
• Understanding database schema within Sunrise Clinical Manager (SCM) and Confidential Ambulatory System (AEHR) as Data Sources
• Understanding workflows within Source System with regards Patient’s Health Issues, Diagnosis, Observation, Order Entry, Results, Flowsheets, Medications, Home and Discharge Medication Reconciliation, Allergies & intolerances as well as related data mapping that flows data into Clinical Data Warehouse
• Working with healthcare Providers to understand business requirements for Clinical, Analytical, Operational and Quality Management Reporting needs for Sunrise Clinical Manager (SCM).
• Meeting with Clinical Leadership Team and planning for Enterprise Data Governance and Data Quality initiatives
• Planned and Designed OLAP and Report presentation model for end users. Used SharePoint as User portal for publishing various Clinical Decision support reports and OLAP data
• Designing and Modifying Clinical Data Warehouse Schema and customizing OLAP models
• Planned and Designed Custom Data Marts specific to Heart Failure, Pneumonia and other areas of Clinical Research and Study
• Planned and Designed Daily ETL process using SSIS and ensuring daily scheduled process is completed without error
• Designed and remodeled OLAP model using SSAS Cube Model for end user’s data analysis
• Coordinating Implementation and Report Development of ARRA Meaningful Use reports, day-to-day Clinical Decision making reports using SSRS for Clinical Staffs and Healthcare Administrators
• Participating and coordinating weekly project status meetings and other technical and non-technical project related meetings as needed
• Working with PMO Office, Clinical and Technical teams and planning Implementation and system upgrade Road map
• Maintaining Analytics System Issue list and escalating them to internal and external support team for issue resolution
• Created Pre and Post System Upgrade Test Scripts for upgrading Sunrise Clinical Analytics version 5.0 to 5.5R2
• Creating End User Training Materials and holding end user classroom training

Systems Analyst

Confidential, Katonah, NY

Responsibilities:

• Reporting to the Health Group’s Chief Medical Officer (CMO) and Chief Operating Officer (COO) and providing leadership, direction and advise with respect to practice wide IT systems and Business processes
• Identifying gaps in IT support system and implementing a improved IT support triage system
• Creating and implementing IT support policies and procedures to support NextGen Enterprise Practice Management System (EPM) for Medical Billing and NextGen Electronic Heath Record System (EHR).
• Managing end users expectation by establishing Service level agreements and maintaining escalation process and ensuring that an appropriate level of support quality was maintained at all times.
• Managing relationships with Vendors and Internal Project team members.
• Creating policies and procedures for integrating new provider offices ensuring smooth transition with respect to IT infrastructure
• Implementing HIPAA privacy rules and standards to ensure appropriate system security to protect Patient’s protected medical records
• Rolling out project plans for training Clinical Staffs and Providers on new Practice go-live initiatives and roll out of NextGen EHR and EPM
• Conducting survey to assess current EHR and EPM usage across the Practice and various locations to asses training needs
• Communicating and informing End Users on NextGen EHR and EPM best practices & procedures
• Performing claim submission using NextGen EPM and Gateway Clearinghouse website
• Managing NextGen EMR and EPM user and group level security. Creating and modifying new and existing users based on their roles and responsibilities. Managing Users under NextGen System Administration module
• Setting up Provider PAQ (Provider Approval Queue) and setting up their staff under system administration area.
• Setting up workflow manager and delegating access rights to Provider PAQ
• Setting up Providers with SureScript for NextGen eRX capabilities and medication refill requests
• Maintaining NextGen File Maintenance module for user defined medications and Allergies
• Updating Systems and Master data tables under File Maintenance including setting up: Providers, Payers, Practices, Enterprises, Locations, Medication Updates, Pharmacies, Allergies and Vaccines etc.
• Creating NextGen Reports and scheduling using Background Business Processors (BBP)
• Troubleshooting various system related issues reported by the end users and escalating to NextGen for additional support needs
• Configuring NextGen EPM system and Master data tables to ensure all fields in CMS 1500 are populating correctly to minimize claim denials and maximizing claim remits.
• Managing Domain Users using Windows 2003 Server environment. Creating new and modifying existing users in Active directory and setting up users in MS Exchange Server 2007
• Troubleshooting end users logging issue within NextGen using windows Terminal Server
• Assisting users to resolve NextGen connectivity issues due to Network failure.
• Setting up and troubleshooting VPN issues reported by users working from remote office locations
• Troubleshooting and setting up document scanners, Bizcard Readers, Prescription Printers for end users

Healthcare Quality Data Analyst

Confidential, NY

Responsibilities:

• Managed company wide roll out of Confidential Electronic Prescription system
• Training and Supporting Clinical Staffs including Physicians and Nurses on how to write prescriptions using Confidential eRX Systems
• Creating Support tickets and working with Support Vendors in resolving day to day support issues
• Supporting Misys Electronic Health Records Management Systems
• Assisting Sr. Executives including Medial Director in data analysis for submission to NCQA and PQRI Recognition Authority
• Administering New York State Immunization Information Systems (NYSIIS) for MKMG and migrated historic data transfer specific to patients 19 or younger to NYSIIS
• Automating H1N1 and Adult Flu Vaccine data transfer to New York State Immunization Information Systems (NYSIIS)
• Performing Clinical Data Analysis and generating Management reports specific to eRX, Vitals, BMI etc.
• Creating ad-hoc data dumps based on user request and providing them to outside vendors
• Converted MS Access 2000 databases to MS Access 2007 Database
• Creating and Managing SQL Server 2005 Databases
• Setup and managing data connectivity between Clinical OLTP system running on Informix 9.0 and Clinical Data Marts hosted on SQL Server 2005; created linked server between the systems for connectivity
• Managing SQL Server security
• Created SQL Server 2005 Database file groups, setting up recovery model suitable for OLAP performance
• Creating SSIS package to extract data from Clinical System and loading into a SQL server 2005 based OLAP data marts
• Creating SSIS jobs and managing SSIS packages
• Optimizing table indices for OLAP performance tuning
• Creating SSRS (Microsoft Reporting Services) Reports and publishing them into MS SharePoint Server.

Sr. Business Intelligence / Data Warehousing Analyst

Confidential

Responsibilities:

• Creating and maintaining Data Source Connections
• Designed and developed a Billing and Revenue Data Mart using SQL Server 2005 that feeds data to Cognos Cubes as well as for detail canned reports using Report Studio and ad-hoc repots within Query Studio
• Designed ETL packages using SQL Server Integration Services (SSIS) sources from Internal ERP System
• Creating Data Cleansing and standardization processes and applying them using SSIS, T-SQL and procedures
• Designed Data Mart Load/Work/Stage Tables and created multiples Dimensions and Fact Tables to implement the Star Schema
• Automating Daily data loads and resolving any data load issue using SSIS Packages and SQL Server Job
• Creating Views, Indexes and Data Aggregates as needed to improve performance within the Database Layer
• Interacting with internal business partners to understand Cognos reporting needs and creating business specification.
• Identifying gap analysis and help implementing improvements to reporting tools, internal business processes.
• Creating detailed design specifications which involved building and maintaining the FM model in Framework Manager.
• Developing Cognos Cubes and designing models using Cognos Transformer and publishing them into Cognos Connection and modifying existing cubes and models as requested
• Creating Framework Manager Models and generating IQD as data sources to build Cubes
• Created DMR Models within Framework manager based on the requirements
• Developed various canned reports using Analysis Studio and designing Cognos Cube defalult views
• Create model query subjects, data source query subjects, various embedded calculations and filters to meet the reporting requirements in the Model.
• Creating master-detail and drill-down/drill-through relationships between Cognos Cube to detail report
• Create multiple page reports and used various prompts and conditional blocks to meet the report specifications using Report Studio.
• Create some complex calculations in Report studio and developed some ad-hoc reports in Query studio.
• Created list and Cross tab reports in Report Studio with Master/Detail Relationship for Report Bursting via email
• Assisting other developers by reviewing plans and defining test cases
• Fulfill customer report requests within defined service level commitments
• Planning and designing a Enterprise wide Cognos BI environment across multiple Distributed Servers
• Participate in capacity planning activities. Optimize and implement standards and best practices.
• Installing and Configuring Cognos 8 BI Server, Configuring IIS Web Server, Transformer and Framework Manager
• Upgrading Cognos 8 BI Server, Cognos Transformer and Framework Manager to v 8.3
• Planning and Implementing Cognos 8 Single Sign-On Security based on Corporate LDAP setup and also added package level Security
• Set the Security in Cognos Connection for various users limiting them access to Cognos Connection by assigning roles and maintaining security for auditing purposes
• Implementing and configuring Audit logging for tracking reporting activities as well as user loggings using CMTools utility
• Performance tuning and Configuring out of the box default settings specific to the enterprise BI environment and hardware
• Administering Cognos Content Store Database and deploying/migrating contents from development to Production environment using Export/Import utility
• Automating Cognos Cube building task and daily data refresh
• Automating, designing and monitoring daily data load procedures using SSIS ETL packages
• Monitoring Cognos Server and maintaining it to avoid any down time in Reporting environment
• Monitoring Scheduling and Report delivery to ensure that end users are receiving all the scheduled reports
• Setting up Project/Folders across multiple environments (Development, Test, Production)
• Supporting other Developers and end users resolving issues / new requests those were elevated or were not resolved by other team members
• Peer Reviewing, Testing and moving development works into production
• Training IT team members and Power Users

Sr. Analyst, Data Integrity and Reporting

Confidential

Responsibilities:

• Providing leadership and direction to project teams by understanding business processes, gap analysis, gathering requirements, identifying potential usability issues, managing scope, maintaining escalation process and ensuring that an appropriate level of application quality was maintained at all times.
• Establishing business requirements documentation with both internal and external customers and vendors.
• Identifying appropriate resources needed, and developing schedule to ensure project deliverables and milestones are met as well as to ensure timely completion of projects.
• Managing relationships with Vendors, Offshore Development Team and Internal Project team members.
• Collaborating directly with business units to assess the technical impact of business requirements and to reach consensus on alternative solutions when necessary in an effort to maintain a consistent yet flexible architecture.
• Working with and mentoring several developers, junior analysts on various projects.
• Project Lead for Business Process Improvement / Re-Engineering initiatives
• Creating detailed design specifications which involved building and maintaining the FM model in Framework Manager.
• Created List Reports, Group Reports and Cross Tab Reports with Drill Through and Drill down functionalities.
• Created Query Prompts, Calculations, Conditions and Filters in the reports.
• Created the Business Mix report and Top Ten reports.
• Created reports in HTML format for easy navigation of data from web browser.
• Create model by using Cognos best practices for creating various reports.
• Created model query subjects, data source query subjects, various embedded calculations and filters to meet the reporting requirements in the Model.
• Developed Prompt Pages and Cascaded input Prompts to display only the selected entrees in the report.
• Created multiple page reports and used various prompts and conditional blocks to meet the report specifications.
• Created some complex calculations in Report studio and developed some ad-hoc reports in Query studio.
• Created Bursting reports to end users and maintained the Data Security
• Deployed the Package from development, staging and production environments.
• Supported existing Impromptu Reports and enhancing Cubes to meet specific requirements of the user.

Business Systems Analyst / Reporting Analyst

Confidential

Responsibilities:

• Generating daily, monthly and annual reports as well as Ad-Hoc reports as requested by end users and Sr. Management Team using Crystal Reports, Cognos Impromptu, Power Play, SQL Navigator and SQL.
• Developing Monthly and Quarterly Analytical Reports for Sales Administration
• Developing catalogs with Impromptu administrator for use with Cognos impromptu reports and Impromptu web reports and Power Play cubes.
• Created List Reports, Group Reports and Cross Tab Reports with Drill Through and Drill down functionalities.
• Created Query Prompts, Calculations, Conditions and Filters in the reports.
• Created the Business Mix report and Top Ten reports.
• Created reports in HTML format for easy navigation of data from web browser.
• Functional Project Lead for implementing Lawson ERP Employee and Manager’s Self-Service portal as well as for various HR Systems.
• Gathering business requirements for implementing Workforce Relations Systems and configuring system security for the end users.
• Establishing business requirements documentation with both internal and external customers and vendors.
• Implementing uniform HRIS coding structure based on various position re-alignment
• Functional Lead for HR Business Process Improvement / Re-Engineering initiatives
• Actively participated in a implementation of a Web based time and attendance collection system (KRONOS)
• Functional Project Lead for HR Data Warehouse initiatives including GAP Analysis, requirements gathering, function and logical design of HR data Warehouse.
• Day to day functional support for various systems including Employee Review and Performance Systems, IVR System for Employee Relations Call Center, bridging with vendors responsible for Payroll Administration, Benefit Administration and Absence Management.
• Creating technical specification, presentation and training materials and as well as providing direction on QA, usability assessment, test plans and strategies
• Supporting HR Compliance initiatives including Annual audits on LOA, Benefit, OSHA, OFCCP, Applicant Flow and New Hires
• Establishing uniform reporting standards to deliver reliable information to HR and senior management team.
• Managing and supporting TAP Sales Force Retention Program
• Successfully implemented Employee Relations Compliance System
• Oracle 10g report conversion and up grade from Oracle 9i
• Successful Implementation of Employee’s Web Portal
• Leading various HR Business Process Improvements
• HR Data Warehouse and Business Intelligence tool implementation
• Successful completion of various audits to comply with Government policy

Accounting System Manager

Confidential

Responsibilities:

• Analyzing and understanding internal and external Client’s business needs and mapping out the requirements in Process Flow Diagram using MS Visio.
• Analyzing and understanding Project Scope and outlining the project budget.
• Analyzing Cost vs. Benefit of an IT/IS Project prior to the beginning of the project and providing recommendations to the upper management.
• Planning and designing strategies to develop and strengthen Corporate IT/IS Infrastructure.
• Responsible for IT/IS inventory acquisition, budgeting and forecasting team hours, team management and production coordination for a variety of projects.
• Creating various reports including inventory, Work In Process (WIP), Project Cost To Date Reports using Crystal Reports 9.0
• Bridging between various Clients, Vendors and the Company for IT/IS related Project.
• Responsible for team management and coordination of a group of 4-6 technical and non-technical personnel for successful implementation of projects.
• Creating project scheduling, tracking progress and Fulfillment of projects using MS Project 2000.
• Disaster Recovery and strategic Planning.
• Coordinating current and future software releases.
• Managed and implemented a Large Financial Data Conversion / Migration to SQL Server 2000 from a Cobol Based Application running on UNIX.
• Analyzing project requirements and outlining project specification including designing Process Flow Chart using MS Visio 2000 for the technical team members as well as outlining the projects for internal business teams and external clients.
• Facilitating client and team meetings and work sessions, including QA and post-mortem project review.
• High-level strategic direction, vision and scope of multiple projects.
• Creating technical specification, presentation and training materials.
• Provide input and direction for QA, usability assessment, test plans and strategies
• System Analysis and Design of a financial data migration project migrating from a UNIX based Accounting System (AIS) to SQL Server 2000 based Financial System and outlining the process flow diagram.
• Understanding internal and external User’s System requirements.
• Data analysis, modeling and data mapping to keep the integrity of data during the migration process.
• Designing and implementing logical/physical databases.
• Creating an efficient daily data and historic data backup plan in UNIX System using AWK and Shell Programming and in SQL Server 2000 for the new system back up using Veritas Backup Exec Software.
• Extraction and conversion of data from UNIX system to various data format including ASCII and CSV format for setting up that data load process in SQL Server 2000 Database.
• Bulk insertion and Transaction of data in SQL Server database using the Data Transformation Services (DTS).
• Monitoring and optimizing database performance, allocating systems storage
• Installed and upgraded new releases of the database server and tools.
• Customizing tables and panels and maintained full documentation.
• Performing data security analysis and providing security solutions using firewalls and authentication.
• Generating custom and ad hoc reports using T-SQL scripts, Stored Procedures, MS Access 2000 and Crystal Reports 9.0.
• Creating Management Reports and publishing them on the Web through secured online access using HTML, ASP and VB / JavaScript and IIS 5.0 Server.
• Creating Technical Notes and Documentations for the Users and Training them the new Financial System.

CRM Data Warehouse Developer

Confidential, Evanston, IL

Responsibilities:

• Analyzed project requirements and outlining project specification including designing Process Flow Diagram using MS Visio 2000 for the technical team members as well as implementing the projects for internal business teams and external clients.
• Analyzed data quality and standardization of data using regular expression, AWK and Gawk utilities in Linux bash environment.
• Data Merge and Parse process in before loading them into database.
• Monitored and optimized the performance of the databases, allocating future and current systems storage, providing back-up, restoration and recovery of databases.
• Monitored and troubleshoot daily data load to the Database.
• Installed, configured Oracle 8i/9i Database as well as configuring Oracle Clients.
• Created Oracle8i/9i database tables and loaded scrubbed data into the Oracle 9i using SQL Loader utility.
• Administered and processed existing CRM Database stored in a flat file database known as ACT 2000.
• Migrated and updated ACT 2000 data into a larger capacity CRM database known as SalesLogix 6.0 running on SQL Server 2000.
• Created database driven Web based applications for Clients File Upload Process.
• Create critical nested queries using SQL Plus and T-SQL.
• Implement database connectivity using ODBC and ADO.
• Created Server side applications using VBScript, JavaScript, ASP and HTML. Used Visual Basic (VB) for storing to and retrieving data from Access 2000 and SQL Server 2000.
• Designed, coded, tested and implemented database interactive website with a secured login page using SSL for the clients.
• Uploaded web applications to the IIS 5 web server running on Windows 2000 Server.
• Successfully implemented projects while beating the deadlines and earned client’ satisfaction.
• Automated file movements to and from the clients using bash scripts.
• Migrated user accounts from local servers to the domain and configured Active Directory.