We provide IT Staff Augmentation Services!

Ssis/sr. Etl Developer/lead Resume

0/5 (Submit Your Rating)

Redlands, CA

SUMMARY

  • Extensive experience in SSAS and SSRS Services & expertise in ETL implementation, Database Administration/Development of MS - SQL SERVER 7.0, 2000, 2005 and 2008 SR, 2012, DQS,MDM and MDS
  • Combined expertise in the development of effective data infrastructure, ETL processing, data warehouse, data modeling, and business intelligence reporting and dashboards
  • Involved in Data Migration between different Systems from OLD legacy systems and RDMS
  • Played leading Role in SDLC including pre-sale, Customer management, requirement gathering, system design, integration testing, Delivering/Signing of the Product
  • Extensive experience in DTS and SSIS Integration Services
  • Experience in MS SQL Server installation, configuration, performance tuning, client/server connectivity, query optimization, back-up/recovery, running Database Consistency Checks using DBCC and troubleshooting on large databases, Stored Procedure Tuning and Trigger Implementations
  • Excellent in SQL Server Database design, development and application development. Very strong in coding with VBA, Access forms, reports and modules
  • Skilled in problem solving, building, trouble shooting, and upgrading computer systems
  • Extensive experience in T-SQL to write Queries, Stored Procedures, and User defined functions
  • Design, develop, manage, and implement quality client/server applications that meet business requirements
  • Extensive experience in full Software Development Life Cycle (SDLC) such as Requirement study, Database design, Setup and Manage Team, Delivery Schedule/Priority, system/program specification, unit/system/integration/user acceptance testing, Production Implementation, Maintenance, Production support, Quality, Documentation and User training
  • Strong working knowledge of state-of-the-art database concepts/design/deployment, recovery techniques, performance monitoring and tuning, Structured Query Language and relational database design techniques
  • Experienced in writing complex T-SQL queries to implement the business rules
  • Excellent Communication and Interpersonal skills and ability to work in a team or individually, and a self-starter
  • Demonstrated aptitude for quickly learning new technologies, equipment, and software
  • Multi-disciplinary experience includes comprehensive knowledge of Project Management practices, team management, risk management, and user acceptance testing
  • Experienced in Crystal Reports; designed and developed reports
  • Very proficient in designing Physical and logical database design using ERWIN

TECHNICAL SKILLS

Languages: ASP.Net, VB.Net, Visual Basic, java-script, Java, VB-Script, ASP, C++, C#, XML, DHTML, HTML, MXSML, DOM, COM/DCOM, MTS

Databases: SQL Server, Reporting Services, Replication Services, DTS, Oracle, (PLS/SQL, Transact SQL, Stored Procedures, Triggers), Business Objects, SSIS and SSRS

Operating Systems: NT, 2000/2003 Advance server, MTS Server, MS Transaction Server

Reports: MS Reporting Services SSRS, Crystal Reports, Active Reports.

PROFESSIONAL EXPERIENCE

Confidential, Redlands CA

SSIS/Sr. ETL Developer/Lead

Responsibilities:

  • Technology used SQL Server 2012, DQS, DBAmp for Salesforce synch, Theabald for SAP extract SSIS for SQL Server 2012 and Visual Studio 2012
  • Upgrading SQL2005 to latest SQL server versions and created SSIS packages.
  • Involved in creating and maintaining MDM (Master Data Model) for all Confidential Application which includes SAP, Salesforce, Confidential GIS and other provisioning application
  • Involved in ETL Restructure. This includes implementing ETL Framework and standardized package development, deployment and Error capture and reporting
  • Effectively implement framework for Package management, error resolution and reporting and report to specific department
  • Implement strategy to synch data between SAP and Salesforce using SAP Delta queues and Microsoft CDC services
  • Improved ETL time up to 80% and significantly reduced overhead load from ETL activities on OLTP applications using CDC services
  • Develop DataStream for different business consumers and applications
  • Implement ETL modules to manage AD users and managing security groups using MDM daily synch
  • Involve in data reconciliation and working toward implementing and creating Golden Record using DataStream’s from SAP, Salesforce and ArcGIS
  • Integrated Arc GIS usage data to data warehouse and Data mart

Confidential, Baltimore, MD

SQL Server Migration/Sr. ETL Developer/Analyst

Responsibilities:

  • Involved in CRM upgrades and data migration across the platform including SQL server and Oracle.
  • Implemented procedures and methods to minimize the gap between business users and development team and improve communication
  • Implemented the methodology for ETL Requirements and Execution Plan and Mapping documents
  • Managed migration of multiple system for system upgrade enterprise wide
  • Involved in data authentication process and Error Reporting
  • Implemented ETL framework to facilitate the ETL development process

