SUMMARY

• 10 years of MS SQL Server Development experience in Crop Insurance,Pharmaceuticals, Finance, Telecommunications, and Health Insurance domains with expertise in MS SQL Server 2008/2008r2/2012 suite of products like SSIS, SSRS, and SSAS.
• Experienced in Data Extraction, Transformation and Loading (ETL) using DTS and SSIS of MS SQL Server 2005/2008 respectively.
• Expert in Creating, Configuring and Fine - tuning ETL workflows designed in DTS and MS SQL Server Integration Services (SSIS).
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unlock Transformations.
• Expertise in Developing and Extending MS SQL Server Analysis Services 2005 (SSAS) Cubes, Data Mining Models, Deploying and Processing SSAS objects, and writing MDX queries.
• Experienced in generating On-demand and Scheduled reports for Business Analysis or Management decisions using MS SQL Server Reporting Services 2005/2008 (SSRS).
• Developed Dashboard reports using Power view and Power Pivot.
• Expert in writing Parameterized Queries for generating Tabular reports and Sub reports using Global variables, Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS 2005.
• Highly proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Tables, User Defined Functions, Relational Database models and Data integrity, and SQL joins.
• Experienced in Logical and Physical Database design & development, Data Conversion, Normalization and Data modeling using Erwin and SQL Server Enterprise manager.
• Involved in all phases of software development life cycle: design, development, implementing testing and Staging phases of the projects with supports of Data-Flow, Process Models, E-R Diagrams
• Expert in database creation, maintenance, monitoring, backups and recoveries.
• Excellent interpersonal communication, problem solving, documentation and business analytical skills.

TECHNICAL SKILLS

Databases: MS SQL Server 2012/2008r2/2008, ORACLE, MS Access

Database Tools: MS SQL Server2012/ 2008R2/2008, MS-Access,SSIS(SQL SERVER INTEGRATION SERVICES), DTS,SSAS(SQL SERVER ANALYSIS SERVICES), BIDSAnd Erwin

Development skills: SQL, PL/SQL, SSIS/SSRS/SSAS, Oracle

Languages: T-SQL, C, C++

Operating Systems: Windows 98/NT/2000/XP, 2003 Servers, UNIX.

Tools: /Methodologies MS Visio, Erwin, SQL Profiler, Visual studio.

Reporting Tools: SSRS(SQL SERVER REPORTING SERVICES)

PROFESSIONAL EXPERIENCE

Confidential, Anoka, MN

SSRS Developer

Responsibilities:

• Created Drill-down, Drill-through and Sub-Report using RDL. Promoted RDLs to Reporting Service Server.
• Developed the chart type, tablix, matrix reports inSSRS like enrollment status, Financial Aid, Degree Objective from the OLAP system.
• Used performance Point Services, SSRS, excel as the reporting tools.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS)
• Expert in designing reports using SQL Server Reporting Services (SSRS) and Excel PowerPivot table based on OLAP cubes
• Used cascaded parameters to generate a report from two different Data Sets.
• Involved with Query Optimization to increase the performance of the Report.
• Developed Reports for business end users using Report Builder with updating Statistics.
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2008r2.
• Interacting with the Database Administrator to maintain the database used DBCC Statements to perform maintenance tasks before backing up the databases.
• Interacting with Business Analysts and Developers in identifying the requirements and designing and implementing the Database Schema
• Created reports with different features like drill through capabilities, jump to another report, use of pie charts and bar charts.
• Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.
• Modifying report content and exporting reports in multiple formats based on the business requirements.

Environment: SQL Server 2012/2008r2/2008 Enterprise Edition, T-SQL, SSAS, SSIS, SSRS, VB Script, Enterprise manager, XML, MS PowerPoint, OLAP, OLTP, MDX, Erwin,, MS Access 2008 & Windows Server 2008, Oracle.

Confidential, Mountain view, CA

SQL BI Developer

Responsibilities:

• Involved in creating SSIS jobs to automate the reports generation, cube refresh packages.
• Extensively involved in designing theSSIS packagesto export data of flat file source to SQL Server database
• Involved in designing cubes inSSAS environmentusing Snowflake/ and Star Schemas.
• Created SQL Server Analysis Project usingMS SSAS 2008r2.
• Querying and manipulating multidimensional cube data throughMDXScripting.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Created complexSSAS cubeswith multiple fact measures groups.
• Created Drill-down, Drill-through and Sub-Report using RDL. Promoted RDLs to Reporting Service Server.
• Developed the chart type, tablix, matrix reports inSSRS like enrollment status, Financial Aid, Degree Objective from the OLAP system.
• As a SSRS developer, worked on SharePoint 2010 and Performance Point Services with the basic knowledge of MDX.
• Also worked on Excel 2010, Power Pivot for providing ad-hoc reporting for the clients.
• Created reports with different features like drill through capabilities, jump to another report, use of pie charts and bar charts.
• Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.
• Modifying report content and exporting reports in multiple formats based on the business requirements.

