SUMMARY

• IT professional with 6+ years of experience, seeking to obtain a progressive position in database development and application support with opportunity to apply customer interaction skills in conjunction with technical and analytical noledge and abilities for teh betterment of teh company’s business and further skills enhancement.
• Microsoft certified technology specialist with 6+ years of professional experience in system analysis, design, development and testing in various projects executed in Client/Server and Data warehouse environments in Telecom, Real Estate and Banking domains.
• Expert in creating various SQL server objects like database, schemas, tables, indexes, indexed views.
• Expertise in creating complex Stored Procedures (Dynamic and static), TEMPeffective functions, and appropriate triggers to facilitate efficient data manipulation and data consistency.
• Hands on Experience in using tools like Dynamic Management Views, Index Tuning Wizard, SQL Profiler and Windows Performance Monitor for Monitoring and Tuning SQL Server Performance.
• Worked extensively on system analysis, design, development, testing and implementation of projects (Complete SDLC) and capable of handling responsibilities independently as well as a proactive team member.
• Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services ( SSIS ), Log Shipping, DTS, Bulk Insert and BCP.
• Developed, monitored and deployed SSIS packages.
• Experience in developing Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Created stored procedure for generating reports using SSRS.
• Created Cross - Tab, Drill-down, Drill-through and Sub-Report using RDL.
• Experience in Designing, Building teh Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS)
• Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server 2008/2005/2000/7.0
• Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduled DTS Packages.
• Strong inclination for finishing job before project deadline and maintaining security.
• Worked on Exception Handling with @@error and with Try/catch.
• Good noledge in Normalizing and De-normalizing teh tables and maintaining Referential Integrity by using Triggers and Primary and Foreign Keys.
• Good SQL Server Administration skills using various backup recovery, replication, restoration and DTS servers, Model (simple, Bulk and full), database maintenance plan, user (NT/SQL) security authorizations and clusters creation.
• Implemented different types of Replication Models such as Transaction, Snapshot and Merge replication in SQL Server 2008 and SQL Server 2005 in OLTP Environments.
• Experience in Configuring and Managing Linked Servers, data transfer between SQL Server and other heterogeneous relational database such as Oracle and DB2.
• Strong analytical and problem-solving skills coupled with excellent documentation, verbal and inter-personnel communication skills and ability to acquaint to fast changing skills.
• Experience in interacting with business analyst and other front end developers.
• Expertise in using Team Foundation Server (TFS) and Visual source safe (VSS) as a tool for repository of codes and version control, branching and merging into production.

TECHNICAL SKILLS

Languages: C, C++, C#.Net, T-SQL.

RDBMS: MS SQL Server 2008 R1, R2, 2005, 2000, Oracle 8i/9i/10g, SQL Server Management Studio(SSMS), SQL Server Analysis Services 2005,MS SQL Server Integration Services 2005, MS Access.

Front End: MS Visual Basics 6.0.

Web Technologies: ASP.Net, ADO.Net, LINQ, XML Web Services, HTML, Microsoft Office SharePoint Server (MOSS) 2007.

Middle Tier: MSMQ, Microsoft .Net Technology.

Reporting Tools: SQL Server Reporting services 2005/08, Crystal Reports.

Web Server Technologies: IIS 5.1/6.0.

Data Modeling Tool: ERWIN 4.0, ETL, Visio 2002.

Operating System: Windows 2008, Advanced Server, Windows 2000/2003 Server, data center, Windows NT, Windows 95/98/2000 XP, UNIX, LINUX.

PROFESSIONAL EXPERIENCE

Confidential

Sr. SQL/BI DEVELOPER

Responsibilities:

