WORK EXPERIENCE:

IAM Process Specialist / Application Architect III Specialist

Confidential

Responsibilities:

• Working at Confidentail in Global Identity Management,Confidentail group. Responsible for reviewing, analyzing, enhancing and documenting the authentication control process flows in Confidentail.
• Identified the process gaps and designed process improvements.
• Defined, developed and deployed the metrics collection to demonstrate the process efficiency and coverage.
• Collected documentation, reviewed and analyzed the Bank Authentication systems and processes.
• Defined and developed the metrics collection to demonstrate the process coverage and maturity.
• Developed playbook to help control partners and improve the process maturity.

IAM Technical Specialist

Confidential

Responsibilities:

• Worked to help Maintain LDAP systems while company engineers transfer processes to Active Directory and Transitions from current system to SailPoint.
• Duties such as helping with Incidents in ServiceNow where users can’t access applications because of LDAP issues.
• Troubleshooting access in LDAP and Active Directory using NetIQ Imanager and ConsoleOne.
• Supporting Office 365 on licensing issues. Using TCPDump with Wireshark to find apps directly Contacting LDAP and insuring they switch to new system.

Identity Access Management Specialist II

Confidential

Responsibilities:

• Design, develop and implement the directory services components of complex identity based systems in the areas of identity and access management, directory services (Including Active Directory), workflow, security, provisioning and compliance.
• Develop viable and efficient technology solutions to complex business needs according to customer requirements.
• Day to day responsibilities include Service Now Incident and Change Coordinator of the Identity and Access Management department.
• Providing support for SailPoint 6.4 and provided support for aging IDM system Sun IDM 7.1 (MyID) and routine operations

Identity Access Management Analyst

Plano, TX.

Confidential

Responsibilities:

• Reviewed and Analyzed User Access Management Controls - Password Management, Revoke User Control, and User Access Management for applications in Autonomy (including Active Directory). Compared with existing requirements at HP to determine differences and effect on operations.
• Reviewed existing Applications at Autonomy to insure they met HP standards and procedures. Developing solutions and implementing changes required to meet HP compliance standards.

Fort Worth, TX

Business Analyst

Confidential

Responsibilities:

• Contracted as Business Analyst Information Governance to Alcon, Fort Worth, TX.
• Worked on Security Step Plan, Inventory, Entitlement Audit, and Remediation for applications in Supply Chain.
• Part of team reviewing existing Applications at Confidentail to insure they met Novartis standards and procedures. Documenting changes required to meet compliance standards.

Irving, TX

Data Analyst / VB Programmer

Confidential

Responsibilities:

• Contracted as a Data Analyst / VB Programmer to Confidentail, at Irving, TX.
• From business requirements used Access database as front end for SQL server to create reports using VBA and Excel
• Created Reports combined from several source databases. Designed application to Verify Scanned documents from one application moved all pages of scan to new application, sheet by sheet.

Irving, TX 

Sr Business Systems Analyst / Identity Access Management

Confidential

Responsibilities:

• Consultant for Confidentail to Citigroup, at Irving, TX, for the global Identity and Access Management (IAM) department.
• Analyzed application systems access revocations outstanding to determine those cases not meeting compliance standards objectives.
• Worked with business teams and outside vendors to define improvement strategies and corrective action plans for identified violations. Kept track of progress until closure.
• Researched and worked with Application Managers and Business Process Owners to develop solutions to issues with Application compliance in Entitlements program.
• Provided Third level support for the Citi enterprise entitlement review system.
• Designed and implemented ad hoc reports from various databases using tools such as MySQL and Business Objects Web View to access Data from Sybase and SqlServer databases.
• Created and Maintained various database in MS Access to track activities and progress.
• Produced Metrics for reporting to Senior Management. Used Extract, Transform, Load, (ETL) Concepts to Transform Data into MS Access database to produce reports in MS Excel.

Addison, TX

Regulatory Reporting Developer

Confidential

Responsibilities:

• Supported regulatory reporting to the various states by coordinating reporting from the various divisions, requesting needed data from outside sources, combining with Coventry data and designing Reports using Access, VBA, Excel, And Power Builder on SqlServer and Oracle Databases.
• Supported needs for Excel VBA programming and Access Database design.
• Created Access database for Marketing initiative.

Ft Worth, TX 

SR IT Project Coordinator

Confidential

Responsibilities:

• Supported the Mincom Ellipse ERP system as Systems Administrator and Technical Systems Administrator.
• Worked with vendor to solve end user issues with package.
• Administrator for the Business Objects 6.5 reporting tools, Including InfoView.
• This included the payroll/HR module and Webview.

 Las Colinas, TX 

