Ssis/sr. Etl Developer/lead Resume
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