PROFESSIONAL SUMMARY:

• Over 9+years of Experience in Analyzing, Developing and Administrating reports using Power BI, SSRS, SSIS, SSAS, Crystal Reports, Power View, Power Pivot, Azure, VSTS, SQL Server 2008/2005, Oracle 11g/10g/9i, DB2, Access and QUORUM and BOLO.
• Proficient in Creating, Configuring and Fine - tuning SSIS packages, SSRS reports and T-SQL queries using tools like SQL Profiler, Performance Monitor and Database Engine Tuning advisor.
• Expertise in writing T-SQL queries, dynamic queries, sub-queries and complex joins for generating complex Stored Procedures, Triggers, User-Defined Functions, Views, Constraints (Primary key, Foreign key, Unique key, check key) and cursors.
• Expertise in Database Administration operations like Backup, Recovery, Replication and using SQL Profiler and excellent knowledge of DDL and DML in T-SQL.
• Experience in modeling Transactional Databases and Data Warehouse using tools like Erwin, Oracle Designer, Power Designer and ER/Studio.
• Solid understanding of Relational Database Systems (RDBMS), Normalization, Multi-Dimensional (Star) and Snowflake logical and physical data modeling using ERWIN data modeler and MSVISIO.
• Expertise using Star Schema and Snow Flake Data Models.
• Expertise in creating reports such as Cascading, Drill through/Drill down Reports, Conditional, Table, Matrix, Charts, Ad-hoc Specialized in using Relational data warehouse and OLAP Cubes for producing Sub Reports.
• Experience with Data Warehouse Concepts, Methodologies and SDLC.
• Proficient in OLTP, OLAP and Data Warehousing Design concepts.
• Experience in generating Drill through and Drill down reports with Drop down menu option, sorting the data, defining subtotals in SSRS.
• Extensive experience in different type of reports including: Tabular forms, Matrix (cross Tab report) form, Conditional, List items, Charts and Sub reports.
• Worked on Data Analysis Expressions (DAX) for accessing data directly from tabular SSAS database.
• Performed DAX (Data Analysis Expressions) & MDX functions for the creation of calculations and measures in the Tabular Mode & multi-dimensional Cubes.
• Expert in Relational, Multi-Dimensional (Star) and Snowflake logical modeling.
• In-depth knowledge on Tableau Desktop and Tableau Server.
• Designed and deployed rich Graphic visualizations with Drill Down and Drop-down menu option and Parameterized using Tableau.
• Explore data in a variety of ways and across multiple visualizations using Power BI.
• Created reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.
• Experience using Toad, PL SQL Developer and Query Analyzer tools for writing queries.
• Experience in publishing Power BI Desktop reports created in Report view to the Power BI service.
• Experience in implementing different types of Replication models like Merge and Transactional.
• Monitored and Tuned MS SQL Server databases with tools like Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for optimal Performance.
• Experience in creating Power BI Dashboards (Power View, Power Query, Power Pivot, Power Maps).
• Experienced in Agile Methodologies like attending daily Scrums, maintaining User Stories and Burn down Charts, Backlog Grooming and Retrospective.

TECHNICAL SKILLS:

Database Technologies: SQL Server (2000, 2005, 2008,2008R2,2012,2014,2016), MS-Access

SQL, T: SQL, HTML, HTML5, CSS, XML, C, C++, C#

Business Intelligence Tools: MSBI (SSIS, SSRS & SSAS), MS Power BI.

IDEs /Tools: MS Visual Studio 2012/2008/2005/2000 , SSMS

Other Tools: MS Office Suite (Word, PowerPoint, Visio), OLAP, OLTP, Erwin

Operating Systems: Microsoft Windows 98/2000/2003 Server/XP/7/8/2008 Server/2012 Server

ETL Tools: Data Transformation Services (DTS) - Export/Import, SQL Server Integration Service (SSIS)

Reporting Tools: SQL Server Reporting Services ( 2012/2008/2005/2000 ), Microsoft Access 2013, Excel, Power BI, Crystal Reports

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Power BI Developer

Responsibilities :

