SUMMARY

• Educated in Associate in Computer Information System.
• Over 13 years of progressive experience in the field of IT and Finance
• Strong skills of Application production support, VBA scripting, SQL, Windows, and Linux.
• Strong analytical, multitasking, project Management, Leadership skills. Learning Cyber Security
• Good team player with excellent communication, detail oriented, written and presentation skills with strong aptitude towards learning new technologies and like to work independently.

PROFESSIONAL EXPERIENCE

Developer

Confidential

Responsibilities:

• Provide onsite support to the R&D department as SQL Developer
• Support the CPLIMS Reporter system by revising/maintaining the Crystal Reports, XML files, SOP, user manual, system documentation, and change control process as needed. Additional responsibilities include developing new Crystal reports and providing user support.
• Write ad hoc SQL queries of the Watson LIMS database to answer questions not answered by Watson and Crystal reports.
• Liaise with multiple technology teams (SA's, DBA's, Support, Infrastructure etc.) to ensure smooth, efficient, and consistent delivery of application releases into test and production environments via our Release mgmt.
• Preparing relevant requisition documents, workflow/design diagrams to support the requirement.

Technical System Analyst / SQL Developer

Confidential, New York, NY

Responsibilities:

• Provide onsite Global Plus support to the Private Banking Division as Vision developer /SQL developer.
• Development and cataloging of customized GLOBAL PLUS (FIS application) - VISION data extract feed programs in support of Confidential internal reports tracking log for GLOBAL PLUS under UNIX (IBM/AIX) server environment.
• Support the development and enhancement of new and existing customized Global Plus - VISION reports and data extracts. Developed coding for Employee vacation tracking Project in SQL Management studio
• Prepare the code for migration to test environments and coordinate the environment builds.
• Develop and maintain database design documentation, including database diagrams, data mapping documents, SQL code snippets etc.
• Developed complex reports using multiple data providers, user defined objects, aggregate aware objects, charts, and synchronized queries.
• Coordinated with front-end for implementing logic in stored procedures and functions.
• Generated Reports using Variables, Expressions and Functions for the reports using SSRS with database as SQL Server.
• Created and maintained user, roles, and groups and granted the privileges to users and groups as per the security and privacy requirement.
• Migration of SSRS reports from SQL 2008 to SQL 2016.
• Worked on scheduled reports using subscriptions in SSRS.
• Loading data from various sources like OLEDB, flat files to SQL Server 2012 database Using SSIS

Confidential

Technical System Analyst

Responsibilities:

• Provide onsite Global Plus support to the Private Banking Division as Vision developer
• Development and cataloging of customized GLOBAL PLUS (FIS application) - VISION data extract feed programs in support of UBS internal reports tracking log for GLOBAL PLUS under UNIX (IBM/AIX) server environment.
• Support the development and enhancement of new and existing customized Global Plus - VISION reports and data extracts.

Technical System Analyst / SQL Developer

Confidential, Wilmington, DE

Responsibilities:

• Provide onsite Global Plus and SQL database support to the Wealth Management Division.
• Actively participated with team lead, business analyst and project manager for understanding and gathering requirements from business user.
• Development, cataloguing and maintaining of customized GLOBAL PLUS (FIS application) - VISION data extract feed programs in support of RBC internal reports tracking log for GLOBAL PLUS under UNIX (IBM/AIX) server environment based on SQL server.
• Coordinate the movement of Global Plus - VISION source code and executables within the TRBCPROD (Production), TRBCTST (Test) environments.
• Analyze system specifications, requirements and developed detailed documentation that included test plan, test cases, test procedures, test scripts, test reports and Change Management Record which needs to be approved by senior managers.
• Support the development and enhancement of new and existing customized Global Plus - VISION reports and data extracts (Using Visualcron application).
• Contributed in building a trust SharePoint website.
• Created and maintained user, roles, and groups and granted the privileges to users and groups as per the security and privacy requirement.
• Proactively worked on implementation and deployment of complex SSIS packages.
• Extensively experienced working on different dataflow and control flow task, for loop container, sequence container, execute SQL task and Package configuration.
• Generated Reports using Variables, Expressions and Functions for the reports using SSRS with database as SQL Server.
• Loading data from various sources like OLEDB, flat files to SQL Server 2012 database Using SSIS Packages and created data mappings to load the data from source to destination.
• Created batch jobs and configuration files to create automated process using SSIS.
• Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Improved scheduled daily job performance by optimizing SQL queries. Replaced cursor and loops with joins to improve data processing time.
• Responsible to troubleshoot production issues, suggested quick work around and fixed the critical production issues.
• Diagnosing and tuning the query performance using SQL Server 2012 SQL Profiler and Database Engine Tuning Wizards.
• Created and modified existing UNIX shell Scripts as per project and user requirements.

Confidential

Business Data Analyst

Responsibilities:

• Managing a group inbox and creating and maintaining records in Excel.
• Utilized Excel functions such as vertical lookup, horizontal lookup, concatenate and assisted in analysis process.
• Performed remediation cleanup project to assure regulatory requirements were met.
• Prepared weekly metrics deck for senior management regarding project completion.
• Excel pivot tables and charts were heavily involved to produce reports.
• Developed scorecard and agenda for team and middle office meeting on weekly basis

Global Processing Support Desk & Programmer/Business Analyst

Confidential, Philadelphia, PA

Responsibilities:

• Provided onsite Global Plus production support to the Custody Department. Issue classification, cataloguing and resolution between Confidential and SunGard are key responsibilities.
• Development and deployment of Confidential ’s internal REPORTS tracking system in support of Global Plus “Reports”, “Report Packages” and “Report Package type Events”. Rapid and accurate identification of these reporting components and their associations to one another are its main feature. The REPORTS application and database are maintained under a Windows XP environment using MS ACCESS/VB/SQL/VISIO.
• Tested upgrades of Global Plus reports and testing user access after setting their profile.
• Create, maintain, define and own status tracking and reporting documents for all SUNGARD applications for internal users (Global Plus, XSP and Intelli-Match) and outside clients’ access to Corporate Actions response too(e-Tran).
• Track and maintain issues logs for Global Plus system.
• Document and track Identity & Access Management project functional requirements.
• Development, cataloguing and maintaining of customized Global Plus - VISION data extract feed programs in support of Confidential ’s internal REPORTS tracking system for Global Plus under UNIX (IBM/AIX) server environment.
• Coordinated the movement of source code and executables.
• Supported the development and enhancement of new and existing customized Global Plus - VISION reports and data extracts.
• Developed Scorecard, Custody Dashboard and various Sub-Custodian reports for accounts, positions, transactions, and cash activity on an exceptions-only basis using Crystal Reports.
• Ran monthly Tax Reclaims files on IntelliMatch System received from Sub-Custodian and matching files between Confidential and Sub-Custodian (CITI Group, JPMCHASE and BBH).
• Provided Quarterly user recertification reports to Auditors for SunGard applications.