SUMMARY

• 7+ years of IT Experience in Database Design, Development and business intelligence of Microsoft SQL Server 2008/2005/2000 in Development, Test and Production Environments.
• Expert in MS SQL Server BI components, Integration Services (SSIS), Analysis Services (SSAS) and Reporting Services (SSRS).
• Extensive experience and proficiency on the design, construction and implementation of Business Intelligence tools, ETL Process (Data Extraction, Transformation and Load) with DTS/SSIS, Data Cleansing, MSSQL Databases, Analysis Services (SSAS), Reporting Services (SSRS)
• Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment.
• Knowledge in developing T - SQL queries (DDL and DML).
• Experienced in creating Tables, Views and other SQL joins and query writing.
• Expert in creating Clustered and Non-Clustered Indexes to improve the performance of the SQL queries.
• Good hands on experience with using all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Check and Unique).
• Experience in Dimensional Modeling, Designing of STAR, SNOW FLAKE Schemas.
• Actively worked on system analysis, design, development, testing and implementation of projects (SDLC) and capable of handling responsibilities independently as well as a proactive team member.
• Hands on experience on Extraction Transformation and Loading (ETL) processes using tools like SSIS, DTS, BCP between different homogeneous/heterogeneous systems and SQL Server and implemented Incremental load in SSIS packages
• Experience in enhancing and deploying the SSIS Packages from development server to production server.
• Experience in creating SSIS packages to transfer data from OLTP data base to Data warehouse.
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart, Ad hoc and Sub Reports.
• Expertise in designing Data Flow task and Work Flow task on SSIS.
• Expert in cube development, partition and aggregations and optimizing using SSAS.
• Good experience in creating Stored Procedures, User Defined functions, Triggers and writing sub-queries to simplify complex queries involving multiple tables.
• Building and writing MDX Queries, Calculated Members, and KPI’s using Microsoft SQL Server 2005/2008 Analysis Services Business Intelligence (SSAS, SSRS).
• Experience in creating scheduling jobs, alerts, SQL Mail Agent, and scheduled DTS packages.
• Expert in extracting and transforming data using DTS Import/Export Data, Bulk Insert.

TECHNICAL SKILLS

Operating Systems: UNIX, Windows Server 2000, Windows Server 2003, Windows Vista/XP/98/95

Data Bases: SQL Server 2008/2005/ 2000 , Oracle 8i/9i and 10g, MS Access

Data Base Tools: SQL Server Management Studio(SSMS), SQL Server Business Intelligence Development Studio(BIDS), SQL Enterprise Manager, Query Analyzer and SQL Profiler, SQL Server Dashboard

Reporting Tools: MS Access, MS SQL Reporting services (SSRS), Microsoft Excel

Data Modeling Tools: Erwin, VISIO 2000

ETL Tools: DTS, MS SQL Integration Services(SSIS)

Languages: SQL,T-SQL,PL/SQL,C,HTML,XML, Java Script

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

SQL BI Developer (SSIS, SSRS)

Responsibilities:

• Responsible for ETL Operation which extracts and transforms the data to Data Warehouse using SQL Server Integration Services (SSIS)
• Created SSIS packages to import and export data from flat files dynamically.
• Deployed SSIS packages to different environments using package configurations of type environment variable and SQL Server table.
• Designed the packages and data mapping using Control flow task, Sequence container task, Dataflow Task, Execute SQL Task, Data conversion task, Derived Column task and Script Task in SSIS Designer.
• Written T-SQL scripts, dynamic SQL, complex stored procedures, functions.
• Created SSIS packages to pull data from SQL Server and exported to flat files, CSV files and Excel Spreadsheets and vice versa.
• Involved in tuning of SQL scripts using stored procedures and functions.
• Generated back up file for data base using Back up Database task in SSIS.
• Involved in maintenance and administration of SSIS by creating Jobs, alerts and schedule SSIS packages.
• Experience in creating and managing linked servers.
• Generated scripts to back up and restore data bases.
• Managed the imports and exports for the data bases and troubleshoot load failures.
• Created SSIS packages to unzip files and move them to folders dynamically based on the file names.
• Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data.
• Developed queries to generate various charts, parameterized reports and conditional reports.
• Involved in performance tuning and optimization of stored procedures and queries.
• Provided daily support, troubleshooting, monitoring of jobs running on SQL Server.
• Created Drill Down and Drill Through Reports in SSRS.
• Automated the execution of SSRS reports using Subscriptions and Data-Driven Subscriptions.

Environment: SQL Server 2008/2008 R2, T-SQL, MS Server Integration services, SSRS (MS server Reporting Services), MS Visual Studio 2008, Microsoft Visual source safe (VSS)

Confidential, Addison, TX

