PROFESSIONAL SUMMARY

• Knowledge of complete software development life cycle (SDLC) including Requirement Analysis, Requirement, Gathering, Design, Development, Implementation and Testingand Development experience.
• Sound knowledge of SQL server administrative skills including, backups, disaster recovery, database maintenance, user authorizations and database creation.
• Worked with Business Analysts, Web development team and users on database solutions.
• Experience in Configure and maintain Report Manager and Report Server for SSRS, Deployed and Scheduled the Reports in Report Manager.
• Extensive hands-on experience in Database development for both OLTP(Batch Processing, Online Processing) & OLAP Systems (SSRS, SSIS, SSAS) using MS SQL Server 2000/2005/2008/2008 R2
• Well versed with theknowledge of RDBMS, data warehousing i.e. OLTP & OLAP systems.
• Experience in extraction, transformation and loading (ETL) of data flows using SSIS with complex integration of SQL Server, oracle, flat file sources and IBM mainframe DB2.
• About 4 + Years of IT Experience in Database Design Development, ETL Implementation and support of OLTP/Data warehouse systems using Microsoft SQL Server 2008/2005/2000 across various SDLC environments.
• Expertise in creating indexed views, complex stored procedures, effective functions, and appropriate triggers to facilitate efficient data manipulation to maintain data consistency.
• Sound knowledge of SQL server administrative skills including, backups, disaster recovery, database maintenance, user authorizations and database creation.
• Involved in designing numerous DB Objects like Tables, Constraints (Primary Key, Foreign Key, Unique), Indexes, defaults, rules.
• Extensive experience in BI suite - using integration services (SSIS) for ETL (Extraction, Worked on data cleansing techniques using look ups, conditional split, merge and derived columns.
• Transformation and Loading), reporting services (SSRS) for creating different types of reports and analysis services (SSAS) for design and developing complex cubes.

TECHNICAL SKILLS

• RDBMS: MS SQL Server 2000/2005/2008, MS Access 97/2003/2005
• LANGUAGES: T-SQL, PL/SQL, C#
• TOOLS AND PACKAGES: SQL Server Management studio, SQL Server Business Intelligence Development Studio (BIDS), SSIS, Visual Studio .NET, ETL
• DATABASE DESIGN TOOLS: MS Visio, Erwin4.5/4.0
• BI TOOLS: SQL Server Reporting Tools (SSRS), SQL Server Integration Services (SSIS), SQL Server Analytical Services (SSAS), Business Intelligence Development Studio (BIDS), Visual Studio

EDUCATION/CERTIFICATION

• Bachelors in Business Finance, University of Phoenix, AZ.
• Associate in Science Degree, RichlandCollege, TX
• MCTS: Microsoft SQL Server 2008 Business Intelligence-Implementation and Maintenance

Confidential, Lewisville, TX 
SQL SERVER (SSIS, SSRS, SSAS) Developer

Project: ICAT & Finance Data Mart (Finmart): Finmart is data warehouse of financial data for the Bank; which involves data transfer (SSIS), data analysis (SSAS) and report (SSRS) generation. ICATis a portal application provides Default and Servicing interface to a multi dimensional cube for financial planning, forecasting and reporting for Mortgage Banking of J P Morgan Chase, USA.

RESPONSIBILITIES

• Working as an application developer (C#, SQL Server) and well versed in Business Intelligence Development (SSIS, SSRS & SSAS) for different Financial and Investment applications. Involved with direct discussion with business and other source systems teams, creation, migration, and decommission and redesigning the project
• Collected business requirements from users and translated them as technical specifications and design documents for development.
• Created Package Configurations, Event Handlers for On Error, On Warning, On Task Failed Event Types.
• Designed Complex Packages with Error Handling and Package Logging that stores the Logging results in SQL table and flat files
• Involved in writingstored procedures for both Online and Batch requestshandling business logic and Functionality of various modules
• Interacted with Program Managers and Test Engineers to contribute and Review functional Specifications and Test Cases.
• Worked on developing Tables, Indexes, Views, Creating complex stored procedures, Triggers, Functions
• Designing Enterprise reports using SQL Server Reporting Services (SSRS 2005) and Excel pivot tables based on OLAP cubes which make use of multiple value section in parameters pick list , cascading prompts, matrix dynamics reports and other features of Reporting service

Environment: MS SQL Server 2008/2008 R2, Business Intelligence Development studio (SSRS/ SSAS/SSIS), Microsoft.NET, MS Office Access 2003, VBScript, Erwin, and Visual Studio 2008.

Confidential, Dallas, TX 
SQL/SSRS/SSIS/SSAS Developer

The new Marketing Intelligence System is designed to centralize marketing information allowing all parts of the Global Marketing and Sales Community to provide and access customer, competitor, and market profile data that cover the airline catering market. Some of the reports were Market share, internal performance analysis, visual map analysis and Executive “dashboard” reports.

RESPONSIBILITIES

• Designed reports using table filters, single value parameters, multi value parameters, dependent parameters and Cascading parameters.
• Report parameters also consist of different parameter types like hidden, internal, default (queried and non queried parameters) to minimize the report execution time and to limit the no of records required.
• Developed reports using complex TSQL queries, User Defined Functions’, store procedures and views.
• Designed and Developed SSIS Packages using various Control Flow and Data Flow items to Transform and load the Data from various Databases and into Siemens Servers using SQL Server Integration Services(SSIS)
• Worked with various upstream and downstream systems and customers in interfacing various systems for Data extractions, ETL, Analytics and reporting needs
• Extracted data from various sources like SQL server 2005/2008, Oracle, CSV, Excel and text file from Client servers and through FTP.
• Involved in source Data Analysis, Design and Creation of Data Mappings for Extraction of bulk data from heterogeneous sources like Oracle, ADSI and other OLEDB data sources
• Designed packages using Lookup Transformations, Merge Joins, Fuzzy Look Ups, and Derived Columns with Multiple Data Flow Tasks.
• Involved in Automating SSIS Packages using SQL Server Agent Jobs and Windows Scheduler.
• Built Drill Down, Drill through, linked and sub reports using SSRS 2005/2008.
• Designing Enterprise reports using SQL Server Reporting Services (SSRS 2005) and Excel pivot tables based on OLAP cubes which make use of multiple value section in parameters pick list, cascading prompts, matrix dynamics reports and other features of Reporting service.

Environment: MS SQL Server 2008/2008 R2, Business Intelligence Development studio (SSRS/SSAS/SSIS), Microsoft.NET, MS Office Access 2003, VBScript, Erwin, and Visual Studio 2008