Confidential, Denver, CO

SSIS/Sr. ETL Developer

Responsibilities:

  • Upgrading SQL SQL server and SSIS packages
  • Optimizing stored procedures and other SQL scripts
  • Created new framework for all ETL jobs which includes Error reporting, Error Recovery, and synchronizing between different Source.
  • The framework support SSIS development environment
  • Daily ETL production support between Oracle and SQL server
  • Implementing process for development and deployment to production
  • ETL Support for data warehouse
  • Converting Existing ETL process to use incremental delta process
  • Creating stored procedures for reporting team.
  • Provided support for modification of existing reports developed utilizing MS Reporting services(SSRS)
  • Collaborating projects across different departments including business clients and data teams

Confidential

SSIS/SSAS/Sr. ETL/Database Developer

Responsibilities:

  • Development of new report subscription using SSRS
  • Providing ETL Support for different production systems using SSIS
  • Providing Support to production team as well as Development Team with their production issues and new development.
  • Development of new cubes for marketing department involves designing from ground up, identifying Measures, Attributes, Hierarchy and ETL and addition to existing Data warehouse using MS Analysis Services (SSAS)
  • Performance tuning of existing procedures, packages and jobs
  • Experience in C# scripting and vb.net scripting
  • XML data extraction support from 3 credit Bureaus
  • Supporting marketing team for their data extraction and management.
  • Involved in full project life cycle SDLC. Manage environments like DEV, UAT and PROD

Confidential, Virginia

SSIS/Sr. ETL/Database Developer

Responsibilities:

  • Involved in development of SSIS packages for data migration across systems.
  • Current duties include maintaining Time Series Economic data from varies venders like Data Buffet, Loan Performance and D&B into Data warehouse.
  • Managing the ETL scheduling and comprehensive reporting on Data quality, data versioning and Data files
  • Managing different data formats including flat files, Excel and CSV file formats.
  • Automation of all manual process including Data transformation and Various ETL process Using SSIS
  • Managing SharePoint for File History and ETL reports. Creating web parts for SharePoint mainly ETL admin Reporting and ETL Schedule management.
  • Data modeling for new database and performance and recommendations for both SQL servers and Oracle databases. Technical lead for new initiatives and projects.
  • Collaborating projects across different departments including business clients and data teams.
  • Supporting ETL for rich environment which includes MS SQL servers, SharePoint servers, Oracle and Business Objects.
  • Involve in full project life cycle SDLC. Manage environments like DEV, UAT, SIT and PROD.
  • Clear case and iCART for deployment.
  • Scripting in C# and VB.net

Confidential - Las Vegas

SSIS/SSAS/SSRS/Sr. Data Warehouse / ETL Developer

Responsibilities:

  • Development of ETL using SSIS for different Casino Properties
  • ETL Upgrades and ETL Development for SQL server, Oracle and DB2 platform
  • This involves MS BI Stack including SSIS, SSAS and SSRS
  • Development of new reports using SSRS
  • Going through complete life cycle of upgrades for Casinos which include adding new dimensions and measures and ETL development.
  • This includes requirement gathering, approval of deliverables, Development, QA, Deployments and final approvals.
  • Providing data warehouse and ETL support for number of properties using Confidential applications
  • Data Analysis and Reports
  • Providing level 2 and 3 support
  • Installation and data reconciliation which involves Terabits of Data for various Casinos
  • Experience in C# scripting and vb.net scripting

Confidential - Owego

Sr. Database/ETL Developer

Responsibilities:

  • Involved in Mentoring/Implementation of ETL techniques for new BI implementation effort using SSIS.
  • Created ETL packages for populating the Dimensions and Fact Tables
  • Implementation of restart-ability of Master package and Error logging implementation
  • Implemented packages from Staging to Warehouse and Warehouse to Data Mart
  • Involved in optimization and solving performance issues
  • Actively participated resolving issues between frontend Team and ETL Team
  • Involve in stored procedure optimization and solving performance issues
  • Creating fault tolerance and rollback strategies for Data downloads for transactional database

Confidential

SSIS/Sr. Database Developer

Responsibilities:

  • Involved in writing new SSIS packages and automation of existing transformation scripts
  • Implementing new ETL strategies using SSIS for Visa transactions
  • Implementation of Data Extraction for Data ware house and Analysis Services(SSAS)
  • Interfacing with customer for requirement specification, code walk through and Strategy Sessions, Implementation and delivering the final project
  • Involved in supporting new Stored Procedure for Analysis application for Visa Transaction
  • Working with development team to provide the backend support for application development
  • Store procedure optimization and solving performance issues
  • Creating fault tolerance and rollback strategies for Data downloads for transactional database
  • Involved in performance tuning of existing DB objects and database maintenance plan

