SUMMARY

• Over 6+ years of professional IT experience in design, development, implementation and support of mission - critical Business Intelligence (BI) applications.
• Experience in Analysis, Design, Development, Testing and Implementation of Business applications and Client/Server applications.
• Proficient in SQL Server and T-SQL (DDL and DML) in constructing Tables, Normalization techniques on database Tables.
• Experience in Data warehousing and Business Intelligence with hands on experience in Power BI, Tableau, olikview, SAP Business Objects and IBM Datastage.
• Have excellent skills in Data Warehouse: Relational and Multi-Dimensional databases: Data Migration: System & Data Integration, Reporting: Analysis and Software Development and Data Management.
• Requested data from Google Analytics from Tableau, and overcome the sampling limits that would typically apply in the interface and the Core Reporting API.
• Used Tableau and Google Analytics to analyze web traffic and make business decisions on the traffic coming from different locations.
• Expert in creating and using Stored Procedures, Views, User Defined Functions.
• Good in creating Sub-Queries and complex Joins for queries involving multiple tables and Exception Handlers.
• Excellent experience in creating Indexes, Indexed Views in observing Business Rules and creating effective Functions and appropriate Triggers to assist efficient data manipulation and data consistency.
• Well versed in Data Extraction, Transforming and Loading (ETL) using tools like SQL Server Integration Services (SSIS) and Data Transformation Services (DTS)
• Proficient in creating dynamic packages for Incremental Loads and Data Cleansing in Data Warehouse using SSIS.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Experienced in working on version control systems like Subversion and GIT.
• Experienced in publishing Power BI Desktop reports created in Report view to the Power BI service.
• Used Power Query to acquire data and Power BI desktop for designing rich visuals.
• Extracted, transformed and loaded data from various heterogeneous data sources and destinations like Access, Excel, CSV, Oracle, flat files using connectors, tasks and transformations provided by SSIS.
• Used various sources to pull data into Power BI such as SQL Server, SAP BW, Oracle, SQL Azure etc.
• Extensive experience in report writing using SQL Server Reporting Services like Table report, Matrix report, Chart Report, Pie charts, Drill Down, Cascading, Parameterized, Sub reports.
• Experience in creating jobs, SQL Mail, Alerts and schedule SSIS Packages using SQL Server Agent.
• Involved in Query Optimization and Performance Tuning using SQL Profiler and Index Tuning Wizard.
• Created, Maintained & scheduled various reports in Power BI like Tabular Reports, Matrix Reports.
• Extensively worked on views, cursors, CTE's, schemas, permissions and performance issues with client/server database design.
• Worked on Data Analysis Expressions (DAX) for accessing data directly from tabular SSAS database.

TECHNICAL SKILLS

ETL tools: SQL Loader, Informatica Power Center 8.1, 7.1, 6.2.

BI Tools Libraries: Tableau Desktop 10.x, Tableau Server, Tableau online, Tableau Public, Tableau Reader, SQL server reporting services (SSRS), SQL Server Analysis Services (SSAS), SQL server Integrating Services(SSIS), Alteryx 11

Databases: SQL server, Oracle 8i,9i,10g, Teradata, SAP hana, Redshift, hadoop

Data Modeling: ER/Studio 3.5/4.0, Erwin 4.1

Languages: Python, PySpark, MS-SQL, MySQL, hive, HTML5, CS3, JavaScript and XML

Web Servers: Apache web server, Microsoft IIS 4.0, Jboss 6.4

OS: Windows XP/03/07/10, OS X, Linux/Unix

Front-End Tools: Microsoft Project, Microsoft Office, Microsoft Excel

PROFESSIONAL EXPERIENCE

Confidential, Columbus, Ohio

Power BI Developer

Responsibilities:

• Guide the design and development of data management and business intelligence projects to drive strategic decisions through data driven actionable metrics and insights.
• Designing, developing and maintaining business intelligence solutions. Crafting and executing queries upon request for data. Presenting information through reports and visualization.
• Knowledge of and proven expertise with cloud implementations in AWS, Azure
• Provide subject matter expertise in data modeling and architecture design. Assist in evaluating and selecting the best technologies and tools to support the BI mission.
• Imported data from SQL Server DB, Azure SQL DB to Power BI to generate reports.
• Created Dax Queries to generated computed columns in Power BI.
• Generated computed tables in Power BI by using Dax.
• Used Tableau and Google Analytics to analyze web traffic and make business decisions on the traffic coming from different locations.
• Used the Tableau Web Data Connector JavaScript library to connect to the GoogleAnalytics data without having pitfalls going directly with the GA connector
• Manage development and production issues impacting our clients and operations.
• Build BI reports, dashboards, drill-downs, filters, graphs, etc. on the MicrosoftPower BI platform.
• Monitor and improve data and BI processes to meet firm SLAs and increase efficiency.
• Leverage technology capabilities and standards while working with technology system owners to identify appropriate data sources, define and build required data transformation logic.
• Significant experience solutioning, architecting, designing, implementing, migrating, and operating in an enterprise cloud environment
• Perform detailed data analysis to derive insights and deliver operational mechanism such as dashboards or ad-hoc reports.
• Maintain in-depth knowledge of IT industry best practices, technologies, architectures and emerging technologies.
• Provide architectural consulting to programs, projects and product initiatives.
• Review new and existing solution delivery for compliance with IT standards, policies and Ensure that project documentation captures significant architectural decisions.
• Identify architectural risks and propose alternatives and solutions.
• Provide analysis of project, including business case, ROI and post-project review.
• Drive innovation, best practices and achievement of strategic objectives.

