SUMMARY

• Over 7 years of ETL developer/SQL Developer experience in Data warehousing environment/projects, high transaction and multi - server production environment, current experience with SQL 2012/2008.
• Forward-thinking problem identification, research, analysis, and resolution. Spearheads full life-cycle project development and innovatively manages quality assurance. Consistently delivers strong and sustainable technology gains. Organizational driver offering productivity improvements, and process redesign and reengineering.
• Strong knowledge in Agile Methodology.
• Knowledge in Relational Database Systems and SQL
• Expert Knowledge of Integration Services (SSIS), Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using SSIS services.
• Strong knowledge on ETL Abinitio and BI processes.
• UNIX/Linux including shell scripting
• Experience in Analysing Execution Plan and managing indexes and troubleshooting deadlocks.
• Strong in STLC process and Test management tools - HP ALM/QC, Rational Clear Quest .
• Proficient in converting User Requirements into Business Requirement Documents (BRD) and Functional Requirement Specifications (FRS).
• Test & Defect Management tool.
• Worked on ETL testing tool.
• Knowledge of ETL/ODS ETL concepts including ETL solutions including ADT, Metadata Management and Data Transformation.
• Good knowledge in using system tables such as sysindexes, sysprocesses, sysobjects and syscomment in various queries and using Database Console Commands (DBCC).
• Experience in using Data Modeling Tools like Oracle SQL developer, Data modeller, Toad Data Modeller. Experience in developing UML diagrams including Use Case diagrams, Class diagrams, Interaction diagrams, State diagrams and Deployment diagrams.
• Worked on Oracle/SQL Server for troubleshooting database related issues
• Exposure to Automating DW systems/Big Data environment using ETL technologies.SQL Server Services (DTS, SSIS, SSRS)
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
• SQL Server 2012/2008 RDBMS database development including SQL programming/commands
• ETL implementation using SQL Server Integration Services (SSIS)
• Developing reports on SSAS & SSRS on SQL Server (2012/2008). Sound Experience and understanding of SSAS, OLAP cube and Architecture
• Experience in creating Pipeline Custom Component such as Error handling to get error description of failure.
• Experience in enhancing and deploying the SSIS Packages from development server to production server.
• Created stored procedure for generating reports using SQL Server Reporting Services (SSRS).
• Worked on OLAP Data warehouse, Model, Design, Implementation
• Experience in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS)Stored Procedure, Functions, Views, Joins and Cursors
• Excellent knowledge in creating Databases, Tables, Stored Procedure, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using SQL.
• Experience in using SQL commands in Oracle 11g (Express edition).
• Implemented complex business logic into database design and maintained the referential integrity via triggers and constraints.
• Experience in writing complex ETL SQL queries using Inner, Outer, Merge and Cross Joins.
• Experience in using Try Catch block introduced in SQL Server 2012/2008.
• Experience in using Transactions blocks in SQL Server 2012/2008.Query Optimization and Tuning
• Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
• Experience in Creating and Updating Statistics to improve the SQL Server Performance.
• Experience in Analyzing Execution Plan and managing indexes and troubleshooting deadlocks.
• Good knowledge in using system tables such as sysindexes, sysprocesses, sysobjects and syscomment in various queries and using Database Console Commands (DBCC).
• Good Knowledge in managing Data and Transaction log files, Files Groups.
• Experience in using profilers, Index Tuning Wizard and performance monitor to monitor SQL ServerDatabase Design and Implementation
• Experience in using Data Modeling Tools like Oracle SQL developer, Data modeller, Toad Data Modeller.
• Good knowledge in Normalizing and De-normalizing the tables and maintaining Referential Integrity by using Triggers and Primary and Foreign Keys.
• Knowledge in ERD Diagrams and linkage system.
• Good knowledge of System Development Life Cycle (SDLC).
• Good in implementing SQL Server Security and Process Control.
• Experience in Creating Roles and Assigning Permissions to the users.
• Good knowledge in SQL Server 2012/2008 Client Server Architecture.

TECHNICAL SKILLS

