SUMMARY

• 7+ years of IT experience in the use and development, design, support and migration of Microsoft SQL Server 2008/2005/2000 databases
• Expert in Microsoft Business Intelligence technologies like SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS )
• Highly proficient in the use of T - SQL for developing complex stored procedures, triggers, tables, user functions, user profiles, relational database models and data integrity, SQL joins and query writing
• Experienced in Logical and Physical Database design, development, Normalization and Data modeling using Erwin and SQL Server Enterprise manager
• Experience in extracting and transforming (ETL process) data using DTS/SSIS Import Export Data from various sources, Bulk Insert, Log Shipping, BCP and DTS/SSIS Packages
• Extensive experience in the development of Reports using SQL Server 2000/2005 Reporting Services (SSRS) and Microsoft Access and developed Custom Report and different types of Tabular Reports, Matrix Reports, drilldown reports, Microsoft Dynamics and score cards in multiple formats using multi - dimensional objects
• Expert in designing and scheduling complex SSIS Packages for transferring data manually from multiple data sources like MSSQL Server2000, Oracle Database, Excel and Flat file to MicrosoftSQL Serverby usingSSISand DTS utility ofSQL server2005/2008
• Have good experience with designing and implementing MDX queries, OLAP architecture, MOLAP, ROLAP and HOLAP
• Experience with all phases of software development life cycle (SDLC) and project methodologies
• Knowledge in query optimization & performance tuning, Using SQL Server Profiler, Execution Plan, Performance Monitor and DBCC Commands
• Experience in OLTP/OLAP system study, Analysis and modeling, developing data warehouse schemas like Star and Snowflake Schema used in dimensional and multi-dimensional modeling
• Worked on SSIS 2012 Package deployments and Dreamweaver
• Extensive working knowledge on Migration from SQL 2008 to SQL 2012
• Worked on Server side development according to the business requirements
• Used Data Quality Services within SSIS 2012 for data Cleansing and data profiling
• Used Power view within SSRS 2012 for statistical analysis
• Worked on full and differential packages
• Extensive working on Performance Optimization and Database Tuning
• Worked on Snapshot Replication
• Worked on Database Participations for Improvement in Query Performance
• Quick learner and good performer both in team and independent job environments

TECHNICAL SKILLS

• MS SQL Server 2008/2005/2000
• MS SQL Server Integration Service (SSIS)
• MS SQL Reporting Services (SSRS)
• MS SQL Server 2005/2008 Analysis Services (SSAS)
• Business Intelligence Development Studio (BIDS)
• T-SQL
• HTML
• XML
• MS Access
• Excel
• SQL Query Analyzer
• SQL Enterprise Manager
• Management Studio
• SQL Server 2005 Query Editor
• Solution Explorer
• Analysis Manager
• Reporting Server
• Data Transformation Services (DTS)
• Netezza
• Business Analysis
• Object-Oriented (Use Case) Analysis
• Database Design and Normalization
• Data Modeling
• Database designer
• E-Commerce
• Cognos
• Microsoft Visio
• MS Office 2007
• ERWIN 7.x
• C
• C++
• QNXT
• Windows Vista/XP/NT/2000.

PROFESSIONAL EXPERIENCE

Confidential, Brentwood, TN

MS SQL Server/SSIS/SSRS Developer

Responsibilities:

• Prepared the complete data mapping for all the migrated jobs using SSIS
• Responsible for creating and designing SSIS package
• Designed Extraction Transformation and Loading (ETL) process using SSIS to extracted data from flat files, excel files and SQL server database
• Based on business requirement, developed the Complex SQL queries with Joins and T-SQL, Stored procedure, Views, Trigger to implementing the business rules and transformations
• Use different control flow control like for each loop container, sequence container, execute SQL task, send email task
• Use package configuration to migrate SSIS package from one environment to other
• Use event handing to send e-mail on error events at the time of transformation
• Use login feature for analysis purpose
• Added intelligent system in SSIS to identify actual change and new change in dimension
• Design SSRS and excel reportsonassets, expense analysis, and balance sheet
• Deployed reports onto the production report server through various ways
• Created Ad hoc Reports using report builder in SSRS
• Design store proc, view, trigger, function for data ware housing
• Developed SSIS Packages to perform Data loads from various types of sources files (EXCEL, Access, Flat files)
• Set up SQL Profiler to trace various Database activities, Application Responses and their Performance in order to tune them
• Created script to migrate SQL server object from one environment to other environment
• Used DBCC commands to check physical and logical consistency of the databases and Rebuild
• Used the SQL Server profiler to capture and store the execution plan. Created necessary indexes
• Modified the queries to achieve better performance
• Used SQL SERVER AGENT to automate the process of rebuilding indexes at regular interval for better performance.
• Involved in designing, reviewing, and creating primary objects like Views, Indexes, Stored procedure, Functions, Triggers based on logical design models, user requirements and physical constraints
• Worked on migration of SSIS 2008 packages to SSIS 2012

Environment: MS SQL Server 2005/2008/2012 , MS SQL Server Reporting Services 2008, MS Dynamics, MS SQL Server Integration Services 2008, XML, MS Access, Excel, Share point (MOSS), C#, ASP .Net, Crystal Reports, ER Studio, Performance point Server.