• Designed and developedSSIS Packagesto import and export data fromMS Excel, SQL Server 2008 and Flat files.
• Involved in daily loads (Full & Incremental) into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS) 2008.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing teh packages in both teh environments (Development and Production).
• Used various Transformations in SSIS Dataflow, Control Flow using For Loop Containers and Fuzzy Lookups etc.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Created SSIS packages for data conversion using Data Conversion Transformation.
• Configured teh loading of data into slowly changing dimensions using Slowly Changing Dimension Wizard.
• Successfully migrated data between different heterogeneous sources such as flat file, Excel and SQL Server 2008 using SSIS, BCP and Bulk Insert.
• Designed DTS/SSIS packages to export and import data from SQL Server to MS Access, Oracle10g, text files and Excel files.
• Involved in Dimensional modeling by identifying teh fact and dimension tables based on teh user and reporting requirements.
• Designed and implemented Dashboards and Scorecards with business KPIs using Performance Point Server and published them Via Microsoft Office Share point Server (MOSS).
• Advanced extensible reporting skills using SQL Server 2008 Reporting Services (SSRS).
• Designed and created report templates, bar graphs and pie charts based on teh financial data.
• Developed various types of complex reports like Drill Down, Drill through, Cross tab reports.
• Involved in scheduling, creating snapshots and subscriptions for teh reports using SSRS 2008.
• Involved in designingParameterized Reports and Report Modelsfor generatingAd-Hocreports as per teh client requirements.
• Defined Key Performance Indicator metrics to create scorecards.
• Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement teh business logic and also created clustered and non-clustered indexes.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Advised optimization of queries by looking at Execution Plan for better tuning of teh database.
• Developed complex SSAS cubes with multiple fact measures and multiple dimension hierarchies based on teh OLAP reporting needs.
• Involved in building Data Marts and multi-dimensional models like Star Schema and Snowflake Schema.
• Defined Schemas, me.e. relationships between Measure groups and Dimensions in SSAS.
• Improved teh performance of teh cube by creating Attribute Relationships, Partitions, and Aggregations, getting rid of unused attributes and by changing teh attribute hierarchy options in SSAS.
• Understanding teh OLAP processing for changing and maintaining teh Warehousing, Optimizing Dimensions, Hierarchies and adding teh Aggregations to teh Cube.
• Created reports using stored procedure and experience in building Reports on Analysis Services cubes (SSAS).

Confidential, TX

SQL Server BI Developer (SSIS, SSRS) / DBA

Responsibilities:

• Involved in development and implementation of SSIS, SSAS and SSRS application solutions for various business units across teh organization.
• Studied teh existing OLTP system(s) and Created facts, dimensions and star schema representation for teh data mart.
• Responsible for hiding and disabling attributes hierarchies.
• Specified teh named sets for calculations.
• Educated team on load process and data movement changes.
• Back end experience in MS SQL Server development, writing T-SQL stored procedures, views, triggers, cursors, UDFs.
• Designed, Managed and published various reports using SQL Server Reporting Services 2008.
• Designed different type of reports including: Tabular forms, Matrix (cross Tab report) form, List items, Charts and Linked reports.
• Designed reports using table filters, single value parameters, multi value parameters, and Cascading Parameters
• Created and designed reports based on query parameters and Report parameters.
• Created nested Grouping, sorting columns and writing expressions according to teh business requirements.
• Created sub reports and pass through parameters from main report to teh sub reports.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on teh OLAP reporting needs.
• Created SQL joins, Sub queries, tracing and performance tuning for better running of queries.
• Involved in Installation, Configuration of SSRS Reporting server and involved in Deploying reports.
• Involved in migration and Conversion of Reports from SSRS .
• Created SSRS Report Model Projects in BI studio and created, modified and managed various report models with multiple model objects, source fields and expressions.
• Experience in backup and recovery models of database.
• Highly involved in creating, structuring, formatting using Report Designer and Report Builder.
• Responsible for scheduling teh subscription reports with teh subscription report wizard.
• Created in setting report parameter properties. Determine whether parameters are single or multi valued, visible at runtime and set teh default values in teh run time.
• Created highly complex SSIS packages using various Data transformations like conditional splitting, Data Conversion, Fuzzy Look-Up, For Each Loop, Multi Cast, column conversion, Fuzzy Grouping, Script Components, error handling.
• Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.,) and then loaded teh data into destination tables by performing different kinds of transformations using SSIS packages
• Directly responsible for teh Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse Worked on SSIS script task, look up transformations and data flow tasks using T- SQL and Visual Basic (VB) scripts
• Enhancing and deploying teh SSIS Packages from development server to production server.
• Fetch and update data using SQL Client Connection and ADO.NET.
• Generated Custom ETL scripts using SSIS, develops and unit test SSIS load processes for performance check.

Environment: SQL Server 2008 Enterprise Edition, .Net 3.5, C#, VB.Net, SQL BI Suite (SSIS, SSRS, SSAS), OLAP, OLTP, Performance Point Server, Erwin, ETL, Enterprise manager, Windows Server 2008.

Confidential, King of Prussia, PA

Sr. SQL Server B.me Developer (SSIS/SSRS)

Responsibilities:

