SUMMARY

• 7+ years of experience as MS SQL Developer in administration and development of Database Design and Development in SQL Server system in OLTP and OLAP environment.
• Excellent experience in SSIS, SSAS and SSRS of MS SQL Server.
• Highly expert in translating Business System Design document into technical design document
• Experience in installation, upgrade and configuration of Microsoft SQL Server and databases.
• Expertise in solving any issues related SharePoint Environment and SQL server
• In - depth noledge of T-SQL, Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using T-SQL.
• Proficient in writing complex T-SQL queries using Inner, Left, Right, Outer and Cross Joins.
• Experience with administration of search engines and relevancy tuning- Thorough understanding of search features in FAST Search for SharePoint 2010.
• Hands on Experience in Installing, Configuring, Managing, monitoring and troubleshooting SQL Server.
• Experience in scheduling SSIS packages using SQL Server Agent.
• Strong noledge of using variables and expressions in packages.
• Experience in enhancing and deploying teh SSIS Packages from development server to production server.
• Excellent skills in implementing ETL Packages using DTS and SSIS
• Proficient in implementing all transformations available on teh SSIS toolbox.
• Expert in resolving teh performance issue of SSIS packages.
• Experience in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SQL tools (SSIS, DTS, Bulk Insert, and XML).
• Well versed in Importing/Exporting Data from various data sources like Excel, Oracle, DB2 and Flat file using BCP, Bulk Insert & DTS utility.
• Strong experiences to Design, deploy, and maintain various SSRS Reports in SQL Server 2012.
• Developed Sites, Team Sites, Views, Alerts and Lists in SharePoint 2010.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2012.
• Extensive experience in report writing using SQL Server Reporting Services like Tabular report, Matrix report, Chart report, Pie Charts and column report.
• Effective communication & interpersonal skills with teh ability to focus on multiple tasks in high pressure envt.

TECHNICAL SKILLS

Languages: SQL, T-SQL, C, XML

Databases: SQL Server 2005,2008,2008 R2,2012, DB2

Reporting Tools: SQL Server Reporting Service (SSRS)

ETL Tools: SQL Server Integration Services (SSIS), Data Transformation Services (DTS), Import Export Data

OLAP Tools: SQL Server Analysis Services (SSAS)

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

SQL Server SSIS/SSRS Developer

Responsibilities:

• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to teh database and written functions, stored procedures and triggers.
• DDL Scripts for generating Tables, Views, Functions.
• Copied Facet State to XML file using T-SQL.
• Analyzed and designed software and database solutions.
• Managed SQL Server environments, by configuring a facet in one instance of SQL Server, copy teh state of teh facet to a file, and tan import that file into another instance of SQL Server as a policy.
• Involved in performance tuning using indexing (Clustered Index, Non Clustered Index) tables.
• Proficient in usage of SSIS Control Flow items (For Loop, Execute package/SQL tasks, Script task, send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping, Pivot).
• Use to update teh database properties directly by getting into facets.
• Experience in building SSIS packages (.dtsx) involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.
• Experience in creating Jobs, Alerts, SQL Server Mail Agent, and schedule using DTS/SSIS Packages.
• Hands on experience working with SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.
• Created SSIS/DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded teh data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Designed high level ETL architecture for overall data transfer from teh source server to teh Enterprise Services Warehouse
• Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Generated Reports using Global Variables, Expressions and Functions for teh reports.
• Configured Reporting Services in SQL Server 2008.
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Created different Power Pivot reports as per teh client requirement.
• Experience in creating Multidimensional cubes using SSAS and designing DW schemas.
• Involved in implementing Key Performance Indicator (KPI) Objects in SSAS 2008. Create Calculate member in MOLAP cube using MDX in SSAS 2008.
• Experience in Designing, Building teh Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS) for analyzing purpose.
• Worked on pre-defined facets included by SQL SERVER
• Created calculated measures and dimension members using multi-dimensional expression (MDX).
• Created DSV, Cubes, and Dimensions, DMX/MDX for SSAS Reports.
• Interacting with teh users and troubleshooting teh problems involved with teh development of stored Procedures, triggers and problems related to teh privileges.
• Created Views to reduce database complexities for teh end users.
• Conceive and direct Active Server Page (ASP) initiative to create a web-based dynamic product registration and tracking system linked through ODBC to corporate DBMS.
• Worked on troubleshooting and maintaining large (terabyte-size) clustered databases.
• Created checks and constraints to maintain data integrity.
• Resolved significant PPS connection string issues with import process.
• Worked with Business Analysts, Developers and customers to resolve and escalate project issues.
• Gatheird teh business system requirements act as a SME for teh system and business & created status reports
• Worked closely with teh team in meeting teh deadlines pertaining to design and development deliverables.