ETL Tools: ETL Tool (Abinitio 3.15), Reporting and querying software, OLAP, Data Mining and Data warehousing,Open Source (Palo).

Operating Systems: UNIX, Windows 10/XP .

Database: Oracle 10i /11g, SQL*Plus, PL/SQL.

Domain: ETL/Datawarehouse

Methodologies: - Agile, SDLC, Waterfall, Scrum.

Other Utilities: Clear Case, Quality Center, CVS, Sharepoint and Spreadsheets.

PROFESSIONAL EXPERIENCE

Confidential, Dallas TX

Sr ETL/Data warehouse Analyst

Roles and Responsibilities-

• Principle responsibility is to handle multiple applications and schedule meetings for review of all the task assigned to developers
• Analyzed, Designed and developed the core modules.
• Interacted with users to gather the business requirements.
• Initiating, monitoring & controlling of automation, integration & normalization projects
• Maintained and enhanced several Console, Windows and Web Forms Applications.
• Gathering functional requirements & translating into technical specifications
• Designed Enrollment process, Payment Details, Account Activity, Linking Multiple student functionality.
• Responsible for performance tuning, and optimization of procedures and queries.
• Developed a cross- platform activity feed client for the social software product.
• Organized and held meetings with stakeholders, contractor product teams and customers.
• Resolved customer issues by establishing workarounds and solutions and by debugging and creating defect fixes.
• Drafted detailed design objectives and developed architectural and system design documents.
• Tested on various tools and Exposure to End-to-End data validation for ETL & BI systems .
• Communicated with back- end servers to provide real- time updated information.
• Involved in system design and for creating database Schemas.
• Creating complex Stored Procedures, triggers, tables, views and other SQL joins and statements for applications by using SQL.
• Extensively use SQL in constructing user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
• Create SSIS packages with error handling.
• Creating complex SSIS packages using proper control and data flow elements.
• Deploying packages on different servers by configuring it.
• Creating SQL scripts, dynamic SQL, complex stored procedures, functions, triggers.
• Created Packages and Procedures to automatically drop table indexes and create indexes for the tables.
• Worked extensively on Ref Cursor, External Tables and Collections.
• Expertise in Dynamic SQL, Collections and Exception handling.
• Experience in SQL performance tuning using Cost-Based Optimization (CBO).
• Good knowledge of key SQL performance related features such as Query Optimizer, Execution Plans and Indexes.
• Experience with Performance Tuning for SQL RDBMS.
• XML schemas, mapping and transforming using XML framework and tools like XSLT, XSD and W3C standards.
• Worked on data warehouse ETL, ODS ETL, Data transformation having techical knowledge.
• Implement Complex business logic with User-Defined-Functions, Index Views and also create User Defined Data type, Clustered & Non-clustered Indexes.
• Create several batch files for scheduling the SSIS packages through ESP Scheduler.
• Collaborated with other team members on special projects and events.

Environment: SQL Server 2012/2008/, Windows XP and Oracle 11 g XE.

Confidential, Foster city, CA

Sr ETL/Data warehouse Developer

Roles and Responsibilities

• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Analysed, Designed and developed the core modules.
• Interacted with users to gather the business requirements.
• Deployed SSIS packages and Reports to Production Servers.
• Migrated data using ETL Tool in SSIS.
• Created partition table for very large database for good performance.
• Worked on Migration of packages from DTS using SQL Server Reporting Service (SSIS).
• Participated Databases Architecture and data modeling design.
• Responsible for writing SQL queries, stored procedures, views, triggers, SQL and DTS/SSIS
• Analysed HP Quality Centre and create release name, release cycle and assign to test script folder.
• XML schemas, mapping and transforming using XML framework and tools like XSLT, XSD and W3C standards.
• Discuss requirement with business analyst and testing manager to create report.

Environment: SQL Server 2012/2008/, Windows XP and Oracle 9i/10g.

Confidential, Foster city, CA

SSIS/Sr ETL Developer

Roles and Responsibilities

