SUMMARY

• 6 years of experience in software development using Microsoft SQL Server and BI Suite.
• Knowledge of full life cycle project development, data warehousing, business analysis, and data modeling.
• Experience in ETL - Data Extraction, Transformation, Loading with Oracle, Access and SQL Server using - DTS/SSIS. Experience in Import and Export Wizard, Package Installation, and SSIS Package Designer.
• Experience on evaluating existing DTS packages on SQL 2000 and upgrading them to SQL Server 2005 SSIS packages.
• Expertise in developing Reports using SSRS and handling sub reports, defining Complex Queries, designing scorecards using SSRS 2005/2008/R2.
• Expert in designing report layout and defining Query for generating drill down reports in SSRS 2005/2008.
• Expert in handling parameterized reports in SSRS 2005/2008.
• Proficient in Data warehousing and SSAS skills: OLTP, OLAP, Relational and dimensional modeling skills (star schema and snowflake schema).
• Experienced in design of logical and physical data modeling using Erwin data modeling tool.
• Extensive experience with SQL Server and T-SQL in creating tables, views and indexes.
• Experience in creating T-SQL Queries, MDX queries, Cubes, Stored Procedures, user defined functions and triggers.
• Knowledge in Data warehousing skills: OLTP, OLAP, Relational and dimensional modeling skills (star schema and snowflake schema).
• Well-versed with database Installation, configuration, maintenance, monitoring, backups and recoveries.
• Experience in using Execution Plan, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning MS SQL Server.
• Knowledge in ASP.NET, Web Forms, C#, Windows Forms, ADO.NET.
• Team player and self-starter with ability to work independently or part of a team.
• Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills and possesses strong analytical skills.

TECHNICAL SKILLS

Operating Systems: Windows, Windows server 2003

Languages: C#, Visual Basic 6.0, VB.NET,VB Script, T-SQL, MDX, PL/SQL

Databases\Data: Access SQL Server 2000/2005/2008/ R2, SQL Integration Services 2005/2008 SQL Reporting Services 2005/2008/R2 SQL Analysis Services 2005/2008/R2,ODBC,MS Access

Tools: and Utilities Visual Studio.NET, Automate, TFS,CCAT, Cognos, ERWIN, Visio

MS Front: Page, Dundas Charts, TIDAL

.NET Technologies: ASP.NET, ADO.NET, XML, HTML, XSL

Application Servers: IIS 5.0/IIS 6.0,Web Services

PROFESSIONAL EXPERIENCE

MS SQL Server/BI Developer

Confidential, Omaha, NE

Responsibilities:

• Gathered and Analyzed Report Requirements from the users and created Technical Specification Documents.
• Created various parameterized reports using SQL Server Reporting Services (SSRS 2008/R2).
• Created Drill-Down reports, Drill-Through Reports, Sub-Reports and Linked Reports.
• Used SQL queries, Stored Procedures and cubes as data sources for the reports.
• Wrote stored procedures and complex queries, sub-queries and joins as per the business requirements.
• Used table control, matrix control for cross tab reports. Built and deployed Reports in Report Manager.
• Created SSAS Cubes and wrote various MDX queries.
• Increased the performance of the reports by tuning the performance of the queries.
• Formatted the reports using Global variables, custom formats and expressions.
• Wrote and executed complex T-SQL queries using SQL Server Management Studio for back end data validation testing.
• Used CTE’s and many other features in SQL Server to optimize the stored procedures.
• Automated reports using TIDAL Enterprise Scheduler.
• Migrated various SSRS reports, Stored Procedures from Development Server to Production Server using Change Control.
• Participated in BI Technical meetings, weekly standup meetings and code review meetings.

Environment: Visual Studio 2008/R2, SQL Server 2008/R2, SQL Server Reporting Services 2008/R2, SQL Server Analysis Services 2008/R2, CCAT, TFS, TIDAL

MS SQL Server/ BI Developer

Confidential, Canandaigua, NY

Responsibilities:

• Prepared Technical Specification Document, Entity-Relationship Diagrams, High level diagrams and Process Flow Diagrams.
• Created the Packages based on mapping document to build dimension tables in the Data Warehouse using SQL Server Integration Services (SSIS).
• Used various Data Flow Tasks like Lookup, Derived Column, Conditional Split, Aggregate, Data Conversion and OLE DB Command.
• Used various Control Flow Tasks like Execute Sql Task, Send Mail Task and Sequence Container tasks.
• Exported and Imported datafrom other data sources likeflat files using Import/Export Wizard through SSIS.
• Performance tuned a Stored Procedure and reduced the time of execution from three hours to eleven minutes using CTE (Common Table Expression).
• Created Tables, Views, Stored Procedures, Functions and Triggers in databases.
• Scheduled SQL Server Jobs to run various stored procedures and SSIS Packages and monitored them to load data correctly.
• Migrated various database objects like Tables, Stored Procedures, SSIS Packages from Development Server to Test Server and then to Production Server using Go Scripts.
• Prepared Test Case Documents, wrote Test Cases and documented the Test results.
• Resolved Team Track issues related to various projects submitted by the Data Warehouse team.
• Analyzed and solved the issues related to missing data in Cognos Reports in Business perspective.
• Followed various techniques and methods for fast execution of SSIS Packages and Stored Procedures.
• Participated in Database Checkpoint meetings, weekly status meetings and Review meetings.

Environment: SQL Server 2005, SQL Server Integration Services 2005, T-SQL, Cognos, Oracle11g, MS Visio, ER Studio

MS BI Developer

Confidential, NY

Responsibilities:

