SUMMARY

• A Microsoft Certified Professional with Database Solutions and BI Solutions using Microsoft Technologies
• Over 8+ years of experience in IT industry as a SQL Server Developer with specialized skills in SSIS, SSAS and SSR
• Extensive experience in BI Solutions (ETL & Reporting) using SSIS, SSAS, SSRS and T - SQL Programming using DDL, DML, DCL commands for various business applications.
• Expert at developing ETL interfaces using SSIS, Data marts/cubes using SSAS and enterprise reports using SSRS utilizing latest versions (2005/2008/2008 R2) & features.
• Involved in writing T-SQL scripts, Design and develop stored MDX queries to support SSRS reports, complex Stored Procedures, Functions, Views, Triggers, and Cursors for various business applications.
• Experience in Error handling and debugging coding issues and troubleshoot production problems.
• Extensive Experience in RDBMS concepts such as Tables, User Defined Data Types, Indexes, Indexed Views, Functions, CTE’s, Table Variables and Stored Procedures.
• Experience in SQL Optimizing by using SQL Profiler, Index Tuning Wizard, Database Tuning Advisor, DBCC Commands, DMV’s, DMFs and Query Execution Plans.
• Expert in Extracting and Transforming data (ETL) from various heterogeneous sources and creating packages using SSIS/DTS, Import, Export Data, Bulk Insert and BCP utilities.
• Hands on experience with performing various SSIS data transformation tasks like Look-ups, Fuzzy Look-ups, Conditional Splits and Event Handlers, Error Handlers etc.
• Great Expertise in creating and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.
• Experience in conversion of packages from legacy systems (DTSàSSIS) and migrating, deploying the packages across Dev/UAT/Prod environments.
• Experience in Developing and Extending SSAS Cubes, Dimensions and data source views SSAS-Data Mining Models and Deploying and Processing SSAS objects.
• Expert in automating process by creating jobs and error reporting using Alerts, SQL Mail Agent, FTP and SMTP.
• Created various SSRS Reports involving variety of features like Reports,Charts,Filters,Sub-Reports,DrillDown,Drill-Through,Multi-valued parameters and etc.
• Designed time and geography dimensions including hierarchies
• Created multidimensional optimized cubes using SSAS
• Identified the requirement of partitioning the cube for better query performance
• Involved in processing the cube, calculated members using SSAS
• Modified star schema and identified the requirement of snow flake schema in the design
• Loaded fact and dimension tables as part of modified data warehouse solution
• Build an analysis services database on already existing data warehouse solution
• Created measures, measure groups, dimensions and multi-dimensional cubes
• Used MDX to query the cubes, debugging and supported the purpose of data analysis
• Worked on back up of cubes, aggregations and dimension level security of cubes
• I have good experience with building the cubes, loading the cubes etc.
• Schedule cube processing from staging database tables using SQL server Agent.
• Experience in developing and extending SSAS cubes, Dimensions and data source views SSAS data mining models and deploying and processing SSAS objects.

TECHNICAL SKILLS

Operating Systems: Windows 98/NT/2000/XP/Vista/Windows7

Databases: MS SQL Server 2000/2005/2008/2008 R2MS Excel/MSWord/MS Access/SharePoint

Database Tools: SQL Enterprise Manager, SQL Profiler, DTS Import/ExportSQL Client Configuration utility, MS OLAP Services, SSMSSQL Server Business Intelligence Development Studio(BIDS)

ETL Tools: DTS, SQL Server Integration Services, SQL Server Analysis

Reporting Tools: SQL Server Reporting Services (SSRS), Crystal Reports

Development skills: Transact SQL (T-SQL)

Languages: C, C++, HTML, XML/XSLT

PROFESSIONAL EXPERIENCE

Confidential, Boston, MA

SQL SSAS/SSIS Developer

Responsibilities:

• Involved in development and implementation of SSAS, SSRS and SSIS application solutions for various business units across the organization.
• Designed T-SQL scripts to identify long running queries and blocking sessions
• Writing and Debugging T-SQL, stored procedures, Views and User Defined Functions
• Data migration (import & export - BCP) from Text to SQL Server
• Error handling using Try-Catch Block
• Scheduled Cube Processing from Staging Database Tables using SQL Server Agent.
• Cube Development--Built Cubes with Multi Dimensions and made proper Hierarchy Relationships on Attributes, Made Partitions on Cubes with Aggregates for better Performance.
• Prepared various Reports by using MDX Queries and the Data existed in the Cube for Analysis Purposes of the Organization
• Created Tabular reports, Matrix reports, List & Chart reports, Parameterized reports, Subreports, Ad-hoc reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Design and develop stored MDX queries to support SSRS reports
• Formulated and documented ETL process design based on business requirements and system specifications including source to target mappings, data dictionaries and transformations.
• Responsible for the Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse.
• Developed ETL interfaces using SSIS, Data marts/cubes using SSAS and enterprise reports using SSRS utilizing latest versions (2005/2008/2008 R2) features.
• Generated reports using SQL Server Reporting Services 2005/2008 from OLTP and OLAP data sources.
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.
• Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications.
• Provided knowledge transfer to the company’s SQL programmers.

Environment: SQL server 2008R 2/2008/2005. BIDS 2008/2005, Reporting services 2008/2005, Integration Services2008/ 2005, Analysis Services 2008/2005, XML, MS PowerPoint, MS Project, MS Access 2003 & Windows Server 2003, Oracle, Share Point, MOSS 2010

