Ssis Developer Resume Sample

-Driving and managing data integration activities to ensure that data is received, compete, accurate and available for users.
-Performing 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
-Documenting data flows, data dictionaries and findings of the data analysis
-Preparing and executing test case scenarios
-Reviewing 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
-Participating 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)
-Identifying, understanding and planing 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
-Identifying and escalating 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

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

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