SUMMARY

• 10+ years of professional IT experience in MS SQL Server Development experience in Finance, Production & Marketing, Telecommunications and Health Insurance domains using SQL server, MS Excel, MS Access.
• 7+ years of Experience in MS SQL Server 2000/2005/2008/2008 R2 and Microsoft’s suite of products like SSIS, SSAS, and SSRS.
• Highly proficient in the use of T - SQL for developing complex Stored Procedures, Triggers, Tables, User Defined Functions, views, indexes, user profiles, Relational Database models, query writing and SQL joins.
• Expert in Performance Tuning, Handling Indexes, and Query Optimization.
• Experienced in creating complex SSIS and DTS packages for ETL purposes. Implemented complicated transformations in the development of SSIS packages.
• Identified and resolved problems encountered during development and release of the SSIS code.
• Developed, Monitored and Deployed SSIS Packages from Development environment to Production environment.
• Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Log Shipping, DTS, Bulk Insert and BCP.
• Experience in working with SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations
• Experience in Deploying the created SSIS packages in Development and Testing environments.
• Good knowledge of RDBMS and Data Warehouse concepts, OLTP & OLAP
• Experienced in Designing, Building the Dimensions, Cubes with Star Schema and Snow Flake Schemas using SQL Server Analysis Services (SSAS) in SQL Server 2005.
• Experience in calculating measures and dimension members using multi-dimensional expression (MDX), creating data source views, named queries, mathematical formulas and user-defined functions in SSAS, and deploying of analysis services projects.
• Proficient in designing Data Mart and Data Warehouse using Star and Snowflake Schemas
• Expert in creating cubes and dimensions, handling multi-dimensional reports
• Generated the Reports with all the subcategory Information to Business users.
• Developed and Deployed different types of Reports like Ad Hoc, List, Drill Down, Drill Through, Matrix, Chart and Sub Reports etc.
• Created and Executed the Stored Procedures and Complex Queries for Reports.
• Strong communication skills when working with stakeholders, developers, project managers, system implementers, and application end-users.
• Ability to handle multiple tasks and responsibilities independently as well as a proactive team member.

TECHNICAL SKILLS

Relational Databases: SQL Server 2008R 2/2008/2005/2000, MS Access.

Tools: and Packages: SQL Server Management studio, SSIS, SSRS, SSAS, DTS, Microsoft Visual Source Safe, SQL Query Editor, BI -Express, Control-M,MS-Office writer, Team Foundation Server(TFS),Office Writer (SSRS-add on)

Languages: T-SQL, HTML, XML,SQL,C, VB.Net, ASP.Net

Operating Systems: Windows vista/XP/2003/2000/NT 4.0/9x, MS-DOS

Web Technologies: HTML, XML, XSL, IIS(4.0/5.0/6/0)

Application Packages: MS Office, MS Outlook (Microsoft Office Suite),Lotus Lotes

BI Tools: SQL Server Reporting Tools (SSRS), SQL Server Integration Services(SSIS), SQL Server Analytical Services (SSAS), Performance Point Server 2007

PROFESSIONAL EXPERIENCE

Confidential, Chicago,Illinois

Sr. MS BI Developer (SQL/SSIS/SSRS/SSAS)

Responsibilities:

• Worked with Business Analysts and Data Architects in analyzing business requirements, specifications and business requirement documents in order to define the optimal solution and identify responsibilities for delivering solutions for data loading and maintenance.
• Prepared Technical Specifications documents for explaining functionality ofSSIS packages, SQL server stored procedures, load/transform data into various target tables, execution process and deployment details.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in different environments.
• Created high level design of SSIS(ETL) Packages for integrating data from heterogeneous sources like (flat file, Oracle, Excel, CSV, SQL Server, Text Format Data) by using Multiple Transformations provided by SSISsuch as Aggregate, Slowly Changing Dimensions, Sort,Merge, Derived Column, Conditional Split, Lookup, Data Conversion andUnion all.
• Involved in daily, bi-weekly, semi-monthly, monthly, annual batch loads (Full & Incremental) into staging and ODS area, troubleshooting load issues and errors using SSIS.
• Developed and created new database objects including tables, views, triggers, stored procedures, user defined functions, complex SQL Queries, clustered and non-clustered indexes to implement the business logic.
• Extensively created SSRS reports such as Drilldown, Drill through, Matrix, Sub Reports, Linked reports, Ad hoc reports as well as interactive reports and automated SSRS reports as per business user requirements and same has been configured in the Production Environment.
• Created custom Report Templates using SSRS, providing consistency of the report throughout the organization.
• Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS.
• Highly involved in creating, structuring, formatting using Report Designer.
• Developed SSAS cubes with multiple fact measures and multiple dimension hierarchies based on the OLAP reporting needs.
• Involved in building Data Marts and multi-dimensional models like Star Schema and Snowflake Schema.
• Defined Schemas, i.e. relationships between Measure groups and Dimensions in SSAS.
• Calculated measures and dimension members using multi-dimensional expression (MDX).
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.