Environment: SQL Server 2012/2008r2/2008 Enterprise Edition, SSAS, SSIS, SSRS, VB Script, Enterprise manager, XML, MS PowerPoint, OLAP, OLTP, MDX, Erwin,, MS Access 2008 & Windows Server 2008, Oracle.

Confidential, IL

SSIS SQL Developer

Responsibilities:

• Designed and developed variousSSIS packages (ETL)to extract and transform data and involved in Scheduling SSIS Packages.
• CreatedETL metadata reportsusingSSRS, reports include like execution times for theSSIS packages, Failure reports with error description.
• Responsible for Data migration fromSQL Server2000 to SQL Server 2005Databases.
• Developed an automated report subscription process usingSSRS.
• Applied conditional formatting inSSRSto highlight key areas in the report data
• Used Report Builder to doAd-hoc Reporting.
• Created report links to refer other reports in a particular report.
• Resolved anydeadlocks issueswith the Databases/Servers on a timely basis.
• Compensation. Assisted (via remote) with payroll, tax, andaccountprocessing.
• Created database objects liketables, users, roles, stored procedures, triggers.
• Used various formatting techniques likeinteractivesorting,groupingto created user friendly reports.

Environment: SQL Server 2008r2, Windows 2000/2003,MS Access 2000/2000,T-SQL,Windows 2000 Advanced Server, SSIS, SSRS, SSAS.

Confidential, Detroit, MI

SSRS Developer

Responsibilities:

• Performed the query tuning to optimize the procedures and triggers to be used in production.
• Developed and executed SQL Server Integration Service packages to extract and populate the data from the various data sources.
• Very extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Created and scheduled SSIS packages to pull data from SQL Server and exported to Excel spreadsheets and vice versa.
• Used various control flow tasks like FTP, Bulk insert task, Transfer job task etc and different data flow tasks.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc) and then loaded the data into destination tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Developed packages with monitoring features and logging so that audit information of the packages and execution results are loaded in to the audit table.
• Created projected income statements and other financial reports. Developed yearly, quarterly, monthly sales reports, bench marking reports and commission reports
• Worked with report parameters and performed Parameterizedand cascading parameterized reports using SSRS.
• Involved in clustering activities using an Active-Passive configuration to achieve high availability.

Environment: Microsoft SQL Server 2008r2/2008 Enterprise edition,SSIS,SSRS,SSAS, BIDS,Oracle 10g,Windows server 2003/2000, Internet Information Server (IIS), MS Excel 2007.

Confidential, Newport Beach, CA

MS SQL Server Developer

Responsibilities:

• Tested to optimize the Stored Procedures and Triggers to be used in production.
• Maintained the client relationship by communicating the daily statuses and weekly statuses of theproject.
• Designed and implemented the Logical and Physical model of the Database using Erwin.
• Worked in Enterprise Manager for job scheduling and batch queries.
• Monitored performance and optimized SQL queries for maximum efficiency.
• Implemented fine tuning of Database objects and server to ensure efficient Data retrieval.
• Planned Backup strategy based on projects requirements.
• Worked closely with developers, end users in designing and creating the Global Enterprise Data warehouse.
• Developed a multi-dimensional database (MDDB) and OLAP cube using SQL Server 2000 that stored and maintained the data.

Environment: MS SQLServer2000, MS Access, Query Analyzer, DTS, BCP, SQL Profiler, Import & Export Data, Windows 2000 Server

Confidential

SQL Server Developer/SSIS

Responsibilities:

• Migrating SQL Server 2000 DTS packages to SSIS packages for uploading various formats of files.
• Schedule jobs to run SSIS package in night feed to DSS system for fresh day data.
• Used DTS migration wizard to convert DTS to SSIS packages and develop new SSIS packages.
• Generated server side T-SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.
• Modified existing databases by adding/removing tables there by altering referential integrity, primary key constraints and relationships according to requirements.
• Created trace in SQL profiler and used database engine tuning advisor for performance tuning on stored procedures and Scripts.
• Created pivot table to provide structured to reports in proper manner like months etc.
• Deployed reports to report manager and trouble shooting for any error occur in execution.
• Scheduled the reports to run on daily and weekly basis in report manager and also email them to director and analysts to review in excel Sheet.
• Planning and scheduling backup strategy to ensure reliable backup.
• Involved created database maintenance plan for the performance of SQL server, which covers database integrity checks, update database statistics and re-indexing.
• Participated in testing during the UAT (QA testing). Mentored and monitored team development and status.

Environment: SQL Server 2000/2005, SSIS, MS Excel 2003, MS Access 2003, Enterprise Manager, Management Studio, SQL Profiler and SSRS.