PROFESSIONAL SUMMARY:

• Around 8 years of IT experience in Microsoft Business Intelligence technologies like SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS).
• Extensive knowledge and Experience in dealing with Relational Database Management Systems including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export.
• Worked on all activities related to the development, implementation, administration and support of ETL processes for large - scale Data Warehouses using SSIS 2008.
• Experience in dealing with high volume transactional data in SQL
• Strong experience in SQL Development, ETL development using Microsoft SQL Server Integration Services (SSIS), Business Intelligence delivery using Microsoft SQL Server Analysis Services (SSAS) and Reporting solutions using Microsoft SQL Server Reporting Services (SSRS).
• Very good experience in Creating, deploying SSIS Packages and migrating DTS Packages from 2000 to 2005/2008.
• Experience in migration of SSRS reports from SQL 2000 to SQL 2005 and SQL 2008 and SQL 2008 R2.
• Extensive experience in writing Distributed Queries between SQL Servers by creating link servers and federated servers.
• Experience in troubleshooting SQL issues by using SQL Tools, execution plans, Trace, statistics, index tuning wizard.
• Extensive Tableau Experience in Enterprise Environment and Tableau Administration.
• Preparing Dashboards using calculations, parameters in Tableau.
• Involved in creating dashboards and reports in Tableau. Created report schedules on Tableau server.
• Extensive experiencein delivering OLAP solutions by developing Corporate Dashboard Reports using SQL Server Reporting Services (SSRS), Report Model and Ad Hoc Reporting using Report Builder functionality.
• Experience in Performance Tuning and Query Optimization.
• Extensive experience in using SQL Server Profiler to monitor the SQL server for deadlocks, long running queries and tune the same to improve performance.
• Developed ETL process using SSIS with Various Control Flow, Data Flow tasks and Store Procedures for Work Order Validation process.
• Experience in creating and managing fragmentation of Indexes to achieve better query performance.
• Expert in using tools like Bulk Copy (BCP), Data Transformation Services (DTS) and SSIS.
• Created shareddimensiontables, measures, hierarchies, levels, cubes and aggregations on MSOLAP/ Analysis Server (SSAS).
• Experience in creating reports through PROCLARITY. Used PROCLARITY for accessing and analyzingcubes and dimensions
• Experience in developing Custom Report and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQLServerReporting Services (SSRS) in Business intelligence development studio (BIDS).
• Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills and possess strong analytical skills.
• Self-motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills. Team-oriented, technically motivated and creative. User oriented with a desire to learn client's business requirements.

TECHNICAL SKILLS:

Languages: Transact SQL,PL/SQL,C, Visual Basic 6.0, HTML,.NET.

Databases: SQL Server 2012/2008R 2/2008/2005/2000 , Oracle 9i,10g,11g, MS Access

Analysis/Reporting Tools: SQL Server Reporting Service (SSRS), SQL Server Analysis Service (SSAS),Crystal Reports, Tableau, Power BI

ETL Tools: DTS, SQL Server Integration Services (SSIS)

Data Modeling Tools: Erwin, MS Visio

MS Office: 2007/2003/2000

Operating Systems: Windows / 98/2000/2003/2007/ XP/Vista

Database Tools: SQL Query Analyzer, SQL Enterprise Manager, Management Studio, SQL Server 2005 Query Editor, Solution Explorer, Analysis Manager, Reporting Server

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Sr. Business Intelligence Power BI Developer

Responsibilities:

• Designed a complex SSIS package for importing data from SQL Server 2008
• Used ETL to implement the slowly changing Transformation, to maintain Historical Data in Data warehouse.
• Created packages in SSIS with error handling
• Worked with different methods of logging in SSIS.
• Implemented data views and control tools for guaranteed data transformation using SSIS.
• Used various transformations like Multicast, Conditional split, OLEDB Command, Script Component and Lookup while loading the data into Destination.
• Expertise in creating measures in Power BI using DAX.
• Successfully deployed SSIS packages with defined security.
• Automated Power Query refresh using power shell script and windows task scheduler.
• Proficiently created Reports based on the requirements using Power BI
• Involved to write complex T-SQL queries and Stored Procedures for generating reports
• Defined parameters for parameterized Reports using SSRSand Tableau.
• Designed and developed various Service Management Reports, utilizing Dynamic and Cascading Prompts, sub-reports, charts, parameterized reports, conditional and dynamic reports using SSRS 2008
• Successfully worked with Report Server and configured to SQL Server 2008.
• Integrated custom visuals based on business requirements using Power BI Desktop.
• Created Batch files to run the script in development and production environment
• Developed a multi-dimensional database and OLAP cube using SSAS that stored and maintained the data
• Extensively worked with OLAP cubes to generate drill through reports in SSRS.
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Analyzed, designed and created a star schema dimensional data model using Erwin for an enterprise data warehouse.
• Extensively used Data Stage Sequences to place the jobs in sequence to achieve final goal.
• Develop and implement tests on all Data Stage jobs.
• Schedule the packages to keep extracting the data from OLTP at specific time intervals.
• Responsible for rebuilding the indexes and tables as part of performance tuning.
• Monitored performance and optimize SQL queries for maximum efficiency.
• Used SQL Server Agent for scheduling jobs and alerts.
• Designed MDX queries in accessing cubes and hands-on experience in query structuring, performance optimization
• Responsible to monitor performance and optimize SQL queries for maximizing efficiency
• Proficiently scheduled the Subscription Reports with the Subscription Report wizard
• Involved in the analysis, design, development, testing, deployment and user training of analytical and transactional reporting system
• Used stored procedures, created new stored procedures and triggers, modified existing ones, and tuned them such that they perform well
• Tuned SQL queries using execution plans for better performance
• Optimized by assigning relative weights to the tables in the Catalog and Query Performance

Environment: MS SQL Server 2012/2008, SSAS 2008, SSIS 2008, SSRS 2008, T-SQL, ORACLE, Power BI, Tableau

Confidential, Helena, MT

SQL BI Developer (SSIS/SSRS/SSAS),Tableau

Responsibilities:

• Designed and optimized various T-SQL database objects like tables, views, stored procedures, functions, indexes and triggers using SSMS.
• Key role in team of 4 in brining 2005 SQL database environment to SQL 2008R2 by migrating, converting and re-writing DTS packages and updating them to SSIS packages.
• Played a major role in Data Sync between IDMS and SQL Server databases, Written T-SQL to handle day to day change records to keep in SYNC and keep track of records what we have sent and changed in SSMS.
• Involved in creating stored procedures, triggers, T-SQL and mainly dealt with SSMS.
• Data Architecture, Analysis and Technical Design solutions for OLTP and Data mart/Data warehouse
• Used SQL Server Package Configuration technique to make Dynamic configurations.
• Used Text Files/ SQL Server Logging for all SSIS packages.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Design and Implement WCF services layer hosted on Windows Azure. This layer is the middle tier between SQL Azure and SharePoint online external content.
• Create Cache Memory on Windows Azure to improve the performance of data transfer between SQL Azure and WCF services.
• Build SharePoint web-parts and Silverlight components for different dashboards.
• Create a Virtual Network on Windows Azure to connect all the servers.
• Build a presentation to present the design of hosting architecture on Windows Azure.
• Maintained high degree of competency across the Microsoft Application Platform, focusing on .NET Framework, WCF, Windows Azure, AppFabric, and SQL Azure
• Managed all aspects of the SDLC process - requirement analysis, time estimates, functional specification, design, development, testing, packaging, and support/maintenance.
• Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel and created SSIS packages to load excel sheets from PC to database.
• Expertise to follow Agile process in application development.
• Created On demand (Pull) and Event Based delivery (Push) of reports according to the requirement.
• Deployed and configured the reports in the Report Server.
• Designed and developed Big Data analytics platform for processing customer viewing preferences for mobile devices.
• Developed frameworks to address data analytics, and strategy development needs.
• Worked on the Snow-flaking the Dimensions to remove redundancy.
• Used SSIS to create ETL packages to validate, extract, transform and load data into data warehouse and data marts.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Deploy, configure, maintain data compute on Azure Cloud.
• Troubleshoot Azure related issues and engage internal teams and vendor for issue resolutions.
• Worked with Data Modeler and DBAs to build the data model and table structures.
• Worked with various SSIS packages which involve Transactions and rollback techniques.
• Configured SQL mail agent for sending automatic emails when SSIS packages fails or succeeds.
• Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers in SSMS.
• Used Power BI Power Pivot to develop data analysis prototype and used Power View and Power Map to visualize reports.
• Involved in Tabular Data warehouse and DAX operations for SSAS 2012 and 2008 OLAP databases.
• Created Power pivots, Power views and SSRS reports using tabular model (DAX), Cubes (MDX) and SQL queries.
• Implemented user based subject selection (Role based security) in Power Views, Power Pivots and SSRS using DAX, MDX and SQL queries.
• Worked as Data Architect and designed dimensional structures needed for Pharmacy reporting.
• Major responsibilities include getting requirements from the user, writing stored procedures for reports and developing reports using Tableau.
• Gathered business requirements and led cross-functional teams to implement advanced data analytics.
• Designed and Implemented application using .NET objects like Dataset, Data table and Data adapter for manipulating, retrieving, storing and displaying data from SQL Server.
• Compiled source to target mapping documents to design the ETL jobs
• Created User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.
• Optimizing Stored Procedures and long running SQL queries using indexing strategies and query optimization techniques.
• Developed a multi-dimensional database and OLAP cube using SSAS that stored and maintained the data.
• Designed Conceptual, Logical and Physical model for Operational Data Source (ODS) and Dimensional modeling (Star and Snowflake) for Data Warehouse and Data mart.
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Analyzed, designed and created a star schema dimensional data model using Erwin for an enterprise data warehouse.
• Schedule the packages to keep extracting the data from OLTP at specific time intervals.
• Migrated 10 years of Oracle data to SQL Server 2014 which includes stored procedures and functions using SQL Server Migration Assistance.
• Developed Metadata Design Patterns in BIML.
• Provided continues maintenance and development of bug fixes for the existing and new Power BI Reports.
• Deployed the packages to production using XML package configuration.

Environment: SQL Server 2014/2012/2008 R2/2008/2005, SSRS 2008/2013, SSIS 2008/2013, SSAS 2008/2013, BIDS, Oracle 9i/10g, Visual Studio 2008/2013, XML, Azure, MS Office, Crystal Reports, .NET, Tableau, Power BI.

Confidential, Denver, CO

SQL BI Developer (SSIS/SSRS/SSAS), Tableau

Responsibilities:

• Created complex SQL stored procedures using Microsoft SQL Server Management Studio 2008 and 2008 R2.
• Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development.
• Experience in developing reports using SSRS 2008 and SSRS 2008 R2
• Created cubes and dimensions and measures and calculated measures according to the business requirements.
• Implemented complex calculations in tabular model using DAX.
• Creating/ managing the project plan, task allocation, work with stakeholders and PMO office for achieving project goals in an agile work environment.
• Created SSIS packages to Oracle and other SQL Server instances in SSIS 2008.
• Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel and created SSIS packages to load excel sheets from PC to database.
• Performed the task of data transfer from files in remote server to folders in another server using FTP.
• Deployed SSIS packages and Reports to Production Servers.
• Created several SSIS packages for performing ETL operations to transform data from a cube using MDX.
• Generated reports from the cubes by connecting to Analysis server from SSRS.
• Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2000 to MS SQL 2005 as well as Created interface stored procedures used in SSIS to load/transform data to the database.
• Created SSIS Packages from BIML.
• Involved in developing applications in C# to meet the business requirements using Visual Studio .NET 2010.
• Designed system for the Azure platform to ensure massive compute resources are available to allow NKR to scale internationally.
• Developed an Azure based high performance compute environment to support the massive computational requirements of client congressional redistricting Azure application
• Developed a conical map/reduce-like architectural pattern that that is designed to leverage the Azure platform.
• Designed, built and maintained data marts and numerous complex reports and scorecards, before development of the Data Warehouse.
• Did the forward and backward data mapping between the fields in mainframe and FACETS.
• Worked on T-SQL programming, stored procedures, user-defined functions, cursors, views setup and management of linked servers to Non-SQL-Server databases.
• Created SSIS Packages from various data sources.
• Use BIML to Automate SSIS packages.
• Experienced with (SDLC): interviewing client, creating the technical specification, building the schema, coding, writing test scenarios, UMLs, and documentation while adhering to Agile Development methodologies.
• Experience in creating snapshots of static reports and configure subscription.
• Identified dimensions, facts, and grains within the data. Created an enterprise dimensional data warehouse data model by following the methodology of Data Warehouse.
• Built cubes for production application, partitioned Cubes to decrease the processing time and increase the performance of the queries running on front end application using SSAS 2008.
• Responsible for logical and physical data modeling, database design, star schema, data analysis, programming, documentation and implementation.
• Identify sources for master data, identify data owners, analyze metadata, determine which applications produce master data, evaluate the data, data clean up by creating SSRS visualization
• Transform the data from the staging database and perform the transformation using the Data Flow Tasks.
• Drove online analytics programs, including ownership of KPI and dashboard reporting, analysis of online programs, and the development, execution, and analysis of variable testing .
• Worked on all types of transformations that are available in Power bi query editor
• Created stored procedures and SQL queries to pull data into power pivot model.
• Worked closely with the QA team to review and develop XML data standards and data sharing models
• Lead the team of developers to write efficient code.
• Involved in system and unit level testing.

Environment: SQL Server 2014/2008/2008 R2, Business Intelligence Studio (SSAS, SSIS, SSRS), T-SQL, Erwin, MDX, Oracle 10g, MS Excel, .Net,Power BI, Azure.

Confidential

SQL Server BI Developer (SSIS/SSRS), Tableau

Responsibilities:

• Generated database monitoring and data validation reports in SQL Server Reporting Service (SSRS).
• Created partition table for very large database for good performance.
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Utilized SSIS to produce a Data Mapping and Data Mart for reporting worked with Multi-Threading Concepts with Synchronous and Asynchronous transactions.
• Designed and developed jobs using Data Stage/Quality Stage 8.x for loading the data into Dimensions and Fact Tables.
• Schedule and plan all Data Stage tasks.
• Created logging, custom logging and error handling packages.
• Deployed SSIS packages and Reports to Production Servers.
• Recovering the databases from Backup in Disasters, and also having Good knowledge on rebuilding s.
• Involved in developing Life Cycle using Agile Methodology.
• Creating testing process and documentation in agile environment.
• Involved in Data modeling and design of database and schema
• Data Warehouse and Data Mart business requirements collecting and auditing. Interview with internal users and document business requirements.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Expertise in writing complex DAX functions .
• Used various sources to pull data into SSRS such as SQL Server, SAP BW, Oracle, SQL Azure etc.. .
• Created and developed the stored procedures, triggers, views, and user-defined functions to support application development.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Deployed and configured the reports in the Report Server.
• Created User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.
• Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications.
• Expertise in writing business solutions using Object Oriented Concepts with .NET frameworks.
• Designed and developed MS SQL Server Reporting Services (SSRS) under SQL Server 2008.
• Worked closely with IT project managers, programmers, and testers.
• Monitored Indexes (XML Type: XML Index) and analyzed their status for performance tuning and query optimization.

Environment: SQL Server 2008 Enterprise Edition, SSIS /SSRS 2008, T-SQL, XML, MS Excel, SQL, BCP, Visual Basic 6.0/5.0, Crystal Reports 7/4.5.