SUMMARY

• 6 years of IT professional experience in Data Warehouse and Business Intelligence in various business domains.
• Extensive experience with different phases of project life cycle (Analysis, Design, Implementation, Testing, and debugging new and existing client - server based applications).
• Hands on Experience with Analysis Services (SSAS), Integration Services (SSIS) and Reporting Services (SSRS).
• Experience with optimizing cube using partitions and aggregations.
• Expert in modeling, Extraction Transform Loading (ETL) using DTS and SSIS 2005 and 2008R2.
• Hands on experience with performing various SSIS data transformation tasks like Look-ups, Fuzzy Look-ups, Conditional Splits and EventHandlers, ErrorHandlers etc.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduled DTS/SSIS Packages.
• Experience in Developing and Extending SSAS Cubes, Dimensions and data source views SSAS-Data Mining Models and Deploying and Processing SSAS objects.
• Thorough understanding of Kimball’s’ theory, KPIs, Perspectives, Translations and SQL 2008R2Architecture.
• Worked in Data modeling, creating star and snowflake schemas in SSAS. Also used tools like Erwin.
• Expert in calculating measures and dimension members using multi dimensional expression (MDX), mathematical formulas, and user-defined functions.
• Expert in generating Drill down and Drill through reports with Drop down menu option, sorting the data, defining subtotals in SSRS 2008R2.
• Proficient in handling parameterized reports in SSRS 2008R2.
• Experience in integrating the SSRS reports into web applications using Report viewer control.
• Experience in Excel pivot services.
• Worked on SQL BI solution integration with Microsoft share point server.
• Worked with report builder tool 3.0/2.0/1.0
• Exposure to source safe, version controlling etc
• Quick learner and good performer both in team and independent job environments.

TECHNICAL SKILLS

Databases: SQL Server 2008/2008 R2, SQL Server 2005, SQL Server 2000/7, Access, Oracle 8i/9i/10g, MySQL, Data warehouse.

Database Tools: SQL Server Management Studio, Performance Monitor, Query Analyzer, Query Optimizer, SQL Profiler, Data Transformation Services (DTS), ETL, Bulk Insert and BCP, ODBC, Business Intelligence Development Studio(BIDS), SQL CMD.

Languages: T-SQL, MDX, C, C++, VB 6.0, PL/SQL, C# 4.0, Shell Scripting, LINQ, ASP.NET, UML, XML, XMLA, MS SharePoint

Reporting Tools: SQL Server Reporting Services (SSRS), Crystal Reports 9.0/8.5,OLAP

Change Management Tool: Tortoise SVN, Visual Source Safe (VSS), Team Foundation Server (TFS)

Operating Systems: Windows Server 2000/2003, 2008, 2008 R2, Windows NT 4.0Windows 7/vista/XP/98/95, MS DOS, Agile, Linux.

PROFESSIONAL EXPERIENCE

Confidential - Farmington Hills, MI

SQL BI Developer (SSIS/SSRS/SSAS)

Responsibilities:

• Involved in complete Software Development Life Cycle (SDLC).
• Designed and developedSSIS Packagesto import and export data fromMS Excel, SQL Server 2005 and Flat files.
• Involved in daily loads (Full & Incremental) into Staging 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 the packages in both the 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.
• Configured the loading of data into slowly changing dimensions using slowly Changing Dimension Wizard. Also implemented checksum SCD method to load the data into date warehouse.
• Developed complex SSAS cubes with multiple fact measures and multiple dimension hierarchies based on the OLAP reporting needs
• Involved in building Data Marts and multi-dimensional models like Star Schema and Snowflake schema.
• Calculated measures and dimension members using multi-dimensional expression (MDX).
• Improved the performance of the cube by creating Attribute Relationships, Partitions, and Aggregations, getting rid of unused attributes and by changing the attribute hierarchy options in SSAS.
• Understanding the OLAP processing for changing and maintaining the Warehousing, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Created reports using stored procedure and Experience in building Reports on Analysis Services cubes (SSAS).
• Advanced extensible reporting skills using SQL Server 2008 Reporting Services (SSRS).
• Developed a High level dashboard using SSRS 2008.
• Developed various types of complex reports like Drill Down, Drill through, Cross tab reports.
• Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2008.
• Involved in designingParameterized Reports and Report Modelsfor generatingAd-Hocreports as per the client requirements.
• Defined Key Performance Indicator metrics to create scorecards.
• Involved in creating report models and applying row level security filters for report model.
• Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non clustered indexes.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Involved in upgrading from SQL Server 2005 to SQL Server 2008.
• Advised optimization of queries by looking at Execution Plan for better tuning of the database.

