Summary

• Accomplished software engineer with 7 years of experience through all software development phases from requirements definition, analysis to design, implementation, testing, maintenance and support. Leverages passion, self-motivation, and strong creative problem-solving skills to develop innovative solutions.
• Expert in installing, upgrading, configuring and implementation of MS SQL Server 2000/2005/2008 in windows environment, BI components DTS/SSIS, SSRS .
• Strong experience in SQL Server 2008R2 with Business Intelligence in SQL Server Reporting Services SSRS , SQL Server Integration Services SSIS .
• Expertise in database design, development for OLTP batch processing, online processing , OLAP, ODS, ETL data warehousing, data mining and data modeling.
• Expertise in merging data from heterogeneous data sources like Excel, MS Access, Oracle, and DB2 to MS SQL Server by using import export wizard, DTS, SSIS, and bulk insert utilities.
• Experience in migrating DTS packages to SSIS, migrating databases from SQL 2000 to SQL 2005, and troubleshoot migration issues, importing and exporting packages to SQL Server and file system.
• Has a very good experience in creating SSIS packages to manage SQL server databases and SQL server objects between instances of SQL server.
• Experience in managing and automating control flow, data flow, events and logging programmatically by using Microsoft.NET framework for ETL by SSIS packages.
• Experience in providing logging, error handling by using event handler in SSIS packages, performance tuning in SSIS packages by using row transformations, block and unblock.
• Experience in writing C script for merge the file in command prompt.
• Experience in developing parameterized reports, linked reports, sub reports, create complex reports ex: drill down reports using different objects , drill through reports using SSRS.
• Experience in Different components in integration services other than Microsoft integration services.
• Worked with the developers and provide necessary SQL scripts using T-SQL.
• Experience in creating views, triggers , functions, batch scripts and stored procedures consumed at various stages of migration/cleansing process, reports or data validation.
• Proficient in writing complex T-SQL DDL, DML , using new features like CTE, ranking functions, top n , pivot and building referential integrity constraints.
• Archived the tables and files from business and other teams periodically to increase database free space.

TECHNOLOGY EXPERTISE

• RDBMS : SQL Server 2000/2005/2008
• Languages : SQL, T-SQL, C, VB.NET, C
• Web Technologies : XML, IIS
• ETL Tools : DTS, SQL Server Integration Services SSIS .
• BI Tools : Business Intelligence Development Studio BIDS ,
• SQL Profiler, SQL Query Analyzer, Index Analyzer,
• DTS Import /Export, SQL Server Management Studio.
• Reporting Tools : SQL Server Reporting Services SSRS .
• Operating Systems : Windows NT/98/2000/windows 7/Vista, UNIX, Linux.

Confidential

SQL Server Developer SSIS/SSRS

Responsibilities

• Built ETL design structure using SQL Server Integration Services by incorporating Extraction, Transformation, Load and Purge phases for the Enterprise Warehouse solution.
• Developed and implemented custom logging structure in Event Handlers for all the SSIS packages using SSIS system variable such as Package Name, Package Start Time, etc.
• Designed and implemented data imports from several Point of System servers with SQL Server source as well as CSV flat file sources to Production environment using SQL Server Integration Services.
• Designed, developed and implemented various SSIS Packages and deployed using Deployment wizard.
• Effectively utilized protection level property of SSIS packages for secure storage and transfer.
• Implemented Encrypt AllWithPassword and Server Storage protection level extensively during package development.
• Create script in C for dynamically passing connection string parameters to SSIS packages in development, testing and production environments.
• Implemented parallel execution of SSIS Packages and actively utilized parent propagate property in event handlers for uninterrupted execution of SSIS packages.
• Extensively utilized expression and constraint feature for conditional processing of flat files and flow control in SSIS.
• Created different types of store procedure for the logging and auditing validation purposes.
• Created parameterized reports for the Attorneys and clients.
• Formatted the report layout for the requirement of the end users.
• Deployed the developed reports and upgraded the system.
• Identified slow running query and optimization of stored procedures and tested applications for performance, data integrity using SQL Profiler.
• Generated Daily, Weekly and Monthly reports for the analysis of managers and end users.
• Created complex Stored Procedures, Functions, Triggers, Tables, Indexes, Views, SQL joins and
• T-SQL, PL/SQL code and Ad-hoc SQL Queries to test and implement business rules.
• Designed and implemented data access stored procedures and triggers for automating tasks.
• Designed index, statistics and optimized queries by using execution plan for performance tuning of the database.
• Create a complex store procedure to generate the different format files as per the Client required format.

