SUMMARY:

• Around 7+ years of experience in IT as a SQL Developer with specialized skills in SSIS, SSAS, and SSRS.
• Experience in managing security of SQL Server 2016/ 2014/2012/2008 R2/2008/2005 databases by creating database users and roles and assigning proper permissions according to business requirements.
• Strong SQL Server 2014/2012/2008 R2/2008 development skills including writing stored procedures, user - defined functions, triggers, views, and indexes.
• Proficient with SQL Server, BI Stack (SSIS, SSAS, and SSRS), Power BI, and Tableau within large and complex environments.
• Good Knowledge in design and implementation processes for deploying, upgrading, managing, archiving and extracting data for reporting using SQL Server Reporting Services (SSRS)/ Power BI.
• Experience in developing end-to-end Business Intelligence solutions in accordance with Standard OLAP Methodologies using Tableau.
• Experience in Data Modelling and CASE tools like ER/Studio.
• Created and maintained numerous Crystal Reports including financial and operational Reports.
• Used TFS 2010 to check in SQL scripts, reports and Integration packages. Involved in documenting the entire technical process.
• Extensive experience in designing, developing, and delivering business intelligence solutions using Power BI, SQL Server Integration Services (SSIS), Analysis Services (SSAS), and Reporting Services (SSRS).
• Validation of the scripts and to check in the scripts like tables, views and stored procedures in to TFS.
• Strong Transact-SQL query writing skills (DDL, DML, and DCL).
• Excellent command writing ad hoc queries utilizing dynamic SQL.
• Extensive experience on Business analysis and Enterprise reporting solutions delivery using Crystal Reports.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Created SSIS process design architecting the flow of data from various sources to target.
• Expert in SQL Server Business Intelligence suite of products like SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), and SQL Server Analysis Services (SSAS).
• Expertise in creating reports of all types in SSRS, like ad hoc, drill-down, pivot, and tabular reports.
• Experience in creating DTS/SSIS packages with ActiveX scripting for transferred data modifications.
• Expert in creating complex Crystal Reports (Ad-hoc Reports, Frequency Reports, Summary Reports, Drill Down, Dynamic Grouping, Graphical, aging Reports).
• Developed complex programs in T-SQL, writing Stored Procedures, Triggers and Queries with best execution plan.
• Develop optimized SQL Server stored procedures, functions, and database views
• Experience using SSIS tools like Import/Export Wizard, Package Installation, and SSIS Package Designer.
• Strong experience in defining referenced relationships and identifying KPIs in SSAS 2008/2005.
• Experience in gathering requirements, analysis, Design, Development, Testing and Production rollover of Reporting and Analysis projects.
• Good Working Knowledge in Agile Project management (Scrum process).

TECHNICAL SKILLS:

BI Tools: Tableau Desktop 9.x/10.x, Tableau Server 9.x/10.x, Tableau Reader

RDBMS: Oracle, SQL Server, MY SQL, MS Access, SSAS, SSIS

Data Bases: MS SQL Server 2012/2008R2/2008/2005, Oracle 9i/10g/11g, Teradata, Horton works Hadoop Hive, SQL Enterprise Manager, SQL Profiler, DTS Import/Export, SQL Client Configuration utility, Backup Server, Replication Server, Microsoft OLAP Services, SQL Server Management Studio, SQL Server Business Intelligence Development Studio (BIDS), EDI

Productivity Tools: MS Word, MS Excel, MS PowerPoint, MS Visio, MS Project, Erwin

Operating Systems: Windows 7/XP, Windows Server UNIX/Linux

WORK EXPERIENCE:

Confidential, Rochester, MN

Tableau Admin/Power BI Analyst

Responsibilities:

