SUMMARY

• Over 7 years of IT Professional experience in Development, Client Analysis, Database Design and Presentation using SQL Server 7.0/2000/2005/2008/2012.
• Experienced in Administration and Installation of Windows 2000 Advanced Server, Windows 2003 Enterprise Server and Windows 2008 Enterprise Server.
• Excellent noledge of Normalization/De - Normalization, Data Design methodology and build Referential Integrity across multiple tables.
• Experienced in T-SQL (DDL, DML) documentation, coding, programming and implementation of Business Intelligence solutions using SQL Server 2000/2005/2008/2012.
• Expertise in creating Complex Stored Procedures, Queries for the application team and for the end users based on the business requirement.
• Experienced in SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Data Transformation Services (DTS) and SQL Server Analysis Services (SSAS).
• Involved in Creation and maintenance of Databases, creating Roles and managing user permissions, resolving deadlocks.
• Good experience in Database Administration activities - Installation, Configuration, User Management, Backup and Recovery, Database Mirroring, Log Shipping and with Strong noledge on Clustering concepts.
• Experienced in transforming complex business logic into Database design and maintaining it by using SQL tools such as Stored Procedures, User Defined Functions, Views and DTS.
• Experienced in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous Systems using SQ Server tools like SSIS, DTS, Bulk Insert, BCP and XML.
• Expert in of various source transformations, including flat files, XML and relational systems.
• Expert in developing skills in stored procedures, Ad-Hoc SQL Queries, triggers, UDF, custom DTS packages using Visual Basic.
• Experience in Migration of Data from Excel, Flat file using DTS, SSIS and other ETL Tools.
• Enhanced the functionality in database and data ware housing concepts (OLAP, OLTP) Cube by creating KPI, Actions and Perspective using SQL Server Analysis Services 2008(SSAS).
• Good hands on experience in writing complex Teradata SQL and also on query optimization techniques.
• Extensive experience on .NET, C#, VB.NET, ASP.NET, ADO.NET, Visual Basic 6.0, VBScript, JavaScript, HTML, DHTML, CSS, IIS.
• Experienced in developing Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server 2005 Reporting Services (SSRS).
• Expert in designing report layouts in SSRS and deployed cubes using SSAS.
• Generated reports using SQL Server Reporting Services integrated and deploying them using web applications onto the web servers.
• Monitored strategies, processes and procedures to ensure the Data Integrity and maintained the required level of security for production and test environments.
• Flexible, enthusiastic and project oriented team player with solid communication and leadership skills to develop creative solution for challenging client needs.

TECHNICAL SKILLS

SQL Server Tools: SQL Server Management Studio, SQL Server

Business Intelligence: Development Studio (BIDS).

Languages: C/C++, C#. NET, T-SQL, My SQL, VB.NET, HTML, XML, ASP.Net.

Operating Systems: Windows 95/2000/2003/XP/VISTA/7, LINUX.

Databases: MS-SQL Server 2008/2005/2000.

ETL Tools: Data Transformation Services (DTS), SQL Server Integration Services (SSIS)

Reporting Tools: SSRS, Crystal Reports.

DB Utilities: SQL Server Management Utility, Query Analyzer.

Application Software: Visual Studio, MS Office

Modeling Tools: Erwin 7.2/4.5

PROFESSIONAL EXPERIENCE

Confidential, Los Angeles, CA

SSIS Developer

Responsibilities:

• Involved in writing SQL queries and populate the tables with the appropriate data from the database.
• Involved in writing stored procedures and User Define scalar Functions (UDFs) to be used in the SSIS packages and SQL scripts. Involved in working with Stored Procedures and converting them into CSV Files.
• The ETL process that has been written would need to be placed into a .csv format.
• Responsible for unit testing .csv files and put through QA to ensure that the correct variables are populating the correct spots in each file.
• Review variables received from client in test files and compare against our database. Need to understand variables and state assumptions that are being made.
• Used ETL SSIS to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Based on business requirement, developed the Complex SQL queries with Joins and T-SQL, Stored procedure, Views, Trigger to implementing the business rules and transformations.
• Analyzed database performance with SQL Profiler and Optimized indexes to improve query performance.
• Involved in designing, reviewing, and creating primary objects like Views, Indexes, Stored procedure, Functions, Triggers based on logical design models, user requirements and physical constraints.
• Designed and developed various SSIS packages (ETL) to extract and transform data and involved in Scheduling SSIS Packages.
• Performed cost benefit analysis of different ETL packages (SSIS) to determine the optimal process.
• File posting process will be tested internally and with client.
• Involved in Preparing support documentation.