Environment: Microsoft SQL Server 2008 R2,VSS, Visual studio, SQL Developer, Oracle 11g ,SQL Server Reporting services SSRS ,SQL Server Analysis Services SSAS .

Confidential

SQL Server Developer

Responsibilities

• Gathered user requirements, analyzed and designed of software and database solutions.
• Responsible for the design, development and implementation of dynamic SSIS packages for ETL extract, transform, and load development following company standards and conventions.
• Used various transformations in SSIS dataflow, control flow using for loop containers, and fuzzy lookups.
• Develop parameterized reports, caching reports, sub reports and Ad Hoc reports using SSRS.
• Implemented error handling and utilized event handlers for automated notifications using SSIS.
• Developed stored procedures, functions, views, triggers, and migrated data from different databases to SQL server.
• Defined granularity with in a measure group and drill through actions.
• Wrote the queries for the drill down reports, identified and added the report parameters by using SSRS.
• Worked on using C script task for complex transformations like processing of multiple formatted files.
• Worked on creating simple reports using Report viewer control and ASP.NET with VB.NET and C .
• Formatted the reports using the global variables and expressions in SSRS, deployed the generated reports on to the Reporting server.
• Created SSIS packages for transferring the data from different systems.
• Increased query performance by 20 , which is necessary for statistical reporting after monitoring, tuning, and optimizing indexes by using Performance Monitor and SQL Profiler. Reduced and obliterated unnecessary joins and indexes.
• Transformed the complex business logic and calculations into coding.
• Gathered information about the system and assisted in the development of deliverables. Worked with the clients to gather system requirements.
• Established and created program evaluation and reviewing for the project lifecycle.
• Create and assign various security roles in Reporting Server like Browser role, Report Builder role, Publisher role and Content Manager Permissions.
• Design and develop a reporting schema and deploy into reporting server by using SSRS.
• Developed stored procedures to maintain database integrity and information workflow.
• Implemented and maintain ETL processes SSIS packages to consolidate data from other business units and departments Excel, CSV, and Text .
• Administered the MS SQL Server by creating roles, user logins, monitoring user accounts, granting user permissions to users and groups.

Environment: Microsoft SQL Server 2005/2008 R2 Enterprise edition, TFS, TAOD, Talend, SQL Developer, Oracle 11g ,Windows server 2003, Internet Information Server IIS , MS Excel 2007.

Confidential

BI Developer

Responsibilities

• Created new database objects like Tables, User Defined Functions, Triggers, Procedures, Functions, Indexes and Views, SQL joins and statements as per the developer team's request through team tracks.
• Analyzed performance related queries and tune the same using SQL Query Analyzer to optimize application and system performance.
• Created SSIS packages by using ETL for application that would transfer data among servers and perform other data transformations and scheduled the same SSIS packages by creating the corresponding job tasks.
• Involved in data cleansing to facilitate efficient data transfer between various environments.
• Involved in administration tasks such as importing, exporting and transforming data to support data consolidation using MS SQL Server.
• Created queries for generating drill down reports in SSRS, the report thus developed were more interactive.
• Identified and created data source views, defined advanced attribute and dimensions properties in SSAS.
• Developed Full Analysis Cycle Project and created packages for extracting data from OLTP to OLAP. Created Multi Dimensional Expression MDX scripts for OLAP data cubes.
• Involved in monitoring database maintenance plans for checking database integrity, data optimization, rebuilding indexes and updating statistics.
• All SSIS ETL standards were followed to maintain reliability and scalability in the extraction.
• Import/Export and successfully migrated the Server usage MS Access database data to SQL Server using ETL/SSIS. Created dynamic and customized packages to support future changes. Scheduled the same packages by creating the corresponding job tasks.
• Develop the Report manager in SSRS to view the reports and subscribe reports and manage reports as well as maintain data source and security settings.
• Created Configuration files with XML documents to support the SSIS packages in different environments.
• Scheduled SSIS packages to run as scheduled using SQL Server Agent.
• Configured database mail and created job alert using SSMS to send notification using email.
• Participated in design session and documentation.

