Professional Experience:

• Over all 7+ years of experience in Database Design, Programming, Development and Implementation of Client - Server Applications & Database systems using MSSQL 2012/2008/2005/2000.
• Experienced in Installing,Upgrading and Configuring of Microsoft SQL Server and Databases.
• Proficient in SQL Server and T-SQL (DDL and DML) in constructing Tables, Normalization techniques on database Tables.
• Expert in creating and using Stored Procedures, Views, User Defined Functions.
• Expert in creating Sub-Queries and Joins for complex queries involving multiple tables and Exception Handlers.
• Excellent experience in creating Indexes, Indexed Views in observing Business Rules and creating effective Functions and appropriate Triggers to assist efficient data manipulation and data consistency.
• Well experience in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Data Transformation Services (DTS).
• Proficient in creating dynamic packages for Incremental Loads and Data Cleaning in Data WareHouse using SSIS.
• Excellent experience in maintaining Batch Logging, Error Logging with Event Handlers and Configuring Connection Managers using SSIS.
• Extracted, transformed and loaded data from various heterogeneous data sources and destinations like Access,Excel,CSV,Oracle,flat files using connectors, tasks and transformations provided by SSIS.
• Excellent experience in developing stylish Drill Down, Cascading, Parameterized, Drill through, Sub reports and Charts using Global variables,Expressions and Functions for the business users.
• Involved in creating Jobs, SQL Mail Agent, Alerts and Schedule SSIS, DTS Packages.
• Involved in Query Optimization and Performance Tuning using SQL Profiler and Index Tuning Wizard.
• Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills and possess strong analytical skills.
• Self-motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills. Team-oriented, technically motivated and creative. User oriented with a desire to learn client's business requirements.
• Strong inclination for finishing job before project deadline. Flexible and versatile to adapt to any new environment and work on any project.

Technical Proficiency:

Operating Systems: Windows NT/98/2000/XP/2003 Server,Unix, Linux, Sun Solaris.

Languages: T-SQL, CSS, HTML, ASP.NET, C#, .NET Framework, C.

Data Warehouse Tools: SSIS, SSRS, SSMS, Business Intelligence Development Studio, DTS, Enterprise Manager, SQL Profiler.

Databases: MS Access, MS SQL Server 2000/2005/2008/2012, Oracle 8i/9i/10g.

Tools: /Utility,Enterprise Manager, SQL Server Management Studio(SSMS), Database Tuning Advisor, DTS,Analysis Manager, BCP, SQL Profiler.

Reporting Tools: Excel,SQL Server Reporting Services 2012,2008,2005.

Other Tools: MS Office,Visio,MS Excel, MS-Project 2000.

Work Experience:

Confidential Financial Group, Indianapolis, IN

SQL Server BI Developer (SSIS/SSRS)

Description: Confidential Financial Group is a diversified financial services holding company whose businesses provide a range of financial services to consumer and corporate clients. The project involved building a data repository to organize mortgage loan documents that are received from customers,submitted through various branches and different sales teams. Prior to the development of the system the data existed in various RDBMS and post development the system is made as single stop for various needs.

Responsibilities:

• Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems.
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2005 and Flat files.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups etc.
• Involved in ETL architecture enhancements to increase the performance using query optimizer.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Created SSIS packages for Data Conversion using data conversion transformation.
• Configured the loading of data into slowly changing dimensions using Slowly Changing Dimension wizard.
• Advanced extensible reporting skills using SQL Server 2008 Reporting Services (SSRS).
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Developed various types of complex reports like Drill Down, Drill through, Cross tab reports.
• Involved in scheduling,creating snapshots and subscriptions for the reports using SSRS 2008.
• Involved in designing Parameterized Reports for generating Ad-Hoc reports as per the client requirements.
• Coordinated with front-end for implementing logic in stored procedures and functions.
• Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins,Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non clustered indexes.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Involved in upgrading from SQL Server 2005 to SQL Server 2008.
• Advised optimization of queries by looking at Execution Plan for better tuning of the database.