Environment: SQL Server 2012/ 2008R2, T- SQL, C#.net., Visual Studio 2010,SSRS, SSIS, SCRUM, Microsoft Access, Oracle 10g, SQL Server Management Studio, Data Tools/BIDS and Windows Server 2008.

Confidential, WOONSOCKET, RI

Sr. MSBI Developer (SQL/SSIS/SSRS/SSAS)

Responsibilities:

• Actively participate in gathering of user requirement and system specification.
• Responsible for writing SQL queries, stored procedures, views, triggers, T-SQL and SSIS.
• Increased query performance necessary for statistical reporting by 25% after performance monitoring, tuning and optimizing indexes.
• Created/Maintained clustered/non clustered Indexes for fast and efficient reporting process. Indexed views, dimensions and stored outlines for optimal performance.
• Check the performance of each and every query using SQL Profiler, VBScript, Index Tuning Wizard and Estimated query plan optimize the performance tuning of SQL queries and stored procedures.
• Backups and Restoration / Database Recovery, Resource allocation / Monitoring
• Deployed SSIS packages and Reports toProduction Servers.
• Hands on in dropping, truncating and modifying tables with SSIS packages
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS. PL.
• Performing FTP tasks for uploading data on sites.
• Created Datawarehouse Cubes in SQL Server Analysis Service (SSAS).
• Created partition table for very large database for good performance.
• Performing DBA functions, installing, XML, configuring and supporting database systems.
• Generated database monitering and data validation reports in SQL Server Reporting Service (SSRS).
• Reported all events and requirements through established reporting mechanisms in SSRS.
• Reviewed and developed data models and database designs with development teams
• Designed and developed OLAP using MS SQL Server Analysis Services.
• Strong contributor to Team with good communication abilities.

Environment: SQL Server 2008 R 2/2008/2005/2000, Oracle 9i, T-SQL, Excel, MS Access, Advanced Windows 2000/2003 Server, Visual Basic .Net, Query Analyzer, SQL Server Profiler.

Confidential

MS BI Developer

Responsibilities:

• Involved in Migration of Databases from SQL Server 2005 to SQL Server 2008 using SSIS and modified the packages accordingly using advance features.
• Loaded Spatial Data for NUIS into a SQL Server database.
• Created Data migration utilities (Import & Export, Bulk Insert) from text toSQL Server.
• Interacted with Business Analysts, Client team, Development team for Capacity planning and up gradation of System Configuration.
• Implemented Event Handlers and Error Handling inSSIS packages and notified process results to various user communities.
• Performed Database Refresh tasks from production to Development and Staging Servers.
• Created database objects like Tables, Indexes, Stored Procedures, Views, User Defined Functions, Cursors and Triggers.
• Designed and Implemented various reports using Crystal Reports and responsible for the migration to SSRS.
• Taking Database full Backup, Transaction log backup & differential backup in daily Routine.
• Perform bug fixing/troubleshooting.
• Create and execute high-quality test plans.
• Manage and maintain the automation of new and current tests through various test harnesses.

Environment: SQL Server 2008/2005, T-SQL, ArcGIS 10, Arc Objects, Arc SD, SSIS, SSRS, BIDS, MS Access, SQL Server Management Studio, Agile, Visual Studio, Crystal Reports and MS Access

Confidential

SQL Developer

Responsibilities:

• Gathered functional requirements, Business requirements and wrote the technical specifications for building the Global Enterprise Data warehouse.
• Designed and maintained a web reporting environment including portal, VBScript, dashboards, scorecards and presentations using SQL Server 2005 and ASP.Net.
• Implemented transactional replication among different servers to have high availability of the data.
• Created DDL, DML scripts, stored procedures and triggers according to the requirement and designed ad hoc queries on the database tables.
• Created views/indexed views consisting of computed columns to facilitate easy user interface.
• Created and Implemented triggers in T-SQL to facilitate consistent data entry into the database.
• Done High Level Design of ETL using transformations in SSIS Package for integrating data from heterogeneous sources (Excel, CSV, Oracle, flat files, Text Format Data).
• Scripted SQL tasks using .NET and C# using Script task in SSIS
• Developed multi-dimensional databases (MDDB),XML, VBScript, OLAP cubes and data marts using SQL Server Analysis Services that stored and maintained the data.
• Performed final verification procedure for SQL release to production environment.
• Used MDM methodology for managing master Data
• Documented all database changes, followed and enforced change and release management processes.
• Provided on-site support, technical guidance to end-users by developing documentations required.

Environment: SQL Server 2008 R 2/2008/2005/2000, Oracle 9i, T-SQL, Excel, MS Access, Advanced Windows 2000/2003 Server, Visual Basic .Net, Query Analyzer, SQL Server Profiler.