Ssis Developer Resume Sample

-Drive and manage data integration activities to ensure that data is received, compete, accurate and available for users.
-Perform files transfers, data warehouse imports, and updates using SSIS
-Building ETL processes using SSIS and SQL server stored procedures
-Working on column store data warehouse system Google BigQuery, preparing PowerBI datasets and dashboards based on Google BigQuery
-Creating new data warehouse solutions
-Development of data models for Data Marts
-Document data flows, data dictionaries and findings of the data analysis
-Prepare and execute test case scenarios
-Review release intstructions
-Creating reports
-Working with high volume Microsoft data warehouses and BI technologies: SSIS, SSRS, SSAS and Power BI
-Working with Microsoft SQL server, Oracle MySQL database management systems
-Creating support BI tool using Python (web development)

-Using SSIS to migrate databases and old server environment
-Creating ETL flows using SSIS, developing and building SSRS reports and dashboard, SQL queries implementing and modifying including stored procedures, views and functions, designing and developing stored procedures, queries and views necessary to support SSRS reports
-Creating ad-hoc reports, deploying changes in internal web application (HTML)
-Updating and publishing content on the company’s internal website, data conversion and configuration using Microsoft database technology (SQL Server 2014)
-Building test plans and follow through, work on test environment, work on international projects with internal and external suppliers
-Participate in roll-outs of projects and training events

-Maintenance, development and troubleshooting of core company application based on VBA with fronted access
-Development os SSIS packages to load data from various sources, implementation of workflows by parameterization the existing function blocks
-Providing the users with a customized and functioning applications, creating database objects (MS SQL Server 2014) such as tables, views, etc.
-Creating, maintaining, and optimizing stored procedures and functions, working in agile methodology (scrum)
-Maintaining and developing Warehouse application (VBA), backend developing companies applications (MS SQL 2016)

-Creating queries and reports in IBM Cognos Query Studio
-Developing queries in IBM Cognos Query Studio for multiple users in AML team
-Preparation of MS Excel and VBA solutions in order to accelerate AML process
-Developing and testing SQL scripts to query and manipulate data, performing SQL queries
-Improving the quality of the reporting solution
-Supporting the management team by creating daily ad hoc reports

-Preparation of MS Excel and VBA solutions in order to accelerate KYC process (screening, Waterfall approach)
-Preparation of training materials in MS Excel, participation in MI program (documenting SQl database systems)
-Performing SQL queries
-Cooperation with operational managers by creating reports to meet expectations of the business partners

-Managing macro tools project improving and accelerate AML process (3 months)
-Identify, understand and plan for macro improvement session
-Participation in session with AML team and cooperation with IT team during project
-Preparing tests and application error reporting
-Performing specific Anti Money Laundering analysis of high risk customers for the UK Retail Division
-Preparation of appropriate transactional analysis of RBS and NatWest customers
-Identify and escalate potential risks to British financial authority (FCA)
-Completion of the Risk Assessment on customers which resulted in decision whether RBSG retain or exit the connection with the customers

-Develop customized lesson plans tailored to the individual learning styles and needs of each student to enhance their understanding of mathematical concepts.
-Deliver engaging and effective mathematics instruction on topics ranging from basic arithmetic to advanced calculus, depending on the student’s grade level and learning objectives.
-Conduct assessments to evaluate students’ progress and provide timely feedback to help them understand their strengths and areas for improvement.
-Create and utilize various educational materials such as practice worksheets, instructional videos, and interactive activities to facilitate learning and maintain student interest.
-Coordinate scheduling with students and parents to ensure consistent tutoring sessions while effectively managing time during each session to cover all necessary topics.
-Regularly communicate with parents or guardians about students’ progress, challenges, and achievements, providing recommendations for further improvement outside of tutoring sessions.

-Allocate financial transactions to appropriate accounts within the company’s accounting system, ensuring accurate tracking of income and expenditures.
-Manage the secure archiving of financial documents and records in compliance with legal and company guidelines to ensure data integrity and availability for audits.
-Regularly update financial databases to reflect transactional changes and adjustments, ensuring that all financial data is current and accurately recorded.
-Maintain the accuracy and reliability of financial data through consistent checks and validations within the accounting system.
-Ensure compliance with financial regulations and standards by properly organizing financial records and following established accounting practices.
-Assist in the preparation of financial reports by providing necessary data and reports from the financial database as requested by senior accountants or management.