Role: SQL Server BI Developer

Responsibilities:

• Designed and implemented Stored Procedures and Triggers for automating tasks.
• Monitoring of History and Current Records by implementing Change Data Capture on the tables.
• Loading flat files everyday and storing them in Archive by renaming the files with current date.
• Updating about 25 columns in each table by implementing complex queries, stored procedures as required by the business logic.
• Creation of Indexes and applying triggers.
• Application of Recursive CTE's where required.
• Created SSIS Packages to pull data from iSeries and load into SQL Server Tables
• Pulling data on a daily basis from OLTP database to OLAP or staging database using SSIS packages
• Implementing Package Configurations for the package for making it to work in different servers.
• Loading flat files from OLTP database and storing them in a folder by renaming using File System Task in SSIS.
• Created SSIS packages to load from oracle to SQL server
• Designed Complex Cubes, KPI's, Partitions.
• Mapped each KPI with Multiple data sources, threshold values, bending methods, and indicators.
• Optimized Complex queries using Indexes and execution plan.
• Generate SSRS reports by using complex queries.
• Developed flowcharts for complex stored procedures.
• Implemented normalization techniques on different databases.
• Developed Multi dimensional Objects (Cubes) using MS Analysis.
• Deployed SSIS Packages to different environments.
• Experience in creating SSIS packages using dashboards.
• Worked for the department that handles the Mortgage services.
• Loading data from various sources like, flat files, to SQL Server database Using SSIS Package
• Using SSIS, building high performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing and also Scheduling the SSIS packages and Jobs
• Design and create report models based on users’ requirements, explain and train users to use report builder to generate their own personalized reports.
• Created SSIS Packages to migrate slowly changing dimensions
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2005.
• Involved in Creation of Dimensions using STAR and SNOW FLAKE Schema in SSAS.
• Developed scripts to generate reports from various relational databases like Oracle, DB2
• Created data driven subscriptions to generate reports on a daily basis in SSRS.
• Highly involved in creating, structuring, formatting usingReport Designer and Report Builder.
• Created reports usingstored procedure and also involved inscheduling, creating snapshotsand subscriptions for the reports SSRS.

Environment: MS SQL Server 2005/2008, Windows 2000/NT/XP, SSIS, SSRS, SSAS, T-SQL, Query Analyzer, MS Office 2003, Oracle 9i/10g,Erwin 4.0

Confidential, Topeka, KS

MS SQL Server BI Developer

Responsibilities:

• Involved in gathering Business Requirements and System Specification from users.
• Successfully implemented physical database on MS SQL Server 2000.
• Supported complex relationship using Triggers
• Facilitated simplified access of database for end users using De-normalized views and created Triggers on them to maintain to database integrity.
• Developed Stored Procedures and T-SQL queries to generate reports for the end users.
• Created views and various User Defined Functions for fast access of data from tables.
• Migrated DTS Packages of SQL Server 2000 to SQL Server 2005
• Import/Export using MS Access, Excel and Text file to/from SQL Server
• Created Ad-Hoc reports for business users using SSRS
• Created Drill down and Drill through reports in SSRS.
• Designed and developed Parameterized and cascading parameterized reports.
• Created various reports using Report Builder.
• Designed stored procedures to create reports.
• Involved in creating multiple level Cascading Prompt for both static and dynamic parameter
• Troubleshoot SQL Server performance issues for internal and external customers
• Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2000 to MS SQL 2005 as well as Created interface stored procedures used in SSIS to load/transform data to the database.
• Created SSIS packages with event handlers.
• Building of OLAP cubes with SSAS 2008(R2).
• Designed DTS/SSIS packages to export and import data from SQL Server to MS Access, Oracle10g,Infopath files, text files and Excel files.
• Scheduled the DTS package for migration data from old system to MS SQL 2005.
• Reconciled data for transformation from SQL 2000 to SQL 2005 using SSIS
• Extracting the data from the different sources (CSV files, oracle, and MS SQL 2000) and stored the data into the intermediate Staging Database using the SSIS ETL tool.
• Monitored and Tuned Databases, Indexes, Stored Procedures and Server Performance using Performance monitoring tools for MS SQL Server 2000 with the help of Administrator
• Participated in the Design, Creation and Maintenance of SQL Server database
• Involved in implementation, maintenance, and monitoring Database Back-ups, Database Space Management, Error Log monitoring, patch application, etc
• Involved in Optimization and Performance of queries and Used DBCC command to free SQL cache memory

Environment: SQL Server 2000, T-SQL, VB 6.0, DTS, SSRS, SSIS, XML, Visual Source Safe, MS Office, Windows 2000.

Confidential, NY

SQL BI Developer (SSAS, SSRS)

Responsibilities:

