SUMMARY

• Around 9 years of IT experience in Data Design, Development, Integration, Implementation and maintenance on Microsoft SQL Server SQL Server 2000/2005/2008/2008 R 2/2012/2014/2016 , T - SQL,PL/SQL,C#,.Net.
• 4+ years of experience on Health care domain.
• Extensive experience in using Microsoft BI studio products like SSIS,SSAS,SSRS for implementation of ETL methodology in data extraction, transformation and loading .
• Experience in handling the offshore/onsite teams.
• Extensive Experience on Health Care, Financial, Telecom and Insurance domains.
• Experience in system and Business Systems analysis in Health care, withFACETSand extensive interaction with client
• Experience in Worked onFACETSData tables and created audit reports using queries. Manually loaded data inFACETSand have good knowledge onFACETSbusiness rules.
• Involved in FACETS Implementation, FACETS providing, billing, enrollment, and Claim Processing and Subscriber/Membership module.
• Experience on various modules available in Facets and associated batch jobs
• Conducted Business validations for different FACETS modules Providers, Claims, enrollment and Membership.
• Extensive experience with T-SQL in constructing Triggers, Tables, implementing stored Procedures, Functions, Views, User Profiles, Batch Process, Batch Scripts Data Dictionaries and Data Integrity.
• Strong Knowledge on database and data warehousing concepts (OLTP & OLAP) including Star schema and snowflake schema.
• Expertise in OLTP/OLAP System Study, developing Database Schemas like Star Schema and Snowflake Schema used in relational and dimensional modeling.
• Strong Experience in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SQL tools (SSIS, DTS, Bulk Insert, and BCP).
• Good Exposure on Control flow level items, Data flow Transformations and Event Handlers.
• Hands on Experience in Installing, Configuring, Managing, monitoring and troubleshooting SQL Server 2016/ 2014/2012/2008 R 2/2005/2000.
• Great ability to create and manage various database objects like tables, views, stored Procedures Functions.
• Excellent T-SQL development skills to write complex queries involving multiple tables, great ability to develop and maintain stored procedures, triggers, user defined functions.
• Extensive Experience in optimization tools such as Index tuning wizard, SQL Profiler and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
• Experience in Upgradation of SQL Server 2000 databases to SQL Server 2005/ 2008/2012/2014 applying Service Packs and Hot fixes.
• Good Understanding in all the Latest BI Tools Tableau, Qlikview, Power BI and Dashboard Design.
• Good Understanding on data model design by using Waterfall, Agile, RAD methodologies.
• Experienced in using ETL tools in (SSIS) MS SQL 2016, 2014, MS SQL 2012, MS SQL 2008, MS SQL 2005 and DTS in MS SQL 2000.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Teradata and Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
• Data Loading Experience in SQL Server 2005/2008/2010 R2/2012/2014 using SSIS ETL and Experience in developing packages in SSIS and DTS according to task and Data analysis and data migration by transferring them using SSIS Packages.
• Experience in Deploying the SSIS Packages from development server to production server
• Experience with logical and physical data modeling and database design using Erwin.
• Experience in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).
• Excellent knowledge in Developing SSAS Cubes, Aggregation, KPIs, Measures, Partitioning Cube, Data Mining Models, and Deploying and Processing SSAS objects.
• Experience in modifying MDX Cubes and Dimensions in SSAS.
• Provide Operational Support to modify existing Tabular SSAS models to satisfy new business requirements.
• Expert in creating simple and parameterized reports and also complex reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs using SSRS in Business intelligence development studio (BIDS).
• Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through and Drill Down reports using SSRS.
• Extensive Experience in implementation functionalities like Grouping, Sorting, Derived Report parameters by 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).
• Using SSRS creating well-formed reports and web-based reports for health related applications and transactions.
• Worked extensively on migrating ad-hoc reports from SSRS2005 to SSRS 2008, SSRS 2010 R2 tO 2014 using TFS Server.
• Hands on experience towards Migration scenarios, scheduling and publishing the reports
• Expertise inFunctional testing, Manual Testing and Automated Testing, Regression testing, User Acceptance testing (UAT), System testing and Integration testing .
• Created Dashboard pages in SharePoint Server that use different types of web parts and excel services for reports
• Expertise in defining the business process flow and gathering business requirements

