SUMMARY

• Around 14+ years of Experience in Data warehousing and BI DEVLOPER.
• Experience in writing complex SQL queries, procedures, functions, packages, cursors, exception handling, triggers, collections and performance tuning.
• Extensive experience in Design, Development, Implementation & Administration of Database systems using MSSQL 2005/2008/2012/2016 for Batch Processing using DDL, DML, DCL commands for various business applications and Data warehousing Systems (SSRS, SSIS, SSAS)
• Creating SSIS packages and executing stored procedures, to load the files into destination tables and sending email notifications.
• Designed dynamic row level security for entire global procurement team wif different level of users utilizing complex DAX functions wifin SSAS tabular model.
• Documenting the types and structure of the business data (logical modeling),
• Analyzing and mining business data to identify patterns and correlations among the various data points
• Involved in creating complex measures including ranking, KPIs, aggregation by DAX in SSAS cubes according to business requirements.
• Create different roles for uses accessing the tabular model. Write complex DAX function to implement row level security and apply the rules for business users assigned to various roles.
• DevelopedPowerBImodel used for financial reporting of P & L and Headcount.
• Involved in building dynamic partitions by using complex DAX function. Optimize the processing of the cube inside the Tabular Model. Write complex process scripts for the cube and use SQL Server Job Agent to automatically refresh data.
• Designed and documented the entire Architecture of Power BI Poc
• Expertise in Power BI, Power BI Pro, Power BI Mobile.
• Have Basic idea of Power Query M formula language
• Expertise in writing complex DAX functions inPower BI and Power Pivot
• Used various sources to pull data intoPower BI such as Sql Server, SAP BW, Oracle, SQL Azure etc.
• Used zappsys for external connectors like Google sheets and AWS and Mongodb for ETL.
• Extract data from S3 bucket using SSIS.
• Having Experience in Migration from Sql server .
• Design and create data reports and reporting tools to halp business executives in their decision making,
• Part of the migration team to validate the packages and update as per new version of the SQL server
• Have extensive knowledge on Ralph Kimball’s and Bill Inmon’s modelling concepts and
• Involved in the creation and deployment of the reports using SSRS and configuring the SQL Server Reporting Server
• Have experience in SaaS / COTS Product Maintenance and Support.
• Experience in database programming in writing T - SQL Stored procedures, Triggers, Contraints (Primary Key, Foreign Key, Unique) Indexes and Batch Scripts using various DDL and DML commands.
• Used integration services (SSIS) to extract data into the tables from Salesforce
• Worked on Insurance projects in health care industry, Medical Claims Experience.
• Experience in developing SSIS packages to bring data from Insurance Claims databases to data warehouse tables.
• Hands-on Experience wif different types of Normal forms (1NF,2NF and 3NF)
• Involved in designing, deploying and processing OLAP Cubes using SSAS for the analysis of data wif pre-calculated aggregations and in summarized fashion which can be modeled into a report accordingly.
• Worked on SSIS Architecture design, SSIS transformations. Whole responsibility for all the deliverables.
• Worked on Database design documentations, mapping the fields between the tables.
• Worked on SQL Server Database design and written queries for Data Cleansing.
• Maintenance of scheduled SQL jobs. Performance tuning & code review.
• Expertise in creating Cubes wif dimensions and Facts Tables in MOLAP Warehouse using SQL Server Analysis Services (SSAS).
• Developing, deploying and debugging distributed systems in a UNIX environment
• Experience in working wifSSASin creatingcubes, data source views, named queries, dimensions and deploying of analysis services projects.
• Knowledge in agile, sprint development projects, data warehouse concept, basic knowledge in scripting language like C# or VB.
• Extensive Knowledge inSSASstorage and partitions, and Aggregations, calculation of queries wifMDX, Data Mining Models, developing reports usingMDXand SQL.
• Designed and developedSQL Server Analysis Services(SSAS) databases andOLAP cubesused in ad-hoc analytic research and automated reporting.
• Experience in creating Jobs, and Sending Alerts using SQL Mail, backups, performance issues, connectivity to databases, upgrade strategies, capacity planning.
• Experience in migrating DTS packages, reports and analysis services projects from SQL Server 2005 to SQL server 2008R2, 2012 and 2014.
• Involved in Huge Data Migrations and Data Transfers using utilities like Data Transformation Services (DTS), and SSIS, Bulk Copy Program (BCP) and Bulk Insert
• Good knowledge in Tuning SQL queries & improving the performance of the Database.
• Strong complex reporting skills - complex Drill-Through, Discontinuous Cross-Tabs, Summary Reports.
• Migrated data from SQL Server .
• Experience in writing expressions in SSRS and Expert in fine-tuning the reports. Created many Drill through and Drill Down reports using SSRS.
• Expert in designing Enterprise reports using SQL Server Reporting Services (SSRS 2005/2008/2012/2014 )
• Expert in creating Parameterized Reports.
• Experience in deploying Reports to Report Server. Creating user interface on Report Server for the users to access reports on Report Manager.
• Hands on experience in Creating Star Schema and Snowflake Schemas.
• Experience in Designing and Building the Dimensions and cubes wif star schema using SQL Server Analysis Services (SSAS).
• Have working knowledge on sales force wave analytics
• Good understanding of Data Marts, Data Warehousing, Operational Data Store (ODS), OLAP, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables using MS Analysis Services.
• Create Users and assign permissions based on the level of database access the user would need.
• Monitor and improve performance of the ETL applications such as Data Stage and SSIS.
• Check for the failed jobs, investigate the route cause and resolve the issue. Native SQL notification alert sends a mail to DBA team and also we can design a customized SSRS report which reports all failed/success job details wif delta value.
• Monitoring and Performance Tuning; Physical Server Level, Database level (Database settings and options) and query tuning
• Documenting major changes to the SQL Servers.
• Created Reports using POWER BI
• Ability to work independently or as part of a team to accomplish critical business objectives and to make decisions under pressure.