• Created Power BI dashboards and reports for D&M and Completions segment by connecting to SSAS cubes, AAS cubes, excel file.
• Involved in gathering requirements, business rules and prepared BI technical specifications.
• Created Complex Stored Procedures for implementing the business rules, also worked on Joins, CTEs (Common Table Expressions), Pivot and Unpivot tables, Materialized Views, Aggregate Conditions.
• Created various data models like Flattened, Star schema in SSAS - Tabular model / PowerPivot.
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables from different databases.
• Extensively worked on views, cursors, CTE's, schemas, permissions and performance issues with client/server database design.
• Developed SSIS packages using various Transformations such as conditional splits, fuzzy look ups, aggregations and multicasting.
• Used SSIS to create ETL packages to validate, extract, transform and load data to Data Warehouse databases.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Merge using SQL Server 2014 SP1 .
• Designed ETL package, with ETL Import/Export wizard for transferring data.
• Delivered required Power BI report as internet link, embedding in Office Tools.
• Worked on Data Analysis Expressions (DAX) for accessing data directly from tabular SSAS database.
• Responsible for creating SQL datasets for Power BI and Ad-hoc Reports.
• Maintained & scheduled various reports in Power BI like Tabular Reports, Matrix Reports.
• Created Tabular Models as a source to Power BI dashboards and scheduled jobs to refresh it in a timely manner.
• Elevated existing Power BI Dashboard on a regular basis as per requests from Business.

Environment: MS SQL Server 2012/2014, Business Intelligence Development Studio (BIDS), SQL Server Integration Services (SSIS 2014), SQL Server Analysis Services (SSAS 2014), SQL Server Reporting Services (SSRS 2014), Power BI, Power Pivot, Windows 2010, MS Excel, SQL Server Profiler.

Confidential, Houston, TX

Sr. SQL Server/SSIS/SSRS/SSAS Power BI Developer

Responsibilities :

• Worked with business users to gather information for reporting changes and new requirements.
• Created new reports and modified the existing reports and shared the reports on share point.
• Created power BI dashboards and reports for sales group by connecting Oracle database.
• Created reports using SSRS and Crystal reports tools.
• Created inventory, sales, audit, customer, purchase, Shipment order reports for different users.
• Verified the reports against Movex database.
• Used BPW designer to identify SSIS packages, Schedules, data sources.
• Worked on CMC to add users, security, reports & schedule the reports.
• Worked with MOVEX application for data source.
• Created stored procedures and views to fulfill the report requirements.
• Designed and developed intuitive Tableau Dashboards against Order Provisioning System to bring visibility on Order provisioning process and performance.
• Provided support for incidents/tickets on daily basis.

Environment: Crystal reports, Power BI, SSRS, SSIS,SSAS,Tableau, Microsoft visual studio 2013, SQL server, I series database, Oracle, Microsoft Excel, Microsoft Word, SharePoint.

Confidential, Boston, MA

Sr. MSBI Developer

Responsibilities :

• Installed and Upgraded from SQL Server 2008 to SQL server 2012 on Various Servers.
• Migrating Databases from SQL Server 2008 to SQL Server 2012.
• Planned, defined and designed data based on the business requirement. Creating dashboard, scorecards using performance point server according to client requirements.
• Expertise in data analysis by writing SQL and compare data for testing the results.
• Updated report requirement documents and shared the documents on Sharepoint.
• Supported production reports based on daily Remedy incidents.
• Worked on Transfer, Messenger plus, Small Talk applications to check and compare data.
• Worked on multiple projects (Transfer, Flow Cal, GCSCADA, Remedy, Audit, Erock) and prioritized the work.
• Created SSIS packages for transferring data from multiple databases.
• Did a lot of analysis on reports and universes to combine two universes (GASPE and GASPEALL) to make one and reduced the maintenance. (Panhandle, Trunkline, SeaRobin)
• Used SVN source control (Tortoise subversion) for controlling the stored procedures, Views, crystal and SSRS reports versions.
• Created crystal reports and SSRS (Report Manager) reports by using command SQL, stored procedures and views and exported them into pdf and excel.
• Created sub reports, Cross tab reports, chart reports and published the reports on the enterprise and scheduled the reports on daily and monthly basis.
• Created Top ten customer dashboard for business by using Power BI desktop.
• Followed the company process while deploying the code (SQL reports) to production.
• Converted crystal 2008 reports to 2013 version. (FGT and ETIH-Trans western, Tiger, FEP pipeline reports, GCSCADA, Flow Cal)
• Worked on upgrading the SQL Server conversion.
• Converted Deski, Webi reports to crystal and SSRS.
• Created and updated stored procedures and views for transfer merge project.

Environment: MS SQL Server 2012/2008, Enterprise Edition, Bamboo, Performance point server, MS SSRS 2012, MS SSIS 2012, T-SQL, VB Script, Windows Server 2007, Erwin 8.0

Confidential, Boston, MA

ETL/ MSBI Developer

Responsibilities :