TECHNICAL SKILLS

SQL Server Tools: Enterprise Manager, SQL Profiler, SQL Server 2014, SQL Server 2012,SQL Server 2008,SQL Server 2005 Management Studio, DTS, SSIS, SSRS, SSAS, Performance Point Server 2010.

Database: MS SQL Server 2016, 2014, 2012, 2008, 2005, 2000, Oracle 9i/11g and Facet.

Language: C, C++, T-SQL, Dynamic SQL,PL/SQL, ASP.NET, Visual Basic, Core Java, Unix, Perl, Shell.

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

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),SSDT, Power Pivot, Microsoft Office (MS),Excel Power Pivot, Excel Data Explorer, Tableau, Qlick View,TFS,TiDal Enterprise Solution.

Architecture: Relational DBMS, Client-Server Architecture, OLAP, OLTP, OLE-DB, XML, ASP, HTML, FTP.

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

PROFESSIONAL EXPERIENCE

Confidential, Norfolk, VA

MS SQL Server/BI Developer

Responsibilities:

• Understanding the business requirements and designing applications to meet customer needs.
• Expertise in defining the business process flow and gathering business requirements
• Developed and maintained technical documentation from source to target load process and ETL development process.
• Prepared Mapping Documents for Business rules and validation rules.
• Involved in creating and designing packages using SSIS by using the existing tasks and transformations.
• Involved in ETL architecture enhancements to increase the performance using query optimizer.
• Developed SSIS Package using MS SQL Server Integration Services in such a way it loads Every day data from oracle into SQL Server database to store consistent and durable data.
• Created SSIS Packages to integrate data coming from Oracle, Facet databases, Text files and Excel files.
• Experience in Worked onFACETSData tables and created audit reports using queries. Manually loaded data inFACETSand have good knowledge onFACETSbusiness rules.
• Experience in Tidal Enterprise Solution and SQL server Agent for Job Scheduling.
• Analyzed the mainframe reports for member/eligibility/claims and mapped the fields withFACETSbatch jobs and reports.
• Experience in depth knowledge of medical terminology and interpret medical records in
• Facets, HEDIS, etc.
• Experience in Health Care data on Adhered to establish procedures for scheduling, requesting, and reviewing records while on-site Confidential provider offices and hospitals.
• Tested the changes for the front end screens inFACETSrelated to following modules, test theFACETSbatches (membership).
• Involved in testing different interfaces and web application forFACETS.
• Involved in FACETS Implementation, FACETS Providers, billing, enrollment, and Claim Processing and Subscriber/Membership module.
• Conducted Business validations for different FACETS modules Providers, Claims, enrollment and Membership
• Created SSIS packages for Data Conversion using data conversion transformation. Configured the loading of data into slowly changing dimensions using Slowly Changing Dimension wizard.
• Extensively worked in data Extraction, Transformation and Loading from source to target system.
• Implemented Event Handlers and Error Handling in SSIS packages
• Scheduled the ETL Package using TIDAL and SQL Server 2012/2008 R2 Management Studio.
• Experienced in writing complexSQLQueries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and Functions to implement the business logic and also created clustered and non-clustered indexes.
• Involved in creating high levelETLarchitecture for overall data transfer toOLTP, ODSwith the help ofSQLServer2008, 2012Integration services.
• Involved inrelational database modelinglike, designing the tables, algorithmic diagrams for the input data (entity diagrams), indexes etc.
• Experienced in performance tuning using SQL profiler and Monitored SQL Server Error Logs and Application Logs.
• Experience in creating Tablix Reports, Matrix Reports, Parameterized Reports, SubReports using SQL Server Reporting Services 2014/2012/2008 .
• Created many complex adhoc reports like Tabular report, parameter report, drill through, and drill down and parameterized reports in SSRS; and created reports subscription schedulefor managers and clients.
• Applied conditional formatting in SSRS to highlight key areas in the report data.
• Created report snapshots to improve the performance of SSRS.
• Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights by using SSRS.
• Deploying SSIS packages to production systems using Deployment manifest files.
• Scheduled the ETL Package Using SQL Server 2014/2012/2008 R2 Management Studio and Tidal.
• Responsible for unit testing, Peer testing and Integration testing of data warehouse jobs.
• Prepared Unit Test Cases as per our business logic.