Environment: SQL Server 2012/2008/2005 Enterprise Edition,SQL Server Data Tools, SQL Server Business Intelligence Development Studio (SSIS, SSRS),TSQL,C#, .Net framework, XML, MS Visual Source Safe and Windows Server 2003.

Confidential, Los Angeles,CA

SQL Server BI Developer (SSIS/SSRS)

Description: Confidential is a video-based local search guide and a social networking site. Confidential has 3,500+ exclusive videos of local restaurants, nightlife venues, shopping and other attractions. It provides personalized search results based on each user s unique taste profile. Confidential also provides ability to see what your friends recommend in almost any city worldwide. The application s video library goes behind-the-scenes of the best spots worldwide and is available to stream via 3G connections.

Responsibilities:

• Design/Build Extract Transform Load procedures in SQL Server Integration Services.
• Worked on creating SSIS packages to upgrade SQL Server 2005 to SQL Server 2008.
• Troubleshooting ODBC and OLEDB connection issues in SSIS packages.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Got a detailed understanding of business functionality and took the responsibility of preparing the Functionality Test Plan which was used by testing team while doing their testing process.
• Designed the packages in order to extract data from SQL DB, flat files and loaded into Oracle database.
• Involved in re-design, re-code, and deploy new data extractions using SSIS, and designed and produced documentation of data transformations for all extractions.
• Developed user defined financial reports to provide on demand financial data analysis using SSRS
• Performed data conversions from flat files into a normalized database structure
• Developed numerous ad-hoc reports using SSRS for day to day financial reporting.
• Written and executed complex T-SQL queries using SQL Server Management Studio for back end data validation testing.
• Worked on SSIS and DTS Packages, DTS Import/Export for transferring data from Heterogeneous Database (Text format data) to SQL Server.
• Data migration (import & export BCP) from Text to SQL Server.
• Created interactive reports with SSRS, using the report parameters, query parameters, Filters and Expressions.
• Involved in design, programming, deploy and Unit Testing of requested Reports.

Environment: SQL Server 2008 Enterprise Edition, SSIS 2008, SSRS 2008,.NET Framework, C#, ASP.NET,CSS,T-SQL, VisualStudio.NET IDE, XML, MS Excel, MS Access, Visual Studio 2008.

Confidential Bank,Los Angeles,CA

SQL Server BI Developer (SSIS/SSRS)

Description: Confidential Bank is a full-service commercial bank, providing a broad mix of financial services to businesses and individuals.Among the bank's markets are consumer,small business, middle market,real estate, corporate, correspondent,and trade finance.The project scope was to assist the marketing and sales departments to categorize their customers based on portfolio of services like checking accounts, savings accounts, personal loans and also categorizing them demographically.

Responsibilities:

• Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers.
• Wrote efficient stored procedures for the optimal performance of the system.
• Monitored performance and optimized SQL queries for maximum efficiency.
• Responsible for Creating and Modifying T-SQL stored procedures/ triggers for validating the integrity of the data.
• Created indexed views and appropriate indexes to reduce the running time for complex queries.
• To keep track of data manipulations using Audit functionalities.
• Generated custom and parameterized reports using SSRS.
• Created reports that call sub reports in SSRS.
• Configuration and Deployment of all the Reports (RDL, RDS) across various SDLC environments.
• Actively involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs.
• Responsible for creating datasets using T-SQL and stored procedures.
• Created several packages in SSIS.
• Scheduled the packages to keep extracting the data from OLTP at specific time intervals.
• Used various transformation tasks to create ETL packages for data conversion.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Responsible for rebuilding the indexes and tables as part of performance tuning.
• Used SQL Server Agent for scheduling jobs and alerts.
• Performed Query optimization & Performance Tuning.
• Optimized queries using SQL Profiler and Database engine tuning advisor.

Environment: SQL Server 2008 Enterprise Edition,SQL Server Agent,SSIS 2008, SSRS 2008, C#,T-SQL,Windows 2000/2003 Server, XML, MS Excel, MS Access.

