SUMMARY:

To work in an environment that provides the opportunity for me to apply my knowledge of data capture, management, analysis, research and policy making in solving problems in the field of academia, research organizations and corporate bodies as well as sampling techniques and lecturing.

TECHNICAL SKILLS:

Statistical Package: Stata, R, SPSS, Basic SAS, Basic GenSTAT

BI Software/ Programming languages: Tableau, XML, SSAS, SSIS

Database: MS SQL server, Oracle, MySQL, MS Access

Application: CSPRO, LaTeX, Matlab, Microsoft Packages

Operating Systems: MVS, z/OS, UNIX, windows

PROFESSIONAL EXPERIENCE:

Tableau Developer

Confidential, Washington DC

• Work with end users, business and IT users to understand, elicit and analyze reporting requirements.
• Cleaning data and performing data quality control checks.
• Develop reports, dashboards using Tableau 10.x for quick reviews to be presented to Business and IT users.
• Developed POCs by building reports and dashboards using Tableau to perform statistical analysis of large data.
• Prototyped data visualizations using Charts, drill - down, parameterized controls using Tableau to highlight the value of analytics in Executive decision support control.
• Developed Ad-hoc reports using Tableau Desktop
• Developed visualizations using sets, Parameters, Calculated Fields, Dynamic sorting, Filtering, Parameter
• Publish dashboards unto Tableau Servers
• Manage the application’s users, groups, and integration with Active Directory
• Knowledge of Tableau Licensing
• Familiar with tableau migration and scheduling.
• Experience in taking back ups and restoration of Tableau repository
• Automate monitoring & server job processes
• Familiar with Installation, configuration, patching and upgrading of Tableau tool across the environments

Tableau Developer

Confidential,Beaverton, OR

• Work with end users, business and IT users to understand, elicit and analyze reporting requirements.
• Cleaning data and performing data quality control checks.
• Gather data from different data sources like MySQL, Oracle, Hadoop and SQL Server.
• Develop reports, dashboards using Tableau 9.x, 10.x for quick reviews to be presented to Business and IT users.
• Exploratory Research to guide predictive modelling
• Migrating reports from other visualization tools to Tableau
• Developed POCs by building reports and dashboards using Tableau to perform statistical analysis of large data.
• Prototyped data visualizations using Charts, drill-down, parameterized controls using Tableau to highlight the value of analytics in Executive decision support control.
• Developed Ad-hoc reports using Tableau Desktop, Excel.
• Developed visualizations using sets, Parameters, Calculated Fields, Dynamic sorting, Filtering, Parameter driven analysis.
• Creating critical field reporting tools for Business customer segments
• R for descriptive statistics and visualization to help detect hidden patterns in data, especially complicated data containing complex and non-linear interactions.

Tableau Developer

Confidential,Cambridge,MA

• Work with end users, business and IT users to understand, elicit and analyze reporting requirements.
• Cleaning data and performing data quality control checks.
• Gather data from different data sources like MySQL, Oracle, Hadoop and SQL Server.
• Develop reports, dashboards using Tableau 8.3, 9.x for quick reviews to be presented to Business and IT users.
• Developed POCs by building reports and dashboards using Tableau to perform statistical analysis of large data.
• Prototyped data visualizations using Charts, drill-down, parameterized controls using Tableau to highlight the value of analytics in Executive decision support control.
• Developed Ad-hoc reports using Tableau Desktop, Excel.
• Developed visualizations using sets, Parameters, Calculated Fields, Dynamic sorting, Filtering, Parameter driven analysis.
• Helped in using SQL Server Reporting Services (SSRS) and SQL Server Management Studio 2008 -SSIS, SSAS, and SQL Profiler, including Crystal Reports to run scripts and maintain stored procedure and code functions across company's Databases.
• Performed schema changes in the database per request and met with clientele and with various subgroups for requirement gathering in order to allow self-extracted reports and created critical field reporting tools for Enterprise Data Management customer segments
• Using Netezza to handle very large queries from multiple users and generates query execution plans.
• R to illustrate the process of data integration and exploration, and building of predictive models to find previously unknown patterns and trend
• R for descriptive statistics and visualization can help understand a data set, especially a large one, and detect hidden patterns in data, especially complicated data containing complex and non-linear interactions.

Data Analyst/ Tableau Developer

Confidential,New York

• Involved in design and architecture of the entire project flow and integration with third party tools. Interfaced with Business in understanding the present functionality of Planner Reports and defining the phases in which the development would be done.
• Cleaning data and performing data quality control checks
• Creates technical specifications, test plans and test data to support ETL processes
• Involved in package migration from DTS to SSIS, running upgrade advisor against DTS packages before migration, scheduling jobs for DTS packages.
• Expert in cleansing data for data consistency whether the data source is a single system or multiple disparate sources
• Expert in Merge Join transformation, which can take two different inputs and merge them together by comparing a set of key columns, which performs different types of joins.
• Expert in SQL joins, sub queries, tracing and performance tuning for better running of DTS packages.
• Used SSIS Packages for extracting, cleaning, transforming and loading data into data warehouse.
• Experience in development of extracting, transforming and loading (ETL), maintain and support the enterprise data warehouse system and corresponding marts
• Created sophisticated SQL Server database to responsively handle complex queries (triggers, stored procedures, views, functions)
• R to illustrate the process of data integration and exploration, and building of predictive models to find previously unknown patterns and trend
• Pulling data from Oracle, Hadoop and SQL Server into Tableau for visualization
• Develop reports, dashboards using Tableau 8 for quick reviews to be presented to Business and IT users.

Research Analyst

Confidential

• Assures the integrity of project data including data extraction, storage, manipulation, processing, and analysis in CRM, and other database programs.
• Cleaning data and performing data quality control checks
• Collects and collates appropriate data for usage in databases and conducting related research.
• Discusses business intelligence needs or information processing needs with business process owners, business line management and leadership personnel.
• Responsible for administration, database design, security, and maintenance of assigned tasks and projects.
• Codes accurate variables form original information or data and completes statistical analyses as required.
• Monitors and maintains the quality of database systems.
• Analyzes data with standard statistical methods, interprets the results, and provides written summaries of data analyses.
• Shares the knowledge of analysis techniques and data coding with other staff.
• Documents development and support processes.
• Participates in ongoing discussions and decisions concerning data collections, study design, methodology, and data analysis.
• Analyzes for accuracy and reasonableness the outputs and extracts from various switching systems, computer servers, and other data processing equipment that are used to support billing processes.
• Extensive use of PROC SQL to perform queries, join tables
• SAS to tap into the relationships, indexes, and other settings supplied by database and have the resulting dataset returned in SAS format.
• Developed POCs by building reports and dashboards using Tableau to perform statistical analysis of large data.
• Prototyped data visualizations using Charts, drill-down, parameterized controls using Tableau to highlight the value of analytics in managerial decision support control.