Environment: SQL Server 2008/2005 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), .Net framework, Microsoft Office Share Point Server, XML, MS Visual Source Safe and Windows Server 2003.

Confidential, Deerfield, IL

SQL BI Developer

Responsibilities:

• Converted Data Transformation Services (DTS) application to SQL Server Integrated Services (SSIS) as assigned.
• Creating reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries.
• Developed DTSX packages to extract, transform and load into the Campaign database from OLTP database using of SQL Server Integration Services (SSIS).
• Experience in Developing and Extending OLAP Cubes, Dimensions and data source view.
• Assisted in production OLAP cubes, wrote queries to produce reports using SQL Server 2005/2008 Analysis Services (SSAS) and Reporting service (SSRS)
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.
• Experience in creating Parameterized reports and Linked reports with thorough knowledge of report serving architecture. (Table, chart and matrix report).
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2008 and in adding calculations using MDX.
• Designed and implemented data mart, facts, dimensions and OLAP cubes using dimensional modeling standards in SQL Server 2005/2008 that maintained data. Involved in the complete data warehouse development life cycle. Actively supported business users for change requests.
• Involved in designing, developing, debugging and testing of reports in SQL Server Reporting Services (SSRS).
• Experience in creating Parameterized reports and Linked reports with thorough knowledge of report serving architecture. (Table, chart and matrix report).
• Involved in creating calculated members, named set, advanced KPI’S for the SSAS cubes.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Created complex Stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.
• Used Joins and sub-queries for complex queries involving multiple tables from different databases
• Daily support of system wide replication tasks including monitoring, alerting, and problem resolution.
• Responsible for documentation of system related activities.
• Worked on PROCLARITY to create OLAP data sets and queries are created directly from the Unified Dimensional Model.
• Actively participated in interacted with users, team lead, DBAs and technical manager to fully understand the requirements of the system.

Environment: MS SQL Server2005/ 2008, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), MS Visual Studio.NET# 2008, TFS (Share Point ), Visual Basic6.0/VB.net, VB Script and Windows 2008 Server.

Confidential, Bellevue, WA

BI Developer (SSRS/SSIS/SSAS)

Responsibilities:

• Created SQL server Reports using SSRS 2008.Identified the data source and defined them to build the data source views
• Involved in the analysis and profiling of source data, creating prototypes and sample reports to help with requirements and design(SSRS)
• Experienced in designing the OLAP systems for data mart applications using SQL Server Analysis Services 2000 & 2005(SSAS)
• Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
• Designed Data flows, Workflows and jobs to load data from source to target in BO Data Integrator.
• Enhancing and deploying the SSIS packages from development server to production server.
• Designed and built OLAP cubes to meet reporting needs. Performed Documentation for all kinds of reports and DTS and SSIS packages.
• Designed Cubes with Star Schema using SQL Server Analysis Services 2008 (SSAS).
• Created several Dashboards and Scorecards with Key Performance Indicators (KPI) in SQL Server 2005 Analysis Services (SSAS).
• Understanding OLAP process for changing and maintaining the Warehouse, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Created Packages in SSIS with error handling.
• Used various ETL tools like SSIS/DTS for data flow from source files like XML, Excel, Tables and views to other databases or files with proper mapping.
• Created reports in SSRS with different type of properties like chart controls, filters, Interactive Sorting, SQL parameters etc
• Created Time Dimensions on OLAP Cubes using SSAS.
• Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2005 to MS SQL 2008 as well as Created interface stored procedures used in SSIS to load/transform data to the database.
• Extensively used T-SQL in constructing User defined Functions, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity.
• Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.
• Worked with Technical Architects and Database analysts for the Design of Summary tables required for efficient Report Design
• Experience in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.
• Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development
• Extensively involved in the SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Developing reports using MDX and SQL.

