Certified SQL BI Consultant

Around 7 years plus of extensive experience as a MS SQL Server SQL Server 2005/2008 Developer with major focus on T-SQL, SSIS, SSAS and SSRS. 6 years of sound experience as a database developer in banking, IT and financial sectors. Sound knowledge of software development life cycle (SDLC) with substantial experience with object oriented analysis and design methodologies. Possess experience in independently handling design, development, documentation and testing phases in a project environment.

• Profound knowledge and ability to write stored procedures, temporary tables, views, indexes, and triggers when required.
• Expertise with DDL and DML statements, RDBMSs, data dictionaries and normal forms.
• Estimate, schedule and track ETL projects throughout SDLC.
• Good knowledge in RDBMS concepts, data models, Star/Snow Flake Schemas.
• Expert in Extraction, Transforming and Loading (ETL) data flows using SSIS; creating mappings/workflows to extract data from Oracle, SQL Server and Flat File sources and load into various Business Entities.
• Exceptional hands on working knowledge with SQL Server Integration Services (SSIS) ,SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS).
• Proficient in Installing SQL Server 2000/2005/2008 and configuration of their tools.
• Good understanding indatabaseanddata warehousing concepts (OLTP and OLAP).
• Experience in Data Warehouse Modeling withSQL Server Analysis (SSAS).
• Experience in Creation and deployment of cubes onSSAS.
• Good report creation skills using Microsoft Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
• Good Hand on Resolving complex issues and Error Handling in SSIS.
• Very good knowledge in scheduling and deploying reports on report manger.
• Experience in developingUser reports and management reports using MS SQL Server Reporting Services (SSRS).
• Experience in developingCustom Reportand different types of Tabular Reports, Matrix Reports, and drill down reports in multiple formats usingSQLServerReporting Services(SSRS) in Business intelligence development studio (BIDS).
• Experience in creating packages to transfer data between ORACLE, MS ACCESS and FLAT FILES to SQL SERVER using SSIS.
• Experience in enhancing and deploying the SSIS Packages from development server to production server.
• Experience in TOAD v9.5 for developing and managing PL/SQL scripts.
• Maintained Database authentication modes, creation of users, configuring permissions and assigning roles to users..
• Knowledge in MS-SQL Server 2008
• Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.

Education:

• Bachelors of Technology in Computer Science Engineering

Technical Skills:

Operating Systems: Windows 2000 Server, Windows 2000 Advanced server, Windows 2003 , Windows 2008 , Windows NT 4.0, Windows XP, Windows Vista.

components/environment: MS SQL Server 2005/2008, SQL Server Management Studio, SQL Server Reporting Services, SQL Server Integration Services, Analysis Services.

Languages: C,C++, PL/SQL,T-SQL

RDBMS: SQL Server 2008,2005/ 2000 /7.0,8.0,9.0,10.0,MySQL,MS Access, Oracle 11Gi

Application: Rational Rose (UML), Erwin, Visual Studio

Database Query Tools: MS SQL Server Query Analyzer, SQL Profiler, ETL, Toad for SQL

Database Software: TOAD,MYSQL

Systems familiarity: OLTP,OLAP, Unix/Linux, Windows

Professional Experience:

Client : Confidential Suwanee, GA
Duration : Apr 11 to Present
Role : Sr SQL Server BI Developer (SSAS/SSRS)
Project Description:
Aon Corporation is the leading provider of risk management services, insurance and reinsurance brokerage and human capital and management consulting. The Application-AuMine is a policy and quote management for endorsements, renewal and invoicing. This project is responsible for loading data (gets from various legacy systems) into SQL Servers by creating Integrated Packages (SSIS) and makes available data for Analysis (SSAS) and Reporting services (SSRS).

Job Responsibilities:

• Designed and Developed Database Objects like Tables, Stored Procedures, Triggers, Rules, Defaults, user defined data types and functions for this project.
• Developed, tested and implemented Referential Integrity rules and regulations through constraints, triggers and views, partitioned views.
• Regular responsibilities for updating staging and dimensional databases as well as rebuilding the dimensions and cubes on Analysis Services (SSAS).
• Created SQL Server Analysis Project using MS SSAS 2005.
• Created Views for specific columns on a table to maintain privacy of a customer data.
• Created Indexes to get the high level performance.
• Performing the ETL operations to support the incremental, historical data loads and transformations using SSIS.
• Designed SSIS packages for synchronizing the data between two different servers.
• Maintained databases, performed software installations and upgrades, monitored Database Performance.
• Responsible for gathering Business Requirements and System Specification from users.
• Designed numerous ad-hoc and custom reports using SQL Reporting Services.
• Created various Tabular and Matrix Reports using SSRS.
• Created various drill down reports using SSRS.
• Experience in the design, development and maintenance of different cubes using SSAS.
• Involved in the post deployment maintenance of reports and cubes.
• Developing ETL Frame work to extract and load the data from multiple databases from SQL Server 2008 to File Server and File Server to work flow Job System SQL databases.
• Created and scheduled jobs for various tasks.

Environment:
Microsoft SQL Server 2005, SQL Server Reporting Services (SSRS), Management studio, SQL Server Analysis Services 2005, SQL Server Integration Services (SSIS), SQL Server Business intelligence Development Studio(BIDS), T-SQL, Oracle 10g,11g, PL/SQL, Erwin 7.3, TOAD v9.5, MS Excel.

Client : Confidential Boston, MA
Duration : Apr 10 to Mar ‘11
Role : SQL Server BI developer (SSIS/SSRS/SSAS)
Project Description:
This is a web based student loan application for customers to consolidate their previous loans and make online monthly payments. . This involved merging the current legacy systems into a single SQL Server data source which is more than 2 TB in size.

Job Responsibilities:

• Installation of SQL Server on Development and Production Servers, setting up databases, users, roles and permissions.
• Responsible for all technical SQL Server database operations, Administration, ongoing development for various in-house databases.
• Designed and Developed Database Objects like Tables, Stored Procedures, Triggers, Rules, Defaults, user defined data types and functions for this project.
• Created Indexes to get the high level performance.
• Modified the database by removing unwanted columns and also adding proper constraints, rules and defaults to tables.
• Performing the ETL operations to support the data loads and transformations using SSIS.
• Involved in migration from Oracle to SQL Server 2005 using SSMA and SSIS.
• Developed Cubes using SQL Analysis Services (SSAS).
• Deployment of SSAS Cubes to the production server.
• Generation of reports from the cubes by connecting to Analysis server from SSRS.
• SSAS storage and partitions, and Aggregations, Data Mining Models, developing reports using SQL.
• Experience in Developing and Extending SSAS Cubes, Dimensions and data source view SSAS-Data Mining Models and Deploying and Processing SSAS objects.
• Maintained databases, performed software installations and upgrades, monitored Database Performance.
• Implemented automated backup and database maintenance / cleanup jobs.
• Managing Logins, Users, Roles and User permissions.
• Running Trace from the Profiler to trouble shoot database and running DBCC consistency checks for other database maintenance aspects.
• Designed numerous ad-hoc and custom reports using SQL Reporting Services.
• Created various Tabular and Matrix Reports using SSRS.
• Created and scheduled jobs for various tasks and also was responsible for maintaining jobs.

Environment:
Microsoft SQL Server 2005, SQL Server Reporting Services (SSRS), Management studio, SQL Server Analysis Services 2005, SQL Server Integration Services (SSIS), SQL Server Business intelligence Development Studio(BIDS), T-SQL, Oracle 10g,11g, PL/SQL, TOAD v9.5, MS Excel.

Client : Confidential Plano, TX
Duration : Oct 09 to Mar ‘10
Role : SQL Server BI developer (SSIS/SSRS)
Project Description:
Rent-A-Center owns and operates more than 2,800 stores in all different states. The corporate headquarter is located in Plano, TX.
Customer Information System:
The project was designed to implement and manage Customer Information System through companys entire customer database for every region and separated them based on the customer details and their business profiles.

Job Responsibilities:

• Created and maintained various databases for Development and Testing Environment using SQL Server 2000/2005 and involve in actual Relational Database Design for high OLTP environment.
• Designed automated scripts in T-SQL, and BCP to import data from various ODBC sources into SQL Server databases to maintain the consistency and data integrity.
• Exposed to data conversion from different data sources to SQL Server 2005 using SSIS.
• Experienced in data warehouse systems, ETL processes using DTS.
• Experienced in ETL (Extracting, Transforming and Loading) development using SSIS for migration of data between legacy systems to SQL Server 2000/200Created ad-hoc reports for business users using SSRS.
• Developed drill down reports using SSRS.
• Developed scripts for tables, Stored Procedures, and SSIS, (SQL 2K5) tasks.
• Experience in building Star schema and Snowflake schema depending on the business data requirement.
• Scheduled Nightly jobs for some of the process to run for the Data flow.
• Created Maintenance plans for the Data Integrity and Backups.
• Designed Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Worked with SSRS to generate reports like Drill Down and scheduled SSIS Packages.

