Ssis Developer Resume Sample
Lucienne Hackett
305 VonRueden Village,
Los Angeles,
CA
+1 (555) 901 1178
Work Experience
Senior Ssis Developer
11/2015
-
PRESENT
Phoenix, AZ
- Fact ETL, Dimension ETL and advanced including slow changing dimensions and late arrivals Dimension design Developing expressions TSQL Stored procedures User-Defined Functions and Types Triggers Error handling Query Performance Tuning XML Files, File groups, and Integrity Qualifications
- Strong computer literacy and proficiency in data manipulation and reporting tools with demonstrated highly skilled knowledge of SSMS, TSQL, SSAS, SSIS, SSRS, Excel, PowerBI and PowerPivot
- Work effectively in a collaborative team environment and effectively demonstrate team building attitude and skills
- High level of proficiency with database and data warehouse development including replication, staging, ETL, stored procedures, partitioning, change data capture, triggers, scheduling tools, cubes and data marts
- Experience with a variety of industry standards regarding Microsoft database development concepts, best practices, and procedures
- Strong analytical, data mining, data modeling and data management skills, and ability to utilize data to drive strategic business decisions
- Proficient in the latest Windows environment using the most recent versions of Microsoft Office and SharePoint
- High level of proficiency with database, dashboard and report development using Visual Studio, source control tools, Excel Services, PerformancePoint, PowerView, PowerBI and ER/Studio
Ssis Developer
01/2011
-
09/2015
Chicago, IL
- SSIS (systems integration and transformation)
- Healthcare Data ETL
- Remote access tools (Bomgar and Logmein)
- Provide inputs to testing strategy, configuration, deployment, hardware/software requirement etc
- Review plan and provide feedback on gaps, timeline and execution feasibility etc as required in the project
- Participate in KT sessions conducted by customer/ other business teams and provide feedback on requirements
- Maintain and develop database components
Junior Ssis Developer
06/2007
-
08/2010
San Francisco, CA
- Demonstrated ability to be flexible and perform a variety of roles such as project champion, developer, analyst, tester, and mentor
- Advanced experience with providing users access to data by building reports and queries using various data querying tools
- Leadership and judgment to analyze, evaluate, and develop solutions to complex problems
- Interpret policy, programs, and regulations
- “LIVE” the Bank’s Mission Statement and “PRACTICE” the Bank’s Corporate Strategy
- There is a need to collect data form different organization to pull into in their system for analysis
- This is a Jr. to mid-level role we are ideally looking for someone who has about 3 -4 years of Experience
- We need this person to have GREAT communication skills
Education
Oglethorpe University
2002 - 2007
Bachelor's Degree in Computer Science
Professional Skills
- Excellent team leading skills
- Strong data modelling experience on either SAP BW / SAP HANA or Microsoft SSRS/SSAS
- Middle tier c# development skills
- Experience of skill with Microsoft Excel
- Process analysis skills
- Programming experience with .NET, specifically with SSIS script task components
- Experience building and delivering new reporting
How to write Ssis Developer Resume
Ssis Developer role is responsible for integration, modeling, architecture, database, security, java, analysis, reporting, design, travel.
To write great resume for ssis developer job, your resume must include:
- Your contact information
- Work experience
- Education
- Skill listing
Contact Information For Ssis Developer Resume
The section contact information is important in your ssis developer resume. The recruiter has to be able to contact you ASAP if they like to offer you the job. This is why you need to provide your:
- First and last name
- Telephone number
Work Experience in Your Ssis Developer Resume
The section work experience is an essential part of your ssis developer resume. It’s the one thing the recruiter really cares about and pays the most attention to.
This section, however, is not just a list of your previous ssis developer responsibilities. It's meant to present you as a wholesome candidate by showcasing your relevant accomplishments and should be tailored specifically to the particular ssis developer position you're applying to.
The work experience section should be the detailed summary of your latest 3 or 4 positions.
Representative Ssis Developer resume experience can include:
- Strong communication and presentation skills (role is customer facing, to some extent)
- Experience in data migrations, data manipulation, and reporting Strong SQL
- Good command of technologies, programming languages, databases, solutions and tools used in developing the assigned software applications
- Determines creative solutions to broadly defined problems using originality and ingenuity gained from increasing experience
- Experience working professionally with the following technologies is required
- In-depth experience in doing data transformation
Education on a Ssis Developer Resume
Make sure to make education a priority on your ssis developer resume. If you’ve been working for a few years and have a few solid positions to show, put your education after your ssis developer experience. For example, if you have a Ph.D in Neuroscience and a Master's in the same sphere, just list your Ph.D. Besides the doctorate, Master’s degrees go next, followed by Bachelor’s and finally, Associate’s degree.
Additional details to include:
- School you graduated from
- Major/ minor
- Year of graduation
- Location of school
These are the four additional pieces of information you should mention when listing your education on your resume.
Professional Skills in Ssis Developer Resume
When listing skills on your ssis developer resume, remember always to be honest about your level of ability. Include the Skills section after experience.
Present the most important skills in your resume, there's a list of typical ssis developer skills:
- Skills Required 5+ years’ experience with SQL Server Integration Services (SSIS)
- Exceptionally good and experienced in handling the application problems and troubleshooting
- Design, develop, and implement MS SQL Server SSIS ETL jobs to effectively process high-volume data sources and meet nightly processing windows
- Experience with designing, implementing, testing and deploying SSIS packages
- Strong scripting and structure programming background
- Experience working with business customers and creating best practices
List of Typical Experience For a Ssis Developer Resume
1
Experience For Senior Ssis Developer Resume
- Excellent communication skills (verbal, written, interpersonal and large group)
- Develop data mapping and design SSIS data loads with new business data elements using EDI extracts from Black Knight MSP
- Create reports and dashboards using the Kennametal standard tools to provide the standard solutions
- Reverse engineer existing SSIS packages
- Coordinate testing activities with multiple groups
- Automation of daily/weekly data loads from third party vendors using secure file transfer protocol (SFTP) and develop file watcher to trigger data load process
- Assist with New Loan Boarding SSIS package development and reconciliation
2
Experience For Ssrs / Ssis Developer Resume
- Continued support and development for ongoing process improvements and server migration to Austin
- Ad hoc reporting support for various internal and external audits and inquiries
- Person is listed on a number of ID’s per year as a co-inventor and in some limited cases is the initiating inventor
- Communicate issues, risks, and concerns proactively to the reporting team
- Self-motivated, creative and innately curious about the world of technology and consistently introducing innovative solutions to problems
- Working with SSRS
- Maintain and developer SSIS packages
- Integrate database components into .NET components
3
Experience For Junior Ssis Developer Resume
- Fix defects in .NET applications
- Handle any technical issues that come up with the availability of Reports
- Provide input on systems architecture as required
- Follow all security practices and identify areas and processes where performance and security can be improved
- Make and justify recommendations for improvement
4
Experience For Ssis Developer Resume
- Provide all required additional support to Development, Quality Assurance, and Production Support Teams
- Work in a team environment with technical and business personnel
- Experience system design, application support, development, and integration using disciplined project methodology and project delivery. This includes designing integration solutions, reporting solutions and supporting Net Developers
- Experience in Relational Database Design, T-SQL, and Dynamic SQL
- Knowledge of SQL Server 2008, SQL Server 2012
- Knowledge of SQL Server Integration Services
5
Experience For Senior Ssis Developer Resume
- Upgrade legacy SSIS packages
- Execute test plans and document results and issues
- Troubleshoot errors, propose solutions
- Track, maintain and report on project status progress
- Hands on ETL development in tools such as SSIS
6
Experience For Ssrs / Ssis Developer Resume
- Responsible for development of SQL Server Packages, procedures, tables and. NET scripts to support various data load process used for Mortgage Servicing reports
- Build SSIS packages to optimize dialer activity
- SSIS/SSRS Technical Support for Operational reporting -- work with servicing management to manage changes to daily, weekly, monthly, quarterly and EOY reporting to support operational and management reporting oversight across Loan Administration, Default and Investor/Cash groups
- Documents all requirements for implementations and changes
- Programming experience with .NET, specifically with SSIS script task components FileWatcher, automating files transfer process and modification of Visual Basic scripts
7
Experience For Junior Ssis Developer Resume
- Full Understanding of Mortgage default and the processes around it including Foreclosure, Bankruptcy, Loss Mitigation, and REO
- Delivers results for project elements/components as assigned. Exercises significant impact on project results though these efforts enabling new technologies to move forward in the development process
- Leads/defines technical elements of project objectives. Plans and conducts investigations and analyses requiring professional expertise - this statement is in scope too - where does it belong
- Applies complete understanding of technical theories and concepts in a limited field of expertise to area of research. Applies general knowledge of other related disciplines
- Mortgage Experience
- Able to perform complex design, development tasks, investigations, modeling, simulation and analyses
- Keeps abreast of trends and developments in their area of expertise, some extended areas, and incorporates them into assignments
- Proficient in how to deploy and debug SSIS packages
- Gather required details from customer in order to develop SSIS packages
8
Experience For Ssis Developer Resume
- Create/track tasks and manage content in Team Foundation Services (TFS) required
- User-Defined Functions and Types
- Files, File groups, and Integrity
- Convert legacy ETL processes to utilize SSIS Framework. Be able to produce code that is well-formatted, documented and highly efficient
- Take part and contribute to code reviews
- Apply standards and best practices. Perform data analysis and quality assurance Unit testing of SSIS and TSQL code. Collaborate with business analysts, subject matter experts, and other team members to determine data extraction and transformation requirements. Work closely and be an active member of a scrum team
- Write efficient TSQL and ETL Code. Experience with the process of loading Data Warehouse Systems
9
Experience For Senior Ssis Developer Resume
- Experience using multiple databases
- Good understanding of SQL permissions
- Estimation Techniques using Agile and Function point analysis
- Expertise in SQL programming
- ETL Prod support Monitoring and SLA maintenance for both Datastage and SSIS
- MVC and/or Spring Hibernate
- SSIS - They are using 2012
- Building complex SQL queries
10
Experience For Ssrs / Ssis Developer Resume
- Daily Offshore co-ordination and mentoring
- Hands-on any of the Self-Serve /Front-End Reporting tools like Tableau, Power BI, Lumira/BOBJ
- Write complex stored procedures and TSQL code
- ALM tools (like Atlassian Bamboo)
- Continuous integration and deployment (CI/CD)
List of Typical Skills For a Ssis Developer Resume
1
Skills For Senior Ssis Developer Resume
- Experience with managing software upgrades and testing
- Experience in Performance tuning (queries / data load processes)
- Experience working with a business intelligence tool
- Experience using SSRS and SSIS
- Experience working with SSIS products
- Experience creating SSIS packages
2
Skills For Ssrs / Ssis Developer Resume
- QL / TSQL, experience writing stored procedures, triggers, table creation, etc
- Experience working in a change controlled environment
- QL / TSQL, experience writing stored procedures, triggers, table creation
- QL development experience
- Preferably 1yr+ experienced in DataVault
- Very strong in Crystal reports
- Strong knowledge of software development life cycle (Agile methodology)
- Strong knowledge of .NET framework (version 2.0 and higher)
- Experience with flat files,
3
Skills For Junior Ssis Developer Resume
- Experience with SQL Server Integration Services (SSIS)
- SSIS experience
- Read, Write, and Speak fluent English. Experience in an Agile environment
- Experience working with end-users to troubleshoot issues
- Experience with an enterprise level job scheduling/automation tool (UC4, Tidal Enterprise, Active Batch, Autosys, etc.)
- Strong DataWarehousig and Data Modelling Concepts
- Experience with ServiceNow or other change management software
4
Skills For Ssis Developer Resume
- Strong SQL / Stored Procedure knowledge is highly desired
- Good Knowledge on Data extraction, data transformation and data load processes
- Experience with provider data within the Healthcare Industry (Medicaid preferably)
- 3) Strong overall SQL knowledge
- Experience with data conversion and transformation
- Hands-on development experience with SSIS
- Hands-on development experience with .NET
5
Skills For Senior Ssis Developer Resume
- Experience with SQL Server 2010/2012, SSIS, XML, XSLT
- Experience in enterprise application integration, SQL Server Integration Services 2008+, or similar technologies
- Create and document test cases to validate process functionality
- Experience with a source code management software, TFS or similar
- Good Functional Knowledge in the areas of Sales&Distribution, Material Management and Finance
- 6) Agile experience
- Developing the interfaces between the data warehouse and the front end using SSIS. Utilizing C# to customize the SSIS packages
6
Skills For Ssrs / Ssis Developer Resume
- Responding and resolving operational issues that have been escalated from level 1/2 ops, participating in roistered support shifts and on call as required
- Writing of documentation and procedures/ documenting the source code with comments and writing technical documentation
- Converting data creating SSIS packages
- Providing lessons learned and giving suggestions to optimize the work processes
- Working on SSIS/Datastage defect fixes, enhancements or new developments
- Attending status meetings with clients
- Attending onsite meetings with clients
- Representing ETL Prod support team
- Working on SSIS/Datastage defect fixes , enhancements or new developments
7
Skills For Junior Ssis Developer Resume
- Preparing weekly status and Monthly status reports
- Reporting on progress, issues and problems to the supervisor
- Identifying the way end users want to analyze the data in HANA/BW and Tableau
- Implementing corrective actions
- Development of SSIS packages and optimizing the ETL jobs. Fixing, enhancing, optimizing existing SSIS jobs (packages)
- C# - customizing SSIS using C# scripting
- ETL Development taking data files, transforming the data, and loading into the data warehouse
- Database Tuning including Explain Plan Partitioning and Optimizer HintsSearch Jobs US
8
Skills For Ssis Developer Resume
- Working with SSIS, including development, support, troubleshooting and upgrades
- Plan, coordinate, develop and support ETL processes including architecting table structure, building ETL process, documentation, and long-term preparedness
- Responsible developing solutions in SSIS by working off the technical specifications and design models provided by the data architect
- Analyze existing SQL / ETL Scripts and improving them to achieve better performance
- Fact ETL, Dimension ETL and advanced including slow changing dimenstions and late arrivals
9
Skills For Senior Ssis Developer Resume
- Expertise in SQL programming. Ability to manipulate data using SSIS and TSQL
- Proficient understanding of code versioning tools such as NaN
- User facing requirements gathering in Agile environments
- Quickly learn process capabilities, functionality and dependencies by analyzing code and working with peers
- Promote upgraded SSIS packages to Production by adhering to existing change management process
- Support existing daily, weekly and monthly data load processes in Production for Servicing Portfolio
10
Skills For Ssrs / Ssis Developer Resume
- SSIS Package ETL development, optimization. ETL job monitoring
- SQL Server database programming, creating tables, stored procedures, functions, etc. Ability to parse and write highly complex T-SQL by hand and also assemble it programmatically. Experience in T-SQL queries to improve performance and design complex drill down matrix and tabular reports
- Use best practices and experience to improve overall solutions on SQL server database and data warehouse, utilizing SQL Server Integration Services (SSIS) packages and custom ETL scripts (requires focus on detail and quality, and involves conducting comprehensive testing to ensure accuracy and correct functionality of the modified SSIS packages)
- Develop test plans to make sure the data warehouse solution meets all user requirements. Responsible for unit testing developments and working with the validation team to correct bugs and anomalies in the data warehouse
- Experience with transforming transactional data into dimensional models
- Strong knowledge of Business Intelligence (BI) system (Preferable banking and Finance system)
- Very strong in SQL Server Integration Services (SSIS) 2008 programming
- Good Knowledge with the following technologies: C#, XML, XSLT, ASP.NET
- Experience in performance tuning SQL Server and SSIS Packages
List of Typical Responsibilities For a Ssis Developer Resume
1
Responsibilities For Senior Ssis Developer Resume
- Database programming knowledge using Oracle PL-SQL / SQL Server T-SQL as well as experience in writing stored procedures and packages is needed. Ability to write complex SQL queries to support reporting and data analysis needs
- Travel required (see note above)
- Evaluate technical approaches and discuss pros and cons of each to arrive at a design
- Aware of the standard Change management and Project management processes
- SOM incident SLA maintenance
- Weekend support – On -call rotation
- Responsible for deliverables from Prod support team
2
Responsibilities For Ssrs / Ssis Developer Resume
- Customer interactions and follow-ups on incident resolution
- Follow-ups with REP1 team on incident resolution
- Intermediate to advanced SSIS
- Responsible for the development and management of Enterprise Data Warehouse processes and policies, following strategic direction on best practices for holistic Data Architecture
- Conduct analysis and design of data models for the development and maintenance of existing Enterprise systems
3
Responsibilities For Junior Ssis Developer Resume
- Monitors industry trends and directions and develops and presents substantive technical recommendations to senior management
- Local to Dallas area and available to interview and start immediately
- Healthcare background - specifically insurance / payer background
- Design and Develop Data migration scripts Procedures Functions
- Proficient in ASP.NET (version 2.0 and higher)
- Proficient in C# / VB.NET(version 3.0 to 5.0)
4
Responsibilities For Ssis Developer Resume
- Knowledge of XML, XPATH and XQUERY
- Knowledge of Windows Server OS (2008R2 and higher)
- Create high performance data packages and do data conversions
- Write complicated queries and stored procedures – Needs a Microsoft stack background: SQL DB and SSIS, no informatica
- 2) SSRS Development/Power BI - 25% of role (SSRS primary, Power BI would be a +)
- Weekend support–On-call rotation
- Front-end application research
5
Responsibilities For Senior Ssis Developer Resume
- IS ETL Development
- Overall knowledge of SQL 2012
- Development ETL Design and Development Optimize SQL Queries
- Data integration (ETL)
- Mid to Junior Level
- Back-end data analysis
- SQL BI DEVELOPER
Related to Ssis Developer Resume Samples
AEM Developer Resume Sample
Work Experience
• Design and develop using Sightly, JSP, servlet, sling service, configuration, runmodes
• Work with front end technologies and frameworks (e.g. Bootstrap, jQuery, Angular.)
• Lead the delivery of solution architecture and design for key digital strategy programs (including, bu...
Professional Skills
• Strong technical communication skills with...
• Experience in Content Management Systems a...
• Excellent problem-solving, planning, and o...
Apparel Developer Resume Sample
Work Experience
• Ensure all development documentation is maintained for assigned styles, including product specs and proto notes
• Create and edit Bill of Materials for assigned styles
• Partner with manager and merchandising team to conduct seasonal product analysis against competitive brand...
Professional Skills
• Intermediate to advanced computer skills w...
• Collaborates with cross functional teams t...
• Passionate to learn leading, coaching, dri...
Remedy Developer Resume Sample
Work Experience
• Obtain a DHS Entrance on Duty (EOD)
• Develop reports and queries on KPIs for leadership team to improve process effectiveness
• Deliver ongoing improvement opportunities with processes, standards, and policies
• Research and document the Service Manage...
Professional Skills
• Strong unit and acceptance testing skills
• Strong IT troubleshooting skills
• Validating received workflow proposals to ...
Assistant, Development Resume Sample
Work Experience
• Experience in construction management with preference given to residential multifamily development
• Computer proficient in Windows, MS Office, Word, Excel, Outlook, OneSite and the Internet. Ability to type 40+ wpm
• Apply common sense understanding to carry out instructions...
Professional Skills
• Strong interpersonal, speaking and writing...
• Strong computer skills, preferably using e...
• Excellent diplomatic and interpersonal ski...
Developer Level Resume Sample
Work Experience
• Debug and resolve application and data issues
• Reports to a Scrum team lead, with additional oversight provided by project manager, application architects and technical lead
• Mentor, coach and develop less-experienced team members
• Professional Angul...
Professional Skills
• Excellent team player with good analytical...
• Experience working within an Agile develop...
• Problem solving ability and critical think...
Territory Development Resume Sample
Work Experience
• People leadership experience
• Able to learn and effectively represent the positioning of Redken and Pureology brands
• Analyzing competitors’ activity
• Provides reconnaissance of competitors’ influence within territory and develops a plan to counter t...
Professional Skills
• Excellent written and verbal communication...
• Manage applicable budgets effectively and ...
• Excellent for communication skill, leaders...