SUMMARY:

• 7+ Years of IT Experience in Database Design, Development and business intelligence of Microsoft SQL Server 2012/2008 R2/2005/2000 in Development, Test and Production Environments wif various business domains.
• Extensive noledge and experience in dealing wif Relational Database Management Systems, including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export Wizard.
• Excellent noledge in creating Databases, Tables, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using T - SQL.
• Experience in writing complex SQL queries involving multiple tables inner and outer joins, stored procedures.
• Experience in creating indexed views, complex stored procedures, effective triggers and useful functions to facilitate efficient data manipulation and consistent data storage.
• Experience in Database Development, Data Warehousing, Design and Technical Management.
• Extensive experience wif data modeling techniques, logical and physical database design.
• Created complex DTS Packages in SSIS for Data Migration from Oracle/MS-Access/MS-Excel Sheets to SQL Server 2005/2008 and Transformation.
• ETL implementation using SQL Server Integration Services (SSIS) in OLTP and Data warehouse Environment.
• Very good experience in Creating, deploying SSIS Packages and migrating DTS Packages from 2000 to 2005/2008.
• Migration of SSRS reports from SQL 2005 to SQL 2008 and SQL 2008 to SQL 2012.
• Experience in enhancing and deploying teh SSIS Packages from development server to production server.
• Worked Extensively on ETL process using SSIS package.
• Experience in creating Jobs, Alerts, SQL Mail Agent, scheduling DTS/SSIS Packages and Backup/Restore of a database.
• Developed reports on SSAS & SSRS on SQL Server (2005/2008/2008R2). Sound Experience and understanding of SSAS, OLAP cube and Architecture.
• Created Reports wif complex formulas and to query teh database for business Intelligence.
• Experience in using variables, Expressions and functions and also defining Query for generating drill down and linked reports in SSRS.
• Experienced in integrating different Microsoft BackOffice Components such as SharePoint and IIS wif MS SQL Server.
• Working Experience on slowly changing dimensions and creating SSIS packages using Active X scripts wif Error Handling.
• Used MDX to interact wif teh back end OLAP Services.
• Experience in Dimensional Modeling, Designing of STAR, SNOW FLAKE Schemas.
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
• Experience in Creation and deployment of cubes on SSAS.
• Expert Knowledge of Integration Services (SSIS), Reporting Services (SSRS) and Analysis Services (SSAS).
• Expertise in using Team Foundation Server (TFS) and Visual source safe (VSS) as a tool for repository of codes and version control, branching and merging into production
• Good understanding in Oracle 9i/10g Database.
• Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up teh SQL Server Performance.
• Experience in Analyzing Execution Plan and managing indexes and troubleshooting deadlocks.
• Experience in Tuning SQL queries and T-SQL queries, MDX & improving teh performance of teh queries.
• Expert in Database designing and creating Indexes, planning and implementing Server Security and autantication, Develop Queries and T-SQL Scripts in MS SQL 2012/2008/2005/2000.
• Excellent analytical, problem solving skills and a motivated team player wif excellent inter-personal skills and familiar wif offshore and multi site development.

TECHNICAL SKILLS:

Databases Tools: SQL Enterprise Manager, Query Analyzer, SQL Server Management Studio, Business Intelligence Development Studio, SQL Profiler, SQL Server Analysis Service (SSAS)

ETL Tools: Data Transformation Services (DTS) - Export/Import, SQL Server Integration Service (SSIS)

Reporting Tools: SQL Server Reporting Services (2000/2005/2008 R2), MS Access, MS Excel

Database: MS SQL Server 2008/2005/2000, MS Access, Oracle 9i/8i

Programming: T-SQL, PL-SQL, C

Web Technologies: HTML, DHTML, XML, XSL, Java Script (Validation), CSS, PERL

Operating Systems: Windows (95/98/2000), Windows 2003/2008 Server, Windows XP, Windows Vista

Other Tools: MS Office Suite (Microsoft Word, Excel, Power Point, MS Visio), OLAP & OLTP, ERWIN, Adobe Photoshop, Abode Flash.

PROFESSIONAL EXPERIENCE:

Confidential, Minneapolis, MN

Sr. MS SQL Server (SSIS/SSRS)/ETL Developer

Responsibilities:

• Developed Complex Stored Procedures, Views and Temporary Tables as per teh requirement.
• Migrated DTS packages from SQL Server 2005 to SQL Server 2008 as SSIS packages.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Worked on different kinds of Transformations in SSIS like Slowly changing dimension (SCD’s), Lookup, Merge, Derived column, Multicast, Conditional split, Aggregate, Fuzzy lookup, Pivot and Un Pivot as per teh client requirement.
• Implemented Logging and Event Handlers on SSIS packages for trouble shooting.
• Excellent report creation skills using Microsoft SQL Server 2008/2005 Reporting Services (SSRS) wif proficiency in using Report Designer as well as Report Builder.
• Created SQL Server Reports based on teh requirements using SSRS 2012.
• Involved in analysis of Report design requirements and actively participated and interacted wif Team Lead, Technical Manager and Lead Business Analyst to understand teh Business requirements.
• Created complex reports which involve more number of groupings and multi-value parameters.
• Rendering teh reports to PDF formats as per teh requirement and printing all teh reports in a batch process for monthly Statements.
• Developed reports like Claim Statements, Fee Bills Transactions and some end request user reports on periodic basis.
• Sound Experience and understanding of SSAS, OLAP and OLTP cube, Data mining and Architecture.
• Created multiple reports wif drop down menu option having complex groupings wifin teh report.
• Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.
• Developed reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Designed, Build teh Dimensions, cubes wif star schema using SQL Server Analysis Services (SSAS).
• Experience in working on Cube structure optimization for MDX query performance in Analysis Services 2008/2005 (SSAS)
• Worked on OLAP Data warehouse, Model, Design, and Implementation.
• Troubleshooting performance issues and fine-tuning queries and stored procedures.
• Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers
• Querying and manipulating multidimensional cube data through MDX Scripting in SSAS.
• Checked teh configuration and performance of teh existing databases including data file allocation, index, fragmentation and impact on system performance. Analyzed potential problems (response delay, locking, server down time, etc) to avoid and optimize by following teh Normalization standards to maintain data consistency and by performing data validation.
• Worked very closely wif Business Customers, End Users and resolved any business process related issues.

Environment: Windows server 2003, IIS 6.0, MS SQL Server-2012/2010/2008/2005 Enterprise Edition, SSIS, SSAS, SSRS, T-SQL, DTS, SQL Profiler, Erwin VB.NET, OLAP, OLTP, Erwin, Performance Point Sever, Office-2007, MS Excel, C#.NET, ProClarity Analysis.

Confidential, Minneapolis, MN

Sr. MS SQL Server (SSIS/SSRS)/ETL Developer

Responsibilities:

• Involved in Normalization of teh database and bringing it to 3NF.
• Developed Complex Stored Procedures, Views and Temporary Tables as per teh requirement.
• Extracting and Loading data into SQL Server Database using SSIS.
• Extensively involved in designing teh SSIS packages to export data from flat file source to SQL Server database.
• Created SSIS Packages to migrate slowly changing dimensions.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Pulling data on a daily basis from OLTP database to OLAP or staging database using teh SSIS packages.
• Performed teh task of data transfer from files in remote server to folders in another server using FTP.
• Created database maintenance plans and deleting of history data using SSIS packages.
• Experience in working on Cube structure optimization for MDX query performance in Analysis Services 2008/2005(SSAS)
• Highly responsible for development and management of PPS, SSAS, SSRS and SSIS projects.
• Building KPI reports for teh cubes and optimizing teh reports.
• Involved in partitioning of cubes in order to increase teh performance of cubes (SSAS).
• Designed SSRS 2008 reports wif Cascaded Parameters, Gauges and Interactive Charts, etc.
• Excellent report creation skills using Microsoft SQL Server 2008/2005 Reporting Services (SSRS) wif proficiency in using Report Designer as well as Report Builder.
• Created SQL Server Reports based on teh requirements using SSRS 2008.
• Created complex reports which involve more number of groupings and multi-value parameters
• Using Sql server reporting services (SSRS) delivering enterprise, Web-enabled reporting so create reports that draw content from a variety of data sources.
• Design and create report models based on users’ requirements, explain and train users to use report builder to generate their own personalized reports.
• Designed, Build teh Dimensions, cubes wif star schema using SQL Server Analysis Services (SSAS).
• Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.
• Developed reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Rendered teh reports to PDF formats as per teh requirement and printing all teh reports in a batch process for Monthly Statements.
• Worked on Logical and physical database development (using ER-win, Normalization, Dimension modeling and Enterprise manager).