Access developer / Data Analyst

Confidential

Responsibilities:

• Worked at Confidentail To create Access database and analyze purchasing data from client hospitals. Matching purchasing data to specific contracts.
• Purpose was to test current cross matching process so it could be applied to other Hospital contracts.

Westlake, TX

Excel Programmer / Analyst

Confidential

Responsibilities:

• This project involved redesigning existing applications functionality and reports using VBA and Built-in functions.
• Skills involved included Requirements gathering, Documentation, designing modifications, Programming, Testing, Training, Implementation and initial support.
• The Excel based program was used by the Project Management Office to track Budget and Hours for Projects.
• Contracted to Confidentail for work at Confidentail.

Dallas TX

Programmer / Data Analyst

Confidential

Responsibilities:

• Solomon Associates is a subsidiary of AIG and is a consulting firm to the energy industry. Consultants are VP level or higher energy industry experts. My position assisted these consultants with the design and execution of surveys and reports to clients.
• Used VBA and Excel macros with ODBC to SQL server databases to design and program input forms and reports for studies.

Carrollton, TX

Business Analyst

Confidential

Responsibilities:

• Met with departments to determine needs and propose solutions based on available resources. Write business requirements and, depending on scope of project, submit project to upper management for approval. If approved coordinate and assign work to developers, meet with end users to refine needs and answer development questions as project progresses. Maintain business requirements documentation. Design test criteria and test application. Submit test application to end users for approval and after addressing concerns or problems place application into production and train end user.
• Acted as primary support for application after it is put into production. Also, tasks such as application processing, data modeling, flowcharting, coding, testing, test plan preparation, testing validations, program debugging, coordination of program releases, investigation and correction of errors or discrepancies and verification that application processing complies with company standards.
• For small projects I was responsible to write project specs. Solve issues myself using such tools as Access, VBA, Visual Basic 5&6, Unix scripting (beginner), Oracle Discover or other applications. Develop applications using Access, Visual Basic 5&6, Excel, SQL, PL/SQL, and ODBC to Oracle databases, ADO, DAO, SQLServer 7, Toad and VBA. Acquire assistance from programmers and tech personnel as needed.
• I redesigned a Gift Certificates Program in Visual Basic 5 and wrote several small programs in Visual Basic 6.
• Supported HR & Payroll ABRA and UNITIME applications and Visual FoxPro

Dallas, TX

Business Data Analyst

Confidential

Responsibilities:

• Business Data Analyst/Reporting at Texas Instruments for global marketing database. Oracle database on Sun server using mainly Forest & Trees, Excel and Access 97.
• Developed and maintained Automated Reports on Internet/Intranet from Business Requirements.
• Designed Executive Reporting System using Forest & Trees Builder.
• SQL and VBA used to design queries and automate reports.
• Created data Universe and reports for MAD (Marketing Analysis Database) in Business Objects.
• Designed Segmentation for Prime Response package.

Westlake, Texas

Treasury Data Analyst

Confidential

Responsibilities:

• Supervisor over refund process - Reconcile and Prepare metrics, streamlined and automated the refund process allowing a three-fold increase in volume of refunds with no increase in personnel and with an improved metric.
• Managed several Access databases. Developed, maintained and serviced. This includes automating ODBC links to Oracle databases as well as Custom VBA solutions to problems not covered by existing programming.
• Develop and maintain the automated informational needs of the Treasury Department. This includes the data imports from banks and credit card clearing houses as well as changing existing scripting as needs change. Maintaining automated queries in Access, Excel, Impromptu and Reports Developer 2000.
• Develop all new data queries, file imports, report development and data analysis work needed by the department.
• Facilitating the implementation of major software packages in Treasury. Such as Checkfree’s ReconPlus.
• Acted as go-between for Treasury and IT department for data source needs and setup, testing and training.

SKILL NAME:

• Level
• Visual Basic 5 & 6
• Sun IDM 7.1
• Sailpoint 6.x
• Intermediate
• Intermediate
• Beginner
• VBA
• Intermediate
• Excel
• Expert
• Access
• Advanced
• Pearl
• Beginner
• Crystal Reports
• Intermediate
• Oracle
• Intermediate
• MySQL
• Intermediate
• SQL
• Intermediate
• PL/SQL
• Intermediate
• Microsoft Project
• Beginner
• SQL * Plus
• Intermediate
• SQL Server
• Intermediate
• Visio
• Intermediate
• Cognos Impromptu
• Business Objects
• Intermediate
• Intermediate