SUMMARY:

• Over 7+ years experienced professional as an ETL/Tableau/Power Bi//MSBI/SSIS/SSRS/SSAS/SQL developer using Microsoft BI products in various domains Retail Business, Pharmaceutical, Automotive, Banking and Financial services.
• Experience in migration of data and reports using SQL server 2012/2008R 2/2008/2005/2000 and Visual studio 2012/2008/2005.
• Expertise in RDBMS writing and performance Optimizing Stored Procedures, complex T - SQL queries involving Joins, Sub-Queries, Triggers, Cursors, Indexes, Functions, Views, CTE’s.
• Proficient in writing DDL, DML, DCL, TCL statements, defining Keys, using Auto Increment.
• Good Understanding of OLTP and OLAP systems and Data-Ware House, Data Mart concepts.
• Strong Experience in creating SSIS packages, migrating DTS Packages to SSIS, data extraction from various data sources using Flat file, Excel, ADO.NET, ODBC, OLEDB connections.
• Proficient in using SSIS Control Flow tasks, Containers, Data Flow tasks, Transformations, Database administration tasks.
• Experience creating SharePoint Web Part, .ASPX page, List, Form, Library, integrating using the ETL tool SQL Server Integration Services (SSIS).
• Knowledge of deploying SSIS project in Integration Services Catalog, Deploying to File system, SQL Server, debugging, Error handling and Performance tuning of the SSIS ETL package.
• Experience in SQL Server Analysis Services (SSAS) creating Data sources, Data Source Views (Star Schema, Snow Flake schema) and writing Named queries, Named Calculations, Cube, Dimensions, Attributes, defining relationships and Hierarchies, Calculated Measure, Measure Group, Fact less Fact table.
• Experience creating Data Mining a structure, Mining Models, defining KPI’s, building partitions, defining aggregations and creating perspectives, Translations using SSAS, deploying & processing.
• Good knowledge working with DAX expressions, MDX queries, DMX data manipulation and data definition statements.
• Expertise with SQL Server Reporting Services (SSRS) creating Data Sources, Datasets, table, Graph, chart, matrix, Drill down, Drill Through, parameterized, indicators, gauges, Dashboards.
• Experience using Report Designer, Report Manager, Report Builder and performance optimizing.
• Experience working with SAP BW Info cubes, DSO, Report creation using SAP Business Objects.
• Experience in creating reports using Tableau Desktop, Power Bi Desktop, Power Bi Service, Power Bi Mobile Apps, creating Datasets, Visualizations, Reports, Dashboards, Tiles, Content Packs, gateways.
• Good Experience in creating visualizations with drill down, drill up options, using slicers, tables, matrix, scatter charts, waterfall and funnel, formatting, sorting the order using Power Bi.
• Experience resolving network related issues, working in Agile, Waterfall SDLC methodologies.
• Excellent analytical, documenting, communication, interpersonal skills and dedicated team player.

TECHNICAL SKILLS:

SQL server versions: 2014, 2012, 2008R2, 2008, Familiar with Oracle DBMS.

BI tools: SSMS, Visual Studio, Familiar with Tableau, Power Bi, SAP BW, SAP BO (webi).

Programming Languages: T-SQL, PL/SQL, C#,.NET.

Productivity Applications: MS Excel, MS Word, MS PowerPoint.

Familiar Programming Languages: C, C++, Java.

Agile Project Management Tools: Jira 7.1.

Source Control Management Tools: TFS, Tortoise and SVN.

Operating Systems: Windows, Linux, UNIX.

PROFESSIONAL EXPERIENCE:

Confidential, Glendale, CA

Sr. MSBI Developer

Responsibilities:

• Working in Agile environment, Created logical and physical design of database and database objects to fit new business requirement and implemented new design into SQL server.
• Involved in Database Objects Migration from Oracle to SQL Server using SSMA.
• Created SSIS packages with Flat file, Excel connections, SQL stored procedures implementing logic, used derived column transformation for converting data types.
• Looping through the files and archiving flat files after the data load to stage tables using SSIS.
• In SSIS, created ISW connection using Oracle attunity provider, wrote numerous PLSQL queries for loading reconciliation data.
• Created numerous SSIS (ETL) packages involving Control Flow, Containers and Data Flow Tasks, Email alerts.
• Automating the SSIS package execution, Debugging, Error Handling, SQL Stored Procedure and package performance tuning.
• Sending Email notifications in case of failed recon execution and success execution of each recon.
• Involved in DB Admin task like granting and revoking permissions on Master Dashboard table to users.
• Build, publish and customized interactive reports and dashboards, report scheduling using Tableau server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Restricted data for particular users using Row level security and user filters.
• Developed Tableau visualizations and dashboards using Tableau Desktop.
• Developed Tableau workbooks from multiple data sources using Data Blending.
• Using SSRS created Data sources, Datasets populating the report data and created table, chart, Drill through and parameterized reports with drop down option.
• Designed cascaded parameters SSRS reports for selecting particular recon and execution date of the recon.
• Designed Recon Dashboard using Lists, Rectangles, Indicators, and Gauges, created page breaks, formatting the report, sorting the report data in SSRS.
• Developed ad-hoc reports using Report Builder, deploying and scheduling the report delivery.
• Improved report performance by tuning SQL queries, created Cache and Snapshot copies, created page breaks, avoided using dataset parameters by creating filters which impacts report performance.
• Developed ad-hoc reports using Report Builder, deploying and scheduling the report delivery.
• Involved in Database admin tasks by collaborating with IT and operations team.
• Provided technical support and guidance to staff and clients, documenting the reconciliation project.
• Lead offshore meetings and tracking the status by weekly.

Environment: Microsoft SQL Server 2008R2, SSIS, SSRS, Tableau Desktop 9.3, T-SQL, C#, BIDS, SAP BO (Webi), SAP BW, MS Excel, MS Access, MS Word, SQL Profiler, Database Tuning Advisor, SSMA.

Confidential, Piscataway, NJ

Sr. SQL BI DEVELOPER

Responsibilities:

• Involved in data Warehouse development starting from requirement gathering to implementation and ongoing support, strong understanding of BI application design and development principles.
• Interacted with team in Analysis, Design and Developed database using ER diagram, Normalization and relational database concept.
• As a part of Database migration from Mainframes DB2 database to SQL server, built database objects from scratch, performing the data load using ETL tool SQL Server Integration Services (SSIS).
• Created SSIS packages to load the flat files to staging then to target SQL server target tables.
• Optimized the performance of T-SQL queries, removed unnecessary columns and eliminated redundant and inconsistent data top reduce the load times/report.
• Created Stored Procedures, User Defined Functions, Cursors, Views, Tuned SQL Queries, Indexes and Triggers to maintain referential integrity.
• Created, maintain and optimized stored procedures, database and ETL processes using SSIS.
• Supported and tuned performance of the database and scheduled daily transactional data load SSIS packages, worked with CDC new task available in SSIS 2012.
• Interacted with report owners to establish/clarify their requirements and developed report specifications using SSRS, Inventory and sales ad-hoc reports using Report Builder.
• Prepared detailed statistical & Inventory reports using SSRS to track progress of weekly, monthly and quarterly customers and sales growth.
• Involved in creating SharePoint Web Part, .ASPX page, List, Form, Library , integrating using the ETL tool SQL Server Integration Services (SSIS).
• Deployed SSRS Dashboards, Reports in SharePoint integrated mode by providing the target SharePoint URL, made changes to deployed SSRS reports by Checking out and checking in back to the server as per the requirement and testing the report results.
• Worked closely with the team in meeting the deadlines pertaining to design and development deliverables.

Environment: Microsoft SQL Server (2008R2, 2012), T-SQL, SSIS, SSRS, C#, Report Builder, Report Manager, SharePoint Designer 2010, JIRA, TFS, MS office.

Confidential, Detroit, MI

SQL BI DEVELOPER

Responsibilities:

• Working in Waterfall environment, designed the database objects to serve business need.
• Created SSIS (ETL) packages with .NET Framework Data Provider connection, involving Control Flow and Data Flow Tasks, wrote SQL stored procedures implementing logic and data cleansing, Event handling.
• Optimized the performance of SSIS package and SQL stored Procedures for better package execution.
• Using SSAS created Data source, Data Source views (Star Schema), Named Calculations, defined relationship between the tables.
• Created Dimensions, attributes, relationship between attributes and hierarchies, measures and measure group.
• Created and processed complex SSAS cubes with multiple fact measure groups and multiple dimension hierarchies based on the OLAP reporting needs.
• Created calculated measures, raised change requests by making changes to the SSAS cube as per the requirement.
• Created Key performance indicators (KPI’s), Partitions, Aggregations serving the business need.
• Involved in creating Data Mining structures, mining models, defining Data types, content types using Data mining wizard also wrote Data mining expressions.
• Participated in status meetings, updating the project progress and involved in documentation.
• Worked closely with the team in meeting the deadlines pertaining to design and development deliverables.

Environment: Microsoft SQL Server 2012, T-SQL, SSMS, SSIS, SSAS, Microsoft Dynamics CRM, SAP SD, Data Mining Wizard, MS Excel, Word

