While working for Integrated Practice Solutions/Revolution EHR, I helped to migrate data between cloud based environments.Meeting with Internal Team Members as well as end users, we helped to move their Electronic Health Records and related data between environments.Configuring and executing scripts to import and export data using VPN and Remote Desktop.Looking for issues in logs and troubleshooting issues in the data.Regularly meeting with with team members to update status and discuss any issues.

• Assisted multiple, concurrent projects with specific PowerCenter and OBIEE problems.• Set up POCs & a training environment including Informatica PowerCenter and Oracle & SQL Server databases.• Taught recent hires basic ETL techniques and practical use of the PowerCenter Client tools.Worked for PPD, Andover Companies, Novo Nordisk, PAREXEL, Wadell & Reed, Neustar, Intralinks American Century Investments, Independent Health, WellPoint, and the Seneca Gaming Corporation

• Understood the existing environment, as well as the plan for implementing the required changes.• Contributed to meetings to refine requirements for loading batches of Clinical records into Siebel in an automated fashion (EIM).• Started developing a bash script to automate EIM processes and log results. The work was put on hold due to a Siebel Upgrade and outstanding requirement details.• Documented meeting details as well as a list of outstanding questions remaining..

• Provided Guidance to Development Teams regarding database queries and logic.• Gathered technical requirements for JIRA Stories. Implemented Stories to create and update DW structures and/or Tableau Server Settings, as well as troubleshot problems.• Ran system processes and documented their results, in non-production environments.• Troubleshot performance issues with databases. Altered Tables and Views to facilitate reporting needs.• Assisted with the Administration of a Tableau Server. Configured scripts to automate Extracts for Data Sources.• Created an initial Data Model of a preexisting Data Warehouse in ER Studio Data Architect.

• Gathered Requirements from Key Stakeholders• Wrote SQL to Analyze Data from Salesforce.com and other systems and Report on the results• Documented Requirements, Code, Testing and Executions in JIRA• Designed Solutions and Documented them in Confluence• Reviewed Code and Provided Feedback• Assigned Work to the Team• Created Scripts to Migrate and Cleanse Data in Greenplum• Generated Extracts for Loads back into Salesforce.com• Triaged and Resolved Downstream and UAT Issues

Assisted in gathering/refining technical requirements based on changing processes.Worked out detailed ETL solutions to move data from and to new cloud based CRM (SalesPage).Developed SQL and Informatica Objects used to move data between internal systems and SalesPage.Assigned developer work and insured its timely completion.Reviewed code and confirmed it met the requirements.Documented the design and solution of data integrations with SalesPage.

• Collaborated with the client team in creating project standards• Worked with the development resources to confirm best practices and guidelines were followed.• Reviewed code to confirm solutions and processes.• Discussed project progress and dependencies with architects and other teams.• Worked with business stakeholders to support business requirement sessions.• Coordinated development and quality assurance efforts to reduce coordination time.• Worked with the team members to create and publish weekly status reports.• Participated in stakeholder meetings to discuss project status and provided guidance in mitigating project risks.

Created REST API calls, and tested combining them with both Windows batch scripting and third party scheduling tools to facilitate more complex job dependencies.Explored possible use of the Integration Template Designer plug-in for Microsoft Visio and Cloud’s Mapping Designer to add capability to its default interface.Tested jobs, resolved multiple issues with how they ran, and finally modified them to meet new requirements and standards.Documented existing work in Informatica Cloud, and reorganized job processing to improve batch times.

• Performed Marketo Tasks for clients such as BankVue, Sauce Labs, and Evolv.• Set up and customized Campaigns and Assets.• Designed Revenue Cycles and set up Analytics.• Performed QA on preexisting work and executed root cause analysis to determine possible solutions.• Analyzed new regulations, implemented short term fixes, and suggested possible long term solutions.

• Modified an existing 10g BI Publisher Report to pull information from SalesForce, instead of Siebel and created new 11g Data Model.• Analyzed five existing Analytics Dashboards to determine which Presentation, OBAW & Siebel Columns they were using.• Developed requested plan to re-source OBAW tables with SalesForce data.• Explored feasibility of replacing DAC, but continuing to use the pre-built OBI App’s mappings.• Created Informatica Mapping to update Informatica Parameter files created by DAC.• Analyzed Existing Siebel Screen, and created BIP Report to replace it, with data from SalesForce.

• Responsible for the migration of data from SalesForce.com into Siebel Sales, using Informatica PowerCenter and Siebel EIM.• Data Architect responsible for aligning Project Management and IT staff to determine technical and personnel resource requirements.• Designed the Data Conversion & aligned Business Users, SFDC Administrators, and the Siebel Configuration Team to complete the work.• Led a team responsible for using PowerCenter to pull the required information from SFDC, convert it to Siebel Format, and load into EIM Tables.• Partnered with the business to recognize opportunities to correct and eliminate duplicate and invalid data.

• Led a team of a dozen junior Informatica administrators supporting 52 Repositories on 33 servers, 24 hours per day, seven days-a-week.• Team maintained system up time, triaged Incidents, migrated code, provisioned security, and handled centralized communication for the department, along with other miscellaneous tasks.• Assisted in the creation and modification of processes to improve the way the team performed their job.• Developed PowerCenter mappings & workflows to gather, aggregate system information, then load it into SQL Server and Teradata tables.• Helped to create scripts and reports to improve the information available to the entire team and simplify repetitive tasks.• Monitored performance and provided feedback to improve outcomes.• Acted as an escalation point and provided guidance to team members dealing with unusual problems with Informatica or related technologies.

• Analyzed issues with information coming into Siebel from at least five different systems, including EDW and EMPI.• Monitored a ticketing queue and documented activities performed, therein.• Maintained, developed, documented and finally created test cases and verified the success of Informatica mappings. Integrated the mappings into existing workflows s to correct problems and make long term improvements to the data flow.

• Led a team of six consultants who used ETL techniques to integrate three iSeries systems into the Oracle Business Analytics Warehouse.• Helped to design and implement the PowerCenter mappings and workflows which were used to provide the sales insight the client requested.• Evaluated the Infinium Financial Application Suite and helped design/develop the Informatica mappings that move the data into the OBAW.• Used PowerCenter mappings and workflows to integrate customer transactions from various systems, to implement business logic to identify and encourage customer loyalty.• Created test cases, based on business requirements, and ensured the problems were solved.• Developed reports to provide insight into the budget and how well it was met.

• Assigned problems to specific teams in HP, to secure timely resolution.• Insured SLAs were met.• Communicated with Weyerhaeuser users to verify that their problems were being solved in a timely fashion.

While working at LexisNexis: Automated, streamlined, improved and/or documented various procedures. Developed a program to assist staff with planning needs. Assisted staff with updating and conversion of XML content. Saved staff many hours of manual labor previously required to create reports and created new reports for management to analyze departmental effectiveness.

Solved customer's technical problems over phone and via e-mail. Became familiar with the products of hundreds of different companies, most of whom sold software including Symantec (Norton), Autodesk, Aladdin (StuffIt), H&R Block, Novell, and ScanSoft (OmniPage

Assisted in building various components of the company's information system. Identified and solved problems on a multi-platform network. Integrated new software and assisted marketing with critical research.