TECHNICAL SKILLS

Databases: MS SQL Server 2005/2008r2/2012/2014, Teradata, Mongo DB, AWS

Database Tools: Enterprise Manager, Query Analyzer, SQL Server Management Studio (SSMS), SQL Profiler, Upgrade Wizard, Database Engine Tuning Advisor, Business Intelligence Development Studio (BIDS). Oracle

Reporting Tools: SQL Server Reporting Services (SSRS) 2012/2008/2005 , SAP BW, Tableau, Business Objects 4.1, Salesforce Wave analytics

ETL Tools: SQL Server Integration Services (SSIS), Data Transformation Services (DTS), BCP, SQL Server Analysis Services (SSAS), ABINITIO, Informatica, zappsys

Languages: C, C++, C#, T-SQL

Web Technologies: Web Services, XML, HTML

Operating System: Windows 98 /2003/NT/XP/7, MS DOS

Applications: MS Visual Studio 2010, MS office 2003/2007/2010 , HTML/DHTML, XML, Visual Studio IDE,HP ALM

Protocols: HTTP, TCP/IP, FTP

PROFESSIONAL EXPERIENCE

Confidential, TX

Power BI Developer

Responsibilities:

• Designed SSIS packages to transfer the data from DB2, flat files and excel documents to the Staging Area in SQL Server 2012 and 2014.
• Used SQL Server Destination in Data flow to improve a great performance changes in Replications. (Admin rights for this operation).
• Created Various ETL process to load data from AWS to Datawarehouse using DDL method.
• Define customized connections for various Cloud and Datawarehouse Using C#.
• Expertise in deploying OLAP tools, Materialized Views, indexing and partitioning techniques for highly responsive Decision Support Systems.
• Involved in creating complex measures including ranking, KPIs, aggregation by DAX in SSAS cubes according to business requirements.
• Create different roles for uses accessing the tabular model. Write complex DAX function to implement row level security and apply the rules for business users assigned to various roles.
• DevelopedPowerBImodel used for financial reporting of P & L and Headcount.
• Involved in building dynamic partitions by using complex DAX function. Optimize the processing of the cube inside the Tabular Model. Write complex process scripts for the cube and use SQL Server Job Agent to automatically refresh data.
• Designed and documented the entire Architecture of Power BI Poc
• Expertise in Power BI, Power BI Pro, Power BI Mobile.
• Have Basic idea of Power Query M formula language
• Expertise in writing complex DAX functions inPower BI and Power Pivot
• Designed and developed Power BI graphical and visualization solutions wif business requirement documents and plans for creating interactive dashboards.
• Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as legal case matter, billing hours and case proceedings along wif slicers and dicers enabling end-user to make filters.

Confidential, Seattle

BI Developer

Responsibilities:

• Designed SSIS packages to transfer the data from DB2, flat files and excel documents to the Staging Area in SQL Server 2012 and 2014.
• Used SQL Server Destination in Data flow to improve a great performance changes in Replications. (Admin rights for this operation).
• Created Various ETL process to load data from AWS to Datawarehouse using DDL method.
• Define customized connections for various Cloud and Datawarehouse Using C#.
• Expertise in deploying OLAP tools, Materialized Views, indexing and partitioning techniques for highly responsive Decision Support Systems.
• Involved in creating complex measures including ranking, KPIs, aggregation by DAX in SSAS cubes according to business requirements.
• Create different roles for uses accessing the tabular model. Write complex DAX function to implement row level security and apply the rules for business users assigned to various roles.
• DevelopedPowerBImodel used for financial reporting of P & L and Headcount.
• Involved in building dynamic partitions by using complex DAX function. Optimize the processing of the cube inside the Tabular Model. Write complex process scripts for the cube and use SQL Server Job Agent to automatically refresh data.
• Designed and documented the entire Architecture of Power BI Poc
• Expertise in Power BI, Power BI Pro, Power BI Mobile.
• Have Basic idea of Power Query M formula language
• Expertise in writing complex DAX functions inPower BI and Power Pivot
• Designed and developed Power BI graphical and visualization solutions wif business requirement documents and plans for creating interactive dashboards.
• Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as legal case matter, billing hours and case proceedings along wif slicers and dicers enabling end-user to make filters.
• Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning.
• Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.
• Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MSOLAP/ Analysis server (SSAS)
• Utilized Power BI gateway to keep dashboards and reports up to-date wif on premise data sources.
• Expert in Designing Dimensional Modeling (Star Schemas, Snow flake schema) and Operational Data store (ODS) in Data Warehouse design.
• Good working experience in Business Objects, Supervisor, Designer, Broadcast Agent (BCA), ZABO, Web Intelligence and Business Objects SDK.
• Proficiency in data warehousing techniques for data cleansing,Slowly Changing Dimensionphenomenon.
• Worked wif Zappsys to connect to various source like AWS, Google Sheets and MongoDB.
• Define Mongo DB connection and Load data into Mongo DB and also extract data from Mongo DB.
• Documenting the types and structure of the business data (logical modeling),
• Analyzing and mining business data to identify patterns and correlations among the various data points,
• Mapping and tracing data from system to system in order to solve a given business or system problem,
• Design and create data reports and reporting tools to halp business executives in their decision making,
• Perform statistical analysis of business data.
• Scheduled Packages using SQL Server Agent Jobs, Monitoring nightly jobs.
• Used SSIS Variables for storing the values, which are used in various components of Data Flow Task.
• Have extensive knowledge on Ralph Kimball’s and Bill Inmon’s modelling concepts and
• Check for the failed jobs, investigate the route cause and resolve the issue. Native SQL
• Documenting major changes to the SQL Servers.
• Created SSIS packages to load data from Teradata to Sql server.
• From time to time recover the databases to a specific point of time, as per the requests
• Mentored the team of 3 on the daily basis for the development activities.
• Involved in high level architectural design discussions for designing the MDF(meta data framework) tables which store the business and supplier data.
• Part of the migration team to validated the packages and update as per new version of the SQL server
• Having Experience in Migration of Sql server .
• Used T-SQL queries to insert the complete file information and layout to MDF tables.
• Used various expressions in designing file watcher which watches for the files dropped into SFTP site.
• Created Multiple reports on Salesforce wave analytics and have working knowledge on it.
• Hands-on Experience wif different types of Normal forms (1NF,2NF and 3NF)
• Created Multiple SSIS packages for Big Data (Hadoop to Teradata to sql)
• Data loading using SSIS into different DW like Netezza.
• Designed SSIS Package to check the row count of the source and target tables of oracle source.
• Worked on SSIS Packages to load data from different source to target sql database using SQL 2008, Sql 2012 and 2014
• Have written MDX queries on Cubes
• Experience in writing expressions in SSRS and Expert in fine-tuning the reports. Created many Drill through and Drill Down reports using SSRS.
• Expert in designing Enterprise reports using SQL Server Reporting Services (SSRS 2005/2008/2012/2014 )
• Expert in creating Parameterized Reports.
• Hands-on Experience wif different types of Normal forms(1NF,2NF and 3NF)
• Developing, deploying and debugging distributed systems in a UNIX environment.
• Worked on SYBASE Data base and loaded data into it.
• Created package configuration in XML and used them to deploy packages into SQL server.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Identified the potential Issues that occur during the package execution by redirecting the rows from source component to Error Output.
• Monitoring SSIS packages, Stored Procedures running in Agent job and support the Production Team.
• Crated report in Tableau and Business object
• Involved in designing, deploying and processing OLAP Cubes using SSAS for the analysis of data wif pre-calculated aggregations and in summarized fashion which can be modeled into a report accordingly.
• Expertise in creating Cubes wif dimensions and Facts Tables in MOLAP Warehouse using SQL Server Analysis Services (SSAS).
• Generated Sales Ranking reports using SQL Server Reporting Services for different subjects
• Developed complex reports using multiple data providers, user defined objects, aggregate aware objects, charts, and synchronized queries
• Created Cross-Tab, Drill-down and Sub-Report using RDL. Promoted RDLs to Reporting Service Server.