• Interacting with the client to understand the project and finalize its scope.
• Estimation, design and development of various modules.
• Coordinating with other teams working on the same project.
• Ensuring smooth delivery of the project.
• Major part of the Big Data Admin team to carry out the reporting activities after the old systems are decommissioned and the data is migrated into Big Data.
• Decommission of old systems and migrating data availability and data quality into Big Data.
• Perform the required data wrangling before connecting to the data source (Hive) from the Tableau client.
• Used HiveQL to run queries in Hive and extract data into Tableau Client.
• Used multiple join conditions to get the data from different tables and use the same to create custom SQL in Tableau.
• Developed individual reports and design the final dashboard according to the user requirement.
• Research ways to help the report users to see the bigger picture at a single glance and insert the ability to drill through the different levels of dimensions.
• Employed various Tableau functionalities like Parameters, Filters, Contexts, Data Source, Filters, Actions Functions, Hierarchies, Sets, Groups, Calculations, etc.
• Experience in creating different visualizations using Bar chart, Stacked Bars, Line Graph, Pie chart, Gantt chart, Heat Maps, Box plot, Scatter plots, Histograms, Bullets, etc.
• Developed compliance report for incident management (Inflow/closure of incidents, Average time for resolution, and Individuals incident stats).
• Scheduling data refresh on Tableau Server for various business requirements to ensure the views and dashboards display the changed data. Use data blending Techniques in case of merging different sources.
• Created dual-axis charts with multiple measures.
• Create Alteryx workflows for such scenarios where data is not readily available.
• Processed the spend and goals data in Alteryx in such a way that it is suitable for reporting.
• Good SQL reporting skills with the ability to create SQL views and write SQL queries.
• Developed custom tools with the Alteryx SDK and API modifying the Alteryx software to use PDF files, web OLAP and Oracle Essbase cubed SQL data storage as native data inputs.
• Maintained Tableau Server in all the environments (Dev, Test, Prod).
• Ability to authoring on Tableau server by changing mark types and adding filters directly in a web browser.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Documenting the dashboard needs, the critical success factors of the business, related KPIs and measures in the dataset, and the designs.
• Assisting users in creating and modifying worksheets and data visualization dashboards.
• Usage monitoring, technical policies set up and controls, admin best practices, technical audits, Managing Tableau Sites and servers in with a clustered environment.
• Testing the reports for formatting and data correctness and publishing the workbooks on the Tableau server for scheduled refreshes.
• Created report schedules, data connections, projects, groups in Tableau server.
• Develops and provides documentation, training, and support for business users.
• Worked on Agile Methodology, where Team Foundation Server (TFS) is used as a tool to update tasks of user story.
• Interacting with the client to understand the project and finalize its scope.
• Estimation, design and development of various modules.
• Coordinating with other teams working on the same project.
• Ensuring smooth delivery of the project.
• Create and designed multiple dashboards as per the customer requirements.
• Develop High performance report and dashboard with high volume data.
• Responsible for all the design fixes for multiple dashboards created by the team.
• Providing continuous feedback to the team on the dashboards design.
• Migration of Finance reports from SAP BO to Tableau.
• Created visual workflows in Alteryx for data blending and analysis using data quality, integration and transformation.
• Develop story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data with the usage of quick filters for demand needed information.
• Performance tuning, Trouble shooting and support of existing system.
• Resolve various performance issues and analyzed the best process distribution for different projects.
• Design and develop reports such as Drill down, Drill-Through using Microsoft Reporting Services.
• Review dashboard and communicate with stakeholders and business groups.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.

Environment: Tableau Server 10.5, 2018.1, Tableau Desktop 10.5.1, Excel, Alteryx 11, SQL Server Management Studios, SSAS, SAP BO.

Confidential, Dallas, TX

SQL BI Developer/ Power BI developer

Responsibilities:

• Created and managed stored procedures, indexed views, user defined functions, triggers, database constraints to meet business requirements and policies.
• Thorough analysis and testing of database objects & T-SQL statements before deployment to the production server.
• Created SSIS packages to clean and load data to data warehouse and package to transfer data between OLTP and OLAP databases.
• 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.
• Used Window azure to deploy the application on cloud and managing the session. Worked on Azure Data Factory for Extract& Load data.
• Experience in extracting data from Azure HDInsight and publish the transformed data into AzureSQL Data Warehouse and build reports on BI platform.
• Developed SSAS solution for analytical reporting; implemented best practices for optimal performance
• Worked with different types of variables (Local, Global, and Shared) in writing formulas.
• Scheduling the reports depending on the users request to receive in different formats (Email, Public folder etc) in Crystal Enterprise using Crystal Reports Scheduler.
• Created and configured an OLTP replication database for disaster recovery purpose.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data ware house.
• Good understanding of Software Development Life Cycle (SDLC), Agile Methodologies.
• Created Hierarchies, Aggregations, partitions, calculated members and dashboards and scorecards with KPIs inusing SSAS.
• Scheduling Jobs and Alerting using SQL Server Agent in Power BI
• Created SSIS package to extract, validate and load data into Data warehouse.
• Expert in creating Star schema cubes using SSAS.
• Extensively worked on creating and managing OLAP cubes using SSAS
• Extensively worked on creating SSIS packages and have used for each Loop containers, Sequence Container for developing processes and loaded data using different transformations such as Derived Columns, Condition Split, Aggregate, Merge Join and Union all.
• Created the SSIS packages and scheduled them using SQL Server agent.
• Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Designed Dimensional Modeling using SSAS packages for End-User
• Created Crystal Reports Repository objects (Reports template, commands)
• Utilized Event Handling effectively to generate audits and logs for the generated SSIS packages.
• Performed archiving and achieved automated processing of the raw data through the ETL process in SSIS.
• Creating SSIS Packages to extract data from CSV and TXT files into schema tables and sends Email attachment of the extracted data.
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Employing data warehouse principles and theories, including knowledge of the various tactical approaches to data warehouse development.
• Extracted data from XML to SQL server.