Environment: SQL Server 2008/2012/2014 , T-SQL,Oracle11g,FACET Application, Facet Reporting Tool, (SSIS) SQL Server Integration Services, (SSRS) SQL Server Reporting Services, TIDAL Job Scheduling, Erwin, SQL Profiler, MS Excel 2003, Visual Studio 2008-2010, C#, ASP.Net, Visual Team Foundation Server.

Confidential, Dallas, TX

MS SQL Server/BI Developer

Responsibilities:

• The project is designed in two phase’s data gathering and reporting, the data gathering part is done using SQL Server Integration Services (SSIS) and the reporting portion is built on SQL Server Reporting Services (SSRS) platforms
• Developed SSIS Package using MS SQL Server Integration Services in such a way it loads last 4 days data from oracle into SQL Server database to store consistent and durable data.
• 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
• 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
• Developed different varieties of Scorecards, Dashboards & analytical charts using PPS 2010.
• Connected Tableau server to publish dashboard to a central location for portal integration.
• Connected Tableau server with share-point portal and setup auto refresh feature.
• Integrating the PPS 2010 Reports into the SharePoint 2010 as part of a web site.
• Created SQL server reports using 2008/2012 for manager, customer support and that can deliver Confidential client’s station
• Created packages using different transformations like pivot, condition split, fuzzy lookup, aggregate, execute SQL flow task, data flow task to extract data from different databases and flat files
• Designed different type of reports tabular, matrix (cross tab), conditional, list items, charts and sub reports
• Responsible for ongoing maintenance and change management to existing reports and optimize report performance
• Involved in creating cubes and dimensions for the new data warehouse using SQL server analysis services (SSAS)
• Created OLAP cubes in SQL Server Analysis Services 2014/2012/2008 for company wide use. The data being compared in the cubes had never been available together in the same application previously.
• Created SSIS packages using different transformations in SSIS toolbox like aggregate, merge, merge join, pivot etc
• Supported in creating KPI, calculation members and measure groups, and MDX queries
• Updated functional specification and technical design documents. Studied the existing OLTP system(s) and Created facts, dimensions and star schema representation for the data mart and OLAP cubes using SSAS
• Created complex SSAS cubes with multiple fact measure groups and multiple dimension hierarchies based on the OLAP Reporting needs.
• Defined Relationships Between Dimensions and Measure Groups like Fact Relationship, Many-to-Many Relationship, Dimension Granularity within a Measure Group in SSAS
• Experience with SSAS Tabular Model. Experience in creating SSAS cube by using dimensions and measures.
• Experience in creating Tablix Reports, Matrix Reports, Parameterized Reports, Sub Reports using SSRS 2014/2012/2008 .
• Used complex expressions to group data, filter and parameterize reports.
• Created linked reports and managed snapshots using SSRS.
• Designed reports using Microsoft SQL Server Reporting Services (SSRS) 2014 and supporting other analysts by using Report Builder Version 3.0.
• Designed and optimized indexes, views, stored procedures and functions using T-SQL
• Created many complex ad hoc reports like Tabular report, parameter report, drill through, and drill down reports in SSRS; and created reports subscription schedulefor managers and clients.
• Deploying SSIS packages to production systems using Deployment manifest files.
• Scheduled the ETL Package Using SQL Server 2014/2012/2008 R2 Management Studio, Autosys, Ctrl M.