Environment: T-SQL, MS SQL Server 2008R2/2008 and 2012 and 2014, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Business Intelligence Development Studio (BIDS), MS Excel, Windows XP, Informatica.Tableau

Confidential, New York

BI Developer

Responsibilities:

• Designed SSIS packages to transfer the data from flat files, Access database and excel documents to the Staging Area in SQL Server 2012 and 2014.
• Written stored procedures and used them in packages.
• Create Users and assign permissions based on the level of database access the user would need.
• Documenting the types and structure of the business data (logical modeling),
• Analyzing and mining business data to identify patterns and correlations among the various data points,
• Mapping and tracing data from system to system in order to solve a given business or system problem,
• Design and create data reports and reporting tools to halp business executives in their decision making.
• Involved in creating complex measures including ranking, KPIs, aggregation by DAX in SSAS cubes according to business requirements.
• Create different roles for uses accessing the tabular model. Write complex DAX function to implement row level security and apply the rules for business users assigned to various roles.
• DevelopedPowerBImodel used for financial reporting of P & L and Headcount.
• Involved in building dynamic partitions by using complex DAX function. Optimize the processing of the cube inside the Tabular Model. Write complex process scripts for the cube and use SQL Server Job Agent to automatically refresh data.
• Created various reports wif functionalities like Cross tab, Embedded Summary, Calculate member of, Charts, Graphs, and sub reports.
• Worked wif several features like Query Stripping, Input Controls, Sub Query, Scope of Analysis and Drill functionality.
• Developed Complex Universes by linking different data sources.
• Create Aliases and Contextsfor resolving Loops and check the Integrityof theUniverse.
• Fine-tuned universes and reports by creating aggregate tables and filters.
• Configured BW Publisher service for Crystal reports migration.
• Utilized Power BI (Power Pivot/View) to design multiple scorecards and dashboards to display information required by different departments and upper level management.
• Created reports utilizing SSRS, Excel services, Power BI and deployed them on SharePoint Server as per business requirements.
• Designed complex data intensive reports in Power BI utilizing various graph features such as gauge, funnel, line better business analysis
• Generated various Drill down reports and Alerts. Business Intelligence reports using Web Intelligence module.
• Worked extensively on distribution, maintenance, and optimization of universes for Business Objects and Web Intelligence deployments
• Have extensive knowledge on Ralph Kimball’s and Bill Inmon’s modelling concepts and
• Check for the failed jobs, investigate the route cause and resolve the issue. Native SQL
• Documenting major changes to the SQL Servers.
• Created SSIS packages to load data from Teradata to Sql server.
• From time to time recover the databases to a specific point of time, as per the requests
• Mentored the team of 3 on the daily basis for the development activities.
• Involved in high level architectural design discussions for designing the MDF(meta data framework) tables which store the business and supplier data.
• Part of the migration team to validated the packages and update as per new version of the SQL server
• Having Experience in Migration of Sql server .
• Used T-SQL queries to insert the complete file information and layout to MDF tables.
• Used various expressions in designing file watcher which watches for the files dropped into SFTP site.
• Created Multiple reports on Salesforce wave analytics and have working knowledge on it.
• Hands-on Experience wif different types of Normal forms (1NF,2NF and 3NF)
• Created Multiple SSIS packages for Big Data (Hadoop to Teradata to sql)
• Data loading using SSIS into different DW like Netezza.
• Designed SSIS Package to check the row count of the source and target tables of oracle source.
• Worked on SSIS Packages to load data from different source to target sql database using SQL 2008, Sql 2012 and 2014
• Experience in writing expressions in SSRS and Expert in fine-tuning the reports. Created many Drill through and Drill Down reports using SSRS.
• Expert in designing Enterprise reports using SQL Server Reporting Services (SSRS 2005/2008/2012/2014 )
• Expert in creating Parameterized Reports.
• Have working knowledge on NIFI.
• Experience in deploying Reports to Report Server. Creating user interface on Report Server for the users to access reports on Report Manager.
• Have good Knowledge on writing MDX queries and the MDX datatypes.
• Worked on for each loop containers, sequence containers.
• Have Worked on Microsoft PMP and Microsoft Viso.
• Generate reports using tableau.
• Used various tasks like Execute SQL task which calls stored procedures and takes parameters, Script component task for reading the file and removing trailer records.
• Created source, stage and archive folders as per the requirements using expressions in file system task.
• Involved in designing, deploying and processing OLAP Cubes using SSAS for the analysis of data wif pre-calculated aggregations and in summarized fashion which can be modeled into a report accordingly.
• Expertise in creating Cubes wif dimensions and Facts Tables in MOLAP Warehouse using SQL Server Analysis Services (SSAS).
• Developed, created and managed complex stored procedures and UDF in SQL Server 2008
• Developing, deploying and debugging distributed systems in a UNIX environment
• Used execute process task for unzipping the zipped files.
• Created package configuration using parent package as variable and used them to deploy packages into SQL server and various environments.
• Developed master package which calls the child packages and loads the files to stage and history tables in GDW.
• Errors in the file will be logged into the DIF (data integration framework) tables and an email will be sent to business people to get back to suppliers wif file information.
• Avoiding the multiple load of the same file using flag column in MDF table. Accommodating MDF to handle new set of files.
• Scheduled Packages using SQL Server Agent Jobs to run every 5 min.
• Developed ETL Dashboard Monitoring reports, Execution summary reports.
• Developed parameterized, drill down, drill through and cascaded reports.
• Used TFS to check in and check out the changes made to code.