Environment: SQL Server 2008R2 Enterprise Edition, .Net 3.5, SQL Server Data tools (SSAS, SSIS, SSRS), Enterprise manager, PPS, Azure SQL XML, MS PowerPoint, MS Project, MS Access 2003 & Windows Server 2008, Oracle, Crystal Reports, Cogon's, Business Objects, SharePoint, MOSS 2007

Confidential, Plano, TX

SQL BI Developer

Responsibilities:

• Analyzed user requirements and functional design, and prepared technical specifications, unit test plans, and created platform to run and validate the test cases.
• Worked with Subject Matter Experts (SMEs) in understanding, documenting, developing, and testing their requirements.
• Responsible for understanding the technology, and the requirements, and delegate work to the team in India.
• Migrated DTS packages from Legacy system like PARAGON to SQL SERVER 2005.
• Responsible for Knowledge transfer and training existing and newly recruited resources on various Loan IQ View practices and processes such as report development, deployment, coding and tools used for managing and developing reports, deploying or executing components, and batch application.
• Generated matrix reports, tabular reports, drill down, drill through, sub reports and multi-parameterized reports.
• Performed modifications to DB2SQL code used to deliver data to downstream application interfaces.
• Demonstrated solid Reporting and SQL skills to coordinate changes to existing reports and develop new intraday and batch reports needed.
• Ran the Autosys batch jobs every week to generate reports in the LIQV(Web Application) after the scheduled LIQ batch runs for respective environments in SIT and UAT.
• Created different Parameterized Reports (SSRS 2008 R2) consisting of Report Criteria in various reports to minimize the report execution time and to limit the no of records required.
• Deployed Global and Zonal reports to Report server weekly, monthly and quarterly using Anthill and well as manually using Report Manager.
• Worked with financial systems team members to document systems and process environments.
• Submitted the ESRs to track the SIT, UAT and Production deployments and was also the Eastern Standard Time communication vehicle and deployment point person for work completed overnight in India.
• Attended to high priority report development and defect fixes for emergency and off-cycle releases and met deadlines in a rapid release cycle.
• Presented excellent communication skills and coordination skills to effectively work with other team members and get the development completed as per the deadline.
• Promoted the company culture by approaching each day with team-oriented and can-do attitude.

Environment: SQL Server Management Studio, HP Application Lifecycle Management 11.0, Power BI, Beyond Compare 3, Microsoft Visual Studio 2010, Microsoft Lync 2010, Microsoft SQL Server 2008 R2, SQL Server Business Intelligence Development Studio (BIDS), Tortoise SVN 1.7.6, Anthill, AutoSys, JIRA, SSRS 2008 R2, SharePoint 2010, MS Office 2010.

Confidential, Houston, TX

BI Developer

Responsibilities:

• Interacted with business to collect and understand Requirements.
• Translated the business needs into system requirements by communicating with the business on nontechnical level and with the System Analyst on technical level.
• Arranged walkthrough sessions with the user group and to confirm that all the requirements have been captured and obtained sign off on the requirements documents.
• Identified the key facts and dimensions necessary to support the business requirements. Develop the logical dimensional models.
• Conducted and participated in JAD sessions with the users, modelers, and developers for resolving issues.
• Performed source data quality assessments and created source to target mapping documentation defining source rules, target rules, and data transformations for various ETL packages in SSIS.
• Created Data Definitions and help maintain Metadata repository.
• Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization.
• Created Relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting,
• Groupings, live connections, and in-memory in both tableau and excel.
• Worked on motion chart, Bubble chart, Drill down analysis using tableau desktop.
• Involved in creating stored procedures, views, and custom SQL queries to import data from SQL server to Tableau
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards
• Defined and created procedures to install Tableau desktop mode and best practices for Tableau report development

Environment: Tableau Desktop, MS SQL Server 2008, Excel, SQL, SQL Server 2008, SQL BI Suite (SSIS, SSRS)MS Office, Visual Studio 2010

Confidential

SQL Developer

Responsibilities:

• Implemented ETL process to load the Data Warehouse and developed repositories (Microsoft SQL Server)
• Participated in stakeholder and project review meetings on weekly basis.
• Responsible for testing process of extracting, transforming, and loading data from oracle, flat files and placing it into data warehouse.
• Designed and documented the test cases for ensuring quality of data and performed thorough validation.
• Created dashboards and reports using Micro Strategy for managers which involved corporate wide data related to environmental factors
• Performed dimensional modeling to help prioritize different business processes
• Developed several scripts and SQL queries to create various reports for administration
• Developed Micro Strategy reporting tutorial for employees to help them create their own customized report

Environment: Informatica Power Center 6.x/7.1, BO 6.5, Microsoft Visio, Oracle 9i.