Etl Developer (ssis,red,informatica) Resume
Miami, FL
SUMMARY
- High proficiency with 8 years of experience in Database System Analysis, Design, Implementation and Administration of MS SQL Server 2000/2005/2008 , Teradata.
- Extensive knowledge of Relational Database Management Systems like SQL Server, Oracle,Teradata.
- Expertise in developing Stored Procedures, Views, Triggers and Complex Queries on SQL Server 2000/2005/2008 to facilitate efficient data manipulation and data consistency.
- Actively participated in sprint planning to follow Agile Methodology.
- Migrated Data from MS Access, MS Excel, flatfiles to Teradata by using Wherescape RED and Informatica .
- Participated in SCRUM standup meetings to review changes and updates.
- Created User stories to break the tasks following the rules of Agile.
- Experienced in defining Data Sources and Targets in Teradata creating data source views.
- Used Informatica to move data across multiple environments into Teradata warehouse.
- Worked with TARA to do a backup and restore of Teradata objects.
- Used Teradata OLELOAD,MLOAD,FASTLOAD,BTEQ scripts to move data from flatfiles to Teradata RLZ
- Experienced in defining Data Sources for creating data source views.
- Expertise in working with and designing SQL Server 2005, SQL Server 2005, Oracle 9i, MS Access and Teradata databases.
- Migrated Data from MS Access,SQL Server, flatfiles to Teradata by using Wherescape RED and Informatica .
- Extensive working knowledge of Oracle databases with forms and reports and MS SQL Server 2008.
- Worked with SSIS file encryption and scheduled to uploaded the file to FTP.
- Experience in data warehousing such as dimensional modeling, star and snowflake schemas, data marts, fact and dimension tables identification, and DataVaulting .
- Strong experience in T - SQL development with MS- SQL Server 2000/2005/2008 .
- Experience in upgrading of SQL Server from version and .
- Conversant with all phases of Software Development Life Cycle involving Systems Analysis, Design, Development and Implementation.
- Experience in authoring reports using SSRS.
- Extensive experience in implementation of Data Cleanup procedures, transformations, Scripts, Stored Procedures and execution of test plans for loading the data successfully into the targets.
- Experience in Database Backup, Recovery and Partitions,Indexes.
- Proficient in performing DBA tasks like installing and configuring SQL servers, creating maintenance plans, checking job failures and troubleshooting issues.
- Proficient with SQL Enterprise Manager, SQL Query Analyzer, scheduling jobs with SQL Server Agent.
- Hands-on working experience with analyzing query plans, using extended Stored Procedures, managing indexes and locks, troubleshooting deadlocks.
- Experience in Microsoft SQL Server Clustering, Log Shipping and Replication solutions.
- Experience in developing, monitoring, extracting and transforming data using DTS/SSIS Import Export Data, Bulk Insert and DTS/SSIS.
- Extensively involved in tuning stored procedures and T-SQL queries.
- Knowledge of Informatica installation and creating workflows mappings and sessions.
- Migrated Data from MS Access, MS Excel, DB2 to SQL Server 2005/2008 by using SQL Server Integration Services (SSIS).
- Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.
- Experience in SQL Enterprises Manager and SSMS - creating and scheduling jobs, alert and operators with SQL Server Agent, SQL Profiler, restoring database.
- Hands on experience on SQL Server, Reporting Services and Integration Services to manage data ware house environment.
TECHNICAL SKILLS
SQL Server Tools: Enterprise Manager, SQL Profiler, Query Analyzer, Export & Import, DTS, Replication, BIMS.
Data warehouse Tools: SSIS, SSRS, Informatica 9.0, Wherescape RED
Database: MS SQL Server 2008,2005, 2000, 7.0, MS-Access 97/2000/2003/2007 , Teradata 13.10
Operating System: Windows 95/98/NT/2000, Unix, DOS, Windows Server 2003
IDE Tools: Microsoft Visual Studio 2003/2005, Visual Basic 6.0
Architecture: Relational DBMS, Client-Server Architecture, OLAP, OLTP
Web Servers: IIS
PROFESSIONAL EXPERIENCE
Confidential, MIAMI, FL
ETL Developer (SSIS,RED,INFORMATICA)
Responsibilities:
- Created workflows in Informatica to extract the data from the tables into RLZ in Teradata
- Used INFORMATICA (Power Center) tool as ETL tool for constantly moving the data from sources into staging area.
- Developed Informatica Mappings, lookups, reusable components, Sessions, Work Flows etc. (on ETL side) as per the design documents/communication.
- Monitoring the identified ETL processes, restarting the ETL processes that aborted.
- Created Sources and Targets in Teradata and loaded the data from the sources.
- Created 200 mapping for moving the data from different sources into Teradata database as per the requirements of the DataVault methodilogy RLZ,DV,DM
- Created worklets in Informatica to load data into the targets depending on their functionality.
- Worked on process to extract the files from the FTP every Thursday .
- Created the RLZ to load files into the landing zone and move them to permanent load tables.
- Created Views in Teradata to source data from delta files feeding the DataVault objects.
- Created the DataVault objects and DataMart objects in Terdata and used RED, Informatica to move data across .
- Scheduled the RED jobs to run daily and setup email alerts
- Used WhereScape RED to extract the files from the shared location to Teradata RLZ
- Created the RLZ to load files into the landing zone and move them to permanent load tables.
- Worked on a process for data cleansing for missing values and incorrect formats.
- Created Views in Teradata to source data from delta files feeding the DataVault objects.
- Created the DataVault objects and DataMart objects in Terdata and used RED, Informatica to move data across .
- Scheduled the RED jobs to run daily and setup email alerts .
- Used the previously build Pamlico framework to extract the files from FTP
- Created the RLZ(Relational Landing Zone) in Teradata to load the files into delta tables
- Created permanent load tables in Teradata using RED
- Created data source views on the delta load files and in Teradata
- Followed the DataVault methodology created Hub’s,Satellite’s,Slnk’s,SlnkSAT’s
- Created the DataMart objects sourcing from the DataVault
- Scheduled the process using the RED scheduler .
- Supported the Microstrategy reporting team.
- Worked on a SSIS package to extract the store and ownership details from SQL Server into a flatfile.
- Encrypted the file with a password and placed the file on a FTP site
- Scheduled the package to place the file with current date with name on the FTP
- Worked on SSIS package to exact the files and load them into the loadtables.
- Created lookup tables to translate the values to current system
- Worked on SSIS packages to load the Dimension and then updated the Fact tables
- Created SSIS package to extract the data from the Environment and load it into the stg area
- Decrypted and encrypted the pins using IPC approved tool and loaded the data into targets
- Scheduled the package to run daily incremental loads
- Coordinated with the reporting teams to generate reports
Confidential, MIAMI, FL
ETL Developer (SSIS,SSRS)
Responsibilities:
- Design and develop SSIS packages, store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance.
- Worked with the teams in organization on SSIS development, data warehouse development, and ETL development best practices.
- Build efficient SSIS packages for processing fact and dimension tables with complex transforms and type 1 and type 2 changes.
- Implemented ETL process using SSIS
- Created system for capturing, reporting, and correcting error data.
- Work with developers, DBAs, and systems support personnel in elevating and automating successful code to production.
- Provide on-call support to production system to resolve any issues.
- Gather requirements and design of data warehouse and data mart entities.
Environment: MS SQL Server 2005/2008 R2, SSIS, SSRS, Windows XP, Management Studio, BIDSBIXpress, TFS.
Confidential, JAX, FL
SQL Server Developer/DBA
Responsibilities:
- Participated in gathering the business requirements and specifications.
- Interacted directly with various business users as a part of team involved in requirements collection and analysis.
- Create a new lookup or translation table to map products from Genelco and Bensel.
- Created complex stored procedures to have a drill down Audit, with coverage level product level, date level.
- Mapped different naming conventions in Genelco to Bensel.
- Extracted data from different sources like Flat files implemented business logic and loaded into the target Genelco Enrollments table.
- Extracted data according to specification and created a new table to house Bensel Enrollments.
- Created complex T-SQL Queries, Stored Procedures and Functions to support Audit.
- Developed several 2005 SQL Reporting Services, with Visual Studio and supporting Stored Procedures.
- Develop SSIS Packages to transform data from excel/Access file to SQL Server database.
- Defined report layouts including report parameters.
- Created parameterized, drill down in MS SQL environment using SSRS 2005/2008.
- Participated in gathering the business requirements and specifications.
- Interacted directly with various business users as a part of team involved in requirements collection and analysis.
- Create a new lookup or translation table to map products from Life70 and Bensel.
- Extracted data according to specification and created a new table to house Bensel Enrollments.
- Created complex T-SQL Queries, Stored Procedures and Functions to support Audit.
- Developed several 2005 SQL Reporting Services, with Visual Studio and supporting Stored Procedures.
- Develop SSIS Packages to transform data from excel/Access file to SQL Server database.
- Defined report layouts including report parameters.
- Created parameterized, drill down, conditional and aggregation reports in MS SQL environment using SSRS 2005.
- Interacted directly with various clients as a part of team involved in requirements collection and analysis.
- Extracted data from different sources like SQL Server and Flat files implemented business logic and loaded into the target Warehouse
- Participated in gathering the business requirements and specifications.
- Interacted directly with various teams involved in requirements collection and analysis
- Created a table to hold all the distinct transactions that have been processed
- Created complex T-SQL Queries, Stored Procedures and Functions to support Audit
- Defined report layouts including report parameters.
- Created parameterized, drill down, drill through sub reports, conditional and aggregation reports in MS SQL environment using SSRS 2005/2008.
- Worked on change controls to move the project through various environments.
- Worked with the Business Analyst to gathering specifications.
- Created complex T-SQL Queries, Stored Procedures to support the report.
- Defined report layouts including report parameter
Environment: MS SQL Server 2005, SSIS, SSRS, Windows XP, Management Studio, BIDS.
Confidential, Jersey City, NJ
SQL Server Developer
Responsibilities:
- Implemented a well-planned backup and restore strategy that protects databases against data loss.
- Involved in complete SDLC, which includes requirement gathering, analysis, design, development, Implementation.
- Created several databases in various Development and Test server by using SQL Server 2005.
- Created several tables, views using SQL Server 2005 Management Studio. These tables, views are created based upon the functional specifications.
- Wrote DTSX packages to transfer data from heterogeneous database & different files format (Text File, Spread Sheet) to SQL Server.
- Involved in understanding and analysis of state report requirements in Trizetto FACETS
- Have developed subscription based reports and created subscriptions and schedules using the Report Manager.
- Developed reports using Crystal reports.
- Responsible for installation, configuration, security, maintenance, restoration of SSRS on Windows Server 2003.
- Created designed and deployed drill down, drill through, parameterized and sub reports in financial domain of MetLife bank using MS SQL Server Reporting services.
- Development of Business rules implemented as Constraints, Triggers and Stored Procedures.
- Replicated the billing data and adjudicated the claims in Facets.
- Working knowledge in general healthcare section with exposure to Trizetto FACETS 4.31 Membership,Provider,Claims,Workflow,CSR of the product
- Created, Tested and has implemented SSRS packages for Reporting Services (SSRS 2005).
- Experience with SQL Server Reporting Services to author, manage, and deliver both paper-based and interactive Web-based reports.
- Generated ad hoc reports using MS Reporting services and Crystal reports.
- Strong experience in MS SQL Server 2005 with Business Intelligence in SQL Server Reporting Services.
- Worked with FACETS in generating dataset for the reports in Billing and CSR section.
- Develop SSIS Packages to transform data from excel/Access file to SQL Server database.
- Working very closely with other developers for their SQL requirements, worked with Business Analyst and end users to understand the report requirements.
- Developed and implemented strategies for improving and further leveraging these reports in order to transfer / convert existing reports to SQL Server Reporting Service.
- Created and executed several SSIS packages to perform operations like extraction of the data from source server to destinations server and OLTP to OLAP.
- Created several stored procedures, triggers, and views and wrote complex T-SQL queries for database development and Report generation.
Environment: MS SQL Server 2005 Enterprise Edition, T-SQL, ODBC, Excel, SSAS, SSIS Packages, SSRS, SQL Profiler, Windows 2003 Server, MS SQL Server 2005, MS SQL Server Reporting Services 2005, SSIS.
Confidential, Rockville, MD
MS SQL Server Developer
Responsibilities:
- Requirement analysis and Capacity Planning for database.
- Designing, maintenance, updating of application schema structure / data models.
- Creation and Execution of TSQL Scripts (Stored Procedures, Triggers and complex queries) in SQL Server 2005 database.
- Development of SSIS packages such as extraction of data to different servers.
- Performance tuning of SQL Server database procedures and networks.
- Handling Installation and creation of new Instances of SQL server databases.
- Backup, Restoration and Recovery in different scenario.
- Managing User Creations, assigning Roles to SQL Databases.
- Extensively involved in maintaining & updating the database documentation.
Environment: SQL Server 2005, SQL Server Management Studio, Query Analyzer, SQL Profiler.
Confidential
SQL Server Database Administrator/ Developer
Responsibilities:
- Installation and configuration of SQL Server 2000 on Window 2000/NT OS.
- Managing of database objects like Tables, views, indexes etc.
- Managing of users including creation/alteration, grant of system/db roles and permission on various database objects.
- Managing Backup and restore, export and import.
- Developed DTS Packages to transfer the data between SQL Server and other database and files.
- Well experienced with tools like Query Analyzer, SQL utility.
- Creation and management of Database maintenance plan for various database consistency checks.
- Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.
- Automation and execution of data transformation scripts.
- Developed Transact-SQL scripts to enforce business rules.
Environment: MS SQL Server 2000, Windows 2000, MS Access, T-SQL, DTS, VB 6.0.