SUMMARY:

• 7+ years of IT experience with extensive expertise in SQL Server technologies like MS SQL Server suite of products like SSRS, SSAS and SSIS including development, deployment, testing and support.
• Experience with software development life cycle (SDLC) and Project Management Methodologies.
• Experience in SQL Server Programming, Analysis Services and Reporting services
• Hands on Experience in Installing, Configuring, Managing, Monitoring and Troubleshooting SQLServer
• Experience in Data Warehouse Development environment using Microsoft DTS, SSIS and SSRS.
• Using Tableau server as a front - end BI tool and Microsoft SQL Server as a back end database designed and developed workbooks, dashboards, global filter page, and complex parameters based calculations.
• Experience in Database Development and Release Management Concepts, Practices and Procedures along with Performance Tuning Database Code in OLTP and OLAP environments.
• Experience in data Extraction, Transformation and Loading (ETL) processes using SSIS, DTS Import/Export Data, Bulk Insert, BCP and DTS Packages.
• Experience in logical design of database using ERWIN. Experience in mapping data into database objects.
• Experience in Dimensional Modeling, Designing of STAR, SNOW FLAKE Schemas. Experience in migrating data from MS-Access, MS-EXCEL and other external data sources.
• Experience in Creation and deployment of cubes on SSAS. Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQLServer Performance.
• Excellent knowledge in creating Databases, Tables, Stored Procedure, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using T-SQL.
• Experience in Analyzing Execution Plan and managing indexes and troubleshooting deadlocks.
• Experience in Tuning SQL queries and T-SQL queries, MDX & improving the performance of the queries.
• Very strong Transact-SQL Development Skills which includes creating Complex Business Stored Procedures, Tables, Cursors, Views, Indexes, Triggers and Functions.

PROFESSIONAL EXPERIENCE:

Confidential, San Diego, CA

SQL Server Developer

Responsibilities:

• Worked as SQL Developer with extensive use of analytical techniques. Wrote SQL queries and optimizing the queries in SQL Server 2012.
• Worked on RDBMS concepts, Views, Triggers, Stored Procedures, Indexes and Constraints.
• Performed data analysis and data profiling using SQL on various sources systems including SQLServer 2012. Produced tables, reports, graphs and listings using various procedures.
• Handled large database to perform data manipulations. Developed SSIS Templates which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Dev, Test and Production Environments. Extracted the data using SSIS from OLTP to OLAP.
• Executed data validation stored procedures in SSIS packages in Business Intelligence Development Studio (BIDS).
• Deployed and Administered SSIS packages with Business Intelligence development studio.
• Developed, monitored and deployed SSIS packages. Participated in System Study analysis for logical/physical data model there by defining strategy for implementing Star Schema with Fact and Dimension tables.
• Automated backup processes using SQL Server jobs. Supported Application Development team with any database issues, updates or new releases.
• Supported deadlock issues, best practices in structuring SQL Queries and debugged unexpected SQL results.
• Developed SSIS Templates which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Dev, Test and Production Environments.
• Extracted the data using SSIS from OLTP to OLAP. Executed data validation stored procedures in SSIS packages in Business Intelligence Development Studio (BIDS).
• Deployed and Administered SSIS packages with Business Intelligence development studio.
• Developed, monitored and deployed SSIS packages. Participated in System Study analysis for logical/physical data model there by defining strategy for implementing Star Schema with Fact and Dimension tables.

Environment: SQL Server 2012, SQL Developer, SQL.

Sr. Data stage Developer

Responsibilities:

• Supported and maintained Order Management System in the Walmart.com website.
• Generating daily reports on the system performance to make sure everything is running smooth.
• Worked with both Front end and Back end development to better understand the system which helps in building efficiently as per the requirement.
• Loaded the data into database tables using SQL*loader from text and excel files. Developed data model, SQL Queries, SQL Query tuning process and Schemas.
• Tuned Performance, which included creating indexes, providing Hints, modifying tables, analyze tables and estimate stats using explain plan utility.
• Designed ER diagram using Erwin, to set the logical and physical relationships of database. Participated in walkthrough sessions with business users during Analysis and Designing phase.
• Wrote PL/SQL Stored Procedures, Functions, and Packages to meet the business requirements.
• Created database objects like tables, views, procedures, packages using Oracle tools like SQL* Plus, PL/SQL and TOAD.
• Wrote complex SQL queries including inline queries and sub queries for faster data retrieval from multiple tables.
• Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables.
• Worked with Bulk Collects to improve the performance of multi-row queries by reducing the context switching. Worked in Agile development methodology environment

Environment: Oracle 11g, PL/SQL, PL/SQL Developer, TOAD, SQL Loader, SQL*Plus, Windows 8, Microsoft SQL Server 2008

Data stage Developer

Responsibilities:

• Actively participated in interaction with users, team lead, and DBA’s and technical manager to fully understand the requirements of the system.
• Performed data migration from SQL Server 2005 to SQL Server 2008. Implemented Functions, views, triggers and stored procedures and enforced business rules via checks and constraints.
• Created reports for tax ids and making sure the fee schedules are implemented correctly.
• Created reports for the provider and vendor data and making sure the fee schedules were processed correctly.
• Performed data conversion from flat file into a normalized database structure. Created Triggers to enforce data and referential integrity.
• Create new SSIS package to extract date from legacy to SQL Server Objects using Business Intelligence Development Studio (BIDS) and Visual studio 2008.
• Defined Check constraints, Business Rules, Indexes, and Views. Generated reports using SSRS, Excel (Pivot) that could be used to send information to diverse group of users, clients, and managers.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Created reports basing on the requirements using SSRS 2008. Migrated data (import & export -BCP) from Text to SQL server.
• Designed SQL SSIS Packages in Business Intelligence Development Studio (BIDS), to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQLServer 2008, 2005 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks in Visual Studio 2008.
• Scheduled jobs and inserted notes in the claims. Worked on back up of master and system databases and restored them when necessary and automated backup processes using SQL Server jobs.
• Supported Application Development team with any database issues, updates or new releases.
• Supported deadlock issues, best practices in structuring SQL Queries and debugged unexpected SQL results.

Environment: SQL Server 2008/2005, SSIS, SSRS, Visual studio 2008, MS Visio 2007, XML, VB.Net.

Confidential, Rogers, AR

Data Stage/ETL Developer

Responsibilities:

• Participated in the identification, understanding, and documentation of business requirements, keeping in mind the need for the application based on the project scope and SDLC methodology.
• Worked with development managers to translate the business requirements into functional requirements (FRD) and non-functional requirements.
• Created use case scenarios and documented work flow & business processes. Communicated regularly with both IT and non IT teams to build ensure knowledge transfer between cross-functional teams.
• Documented all data mapping and transformation processes in the Functional Design documents based on the business requirements
• Validated the data integrity of the data loads and used data modeling tools to create the reporting databases
• Extensively involved in Data Extraction, Transformation and Loading (ETL process) from Source to target systems
• Worked on daily basis with lead Data Warehouse developers to evaluate impact on current implementation, redesign of all ETL logic.
• Configured Script Task and Send Mail task in SSIS. Designed and implemented report layouts according to reporting standards of the department.
• Created different datasets for reporting the data through SSRS. Worked on exporting reports in multiple formats including MS Word, Excel, CSV and PDF. Made report available for scheduling or viewing on demand.

Environment: SQL Server 2008, SSIS, SSRS, Rational Rose, Rational Requisite Pro, Data Warehousing, Clear Quest, MS-Office