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, RDBMS's, 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).
• Created reports that have been defined by business architect and generated canned reports in a Crystal format of Crystal Reports.
• Worked on predefined, developed stored procedures for automation and scheduling in crystal reports
• 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:

• Bachelor of Technology

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

ProfessionalExperience:

Client : Confidential, Kanas City, MS Duration : May 2011 - Present Role : Sr SQL Server Reports Developer(SSIS/SSRS) Project Description: Confidential is a federation of 38 separate health insurance organizations and companies in the United States. Combined, they directly or indirectly provide health insurance to over 99 million Americans.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.
• Developed multiple processes for Daily Reports using SSIS and SSRS.
• Developed multiple processes for Daily Reports to business users on shared Network and email attachments with email notification using SSIS and SSRS.
• Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.
• Generated and consolidated monthly reports and budget analysis to drive forecast production plan with SQL report service (SSRS).
• Designed and Implemented various reports using Crystal Reports and responsible for the migration to SSRS
• 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 (SSRS).
• Created variousTabular 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, Microsoft SQL Server 2008(R2), 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, Pittsburg, PA Duration : July 2009 - May 2011 Role : SQL Server BI developer Project Description: Confidential offers a wide range of services for all our customers, from individuals and small businesses, to corporations and government entities. No matter how simple or complicated your needs, we're sure to have the products,knowledge and resources necessary for financial success.

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.
• Developed reports by using SSRS and deployed them on web pages using ASP.NET using C#.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS.
• Performing the ETL operations to support the data loads and transformations using SSIS.
• Developed multiple processes for Daily Data Ingestion from Client associated data vendors and Production Team, Client site employees using SSIS and SSRS.
• Developed multiple processes for Daily Reports to business users on shared Network and email attachments with email notification using SSIS and SSRS.
• 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 variousTabular and Matrix Reports using SSRS.
• Created and scheduled jobs for various tasks and also was responsible for maintaining jobs.

Environment: Microsoft SQL Server 2005, Microsoft SQL Server 2008(R2), 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, Boston, MA Duration : Aug 2008 - June 2009 Role : SQL Server BI developer (SSIS/SSRS) Project Description: Confidential is a world leader in information management services, assisting more than 140,000 organizations in 39 countries on five continents with storing, protecting and managing their information. .

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/2005.
• Created 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 andscheduled 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 , MS Excel.

Client : Confidential, Alabama Duration : Jan '06 - July '08 Role : SQL Developer

Project Description: Confidential was formed in 1971 as First Alabama Bancshares Inc., Alabama's first multibank holding company. With the combination of three well-respected banks, the holding company began operations with a total of $543 million in assets and 40 banking locations in Birmingham, Huntsville and Montgomery. 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 - 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 : July '03 - Nov '05 Role : SQL Developer

Project Description: This project involved migration of data from SQL Server 7 to SQL Server 2000 and then executing complex queries on the data.

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, Hyd - India Duration : Jan '03 - May '03 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.