Consultant/SQL Developer/DBA Resume Warminster, PA - Hire IT People

SUMMARY

Result - oriented, self-motivatedSQL/Database developerwith a strong background in Finance/Banking/Insurance/Managed Care industry islooking for a challenging position in a company where I can utilize my technical and business expertise.
I am eager to contribute to the mission of the organization.
Enthusiastic and open minded to engage in new endeavors.

TECHNICAL SKILLS

Languages: SQL, T-SQL, VB Script, HTML, XML

Operating Systems: Desktop: Windows XP/ Vista/Windows7/8/10 Server: Windows Server 2008/2012/2016

Databases: MS SQL Server 2005/2008/2012/2014/2016 , MS Access

ETL Tools: SQL Server SSIS(ETL)

Business Intelligence: SAP Business Objects

Utilities/Tools: ODBC, SSRS, IIS 4.0/7.0, Adobe Photoshop 5.0-7.0/CS, SharePoint, Microsoft office, Red Gate SQL Compare&Data Compare, Jira

PROFESSIONAL EXPERIENCE

Consultant/SQL Developer/DBA

Confidential, Warminster, PA

Responsibilities:

Aggregate data from multiple sources into an efficient reporting mechanism through relational database design and development, and extract-transform-load (ETL) development
Transfer data from existing applications (including Excel and Flat files) into various databases using SSIS
Create ad hoc reports using T-SQL in an OLTP environment
Involved in maintenance and development of various database distribution processes between multiple versions of SQL Server (2005, 2008R2, 2012, 2014)
Work closely with .NET developers to design data storage and retrieval processes for new/existing user applications
Design and modify SSIS packages, set up server specific configurations
Collecting, analyzing and reporting on health care/managedcare data including claims, capitation, member, and provider information
Finalize reporting required to proactively support medical management activities, provider contracting and management activities, financial and accounting activities
Create dashboards generated from trend data, utilization authorization, risk adjustment, and claims data to support departmental functions
Develop financial and analytical reports to support business needs using SSRS
Participate in 3rd party software integration and provided remote user support
Manage SQL Server database security (application and user permissions, etc.)
Utilize JIRA ticketing software for tracking logged issues and provide resolution details
Verify implemented products in accordance with the requirements

SQL Developer/Financial Business Analyst

Confidential

Responsibilities:

Generated scheduled reports using SSRS for both internal and external customers to answer inquiries and provide recommendations for addressing business challenges
Responsible for assisting banks’ managers by providing operational and financial information
Leverage tools and systems to quickly access data and present information to various levels of management and ensuring the data integrity of all reports
Created and ran Ad hoc queries to supplement data not available through the applications
Created weekly Profit and Loss statements for the company’s management team
Maintained badge process of synchronizing and importing new user accounts into the database using ETL tool (SQL Server 2008 SSIS)
Streamlined workflows to enhance and improve productivity for collecting, analyzing and reporting financial data
Reviewed data supplied by banks to ensure the validity and integrity of the data
Adhered to the best practices and standard operating procedures to bridge data gaps and resolve related issues
Received an award “Employee of the year” for displaying high proficiency in strategic planning, market plan implementation and budgeting
Translated business needs into software and operational requirements, documented and analyzed requirements and proposed possible solutions

Financial Analyst

Confidential

Responsibilities:

Performed financial and operational analyses that drove business results and sound decision making in support of the short-term and long-term goals and objectives
Assisted with development as well as updated annual strategic and operating plans
Participated in financial planning, budgeting and forecasting processes
Provided management with reports specifying and comparing factors affecting cost and profitability of products and services
Generated and maintained standard/custom reports and dashboards for business needs and validated results for accuracy
Developed accounting process for tax payable account
Designed tax policies for Tax Department according to the law
Performed tax reporting based on documentation, accounting revenue and expenses
Responsible for accounting of operations with securities
Settled all local and government taxes
Prepared different types of reports for the state tax inspection and social insurance funds
Analyzed data and created reports to pull meaningful insights, identified trends, validated business decisions/changes, tracked results on strategic and operational initiatives