SUMMARY

• Over 7+ years of experience in Business Intelligence Using MS SQL Server 2008/2005/2012 , Teradata and Oracle
• Expert in developing Cubes on SSAS using SQL Server 2008/2005/2000.
• Strong knowledge of Teradata RDBMS Architecture, ETL Tools and Utilities
• Exploited power of Teradata to solve complex business problems by data analysis on a large set of data.
• Expertise in design and development of Web applications, Windows applications and XML Web Services using .Net Framework (1.1/2.0), ASP.NET (1.1, 2.0), VB.NET, C#, ADO.NET, .NET Security,XML.
• Experience in creating partitions and designed various storage modes to increase the performance of cubes using SQL Server Analysis Services 2008/2005/2000 (SSAS)
• Built Fast Load & Export scripts to load data into Teradata and extract data from Teradata
• Developed BTEQ scripts for Teradata.
• Used Teradata to write Stored Procedures, functions triggers.
• Experience in data warehouse environment, including all dimension and fact tables
• Expert in calculating measures and dimension members using Multi Dimensional Expression (MDX)
• Performed complex SQL, PL/SQL procedures and MDX Queries and generated reports.
• Experienced working on OLAP database development including KPIs, Data Mining.
• Expertise in designing complex reports like Dashboard Reports, Drill - Down Reports, Parameterized Reports, Cascaded Reports and Sub Reports using SQL Server Reporting Services 2008/2005/2000 (SSRS) based on client requirement.
• Expert in deploying the SSRS reports on Report Server.
• Used Teradata SQL Assistant as a guy for writing SQL scripts.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using SQL Server Integration Services 2008/2005/2000 (SSIS).
• Expert in creating complex Stored Procedures, User Defined Functions, DDL/DML Triggers, Views, Cursors and Indexes to facilitate efficient data manipulation and data integrity in Teradata.
• Experience in writing complex queries in Oracle inner, outer and cross joins in TOAD/SQL Navigator
• Experience in designing logical and physical data models using ERWIN and ER/Studio tools.
• Good knowledge in Normalizing and De-normalizing the tables and maintaining Referential Integrity.
• A Team-Player with motivation and ability to work independently, Worked closely with the Case Teams, Business Analysts and Data Analysts and Functional Design Teams
• Good communication and written skills and can handle multiple projects simultaneously.

TECHNICAL SKILLS

Operating System: UNIX, Windows 7/Vista/XP/2003/2000, Windows Server 2003, Windows NT and MS-DOS.

Programming Languages: C, T-SQL, C#, VB.Net, ASP.Net.

Web Technologies: HTML, XML, PHP, WCF.

RDBMS: Teradata, SQL Server 2008R2/2005/2000, Oracle 11/10g/9i

BI Tools: SSAS, SSRS, SSIS, Crystal Reports, Business Objects, MS Excel Power Pivot, MDX, SharePoint, Performance point

Data Modeling Tools: MS-Visio, Erwin 7.2/4.5, Visual Studio 2005/2008.

Database Query Tools: SQL Server Management Studio, Business Intelligence Development Studio, SQL Server Query Analyzer, SQL Profiler.

Version Management Tools: VSS, PVCS, TFS, Subversion.

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

MS BI Developer SSAS/Teradata/SharePoint

Responsibilities:

• Principle responsibility is to solve complex business problems by designing, implementing, maintaining and monitoring multi dimensional cubes using SQL Server Analysis Services (SSAS).
• Developed Web forms in ASP.net with VB.net and C#.
• Designed MOLAP cubes making use of Star and Snowflake Schemas.
• Customization of a third party tool that was used for developing the application.
• Interacted with end-users in requirement gathering sessions, use case analysis, report layout design.
• Used Calculated Member Builder to create custom measures.
• Designed and developed SQL Server Integration Services 2008/2005/2000 SSIS Packages to automate the cube processing.
• Deploying cubes and reporting services reports to Production servers generated by the offshore team.
• Writing SQL Server Stored procedures/complex queries to retrieve data from Teradata
• Writing MDX queries to generate OLAP reports.
• Created various complex reports like Dashboard, Drill Through, parameterized reports, Matrix and chart reports according to user specifications.
• Scheduled the Reports to run on daily and weekly basis in Report Manager and also emailing them to end users and analysts to be reviewed in Excel Sheets.
• Writing SSIS packages to load data into Facts and confirmed dim tables to build cubes.
• Extensively worked with SQL Server Integration Services 2008/2005/2000 SSIS to created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Multicast and Derived Column
• Created Database Objects - Schemas, Tables, Indexes, Views, User defined functions, Triggers, Stored Procedure, and Constraints.
• Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.