Environment:
Microsoft SQL Server 2005, SQL Server Reporting Services (SSRS), Management studio, SQL Server Integration Services (SSIS), SQL Server Business intelligence Development Studio(BIDS), T-SQL, Oracle 10g,11g, PL/SQL, TOAD v9.5,Erwin, MS Excel.

Client : Confidential San Jose, CA
Duration : Nov 08 to Sep ‘09
Role : SQL Developer

Project Description:
This was an Oracle Development/implementation Project for Cisco Lean.

Job Responsibilities:

• Modified current database by adding tables and relationships to support online system.
• Defined Constraints, Rules and Defaults.
• Was Involved in Database Normalization
• Created Views as required by front end developer for easier implementation on web pages, and triggers on those views to provide efficient data manipulation.
• Created complex T-SQL Queries, Stored Procedures and Functions to support efficient data storage and manipulation.
• Created SSIS packages to capture the Incremental changes for the Data ware house.
• Built SSIS packages to process Cubes, Dimensions and partitions.
• Have a very Good Experience with all the Control Flow and Data Flow tasks in SSIS.
• Created and managed SQL Server login, database users and Roles.
• Assisted in designing and creating website for the system using HTML.
• Scheduled jobs for backup, and created alerts for error reporting.
• Data migration (import & export to BCP) from Text to SQL Server.
• Participated in different testing and debugging for the system.
• Documented all processes involved in maintaining the database for future reference.
• Develop various reports using Reporting Service (SSRS) as required.
• Developed Charts and Tabular reports in Excel and Web format using SSRS.

Environment:
Microsoft SQL Server 2005, SQL Server Reporting Services (SSRS), Management studio, SQL Server Integration Services (SSIS), SQL Server Business intelligence Development Studio(BIDS), T-SQL, DHTML, PL/SQL, TOAD v9.5, MS Excel.

Client : Confidential, India
Duration : Nov 06 to Sept ‘08
Role : SQL Developer

Project Description:
Purchasing and sales system project involves maintaining the details of purchase of raw materials through tenders.

Job Responsibilities:

• Created Views to reduce apparent database complexity for end users and preventing sensitive columns from being displayed
• Wrote Triggers and Stored Procedures.
• Evaluated Database Performance and performed maintenance duties such as Tuning, Backup and Restore.
• Scheduling Jobs and Alerting using SQL Server Agent.
• Successfully designed and implemented SSIS packages to transfer data within servers.
• Developed custom reports using SSRS/SQL Server BI studio.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Managing and configuring logins to SQL Server, database user accounts, permissions.
• Created complex T-SQL Queries, Stored Procedures and Functions to support efficient data storage and manipulation.
• Troubleshooting, Monitoring and Tuning the SQL Server for optimum performance.

Environment:
Microsoft SQL Server 2005, SQL Server Reporting Services (SSRS), Management studio, SQL Server Integration Services (SSIS), SQL Server Business intelligence Development Studio(BIDS), T-SQL, DHTML, PL/SQL, TOAD v9.5, MS Excel.

Client : Confidential India
Duration : Jul 05 - Oct 06
Role : Software Programmer

Job Responsibilities:

• Technical Design and development.
• Interacting with the client for more clarity on the requirements if required.
• HLD/Customer Visible Documentation.
• Creation of tables CDMAPART and DNHLRRTE.
• Development of Customer Forms and Reports.
• Table content monitoring during restarts.
• Product Testing
• Created packaged procedures, triggers validation procedures.
• Developed validation scripts for the complex business rules using PL/SQL.
• Designed the Test Case documents for the product.
• Tested product Performance and Functionality.
• Created test cases at all phases of unit and acceptance testing for all the developed forms and reports according to the client requirement.

Environment: Proprietary database, Proprietary language called PROTEL similar to JAVA, PL-SQL code browsing tool MENTOR, 2000/XP, UNIX.