SUMMARY

• Over 7 years of professional experience in SQL Server database development.
• Efficient in creating joins and sub - queries for complex queries involving multiple tables.
• Strong experience with SQL Server and T-SQL in constructing complex stored procedures, triggers, tables, user functions, views, indexes, user profiles, relational database models, data dictionaries, exceptional handling, and data integrity.
• Strong experience in MS SQL Server with SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS).
• ETL implementation using SQL Server Integration Services (SSIS).
• Excellent in High Level Design of ETL DTS Packages&SSISPackages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided bySSISsuch as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Excellent report creation skills using Microsoft SQL Reporting Services (SSRS).
• Expert in designing Enterprise reports using SQL Server Reporting Services and Excel Pivot table based on OLAP cubes which make use of multiple value selection in Parameters pick list, cascading prompts, matrix dynamics reports and other features of reporting service.
• Experience in creating Ad-hoc reports, data driven subscription reports by using Report Builder in SSRSand ability to export reports and query results to Excel or PDF.
• Expertise in OLTP/OLAP system study, Analysis and developing Database Schemas like star schema and snowflake schema used in relational, dimensional and multidimensional modeling.

TECHNICAL SKILLS

Database: SQL Server 2000, 2005, 2008, 2008 R2,Oracle 9i/10g

Operating Systems: Windows 8, 7, XP/2003/2000.

Programming Languages: T- SQL, PL/SQL.

ETL TOOLS: DTS,SSIS.

DB Concepts: ETL, Dimensional Databases, Star Schema, Snowflake Schema, SQL Stored Procedures, SQL queries, Indexing, Views, Cursors, Triggers, Data Backup.

Reporting Tools: SSRS(2012, 2008R2, 2008, 2005).

Query Tools: SQL 2008 Management Studio, Query Analyzer.

PROFESSIONAL EXPERIENCE

Confidential, Springfield, IL

SSRS, SSIS Developer

Responsibilities:

• Worked on the file import framework process for the various flat files structures to get data imported into our database.
• Created the Stored Procedures, tables, Views depending upon the project requirement.
• CreatedSSISpackages to clean and load data to data warehouse.
• Worked with Business Analysts and Users to understand the requirement.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and files to data warehouse.
• Created tabular, matrix, chart, drilldown reports, and parameterized, cascaded reports according to business requirement.
• Documentation for all kinds of reports and SSIS packages.

Environment: SQL Server 2008, SQL Server Management Studio 2008,SSIS, SSRS

Confidential, Troy, MI

SSRS, SSIS Developer

Responsibilities:

• Created SQL Server Integration Services (SSIS) packages to import data from heterogeneous data sources like Oracle 10g/9i, SQL Server Text files (XML)
• UsedSSISto unite data from existing system and performed transformations on MS SQL 2008.
• Extract Transform Load (ETL) development Using SQL server 2008, SQL 2008 Integration Services (SSIS).
• Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2005 to MS SQL 2008 as well as Created interface stored procedures used inSSISto load/transform data to the database.
• Actively involved in developing ComplexSSRSReports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs.
• Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).
• Used Lookups Transformation to get the data from reference data sets.
• CreatedSSISPackages to migrate slowly changing dimension.

Environment: SQL Server 2008 R2/ 2005 Enterprise Edition, SSAS,SSIS, T-SQL,SSRS, Windows Server 2008, Oracle 9i/10g, MS Excel, MS Access.

Confidential

SSRS, SSIS Developer

Responsibilities:

• Installation, configuration of MS SQL Server 7.0 for development and testing purpose.
• Involved in developing database objects such as procedures, triggers, constraints, indexes and views. Used T-SQL to build dynamic stored procedures.
• Managed Database files, transaction log and estimated space requirements.
• Created SQL server Reports usingSSRS2005.
• Involved in writing Query for generating drill down reports, identified and worked with the parameters to generate parameterized reports along with that extensively used global variables, expressions and functions.
• Identified the data source and the data source views.
• Involved in making stylish report layouts.
• Analyzed reports and fixed bugs in stored procedures on the ongoing database operations, as needed, to resolve business problems.
• Strong experience in developing parameterized, Sub Reports, Matrix Reports, Charts, Drill down, Drill through reports, Interactive sorting and cascading reports using SQL Server Reporting Services 2005(SSRS).

Environment: SQL Server 7.0/2000, Windows XP, SSRS,SSIS, sql, t-sql

Confidential

SSRS, SSIS Developer

Responsibilities:

• Involved in configuring and converting MS SQL Server 2000 database to MS SQL Server 2005.
• Partially involved in Database design and Database objects.
• Created backups for databases.
• UsedSSRSto create, execute, and deliver tabular, matrix, and charts reports.
• Created severalSSISpackages in Microsoft SQL Server 2005.
• Created Test packages to validate theSSISpackages build.
• Created and modified Stored Procedures, Functions, and Indexes.
• Experience in configuration of report server and report manager scheduling in SQL Server Reporting Services (SSRS).
• Expertise in generating reports using MS Reporting Services .
• Experience in generating on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services.
• Excellent hands on experience scheduling and the deployment of the reports and uploading files to a report server catalog from the report manger.
• DesignedSSISpackages to Extract data from different sources like SQL server 2005, MS Excel, MS Access; transform them and then load into Dimension and Fact tables in Data Warehouse using SSIS.

Environment: SQL Server 2000/2005), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Access, Excel.