Environment: Visual Studio 2008, SSAS,SSRS, SSIS, Teradata, windows server 2005, oracle, Power Pivot, SharePoint

Confidential, San Diego,CA

BI Developer /SSRS/SSAS/Oracle/Teradata/SharePoint

Responsibilities:

• Worked as part of a team for gathering and analyzing Business Requirements and prepared business requirement documents (BRD).
• Participated actively in designing the system database structure
• Designed cubes with star schema using SQL Server Analysis Services2008/2005 (SSAS) and deploying cubes to production
• Developing OLAP cubes for migrating existing reports onto this new platform.
• Experience in writing complex MDX queries for calculated members and measure groups
• Responsible for stylish design layout like Pie charts, Graphs and Linked Reports
• Played a major role in production support of SQL Server Analysis Services 2008/2005(SSAS) (cube refresh), SSIS jobs
• Involved in writing MDX queries and performance optimization of the SQL Server Analysis Services 2008/2005(SSAS) cubes
• Created complex PL/SQL Stored Procedures, triggers, cursors, tables, views and other SQL joins for applications by using T-SQL.
• Created dimension tables in Teradata to fit our reporting needs.
• Responsible to created views with multiple Facts and dimension tables in Teradata for building cubes.
• Tuned lots of Teradata queries used in SSRS/Crystal reports to improve the performance.
• Microsoft TFS has been used for code versions and integrity, I was the admin to creating new users and integrating the code
• Developed reports using SSRS 2005 and used table control, matrix control for cross tab reports
• Responsible for creating SQL Server Drill down and Drill through Reports using SSRS to fit business requirements, and implemented into SQL Server 2005.
• Involved in developing a web application using .NET framework and SQL server 2005

Environment: SQL Server 2005 SSIS, SSAS, SSRS, Teradata, Oracle, Visual Studio 2005, Windows Enterprise Server 2003, ADO.NET, Visual Source Safe, XML, HTML, Erwin.

Confidential, Iselin NJ

SQL Developer/SSIS/SSRS

Responsibilities:

• Created dynamic and customized packages to support future changes. Scheduled the same packages by creating the corresponding job tasks.
• Submit a Weekly Status Report to the offshore Project Manager
• Import/Export and successfully migrated the Databases such as Oracle, DB2, ERP (Navision) and MS Access to SQL Server 2005 using SSIS.
• Worked on the script components in SSIS using VB script for getting latest files and ETL logging areas.
• Created Configuration files with XML documents to support the SSIS packages in different environments.
• Created complex TSQL batches / stored procedures, Optimized existing queries and stored procedures.
• Defined check constraints, functions, indexes, synonyms and views.
• Experience in designing reports for the end user using SQL Server Reporting Services (SSRS) and creating multiple operational Drill-through and Drill-down, parameterized, cascaded, Matrix type reports and Charts using SSRS.
• Deployment and maintenance of various SSRS Reports in SQL Server 2005.
• ScheduledReports to run thereports hourly, daily, monthly accordingto client requirements for the periodic analysis.
• Created XML, PDF, EXCEL files using SSRS.
• Optimized the existing queries to improve performance using SQL Profiler tools.
• Designed and developer SSRS security architecture using Role based security model provided in SSRS 2008.
• Involved in Analyzing, designing, building &, testing of OLAP cubes for GameStop Merchandising with
• Documented all the project work in support for maintenance.