Environment: SQL Server 2005/2008, SQL Server Integration Services SSIS /ETL, SQL Server Reporting Services SSRS , Microsoft Office, Windows 2003, Visual Studio, T-SQL, Team Foundation Server TFS .

Confidential

SQL Server/ BI Developer

Responsibilities

• Coordinated with front-end developers for implementing business logic.
• Designed and developed SQL ETL Process SSIS Packages to extract data from several source systems.
• Created Tables, Views, Triggers, Stored Procedures, User Defined Functions and other T-SQL statements for application
• Analyzed the existing application programs and tuned SQL queries using Execution plan, Query Analyzer, SQL Profiler and database Engine tuning Advisor.
• Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
• Performed rebuilding of indexes at regular intervals to reduce page splits.
• Creating Ad Hoc and Parameterized various Reports using SQL server 2005 Reporting Services
• Write Complex SQL Queries to generate Reports based on the business requirement
• Designed and developed Drill down and Drill through reports using SSRS.
• Created Parameterized reports and Linked reports which navigates to other report.
• Deployed created reports and assigned credentials.
• Tested and migrated reports from old application to new.
• Developed reports from the OLTP and OLAP databases using SQL Server Reporting Services.
• Proficiency in RDBMS concepts, SQL scripting.
• Scheduled reports for Daily, Weekly, Monthly reports for various categories and regions based on business needs using Reporting services SSRS
• Designed reports using SQL Server Reporting Services SSRS based on Data Warehouse which makes use of multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports and other features of reporting service.
• Created SSIS Packages to import and export data from Excel Spreadsheets, Text files and CSV files.

Environment: SQL Server 2005 Enterprise Edition, SSRS, SSIS, SSAS, Windows Enterprise Server 2003, Microsoft Visual studio, Microsoft office.

Confidential

SQL Server Developer

Responsibilities

• Involved in various stages like development, system analysis and design, and creating stored procedures. Designed and developed interfaces which were used for connecting to SQL Server database.
• Validated and coded the application using C .
• Debugged and fixed the bugs.
• Designed the logical and physical databases of SQL Server.
• Performed database testing maintaining the data by using the procedures.
• Created DTS packages to get data from different sources, consolidate and merge into one single source.
• Imported and exported database using DTS utility.
• Wrote SQL stored procedures to implement business logic.
• Developed and coded applications in T-SQL.
• Designed a report on the monitoring of server performance using Task manager and Performance Monitor
• This report gives a detail report to the management on the performance of the server.
• Maintained SQL script for creation of database objects.

Environment: SQL Server 2005, SQL Enterprise Manager, Windows 2003, MS Access, MS Excel, C .

Confidential

SQL Server Developer

Responsibilities

• Involved in the development of the system.
• Involved in ER diagrams and mapping the data into database objects.
• Design of the database and tables.
• Installed and configured SQL Server 2000 successfully.
• Built table relationships and wrote stored procedures to clean the existing data.
• Coordinated with the front-end developer to put in the business rules.
• Wrote procedures to check some of the rules at the backend at the time of entering data.
• Developed SQL scripts to insert/update and delete data in MS SQL database tables.
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery.
• Database programming Stored procedure Triggers
• Testing and debugging of procedures.
• Identifying procedures include stored procedures /triggers to speed up application
• Used ADO.NET for fetching and storing of data from SQL Server.
• Used XSLT to create templates.

Environment: SQL Server 2000/2005, Enterprise Manager, SQL Profiler, T-SQL.