Confidential, Jersey City, NJ

Sr. SQL SERVER/BI Developer

Responsibilities:

• Created Database objects to fit new requirement, designed various SSIS packages for loading capital market and securities data from various Data sources into stage tables, sending the result set to Business users via Email.
• Used SSIS to create capital market and fixed income ETL packages to validate, extract, transform and load data to data warehouse and OLAP data marts and tuned the SSIS package performance.
• Created Datasets by writing MDX queries using SSRS, Used partitions for each branch, created perspectives for improving the SSRS report performance.
• Created parameters for the purpose of taking inputs from users and filtering the data to be displayed and displaying the traffic light indicators in the SSRS reports.
• Designed, developed and deployed cascaded reports and Dashboards in MS SQL Server environment using SSRS.
• Created Dashboards to show and analyze the performance of the project.
• Transformed data into SQL server database using OLEDB connection by creating various SSIS packages.
• Created Data Transformation tasks like Bulk Insert to import/export data from clients.
• Generated Daily, Weekly and Monthly trigger based SSRS reports regarding assigned projects to designated managers and clients.
• Used SQL profiler and SQL Query analyzer for performance tuning.
• Connected to Loans Database and created bar and table visualizations using Power Bi.
• Using Power Bi Created Dashboards by pinning the tiles and reports.
• Formatted the irregular data and used transpose for switching the rows and columns in Power Bi.
• Involved in creating calculated columns writing Data analysis Expressions (DAX).
• Created content pack for sales force in power bi, deploying to Power Bi Service.
• Created gateways for scheduling the data refresh periodically.
• Created groups for restricting the users to view reports created using Power Bi.
• Used Tortoise SVN a version control software for windows to store, run, view, edit and revert back to different versions of the design in case of a system crash.
• Involved in daily, weekly meetings tracking the progress and status of the project.

Environment: Microsoft SQL Server 2012, T-SQL, C#, SSMS, SSDT, Power Bi, SVN, MS Excel, Word

Confidential

SQL SERVER Developer

Responsibilities:

• Active member of the team designing the OLTP and data warehouse relational data models
• Embedded complex queries and procedures in DTS Packages based on business requirements.
• Optimized poorly performing queries and procedures for optimal performance.
• Implemented data integrity by implementing constraints and triggers.
• Replaced sub queries with inner and outer join statements for improving query performance.
• Developed all the required stored procedures, user defined functions, triggers using T-SQL.
• Involved in the Analysis and creation of Staging DB and defined various facts and Dimensions in the data.
• Designed the Data Mart defining Entities, Attributes and relationships between them.
• Involved in performing Extraction, Transformation and Loading using DTS.
• Involved in Data Integration by identifying the information needs within and across functional areas of an enterprise database upgrade and scripting/Data Migration with SQL server DTS.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes whenever necessary
• Involved in developing a database system prototype for front end application for testing purposes
• Used PHP in backend of company’s web portal for reporting purpose.

Environment: MS SQL Server 2000, DTS, Flat Files, SQL Server Agent, Enterprise Manager, Query Analyzer

Confidential

Backend SQL Engineer

Responsibilities:

• Involved in Installation and configuration of SQL server 2000 on Servers.
• Maintaining User account administration for Different domains.
• Applied patches and service packs to keep the database at current patch level.
• Setup and troubleshoot for Active/Passive Clustering in SQL Server2000.
• Monitor failed and long running MS SQL Server jobs.
• Created Scheduled maintenances and backup procedures to the database as a DR method.
• Involved in Configuration, Administration, and Implementation with Log Shipping mechanism.
• Configured Disaster Recovery solution with Transaction and Merge Replication from Production to Development Server for multiple subscribers with Non-Updatable subscriptions.
• Scheduled Backup/Recovery jobs, creation of Logins, Users, and Permissions.
• Up gradation of existing Servers from SQL Server 7.0 to SQL Server 2000.
• Implemented database standards and naming convention for the database objects.
• Implement and maintain database security.
• Implemented trigger and stored procedures and enforced business rules via checks and constraints.
• Fine-tuned Stored Procedures using Execution Plan in T-SQL for better performance.
• Going through the clients' requirements and coming up with database design and application Architecture.
• Designed new job process, new database maintenance plans, DTS programs and did Performance tuning of the existing processes.
• Data conversions and data loads from various databases and file structures.
• Generated reports using Crystal reports.
• Monitor, tune, and analyze database performance and allocate server resources to achieve optimum database performance.

Environment: SQL Server 2000, DTS, T-SQL, Crystal reports7, Windows 2000 Server.