PROFFESIONAL SUMMARY:

• Over 8 years of experience in Microsoft BI Tools (SSIS/SSRS/SSAS) and T - SQL using SQL Server 2005/2008R2/2012.
• Proficient in advance features of Oracle 11g for PL/SQL programming like Using Records and Collections, Bulk Bind, Ref. Cursors, Nested tables and Dynamic SQL.
• Experience in Developing, Designing and Support inter active Tableau dashboards.
• Experienced in Developing Power BI Reports and Dashboards from multiple data sources using Data Blending.
• Experience in T-SQL (DDL, DML and DCL), Creating, developing new database objects by like Tables, Views, Indexes, Complex stored procedures, function(UDF), cursors, and triggers, locking issues, BCP, common table expressions (CTEs), Backups, Recovery and SQL Server Agent profiler using SQLSERVER 2000/2005/2008 R2/2012.
• Proficient Knowledge in dealing with RDBMS including E/R Diagrams, Normalization, Constraints, Joins, Keys and Data Import/Export.
• Experience in developing and debugging Stored Procedures and Triggers. implemented row-level security by using user filters at the group level.
• Worked on administration tasks such as data loading, batch jobs, configuring IIS, data uploading, backup & recovery, Database mirroring, Log shipping, user and application table management, upgrades, creating database partitioning, databases/file groups/files/transaction logs.
• Used tools like MS SQL Profiler, Index Tuning Wizard, Pervasive and Windows performance for monitoring and tuning SQL Server performance.
• Developing SSIS packages for data migration between different sources such as flat file, excel, oracle, Sybase, DB2, MS accessing SQL Server SSIS 2005/2008 R2/2012.
• Excellent hands on Experience in ETL (Extraction Transformation and Loading) by extracting large volumes of data from various data sources using SSIS.
• Transferred data from various data sources/business systems including MS Excel, MS Access, Flat Files, COSMOS etc. to SQL Server using SSIS /DTS using various features like data conversion etc.
• Hands on experience with migrating of DTS packages to SSIS from lower version (2005) to higher version (2005/2008/2012 ) and also trouble shooting migrating issues.
• Experience in by using Row Transformations, Block and Unblock Transformations for Performance Tuning in SSIS packages.
• Experience in working with different type Dirty Data from Different sources.
• Hands on experience working with Logging, Error handling using Event Handlers pre and post for SSIS Packages.
• Creating SSIS Packages for integrating data using OLE DB connection from sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union.
• Experience in working with Data Cleansing technique in ETL procedures.
• Experience in working with Self Service MS BI end user tools such as Excel 2010 (Power pivot), Performance Point Server (PPS), Power view.
• Skilled at building and deploying multi-valued parameterized reports using Power BI, Tableau.
• Worked with Microsoft Power BI, Data zen, DAX expressions, Power View and Power Query integrated with share point.
• Experience in developing OLAP Cubes by using SQL Server Analysis Services (SSAS), and defined data sources, data source views, Dimensions, Measures, Hierarchies, Attributes, Calculations using multi-dimensional expression (MDX), Perspectives and Roles.
• Excellent hands on experience in creating groups and measures, KPIs.
• Experienced in building Tabular Model Cube from Scratch in Databases with different Measures and Dimensions.
• Experience in performance tuning, processing and deploying the cubes.
• Experience in cube partitioning for better database performance.

TECHNICAL SKILLS:

Databases: MS SQL Server 2008/2012/2014 , ORACLE, MS Access, TEREDATA V2R6/V2R5, DB2.

SQL Server Tools: SSMS, Configuration Manager, Enterprise Manager, Query Analyzer Profiler, DTS, SSIS, SSAS, SSRS, Database Tuning Advisor, Cognos 10 BI tools (Report Studio, Analysis Studio, Query Studio, Cognos Connection), SQL* Plus.

Reporting Tools: Power BI, SSRS, Tabluea

RDBMS: SQL Server 2005/2008 R2/2012/2014 Oracle 11g/10/9i.

Programming: T-SQL, PL/SQL, Dynamic SQL, MDX, C# .NET, XML, JSON, Java.

Operating Systems: Windows 7/Vista/XP/2008/2003, Windows 9x, UNIX.

Application Packages: MS Office, Microsoft SharePoint Server (MOSS) 2007/2010.

WORKING EXPERIENCE:

Confidential, Dallas, TX

Power BI Developer

Responsibilities:

• Designed and implemented Dashboards and Scorecards with business KPIs using Performance Point Server and published them via Power BI.
• Building Ad-Hoc reports in Power BI depending on Business requirements is one of the major responsibility.
• Used to connect different data sources like SQL DB (SQL Query), Tabular Model (MDX Query), Web Trends to Power BI and generate reports with different visualizations.
• Created Calculated Columns and Measures in Power BI and Excel depending on the requirement using DAX queries.
• Responsible for creating and changing the visualizations in Power BI reports and Dashboards on client requests.
• Created bottom count, top count, cross join, non-ascendants, log MDX queries for creating Calculations and KPI’s on a cube.
• Responsible for Scheduling jobs for weekly, daily data refresh on different Power BI reports.
• Designed a Data Model with multiple Fact Tables and Dimensions depending on the business requirements.
• Built a Tabular Model cube from scratch data and by MDX queries fetched data to SSRS and Power BI reports.
• Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder. implemented row-level security by using user filters at the group level.
• Using SQL Server Integration Services (SSIS) as an ETL Tool, the data has Extracted, Transformed and Loaded (ETL) from Excel and Flat file to MS SQL Server.
• Designed SSIS packages to transfer the data from flat files, Access database and excel documents to the Staging Area in SQL Server 2012.
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups etc.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Created reports by using Joins in multiple tables from multiples database using complex SQL queries
• Writing MDX queries to get the data from a tabular model.
• Updated mapping tables related to assigned functional areas as directed by the Business Analysts.
• Worked with Excel Power Pivot Tables.
• Create PowerPivot models and PowerPivot reports, publish reports onto SharePoint, and deploy models into SQL Server SSAS instance. Create Parameterized SSRS Reports and PowerPivot Workbooks using data of Tabular model and Cube data model to prove the functionality of database

Environment: MS SQL Server 2012/2014, Management Studio (SSMS), ETL, Integration Services (SSIS) 2012, Power BI, Power BI (Pro), Power BI Service

Confidential, Sunnyvale, CA

BI Developer

Responsibilities:

• Responsible for gathering/refining requirements from the customer for developing reports in Power BI.
• Built Data Analytics or visualization using Power BI (Power View integrated with Share Point).
• Worked with DAX/MDX queries in building expressions for various business calculations.
• Building, publishing customized interactive reports and dashboards, report scheduling using Power BI service.
• Involved in Developing Power BI visualizations and dashboards using Power BI Desktop.
• Created Grouping, sorting columns and writing expressions according to the business requirements.
• Transferred the data using SSIS packages.
• Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Lookup.
• UsedSSISto createETLpackages to validate, extract, transform and load data toData Warehousedatabases.
• CreatedSSIS packages to Export data from text file to SQL Server Database.
• Created SQL Server Reports and developed query for generating drill down and drill through reports using SSRS.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Identified and worked with Parameters for parameterized reports in SSRS.
• UsedSSRSto create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports inSSRS.
• Generating Ad-Hoc reports on a timely basis and also to fulfill immediate requirements.
• Used star and snow flake schema in designing cubes for creating SSAS packages.

Environment: MS SQL Server 2008/2012 Enterprise Edition, MS SQL Server Reporting Services 2012, Power BI.

Confidential, MI

MS SQL Server/SSAS/SSIS/SSRS Developer

Responsibilities:

• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple homogeneous and heterogeneous information sources (CSV, Excel, DB2, SQL 2000, and SQL 2005).
• Created Configurations to make package portable and created Event handlers for handling package error.
• Used For-Each Loop Container, Sequence Container, Script task, Expressions, Execute SQL task, Variables, Send Mail Task, Package Execution task to achieve business needs.
• Created SSIS packages to Extract, Transform and load data using different transformations such as Lookup, Used Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension, Merge Join and Union all in transformation of SSIS Packages.
• Created and modified various Stored Procedures used in the application using T-SQL.
• Designed Cubes with star schema and snow flake schema in SSAS and Executing Analysis Services Processing Task in SSIS for processing cubes in packages.
• Scheduled and maintain packages by daily, weekly and monthly using SQL Server Agent in SSMS.
• Ad-Hoc reporting was one of the major responsibilities.
• Built SSAS Cubes for Aggregate reporting
• Worked in Creating Calculations using MDX and Supported DAX expressions which were using Pivot table reports
• Created Project Expense Statements in all Data marts and other Financial Reports using SSRS.
• Developed yearly and quarterly company expense reports.
• Responsible for Deployment of the report using SSRS and used Report subscription (Data Driven and Email) to publish reports.
• Tuning SQL query for better performance using SQL Profiler.
• Actively supported business users for change requests.

Environment: SQL Server 2000/2005, Enterprise Edition, SQL, Enterprise manager, SSRS 2005, SSIS 2005, Spotlight, MS SharePoint, MS Access 2000 & Windows 2003/2000 platform, VB.NET, ASP.NET.

Confidential

SQL Server /Developer

Responsibilities:

• Created SSIS package to load data from Flat File to Flat File and Flat File to SQL Server 2005 and Oracle 10g using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Used SSIS packages to Validate, Extract, Transform and Load data to DW and Data Mart Databases.
• Created various Parameterized Reports, Drill through Reports using SSRS 2005.
• Generated ad hoc reports using MS Reporting services.
• Reports were scheduled to be delivered by Email and File. Created Dashboard reports using SSRS.
• Generated reports using SSRS that were used to send information to different Primary vendors, Clients and managers.
• Formed and developed the stored procedures, triggers to handle complex business rules, data conversion, historical data, and audit analysis.
• Implemented a well - planned backup and restore strategy that protects databases against data loss.

Tools: & Technologies: MS SQL Server 2005, SSAS, T-SQL, SSIS, SSRS, Erwin, MS Access, MS Word