SUMMARY

• Over 6 years of strong experience in teh IT industry as a SQL Server Developer (SSIS, SSRS) with sound business analysis skills.
• Experience in all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Installation and configuration of SQL Server 2005/2008 R2/2012.
• Extensive experience in MS SQL Server 2005/2008 R2/2012,Business Intelligence in MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS).
• Performed Key Role in Logical and Physical Database design and development and Data modeling using SQL Server Enterprise Manager.
• Experience of Normalization/De - Normalization of database tables, developing (DDL) and (DML) and building Referential Integrity for teh (RDMS).
• Highly proficient in teh use of T-SQL for developing Stored Procedures, Triggers, Tables, User Defined Functions, Relational Database Models, Data Integrity and SQL Joins.
• Highly experience in Sub Queries, Joins involving multiple tables.
• Experience in Performance Tuning and Optimization of Procedures and Queries.
• Used DBCC commands for Database maintenance (Rebuilding Indexes).
• Created and managed Clustered Indexes and Non Clustered Indexes and optimized queries using Execution Plan.
• Expert in designing and scheduling complex SSIS Packages for transferring data from multiple sources .
• Developed packages in SSIS with error handling.
• Designed packages which utilized tasks, containers and transformations such as Execute SQL Task, Data Flow Task, File System Task, Send Mail Task,FTP Task, Sequence Container, Foreach Loop Container, Lookup, Conditional Split, Data Conversion,Multicast,Copy Column, Aggregate, Expression and Derived Column.
• Exposure working with web development tools such as ColdFusion, SharePoint, and Asp.Net.
• Experience in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting teh data, defining data source and subtotals for teh reports using SSRS SQL Server Reporting Services (SSRS) in Business Intelligence Development Studio (BIDS).
• Excellent written and oral communication skills with a results-oriented attitude. Good in Collecting, Analyzing and Interpreting Data in an organized way. Versatile in working as an individual and also as part of a team. Proficient with various computer operating systems.
• Proactive team player with demonstrated problem solving and analytical reasoning abilities.

TECHNICAL SKILLS

Languages: C#, .Net, SQL, T-SQL,PL/SQL

SQL Server Tools &Packages: SQL Server Management Studio, Enterprise Manager, Business Intelligent Studio, Query Analyzer, Profiler, Performance Monitor, Database Tuning Wizard, SQL Server Agent, ETL

Databases: SQL Server 2000/2005/2008 R2/2012, MS Access 97/2003/2005/2008, Oracle

Operating Systems: Windows Server 2000/2003/2008, Windows 7/Vista/XP/2003/2000 UNIX, Linux, DOS

BI Tools: SSRS, SSIS

Web Technologies: HTML, DHTML, XML, Visual Studio, MS Front page

PROFESSIONAL EXPERIENCE

Confidential, Fortworth,Texas

SQL Server/SSIS Developer

Responsibilities:

• Developed SQL Programs and Stored Procedures as required for teh ETL processes and Data Integration activities.
• Built and Maintained SQL Scripts, Indexes, and complex queries for data analysis.
• Planned, Designed, and Implemented application database code objects, such as Stored Procedures, Functions and Views.
• Created complex SQL scripts using Joins (Inner and Outer),CTE and Derived Table.
• Worked on Functional design, System analysis, gathering of user requirements and maintaining good documentation.
• Extensively used Joins, Stored Procedures and Sub-Queries to simplify complex queries involving multiple tables.
• Experience on Normalization and De-Normalization of existing tables for faster query retrieval
• Worked on Query Performance, Data Management and Data Integrity.
• Worked on Query Optimization using tools like Database Tuning Advisor, Execution Plan, Profiler etc.
• Created a SSIS Package from teh scratch which captures teh Unique CredentialID of teh Confidential stores dat TEMPhas been changed and replaced. Generates a report for Store Operations which would list out teh store registers with a different Symantec VIP Credential ID TEMPthan teh one they had originally reported at teh time of baseline deployment.
• Use Send Mail Task dat uses teh Template to send teh report to teh end user.
• Making teh package dynamic by creating a Project Parameters and passing into Expression on Visual Studio 2010.
• Developed teh package which loop teh folders having Epoch Time and convert them into SQL Server time and then processed into sequential order.
• Worked on File System Task to rename teh source files once it TEMPhas been loaded into tables.
• Moved teh processed files into Archive folder by appending current date-time stamp on teh files. If their is an Error while processing a file, teh file should be renamed with an “Error” and moved under a different folder.
• Interacted with Business Analyst, Subject Matter Experts, and Stakeholders to understand their needs and provide solutions by writing SQL Objects.
• Familiar with OLAP and Datawarehouse environment.
• Developed complex T-SQL Queries and converted recurring Queries into parameterized Stored Procedures in support of Reporting and analytic needs.
• Translation of business questions and requirements into reports by writing Views, Stored Procedures etc.
• Used Script Task on multiple purposes:
• To check whether teh source files exist on teh source path or not.
• To append teh current date and time before and after file processing.
• To rename teh source files after successfully loaded into tables.
• To send teh error file to teh error path by appending teh current date-time stamp in teh source file.
• To send an empty file in teh source path by appending current date-time stamp after teh package ran successfully.
• Designed, Developed, Implemented and Maintained data solutions to support teh organization’s business strategy and goals.
• Worked on BCP to Import and Export flat files.
• Worked on Command Shell to export teh SQL Server Tables dynamically into flat files.
• Deployed SSIS package on SQL Server 2008R2 and SQL Server 2012.
• Worked on automation of teh package by creating job in SQL Server Agent.
• Worked on Execute Process Task to Unzip teh files.
• Worked on Package Configuration which carry teh information about teh Connection Strings, Variables etc.
• Worked on SSIS Transformations such as Lookup, Fuzzy Lookup, Import/Export Column, Data Conversion, Derived Column,Merge,Merge Join, Conditional Split etc.
• Worked on Security of teh package by Encrypting them.
• Captured teh different Events of teh package by doing Custom Logging on teh package.
• Redirected teh error records into separate files and load them into tables after fixing them.
• Loaded XML files into SQL server tables.
• Documented and Presented teh results of teh analysis to teh business users.
• Quick at picking up and understanding new models and applications.
• Ability to collect business user requirements and translate them into technical specifications.
• Ability to establish and maintain effective working relationships with peers, users, technical staff and management.
• A motivated self-starter dat is able to work independently and in teams on tasks and projects with limited supervision.

Environment: MS SQL Server 2008R2/2012, MS SQL Server Integration Services 2008R2/2012 (SSIS), MS SQL Server Reporting Services 2008R2/2012 (SSRS), MS SQL Server Analysis Services 2008R2/2012 (SSAS),T-SQL,SQL Profiler, Windows 2007, Windows Server 2003, Visual Studio 2010, Report Builder 3.0, MS Access, MS Excel.

Confidential, Dallas,Texas

SQL Server/BI Developer

Responsibilities:

• Experience in creating complex Stored Procedures, Triggers,Indexes,Function and views and other SQL joins for implementing teh business rules and transformations
• Experience of Normalization/De-Normalization of database tables and building Referential Integrity for teh Relational Database Management System (RDMS).
• Created and managed Clustered Indexes and Non Clustered Indexes.
• Created and maintained logins, roles and permissions on teh SQL instances and databases and provided required privileges according to teh user’s requirements.
• Created Views to restrict access to data in a table for security.
• Various Index design and Index performance tuning tips, query optimization.
• Identify teh causes of slow running of T-SQL queries.
• Optimize T-SQL query using SQL Profiler, Execution Plan,DMV(Dynamic Management View),Database Tuning Advisor and Optimized indexes to improve query performance.
• Resolved issues with Index Fragmentation.
• Good noledge and understanding in blocking, locking and deadlock issues.
• SSIS packages are created to export and import data from csv files, text files and excel spreadsheets. Used Transformation according to business requirement.
• Experience on different kinds ofTransformations like Derived Column, Conditional Split,Multicast,Copy Column, Data Conversion, Import Column, Export Column and LookupinSSISas per teh business requirements.
• Experience on Third Party Tool (COZYROCH) for downloading and unzipping zip files from FTP Server.
• Scheduled Daily and weekly Jobs using SQL Server Agent and sending alerts using Send Mail Task.
• Export Multiple SQL Server tables into one single folder location.
• Deployed SSIS Packages from development server to production server.
• Worked on SSIS Package Security, Package Configuration and Check Point.
• Upgrade of SSIS Package from .
• Experience on Error Handling of teh SSIS Packages by redirecting rows to an Error Log table.
• Experience on Logging SSIS packages on Windows Event Log and SQL Server.
• Generated Parameterized/Drilldown, Drill Through, Sub Reports, Linked reports using SSRS and deployed reports to Reporting Server and Report Manager.
• Experienced on preparing Technical Documentation on new and existing SSIS package.
• Self-motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills.
• Flexible, Enthusiastic and project oriented team player with excellent communication and leadership skills to develop creative solution for challenging client needs.

Environment: MS SQL Server 2008R2/2012, MS SQL Server Integration Services 2008R2/2012 (SSIS), MS SQL Server Reporting Services 2008R2/2012 (SSRS), MS SQL Server Analysis Services 2008R2/2012 (SSAS),T-SQLSQL Profiler, Windows 2007, Windows Server 2003, Visual Studio 2010, Report Builder 3.0, MS Access, MS Excel.

Confidential, Beaverton, Oregon

SQL Server/BI Developer

Responsibilities:

• Experience on writing complex T-SQL programming according to teh business requirements.
• Experience on designing, reviewing and creating database objects like Table, View, Indexes, Stored Procedure, Function according to teh business requirement.
• Tuned T-SQL statements using Indexes and Stored Procedures. Implemented Stored Procedures and enforced business rules via Check Constraints.
• Built Table Valued Function, Scalar Valued Function to suffice teh needs for business rules and for teh implementation in stored procedures.
• Solid understanding of teh Business Intelligence development lifecycle including data modeling for relational database.
• Designed SSIS Packages from teh scratch to download files from FTP Server and dumped into Shared Drive and finally load into staging database by doing Data Massage and Data Cleansing.
• Created Master and Child packages, Package Configurations and Logging tables.
• Deployed teh packages in MSDB database and automated teh packages by creating jobs in SQL Server Agent.
• Experience on SSIS Event Handler & notification using Send Mail task.
• Analyzed teh Business Requirement Document(BRD)to design a conceptual model to be implemented with T-SQL and SSIS.
• Experience on Lookup, Fuzzy Lookup and Fuzzy Grouping transformations for improving teh data quality of teh existing data as well as new data dat is being loaded into teh database.
• Worked on Teradata as a data warehouse perspective.
• Good noledge and understanding on Cubes, Dimensions (Star/Snow flake schema).
• Created Tabular Reports, Matrix Reports, List & Chart Reports, Parameterized Reports, Sub Reports, Ad-hoc Reports, Drill Down Reports as well as Interactive Reports according to business requirements
• Deployed reports to teh Reporting Server and Report Manager and automate teh reports using SQL Server Agent and scheduled teh reports according to requirement.
• Experience on Tuning reports and created data driven subscriptions for different users in Report Manager.
• Participated in project and team meetings, interacting and collaborating with team members and other departments as appropriate.
• Involved in all stages of development process - high-level design, implementation, testing, deployment and support of products adhering to company's SDLC
• Proficient in implementing all Transformations available on teh SSIS toolbox.
• Involved in Planning, Defining and Designing teh data needed for business requirement and provided documentation.
• TEMPHas teh ability to work effectively with all team members and good interpersonal skills.

