PROFESSIONAL SUMMARY:

• Microsoft Certified Business Intelligence Developer with 7+ years of IT experience in development, analysis, design, testing, presentation and implementation experience using SQL Server 2012/2008R2/2008/2005,Oracle11g/10g/9i and SQL Server Data tools.
• Very good hands - on experience in development and implementation of Data Warehouse applications.
• Involved in all the stages of Software Development Life Cycle mainly in Database design, data access and development using MS SQL Server 2012/2008R2/2008,Oracle 11g/10g and Web Applications development.
• Extensive experience in designing, developing, and delivering business intelligence solutions using
• Strong data base experience in Oracle, SQL Server 2000, DB2 and Sybase.
• SQL Server Data tools or SQL Server Integration Services (SSIS) and Reporting Services (SSRS).
• Strong SQL development skills including writing Stored Procedures, Triggers, Views, and User Defined functions.
• Expert in creating objects like Indexed Views, complex Stored Procedures, effective functions, and appropriate Triggers to facilitate efficient data manipulation and data consistency.
• Experience in developing the applications usingT-SQL Programming (DDL, DML, and DCL).
• Conversant with various phases of Software Development life cycle (SDLC) including development, designing, analysis, coding, testing and implementation.
• Knowledge on integration of BI suite of products with Microsoft Office range of products like MOSS (SharePoint), Business Scorecard Manager, Dashboards, Performance Point Server.
• Expertise in creating Dashboards, Metrics, Rules and Goals, corporate/personal dashboards, Alerts.
• Experience with working on ProClarity Analytics server to analyze results produced in the Dashboard.
• Expertise in Extract, Transform and Load (ETL) using SSIS and various tools including Bulk insert, BCP, Import Export data, DTS packages and SQL Server Integration Analyzed, designed and developed for a Data Warehousing and Data Migrations.
• Experience in building Data Integration, Workflow Solutions and Extract, Transform and Load (ETL) solutions for data warehousing using SQL Server Integration Service (SSIS).
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like Tabular, Matrix, Drill Down, Drill Through and web reporting by customizing URL Access.
• Experience in Data Warehouse Modeling with SQL Server Analysis Service (SSAS).
• Experienced in creating Transformations and Mappings using Informatica Power center, Designer and processing tasks using Workflow Manager to apply business logics and to move data from multiple sources into targets
• Creating the Cubes and Dimensions building, deploying, processing and maintaining Cubes using SQL Server Analysis Services (SSAS).
• Expertise in creating cubes with dimensions and facts tables in MOLAP Warehouse using SQL Server Analysis Services (SSAS).
• Designed and developed Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snowflake Schema for developing Cubes using MDX in SSAS.
• Development Projects in SQL Server and Microsoft.Net.
• Hands on experience in debugging an application using debugging tools provided by the Visual Studio.Net IDE.
• Worked extensively with Data Adapter, Dataset, Data reader as a part of ADO.NET and LINQ (Language Integrated Query) to access and update database.
• Experience in using Data Modeling Tools like Erwin, MS access and Microsoft Visio.
• Experience in Dimensional Modeling, ER Modeling, Star Schema / Snowflake Schema, FACT and Dimensional Tables and Operational Data Store (ODS).
• Excellent Communication and interpersonal skills and strong ability and experience in seeking solutions effectively and aggressively in challenging environment.

TECHNICAL SKILLS:

Operating Systems: Windows Vista Business / XP Pro. / 2003 / NT / 9.X

Programming: C#. Net, VB.Net, ASP, C, C++, ADO.NET, XML

Scripting Language: Java Script, VB Script, HTML, XML

Databases: SQL Server 2012/2008 R 2/2008/2005/2000 , PL/SQL, Oracle 11g/8.0i, DB2 MS Access 2000/8.0. teradata.

SQL Server Tools: SQL Server Management Studio, Enterprise Manager, Query Analyzer, SQL Profiler, Data Base Engine Tuning Advisor, Enterprise Manager, Import and Export Data wizard, SQL Server Business Development studio (BIDS).

ETL Tools: SQL Server Integration services (SSIS) 2005 and 2008, Data Transformation Services (DTS)

Analytical Tools: SQL server Analysis Service (SSAS), Performance Point Server 2007.

Reporting Tools: SQL server Reporting Services (SSRS), Crystal Reports, Business Objects, OBIEE

Data Modeling Tools: Erwin, Visio, MS Access

Data Warehousing ETL tools: Informatica Power Center 8 .X,7.X, Talend 4.2.x/5.1.2