Environment: Windows server 2003, IIS 6.0, MS SQL Server-2008/2005 Enterprise Edition, SSIS, SSAS, SSRS, T-SQL, DTS, SQL Profiler, Erwin VB.NET, OLAP, OLTP, Erwin, Performance Point Sever, Office-2007, MS Excel, C#.NET, ProClarity Analysis.

Confidential, Santa Ana, CA

MS SQL Server BI /ETL Developer

Responsibilities:

• Understanding teh Reporting design requirements from teh Architects and Business Analyst.
• Interact wif SME’s and End Users for requirement gathering, process improvement, problem identification, project analysis & review meetings and progress reporting.
• Designed SSIS package for automatic data migration to transform Data from SQL Server 2000 to SQL server 2008.
• Generated periodic reports based on teh statistical analysis of teh data using SQL Server Reporting Services (SSRS).
• Created several Dashboards and Scorecards wif Key Performance Indicators (KPI) in SQL Server Analysis Services (SSAS)-2008/2005.
• Well versed in defining/creating and handling Data Sources, Data Source views and parameterized Reports in SSRS 2008.
• Designing OLAP cubes, Data Modeling, Dashboard Reports, and scorecards according to teh business requirement.
• Served as technical expert guiding choices to implement analytical and reporting solutions for complex financial scenarios.
• Created/Updated Stored Procedures, Triggers, Functions, Views, and Indexes wif extensive use of T-SQL.
• Design and develop SSIS (ETL) packages for loading data from Oracle and Flat files (3GB) to SQL Server Database.
• Created packages in SSIS wif error handling as well as complex SSIS packages using various Data transformations like Lookup, Script Task, and Conditional Split, Derived Column, Fuzzy Lookup, and Partition task, For-Each loop container in SSIS; scheduled teh same SSIS packages by creating teh job tasks.
• SSAS storage and partitions, and Aggregations, calculation of queries wif MDX, Data Mining Models, developing reports using MDX and SQL.
• Participated in creating Jobs for various packages that run at specific schedule every day based on some dependencies.
• Created clustered and non-clustered indexes on tables for new database to faster retrieval of data for teh Reports.
• Understanding teh OLAP processing for changing and maintaining teh warehousing, optimizing Dimensions, Hierarchies and adding teh Aggregations to teh cube.
• Responsible for Process CUBE Partitions and Dimensions.
• Involved in writing MDX queries for various calculated members.
• Experience in Developing and Extending SSAS Cubes, Dimensions and data source view SSAS-Data Mining Models and Deploying and Processing SSAS objects.
• Used SQL Profiler for troubleshooting, Monitoring, Optimizing SQL Server and T-SQL statements from developers and testers.
• Managing teh Report Server contents wif Admin privileges and Report Manager for Subscriptions, Snapshots and Security Content on teh reports
• Helped Quality Assurance Team to generate Test Plans and Test Executions.

Environment: Windows 2003 Server, SQL 2008/2005 Enterprise Edition, Import-Export (DTS), SSRS, SSAS, SSIS, OLAP, OLTP, MDX, T-SQL, ASP.NET2.0, C#.NET, ADO.NET, Microsoft Visual Studio.Net 2005, .NET Framework 2.0, EXCEL2007.

Confidential, West Fargo, ND

SQL BI /ETL Developer

Responsibilities:

• Analyzed all teh Database Structure and prepared a reference guide to understand teh existing system better.
• Created complex Stored Procedures, triggers, cursors, tables, views and other SQL joins and statements for applications.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2005.
• Created SSIS packages to Oracle and other SQL Server instances and used configuration files and variables for production deployment.
• Actively involved in Normalization of database.
• Involved in making mappings and transformations using DTS Transform Data Task, Data Driven Query Task.
• Scheduled SSIS Packages for loading Facts and Dimensions.
• Created packages in SSIS wif error handling.
• Worked wif different methods of logging in SSIS.
• Experience in creating complex SSIS packages using proper control and data flow elements
• Involved in updating slowly changing dimensions strategies.
• Designed cubes wif star schema using SQL Server Analysis Services (SSAS).
• Understanding teh OLAP processing for changing and maintaining teh Warehousing Optimizing Dimensions, Hierarchies and adding teh Aggregations to teh Cube.
• Designed and built OLAP cubes to meet reporting needs.
• Responsible for identifying and defining Data Source and Data Source views.
• Created cubes and defined teh dimensions.
• Responsible for defining calculated members.
• Developed Multi dimensional Objects (Cubes, Dimensions) using MS Analysis Services (SSAS)
• Build MDX queries and Data Mining Expression (DMX) queries for Analysis Services SSAS and Reporting services SSRS.
• Defined attribute properties in a Parent Child Dimensions.
• Used Joins to write queries that retrieve data from more TEMPthan one table.
• Responsible for hiding and disabling attributes and attribute hierarchies.
• Developed reports that deliver data from cubes.
• Responsible for creation of logical data models based on entity-relationship diagrams. Teh models were developed in accordance wif teh rules of referential integrity and normalization.
• Created and managed subscriptions for teh reports.
• Responsible for ongoing maintenance and change management to existing reports and optimize report performance.
• Created stored procedures to calculate pension and annuity information, when called will give teh details for an employee on teh website.
• Defined specific read/process permissions for teh users in SSAS instance.

Environment: Windows 2003/XP, SQL Server 2005 BI Suite, SSAS, SSIS, SSRS, ETL, OLAP, OLTP, ASP.NET, PROCLARITY, MDX, T-SQL, MS Visual Studio 2005.

Confidential, Alpharetta, GA

SQL Developer

Responsibilities:

• Installation of SQL Server on Development and Production Servers, setting up databases, users, roles and permissions.
• Responsible for all technical SQL Server database operations, Administration, ongoing development for various in-house databases.
• Designed and Developed Database Objects like Tables, Stored Procedures, Triggers, Rules, Defaults, user defined data types and functions for this project.
• Created Indexes to get teh high level performance.
• Performing teh ETL operations to support teh data loads and transformations using SSIS.
• Involved in migration from Oracle to SQL Server 2005 using SSIS.
• Generation of reports from teh cubes by connecting to Analysis server from SSRS.
• Used SQL Profiler for troubleshooting, Monitoring, Optimizing SQL Server and T-SQL statements from developers and testers.
• Maintained databases, performed software installations and upgrades, monitored Database Performance.
• Implemented automated backup and database maintenance / cleanup jobs.
• Managing Logins, Users, Roles and User permissions.
• Running Trace from teh Profiler to trouble shoot database and running DBCC consistency checks for other database maintenance aspects.
• Designed numerous ad-hoc and custom reports using SQL Reporting Services.
• Created various Tabular and Matrix Reports using SSRS.
• Created and scheduled jobs for various tasks and also was responsible for maintaining jobs.

Environment: SQL Server 2000/2005, Query Analyzer, SSIS 2005, T-SQL, Excel, Microsoft SQL Reporting Services 2005 (SSRS), Windows 2000/XP, Oracle 7.0

Confidential, New York City, NY

SQL Server Developer

Responsibilities:

• Actively participated and interacted wif users, team lead, DBAs and technical manager to fully understand teh requirements of teh system.
• Worked on teh Reports module of teh project as a developer on MS SQL Server 2005 (using SSRS, T-SQL, scripts, stored procedures and views).
• Extracted data from many operational systems, including flat files, spread sheets and RDBMSs like SQL Server and Oracle 8i
• Conducted and automated teh ETL operations to Extract data from multiple data sources, transform inconsistent and missing data to consistent and reliable data, and finally load it into teh Multi-dimensional data warehouse
• Created reports from OLAP, sub reports, bar charts and matrix reports using SSRS
• Deployed teh SSRS reports in Microsoft office share point portal server MOSS 2007.
• Worked on DTS/SSIS for transferring data from Heterogeneous Database (Access database and xml format data) to SQL Server.
• Involved in Data Integration by identifying teh information needs wifin and across functional areas of an enterprise database upgrade and Migration wif SQL server Export Utility.
• Used DTS/SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML.
• Involved in deployment of SSRS reports on teh SharePoint Portal.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Wrote stored procedures to get teh fields required for teh reports.
• Created datasets using stored procedures and reports using multi value parameters
• Created sub reports, bar charts and matrix reports.

Environment: SQL Server 2005 /2000, 64 bit edition of SQL server 2000), DTS, Crystal Reports, Microsoft Business Intelligence Development Studio, VB Scripts, SQL Queries, Stored Procedures, Office, Excel, SSRS, SSIS, ERWIN.