SUMMARY

• Over 8 Years of IT industry experience with Microsoft SQL Server 2005/2008/R2/2012
• Extensive experience in BI Solutions (ETL & Reporting) using SSIS, SSAS and SSRS.
• Worked with end users/customers to understand business requirements, recommended technical solutions and documented functional requirements.
• 24/7 Support and effectively to production & development issues and taking responsibility for seeing those issues through resolution.
• Strong experience of programming languages like Java, C#, Visual Basics, .Net, Oracle
• Extensive work experience on system analysis, design, development, testing and implementation of projects with full SDLC (Software Development Life Cycle).
• Highly proficient in the use of T - SQL for developing complex Stored Procedures, Triggers, Tables, User Defined Functions, Views, Indexes, User profiles query writing and SQL joins.
• Solid knowledge of Relational Database Management System (RDMS), Data Warehouse Concepts, OLTP and OLAP and experience with Working on SSIS, SSAS, SSRS, Data Analysis, Data Cleansing/Data Scrubbing and Data Migration.
• Worked with T-SQL, DDL, and DML Scripts and established Relationships between Tables using Primary Keys and Foreign Keys.
• Proven ability in Performance Tuning, Query Optimization and Running Database.
• Performing Data transfers between different homogeneous/heterogeneous systems (Excel, MS Access, Oracle and DB2) and SQL Server as a part of Data Migration, Data Maintenance and other ETL tasks.
• Involved in conversion of DTS to SSIS packages and troubleshooting the migration issues.
• Well-versed in usage of SSIS Control Flow items(for Loop, Execute package/SQL tasks, script task, send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping, Pivot).
• ETL implementation using SQL Server Integration Services (SSIS).
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS) (2005/2008).
• Experience in creating configuration files to deploy the SSIS packages across all environments.
• Skilled in error and event handling: precedence Constraints, Break Points, Check points and Logging.
• Expert in Extracting and transforming data (ETL) from various heterogeneous sources and creating packages using SSIS/DTS, Import and Export Data.
• Extensive experience in report generation using SQL Server Reporting Services (SSRS) from both relational databases and OLAP cubes.
• Hands on experience in developing Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Experience in developing various kind of reports like Cascading parameters, Drill down, Drill through, Sub Reports and Charts.
• Proficient in designing Data Mart and Data Warehouse using Erwin Star and Snowflake Schemas.
• Wide experience in creating OLAP cubes, identifying dimensions, attributes, hierarchies and calculating measures and dimension members in SQL Server Analysis Services (SSAS 2005).
• Hands on experience in creating the MDX cubes and dimensions.
• Well versed in using multi dimensional expression (MDX) queries, mathematical formulas, and user-defined functions for developing reports from Multi Dimensional OLAP Cubes.
• Good Knowledge on creating score cards and dash boards using MS Office performance Point Server (MS ProClarity Analytics) Dashboard Designer and integrated them with SharePoint Web Services.

TECHNICAL SKILLS

Tools: &Packages: SQL Server Management studio, Enterprise Manager, Profiler, SQL Server Business Intelligent studio (BIDS), DTS, Report Builder 9.0ProClarity 6.2,SharePoint 2007

BI Tools: SSIS, SSAS, SSRS.

Databases: MS SQL Server 2000/2005/2008 , MS Access 97/2003/2005/2008.

Language: T-SQL, PL/SQL, MDX,C, VB.net, C# (.NET)

Operating Systems: Windows vista/XP/2003/2000, Windows Server 2000/2003/2008 , UNIX.

Application Packages: MS Office Suite, MS Outlook, Windows SharePoint Services.

Data Modeling Tools: MS Visio, Erwin

PROFESSIONAL EXPERIENCE

Confidential, MD

SQL Server Developer/SSIS/SSRS

Responsibilities:

• Implemented Complex business logic with User-Defined-Functions, Indexed Views and also created User Defined Data type, Clustered & Non-clustered Indexes.
• Extensively used all the functionalities of Excel.
• Used some data conversion tasks in SSIS to load the data from flat file to SQL Server database.
• Used T-SQL in constructing Stored Procedures, triggers, cursors, tables, user defined functions, views, indexes.
• Created ETL/SSIS packages both design and code to process data to target databases.
• Created ETL SSIS packages both design and code to process data to target databases.
• Created document for Self-Service Deployment and Execution process for SSIS packages
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Created Tabular reports, Matrix reports, List & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment.
• Created SSRS Report Model Projects in BI studio and created, modified and managed Various report models with multiple model objects, source fields and expressions.
• Highly involved in creating, structuring, formatting using Report Designer and Report Builder.