• Involved in complete SDLC life cycle.
• Extract, Transform and Load source data into respective target tables to build the required data marts.
• Understand user requirements and Data Model defined and developed by the business analysts and data architects.
• Performed DBA tasks like Backup, Restore of tables and Stored Procedures and Refreshing Database on weekly basis.
• Created complex Stored Procedures, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards.
• Implemented different types of constraints on tables.
• Designed and applied entity and attributes description and definition for the models.
• Managed indexes, statistics and tuned queries by using execution plan for optimizing the performance of the databases.
• Maintained the physical database by monitoring and optimizing performance, data integrity and SQL queries for maximum efficiency using SQL Profiler.
• Created ETL process using SSIS to transfer data from heterogeneous data sources.
• Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Migrated DTS objects to SQL Server Integrated Services (SSIS) environment.
• Worked on different sources in SSIS (XML, Flat file, Excel, OLEDB Source)
• Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Responsible for gathering business requirements to create business user reports.
• Developed optimal stored procedures and queries to create data sets for reports.
• Created SSRS Reports on the top of the cube using some MDX queries.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Migrating COGNOS reports to SSRS.
• Worked on performance tuning on existing stored procedures and existing reports for the faster processing of reports.
• Developed SSAS Cubes, partitions, aggregation from scratch with Star Schema.
• Performed unit and system testing, troubleshooting and bug fixing in Prod and QA environments.

Environment: Windows Server 2003, SQL Server 2008/2005, SSIS, SSAS, SSRS, ProClarity/PPS, EDW, ODS Project Name Knowledge Management (KM)

Confidential, Richmond, VA

ETL/ Reports Developer

Responsibilities :

• Designed logical and physical models for staging database and data warehouse using Erwin database modeling tool.
• Created database projects for staging database and data warehouse in visual studio 2008, to store all related objects at one centralized location.
• Designed the entire ETL process involving the access, manipulation, analysis, interpretation and presentation of information from both internal and secondary data sources to the business.
• Created complex ETL (SSIS) packages to pull data from DB2/Oracle, load monthly data from Excel to SQL Server.
• Used master child SSIS packages for better design and ease of maintenance.
• Implemented error & failure handling in SSIS packages using event handlers, row redirects, check points and used loggings for monitoring the execution.
• Optimized packages by avoiding use of non-blocking transformation, executing tasks in parallel and optimizing code at source.
• Created alerts and mail confirmation of all packages and cube processes in SQL Server Agent to get event messages such as success/failure of package, procedure.
• Deployed SSIS packages to the production server using XML and SQL Server configurations.
• Created different kind of reports like parameterized reports, drill down reports, and sub reports to support business needs and involved in report deployment and report security.
• Developed complex reports like Drill capabilities, Complex freehand SQL queries, Functions, Master Detail, and Cross Tab with multiple breaks.
• Created Ad-hoc reports using Report Models (.smdl) files and deployed it on Report Manager to create reports on the fly for the people who are less adept with technical skills.
• Configured deployment of SQL Server Reporting Services to work with deployment of Microsoft SharePoint Integrated mode.
• Optimized the performance of reports by using various techniques like optimizing data-sets, making use of less number of input parameters along with caching and taking snapshot of reports.
• Implemented security on reports at Server Level, Report Level and Item Level according to the hierarchy in the organization and business requirement.
• Administered interface to organize reports and data sources, schedule report execution, delivery and track report history.

Environment: SQL Server 2008, Transact-SQL, SQL Server Integration Services (SSIS), SSRS (Reporting Services), Erwin, Windows Server.

Confidential, Dallas, Texas

SQL Server Developer

Responsibilities:

• Installation and configuration of MS SQL Server 2005 on Production and Test Servers.
• Developed SQL Queries and Stored Procedures to fetch data from different tables in remote databases using Joins.
• Used DBCC commands to check the physical and logical consistency of the Databases.
• Interacted with Business Users for Reporting Requirements.
• Experience in working with SSRS 2005 for generating reports like Drill Downs and Drill Through.
• Proper use of Indexes to enhance performance of individual queries for fast & efficient reporting.
• Created many SSIS packages using Import/Export Wizard and Control Flow and Data Flow Tasks with ETL Tool.
• Extensively involved in enterprise reporting in generating reports using Linked Reports, Sub Reports, Adhoc Reports, and Drill down reports, Drill through reports and filters, charts in SQL server Reporting Services.
• Involved in Reporting Services Administration by creating roles, users and providing security to Reports.
• On call 24/7 support to databases on weekly rotation.

Environment: Windows Server 2003, MS SQL Server 2005, Business Intelligence Development Studio (SSIS & SSRS).