SUMMARY

• Over 10.5 Years of IT experience which includes System Analysis and Design, Development & Support of MS SQL Servers 2005, 2008, 2012, 2014, 2016, 2017 in Production, QA and Development Environments.
• Strong development skills with Azure Data Factory, Azure SQL Data warehouse, Azure SQL Database, Azure Storage Explorer.
• Strong experience in Copy activity, Dataflow, Trigger in Azure Data Factory Pipeline Activities for On - cloud ETL processing.
• Extensive experience in Design and Develop ETL Processes data from external sources like Azure blob Storage, Azure Data lake Gen2 and ORC/Parquet/Text Files into Azure SQL Data Warehouse (Azure Synapse).
• Extensive experience using Logic Apps, Power BI Report Server in Azure Environment. Strong experience in Azure migration for existing Data Warehouse from on premise to Iaas VM in Azure Cloud.
• Experience Using Azure Data Factory to upload to transfer data from on premises to Cloud.
• Experience in implement ETL and data movement solutions using Azure Data Factory (ADF), SSIS.
• Experience in Azure SQL Data warehouse by following all the best Practices like Group Inserts, Poly Base to load, Hash Distribute tables, Minimizing transaction size etc.
• Strong experience with T-SQL (DDL & DML) in Implementing & Developing Stored Procedures, Triggers, Nested Queries, Joins, Cursors, Views, User Defined Functions, Indexes, User Profiles, Relational Database Models, Creating & Updating tables and checking the database consistency by executing DBCC Commands.
• Ability to work in all stages of System Development Life Cycle (SDLC).
• Experience in Error handling and debugging coding issues and troubleshoot production problems.
• Extensive Experience in RDBMS concepts such as Tables, User Defined Data Types, Indexes, Indexed Views, Functions, CTE’s, Table Variables and Stored Procedures.
• Experience in using tools like Database Engine Tuning Advisor, SQL Profiler, Index Tuning Wizard and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Expertise in SQL Server 2005, 2008 R2/2012, 2014, 2016, 2017 Reporting Services (SSRS), SQL Server 2005,2008 R2/2012, 2014, 2016, 2017 Integration Services (SSIS) and in SQL Server 2005, 2014, 2016 Analysis Services (SSAS) in Business Intelligence (BI).
• Hands on experience with performing various SSIS data transformation tasks like Look-ups, Fuzzy Look-ups, Conditional Splits and Event Handlers, Error Handlers etc.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) (2000) and SQL Server Integration Services (SSIS) (2005/2008 R2, 2012, 2014, and 2016.
• Experience in upgrading SQL Server 2008/2008 R2/2012/2014 to SQL Server 2016 and data migration among versions. Experience in DTS Migration and Metadata Management: Migrating DTS packages to SSIS, Package Migration Wizard, and Storage Management and Data Quality (DQ). Management of Enterprise-level APIs.
• Experience in the complete life cycle of DTS/SQL Server Integration services (SSIS) Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring for performing Data transfers and ETL jobs across different servers.
• Excellent knowledge of Scheduling Jobs and Alerts using SQL Server Agent.
• Hands on experience in installing, configuring, managing, upgrading and migrating, Backup/Restore, monitoring and troubleshooting SQL Server 2008 R2/2012, 2014, 2016 and 2017.
• Experienced in MS SQL Server planning, installation and configuration of SQL Server on Windows Server 2016, 2012, 2008, 2003 both on physical and virtual environments.
• Experienced in Database Backup, Restore and Disaster Recovery procedures.
• Expert in providing HA solutions support for SQL Server Failover clustered instances, mirroring, log shipping, replication and Always on Availability groups.
• Experience in installing Service Packs and updates for SQL Server instances
• Experience in Database Migration. Migrated SQL Server 2005 to SQL 2014, SQL Server 2008R2 to 2014 and 2016 and 2017.
• Extensive experience in controlling the User Privileges, Monitoring the Security and Audit issues as per Standards.
• Experience in PowerShell for automation and managing multiple SQL Server instances
• Experience in reviewing the entire environment and quantifying the standardization of the databases and servers, worked on enforcement of Microsoft best practice standards
• Experience in developing Dashboard, Ad-hoc and Parameterized Reports, create complex reports (ex: drill down reports using different objects) using SSRS.
• Experience in Configure and maintain Report Manager and Report Server for SSRS, Deployed and Scheduled the Reports in Report Manager.
• Integration of SSRS Reports using various web parts into SharePoint (MOSS 2007) and various delivery mechanisms.
• Experience in Interacting with Business users to analyze the business process and transforming requirements into screens, performing ETL, documenting and rolling out the deliverables.
• Strong Experience in Creating, Configuring, Deploying and Testing SSIS Packages.
• Worked extensively on Extraction, Transformation, loading data from SQL Server, MYSQL, Oracle, DB2, Access, Excel, Flat Files and XML using DTS, SSIS.
• Experience in Performance Tuning in SSIS packages by using semi-blocking, Blocking and Unblocking Transformations.
• Experience in .NET/C# application development environment to use SQL Server Databases.
• Good experience in creating OLAP cubes using SQL Server analysis services (SSAS).
• Experience in working with Database setup, partitions and maintenance.
• Good knowledge of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables using MS Analysis Services.
• Strong knowledge on claim management process, well versed with Medicaid and Medicare services, HL7 message validation, ICD9, Electronic Health Records and Electronic Medical Records.
• Good understanding of Normalization /De-normalization, Normal Form and database design methodology Expertise in using data modeling tools like MS Visio and Erwin Tool for logical and physical design of databases.
• Experience in managing large data sets on MS Excel 2016
• Provided application security support for SQL applications with ADO.NET
• Worked with Business Analysts, Web development team, and users on database solutions.
• Excellent communication and interpersonal skills. Highly motivated and obliged by strong commitment to quality and customer service. Can-Do, Will-Do Attitude, Quick Learner and professionally practical, logical thinking besides efficient Problem-solving skills, Self-directed.

TECHNICAL SKILLS

Tools: &Packages: SQL Server Management studio, Enterprise Manager, SQL Profiler, SQL, Server Business Intelligent studio (BIDS), SSDT, DTS, Report Builder 9.0, 15.0HP QC, ProClarity 6.2, SharePoint 2007, Team Foundation Server Export/Import, Query Analyzer, Red gate, SQL Server Data tools (Visual studio), SQL Server Analysis Service (SSAS)

Azure Cloud: Azure SQL Database, Azure Data Lake, Azure Data Factory (ADF), Azure SQL Data Warehouse, AZURE Analysis Service (AAS), Azure Blob Storage. Infrastructure-as-a-Service (IaaS), Database-as-a-Service (DBaaS), Data Migration Service (DMS), Azure SQL Data.

BI Tools: SSIS, SSAS, SSRS.

Databases: MS SQL Server 2000/2005/2008 , 2012, 2014, 2016, 2017 MS Access 97/2003/2005/2008. Oracle 11g/12c, DB2

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

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

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

Data Modeling Tools: MS Visio, Erwin

Web Technologies: PowerShell, PowerPivot, IIS, HTML, DHTML, XML

PROFESSIONAL EXPERIENCE

Confidential, Clearfield, Utah

Responsibilities:

• Designed and created new data warehouse for new reporting systems as per the industry best practices using star schema.
• Experience in MOLAP (Multidimensional Cube) and ROLAP (RDBMS) to develop customized reports in MS SQL Server database.
• Created OLAP models based on Dimension and Facts for efficient loads of data based on Star Schema structure.
• Design, Develop, test, and deploy ELT/ETL pipelines using Azure Data Factory.
• Developed multiple complex ETL pipelines and activities stores for full and incremental data loads into an Azure SQL Data warehouse.
• Involved in performance tuning (DB Tuning) and monitoring of T-SQL blocks.
• Fine-tuned the logic in Procedures, Functions and Triggers for optimum performance.
• Generated server-side T-SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.
• Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data
• Created and developed data dictionary, tables, views, indexes, functions and advanced queries for databases by using Query Analyzer and SQL Server Enterprise Manager
• Performing data transfer/migration using Export/Import and Data Transformation Services.
• Created new database objects like Sequences, Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server.
• Worked on HORIZONTAL SCALABILITY by dividing the data into different databases mainly to improve the data security and performance purposes.
• Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, Column Mapping, Data dictionary and Metadata.
• Created complex SSIS/ETL packages to load data from various heterogeneous sources to the database and transformed the data accordingly to fit into the current reporting system.
• Designed incremental daily loaded for large and small data warehouses, data marts as per the reporting requirement
• Configured dynamic check points in SSIS package to allow the package to run from the point of failure.
• Expertise use of various SSIS control flow and data flow components in data transformation between source and destination.
• Deployed the packages to Test, QA and Prod environments and provided support whenever needed.
• Created Parameterized, Linked, Snapshot, Cached, Ad hoc, Click through, Drill down, Drill through, Sub reports for top selling plans in the company, top sales based on region and sales based on season.
• Developed different type of reports including: Sales Report, Client Contact Report, Accounting Statement Report, Employee/benefits census report, Benefits statements report, Enrollment count summary report, Billing report and other insurance/payroll/COBRA file transfer reports by using SSRS and SQL Server 2012/2014/2016 /2017.
• Scheduled and managed daily/weekly/monthly sales and operational reports based on the business requirements.
• Involved in design and successful implementation of SSAS cubes and wrote complex MDX and ad- hoc queries.
• Configured Database mail and linked servers between SQL Server to SQL Server, SQL to Oracle Servers, and SQL to MS Access Databases
• Monitored SQL Server Performance and Activity by using SQL profiler
• Monitored Dashboard Reports for Performance Tuning and finding bottlenecks in database.
• Monitored the server’s status, database file growths, disk space alerts etc.
• Experienced in improving/Tuning SQL Server performance using native and third party tools
• Analyze reports for long running queries, locks, deadlocks, backup history check and retention
• Support, troubleshooting of databases and vendors’ application problems
• Scheduled Alerts and Jobs Using SQL Server Agent (Automation)
• Supporting several enterprise-wide high availability systems and services with SLA driven up-time requirements
• Performed SQL administrative tasks including installing and upgrading SQL server products, creating maintenance plans, and creating database objects
• Installed and Configured MS SQL Server 2016 and 2017
• Developed Different Maintenance Plans for database monitoring
• Manual, on Demand and setup jobs for Database Backup, and design backup strategy
• Good knowledge of High Availability (HA), Always On and Disaster Recovery (DR) options for MSSQL Server.
• Maintenance and support of SQL server Mirroring, Log shipping, Clustering, and other methods of disaster recovery
• Configured Snapshot, Transactional and Merge Replications.
• Analyze execution plans and generate suggestions for improvement.
• Performed index and statistics management.
• Worked on Active/Active, Active/Passive, Active/Active/Passive clusters environment.
• Maintains data propagation across the organization based on data capture, data processing, reporting and analytics, data backup and recovery, data access/conflict resolution and data integrity needs while minimizing redundancy
• Performed complex ETL utility functions

Environment: SQL Server 2012/2014/2016 , 2017 Enterprise Edition, Azure Cloud, Azure SQL Database, Azure Data lake, SSAS, SSIS, T-SQL, SSRS, Windows Server 2012R2, OLAP, OLTP, MDX, C#, ASP.Net, Redgate, MS Office 2010, Performance Point Server 2007.

Confidential, Milwaukee, WI

Responsibilities:

• Worked on Data Consolidation/ Data Migration/ Data Quality (DQ) Project building.
• Performed successful installation and configuration of SQL Server 2016 and PowerShell scripting sources.
• Installed SQL Server Data Tools (SSDT) to support SQL data tool functionality.
• Written Data definition language (DDL) and Data Manipulation Language (DML) queries along with dynamic SQL queries and created new SQL Server databases on Azure platform.
• Used C# to access SQL Server to store and retrieve data from databases.
• Created Temporary tables with Temporary variables using Transact SQL (T-SQL).
• Created traces using SQL Server Profiler to find the long running queries and modify those queries as a part of Performance Tuning.
• Created SSIS packages, extracted the data from heterogeneous sources like Flat files, Excel, SQL Server and loaded it into the destination files by performing ETL (Extract, Transform and Load) operations including some transformation tasks such as data conversion, derived column, fuzzy lookup, row count, sort, Aggregate etc.
• Effectively implemented Data Extraction and Loading from OLTP to OLAP systems and scheduled Jobs to call the packages and Stored Procedures.
• Involved in maintaining Data consistency and Data Integrity using various constraints like Unique, Check, Primary Key and Default.
• Collaborated with other teams especially testing team to manage and determine various functionalities of API integrations.
• Created SQL agent jobs for Running SSIS Packages on scheduled basis.
• Implemented error handling, created checkpoints and break points.
• Deployed the packages into Integration Services Database Catalog and then configured those files in different environments like Dev/UAT.
• Defined Backup restore and Data Recovery procedures.
• Created Dim and Fact tables and performed data analysis with multidimensional Cubes written in MDX scripting using SSAS with techniques like slicing and dicing.
• Designed and developed Entity Relationship models with Normalization concepts for star and snowflake schemas.
• Created Reports, Dashboards using SSRS, Excel PowerPivot using DAX scripts and visualized few enterprise level dashboards in Power BI.
• Worked on importing custom visualizations; table and matrix visuals and different level of filters with Power BI.
• Achieved many of the new tasks like making successful connections to different new connection managers and tested the complete package.
• Came across various issues and helped in resolving them while to performing script tasks using Excel Interop.
• Installed and configured different versions of SQL server in Clustered and standalone servers.
• Implemented backup and Recovery strategies based on RPO and RTO
• Maintained User Permissions and Login, assigned the least required permission
• Monitoring Event Viewers, SQL Error logs
• Monitoring and Troubleshooting SQL Server Performance using SQL Server Profiler, System Monitor, Database Engine Tuning Advisor, Dynamic Management Views and Functions and Resolving Blocking and Deadlocking Issues.
• Working on production Break fix issues which include performance, blocking and space related issues.
• Configured, monitored and troubleshoot HA/DR solutions such as Log Shipping, Clustering, Always On Availability Group and Replication (Transactional and Merge). Scheduling and implementing patching activities i.e. Service packs and Cumulative upgrades as per baseline standards.
• Implemented log shipping, Mirroring and Transactional Replication
• Implement Always On Availability Groups for high availability mechanism

Environment: MS SQL Server 2012/2016, Visual studio 2015, TFS, SQL Server Integration Services (SSIS), SQL Server reporting services (SSRS), SQL Server Analysis Services (SSAS), SSDT, Excel PowerPivot, IIS, VBA, C#.

Confidential, Milwaukee, WI

Responsibilities:

• Designed Contract Retention database using SQL Server 2008 technology
• Designed and developed data models for the data warehouse using star and snowflake schema.
• Developed data mapping documentation to establish relationships between source and target tables including transformation processes
• Developed and implemented SSIS 2008 ETL processes to load data from source files to target table
• Created Data Flow Tasks with Merge Joins to get data from multiple sources from multiple servers, with Look Ups to access and retrieve data from a secondary dataset, with Row Count to have the statistics of rows inserted and updated, and worked with Script Task to perform a custom code.
• Worked with Package Variables, with Event Handlers to react to the appropriate error conditions, with SSIS Parallelism, with Package properties to make package more proficient.
• Develop DTS script to migrate data from SQL Server database to Oracle database.
• Develop Procedure and Function using SQL Server database to migrate data to Oracle database.
• Developed Data Migration strategy for the customer to transfer enterprise legacy data to the newly developed ERP application. Reverse engineered various application to develop data mapping between the two applications and implemented PL/SQL migration scripts to load data across multiple table by maintaining data integrity
• Programmed stored procedures, user defined functions, database triggers and packages and all the database objects needed in Oracle environment to implement business logic.
• Managed indexes, statistics and optimized queries by using execution plan for tuning the database.
• Responsible for performance tuning and Optimization of stored procedures using SQL Profiler and Database tuning wizard.
• Created, enhanced, maintained essential Crystal Reports for Operations and HR departments.
• Created additional ad-hoc reports using MS Access for Operations Director.
• Received MS SharePoint 2010 application development covering Visual Studio 2010, SharePoint Designer 2010
• Designed logical and physical database for reporting tool, generating various monthly financial & end user reports and send them to the traders and end users. Also generated reports in different formats such as csv, pdf, rpt & txt etc
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Actively involved in generating Matrix, Sub reports and complex reports with multi value parameters for the analysis of Performance.

Environment: SQL Server 2005/2008 Enterprise Edition, SSAS, SSIS, T-SQL, SSRS, Windows Server 2003, OLAP, OLTP, MDX, C#, ASP.Net, Data Mart, ETL, MS Office 2010, Performance Point Server 2007.

Confidential, Milwaukee, WI

Responsibilities:

• Actively participated in Investors Data related meetings with users, team lead and technical manager to fully understand the requirements of the system.
• Worked on security master which enriches data from Bloomberg and cleanses the data and run the
• Securities data thru workflow and approval process and replicates the data to various systems in the firm.
• Stored Procedures, User Defined Functions, Views, TSQL Scripting for complex business logic.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different Databases.
• Optimized the database by creating various clustered, non-clustered indexes and indexed views.
• Increased the performance necessary for statistical reporting by 25% after performance monitoring, tuning and optimizing indexes.
• Created Alerts for successful or unsuccessful completion of Scheduled Jobs.
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Created logins, users and configuring permissions and assigning roles to users.
• Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
• Used Execution Plan, SQL Server Profiler to trace the slow running queries and tried to Optimize SQL Queries for improved performance and availability.
• Created SQL scripts for tuning and scheduling.
• Worked on programmatically connecting to all the FTP servers to download the files and load into database on daily basis.
• Experience in downloading files from curl scripts and save them into database using C# loaders.
• Worked on scheduling Email trigger jobs to raise an alert to download the files when an email attachment triggers the mail box.
• Developed SSIS Templates which can be used to develop SSIS Packages in such a way that they can be dynamically deployed into Dev, Test and Production Environments.
• Converted DTS 2000 to SSIS 2012 for the new Data warehouse
• Involved in Deployment and Administration of SSIS packages with Business Intelligence development studio.
• Involved in design, implementation of SQL Server 2012 in Dev, test and prod environment.
• Imported and created relation between different data sources and between multiple tables using Pivot table.
• Involved in securing DB applications with ADO.NET and C# scripting.
• Involved in DB management for the new DW both in Dev and Prod environments.
• Performed DB backup, restore and other data base maintenance work.
• Generated reports using report Builder3.0 that could be used to send information to diverse group of users, clients, and managers.
• Generated power reports in Excel 2013 for the users to as per user requirements along with BA.
• Extensive experience in ActiveBatch V9 scheduler. Installed the tool and moved all the scheduled jobs from Prism to ActiveBatch.
• Scheduled and maintained routine jobs, tasks, and alerts using ActiveBatch. For instance, an alert would be sent to the entire Investor team, if any mismatch in the pricing entry by the trading.
• Implemented automated jobs for Database Backup on a weekly and monthly basis, based on the volatile nature of database tables and indexes.

Environment: SSIS/SQL 2008 R2/2012, ActiveBatch v9, ERWIN 8 Data Modeling tool, XML Schema, FTP, BIDS, Visual Studio2010.

Confidential, Newark, NJ

Responsibilities:

• Requirement gathering, Functional & technical specifications for end user and end client applications, Re-Engineering and capacity planning.
• Involved in database Schema design and development.
• Migrated Database from SQL Server 2005 to 2008.
• Experience in using T-SQL for creating stored procedures, indexes, cursors and functions.
• Generated server side T-SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.
• Creating tables, indexes and designing constraints and wrote T-SQL statements for retrieval of data and involved in performance tuning of T-SQL Queries and Stored Procedures.
• Experience in working with Medicare and Medicaid insurance data, Medicare parts A, B, C and D. Insurance pricing, Insurance Claim Adjudication.
• Participated in ICD 9 to ICD 10 codes mapping sessions as well as status meetings and provided necessary suggestions on challenges.
• Executed stored procedures using BATCH files.
• Developed stored procedures and functions for designing various reports.
• Increased the performance necessary for statistical reporting by 25% after performance monitoring, tuning and optimizing indexes.
• Used Batch Files to Import Data from other Data Base.
• Used SSIS to create ETL packages (.DTSX files) to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Wrote the ETL scripts to load the data into database from various source files. Experienced in error handling and troubleshooting the scripts in failure to load the data into database.
• Created SSIS Templates for developing SSIS Packages in such a way that they can be dynamically deployed into Development, Testing and Production Environments.
• Developed DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle using SSIS.
• Created packages in SSIS with custom error handling and worked with different methods of logging in SSIS.
• Created SSIS packages to retrieve data from Legacy sources and also to retrieve PII user data from the Flat files on monthly and weekly basis.
• Expert in SSIS Deploying and Scheduling
• Identified and Defined Key Performance Indicators in SSAS 2005/2008.
• Process SSAS cubes to store data to OLAP databases
• Integrate SQL Server 2005 reporting services with Microsoft Share point Portal Server to deliver automatically generated reports to the Share Point portal.
• Defined report layouts for formatting the report design as per the need.
• Developed Sub Reports, Matrix Reports, Charts, and Drill down reports, using SQL Server Reporting Services.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Created reports and Dash boards using Microsoft Performance Point service.
• Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and send the reports via email.
• In depth knowledge in SSRS for report generation to create various types of reports and also to develop different SSIS packages.
• Administrated the created Reports by assigning permission to the valid user for executing the reports.

Environment: SQL Server 2005/2008 Enterprise Edition, SSIS, SSRS, MS PowerPoint, MS Project, Oracle, PL/SQL, C#, VB.Net, XML, Visual Studio 2008 & 2005, MS Visio 2007, TortoiseSVN.

Responsibilities:

• Understand user requirements and Data Model defined and developed by the business analysts and data architects.
• Performed DBA tasks like Backup, Restore of tables and Stored Procedures and Refreshing Database on weekly basis.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards.
• Implemented different types of constraints on tables.
• Designed and applied entity and attributes description and definition for the models.
• Managed indexes, statistics and tuned queries by using execution plan for optimizing the performance of the databases.
• Maintained the physical database by monitoring and optimizing performance, data integrity and SQL queries for maximum efficiency using SQL Profiler.
• Extract, Transform and Load source data into respective target tables to build the required data marts.
• Migrated data from SAS environment to SQL Server 2005 with SQL Server Integrated Services (SSIS).
• Created ETL process using SSIS to transfer data from heterogeneous data sources.
• Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Migrated DTS objects to SQL Server Integrated Services (SSIS) environment.
• Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Designed SSAS cube to hold summary data for Target dashboards.
• Developed Cube with Star Schema.
• Created usage based aggregations in cube to minimize time for query retrieval from client tool Target.
• Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.
• Responsible for gathering business requirements to create business user reports.
• Created Parameterized, Cascaded, Drill-down, Cross-tab and Drill-through Reports using SSRS 2005.
• Developed optimal stored procedures and queries to create data sets for reports.
• Designed and implemented stylish report layouts.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Played a Content Manager role on report server.
• Worked on performance tuning on existing stored procedures and existing reports for the faster processing of reports.
• Performed unit and system testing, troubleshooting and bug fixing in development and QA environments.

Environment: Microsoft SQL Server 2000/2005/2008 Enterprise Edition, MS Access, ETL Packages (SSRS, SSIS), Great Plains, PL/SQL, C#, VB.Net, ASP.NET, .Net 3.5 SP1, SP2 & 3.0, HTML, IIS, Visual Studio 2008 & 2005, Visual Source Safe, DTS, T-SQL, Oracle 10G, nt scripting, VSS, TFS.