Environment: SQL Server 2014/2012/2008 R2, T-SQL,PL/SQL, (SSIS) SQL Server Integration Services, (SSRS) SQL Server Reporting Services, (SSAS) SQL Server Analysis Services, ETL, MDX, Performance Point Server 2010, Tableau,C#,.net.

Confidential, Seattle, WA

Sr MS SQL Server/BI Developer

Responsibilities:

• Understanding the business requirements and designing applications to meet customer needs.
• Developed and maintained technical documentation from source to target load process and ETL development process.
• Involved in creating and designing packages using SSIS by using the existing tasks and transformations.
• Experience in Worked onFACETSData tables and created audit reports using queries. Manually loaded data inFACETSand have good knowledge onFACETSbusiness rules.
• Experience in Sql server Agent,Tidal Enterprise Solution and SQL server Agent for Job Scheduling on Facet Application.
• Analyzed the mainframe reports for member/eligibility/claims and mapped the fields withFACETSbatch jobs and reports.
• Experience in depth knowledge of medical terminology and interpret medical records in
• Facets, HEDIS, etc.
• Experience in Health Care data on Adhered to establish procedures for scheduling, requesting, and reviewing records while on-site Confidential provider offices and hospitals.
• Tested the changes for the front end screens inFACETSrelated to following modules, test theFACETSbatches (membership).
• Involved in ETL architecture enhancements to increase the performance using query optimizer.
• Created SSIS packages for Data Conversion using data conversion transformation. Configured the loading of data into slowly changing dimensions using Slowly Changing Dimension wizard.
• Extensively worked in data Extraction, Transformation and Loading from source to target system.
• Implemented Event Handlers and Error Handling in SSIS packages
• Scheduled the ETL Package using SQL Server 2012/2008 R2 Management Studio.
• Experienced in writing complexSQLQueries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and Functions to implement the business logic and also created clustered and non-clustered indexes.
• Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2008.
• Created subscriptions in SSRS to deliver reports to a shared file.
• Implemented logical and physical modeling using ERWIN data modeler
• Experience in creating Tablix Reports, Matrix Reports, Parameterized Reports, Sub
• Reports using SQL Server Reporting Services 2012/2008.
• Used Package Configurations to make use of same SSIS package in Dev/Testing/Prod Environments
• Applied conditional formatting in SSRS to highlight key areas in the report data.
• Identified the dimension, fact tables and designed the data warehouse using star schema.
• Created Parameterized reports, Cross-Tab reports, Drill down reports & Summary Reports by using SSRS
• Created new cubes and modified existing cubes using SSAS 2012/2008 to make data available for the decision makers
• Created complex SSAS cubes with multiple fact measure groups and multiple dimension hierarchies based on the OLAP Reporting needs.
• Proficient in writing MDX query and good knowledge of all MDX Functions.
• Created different types of reports like List, Cross-tab, Chart, Drill-Thru and Master-Detail Reports by using cogonos tool for business users.
• Good understanding on Structuring Metadata and Cognos Models using Framework Manager.
• Responsible for code migration across environments (DEV, UAT, Prod).
• Designed user defined hierarchies in SSAS including parent-child hierarchy.
• Created star schema in SSAS and developed SSRS reports based on the cubes.
• Identified and worked with parameters for parameterized reports in SSRS in SQL Server 2008.
• Experience in designing and developing reports on SSRS (SQL Server Reporting Services), SSAS (SQL Server Analytical Services) and OLAP (Creating cubes).
• Involved in developing Cubes in Business Intelligence Development Studio using SSAS.
• Supported in creating KPI, calculation members and measure groups, and MDX queries
• Expertise in OLTP/OLAP System Study, developing Database Schemas like Star Schema and Snowflake Schema used in relational, dimensional and multidimensional modeling.
• Have good experience with designing and implementing MDX queries, OLAP architecture, MOLAP, ROLAP and HOLAP.
• Worked on Report Manager to Subscribe reports, Assign roles, user access with respect to security.
• Build efficient SSIS packages for processing fact and dimension tables with complex
• Transforms and type 1 and type 2 slowly changing dimensions.
• Integrated SQL Server 2008 reporting services with Microsoft Office Share point Server
• To automatically deliver reports to the Share Point portal
• Created mapping tables to find out the missing attributes for the ETL process.
• Used the row count transformation and event handlers control flow to populate the special
• Log tables with high level SSIS package execution results
• Creating source and target table definitions using SSIS. Source data was extracted from Flat files, SQL Server and DB2 Database
• Worked with MDX to query cube’s data.
• Used data profiling task in SSIS 2012/2008 to identify poor data and repair it.
• Created report snapshots to improve the performance of SSRS.
• Improved the accuracy of the source data by implementing data validation on the source data for reporting
• Created partitions of the Analysis Services cube to improve performance.
• Designed reports and tuned them for optimal performance when using multiple parameters
• Used Report Manager to assign roles, permissions and to create report schedules.

