SUMMARY:

• Enthusiastic IT professional with 9+ years’ experience in Data and business analytics with Strong analytical and problem solving and communication skills, ability to work to deadlines, result oriented, flexible and adaptable, sharp attention to details, excellent verbal and written communication skills, team player and ability to learn innovative technologies independently.

TECHNICAL SKILLS:

DBMS: SQL Server 2016, 2014, 2012 and 2008

Languages: SQL, C#

Operating Systems: Windows server 2003/XP/NT6.0/98/Vista,7,8,10

Reporting Tools: TABLEAU, Power BI, SQL server Reporting Services (SSRS) 2014/2012 and 2008

ETL Tools: SQL server Integration Services (SSIS) 2016/2014/2012 and 2008

Data Modeling: Microsoft Visual Studio 2008, 2010, SSAS

Office Tools: MS Word, PowerPoint, Excel, Visio, one note, MS Operations Manager, Share point

Job Scheduler: SQL Server Agent

PROFESSIONAL EXPERIENCE:

Confidential, Washington, DC

Data Analyst/Tableau Developer

Responsibilities:

• Created action filters, parameters, calculated sets for preparing dashboards, worksheets and designed data visualization of the large data volume from various sources by joining and blending data (Oracle Server, SQL Server, Excel, etc.)
• Responsible for creating all reports such as matrix report, drill down report, drill through report, sub report and chart report etc.
• Identify, analyze, and interpret data tends or patterns in complex data sets and analyze results by using statistical techniques and provide ongoing reports.
• Capable in developing Custom Reports and different types of Tabular Reports, Matrix Reports, Drill through and Drill down reports, parameterized reports, Linked reports, Sub reports, Chart reports and distributed reports in multiple formats.
• Work with systems and projects teams to automate, maintain and improve/update existing reports and processes.
• Partner with colleagues across the organization to develop analytics algorithms that will demonstrate patterns and actionable insights from large data, and calculations.
• As a Tableau SME, responsible for the design, development and production support of interactive data visualizations used across the company.
• Involved in reviewing business requirements and analyzing data sources form Excel/ SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Developed storytelling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on - demand needed information.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Involved in gathering client requirement and developed Tableau reports based on user defined ad hoc user Interface for end users.
• Involved in developing Tableau Dashboards using both relational and Multidimensional data.

Confidential

Tableau Developer

Responsibilities:

• Data blending implemented on databases and generated interactive dashboards with Tableau 10.0.
• Create ad hoc reports to users in Tableau by connecting various data sources.
• Handle Tableau admin activities granting access, managing extracts and Installations.
• Manage dashboard permissions within a complex matrixed organizational structure.
• Maintenance and scheduling of Tableau Data Extracts using Tableau server and the Tableau Command Utility.
• Tableau administrative duties: adding users, groups, data connections, scheduling tasks, embedding views, etc.
• Developing complex calculated fields for the business logic, field actions, sets, and parameters to include filtering capabilities for the dashboards, and to provide drill down features for the detailed reports.
• Generate Dashboards with Quick filters, Parameters and sets to handle views more efficiently with Tableau 10.0.
• Publish Workbooks by creating user filters so that only appropriate teams can view it.
• Embedded Tableau views into SharePoint and analyzed the source data and handle efficiently by modifying the data types.
• Use excel sheet, flat files, CSV files to generated Tableau ad hoc reports.
• Generated Tableau dashboards for sales with forecast and reference lines with Tableau 10.0
• Generated Tableau dashboards with combination charts for clear understanding.

Confidential

SQL Server BI/SSIS/SSRS ETL Developer

Responsibilities

• Created SSIS packages to validate, extract, transform and load data to a centralized SQL server using OLEDB providers from the existing diversified data sources.
• Implemented Error Handling by using the Script component to generate custom error messages and redirected the error rows to an error file.
• Worked with users and business analysts to design and develop tabular, matrix, gauges, Charts, drill down interactive reports.
• Created automatically running stored procedures for day-end / Month-end operation using SQL Server agent.
• Designed data structure with multiple facts and dimension tables to hold the source data to be used for building new reports with SSRS.
• Designed and developed data warehouse, data marts and business intelligence using snowflake schema.
• Worked with Business analyst, Data architect and business users to understand business processes, document project requirements and translate them into functional and non-functional specifications for BI reports and applications.
• Formulated and documented the physical ETL process design based on business requirements and system specifications, including source to target mappings, transformations, lookups, aggregations and expressions.
• Designed packages using data conversion, sorting, scripting, lookup, merge joins, and derived columns with multiple data flow tasks.
• Experienced in Developing and Extending SSAS Cubes, Dimensions and data source views SSAS-Data Mining Models and Deploying and Processing SSAS objects.
• Expertise in creating SQL objects such as Tables, Complex Stored Procedures, Effective Functions, Views, Indexes, Triggers, Rules and SQL Performance Tuning to facilitate efficient data manipulation and consistency.

Confidential

Business Development Analyst

Responsibilities

• Managed end-to-end process for updating and verifying special orders data.
• Analyzed inventory usage reports to avoid back ordering and 20% reduction in delivery delays from an initial 10% per month.
• Direct weekly cross-functional team meetings as part of the forecast, inventory, and sales and marketing operations continuous improvement process.
• Created and documented workflows of new processes and procedures for warehouse and stores.
• Conducted detailed industry analyses, research, and draft reports.
• Developed and applied quantitative and qualitative analytic methods to identify, collect, process, and analyze data sets.
• Headed Confidential analytics team for business planning and development.
• Completed an in-depth analysis using Excel for business-optimization projects, reporting tools, marketing projections, customer retention, and employee/customer analysis. Measurable outcomes.
• Built a comprehensive complaints analysis dashboard identifying new insights on customer complaints resulting in 88.6% customer retention and complaint reduction by 11% monthly.