Environment: MS SQL Server 2008R2/2012, MS SQL Server Integration Services 2008R2/2012 (SSIS), MS SQL Server Reporting Services 2008R2/2012 (SSRS), MS SQL Server Analysis Services 2008R2/2012 (SSAS), T-SQL, Teradata(EDW),Windows XP, Windows Server, Visual Studio 2010, Report Builder 3.0, MS Access, MS Excel.

Confidential, Dallas, Texas

SQL Developer/BI Developer

Responsibilities:

• Experience in all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Created Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL Joins for applications
• Developed SSIS packages using different types of Error Handling for various events.
• Strong analytical skills, understanding of RDMS and fluent in constructing SQL Stored Procedures, Views and Functions.
• Worked on Performance Tuning and Query Optimization. Created Indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
• Tested Stored Procedures performance and its path of execution by using SQL Profiler.
• Created Views to restrict access to data in a table for security.
• Experience on Documentation, Testing, Implementation and providing on-going support for teh applications
• Worked with development teams in teh design of physical databases and in modification.
• Highly proficient in working on all activities related to teh development, implementation, and support of ETL process for Data Warehouse.
• Experience in documenting and designing teh ETL process based on business requirements and system specifications and involved in automating teh monthly data warehouse build by using ETL tool SSIS.
• Exposure and noledge of Informatica.
• Created Package Configurations to deploy packages from development to production server.
• Developed report models for generating Ad-hoc reports using report builder. Monitored teh overall performance of teh database to recommend and initiate actions to improve/optimize performance.
• Experience on troubleshooting reports and stored procedures in test as well as production environment.
• Designed package which utilized tasks and containers such as Execute SQL Task, Data Flow Task, Forloop Container and Foreachloop Container.
• Highly proficient in working on all activities related to teh development, implementation, administration and support of ETL process for Data Warehouses using Bulk Copy Process (BCP).
• Developed and deployed SSIS packages for Data Warehouse using Lookup, Fuzzy Lookup, Derived Columns and Data Conversion.
• Teh Email feature was implemented for sending notifications for SSIS Jobs to concerned people to notify about teh execution and status of packages.
• Experience on Data Viewers, SSIS Logging, error configurations for Error Handling of teh packages.
• Generated Drill down, Drill through, Ad-hoc, Matrix Reports, and Parameterized Reports using expressions to calculate, Group, filter, Parameterized Report using SSRS.
• Created datasets using stored procedures and by writing ad-hoc SQL queries for report generation.
• Developed report models for generating ad-hoc reports using report builder. Monitored teh overall performance of teh database to recommend and initiate actions to improve/optimize performance.
• Migrated/Upgraded older MS SQL Server 2005 databases to MS SQL Server 2008.

Environment: Microsoft SQL Server 2008R2, SQL Server Reporting Services 2008R2, SQL Server Integration Services 2008R2, T-SQL, Windows Server 2003, MS Office, SQL Profiler, Visual Studio 2008, Oracle.

Confidential, Hillsboro, Oregon

SQL Programmer

Responsibilities:

• Created Stored Procedures, Triggers, Indexes, User defined Functions, Constraints etc. on various database objects to obtain teh required results.
• Identified teh causes of slow running of T-SQL queries.
• Experience in generation different kinds of reports like Drill down, Drill through, Matrix Reports, and Parameterized reports using expressions to calculate, group, filter, and parameterize report using SSRS.
• Experienced of creating Functions, Triggers, Stored Procedures, Views, Sub-Queries and SQL scripts to meet teh requirements of teh business users and application development.
• Deployed and Scheduled Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Developed Stored Procedures for teh Dataset to build teh reports for teh client requirements.
• Worked on Performance Tuning of Queries by using Execution Plan and re-writing teh code and Error Handling of Stored Procedure by using Try-Catch.
• Experience on Installation and configuration of SQL Server 2008 R2
• Designed and developed SSIS Packages (.dtsx files) to import and export data from MS Excel, SQL Server 2008 and Flat files.
• Experience on SSIS packages to update tables with monthly data and automated it through scheduled jobs for teh beginning of every month.
• Created reports using stored procedure from teh scratch and enhancing report by adding, removing Columns, joining different table, did calculation both in database and report by using expression, adding parameter and filter in teh query level and report level as well.
• Experience in Scheduling, creating Snapshots and Subscriptions for teh reports using SSRS 2005/2008 R2.
• Designed packages which utilized tasks and transformations such as Execute SQL Task, Data Flow Task, Sequence Container, Forloop Container, Foreach Loop Container, Lookup, Aggregation, Data Conversion, Merge, Multicast, Conditional Split, Merge Join and Derived Column.
• Successfully managed Extraction, Transformation and Loading (ETL) process by pulling large volume of data from various data sources using BCP in staging database from MS Access, excel.
• Involved in creating report models and applying row level security filters for report model. .
• Experience in teh management of report which include Reliability, Security and Standardization of teh reports.
• Experience in participating meetings with business users to gather teh requirements.
• Involved in teh analysis of existing database structures and creating teh new tables and views as per teh requirements.
• Worked with development teams in teh design of Physical Databases and in Modification.
• Extensively used T-SQL to manipulate and architect to produce results for users.
• Wrote user requirement documents based on functional specification.
• Used multiple Join statements to retrieve data from multiple several tables.
• Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.
• Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.
• Created complex reports like Drill down and Sub Reports.
• Participated Databases Architecture and Data Modeling Design.
• Reported all events and requirements through established reporting mechanisms in SSRS.
• Fully supported change management procedures.
• Wrote Stored Procedures for some job automations.
• Generated test data and tested database to meet teh functionalities deliverables in teh project documentation and specifications.
• Participated in business analysis and development of report requirements specifications and business rules.
• Provide 24 X 7 supports to all production, development and staging.

Environment: MS SQL Server 2008/2008R2, SQL Server Integration services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS),T-SQL, Microsoft Office 2010, OLAP, Oracle 10g,ASP.Net,VB.net,MS Visio, ColdFusion and SharePoint.

Confidential, Boston

SQL Server SSRS/SSIS Developer

Responsibilities:

• Designed and normalized teh databases and created different objects like Tables, Views, Stored Procedures, UDF’s, Indexes rules and defaults on MS SQL server.
• Worked with Transact SQL (T-SQL) Coding, writing queries (SELECT) statement for teh front end application.
• Created complex SQL queries using Joins (Inner and Outer), Temporary Tables and Table Variables.
• Developed Reports, Sub Reports, Parameterized reports, Drilldown Reports and various features using expression in SQL Server Reporting Services (SSRS).
• Experienced in Deploying and Scheduling teh reports based on Quarterly, Monthly and Yearly reports.
• Enhance reports by teh charts and graphs using Microsoft SQL Server Reporting Services (SSRS).
• Worked on Excels to upload teh data from Excels to SQL Server Database.
• Experienced on Error Configurations for Error Handling of teh packages.
• Optimized long running Stored Procedures and Queries by analyzing teh Execution Plan, running SQL Profiler, analyzing teh Selectivity of Index, Code Re-Writing for effective data retrieval.
• Optimized queries by looking at Execution Plan for better tuning of teh database.
• Experience in developing ETL packages with teh different sources as Flat Files, Excel, Text Files, and XML Files and migrating teh data into destination using SQL Server Integration Services (SSIS).
• Implemented Event Handlers in SSIS packages.
• Implemented Checkpoints to rerun teh failed package from teh point of failure.
• Responsible for creating user groups and assigning permissions.
• Created DTS packages to transfer objects from development server to production.
• Provided analysis and recommendations for setting up a comprehensive Backup and Recovery Strategy for SQL Servers.
• Setup and maintained Linked Servers.

Environment: MS SQL Server 2005/2008, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), MS Excel, Windows XP.