SUMMARY:

An analyst with over 15 years demonstrated analytical experience in diverse roles in Confidential and power industries. My desire is to assist a company solve their technology problems using my diverse background and good problem solving skills.

TECHNICAL SKILLS:

Systems: Windows Server 2012/2008R2, standalone and active/passive clusters. Windows 10, 8, 7 clients. AIX - Unix.

Databases: SQL Server 2012/2008, Microsoft Access, Oracle, Teradata, Aginity

Productivity: Microsoft 2010 Office (Excel, Word, Outlook, PowerPoint), Communicator, WebEx, Visio, Project, Snap-It, Adobe PDF Creator, Putty, remote VPN computing via CISCO secure services, CA Erwin data modeling, SAS development and reporting, Lynx chat, social media

Development/Programming: Visual Studio 2010/2008-VisualBasic.Net, VBA, T-SQL, XML, ASP (Active Server Pages), VBScript, LDAP query, AD Active Directory tools, SAS.

Other: BizTalk 2013/2010, Microsoft Team Foundation Server, SharePoint 2010 Administrator, Helpdesk analyst for Mainframe systems (TSO, VM, MVS), Powershell, Agile/Rally

Microsoft SQL Server client/server tools: SSMS (Management Studio), ETL using SSIS (Integration Services), and Reporting development with BIDS for SSRS (Reporting Services)

WORK EXPERIENCE:

Confidential

Consultant

Responsibilities:

• Creating DQ rules in Ab Initio for Commercial Lending team.
• Completed training on Ab Initio for the department - a new application of the tool.

Confidential

Data Analyst

Responsibilities:

• Participated with Agile/Rally development to work with programmers in concept development of SAS VA calculators for EIT that will eventually replace Excel calculators.
• Provided technical documentation including flowcharts and logic diagrams. Assisted analysts with improving the efficiency and accuracy of Excel calculators used in EIT.

Data Analyst

Confidential

Responsibilities:

• Conducted data mappings from regulatory reports instructions.
• Documented Regulatory report requirements.
• Compared current data used in report to previous quarter.
• Identified and documented gaps.
• Compared current data sources with target Confidential data sources.
• Developed mapping documents with data lineage from source (minus one hop back) to target. Identified key business elements ( Confidential ’s) required to produce the report.
• Reviewed and documented current report creation process.
• Analyzed manual data providers (MDP) quarter over quarter (QoQ) data variance.

Confidential

Consultant

Responsibilities:

• Using VBA to automate repetitive and systematic manual tasks.
• Develop a prototype for customer design.
• Collect data from large data warehouse with Teradata queries.

Confidential

Consultant

Responsibilities:

• Analyzed End-to-End data lineage using queries from Netezza and diagrams from MetaCenter tool.
• Documented data lineage and thresholds based on ranges of data using SQL queries in Netezza and MetaCenter tool.
• Recorded lineage thresholds on Excel workbooks and documented lineage graphically using MS Visio.

Confidential

Technical Consultant

Responsibilities:

• Trained customers to upgrade Paragon with SQL jobs, supporting functions with stored procedures and other database projects via remote WebEx sessions.
• Led Meaningful Use Technical team for Truven Analytics and Microsoft BizTalk to setup Clinical Decision support rules within Paragon for business logic. Installed over 200 customer sites on shorted deadline while providing support with existing customers. Trained customers via remote WebEx on future upgrades.
• Developed SQL Server scripts to support and upgrade Paragon products at customer sites remotely using SQL Server stored procedures and custom scripts.
• Performed database admin functions for hospitals, like database backup/restore; maintenance plans, SQL jobs.
• Converted Patient Health Info (PHI) from legacy systems to Paragon database using bulk insert ( Confidential ) from legacy systems via flat file inputs to Paragon SQL Server database. Performed error checks on data between databases and migrating data as necessary, also modifying triggers, check constraints and stored procedures if required.
• Setup and install SSIS packages for new installations and upgrades, including server settings and permissions.
• Tracked projects via MS-Access, coded VBA modules to allow others to add training data.