Confidential, Westlake Village, CA SQL Server BI Developer (SSIS/SSRS)

Description:The Move Network provides resources and decision support tools for consumers and real estate professionals to help them navigate all stages of the home-buying cycle. With these tools, consumers have access to the most comprehensive selection of existing homes for sale, property records, rentals, mortgage resources, senior housing, moving resources and more.

Responsibilities:

• Involved in documenting the code for understandability.
• Participated in creating reports that deliver data based on stored procedures.
• Experience in creating snapshots of static reports and configure subscription.
• Encapsulated frequently used SQL Statements into stored procedures thereby reducing the execution time.
• Involved in developing triggers to audit schema changes at the database level.
• Created sub-reports to present more detailed information about the summary.
• Designed and implemented stored procedures and triggers for automating tasks.
• Configured Server for sending automatic mails to the respective people when a SSIS process failure or success.
• Data from various sources like flat files, to SQL Server database Using SSIS Package.
• Used Lookups Transformation to get the data from reference data sets
• Scheduling the SSIS packages and Jobs
• Using SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting so create reports that draw content from a variety of data sources.
• Making a Report as per user requirement using MS Reporting Services 2005/2008.
• Created SSIS Packages to migrate slowly changing dimensions.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2005.
• Worked on improving the performance of the system.
• Created permanent tables, temporary tables and table variables.
• Used Query Analyzer to optimize SQL queries.

Environment: SQL Server 2005/2008,SQL Server Integration Services(SSIS),SQL Server Reporting Services(SSRS),C#,VBScript,ASP.NET,T-SQL,MS Excel 2003, MS SQL Query Analyzer, SQL Profiler.

Confidential, Southplainfield,NJ

SQL Server Developer

Description: Confidential Q/ Q9M/ Q9C are the smart phones (CDMA) developed by Confidential . The most new and effective software s used by these devices are tested and implemented on these phones using the most sophisticated software s.

Responsibilities:

• Interacted with customers to analyze business needs. Provide software product design and developed technical roadmap for the solution through the project lifecycle and beyond.
• Determined the SQL Server Installation. Installed SQL Server Management tools using SQL Server Setup Program.
• Tested the Installation of SQL Server.
• Implemented Triggers for checking complex business conditions, providing security for the tables.
• Physical Implementation of database into SQL Server 2005 using T-SQL.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to administer SQL Server.
• Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity checks, Database Statistics update and Re-indexing.
• Created check constraints to maintain data integrity.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Created Business-Crucial stored procedures and functions to support efficient data storage and manipulation.
• Worked on DTS Package, DTS Import/Export for transferring data from heterogeneous database.
• Data migration (import & export/BCP) from Text to SQL Server.
• Planned complete Back-up of Database and Restored the Database from Disaster Recovery.
• Coordinating post-implementation events such as testing.

Environment: SQL Server 2005/2000,DTS,T-SQL, VSS, VBScript, XHTML, XML, Windows 2000/2003 Server.

Confidential Group, Hyderabad, India

SQL Server Developer

Description: It is one of the nation's leading financial institutions, lending and investment services to individual consumers, as well as to small businesses. It maintains users checking and saving account information, allows users to make a payment, transfer funds.

Responsibilities:

• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in SQL Server 2005.
• Validated change requests and made appropriate recommendations. Standardized the implementation of data.
• Promoted database objects from test/develop to production. Coordinated and communicated production schedules within development team.
• Modified database structures as directed by developers for test/develop environments and assist with coding, design and performance tuning.
• Managed user access and Created new security accounts.
• Performed Backup and restore of databases.
• Developed and implemented database and coding standards, improving performance and maintainability of corporate databases.
• Created the DTS Package through ETL Process to vendors in which records were extracts from Flat file and Excel sources and loaded daily at the server.
• Updated the statistics information for both the old and new servers.
• Assisted with various ad hoc query requests.
• Provided back-end support for functional testing and performance testing.

Environment: SQL Server 2005, T-SQL, DTS Designer, MS-Office, MS-Excel, VSS.