Confidential

SQL Server/Sr. Database Developer/DBA

Responsibilities:

  • Managed migration of SQL Server from 7 to 2005 Server
  • Involved in SSIS 2005 SQL Server conversion from SQL 2000 DTS packages
  • Designing and creating new customer loyalty programs and implementing the business logic using SSIS packages
  • Creating DB schema using Visio
  • Extending existing point programs to create the to include different criteria for loyalty programs
  • Implemented Survey application “Survey Monkey” and integrated the survey result using SSIS 2005 SQL server
  • Involve in incorporating the survey result in Loyalty programs
  • Designed and implemented the stored procedures to facilitate data extraction for marketing campaigns
  • Implemented SSRS reports.
  • Data replication across servers using Delta methodology using SSIS packages
  • Involved in data replication for synching development environment with the productions with CRM database
  • Monitoring and optimizing the performance of the SQL server databases
  • Wrote stored procedures and queries to maintain Database System. Enhanced the indices on the table objects. Query optimization.
  • Involve in existing stored procedure optimization and developing test plans and test cases
  • Implementation of BI front ends: scorecards, trend analysis and profiling

Confidential

SQL Server/Sr. Database Architect/DBA

Responsibilities:

  • Database upgradation from SQL Server 7.0 to SQL Server 2000 to SQL Server 2005
  • SSRS implementation and conversion of DTS to SSIS services
  • Actively involved with customer interfacing which includes pre-sale meeting, technology session and recommendation
  • Database Modeling and Architecture
  • Led requirement gathering process which includes organizing meeting with customers and different business units
  • Involved in organizing JAD sessions for solution recommendations
  • Interfacing with programming team for Database design
  • Involve in installation and maintenance of SQL SERVER
  • Led migration and upgrade of several SQL Server database
  • Design Database and Maintaining Data database optimization
  • Database Normalization, Involve in the Implementation of data warehouse and data mart.
  • Monitoring and optimizing the performance of the SQL server databases
  • Wrote stored procedures and queries to maintain Database System. Enhanced the indices on the table objects.
  • Optimizing queries and writing stored procedures
  • Developing customized reports and developing database test plans
  • Developing data views and improving performance on the existing views
  • Developing DTS Packages
  • Implementation of ETL tools along with Ad Hoc reports, Data mining and Analysis. Development of data Marts.
  • Maintained .Net Application and C# web application. Wrote custom Data parsing application in VB.net and C#
  • Implementation of BI front ends: scorecards, trend analysis and profiling
  • Managing web services in VB.Net and C#
  • Devised methods and techniques to maximize reusability of code, solid testing and simple implementation.
  • These redundantly reduce development time and minimized any project overheads

Confidential, Orange CA

SQL Server/Sr. Database Developer/DBA

Responsibilities:

  • Installation of SQL SERVER 2000/2005
  • Involved in data migration for upgraded server
  • Backup and Restore and log shipping
  • Creating user requirements for Application/Database Architecture
  • Interface with different business units in planning sessions for application development and Database designing.
  • Co-ordinate with Offshore team Local Team for work coordination
  • Co-ordinate meetings with developers and management for implementation and rollout strategies
  • Interface with DBA and IS team for application rollout and periodic patches
  • Database Modeling and Database ArchitecturE
  • Design Database and Maintaining Data database optimization
  • Implementing business logic using Triggers, Views and Stored procedures and performance tuning of several projects
  • Data modeling using ERWIN tool and Microsoft Visio
  • Hands on experience in trouble shooting database issues and writing complex stored procedures
  • Conversion of many databases from access to SQL Server
  • Conversion of Oracle Packages to MS SQL
  • DTS Packages for partial database recovery
  • Converting Access reports to MS Reporting services
  • Project Coordinator/Database Developer in designing and implementation of ASP/Com based framework for web Application and reporting services

Confidential, Irvine CA

Senior Developer

Responsibilities:

  • Development and implementation of a Triumph system for Confidential restaurants chain involving Confidential, Pizza Hut and KFC Chain
  • Wrote supporting stored procedures for new screens and business logic implementation.
  • Applied development methodology based on centralizes framework and set of tools to generate cookie-cutting approach to develop form
  • Porting functionality on Client Side by re-writing modules in Java scripts and converting Oracle Packages and Stored procedure to SQL Server

Confidential, Inland CA

Architect/Lead Developer