• Worked with Technical Architects and Database analysts for the Design of Summary tables required for efficient Report Design,
• Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development
• Developed OLAP Cubes using SQL Analysis Services (SSAS).
• Involved in creating Named calculations and named queries.
• Created Dimensions with the cube wizard and also individually.
• Refreshing the cube to get the latest information updated.
• Created SSIS packages to Oracle and other SQL Server instances.
• Created Triggers and Stored Procedures to capture updated and deleted data from OLTP systems.
• Deployment of Cubes to the production server.
• Generation of reports from the cubes by connecting to Analysis server from SSRS.
• Created Global variables, expressions and functions to generate dynamic reports.
• Performed maintenance of Stored Procedures to improve Performance of different front end Applications.
• Worked on T-SQL programming, stored procedures, user-defined functions, cursors, views setup and management of linked servers to Non-SQL-Server databases.
• Created Packages
• For the data warehouse Analysis services and develops the different reports for the analysis.
• Extensively involved in the SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Responsible for logical and physical data modeling, database design, star schema, data analysis, programming, documentation and implementation.
• Transform the data from the staging database and perform the transformation using the Data Flow Tasks
• Operations and perform the Different required transformation in the Staging Database and make the data ready to load in the Data Warehouse Database.
• Experience in Developing and Extending OLAP Cubes, Dimensions and data source view
• Developed complex stored procedure using T-SQL to generate Ad hoc reports using SSRS.
• Scheduled the Reports to run on daily and weekly basis in Report Manager and also email them to director and analysts to review in Excel Sheet.
• Created SSIS packages using control flow and data flow elements.
• Configured packages to deploy them to different environments.
• Designed dashboards for different reports like charts, matrix, Data bar in SSRS.
• Build database queries and test cases for the testing team to test the reports
• Created Sub-Reports, Drilldown-Reports, and Cross Tab reports using MS SQL Reporting Services (SSRS).
• Prepared the reports for the day-to-day as well as weekly/monthly purposes in various formats like MS Excel, PDF, HTML, and XML etc.

Environment: SQL Server 2005/2008, Business Intelligence Studio (SSAS, SSIS, SSRS), T SQL, Erwin, MDX, Oracle 10g, MS Excel.

Confidential, St Louis MO

SQL Server BI Developer

Responsibilities:

• Involved in requirements gathering, analysis, design, development, change management, deployment and user training.
• Translates requirements into physical database structures that integrate with existing or proposed database structures.
• Participated in developing and designing the data models, in conjunction with the application development team.
• Work with databases to optimize database performance and resource usage
• Performs database performance monitoring and implements efficiency improvements including capacity planning.
• Assisted the development staff regarding application design to facilitate effective use of database languages, methodologies and established standards.
• Worked with development staff in approving database changes and managed access paths to optimize availability of the databases.
• Created complex Stored Procedures, User Defined Functions, Triggers, Cursors, Tables, Views.
• Developed various SQL Joins, Unions and other statements for various applications, maintained referential integrity and implemented complex business logic.
• Created various reports using MS Reporting Services. And deploy public reports in dynamic web portal.
• Used Stored Procedures to generate different reports.
• Loading data from various data sources using MS Data Transformation Services (DTS).
• Interacted with developers on various aspects ranging from usage of utilities to SQL performance, test data and general trouble shooting.
• Involved in writing MDX Scripts for the OLAP CUBES.
• Designed OLAP Star and Snow Flake schemas and then Dimensions and Fact table to build the cubes.
• Involved in writing views, cursors and triggers.
• Created and integrated user defined functions and stored procedures for reporting purposes.
• Designed and developed various complex reports.
• Involved in creating the reports that can handle dynamic grouping and dynamic sorting.
• Developed T-SQL procedures to modify database objects dynamically based on user inputs.
• Used SQL Server Profiler to tune the performance of the stored procedures and functions to improve the report generation time.

Environment: SQL Server 2005/2008, MS Excel 2003, MS Access 2003, MS SQL Query Analyzer, SQL Profiler, MS SQL Server Reporting Services, Crystal Reports 9,Oracle9i/10g.

Confidential

Jr. SQL Developer

Responsibilities:

• Involved in creating, manipulation and supporting the SQL Server databases.
• Developed the Data modeling, Physical and Logical Design of Database.
• Created tables, constraints, indexes, sequences, procedures and triggers.
• Implemented Stored Procedures and Triggers on business rules.
• Participated in integrating the front end with SQL server back end.
• Created User defined Functions, Stored Procedures and Triggers using DML and DDL.
• Used Data Transformation Services (DTS) to import and export data from one server to other server.
• Involved in performance tuning of T-SQL queries.

Environment: MS SQL Server 2000, T-SQL, DTS.