Andrew Shino
Chandler, AZ *****
adxgjm@r.postjobfree.com
Professional Experience
SQL Server BI Developer with over 7 years of experience with MS SQL Server working extensively on Integration Services (SSIS) . Experience includes requirements gathering, development, design, testing, deployment and maintenance of SQL Server BI technologies. Skills
MS SQL Server, SQL, SQL Server, T-SQL,Microsoft SSIS, Microsoft SSRS, Business Intelligence, ETL, Experience
April 2022 -
HarmonyCares, Troy Michigan - SSIS Data Engineer
● Designed and developed data pipelines using SSIS for all systems within the enterprise.
● Use SSIS to develop jobs for extracting, cleaning, transforming, and loading data into target destinations.
● Designed and tested (Unit, Integration and Regression) packages to extract, transform and load data using SQL Server integration services (SSIS) Designed packages which utilized tasks and transformations such as Execute SQL Task, Data Flow Task, For Loop, Conditional split, Data conversion, Derived column and Multi casting.
● Ensured the ongoing consistency and performance of existing processes and took the appropriate actions to resolve issues.
May 2021 - December 2021
Took Time Off to Take Care of Family
March 2021 - April 2021
Arizona Federal Credit Union, Phoenix, AZ - Senior BI Contracted Data Analyst
● Utilized SSRS and SQL on a daily basis to produce accurate, timely results in response to time-bound problems.
● Design, build, and implement reporting solutions which meet user requirements.
● Maintained and supported existing reports, reporting tools, and reporting libraries.
● Interacted and corresponded professionally with team members, project management, clients, and other stakeholders.
March 2019 - March 2021
Epiq Systems, Phoenix, AZ - Contracted Data Analyst 2
● Utilized SSRS and SQL on a daily basis to produce accurate, timely results in response to time-bound problems.
● Worked with a variety of requesters (BSAs, clients, managers, operations, etc.) to analyze and understand requirements.
● Design, build, and implement reporting solutions which meet user requirements.
● Maintained and supported existing reports, reporting tools, and reporting libraries.
● Interacted and corresponded professionally with team members, project management, clients, and other stakeholders.
August 2017 - February 2019
UnitedHealth Group, Phoenix, AZ - Full Time Data Analyst
● Developed and maintained sql queries for accessing and extracting health care data from one or more database systems.
● Created and maintained various reports, tracking spreadsheets, and on-demand ad-hoc report requests, as needed, and within specific timeframes.
● Interpret health care data and communicate key findings and recommendations to address issues.
● Peer code reviews and inspections for the purpose of program optimization and accuracy.
● Meets with management to present findings and recommendations. July 2002 - August 2017
Arizona Supreme Court, Phoenix, AZ - SQL Server Full Time BI Developer
● Involved in migrating data from AS400 tables to staging and finally load into SQL databases using SSIS.
● Used SSIS for data analysis, data cleansing, transformation, consolidation, data import and export using various sources and destinations (MS SQL Server, Excel, XML, Flat Files).
● Used conditional split, multicast, union all, derived column, merge join, script component and other SSIS data flow transformations.
● Created complex stored procedures, triggers, functions, indexes, tables, views and other T-SQL code and SQL join.
● Involved in requirement gathering, analysis, development, implementation, and production.
● Worked in a team development environment as well as worked independently and efficiently to meet deadlines.
July 1996 - July 2002
The Boeing Company, Phoenix, AZ - COBOL/CICS Contracted Programmer
● Programming tasks including enhancements, maintenance and support for clients applications and interfaces.
● Performed coding, testing, and verification of mainframe COBOL/CICS online application.
● Worked with COBOL, COBOL II, COBOL 370, Easytrieve, Xpediter/TSO, Xpediter/CICS, JCL.
3
● Y2K Compliance Project. Performed coding, testing, and verification of applications written in COBOL/ CICS.
Education
Devry University, Chicago, IL - Bachelor of Science in Computer Information Systems