Confidential, Chicago, Illinois

SQL Server Developer/SSIS/SSRS

Responsibilities:

• Generated Daily, Weekly and Monthly Trigger based reports regarding assigned projects to designated Managers and Clients.
• Involved in deploying the SSIS packages to an instance of SQL server and also to the file system by creating the deployment utility.
• Responsible for the design, development and implementation of dynamic SSIS packages for ETL (extract, transform, and load) development following company standards and conventions.
• Developed Test Scripts based on SSIS packages and Mapping documents.
• Involved in migrating the packages from DTS to SSIS by using Complete Rewrite and Import wizard.
• Generated Dynamic reports from Cubes SSAS using SSRS-2012.
• Developed Unit Test Plans for SSIS packages.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Developed Tabular Reports, Matrix Reports, Drill down Reports and Charts using SQL Server Reporting Services (SSRS).
• Generated various Report models on Views (due to security issues) and deployed them on to the production reporting server and generated various Report models and ad-hoc reports.
• Worked with scheduling and publishing of reports in SQL server reporting services and integration with
• Developed Complex SSRS Reports involving Sub Reports (Matrix/Tabular Reports, Charts and Graphs).
• Modified the existing SSIS packages to meet the changes specified by the users.
• Designed, Developed and Deployed reports in Sql Server environment using SSRS-2005.
• Implemented SSAS Cubes, Facts and Dimension tables to perform analysis.
• Developed XML Web Services and Server Components with C# in .NET Framework.
• Developed Query for generating drill down reports in SSRS 2008.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
• Involved in Creating Stored Procedures to perform calculation and update of data in the database.
• Generated Daily, Weekly and Monthly Trigger based reports regarding assigned projects to designated Managers and Clients.
• Created SQL reports, data extraction and data loading scripts for different databases and schemas.
• Involved in OLTP/OLAP System Study, Analysis and E-R modeling, developing Database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional modeling.
• Implemented SQL Server Log Shipping on the Development Server.
• Involved in project management and coordinated with offshore development team.

Confidential, Chicago,Illinois

SQL Server Developer

Responsibilities:

• Generated various Report models on Views (due to security issues) and deployed them on to the production reporting server and generated various Report models and ad-hoc reports.
• Developed daily, weekly, monthly reports and delivered reports to the required users.
• Maintained various packages, jobs for importing data from Source to solar environment.
• Responsible for Debugging reports using Stored Procedures.
• Created various SSIS packages for the ETL functionality of the data and importing data from various tables to the rollup tables.
• Worked with SQL Server Profiler to generate traces.
• Configuring SQL Mail and setting up Log shipping as a part of Disaster Recovery Plan.
• Setting up and Troubleshooting Microsoft Full Text Search.
• Archived the tables to increase database space.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Created SQL Server Reports using SSRS
• Created Queries for generating drill down reports in SSRS
• Data mapping done to new environments.

Confidential, Atlanta, GA

MS SQL Server Developer

Responsibilities:

• Created stored procedures, scripts, views in Oracle database design and create SQL Database, tables, indexes and views.
• Gathered Business Requirements, Interacted with the Users, Designers and Developers, Project Manager to get a better understanding of the Business Processes.
• Create User Defined Functions, Stored Procedures and Triggers.
• Suggested creating Clustered and Non-Clustered indexes on tables.
• Used DTS for data population from different sources and create DTS packages for data conversions and load data from flat flies or excel files.
• Create database maintenance plans for the performance of SQL Server including database integrity checks, update database statistics, re-indexing and data backups.
• Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large sets of data and used Multi Dimensional expression (MDX) to access them.
• Extensively used Enterprise Manager, Query Analyzer and SQL Server Profiler.
• Developed parameterized crystal reports existing reports for presentations using cross-tab reports, running totals and alerting.

Confidential

SQL Server Developer

Responsibilities:

• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, Joins and
• Other T-SQL code to implement business rules.
• Created parameterized reports and adhoc reports using Report builder for the brokers and clients.
• Formatted the report layout for the requirement of the end users and deploy the developed reports on to the server for the end users.
• Performed System Acceptance Testing (SAT) and User Acceptance Testing (UAT) for databases.
• Performed unit testing and path testing for application.
• Optimized queries tuned and monitored server performance.
• Created triggers for cascading update and delete operations to maintain data integrity.
• Created databases objects like tables, views, indexes and stored procedures.