Consultant - Ssis Developer Resume
3.00/5 (Submit Your Rating)
Austin, TX
SUMMARY
- Experienced professional, DBA, team leader and DB application developer in SQL Server, DB2, Mainframe, AS400 - iSeries and Object Oriented multi-platform IT Environments for over 25 years.
- Specialized in Data Migration and Transformations between DB2, Sybase, Excel and Text Files into MS SQL database. Solely performing the entire process started with software installation, analysis, creating all Database Objects, Data Transitions and Load, verifying data and testing. Experience working with AGILE Technology, DevOps, SCRUM, Kanban, JIRA and Confluence.
- Data Architect with Business Intelligence BI and DW Design and implementation Skills.
- Design and Develop Data transformation and Migration using MS SSIS, Informatica, Pervasive and SAP BODS ETL, PowerBI Tools within different Data Warehousing and BI platforms.
- Specialized in developing interfaces from Java to Legacy system using Java and SQL Server Stored Procedures or DB2 (Native SQL & Cobol SPs) and ETL tools.
- Physical & Logical Database Design using Erwin Modeling tools generating DDL Scripts, creating all DB2 and SQL Server DB Objects in Development, Test and Production Environment,
- Design detailed specifications for program modules using UML and use cases.
- Plan and coordinate all level and types of testing for projects and programs throughout the project life cycle including production implementation and support.
- Document systems, programs, operations, and user stories and procedures.
- Analyze and rectify production problems as required and makes recommendations for non-recurrence of such problems as well as solving those problems by myself.
- Making a significant Performance Improvement with the best approach in Database and Application Design, Modifying SQLs, Stored Procedures, Creating the best performing Indexes when needed on DB2 and SQL Server platform, documenting all tasks in JIRA.
TECHNICAL SKILLS
- MS SQL Server 2005-2017, MySQL, UDB, DB2 on z/OS & iSeries(AS400) & LUW, Oracle, Sybase, JIRA, TSQL MS Management & Visual Studio, IDERA
- SSIS, Pervasive, Informatica, SAP BODS, UML, WinSQL,VisualAge, Java SmallTalk, Data Studio, SQL, QMF, Crystal Reports, SPUFI, TSO/ISPF, FILE-AID, IBM File Manager, SyncSort, Erwin, XPEDITER, CICS, CHANGEMAN, RMF ENDEVOR, BMC Utility, CA Insight, SCRUM, Kanban, Confluence SharePoint
PROFESSIONAL EXPERIENCE
Confidential, Austin, TX
Consultant - SSIS Developer
Responsibilities:
- Working on extremely complex Database Migration from DB2 on AS400 to MS SQL using MS SSIS ETL tool. Downloaded all needed software to do the assignment: Installed MS SQL Server 2017, MS Visual Studio 2017, Management Studio, SSDT, ODBC drivers, set DSN Data Source to access DB2 from SQL Server.
- Analyzed the design that was developed prior to my assignment, modified it optimizing the process and dataflow, created necessary indexes to speed up the queries and developed the SQLs for data validation and verification.
- Generated DB2 tables DDLs, adjusted them to be compliant with SQL Server standards and created all corresponding Databases, Tables, Views and Indexes on SQL Server.
- Analyzed the design that was developed prior to my assignment, modified it optimizing the process and dataflow, created necessary indexes to speed up the queries and developed the SQLs for data validation and verification. Also provided summary data reports for the Project.
- Migration included merging Cardinal data on DB2 and LoanIQ data on SQL Server, so had to develop extremely complex SQLs and handle lots of updates, inserts and merge statements to get all correct.
- Performed implementation into Production for Plains Loan Bank as the first association of FCB. The project finished with the big success
- Documenting the entire process, DDL files, Queries and created Instructions for creating and using Linked Servers, SSIS Projects and Packages.
- Created and provided Bank Management with a new much better design which will optimize the process, reduce the testing and execution time for all other 11 FCB associations.
Confidential, Austin, TX
Consultant - Data Migration Analyst
Responsibilities:
- Working on Database Migration from DB2 to MS SQL Server for all Databases Confidential need to migrate. Downloaded all needed software to do the assignment: Installed MS SQL Server 2017, MS Visual Studio 2017, Management Studio, SSDT, ODBC drivers, set DSN Data Source to access DB2 from SQL Server.
- Setup Always-on High Availability Groups.
- Generated DB2 tables DDLs, adjusted them to be compliant with SQL Server standards and created all corresponding Databases, Tables, Views and Indexes on SQL Server.
- Analyzed the provided Business requirements, filtered them and documented with use cases back to Business people. Once accepted and agreed to worked on details till all was finalized.
- Migrated first set of DB2 Schemas to SQL Server using SQL Server SSIS Packages and Import/Export Utility and verified all data are transferred and match DB2 data.
- Applied Transparent Data Encryption (TDE) to Databases containing NPI and HIPA data.
- Analyzing existed and new reports users will need and creating queries to retrieve data for reports. Using SSRS to produce first set of reports.
- Initially helped BI team and later joined the team to integrate data into Data Lake using SAP BODS ETL, PowerBI Tools within different Data Warehousing models.
- Documenting the entire process, DDL files, Queries and created Instructions for creating and using SSIS Projects and Packages.
Confidential, Austin, TX
DBA Architect / Senior System Analyst
Responsibilities:
- Worked as DBA on the SQL Server installation, upgrade, administration, monitoring, optimization and maintenance. Supported all in-house projects by designing and creating the logical and physical database structure such as data model, database, tables, indexes, stored procedures, triggers, etc.
- Database Modeling using Erwin for all required DB2i on AS400 and SQL Server DB objects.
- Perform day to day Database Maintenance tasks - Database and replication Monitoring, Backups, Space Management, Resource Utilization, SQL Optimization and Performance tuning and improvement.
- Troubleshoot database performance issues and tune database objects. Set up traces and Profiler to troubleshoot performance issues. Analyze deadlocks diagnose issues on the server. Troubleshoot Infrastructure issues related to SQL database server such as memory, CPU, I/O, Storage, using IDERA Diagnostic Manager Tool. Monitor log files to proactively resolving issues.
- Designed and fully performed the entire process of mass migration including data transformation from DB2 on iSeries into brand new created SQL Server Databases using MS Import/Export utility and MS SSIS packages. Automated any repeatable data load creating and scheduling SQL Server Agent jobs to execute all needed steps including executing SSIS packages, Stored Procedures and PowerShell Scripts.
- Performed Data refresh of DB2 Database and sole developed a fully automated Data refresh process for SQL Server tables applying all changes in non-production environment.
- Analyzing the access path of any bad performing Query. Coding a new or modifying existed SQLs, T-SQLs and SQL Stored Procedures either DB2 on AS400 or SQL Servers.
- Highly involved in the company transition into AGILE Technology and DevOps.
- Attended a few workshops for SQL Server DB transition into MS Azure and MONGO DB.