Environment: SQL Server 2008/2012 Enterprise Edition, SSIS, SSRS, PPS, MS PowerPoint, MS Project, MS Access 2003, Oracle, Business Objects, SharePoint, PL/SQL, C#, Visual Studio 2008,MS Visio 2007.

Confidential, MD

SQL Server Developer/SSIS/SSRS

Responsibilities:

• Involved in complete SDLC life cycle.
• Developed complex SSIS packages to migrate the data from flat files to SSIS.
• Extensively used T-SQL in constructing Stored Procedures, triggers, cursors, tables, user defined functions, views, indexes.
• Worked on different sources in SSIS ( XML, Flat file, Excel, OLEDB Source).
• Created XSLT files for loading the XML data to database.
• Implemented custom error handling in SSIS packages and also worked on different methods of logging.
• Created batch files to load the data from text file to database tables.
• Developed packages to copy tables, schemas and views and to extract data from Excel and from other legacy systems using SSIS.
• Experience in creating Drill down reports, parameterized reports, cascading parameterized reports and drill through reports.
• Created ETL/SSIS packages both design and code to process data to target databases.
• Created SSIS packages to retrieve data from Legacy sources and also to retrieve user data from the Flat files on monthly and weekly basis.
• Experience in performance tuning of SSIS packages.
• Developed SSIS packages and SSRS Reports.
• Created ETL SSIS packages both design and code to process data to target databases.
• Created technical documents for the process of executing the packages
• Experience in creating multiple reports (SSRS) in Drill mode using tables, financial tables.
• Experience in MS SQL Server Configuration, Performance Tuning of stored procedures, SSIS Packages, SSRS Reports.
• Involved in Project tracking using MS Project.
• Performed unit and system testing, troubleshooting and bug fixing in development and QA environments.
• DevelopedSSISpackages(C#,AMO)to deploy, partition and processSSASdatabases
• Designed and developed.NETWeb Servicesfor Supervisory ReportingDashboard (Java web-enabled client) to retrieve data from OLAP database.TheWebService class library generates dynamic MDX based on user's input,utilizingADOMD.NET, AMO, C#, LINQ.
• Fixing some of the production issues.
• Integrate SQL Server 2005 reporting services with Microsoft Share point Portal Server to the Share Point portal.
• Created adhoc reports based on the user requirements and worked on different on-demand reports.
• Worked on source controls VSS (Visual Source Safe), Borland Star team.
• Involved in crystal report generation and also generated EXCEL based reports for business users.

Environment: SQL Server 2005/2008 Enterprise Edition, SSIS, SSRS, PPS, MS PowerPoint, MS Project, MS Access 2003, Oracle, Business Objects, SharePoint,C#.Net,VB.Net, Visual Studio,VBScriptPL/SQL,ASP.NET, XML, Visual Studio 2008 & 2005,MS Visio 2007,Borland StarTeam, Build Forge, Visual SourceSafe.

Confidential, Los Angeles, CA

SQL Server Developer/SSIS/SSRS /SSAS

Responsibilities:

• Migrated DTS packages from SQL Server 2000 to SQL Server 2005 and SQL Server 2005 to SQL Server 2008 as SSIS Packages.
• Implemented Complex business logic with User-Defined-Functions, Indexed Views and also created User Defined Data type, Clustered & Non-clustered Indexes.
• Expert in automating process by creating jobs and error reporting using Alerts, SQL Mail Agent, FTP and SMTP.
• Designed and Developed web-enabled user interfaceforthe main patient-care system administrative reports, utilizing ASP.NET, C#, AJAX, Active Directory Services.
• Gather Day to Day files from FTP, Secure FTP servers, decrypt them and deliver to the respective teams that require the file.
• Used some data conversion tasks in SSIS to load the data from flat file to SQL Server database.
• Extensively used T-SQL in constructing Stored Procedures, triggers, cursors, tables, user defined functions, views, indexes.
• Experience in MS SQL Server Configuration, Performance Tuning, Client-Server Connectivity, Query Optimization, Database Maintenance Plans and Database Consistency Checking DBCC commands.
• Built MDX queries and Data Mining Expression (DMX) queries for Analysis Services & Reporting Services.
• Created ETL/SSIS packages both design and code to process data to target databases.
• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation. Developed, monitored and deployed SSIS packages.
• Created ETL SSIS packages both design and code to process data to target databases.
• Created document for Self-Service Deployment and Execution process for SSIS packages
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Created Tabular reports, Matrix reports, List & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment.
• UsedEvent Handlers for Exception Handling inSSISpackages
• Created SSRS Report Model Projects in BI studio and created, modified and managed
• Various report models with multiple model objects, source fields and expressions.
• Highly involved in creating, structuring, formatting using Report Designer and Report Builder.
• Provided critical Production support when needed.
• Completed revamping on a slow performing workflow to greater than 5 times faster and thus processing larger volume of data/reports and meeting the current SLA.
• Performed database normalization to avoid data redundancy
• Parallely involved in development of stored procedures using Oracle 9i and 10g.
• Parallely involved in development of stored procedures using Oracle 9i and 10g.
• Involved in loading the data from flat file to oracle database.
• Involved in generating the keyword file from oracle database.

Environment: SQL Server 2005/2008 Enterprise Edition, SSIS, SSRS, PPS, MS PowerPoint, MS Project, MS Access 2003, Oracle, ER Studio, Perforce,AutoSys, Business Objects, SharePoint, PL/SQL, C#,VB.Net,ASP.NET, XML, Visual Studio 2008 & 2005,MS Visio 2007.

Confidential, Simi Valley, CA

SQL Server Developer/SSIS Developer/SSRS Developer

Responsibilities:

• Analyzing the Cobol Programs and writing the Business Requirements for the Reports and Developing SQL Stored Procedures and Reports Using SSRS2005.
• Implemented various DDL modifications and developed Script libraries for generating Tables, Views and Functions for Reports.
• Developed complex SQL Scripts for various data manipulations and validations across ETL, Reporting and OLTP systems.
• Scheduling Jobs for SSIS packages, Backups and Restore databases in Dev environment for debugging purposes.
• Extensively used triggers, stored procedures with complex joins and Sub-Queries to simplify complex queries involving multiple tables.
• Involved in developing SSIS packages using BIDS for Incremental loading process including getting data from transactional system in to data ware house and then making data available to be viewable in the cube.
• SSRS installation and report server configuration to Support all Renders of Reports.
• Developed reports using SSRS 2005. Used table control, matrix control for cross tab reports.
• Writing queries to generate reports for analysis of data using SQL Server Reporting Services, Report Builder.
• Created packages in SSIS with error handling as well as created complex SSIS packages using proper control flow and data flow elements.
• Experience in enhancing and deploying the SSIS Packages from development server to production server.
• Written and executed complex T-SQL queries using SQL Management Studio for back end data validation testing.
• Creating some Score cards and Dash Board Reports Using SSRS 2008.
• Generated of Ad-Hoc reports as per the client requirements using Report Builder.
• Worked on XML and HTML content and metadata for search engine optimization (SEO) .
• Process improvement activities -- Logging clarifications via QC which led to cost reduction and more efficient way for data tracking and management.
• Review sessions for QA leads on Test Strategies / Test plans / Regression testing to optimize the coverage area including Risk management techniques.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2005/2008.
• Performing query plans and making sure each query is using appropriate indexes.
• Provided on - call 24/7 provide support.

Environment: SQL Server 2005, SSIS, SSRS, ASP, ODBC, MS Excel, MS Access, Windows 2000/XP, IIS 5.0

Confidential

SQL Server Developer

Responsibilities:

• Installed SQL Server Management tools using SQL Server Setup Program.
• Tested the Installation of SQL Server.
• 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, Update Database Statistics and Re-indexing.
• Worked on Complete Backing up of Database and Restored the Database from Disaster Recovery.
• Worked on replication server and managed.
• Fine tuning of database objects and server.
• Worked on DTS Package, DTS Import/Export for Transferring data from Heterogeneous Database.
• Data migration (import & export - BCP) from Text to SQL Server.
• Created Triggers to enforce data and referential integrity.
• Created stored procedures for maintaining SQL Server, Written Stored Procedures for Application Developers.
• Used DTS to migrate the tables to the Data Warehouse. Handled Different DSS (Decision Support System) for various applications.
• To setup, implement, and maintain industry standards in database management.
• Monitoring SQL server performance using profiler to find performance and dead locks.
• Monitoring the servers using spot light third party Quest software.
• Recovering the databases from backup in disasters
• Maintaining the database consistency with DBCC at regular intervals
• Monitoring SQL server performance using profiler to find performance and dead locks.
• Environment: SQL Server 2000/7.0, Transact-SQL, Enterprise Manager, Query Analyzer, SQL Profiler, BCP, OSQL, DTS, Oracle 8i, MS-ACCESS
• Worked on making on the enterprise-wide use of XML applications, content management systems, taxonomies, and search engine optimization.

Environment: SQL Server 2005 Enterprise Edition, T-SQL, Enterprise manager, VBS, MS Office & Windows 2K platform.