SUMMARY

• Around 6 plus years IT experience in Database Development, Administration, Data Analysis, System Analysis, Design, Development and Support of MS SQL Server 2008, 2005, 2000 in Production, Testing and Development.
• Experience with software development life cycle (SDLC), Agile / Scrum and Project Management Methodologies. Extensively involved through the Software Development Life Cycle (SDLC) from initial planning through implementation of the projects. Capable of handling responsibilities independently as well as a proactive team member.
• Experience in coordinating with users in gathering source data files, defining data elements, business rules, data and process flow documentation, prepare High level and Low - level design documents.
• Experience in Database Backup, Recovery and Disaster Recovery procedures.
• Knowledge of Relational Database Management systems.
• Experienced in creating and using Stored Procedures, Triggers, Views, User Defined Functions, Sub - Queries and Joins for complex queries involving multiple tables and exception handlers.
• Expert in designing ETL data flows using creating mappings/workflows to extract data from SQL Server and Data Migration and Transformation from Oracle/Access/Excel Sheets using SQL Server SSIS.
• Expert in developing SSIS packages. Experience in DTS Migration and Metadata Management: Migrating DTS packages to Package Migration Wizard, and Storage Management.
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks.
• Having experience on Database administration like creating the roles, users and giving the permissions for the database, tables, functions etc.
• Expertise in developing Parameterized, Chart, Graph, Linked, Dashboard, Scorecards, Drill-down, Drill-through and Cascading reports using SSRS.
• Can-Do, Will-Do Attitude, Problem solving, Self-directed, Ability to learn new tools and use them.
• Experience in Object Oriented Analysis concept implementation, design and programming technical skills.

TECHNICAL SKILLS

Database Tools: Management Studio, ER-Win, MS Visio

RDBMS: MS SQL 2005/2008/2008 R2/2012, Oracle 9i, 10g, 11gMySQL, Snowflake

Business Intelligence: BIDS/SSDT, SSIS, SSAS, SSRS, SharePoint 2010, 2013, Tableau, ProClarity

Operating Systems: Windows Server 2003/2008/R2, 7/8

PROFESSIONAL EXPERIENCE

Confidential, LOS ANGELES, CA

Data Engineer/ BI Developer

Responsibilities:

• Worked on Snow SQL and Snowpipe
• Converted Talend Joblets to support the snowflake functionality.
• Created Snowpipe for continuous data load.
• Created data sharing between two snowflake accounts.
• Created internal and external stage and transformed data during load.
• Redesigned the Views in snowflake to increase the performance.
• Unit tested the data between Redshift and Snowflake.
• Developed data warehouse model in snowflake for over 100 datasets using whereScape.
• Creating Reports in Looker based on Snowflake Connections
• Experience in working with AWS, Azure and Google data services
• Validation of Looker report with Redshift database.
• Good working knowledge of any ETL tool (Informatica or SSIS).
• Created Talend Mappings to populate the data into dimensions and fact tables.
• Wrote ETL jobs to read from web APIs using REST and HTTP calls and loaded into HDFS using java and Talend.
• Used Talend big data components like Hadoop and S3 Buckets and AWS Services for redshift.
• Validating the data from SQL Server to Snowflake to make sure it has Apple to Apple match.
• Consulting on Snowflake Data Platform Solution Architecture, Design, Development and deployment focused to bring the data driven culture across the enterprises
• Building solutions once for all with no band-aid approach.
• Implemented Change Data Capture technology in Talend in order to load deltas to a Data Warehouse.
• Develop stored procedures/views in Snowflake and use in Talend for loading Dimensions and Facts.
• Design, develop, test, implement and support of Data Warehousing ETL using Talend.
• Very good knowledge of RDBMS topics, ability to write complex SQL, PL/SQL

Environment: Snowflake, MS SQL Server 2008 R2/2012, Teradata, SSIS, SSAS, SSRS, Informatica, AWS, Erwin, Excel, Windows server, SharePoint 2010/2013, Power Pivot, TFS, ProClarity, Active Batch, DAT.

Confidential, Atlanta, GA

SQL Server\ETL Developer

Responsibilities:

• Created SSIS Packages for Incremental loading and slowly changing dimensions.
• Created SSIS Packages to import and export data from Excel Spreadsheets, People Soft, Text files, CSV files and various direct sources.
• Created logging, custom logging and error handling packages.
• Created and scheduled SQL jobs to run SSIS packages on a daily basis.
• Experience in creating complex SSIS packages using appropriate control and data flow elements with SSIS Standards like error handling, logging and working with package config files.
• Created DTS (SSIS) packages to get data from various sources (mainframe, Informix, Oracle).
• Used ETL (Extraction, Transformation, Loading) from heterogenous source systems. Assisted DBA in using the repository manager to give permissions to users to create new users and repositories.
• Developed Stored Procedures and Views to be used to supply the Data to the Reports. Complex formulas were used to show derived fields and to format the data based on specific conditions.
• Maintenance and provide support to the users for the deployed reports.
• Developed Query for generating drill down reports in SSRS 2005/2008.
• Created subscription to reports.
• Analyze, tuning and optimizing for SQL Server Applications by using performance monitor.
• Expertise includes Data Analysis, Data Modeling, Data Cleansing, Transformation, Integration, Data import, Data export.
• Publishing PDF Reports obtained from Report Server on to SharePoint Portal.
• Created Parameterized Queries, generated Tabular reports, Sub reports, Cross Tabs, Drill down reports using Expressions, Functions, Charts, Maps, Sorting the data, Defining Data sources and Subtotals for the reports.
• Developed SSIS packages for different tasks like data cleansing and standardizing, sorting, conditional split, back up and involved in scheduling of SSIS packages.
• Involved in Data Extraction, Transformation and Loading (ETL) between Homogenous and Heterogeneous systems using SQL tools (SSIS, Bulk Insert).
• Improved performance by adding indexes, removing unnecessary columns in the inner views and adding conditions to get only required data.
• Identified slow performing views, stored procedures and queries using SQL Profiler, by running simultaneously while browsing the application.
• Developed User defined functions, stored procedures, indexes, Triggers.
• Created Database objects including Tables, Views, Stored Procedures and UDF.

Environment: MS SQL Server 2008 R2/2012, SSIS, SSAS, SSRS, Erwin, Excel, Windows server, SharePoint 2010, Power Pivot, TFS.

Confidential | Carson, CA

ETL/SQL Developer

Responsibilities:

• Drive stability, reliability, and performance by optimizing in-application SQL statements and design user- focused databases.
• Develop an ETL Database Model to carry out new procedures and create various database warehouse dimensions to accept ETL outputs.
• Designed and developed ETL solutions from Teradata tools.
• Formulated and executed application development procedures.
• Prepared and maintained unit test cases and plans.
• Installed and managed ETL modules in adherence to design specifications.
• Tested and managed ETL workflows for XML and Teradata sources.
• Created and updated plans for ETL mappings and database application code.
• Analyzed ETL workflows for ensuring process performance.
• Gather requirements from business analysts, develop physical data models using Erwin, and create DDL scripts to design database schema and database objects.
• Perform database defragmentation and optimize SQL queries, improving database performance and loading speed by 70%.
• Lead the development of 12 database projects for one of the company’s largest clients with on-time delivery and 13% under budget completion.
• Writing Triggers, Stored Procedures, Functions, define User Defined Data Types, TSQL, and Create and maintain physical structures.
• Create / Manage Table Indexes, Query Tuning, Performance Tuning, Deadlock Management.
• Design and Deploy SSIS Packages.
• Creating SSIS Packages, Configure SSIS packages for different environments using DTS Config.
• Extract-Transform-Load data into SQL Server 2008 Normalized database from various sources.
• Day to Day maintenance of databases, Staging, Backup / Restores of databases.
• Query Tuning, Performance Tuning.
• Involved in complete Software Development Lifecycle (SDLC).
• Wrote complex SQL Queries, Stored Procedure, Triggers, Views & Indexes using DML, DDL commands and user defined functions to implement the business logic.
• Wrote T-SQL Queries and procedures to generate DML Scripts that modified database objects dynamically based on inputs.
• Reviewed, analyzed and implemented necessary changes in appropriate areas to enhance and improve existing systems.

Environment: MS SQL Server 2008 R2, SSIS, SSAS, SSRS, Erwin, Excel, Windows server, Flat Files, SharePoint 2010, Teradata Foundation Server (TFS)