Visualization Tools: Tableau 8.1/8.0/7/0

Web server technology: IIS

Other Tools: MS Office, Crystal Reports XI, Microsoft Business Intelligence Studio, Service Oriented Architecture (SOA) SQL Server Notification Services, Visual web developer, MS FrontPage, Windows Scripting Host

Hardware: EMC DMX & IBM Fast T 700 Storage Area Network (SAN), Compaq Proliant 8000, 6500, 6000

PROFESSIONAL EXPERIENCE:

Confidential, Virginia Beach, VA

SQL BI developer(SSAS/SSIS/T-SQL)

Responsibilities:

• Created SSIS Packages using SSIS Designer for importing heterogeneous data from OLEDB Sources, Excel Spreadsheet, text files into Data Warehouse.
• Various ETL Transformation tools were used for Control Flow and Data Flow tasks.
• Experienced in creating reports (SSRS) in Drill mode using tables, matrix and charts in SQL SERVER 2008.
• Designed and implemented Parameterized and cascading parameterized reports using SSRS.
• Created star schema in SSAS and developed SSRS reports based on the cube.
• Assisted in production OLAP cubes, wrote queries to produce reports using SQL Server 2005/2008 Analysis Services (SSAS) and Reporting service (SSRS).
• Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.
• Backing up, restoring system & other databases as per requirements, and also scheduled those backups.
• Developing stored procedures, triggers, views, and adding/changing tables for data load and transformation, and data extraction.
• UsedSSISto create ETL packages to Validate, Extract, Transform and Load data to Transaction and Data
• Creating complex SSIS packages using proper control and data flow elements.
• Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, Oracle, DB2etc) and then loaded the data into destination tables by performing different kinds of transformations using SSIS packages.
• Created packages in SSIS with error handling and worked with different methods of logging in SSIS.
• Created custom data flow items for different SSIS packages using the VB.Net script.
• Troubleshooting and fixing Bugs/issues in the enterprise level web application using C#.NET, ADO.NET, ASP.NET.
• Involved in writing queries for Stored procedures, clustered and non-clustered indexes.
• Created List reports, cross tab reports, charts, sectional reports, & Drill through reports by using Report studio.
• Involved with business and functional people to collect and gather requirements
• Implemented Mock report layouts before the actual report implementation.
• Creating value prompts, Date & time prompts, Text box prompts, cascading prompts.
• Hide and Show the objects by using conditional blocks.
• Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.

Environment: MS SQL Server 2008, Management Studio, Windows XP Server, MS Excel, MS Access, Text Pad, text editor, C#.NET, ADO.NET, ASP.NET 3.5, VB.Net, MS Visio 2005, DTS, SQL Query Analyzer, Tera Data SQL Developer, SSIS/SSRS/SSAS.

Confidential, NY

SQL Server/BI Developer

Responsibilities:

• Worked with Business Analysts to understand the requirements.
• Analyze different business requirements and provide time estimate for all SDLC phases (Analysis, Design, Coding, Implementation, SIT, UAT, and Production Move)
• Perform ETL processes using SSIS tool for SQL Server.
• Used Informatica Power Center for extraction, transformation and loading (ETL) of source data on heterogeneous Database sources like Oracle, SQL Server & flat files.
• Designed and developed a number of complex mappings using various transformations like Source Qualifier, Aggregator, Router, Joiner, Union, Expression, Lookup (Connected & unconnected), Filter, Update Strategy, Stored Procedure, Sequence Generator and used reusable transformations as well as mapplets, and Schedule jobs.
• Design/Develop complex queries efficiently as per the given business requirements.
• Created database fact/dimension tables, views, stored procedures, functions and triggers as required.
• Worked on Table Partitioning to load current and historical data.
• Worked with Business users to understand the Business Logics as per the need.
• Worked with Financial data to calculate Comp.
• Transferred data from various data sources/business systems including MS Excel, MS Access, Flat Files, COSMOS etc. to SQL Server usingSSIS/DTS using various features like data conversion etc
• Develop views, sub-queries and joins for complex queries involving multiple tables Created joins and sub-queries for complex queries involving multiple tables.
• Used various transformation tasks to create ETL packages for data conversion.
• Loaded flat files data into database using SQL Server Integration Services (SSIS) after applying various transformations like Lookup, Merge join, Aggregation, Derived column, Data Conversion, Script Task etc.
• Implemented changes in Cubes (SSAS) as per the requirement.
• Created a cube in existing system and their respective Facts and Dimensions, Relationship and Partitioning.
• Worked with SSAS cubes using multiple dimensions, perspectives, hierarchies, measures groups to analyze performance of System.
• Developed complex SSAS cubes with multiple fact measures and multiple dimension hierarchies based on the OLAP reporting needs.
• Created Transact-SQL (stored procedures, views, triggers, sub-queries, joins)
• Generated reports using SQL server reporting services (SSRS)
• Scheduled Jobs and Alerting using SQL Server Agent.
• Design/Develop Test Plans, Test Cases and documentation of various processes involved.
• Implemented Custom Logging, Auditing and Custom Email Notifications using SSIS 2008.
• Worked with DBAs in order to schedule SSIS packages as jobs either daily, monthly, yearly or ad-hoc.
• Enhanced performance using optimization techniques like normalization, indexing and monitoring logs to ensure the completeness of batch processes, Scripts and processes.
• Responsible for maintaining and supporting production databases.
• Created standard report subscriptions.
• Created report snapshots and cache for better performance.
• Developed and rendered monthly, weekly and daily reports as per the requirement and gave roles, user access with respect to security in Report Manager.
• Perform /coordinated end to end Migration process in TEST /PROD ENV.
• Created C#.Net Script for Data Flow task to fetch data from server and load it into database through Script component.
• Deployed and processed SSAS cubes daily/Weekly to update information using SQL Server Agent.
• Increased the performance necessary for statistical reporting after performance monitoring, tuning and optimizing indexes.