• Worked with Business analysts for requirement gathering, business analysis, and testing and project- coordination. Researched Sources and identified necessary Business Components for Analysis.
• Analyzed source data and gathered requirements from the business users.
• Created SSIS packages to extract data from Oracle Database and Flat files and load the data into SQL Server 2005 database.
• Developed new mappings using Look Up/Aggregation transformations to match the needs of the business case and performed data conversion tasks.
• Created configuration files for the packages for easy deployment from one environment to the other.
• Scheduled SQL Server Agent jobs to run the packages which update the data in the tables periodically that are used in reports.
• Created Drill-down and parameterized reports in SSRS 2005.
• Used Report Catalog to store the Configuration, Security and Caching Information for the Operation of the Report Server.
• Designed and implemented stored procedures and triggers for automating tasks.
• Created Databases, Tables, Views, and Indexes and wrote complex stored procedures, queries, triggers and transactions.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Involved in Unit testing, which involves writing test conditions for all possible cases, creating test data, recording expected/actual results.
• Migrated the whole project from development environment to production environment.
• Provided to users to get familiar with reporting functionalities.

Environment: SQL Server 2005, SQL Server Integration Services 2005, SQL Server Reporting Services 2005, Oracle9i, Windows Server 2003

MS BI Developer

Confidential, Troy, MI

Responsibilities:

• Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect on the development of logical data models.
• Used SQL Server Integration Services as ETL tool to load data to OLAP servers and responsible for scheduling of jobs to load previous business data into OLAP Reporting Databases.
• Developed, monitored and deployed SSIS packages.
• Implemented SSIS data transformation scripts, created maintenance procedures and provided data integrity strategies.
• Administered and enhanced SQL Server Integration Services (SSIS) data loads.
• Designed and created various kinds of reports based on the analysis of gathered user requirements using SQL Server Reporting Services 2005.
• Identified the database tables for defining the queries for the reports.
• Wrote the queries for the drill down reports.
• Identified and added the report parameters.
• Formatted the reports using the Global variables and expressions.
• Deployed the generated reports on to the server.
• Actively involved in creation of database, Importing Data, modified tables and store procedures to clean and validate the data so as to meet the company specifications.
• Created views as per design needs.
• Wrote T-SQL statements for retrieval of data and Involved in performance tuning of T-SQL queries and Stored Procedures.
• Monitored performance and optimized SQL queries for maximum efficiency.
• Supported the front application developers for queries for development hierarchies, file upload and validations using ASP. Net.
• Maintained data integrity by performing validation checks.
• Involved in Fine-tuning of database objects and server to ensure efficient data retrieval.

Environment: SQL Server 2005, SQL Server Integration/Reporting Services 2005, ASP.NET, ADO.NET, Erwin

MS SQL Server Developer

Confidential, Plymouth, MN

Responsibilities:

• Developed Schemas for business applications with providing full-life cycle architectural guidance and ensured quality technical deliverables.
• Designed SSIS packages to load customer information from flat files.
• Converted OLTP databases to OLAP database used in SSAS.
• Designed SSAS cubes to meet business requirements such as tracking, purchasing patterns, analyze customer’s account and allow users to perform fast queries.
• Generated reports according to customer’s requirement using SSAS cubes as data source.
• Created, managed, and delivered interactive web-based reports to support daily operations and drive decisions.
• Scheduled and monitored all maintenance activities of SQL Server 2000/2005 to meet business requirements activities including database consistency check, data backup & restore strategy, index defragmentation.
• Modeled and forecasted database and platform resource utilization to meet user needs and respond to anticipate technological innovations.
• Created alerts, notifications, and emails for system errors, insufficient resources, fatal database errors, hardware errors, and security breach.
• Used SQL Profiler for troubleshooting, monitoring, optimizing SQL Server and T-SQL statement from developers and testers.
• Managed the production, development, and test database including access controlling, high availability, performance monitoring and tuning, capacity planning, SQL Server clustering, database security configuration, and database continuity.

Environment: MS SQL Server 2005, MS SQL Server Integration / Analysis Services 2005, Erwin, Oracle

SQL Developer

Confidential

Responsibilities:

• Gathered user requirements.
• Analyzed and designed software and database solutions.
• Updated functional specification and technical design documents.
• Developed Analysis Services Project.
• Identified and defined Data Source and Data Source views.
• Created cubes and defined the dimensions.
• Defined attribute properties in a Parent Child Dimensions.
• Implemented the calculations to aggregate physical measures.
• Identified and defined the scoped assignments using script commands.
• Responsible for defining calculated members.
• Responsible for Processing Database Objects Security Role.
• Created various tables and views.
• Wrote T-SQL code for creating cursor and handling the data validations.
• Designed and implemented stored procedures and triggers for automating tasks.
• Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, cursors, tables, views, SQL joins and statements for applications.

Environment: T-SQL, MS SQL Server 2005, MS SQL Server Analysis Services 2005, MS SQL Server Integration Services 2005, ADO.NET

.NET Developer

Confidential

Responsibilities:

• Responsible for writing stored procedures in SQL server 2000 incorporating business logic for the reports.
• Designed and developed Web-based user interface application with ASP.NET, HTML, Java script and IIS.
• Design and developed User controls and Custom controls for the application.
• Used validation techniques and Java Script for User Input Validations.
• Created SQL Server database to responsively handle complex queries (triggers, stored procedures) and .NET data access components.
• Involved in generating reports for the application using Crystal Reports.
• Utilized Visual SourceSafe for version control during development and maintenance.
• Involved in unit testing, Integration testing and documenting the project.

Environment: ASP.NET 1.1, ADO.NET, C# .NET, Visual Studio .NET, SQL Server 2000JavaScript, IIS 5.0, SQL Server 2000, Windows 2000/XP, Crystal Reports and Microsoft VSS