Environment: T-SQL, MS SQL Server 2012/2014, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS),Team foundation Server(TFS), SharePoint, MS Excel,Hadoop,Teradata, Windows 2008 R2, Microsoft windows server 2012.

Confidential - New York

MSBI Developer

Responsibilities:

• Designed SSIS packages to transfer the data from DB2, flat files and excel documents to the Staging Area in SQL Server 2012 and 2014.
• Used SQL Server Destination in Data flow to improve a great performance changes in Replications. (Admin rights for this operation).
• Have written MDX queries on Cubes .
• Created Reports using POWER BI
• Have Worked on Microsoft PMP and Microsoft Viso.
• Have good Knowledge on writing MDX queries and the MDX datatypes.
• Mentored the team of 3 on the daily basis for the development activities.
• Used various Data Flow Transformations, like Derived Column, Data Conversion, Union All, Multicast and Copy Column while developing the packages.
• Used Event Handlers for Error Handling and Alert Operations.
• Developed SSIS Packages using Look Up Values & implementing rules provided by Business in the mapping document.
• Design Cubes and hierarchies in SSAS .
• Having Experience in Migration from Sql server .
• Involved in designing, deploying and processing OLAP Cubes using SSAS for the analysis of data wif pre-calculated aggregations and in summarized fashion which can be modeled into a report accordingly.
• Expertise in creating Cubes wif dimensions and Facts Tables in MOLAP Warehouse using SQL Server Analysis Services (SSAS).
• Expertise in deploying OLAP tools, Materialized Views, indexing and partitioning techniques for highly responsive Decision Support Systems.
• Expert in Designing Dimensional Modeling (Star Schemas, Snow flake schema) and Operational Data store (ODS) in Data Warehouse design.
• Hands on Programming skills inSQL, PL/SQL, Stored procedures, packages, functions,triggers.Managed all upgrades, maintenance, and support of the Business Objects System and Expertise inMigrating the Business objectsfrom 5.1.x/6.1a/6.1b/6.1.5/XI r2 to XI 3.1.
• Good working experience in Business Objects, Supervisor, Designer, Broadcast Agent (BCA), ZABO, Web Intelligence and Business Objects SDK.
• Proficiency in data warehousing techniques for data cleansing,Slowly Changing Dimensionphenomenon.
• Created reports including dynamic calculations involving Contexts, Queries, Hierarchies,list of values (LOVS),local variables, Alerters, Ranking and multiple data providers.
• Diversified experience in implementation of Crystal Enterprise wif multiple domains.
• Havinghands on experience in BI 4.1 on both SAP and Non SAP Systems.
• Documenting the types and structure of the business data (logical modeling),
• Analyzing and mining business data to identify patterns and correlations among the various data points,
• Mapping and tracing data from system to system in order to solve a given business or system problem,
• Design and create data reports and reporting tools to halp business executives in their decision making,
• Perform statistical analysis of business data.
• Scheduled Packages using SQL Server Agent Jobs, Monitoring nightly jobs.
• Used SSIS Variables for storing the values, which are used in various components of Data Flow Task.
• Hands-on Experience wif different types of Normal forms(1NF,2NF and 3NF)
• Developing, deploying and debugging distributed systems in a UNIX environment.
• Worked on SYBASE Data base and loaded data into it.
• Created package configuration in XML and used them to deploy packages into SQL server.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Identified the potential Issues that occur during the package execution by redirecting the rows from source component to Error Output.
• Monitoring SSIS packages, Stored Procedures running in Agent job and support the Production Team.
• Crated report in Tableau and Business object
• Involved in designing, deploying and processing OLAP Cubes using SSAS for the analysis of data wif pre-calculated aggregations and in summarized fashion which can be modeled into a report accordingly.
• Expertise in creating Cubes wif dimensions and Facts Tables in MOLAP Warehouse using SQL Server Analysis Services (SSAS).
• Generated Sales Ranking reports using SQL Server Reporting Services for different subjects
• Developed complex reports using multiple data providers, user defined objects, aggregate aware objects, charts, and synchronized queries
• Created Cross-Tab, Drill-down and Sub-Report using RDL. Promoted RDLs to Reporting Service Server.