Environment: SSIS/SSRS/SSAS, SQL Server 2008, Microsoft Visual Stuidio.NET 2008, VB.NET Query Analyzer, Tera Data Windows 7, Team Foundation Server (TFS) NET Framework 2.0.

Confidential, Reston, VA

SQL BI Developer

Responsibilities:

• Created Tablix Reports, Matrix Reports and Parameterized Reports and Sub reports using SQL Server Reporting Services 2008.
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports
• Involved in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.
• Involved in writing MDX queries and performance optimization of the SSAS cubes.
• Experience in writing complex MDX queries for calculated members and measure groups.
• Experience in building Reports on Analysis Services cubes.
• Created reports using stored procedure. Involved in scheduling, creating snapshots and subscriptions for the reports. (SSRS 2005/2008 R2).
• Extensively involved in the SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL
• Extract Transform Load (ETL) development using SQL Server 2005, SQL 2008 R2 Integration Services (SSIS).
• Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
• Hands on experience in using different transformations like fuzzy lookup, derived column transformation etc using SSIS.
• Generated Reports using Global Variables, Expressions and Functions for the reports in SSRS.
• Responsible for scheduling the subscription reports with Data Driven Subscription Windows File share and Email Delivery using SSRS.
• Generated various Drill-through reports, parameterized reports, sub-reports and linked reports using SSRS and integrated into the web front end.
• Experience in Reviewing Cube with End user and changing the cube and documentation according to their requirements.

Environment: SQL Server 2005/2008 R2, SSAS, SSIS, T-SQL, SSRS, Oracle 9i, Performance Point Server 2007, .Net framework, Microsoft Visual Stuidio.NET 2008, C#.NET, VB.NET, Windows Server 2008.

Confidential

SQL Developer/SQL Server DBA

Responsibilities:

• Assisted clients with physical database modeling, data archiving strategies, data purges and disaster recovery planning.
• Development of automated daily, weekly and monthly system maintenance tasks such as database backup, replication verification, database integrity verification, indexing and statistics updates.
• Creating and managing schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements and converting them into technical specifications
• Created complex stored procedures and functions to support efficient data storage, Archiving, Purging and manipulation.
• Involved in Administration of the SQL Server by creating users & login ids with appropriate roles & grant privileges to users.
• Involved in writing T-SQL statements for retrieval of data.
• Worked on performance tuning of T-SQL queries and Stored Procedures. Optimized query performance by creating indexes.
• Performed daily database backup & restoration, monitored the performance of the Server.
• Tuned the SQL queries using SQL profiler. Involved in tuning the database. Created necessary indexes to make data retrieval process faster.
• Designed and developed tables, view, stored procedures and triggers in MS SQL Server database on Windows NT platform.
• Designed and developed reports using Crystal Reports

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

Confidential

SQL Server 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: MS SQL Server 2000, Windows server 2003, Enterprise Manager, MS Access, MS Excel, MS Word, Windows 98/NT/2000, T-SQL, DTS, Query Analyzer, SQL Profiler, Crystal Reports.