• Created SQL Server Reports using SSRS 2005.Identified teh data source and defined them to build teh data source views.
• Involved in debugging Reports and deploying Reports.
• Created Tabular Reports, Cross Tab Reports and Sub Reports.
• Scheduled teh Reports to run automatically.
• Extract Transform Load (ETL) development using SQL Server 2005, SQL 2008 Integration Services (SSIS).
• Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
• Experience in moving teh data from heterogeneous data sources like oracle, XML etc., to SQL using SSIS.
• Hands on experience in using different transformations like fuzzy lookup, derived column transformation etc., using SSIS.
• Enhancing and deploying teh SSIS Packages from development server to production server.
• Designed high level ETL architecture for overall data transfer from teh source server to teh Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, Column Mapping, Data dictionary and Metadata.
• Used Performance Point Server to create interactive reports with an ability to drill down into details.
• Experience in Performance Point Server powerful visualization tools, including teh Decomposition Tree, Perspective View and Performance Map, to drill down, cross drill, pivot, chart, and investigate data.
• Used Performance Point Server to identify KPI ‘S, build score boards, reports and dash boards
• Created SSIS packages to migrate data from Oracle DB to SQL Server 2005.
• Involved in Data migration (Import & Export using BCP) from text to SQL Server2005.
• Involved in Creating Stored Procedures for Reports generation.
• Migrating teh data from DTS to SSIS packages.
• Worked on creating complex reports using Report Designer in SSRS.
• Creating ad hoc reports on relational and multidimensional data using model data sources in SSRS.
• Creating SSIS packages in Business Development Studio 2005.
• Development, improvement, customization and deployment of SSRS reports in Business Development Studio.
• Identified and defined Fact relationships in SSAS.
• Responsible for identifying KPIs in SSAS 2005.
• Created SFTP tasks and automated data loads.
• Responsible for Data Modeling and design of Data Warehouse and Data Marts in Star schema methodology.
• Maintained teh table performance by following teh tuning tips like normalization, creating indexes and collect statistics.
• Tested applications for performance, data integrity and validation issues.

Environment: MS SQL Server 2005/2008, ANSI SQL, SSAS, SSIS, MS SQL Server Reporting Services (SSRS), OLAP, OLTP, Erwin, Oracle 9i, SharePoint Portal, ASP.Net, C#.Net, ETL, Erwin, C#.Net, CSS, Java Script, XML, HTML.

Confidential, LA

Sr. Database Developer

Responsibilities:

• Monitored testing servers for long running stored procedures, queries using profiler and recommended clustered and non-clustered indexes using DTA.
• Created DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle using SSIS.
• Experience in mapping multiple related systems.
• Designed teh system architecture that is used to structure, plan, and control teh process of developing an information system
• Transformed data from various data sources using OLE DB connection by creating various DTS packages.
• Used BCP command line utility to replicate a database.
• Extensive experience in designing, creating and deploying SSIS packages for transferring data from flat files, excels spreadsheets and heterogeneous data to and from SQL Server.
• Used Erwin tool to visualize complex data structures, inventory information assets and establish enterprise-wide standards for managing data.
• Experience in migrating some of teh DTS packages in to SSIS.
• Used Recompile and with option query hints to avoid parameter sniffing problems.
• Improved query performance by adding covered indexes, adding file groups.
• Creating and managing schema objects such as tables, views, joins, clusters, indexes, functions, procedures, triggers & maintaining Referential Integrity.
• Implemented SSIS data transformations scripts, created maintenance procedures and provided data integrity strategies.
• Developed reports using SSRS 2005 and Crystal reports. Used table control, matrix control for cross tab reports.
• Installing different hot fixes for deadlocks, blocking and indexes.
• Detection and resolving of blocking and deadlocks using Profiler.
• Experience of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables using MS Analysis Services.
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2005 and in adding calculations.
• Worked with Technical Architects and Database analysts for teh Design of Summary tables required for efficient Report Design.
• Experience in using XMLA protocol for SQL Server Analysis Services 2005 for interaction between client application and instance of Analysis Services.
• Designed and developed packages for data warehouse using Integration services (SSIS) SQL Server 2005/2008.
• Configured Reporting Services in SQL Server 2005.
• Created standard Reports and Cross Tab Reports and Drill Through reports.
• Generated Reports using Global Variables, Expressions and Functions for teh reports.
• Responsible for scheduling teh subscription reports with teh subscription report wizard.
• Created different chart reports halped in analyzing Perfmon counters using SSRS 2005.
• Troubleshooting performance issues with Fragmentation using Profiler, System Monitor and DMV’s.
• Configured nodes and virtual server to set up Active/Active Clustering.
• Import Data from MS-Access Database and XML to SQL Server Database.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor
• Involved in Installation, Configuration of Share Point Form in Cluster Environment.

Environment: SQL Server 2000/2005/2008 , Enterprise Edition, SQL, Enterprise manager, SSRS 2005, SSIS 2005, Spotlight, MS SharePoint, MS Access 2000 & Windows 2003/2000 platform,C#,VB.NET,ASP.NET.

Confidential, Atlanta, GA

Sr. Software Developer

Responsibilities:

• Created logical and physical database design, data structures and maintained it by using SQL tools like Stored Procedures, User Defined Functions, Views, T-SQL Scripting for complex business logic.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Optimized teh database by creating various clustered, non-clustered indexes and indexed views.
• Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.
• Increased teh performance necessary for statistical reporting by 25% after performance monitoring, tuning and optimizing indexes.
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
• Created Parameterized reports and linked reports using Bookmark links and Hyperlinks.
• Created subscription for teh windows file share and implemented three layer securities for teh reports, SSRS website, and in teh Intranet web application.
• Return teh custom code in Reports to avoid teh case statement in teh SQL stored procedure.
• SSIS Packages are created to export and import data from CSV files, Text files and Excel Spreadsheets.
• Design teh SSIS Package to update teh Data mart from OLTP Database.
• Full text search.
• Responsible for teh validation of teh aggregate data from teh ODS and teh OLTP Database.
• Problem identification, troubleshooting, resolution, and index tuning databases.
• Tested and implemented Database Mirroring solution for Production critical application.
• Taking Database full Backup, Transaction log backup & differential backup in daily Routine
• Created Alerts for successful or unsuccessful completion of scheduled Jobs.
• Diagnosing and tuning teh server optimal performance using SQL Server 2005’s Dynamic Management Views (DMV), Profiler and Index Tuning Wizards

Environment: SSRS, SSIS, MS SQL Server 2005, Windows 2003, C#, VSS 2005, XML, MS Access, MS SharePoint, ASP.NET, MS Office Access 2003, VBScript, ER-Win and Visio.

Confidential, Richmond, Virginia

SQL Server Developer (SSRS)

Responsibilities:

• Logical and Physical design of database for projects on basis of user requirements using ERWIN.
• Complete administration of MS-SQL Server 2000/MS SQL Server 2005.
• Migration of databases from MS SQL Server 2000 to MS SQL Server 2005 wherever required.
• Provided 24/7 Support for Production, Development & Test Servers of MSSQL Servers.
• Wrote Triggers and Stored Procedures to capture updated and deleted data from OLAP systems.
• Implemented and maintained database security.
• Writing queries to generate reports for analysis of data using SQL Server Reporting Services (SSRS), Report Builder.
• Generated Reports using Global Variables, Expressions and Functions for teh reports in SSRS.
• Responsible for scheduling teh subscription reports with teh subscription report wizard using SSRS.
• Generated various Drill-through reports, parameterized reports, sub-reports and linked reports using SSRS and integrated into teh web front end.
• Worked on backups scheduling.
• Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS
• Successfully created Fact Tables, Dimensions and joined them to extract meaningful data.
• Administrator tasks like managing users, roles, and profiles.
• Performed Database backups (operating system, flat file backups & export/import).
• Tuned SQL statements (using Indexes) and PL/SQL Procedures.
• Used Query Analyzer to optimize SQL Queries.
• Configured teh SQL Server’s Optimal Settings (Multithreading, Locking Memory) according to teh usage of its tables, # of users and hardware.
• Designed & created Reports using Report Builder in Developer 2000.
• Developed standards and guidelines to maintain and develop and administer teh SQL Server database.
• Handled corrupt databases diagnosed and repaired them.
• Analyzed and created Facts and Dimension Tables using SSAS.
• Created teh Data source connections, Data Source Views, Relationships, Named Query for customized analysis in SSAS.
• Developed Multi-dimensional Objects Cubes, Dimensions using SSAS.
• Worked with SSAS storage and partitions, and Aggregations.

Environment: SQL Server 7.0/2000, T-SQL, Enterprise Manager, Query Analyzer, Windows 2000 Server, MS Office 2000, Crystal Reports.

Confidential

Jr. Database Developer (Microsoft SQL Server 2000/2005)

Responsibilities:

• Actively involved in Normalization of database.
• Designed DDL and DML for MS SQL Server 2000 and MS SQL Server 2005
• Create rules, defaults, tables, views, clustered & non-clustered index, user defined data types, and user defined functions.
• Optimize query performance by creating indexes.
• Involved in writing SQL batch scripts.
• Write T-SQL statements for retrieval of data and Involved in performance tuning of T-SQL
• Involved in merging existing databases and designed new data models to meet teh requirements and perform daily database backup & restoration and monitor teh performance of Database Server.
• Created joins and sub-queries for complex queries involving multiple tables.
• Use DDL and DML for writing triggers, stored procedures, and data manipulation.
• Install and Configured SQL Server 2000 and SQL Server 2005 on development server for designing and testing.

Environment: MS SQL Server7.0/ 2000/2005, T-SQL, DTS, SQL Server Enterprise Manager, SQL Profiler.