Environment: T-SQL, MS SQL Server 2008R2/2008 and 2012 and 2014, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Business Intelligence Development Studio (BIDS), MS Excel, Windows XP, Informatica.Tableau

Confidential

MSBI Developer

Responsibilities:

• Analyzed business requirements built logical and physical data models that describe all the data and relationships between the data.
• Written complex stored procedure according to the business requirements for reporting purpose.
• 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.
• Generated variousList Reports,Grouped Reports,Cross tab Reports,Chart Reports, Power Pivot, Drill-Down andDrill-Through Reports. Designed & developed the various SSIS packages for the Weekly & Monthly Loads from business users in different locations in United States.
• Have written MDX queries on Cubes
• Have good Knowledge on writing MDX queries and the MDX datatypes.
• Have Working knowledge on HL7 data.
• Involved in designing, deploying and processing OLAP Cubes using SSAS for the analysis of data wif pre-calculated aggregations and in summarized fashion which can be modeled into a report accordingly.
• Have Knowledge on EPIC.
• Expertise in creating Cubes wif dimensions and Facts Tables in MOLAP Warehouse using SQL Server Analysis Services (SSAS).
• Managed the ETL processes between various environments through SSIS Configuration.
• Created Dashboards to present criticalcompany data in a single report.
• Worked wif various SSIS tasks including execute SQL task, for each loop container, file system tasks.
• Created Reports using POWER BI.
• Worked on SYBASE Data base and extracted data from it.
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Implemented the Error handling in the Stored Procedures and SQL Objects and also modified already existing stored procedures, triggers, views, and indexes depending on the requirement.
• Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS.
• Involved in designingParameterized Reports and Report Modelsfor generatingAd-Hocreports as per the client requirements.
• Defined Key Performance Indicator metrics to create scorecards.

Environment: SQL Server 2008 R2 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), ORACLE 10g, MS Visual Source Safe and Windows Server 2008,.NET Framework, MS Office share point Server.

Confidential

Database Developer

Responsibilities:

• Created/reallocated database objects on appropriate File groups to ease maintenance and improve data access performance.
• Coded Stored Procedures, functions and triggers at high level.
• Fine Tuned the SQL queries using hints for maximum efficiency and performance.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Participated in User Acceptance Testing for different modules.
• Implementing user training and providing technical support.
• Prepared proper backup and recovery plans.
• DBA activities like creating users, roles and granting and revoking privileges.
• Merging data into a single server for achieving better control, consistency & security of data.
• Designed the Logical and Physical design of database for projects on basis of user requirements.

Environment: MS SQL Server 2005, T-SQL, SQL Windows Server 2003, and MS Access and Excel.