Environment: Power BI Desktop, Power BI Server, MS Office Suite, SQL Server, Oracle, Informatica, Teradata, MS Excel.

Confidential, Columbus

Power BI Developer

Responsibilities:

• Expert in preparing performance Dashboard, Job Failure stats, Data Volume check using SSRS, SSIS, and SQL.
• Create reports in Power BIutilizing the SSASTabular via Analysis connector as Data Source.
• Expert in developing multiple kind of Power BI Reports and Dashboards.
• Experience in publishing Power BI Desktop reports created in Report view to the Power BI service& Report Server.
• Explore&Analyze data in a Variety of ways and across multiple visualizations using Power BI.
• Understanding the business requirement and functional specification of the client module with Business Executives & Analysts.
• Created SSIS Packages/projects to move data from source to destination programmatic by using Visual Studio 2014 and developed ETL packages to extract and transform data from data sources like MS Access.
• Involved in Data Scrubbing and Data Cleansing using MDS, DQS.
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for DBMS.
• Extensively used various SSIS objects such as Control Flow Components, Dataflow Components, Connection managers, Logging, Configuration Files etc.
• Designed, developed, debugged Stored Procedures, configuration files and implement best practices packages to maintain optimal performance.
• Creating Dashboard Reports using Power BI and Tableau.
• Implemented Power BI Power Query to extract data from external sources and modify the data to generate the reports.
• Created various visualizations such as Stacked Charts, Pie Charts, Donut Chart cards according to business requirements. Worked on RLS to constrain the user access to the row level data.
• Involved in creating MDX,DAX, Cubes and Tabular models using SQL Analysis Services (SSAS).
• Design and write elastic queries to access data across database and Migrate an existing SQL Server Database to use Azure Database.
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Worked on both live and import data to Power BI for creating reports.
• Worked with Power BI gateway to schedule daily job to refresh data.
• Expertise in publishing Power Bi reports of dashboards in Power BI server and scheduling the dataset to refresh for live data in Power BI server using Direct Query.
• Managed relationship between Power BI using Schemas such as Star & Snowflake.
• Created calculated columns and measure in Power BI and Excel depending on the requirement using DAX expressions.
• Familiar with DAX Functions Such as SUMX, CALCULATE, ALLEXCEPT,FILTER Functions.
• Expertise in Data Cleansing using Power Query in Power BI Desktop Editor.
• Provided ongoing support and configuration for JIRA projects, workflow, screens, fields, permissions and other administrative tasks.

Environment: MS SQL Server 2014, SQL Server Integration Services 2014 (SSIS), SQL Server Analysis Services 2014 (SSAS), SQL Server Reporting Services (SSRS), MDX, DAX, T-SQL, Shell Scripts, Microsoft Visual Studio 2014, JIRA, MDS, DQS, Power BI Desktop, Power Query, TFS, Tableau, Azure, MS Access, ETL, Excel.

Confidential, Santa Clara, CA

Sr. Power BI Developer / Sr. Tableau Developer

Responsibilities:

• As Tableau Developer, primary activities included designing technology roadmap for Tableau; product installation and implementation development of insightful dashboards; serving as SME point of contact for Tableau and delivery of solutions adhering to BI industry best practices.
• Solving P1 issues for the users in the production.
• Implemented row level security for the tableau dashboards and used various advanced table calculations for the dashboards.
• Architect and design API Security, Container Security, Azure / AWS Cloud Security, etc
• Created and maintained SOX documentation required for critical financial file systems.
• Mentored and trained less tenured Business Analysts for their development.
• Use tools such as SQL and Insync for investigation of issues and work closely with our Actuarial and Underwriting Customers.
• Managed projects ranging from large to small.
• Created, maintained and queried relational database (MS Access). Understand and use SQL regularly for problem analysis.
• Member of a team that created the proof of concept for the selection of the ETL tool (BI tool). Sat with vendors and evaluated vendor tools during the proof of concept.
• A member of the team that designed and created the infrastructure for a Data Store which was used for conversion and routing of information created outside of the company and moved to Safeco data source.
• Created specifications for the conversion of data outside of Safeco into legacy data. Learned and understood complexities of outside systems and was able to convert into Safeco terms.
• Work and communicate daily across departmental boundaries.
• Proven strong analytical and problem solving skills.
• Team member of the data warehousing initiative - conducted interviews with high level management about their data warehousing needs.
• Willingness to learn new technologies. Enjoy working on the technical side as well leading project efforts.
• Created incremental refreshes for data sources on Tableau Server.
• Created report schedules, data connections, projects, groups in TableauServer.
• Implemented action filters, parameters, calculated filed and set for preparing dashboards and worksheets in Tableau.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Created solution driven dashboards by developing different chart types including Crosstab's, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau Desktop.
• Created Adhoc reports to users in Tableau Desktop by connecting various data sources, multiple views and associated reports. Used Excel, flat files, CSV files to create Tableau Adhoc reports.
• Design interactive dashboards in TableauDesktop and published them to Tableau Server.
• Strong presentation skills
• Attention to detail and quality.
• Ability to work independently and deliver around tight timelines.
• Coordinate with multiple technology teams on production releases and related administrative tasks.
• Able to thrive in an environment that requires flexibility and multi-tasking.