Confidential, New Jersey, NJ

BI/SSIS/SSRS Developer

Responsibilities:

• Created SSIS packages to clean and load data to data warehouse and package to transfer data between OLTP and OLAP databases.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, 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 ware house.
• Extracted data from XML to SQL server.
• Created SSIS packages for data Importing, Cleansing, and Parsing etc. Extracted, cleaned and validated.
• Created complex queries to automate data profiling process needed to define the structure of the pre staging and staging area.
• Scheduled Cube Processing from Staging Database Tables using SQL Server Agent.
• Generated reports using SQL Server Reporting Services 2005/2008 from OLTP and OLAP data sources.
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications.
• Provided knowledge transfer to the company’s SQL programmers.
• Created several materialized views and UDF’s to be accessed by the new front end applications.
• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases
• Optimized the performance of various SQL scripts, stored procedures and triggers by using embedded UDFs, CTEs and System stored procedures.
• Successfully tested all task in staging and stored all versions of data using team foundation server (TFS).

Environment: SQL server 2008/2005. BIDS 2005, Reporting services 2005, Integration Services 2005, Analysis Services 2005, Windows Server 2003, HealthCare database, DB2, Share point server, TFS.

Confidential

SQL Server/BI Developer

Responsibilities:

• Involved in development and implementation of SSIS, SSAS and SSRS application solutions for various business units across the organization.
• Formulated and documented ETL process design based on business requirements and system specifications including source to target mappings, data dictionaries and transformations.
• Used DTS/SSIS for ETL processes, SSRS for Reporting needs and SSAS for Analytics reporting including Share point/Moss2007 integration.
• Generated the Reports with all the subcategory Information to Business users.
• Interviewed Clients and management to identify additional reporting needs Develop report requirements and specifications to meet Reporting needs.
• Developed and Deployed different types of Reports like List, Drilled Down, Matrix, and Chart and Sub Reports etc.
• Created and Executed the Stored Procedures and Complex Queries for Reports.
• Deployed and Scheduled the Reports in Report Manager. 7
• Used SQL Server Integration Services (SSIS) and its tools to Extract, Transform and Load data into Data Ware House and for OLTP side.
• Extensive use of Import/Export wizard to convert T- SQL Queries, Data and Reports from different forms like XML file, MS Excel file, TTF file, PDF file and other formats to SQL data type and Vice versa.
• Created various complex reports and manage those using SQL Server Reporting Services (SSRS 2008/2005) according to ERLC.
• Involved in migration and Conversion of Reports from SSRS .
• 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 in time restricted environment.
• Highly involved in creating, structuring, formatting using Report Designer and Report Builder.
• Wrote and integrated stored procedures to generate the special reports according to client’s need.

Environment: SQL Server 2005/2008 Enterprise Edition, .Net 3.5,SQL BI Suite (SSAS, SSIS, SSRS), Enterprise manager, PPS, XML, MS PowerPoint, MS Project, MS Access 2003 & Windows Server 2003, Oracle, Share Point, MOSS 2007

Confidential, Seattle, WA

ETL/SSIS Developer

Responsibilities:

• Modification of database object such as addition of triggers, modification of table, stored procedure to meet new customer’s requirements.
• Database performance tuning, monitoring, scalability and Testing.
• This includes optimization of slow running stored procedures, deployment of locking mechanism to increase concurrency.
• Created DTS (SSIS) packages to get data from various sources (mainframe, Informix, Oracle).
• Administer, maintain, develop and implement policies and procedures for ensuring thesecurity and integrity of the department database.
• Performed Weekly Application Builds, including some troubleshooting and debugging of Multi-tier financial applications.
• Automation of monitoring all the failed jobs in the database using DTS (SSIS) and SQL mail.
• Prepared patch and upgrade scripts for service packs and new releases
• Index optimization, Performance, Disk management, Disk partitions and optimizing.
• Worked on locking strategy which is used for various batch Programming structures & Transactions.
• Memory management, data storage, user connections and load balance.
• Prepare and set up environment for disaster recovery.
• Transformation of data from one server to other servers using tools like bulk copy program (BCP), data transformation services, data conversions from legacy systems to SQL server.

Environment: SQL Server 2005, Enterprise Manager, SQL Profiler, Data Model, T-SQL, SQL Query Analyzer, Replication, Backup/ Recovery, DTS/SSIS, Windows 2000/Advanced server.

Confidential

SQL Server Developer

Responsibilities:

• Study and understand the requirements of the information required by company’s Procurement Department about the vendors.
• Designed T-SQL scripts to identify long running queries and blocking sessions
• Writing and Debugging T-SQL, stored procedures, Views and User Defined Functions
• Data migration (import & export - BCP) from Text to SQL Server
• Error handling using Try-Catch Block
• Normalization and De-Normalization of tables
• Developed Backup and Restore scripts for SQL Server 2005
• Installed and Configured SQL Server 2005 with latest service packs.
• Created database objects like tables, views, indexes, stored-procedures, triggers, and user defined functions.
• Written T-SQL queries for the retrieval of the data.
• Developed administrative tasks of SQL Server of performing daily Backups and Recovery procedures.
• Worked with the developing team in the Writing functions in Visual Basic 6.0 for Upload download functionality, Data transfer and migration.

Environment: SQL Server 2000 Enterprise Edition, T-SQL, Enterprise manager, MS Office & Windows 2K platform.