• Principle responsibility is to implement support, maintain, monitor and tune high available and clustered database systems.
• Responsible for performance tuning, and optimization of procedures and queries.
• Made various Data Flow and Control Flow objects for the report linking with several Stored procedures, Views and Functions
• Created Stored Procedures/Functions/Triggers/Views in SQL Server using SQL.
• Worked on Performance related Issues in SQL Server database
• Used CSS classes/skins for client side control UI formatting and provide same look and feel throughout the application.
• Console applications related to sending daily reports to the client attaching the transaction details of the users.
• Analyzed, Designed and developed the core modules.
• Creating complex Stored Procedures, triggers, tables, views and other SQL joins and statements for applications by using SQL.
• Extensively use SQL in constructing user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
• Create SSIS packages with error handling.
• Creating complex SSIS packages using proper control and data flow elements.
• Deploying packages on different servers by configuring it.
• SSRS Development on a daily basis working on the control and data flows as per the requirements mentioned in specific documents assigned.
• Create several web pages and integrate the SSIS, SQL or OLEDB connections as per the requirement.
• Contribute to the test and production environment of the project after the completion of the development work assigned.
• Create several batch files for scheduling the SSIS packages through ESP Scheduler.
• Collaborated with other team members on special projects and events.

Environment: SQL Server 2012/2008/, Windows XP and Oracle 10g.

Confidential, Foster city, CA

Sr. ETL Analyst

Roles and Responsiblities

• Analysis of SDLC Scope and high-Level Business Requirements document.
• Discussed requirement for each asset types from business analyst.
• Involved in requirement gathering, analysis, design, development, change management,
• Involved in conversion of business requirements into functional requirement.
• Developed source to target specifications.
• Created table scripts, scalar valued functions, stored procedure in SQL server Database
• Tested data modules on various ETL testing tool like quest tool,HP, tracking defect and resolving them .
• Successfully extracted transformed and load data into data warehouse.
• Tested the data with complex queries, joins and sub queries.
• Deployed the SSIS Packages from development server to production server.
• Documentation for all kind of stored procedure, scalar valued function and SSIS packages.
• Responsible for the systems study, analysis, systems design and database design, ER modelling, coding, testing, implementation and documentation.
• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
• Developed ER Diagrams

Environment: Environment: SQL Server 2012/2008/, Windows XP and Oracle 9i/10g.

Confidential, Foster city, CA

SQL Developer/Software Engineer

Responsibilities

• Developed and implemented SSIS ETL development standards and requirements.
• Analysed project business document and discuss requirement with manager.
• Created pipeline custom component such as Error handling to get error description of failure.
• Created custom logging component to get logging info at task level.
• Instrumented and modified unit and integration tests to improve software quality and reliability
• Developed and maintained accurate network documentation and Visio diagrams to provide management with proper understanding of organizational needs.
• Expertise in Dynamic SQL, Collections and Exception handling.
• Good knowledge of key SQL performance related features such as Query Optimizer, Execution Plans and Indexes.
• Executed and monitored standards for user interfaces, page design and graphics development.
• Developed web- site mock- ups for clients to ensure quality control and client satisfaction before project development phase.
• Auditing stored procedures for optimization and improving the performance tuning.
• Involved in extensive testing and debugging of all the modules coded.
• Expert in writing SQL code to avoid data flow components such as merge join, data conversion, aggregate transformation.
• Deployed SSIS packages from dev environment to testing environment using xml package configuration file.
• Expert in debugging SSIS packages using data viewer and break point.
• Traced user variables and system variables while running SSIS packages.
• Address any issues reported in conversion program testing and provide solutions in a timely manner.
• Used Cache transformation to cache lookup excel data and used in look up transformation.
• Worked on the architectural of ETL solutions.
• Created SSIS packages using data flow transformation such as derived column, conditional split, multicast, lookup, data conversion, Oledb command, union all etc.
• Expert in using control flow component while creating SSIS packages such as for each loop, execute SQL task, script task, sequence container, file system task etc.

Environment: SQL Server 2012/2008/, Windows XP and Oracle 11 g XE.