Confidential, San Francisco, CA

SQL Developer

Responsibilities:

• Gatheird business requirements, definition and design of teh data sourcing and data flows, data quality analysis, working in conjunction with teh data warehouse architect
• Created logical and physical data models using Erwin for new requirements after discussion with technical team and application users.
• Designed and implemented complex SSIS package to migrate data from multiple data sources (Teradata) for data analyzing, deploying and dynamic configuring of SSIS packages.
• Designed high level ETL architecture for overall data transfer from teh OLTP to CDW with teh help of SSIS.
• Developed and maintained a combined data store for reporting purposes.
• Generated reports using Global Variables, Expressions and Functions using SSRS.
• Identified teh database tables for defining teh queries and defined datasets for report generation.
• Defined report layouts including report parameters and wrote queries for drill down reports using SSRS 2012.
• Created parameterized, drill down and aggregation reports in MS SQL environment using SSRS 2012.
• Generated daily, weekly and monthly reports for teh managers.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2012.
• Extensively used performance monitor/SQL profiler to solve dead locks/long running queries.
• Tested teh reports and fixed bugs in teh stored procedures.
• Responsible for teh Performance tuning of teh SQL Commands and teh troubleshooting of teh technical problems in MS SQL Server 2012

Confidential, Arlington, TX

SQL Developer

Responsibilities:

• Designing Data Model and implementing changes in teh earlier phase of teh project to accommodate business logic and dynamic nature of teh front end application.
• Designed and modeled Microsoft SQL Server 2008R2 data warehouse and data marts, including teh modification of existing Microsoft SQL Server 2005 data warehouse and data marts.
• Used SSIS packages to roll our data to Live Tables and to Processing Database.
• Developed database objects such as SSIS Packages, Tables, Triggers, and Indexes using T-SQL, SQL Analyzer and Enterprise Manager
• Configure teh SSIS Package for run time Parameters and Config file
• Develop teh Documents for Logging/Error Handling for SSIS Packages
• Integrate teh SSIS package, converting all existing DTS packages of MS SQL by adding extra SSIS task.
• Schedule Package using SQL Server Job for weekly/monthly basis.
• Used Checkpoint for avoiding re-executes Package from teh first task.
• Develop teh Slowly Changing Transformation to maintain teh Historical Data.
• Handling teh errors during data moving and Sequencing teh task as per requirements.
• Developed packages using fuzzy task for data cleansing.
• Handling teh orphan rows in Dimension and Fact tables.
• Developed Sites, Team Sites, Views, Alerts and Lists in SharePoint 2010.
• Created Sites & Sub Sites and installed Solution Packages by using PowerShell in SP 2010.
• Participated actively in analysis and discovery phases of data warehouse implementation.
• Perform T-SQL tuning & optimizing queries for Reports which take longer time in execution SQL Server 2008R2
• Developed interface and reporting stored procedures, views, UDF for efficient data storage and manipulation
• Migrated Crystal reports to SSRS reports manually
• XML result set from Stored Procedures to create custom XML file for third party data export.
• Extensively worked on SSIS creating all teh interfaces between front end application and SQL Server 2008R2 database, tan from legacy database to SQL Server Database and vice versa.

Confidential

Technical Associate

Responsibilities:

• Interacted with Team in Analysis, Design and Develop database using ER Diagram, Involved in Design, Development and testing of teh system
• Developed SQL Server Stored Procedures, Tuned SQL Queries( using Indexes)
• Created Views to facilitate easy user interface implementation and Triggers on them to facilitate consistent data entry into teh database.
• Implemented Exceptional Handling
• Worked on client requirement and wrote Complex SQL Queries to generate Crystal Reports
• Creating and automating teh regular Jobs.
• Tuned and Optimized SQL Queries using Execution Plan and Profiler
• Rebuilding Indexes and Tables as part of Performance Tuning Exercise
• Involved in performing database Backup and Recovery
• Worked on Documentation using MS word