Responsibilities:

  • Database Administrator in Administering MS-SQL Server, performing day to day tasks such as Database tuning by checking indexes and modifying procedures, creating users, assigning roles
  • Performance tuning servers, stored procedures, queries, index tuning - using SQL Server Profiler, NT Performance monitor, Query Analyzer
  • Involved in the development of DTS packages and stored procedures using T-SQL
  • Designed and Implemented interfaces between SQL Server, Oracle based Application and MS Access, based custom software.
  • Did customizations for customers using VBA for interfacing
  • Creating automated Backup and Recovery plans for databases and logs
  • Check databases, jobs, nightly backups on all servers and monitor system log and security log on Event Viewer

Confidential

Architect/Lead Developer/DBA

Responsibilities:

  • Involve in SQL Server installations and implementing maintenance plans
  • Involve in Backup and Restores and data migration between development team
  • Responsible for the maintained production/development servers
  • Involved in the planning, development and implementation of an ERP system for a furniture-manufacturing Company.
  • The system was converted from an existing Oracle Just in Time (JIT) system into a three-tier multi user Intranet application.
  • Conversion entailed all basic modules of the JIT system including Order Entry, Accounting, Engineering, Manufacturing, Procurement and Inventory Control.
  • The new system T2K-JIT was developed by creating Active-X User Documents through Visual Basic 6.0 with the backend Database of SQL Server 7.0.
  • Maintain implementation SQL Server for clients through VPN and maintained in-house testing SQL Server.
  • Developing DTS Packages between SQL server and Oracle
  • Worked as a database developer to implement new functionalities and maintain existing database objects. This data base has around 1400 tables and 1800 stored procedure
  • Designed the database schema for program management, Task Management and Assessment module as per requirements
  • Used Erwin tool to created data model and maintain multiple versions of databases schemas.
  • Created physical data model for existing database by using ERWin with reverse engineering process.
  • Worked with offshore team to implement new functionalities.
  • Wrote complex stored procedures, views and queries to develop Adhoc report
  • Worked on data issues.
  • Wrote Synchronization Application in VB to synch data between Oracle and SQL server.
  • Developed methodology for designing the translator tool translating Oracle Forms and Framework and COM objects to simulate Oracle functionality.
  • The project involved array of middle-tier ActiveX dll’s and Active-X exe and Java Scripting.
  • My role was to develop the extensive framework to simulate the complete functionality of Oracle in VB.

Confidential

Senior Software Engineer/DBA

Responsibilities:

  • Specialized in Systems Design, Workflow Analysis, Project management and Co-Ordination of client server application
  • Extensive knowledge of Intranet and Internet application with Microsoft Solution of Interdev and DCOM objects.
  • Designed online Intranet reports in Java, Crystal Info, VB and Oracle for Confidential Inc.
  • Define Use case scenarios; develop sequence activity and class diagrams using Visio in order to define the scope of the project
  • Maintained multiple SQL servers for Confidential
  • Implementation of database best practices and standards
  • Designed database tables, normalization, and provided E-R Model among all the tables.
  • Generated reports, queries, and database updates using MS SQL and PL/SQL.
  • Developed User Interface components, Business and Data Objects using Visual Basic and ASP
  • Prepared specifications for system changes and/or systems testing
  • Created Data Dictionary and documented all procedures according to technical documentation standards.
  • Designed and developed complex real-time reporting application for stocks and bonds for one of the largest financial management company (Provident Investment counsel).
  • Designed using SQL Server, Visual Basic and Crystal Reports
  • Developed Remote Synchronization module for client/server application using ORACLE and Visual Basic.
  • Module allows remote user to use application on their laptops in field and later synchronize it with central Database.
  • Provided Performance Tuning, Normalization and ERD Diagrams for existing database.
  • The Application tracks bank loans, collateral and customer correspondence.
  • Keeps track of collateral auctions and litigation process. The application was designed to automatically generate letters to clients.
  • Duties Involves Travelling and customer interfacing. All across European clients.

Confidential - Irvine, CA

Senior Software Engineer

Responsibilities:

  • Applications development and customization using Visual Basic, Power Builder, Access and FoxPro
  • Developed Client/Server applications for Confidential . Visual Basic is used as the primary development tool.
  • Expertise in using Windows API. Extensively used Attachmate for HLLAPI interface.
  • Used Delphi to create DLL for Mainframe logins. OLE2 automation with MS Word.
  • Created Stored Procedures and Triggers for Client/Server applications Administration and management of SQL Server
  • Project manager for WorkComp package using FoxPro for Windows.
  • The application is designed to track the disability claims, maintain transaction, create checks, and reconcile checks, Dairy system, and detailed reporting features.
  • OLE automation with MS Graph. Excellent communication and interpersonal skills

We'd love your feedback!