SUMMARY

• 5+ years of experience in Data Modeling, Database Design, Programming, Development and Implementation of Client - Server Applications & Database systems using SQL Server 2000/20 R2/2012.
• Extensive work knowledge in handling huge databases and worked on performance tuning and query optimizations.
• Extensive experience in using Microsoft BI studio products like SSIS, SSAS, SSRS for implementation of ETL methodology in data extraction, transformation and loading.
• Expert in Data Warehouse development starting from inception to implementation and ongoing support, strong understanding of BI application design and development principles.
• Highly experienced in whole cycle of DTS/SQL server integration services (SSIS 2005/2008) Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing Data transfers and ETL Purposes across different servers.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations
• Scheduling and Monitoring ETL Processes using DTS Exec utilities and batch files.
• Expertise in generating reports using SQL Server Reporting Services, Crystal Reports, and MS Excel spreadsheets and Power Pivot.
• Expert in designing Enterprise reports using SQL Server Reporting Services (SSRS 2000/2005/2008 ) generated drill down reports, parameterized reports, linked reports, sub reports, matrix dynamics and filters, charts in SSRS 2005/2008.
• Experience in creating Ad-hoc reports, data driven subscription reports by using Report Builder in SSRS.
• Good knowledge of Data Marts, Operational Data Store (ODS), OLAP, Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling for FACT and Dimensions Tables using Analysis Services.
• Developed OLAP Cubes by using SQL Server Analysis Services (SSAS), and defined data sources, data source views, Dimensions, Measures, Hierarchies, Attributes, Calculations using multi-dimensional expression (MDX), Perspectives and Roles.
• Performed Data Mining activities like Predictive Analysis, Forecasting on central repository for various application and dashboard functionalities
• Writing MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
• Created Dashboard pages in SharePoint Server that use different types of web parts and excel services for reports.
• With the ease of TFS, managed user permissions among team projects and, further made it easy to identify any missing permissions.
• Created Scorecard/Dashboard pages in Performance point server (PPS).
• Used ProClarity tool to analyze the data in the cube by using different features like Chart view, Decomposition Tree, Performance Maps, etc.
• Generated reports from Analysis Services cube by using ProClarity tool.
• Knowledge on DICOM standards.
• Has very strong background in a disciplined software development life cycle (SDLC) process and has excellent analytical, programming and problem solving skills.
• Good team player, Excellent interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.
• Expertise in defining the business process flow and gathering business requirements.

TECHNICAL SKILLS

Languages: T-SQL, PL/SQL, Dynamic SQL, MDX, C, Shell Scripting

Databases: Sybase, MS SQL Server Denali,2012,2008R2,2008,2005,2000

DWH / BI Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), QNXT, Business Intelligence Development Studio (BIDS), Informatica, Visual Studio, Crystal Reports.

Database Design Tools and Data Modeling: MS Visio, ERWIN 4.5/4.0, Star Schema/Snowflake Schema modeling, FACT& Dimensions tables, Physical & logical data modeling and De-normalization techniques, Kimball & Inmon Methodologies

Packages: MS Office, Microsoft Office Suit, Microsoft Office SharePoint Server (MOSS) 2007, Microsoft Performance Point Server 2007

Tools: and Utilities: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Visual Studio .Net, Microsoft Management Console, Visual Source Safe 6.0, DTS, Business Intelligence Development Studio (BIDS), Crystal Reports, Power Pivot, Epic-Clarity, ProClarity, Microsoft Office(MS), Lotus Notes, Excel Power Pivot, Excel Data Explorer, Tableau.

Operating Systems: Windows Vista/XP/2003/2000, NT & Windows 9x, MS-DOS and UNIX.

PROFESSIONAL EXPERIENCE

Confidential - Barrington, IL

SQL/MSBI Developer

Responsibilities:

• Added Maintenance task for newly created tables where tasks are scheduled to run every week to updates the statistics on respective large tables which helps the Query optimizer to choose the correct query plan.
• Worked on the Row Level Locking (RLL) feature which is intended to retire all the STVs that applies row level locking to one or more tables in the MS SQL Server database. As part of this feature, I modified 23 tables. Only tables with less than 1M rows will automatically be reconfigured to RLL.
• Fixed the issue where current version of MS SQL Server unable to create a worktable to store the cursor result. Fixed it by adding INSENSITIVE clause to cursor declaration so that it forces MS SQL Server to materialize the cursor immediately into a worktable and lock on base tables were released.
• Created and modified SQL Requests where these acts as an interface between MS SQL Server and application.
• Provided a patch to resolve the issue raised at one of our customer site where one of the column in the database was out of range. Fixed it by adding 4 billion to make it positive range.
• Having sound knowledge on relationship between exams, studies, series and DICOM images.
• Created views to facilitate easy user interface implementation and triggers on them to facilitate consistent data entry into the MS SQL Server.
• Involved in usage of SSIS Control Flow items (For Loop, Execute package/SQL tasks, Script task, and send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping, Pivot).
• Extensively worked in developing SSIS packages using Derived Column, Conditional split, Script Task, Merge, FTP task and Multicast.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Designed & developed the various SSIS packages for the daily, Hourly, Weekly & Monthly Loads
• Worked on error handling using try and catch blocks and performance tuning using counters in SSIS
• Created SSIS Packages to integrate data coming from Oracle, Teradata databases, Text files and Excel files.
• Deployed SSIS packages by creating configuration files making packages dynamic by creating variables
• Created the dimensional & relational models for various databases for monitoring tools, created database, SSIS standards of development, configuration & deployment of the Packages
• Worked on Common Table Expression which uses rank function to calculate the ranking of clients based on the policies they insured.
• Generated various parameterized and cascading parameterized reports to populate drilldowns, drill through reports as per requirements using SQL Server Reporting Services (SSRS).
• Deployed SSRS reports in SharePoint for web based access for multiple end users.
• Created, implemented and maintained a reporting suite of over 72 standard reports while also customizing many reports to meet individual client needs.
• Created different types of reports like List, Cross-tab, Chart, Drill-Thru and Master-Detail
• Experience in creating Multidimensional cubes using SSAS and designing DW schemas.
• Enhanced the functionality of OLAP Cube by creating KPI, Actions and Perspective from huge dataset using SQLServer 2012 Analysis Services (SSAS).
• Created DSV, Cubes, and Dimensions, DMX/MDX for SSAS Reports.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
• Created temp tables in the stored procedure to improve the performance.
• Created tables, stored procedures, DDL/DML triggers, views, functions and cursors using T-SQL.
• Worked extensively on clearcase and had sound knowledge on VOB, labels, branches.

Environment: MS SQL Server 2012, putty, UNIX, Shell scripting, TSQL, Confluence, Collaborator, ALM, Clearcase.

Confidential - Eden Prairie, MN

SQL /BI Developer

Responsibilities:

• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• Monitored performance and optimized SQL queries for maximum efficiency.
• Created and Automated SQL Server jobs utilizing DTS, triggers and T-SQL stored procedures to migrate data from a staging environment, through the Data Warehouse, into various data Marts for analysis purposes.
• Extensively used Joins to simplify complex queries involving multiple tables.
• Involved in integrating Share Point Server with SSRS and deploying SSRS reports on to Share Point Server.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse and data marts.
• Created efficient, robust SSIS packages for data movement and loading with error checking and well documented code.
• Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Data management and data processing solutions using SSIS, this includes Error Handling and Slowly Changing Dimensions
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Developed DTSX packages to extract, transform and load into the Campaign database from OLTP database using of SQL Server Integration Services (SSIS).
• Wrote stored procedures and User Defined Scalar Functions (UDFs) to be used in the SSIS packages and SQL scripts.
• Created Linked reports and Ad-hoc reports based on the requirement. Linked reports were created in the Report Server to reduce the repetition the reports.
• Created multiple SSIS packages to extract, validate, transform, load data and generate files for various project specific functionalities.
• Created Tabular reports, Matrix reports, List reports, Parameterized reports, Sub reports.
• Designed and implemented modular and reusable ETL processes and associated data structures for Data Staging, Change Data Capture (CDC), Exception Handling, Surrogate Key Generation & Assignment, Data Lineage Tracking, and ETL Auditing.
• Maintained databases with Data Base Consistency Checks (DBCC) such as Rebuilding Indexes and Integrity Checks.
• Having hands on experience in DR Processes including Log shipping and Database Mirroring.
• Experience in building SSIS packages (.dtsx) involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.
• Hands on experience working with SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.
• Implementing all high availability techniques like clustering, log shipping, replication.
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Created Dashboards using SSRS.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).
• Designed and deployed various professional reports withSSRStools, utilizing Dynamic and Cascading Prompts, sub-reports, conditional and dynamic reports.
• Developedheavy formatted, complex formula reports; reports with advanced features likeconditional formatting, andmultiple groupingreports.
• Created different Power Pivot reports as per the client requirement.
• Creation of Tabular model in SSAS for creating Power pivots, Power view reports and Dashboards.
• Developed reports for business end users using report builder with updating statistics.
• Experience in creating Multidimensional cubes using SSAS and designing DW schemas.
• Involved in creating cubes and dimensions for the new data warehouse using SQL server analysis services (SSAS).
• Created Power View Reports using the Tabular SSAS models in Excel 2010 and 2012
• Advanced knowledge of Excel for using Pivot tables, Power Pivot, Complex formulas.
• Create reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.
• Involved in implementing Key Performance Indicator (KPI) Objects in SSAS 2008. Create Calculate member in MOLAP cube using MDX in SSAS 2008.
• Proficient in writing MDX query and good knowledge of all MDX Functions.
• Defined Relationships Between Dimensions and Measure Groups like Fact Relationship, Many-to-Many Relationship, Dimension Granularity within a Measure Group in SSAS
• Experience in Designing, Building the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS) for analyzing purpose.
• Copied Facet State to XML file using T-SQL.
• Involved in performance tuning using indexing (Clustered Index, Non-Clustered Index) tables.

Environment: Windows2003 Advanced Server, ASP.Net, MS SQL Server 2005/20, TSQL, Pl/SQL, QNXT, Visual Studio 2008, Oracle 11g, Pentaho BI.4.8, Pentaho kettle, SharePoint 2007/2010, Cognos, Qlikview, Lotus Notes, SSRS, SSIS, Jasper Reports 6.1.0 API, OBIEE, Informatica, Erwin.

Confidential - Richmond, VA

SQL /BI Developer

Responsibilities:

• Wrote many stored procedures for cleaning, manipulating and processing data between the databases.
• Scheduled jobs to execute SSIS packages which were developed to update database objects daily and maintained nightly loads of data by creating the corresponding tasks.
• Extensively used Joins and Common Table Expressions to simplify complex queries involving multiple tables.
• Created numerous efficient Stored Procedures to perform data cleansing and loading task when data is loaded into staging area.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
• Created views to facilitate easy user interface implementation and triggers on them to facilitate consistent data entry into the database.
• Migrated DTS packages from SQL Server 2000 to SQL Server 2008 as SSIS Packages.
• Created efficient, robust SSIS packages for data movement and loading with error checking and well documented code.
• Worked on extracting, transforming and loading data using SSIS Import/Export Wizard.
• Created SSIS Packages to integrate data coming from Text files and Excel files
• Created different Power Pivot reports as per the client requirement.
• Created Power View Reports using the Tabular SSAS models in Excel 2010 and 2012
• Advanced knowledge of Excel for using Pivot tables, Power Pivot, Complex formulas.
• Create reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.
• Created SSIS Packages to integrate data coming from Text files and Excel files.
• Migrated old data from MS Access into SQL Server 2008 using SSIS Packages in Business Intelligence Development Studio.
• Created SSIS packages to validate, extract, transform and load data to data warehouse databases.
• Migrated all DTS packages to SQLServer Integration Services (SSIS) and modified the package according to the advanced feature of SQL Server Integration Services.
• Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups using SSIS tasks.
• Experience in handling parameterized reports in SSRS.
• Used cascaded parameters to generate a report from two different data sets.
• Worked on Database Compression for different databases to save space across different environments.
• Reports by using cognos tool for business users.
• Identified and worked with parameters for parameterized reports in SSRS.
• Migrated and resolved conversion errors for Performance Point Server reports to SharePoint 2010 Business Intelligence platform.
• Experience in using global variables, expressions and functions for the reports.
• Developed different kind of reports such a sub reports, charts, matrix reports, linked reports.
• Assisted business users and end users to schedule and creating subscriptions to provide reports on a daily/weekly/monthly/Quarterly and annual basis.
• Enhanced the functionality of OLAP Cube by creating KPI, Actions and Perspective from huge dataset using SQLServer 2008 Analysis Services (SSAS).
• Created DSV, Cubes, and Dimensions, DMX/MDX for SSAS Reports.
• Involved in writing on complex MDX Function for cube creation.
• Supported in creating KPI, calculation members and measure groups, and MDX queries.
• Created complex SSAS cubes with multiple fact measure groups and multiple dimension hierarchies based on the OLAP Reporting needs.

Environment: Windows2003 Advanced Server, ODBC, MS SQL Server 2005/2008/2012 , TSQL, Visual Studio 2008, Oracle, SSRS, SSIS, Erwin.

Confidential

SQL Server Developer

Responsibilities:

• Interacted with Team in Analysis, Design and Develop database using ER Diagram, Involved in Design, Development and testing of the system
• Created complex Stored Procedures, functions, triggers, cursors, tables, views, indexes, SQL joins and statements for applications by using T-SQL.
• Involved in database design, development of database Tables, Roles, and Users in SQL Server.
• Design and Creation of logical storage (Table spaces, Segments etc.).
• Hands on experience in Importing and Exporting Data from/to Oracle to SQL Server and other database servers.
• Creating and maintaining complexstored procedures, ExtendedSystem SP,Triggers,views,Tables, user defined functions,DBCC commands.
• Implemented DatabaseMirroringandLog Shippingas part ofDisaster Recovery.
• ImplementedSQL Logins,Roles and AuthenticationModes as a part ofSecurity Policiesfor various Categories of users.
• Experience in Configuring Linked Servers.
• Experience with index Analyzer and Query analyzer for SQL 2005. Involved in Backup and Recovery Strategies and Point in Time Recovery.
• Normalized and De-normalized the tables and maintaining Referential Integrity by using Triggers, Primary and Foreign Keys.
• Experience in writing Stored Procedures in DW environment and then created packages in SSIS to load the data into Data Warehouse. SSIS package calls these stored procedures for loading the data.
• Responsible for report generation using SQL Server Reporting Services (SSRS) and Crystal Reports based on business requirements.
• Created number of jobs, alerts and operators to be paged or emailed in case of failure for SQL 2005.
• Developed SQL Server Stored Procedures, Tuned SQL Queries (using Indexes) .
• Performeddata analysisanddata profilingusingSQLon various sources systems including SQL Server 2008.
• Extensive knowledge and experience inproducing tables, reports, graphsand listings using various procedures and handlinglarge databases to performdata manipulations.

Environment: MS SQL Server 2005, SQL Integration Server 2005, SQL server Reporting Services 2005, VSS, SQL Profiler, MS Excel 2003, Visual Studio 2005, .NET Frame Work 1.0, Windows XP, Erwin.