Confidential

Data Analyst

Responsibilities:

• Document and reverse engineered DB2/Oracle/SQL server databases using ERWIN to archive legacy applications.

Data Analyst

Confidential

Responsibilities:

• Deployed a Database User Interface web tool for provisioning IDs (DB UI) tool to all Confidential production and Business
• Continuity Program ( Confidential ) databases and SQL Server instances to facilitate collection of required information info prior to
• Loading into the Account (ID) Certification Tracking system (ACT).
• Incorporated all Confidential Oracle databases and SQL servers into User Interface (UI) tool within 6 months term of contract. This allowed Data Security team to provision IDs for these items and more importantly reduce risk to Confidential that these items were not certified.
• Arrange, print, manage the documents for Confidential presentations.

Confidential

Data Analyst

Responsibilities:

• Provided MSRS reporting support to corporate Confidential users by troubleshooting and developing MSRS reports generated from large Oracle or MSSQL datasets.
• Troubleshoot issues with reporting and provide solutions.
• Used Remedy Picasso for entering Incident and Change requests.
• Setup and used Oracle and MSSQL client access to multiple large databases in multiple environments.
• Used Change-man for code management of MSRS report code between TEST, DEV, QA and PROD environments.
• Used Visual Studio BIDS 2005/2008 to either design new or troubleshoot existing MSRS reports. Used MS SMS 2005/2008 for building and testing MSSQL SQL queries.
• Used Quest TOAD for building and testing Oracle 11g SQL queries.
• Provided on-call MSRS reporting support for Confidential reports.
• Supported reports based on Analysis Services developed cube - includes knowledge of cube design, process flow and desired outputs.

Confidential

Management Metrics Analyst

Responsibilities:

• Developed monthly production reports for Capital Markets, Investor Relations, and Regulatory OCC.
• Developed multi-join queries and embedded SAS statements across large databases - SQL Server, DB2, Oracle, UNIX data marts to build credit risk datasets using PUTTY to send secure data to 3rd party government consolidator.
• Maintained and ran monthly SAS application to collection data from SQL databases and created output for OCC dataset that was transmitted to 3rd party for OCC.
• Acquired the lead SAS reporter position for 6 teams to produce datasets used with credit department.
• Provided SQL and SAS datasets to Risk Management teams and developed a method to transfer data between firewalls.
• Developed monthly production reports for Capital Markets, Investor Relations, and Regulatory OCC. Used query skills across large databases - SQL Server, DB2, Oracle, UNIX datamarts.
• Allocated mainframe datasets and FTPed data to/from mainframe datasets for address correction.
• Designed and developed a SAS application to automate collection of loss data from Excel sheets to build Losses cumulative dataset - loss data was based on corporate GL sections.
• Developed a SAS application to combine several datasets and to provide department dataset for Zone Risk Segmentation report

Confidential

Senior Reporting Analyst

Responsibilities:

• Designed and developed a Lock Restriction Application in MS-Access: (a) for allowing field managers to perform loan broker lock assignments and (b) for administrative personnel to manage broker status changes.
• Processed Broker Score Card Reporting each month which produced following results by using SSIS to collect data from
• ESSBASE and other data-warehouses and report to Secondary Marketing department:
• Performed monthly production of wholesale mortgage sales and management data for reporting to field management
• Developed reporting rollup summary reports
• Developed suite of reports for field management on wholesale broker performance with different presentations features
• Converted reports from MS-Access used by Credit Swap Confirmations department to SQL Server and SSRS reports to achieve enterprise standards of data backup,security and reliability. Identified failures with MS-Access reporting system and developed specifications for SSRS reports used to submit Federal Credit reports.
• Supported Wholesale Operations division with MS-Access applications that replaced Excel spreadsheets in Derivatives,
• Performed Daily Production reporting to Documentation department and management staff.
• Participated on Confidential - rates and Endur - conversion project: (a) provided project and production status reports on trading system conversion and (b) developed recon database for GL and trade transactions