Confidential, Tampa FL

MS SQL Server/SSIS/SSRS Developer

Responsibilities:

• Analyzed business requirements and build logical and physical data models that describe all the data and relationships between the data using Erwin
• Based on business requirement, developed the Complex SQL queries with Joins and T-SQL, Stored procedure, Views, Trigger to implementing the business rules and transformations
• Used ETL SSIS to develop jobs for extracting, cleaning, transforming and loading data into data warehouse
• Involved in designing, reviewing, and creating primary objects like Views, Indexes, Stored procedure, Functions, Triggers based on logical design models, user requirements and physical constraints
• Worked on migration of SSIS 2008 packages to SSIS 2012
• Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS-2008 in Business Intelligence Development Studio (BIDS)
• Prepared the complete data mapping for all the migrated jobs using SSIS
• Developed SSIS Packages to perform Data loads from various types of sources files (EXCEL, Access, Flat files)
• Performed data cleansing by creating tables to eliminate the dirty data using SSIS
• Performed daily tasks including backup and restore from disaster recovery by using SQL Server 2008 tools like SQL Server Management Studio, SQL Server Profiler and ANSI
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP
• Prepared the complete data mapping for all the migrated jobs using SSIS

Environment: MS SQL Server 2005/2008/2012 , MS SQL Server Reporting Services 2008, MS SQL Server Integration Services 2008, XML, MS Access, Excel, Share point (MOSS), C#, ASP .Net, Crystal Reports, ER Studio, Performance point Server

Confidential, Pittsburgh, PA

MS SQL Server/SSRS Developer/BI Developer

Responsibilities:

• Excellent knowledge in creating reports using SSRS
• Created Sub Reports and Drill down Reports as per the client requirements using SSRS
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations
• Involved in all phases of System Development Life Cycle (SDLC)
• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple heterogeneous information sources (Oracle & Sybase)
• Extensively designed the packages and data mapping using Data Profiling Task, Control Flow Task, Sequence Container Task, Dataflow Task, Execute SQL Task, Data Conversion Task, Derived Column Task and Script Task in SSIS Designer
• Created List reports, Standardized Reports, On-Demand Reports, Cross tabs Reports, Drill-down Reports, Ad hoc Reports, Charts, Functions and Formulas using SQL Server Reporting Services (SSRS)
• Configured report server in development and production and also created SQL Server Reports using SSRS 2008 from initial stage
• Worked on parameters to generate cascaded parameterized reports along with that extensively used global variables, expressions and functions
• Created Views to reduce database complexities for the end users
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2008R2
• Developed SSIS Packages using Derived Columns, Condition Split, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse
• Created a table to save dirty records
• Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS)
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers
• Generated Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS

Environment: SQL Server 2008R2, Integration Services 2008R2, Visual SourceSafe, TSQL, MS Access.

Confidential, Seattle WA

MS SQL Server / SSRS /SSIS Developer

Responsibilities:

• Responsible for creating the reports based on the requirements using SSRS 2005
• Created detailed reports for the customers to help them decide which property to purchase by showing demographic information based on various parameters
• Authored performance based reports for the managers to show sales against various measures like Time, Area, and Price-Range
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations
• Actively supported business users for change requests
• Monitored performance and optimized SQL queries for maximum efficiency
• Identified and defined the Datasets for the report generation
• Wrote the queries for the drill down reports
• Planned the complete Back-up of various Databases for Disaster recovery scenarios.
• Identified and added the report parameters
• Formatted the reports using the Global variables and expressions

Environment: SQL Server 2000/2005/2008 Enterprise Edition, Visual Studio, SQL, T-SQL, MS Access, MS Excel, & Windows 2003 server, Business Intelligent technologies like SSIS,SSRS,SSAS.

Confidential, West Chester, PA

MS SQL Server Developer/BI Developer

Responsibilities:

• Involved in the designing, development, modification and enhancing the database structures and database objects
• Created complex SSAS cubes with multiple fact measure groups and multiple dimension hierarchies based on the OLAP Reporting needs
• Transferred data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat Files, CSV files into SQL Server 2005
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases
• Wrote several complex stored procedures for efficient handling of the application
• Debugged and optimized several complex stored procedures
• Constructed cubes based on data volumes mostly adhering to Star Schema
• Identified and worked with parameters for parameterized reports in SSRS 2005

Environment: MS SQL Server 2005, MS SQL Reporting Services 2005, ASP.Net, Toad.

Confidential

BI/SQL Server Developer

Responsibilities:

• Responsible for creating reports based on the requirements using SSRS 2005
• Actively supported business users based on their requirements
• Identified the database tables for designing the queries for reports
• Written queries for drill down reports
• Extensive usage of Data Definition Language and Data Manipulation Language
• Identified and included report parameters and formatted reports using global variables and expressions.
• Deployed the reports onto the server
• Defined attribute properties in Parent Child Dimensions
• Responsible for hiding and disabling the attribute hierarchies

Environment: SQL Server 2005/2008/2012 , SSIS, SSRS, Erwin, .Net Frame Work, XML, MS Access, Excel, C#, ASP .Net, Crystal Reports.