Environment: MS SQL Server 2008 and 2005, T-SQL, SSRS, SSAS, SSIS Packages, SSRS,ETL, ODBC, Erwin, ASP.Net 3.0, Ado.Net 3.0, C#.Net, Excel, Business, Business Objects Data Integrator 6.5, SharePoint Server, MDX, ProClarity, OLAP, OLTP, DB2, Access, Windows 2003 Server, IIS 6.0.

Confidential, CA

SQL BI Developer

Responsibilities:

• Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Designed and tested (Unit, Integration and Regression) packages to extract, transform and load data using SQL Server Integration Services (SSIS).
• Transferred data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat files, CSV files into SQL Server 2008.
• Designed packages which utilized tasks and transformations such as Execute SQL Task, Execute Process Task, Send Mail Task, FTP task, Execute Package task, Xml Task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate, Expression, OLE DB Command, and Derived Column.
• Developed error handling routines for packages using both script tasks as well as in the error handling environment.
• Created a number of cubes, dimensions and business critical KPIs using SQL Server Analysis Services (SSAS) representing aggregations in several different ways - hierarchically and using custom groupings that the company will use to analyze performance.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Created calculated measures, dimension members using MDX, mathematical formulas and user defined functions, named calculations using SSAS for generation of cubes.
• Implemented various notifications based upon the scheduling jobs, database monitoring, disaster recovery plans and wrote windows scripting scripts for automation of the tasks.
• Developed reports by using SSRS and deployed them on web pages using ASP.NET using C#.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS.
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration.
• Responsible for creating parameterized, cascading, configuration, drill down, rollup reports using SSRS and deploying them into server using report builder.
• Developed stored procedures, user-defined functions, triggers, indexes, cursors and views in SQL Server, DB2 databases.
• Developed processes, automation of maintenance jobs, tuning SQL Server, data validations, locks and indexes configurations.
• Worked on Performance tuning of ETL transformations, data validations and Stored Procedures.
• Tuned several slow running queries in Production. Implemented Indexes and re-indexed to achieve time performance.
• Extensive Experience in Migrating Database from SQL Server and .
• Administered SQL Server security, SQL Server automatic e-mail notification and SQL Server backup strategy and automation.

Environment: Microsoft SQL Server 2000/2005/2008 Enterprise Edition, MS Access, ETL Packages(SSIS), SQL Server Analysis Services(SSAS), MDX, .Net, VB.Net, HTML, IIS, Visual Studio, Visual Source Safe, DTS, T-SQL, Oracle 10g.

Confidential

SQL Developer

Responsibilities:

• Created and developed the stored procedures, triggers to handle complex business rules, history data and audit analysis.
• Developed and created data dictionary, stored procedures, advanced queries, triggers, views, indices, and functions for databases.
• Wrote database triggers in T-SQL to check the referential integrity of the database.
• Created the MS DTS packages for executing the required tasks. Created the Jobs and scheduled for daily running.
• Created reports from database onto excel spread sheet using DTS.
• Involved in database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler, SQL Analyzer, and SQL Enterprise Manager.
• Involved in creating maintenance plans in SQL Agent to backup the database.
• Involved in creating Users and Roles, and managing security and permission of database, managing Jobs and error logs.
• Worked with development teams in the design of physical databases and in modification.
• Involved in analyzing MS SQL server (storage, memory, processing) and their dependencies/performance bottlenecks.

Environment: SQL Server 2005, Windows Enterprise Server 2003, Windows SharePoint Service 2.0, IIS 6, Visual Source Safe 2003, Crystal Report 10, Crystal Enterprise 10, Microsoft Visio 2000