Environment: Server 2000/2005 Enterprise, BIDS, MSMS, Microsoft Reporting Service (SSRS), SQL Server Integration Services (SSIS), SSAS, Enterprise Manager, Microsoft office share point portal server 2003 .NET, C#, ASP.NET, Red gate.

Confidential, Gold Canyon, AZ

SQL BI Developer SSIS/SSRS/SSAS

Responsibilities:

• Used Joins, correlated and non correlated sub-queries for complex business queries involving multiple tables from different databases.
• Migrated legacy database and spreadsheets (Access/Excel) to SQL Server 2000 using Data Transformation Services (DTS) and T-SQL scripts.
• Wrote several SQL Scripts such us finding tables that have Identity Columns, finding tables that do not have primary key.
• Designed SQL SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server, transform and load it into destination.
• Automated the SSIS jobs in SQL scheduler as SQL server agent job for daily, weekly and monthly loads.
• Design and develop SSIS packages, store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance.
• Created Ad-Hoc Reports, Summary Reports, Sub Reports, and Drill-down Reports using SSRS.
• 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).
• Proven ability in generating Drill down and Drill through reports with Drop down menu option, sorting the data, defining subtotals in SSRS 2005.
• Created Parameterized reports and Linked reports and thorough knowledge of report serving architecture using SSRS.
• Designed and implemented Disaster Recovery Procedures like Log Shipping and mirroring between production and DR servers.
• Extensively involved in replication and implemented Snapshot, Merge and Transactional Replications.
• Analyzing the Performance of a Cube by partitioning it and creating Perspective Cubes.
• 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 MOLAP Warehouse on SQL 2008 Server Analysis Services and created cubes with dimensions and facts
• Analyzing the Performance of a Cube by partitioning it and creating Perspective Cubes
• Effectively worked on Facts, Dimensions, and Cubes and wrote MDX queries using MS Analysis Services (SSAS).

Environment: s: MS SQL Server 2005/2008, Server Integration Services, SQL Server Reporting Services, SQL Server Analysis Services, ASP.NET, XML, Windows 2003 Server, MS VISIO, ERW

Confidential

SQL Developer/SSIS

Responsibilities:

• Configured SQL Server Environment.
• Created DTS packages to copy tables, schemas and views and to extract data from Excel using SSIS.
• Transformed data from various data sources using OLE DB connection by creating various DTS packages.
• Used BCP command line utility to replicate a database.
• Designed Entity-Relationship diagrams and thus the database schema
• Involved in the development of a normalized database using Data Definition Language (DDL) in T-SQL.
• Performed job scheduling in the SQL Server Environment.
• Used Data Modification Language (DML) to insert and update data, satisfying the referential integrity constraints and ACID properties.
• Developed stored procedures, triggers, row level audit tables in SQL Server.
• Developed cursors and views to improve performance in data transactions.

Environment: MS SQL Server 2000/05, MS SQL Enterprise Manager, SSIS, DTS, T-SQL, and Windows NT.

Confidential

SQL Server Developer/DBA

Responsibilities:

• Created and developed the stored procedures, triggers to handle business rules, historical data and audit analysis.
• Conducted database management, performance measurement and tuning for new and existing databases by using SQL Profiler, SQL Analyzer, and SQL Enterprise Manager.
• Conducted logical and physical database design including data modeling, maintenance, problem diagnosis and resolution.
• Created and administered multiple development, training and production databases.
• Developed and created data dictionary, stored procedures, advanced queries, triggers, views, indices, and functions for databases.
• Maintained databases, performed software installations and upgrades, monitored database performance, performed capacity planning and SQL Server clustering, managed database quality assurance including database consistency check.
• Responsible for creating standards and operating procedures to maintain all databases.
• Worked with development teams in the design of physical databases and in modification.

Environment: MS SQL Server 2000, T-SQL, SQL Server Enterprise Manager, SQL Profiler, Excel, Data Import, DBMS, C.