Environment: SQL Server 2005/2008, T-SQL, (SSIS) SQL Server Integration Services, (SSRS) SQL Server Reporting Services, (SSAS) SQL Server Analysis Services, ETL, MDX, Erwin, SQL Profiler, MS Excel 2003, Visual Studio 2008-2005, C#, ASP.Net, Visual Team Foundation Server, Visual Source Safe. MS Visio, Cognos 8.2.

Confidential, Los Angeles, CA

MS SQL Server/BI Developer

Responsibilities:

• Created new database objects like stored procedures, Functions, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2008.
• Involving in designing, testing for SSIS Packages to load bulk data into database.
• Gathered requirements for the creation of Data Flow processes for the SSIS packages.
• Used various Control Flow Tasks in the development of various complicated packages.
• Designed and developed SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL server 2008 for further Data Developer and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and Union All.
• Expertise in upgrading from DTS to SSIS packages, Logging, SQL Mail, Check Point, Custom Control Flow, Auditing, Variables Deploying, resolving complex issues and Error Handling in SSIS.
• Involved in developing Cubes in Business Intelligence Development Studio using SSAS.
• Created complex SSAS cubes with multiple fact measure groups and multiple dimension hierarchies based on the OLAP Reporting needs
• 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
• Supported in creating KPI, calculation members and measure groups, and MDX queries
• Updated functional specification and technical design documents. Studied the existing OLTP system(s) and Created facts, dimensions and star schema representation for the data mart and OLAP cubes using SSAS.
• Experience in Developing and Publishing Reports in SQL Server 2008 using SSRS (SQL Server Reporting Services).
• Created various kinds of reports involving Drill Down, Drill through Report, Parameterized Reports and Ad-hoc Reports.
• Designed the Sales and Manufacturing Summary reports in SSRS 2008 from the requirement document.
• Identified and worked with Parameters for Parameterized Reports in SSRS 2008.
• Experienced in performance tuning using SQL profiler and Monitored SQL Server Error Logs and Application Logs.
• Involving in deploying and scheduling SSIS packages.
• Creating Table, matrix, drill- down and drill - through reports and Charts using SSRS.
• Creation of tabular, drilldown and drill through reports.
• As per Client Requirements, creation of tabular, drill down and drill through reports.
• Involving in deploying Reports.
• Rendering the Reports in the form of PDF, EXCEL and CSV to the Clients.
• Implementing subscriptions, caching and securities for reports.

Environment: s: SQL Server 2008, T-SQL,PL/SQL, (SSIS) SQL Server Integration Services, (SSRS) SQL Server Reporting Services, (SSAS) SQL Server Analysis Services, T-SQL,MDX,, BO, C#, .net.

Confidential

MS SQL Server/BI Developer

Responsibilities:

• Analyze the source map documents and creating packages to move the data from source to destination.
• Understanding the Business and its Requirements.
• Creating packages for implementing ETL by using various control flow items for each loop, for loop and data Flow transformations execute SQL, conditional split, multicast, derived column, lookup, sort, union all etc. Did error handling while moving the data.
• Implemented Performance Tuning Confidential various levels.
• Implemented check point configuration, package configuration in packages for better reusability.
• Analyze the specified documents, based on that created cubes, measure groups from the data sources.
• Process the facts dimensions and implemented aggregation on granularity basis.
• Design and development of database scripts and procedures
• Develop the package for ETL process (First Run and Incremental)
• Involved in creation of the package and was responsible for moving the package from development server to production server.
• Involved in creating high level ETL architecture for overall data transfer toOLTP, ODSwith the help ofSQLServer2005, 2008Integration services.
• Involved inrelational database modelinglike, designing the tables, algorithmic diagrams for the input data (entity diagrams), indexes etc.
• Created complex SSIS packages using appropriatecontrol and data flow elementswithSSIS Standards likeerror handling, loggingand working withpackage configuration files.
• Exporting the database from Local server to the remote server and importing the current running database from remote server to thelocal DB Server using SSIS.
• Created complex SSAS cubes with multiple fact measure groups and multiple dimension hierarchies based on the OLAP Reporting needs.
• Defined Relationships Between Dimensions and Measure Groups like Fact Relationship, Many-to-Many Relationship, Dimension Granularity within a Measure Group in SSAS
• Experience on SSAS Tabular Model and SSAS Cube Model and support the existing database components
• Create reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.
• Experience with SSAS Tabular Model. Experience in creating SSAS cube by using dimensions and measures.
• Involved in developing Cubes in Business Intelligence Development Studio using SSAS.
• Created Tablix reports, Tabular/Matrix reports based on requirements.
• Created Dashboards using SSRS.
• Reduced the overallETL time bySQL Query performanceTuning. Discussed with user interface and external interface teams over the performance issues and provided solutions.
• Created databases, tables, and fields for data entry,performingdatabase capacity planning.
• Enhanced anddeployed the SSIS packagesfrom development server to production server andscheduled jobs.
• Supported the production team when issues rose in the packages.
• Creating Table, matrix, drill- down and drill - through reports and Charts using SSRS.
• Involving in deploying Reports.

Environment: SQL Server 2008/2005 / 2000 (2003, 64 bit edition of SQL server 2000), DTS, Microsoft Business Intelligence Development Studio, VB Scripts, SQL Queries, Stored Procedures, Office, Excel, SSRS, SSIS, SSAS, c#, .Net.

Confidential

BI Developer

Responsibilities:

• Created complex Stored Procedures, triggers, cursors, tables, views and other SQL joins.
• Involved in mentoring the developers to follow the guidelines of performance optimization
• Scheduled SSIS Packages for loading Facts and Dimensions.
• Involved in making mappings and transformations using DTS Transform Data Task, Data driven query task
• Creating and Modifying T-SQL stored procedures/triggers for validating the integrity of
• Dealt with huge amount of data and used SSAS in order to retrieve the data
• Defined attribute properties in a Parent Child Dimensions.
• Worked with data extraction using SSIS and Data Warehouse staging, and loading.
• Responsible for hiding and disabling attributes and attribute hierarchies.
• Implementing the calculations to aggregate physical measures.
• Developed reports that deliver data from cubes.
• Created and managed subscriptions for the reports.
• Defined specific read/process permissions for the users in SSAS instance.
• Implemented user based security in SSRS reports to limit the access of reports.
• Responsible for identifying and defining Data Source and Data Source views.
• Created cubes and defined the dimensions.
• Responsible for defining calculated members.
• Created SSIS packages to move data from oracle to SQL Server which involved using
• Various transformations, developing SQL queries
• Designed and deployed monthly sales reports for the business users using SSRS.
• Involved in project planning sessions with project managers, business analysts, and team members to analyze business.
• Involved in Universe developments.
• Used report level filters, URL reporting using parameters passed by hyper links and report variables.

Environment: Windows XP, SQL Server 2005 BI Suite, SSAS, SSIS, SSRS, ASP.NET, T-SQL, MS Visual Studio 2005, BO XI R2 and Crystal Reports, c#, .Net.