Data Analyst / Production Support Resume

PROFESSIONAL EXPERIENCE

Data Analyst / Production Support

Confidential

Responsibilities:

Organize requirement gathering session with business users and IT teams to align services with the needs of business processes and document both the IT and business requirements.
Review the logical model with ETL Team, DBA’s and testing team to provide information about data modeling and business requirements.
Scheduled multiple working sessions with DBAs and production support team to discuss about maintenance planning and support turnover.
Worked on data profiling and data validation to ensure the accuracy of the data between the target and source systems.
Environment - Microsoft SQL 2008 Server, Microsoft SQL Management Studio, Oracle 11g, DB Visualizer, Oracle Sql Developer, Teradata,
Reporting tools: Tableau, SAS 9.3, SQL Developer
Administered restructuring of existing SQL/SAS code from legacy sources to adhere to current processes and standards.
Developed and documented various ITIL standards on several key areas of production systems.
Data Analyst duties include scripting in SAS and Teradata environments.
Application Support for Moody’s Analytics - Risk Frontier…

Production Support Specialist

Confidential

Responsibilities:

Worked with Confidential ’ eCommerce Commercial Web site as a 3rd level support analyst for technical customer/client issues.
Responsibilities included the investigation, troubleshooting, and resolution of IT issues. Maintained ownership of these issues and provided timely and thorough status reports to the business and the internal client support teams.
Work closely with the development teams as well to provide successful and quick resolution of all IT issues.
Main Platforms working daily with: Microsoft SQL Server, Unix Server environment, DB2 databases.
Other experiences are working to troubleshoot client/customer issues within the eCommerce environments.
Provided support to Business to Business applications as well as eCommerce Apps and maintained competency of activities

Confidential

Systems Administration support lead

Responsibilities:

Maintain full support in the integration of the Confidential security databases and it’s various components of the Access Security Systems. (badging readers, video recorders and Wintel servers)
Wide range of experience in providing technical support and training to both Confidential Security and its IT environment.
Master Certification for: Lenel Enterprise Card Access Systems and Databases, Lenel Video, Boon Edam Revolving Door and Turnstiles
Work extensively in integrating the support team’s efforts with internal Confidential ’s IT processes and procedures that include it’s Change, Configuration & Release Management systems
Data Analysis, DBA support for SQL and Oracle databases
SQL Server Database admin/maintenance duties that include: the creation of DBs, backup DBs, monitoring and development of DBs (20 databases), creating views and procedures. Utilization of DTS. Analysis of data and processes/procedures for data warehouse implementations.
Analysis of data and processes/procedures for data warehouse implementations