Environment: Tableau Desktop 10.5/10.3, Tableau Server 9.3, MS Office Suite, SQL, T-SQL, PL/SQL, Ms-Excel, MDX, DAX, OLAP Cubes, Microsoft Analysis Services.

Confidential - Tampa, FL

Tableau/Power BI Developer

Responsibilities:

• Created Tableau dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts etc. using show me functionality.
• Created interactive data visualizations in Tableau, using relational and aggregate data sources.
• Created complex dashboard using parameters, sets, groups and calculations and drill down and drill up in worksheets and customization using filters and actions.
• Integrated custom visuals based on business requirement using powerBI desktop.
• Converting all operational excel report into Power BI Reports.
• As a Tableau SME, responsible for the design, development and production support of interactive data visualizations used across the company.
• Deep experience in architecting cloud solutions for enterprise
• Experience in deploying solutions in Azure and AWS platforms
• Blended data from multiple databases into one report by selecting primary keys from each database for data validation.
• Provide Support to Business users in Business Objects Reporting.
• Identify areas of opportunity to improve ROI of marketing activities by analyzing customer behavior.
• Worked on all types of transformations that are available in Power bi query editor.
• Scheduled Automatic refresh and scheduling refresh in power bi service.
• Implemented metrics, filters, reports, dashboards and also created advanced chart types, using calculations to manipulate the data and enable user driven parameters for visualizations and drilled down level of detail using sets.
• Developed interactive views with action/highlight filters to track-manage-correct system entry errors which provided strategic insights to Finance leaders, that helped decrease the faulty inputs into their projects software.
• Implemented workbooks to display Year to Date, Month to Date, Quarter to Date analysis for Operational expenses for IT leaders based on Accounts, and generated bullet graphs.
• Implement complex formulas, calculations & Level of detail (LOD) within Tableau to meet the needs of complex business logic.
• Created advance connections, join new tables, create & manage Extract and Monitor Queries using SQL Assistant.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Designed and developed ETL routines, using Informatica Power Center within the Informatica Mappings, usage of Lookups, Aggregator, Mapplets, connected and unconnected stored procedures / functions / Lookups, SQL overrides usage in Lookups and source filter usage in Source qualifiers and data flow management into multiple targets using Routers were extensively done.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Connected Tableau to various databases and performed live data connections, query auto updates on data refresh.

Environment: Tableau Desktop 10.5/10.3, Tableau Server 9.3, MS Office Suite, SQL Server, PL/SQL, Informatica, Teradata, MS Excel.

Confidential

Tableau/SQL Developer

Responsibilities:

• Built Strategic, Analytical and operational dashboards using Tableau.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• Developed Inventory reconciliation, Sales KPI summary update reports, Days Inventory on hand report for different channels, firms and products rolling up by month end.
• Created SQL views to pull data from SQL Server and developed reports using advanced calculations, filters and parameters.
• Training business users for all things Tableau and data analysis.
• Creating New Schedule's and checking the task's daily on the Tableau Server.
• Maintaining server activities, user activity, and customized views on Tableau Server analysis
• Interacted with the Business Users and Supervisors to gather business requirements.
• Converted the User Requirements into Business Requirements Document, Functional and Technical Requirements Documents.
• Created Business Process Models from the requirement specifications.
• Worked on developing Tables, Views, Indexes, Stored Procedures, Triggers, Queries, and Macros using MS SQL Server 2005, and MS Access databases.
• Involved in Partitioning tables that have bulk inserts, deletes and updates to improve the performance.
• Extracted data from xml and flat files using SSIS.
• Generated parameterized/Drilldown, Drill through & Cascaded reports using SSRS.
• Created, maintained, modified, and optimized SQL Server databases, database security and auditing.
• Designed, programmed, deployed and tested the requested Reports.
• Designed ER diagrams (Physical and Logical using Erwin) and mapping the data into database objects.
• Developed Data Flow Diagrams, illustrating the flow of data from the legacy systems into the Application Database Tables, along with checkpoints for testing verification.
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration.
• Analyzed long running queries and tuned the complex queries to optimize application and system performance.
• Developed user test cases and validated test results during user acceptance testing.
• Assisted in test planning and execution. Created test plan for User Acceptance Testing.
• Implemented a well-planned Backup and Restoration strategy that protects databases against data loss due to damage caused by a variety of failures.

Environment: MS SQL Server 2000/2005/2008, Erwin, MS Access, SQL Server Integration Services (SSIS), SSRS Import & Export Data, SQL Reporting Services, XML.