TECHNICAL SKILLS

Data Warehousing and BI: SQL Server Business Intelligence (SSIS, SSRS, SSAS).

Certifications: Microsoft Certified Professional for Programming in HTML5 with JavaScript and CSS3SAS UTD Certification, Six Sigma Lean Professional (Yellow Belt)

Software Tools: MSBI - SSRS, SSIS & SSAS, TFS, Visual Studio, CA Erwin, JIRA, ITSM, R Studio, Microsoft Dynamics CRM 2011/2013, Google Analytics, Google Big Query, Google Data Studio, Google AdWords, Microsoft Office, Agile Software Development Methodology.

Analysis/Reporting Tools: Tableau, Qlikview, Business Objects, Nvivo, Microsoft Excel

Programming: C#, Python, T-SQL, JAVA, ASP.NET, ADO.NET, C, C++, HTML5, CSS3, JavaScript, XML, MVC, SAS

Statistical Methods: Regression Analysis, Hypothesis Testing, ANOVA, Decision Trees, Random Forests

Databases: MS SQL Server, Oracle

PROFESSIONAL EXPERIENCE

Confidential, St Louis

Business intelligence Developer

Responsibilities:

• As the Business Intelligence Developer for Confidential, I have helped the station understand its radio, digital (website, mobile, app, streaming and podcast) audience and donor base with my work on data collection, ETL, data analysis, data visualization and web analytics, under the supervision of the Director of Marketing & Digital Media.
• Developed more than 30 key interactive and automated data visualization reports by collecting data from various sources like Google Analytics, Google AdWords, Facebook, twitter etc. and performing data cleansing and using effective data visualization techniques. These reports give insights into our performance and allow leadership to make informed decisions.
• Developed recurring Quarterly, Monthly, Weekly reports to various departments for them to keep track of key metrics useful to them and so that they can make informed decisions.
• Participated in all phases for building a Data Warehouse for analysis, requirement gathering, Design and Development of code.
• Created data models in ER and Dimensional Modeling.
• Developed ETL packages using SSIS which involves applications of various transformations.
• Ensure the ETL code delivered is running, conforms to specifications and design guidelines and analyse the data in the source to look for data quality problems and write code to fix data quality issues
• Unit testing the ETL code to ensure it can be delivered and run in a system testing environment
• Monitor Scheduled ETL Jobs & reports and resolve issues if any
• Created and deployed SSIS packages using various transformations such as Slowly Changing Dimension, Slowly Growing Target, and Simple Pass through Multicast, Merge Join, Lookup, Fuzzy Lookup, Conditional Split, Aggregate, Derived Column, and Data Conversion Transformations.
• Developed stored procedures and functions in SQL Server
• Experienced in working with various Python IDE’s using PyCharm, Jupiter Notebook.
• Experience with NumPy, Matplotlib, Beautiful Soup, Data Frame and Pandas python libraries during development lifecycle.
• Designed, developed, tested, and maintained Tableau functional reports based on user requirements.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameters using Tableau.
• Involved in creating database objects like tables, views, procedures, triggers, functions using Oracle SQL to provide definition, structure and to maintain data efficiently.
• Extensively involved in creating graphs by using measures and dimensions data from various databases by using data blending concept.
• Created different KPI using calculated key figures and parameters.
• Developed Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart.
• Developed donut charts and implemented complex features in charts like creating bar charts in tooltip.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics and table calculations.
• Utilized Tableau server to publish and share the reports with the business users.
• Responsible for creating calculated fields, combine field, bins, sets, geo coding and hierarchies using Tableau Desktop.
• Involved in creating a dual-axis bar chart with multiple measures.
• Implemented data blending to blend related data from different data sources.
• Received an ‘Exceeds Expectations’ rating in the performance appraisal from the employer for FY2018 which is based on several measures such as Accountability, Collaboration, Time Management, Judgement, Customer Focus, Communication, and Diversity & Inclusion.

Confidential

Business Data Warehousing

Responsibilities:

• Identified the key entities required for the business process.
• Created the relationships between entities using cardinalities.
• Implemented the ER logical model using the tool ERWin.
• Implemented the physical database structure in SQL Server through ERWin.
• Identified the grains for the fact tables and conformed dimensions to connect different star Schemas.
• Created an enterprise data warehouse bus architecture.
• Implemented the dimensional model in ERWin.
• Created the corresponding physical database structure in SQL Server through ERWin.
• Result: Created ER & Dimensional Model and generated Web Intelligence reports for the online marketplace company.
• Created a universe in Universe Design Tool and Informational Design tool of SAP Business Objects using source tables from SQL server database.
• Identified key objects as per users reporting requirements.
• Result: Generated reports using key objects on customer details, employee information, time specific revenue calculation.
• Performed data imputation for filling the missing values in dataset to improve data quality.
• Identified the importance of attributes through importance graph in Rattle.
• Data preprocessing and transformation performed on data.
• Using Random forest and neural networks to find better accurate model.
• Predicted passenger survival probability on Titanic dataset on Rattle with 89% accuracy.

Data Visualization

Confidential

Responsibilities:

• Analyzed the Car Retail Dataset to reveal various relationships between entities in the dataset.
• Used Graphical charts such as pie chart, Scatter plot, Gantt Chart, Bubble Chart, Histogram to determine various answers to questions like Which car manufacturer has the greatest number of car models, which manufacturers have, on average, more powerful engines in their four-wheel drive small SUVs than their two-wheel drive small SUVs etc.
• Created a calculated field to find which car model has the greatest difference between its highway fuel economy and its city fuel economy.
• Objective: To Measure and rank countries level of social and economic Development based on Human Development Index.
• Analyzed different dimensions and their effects on HDI using Tableau.
• Using scatter plot to analyze 3 dimensions in a single graph and comparing their affects by size and location of bubbles, helped reveal which factor was more influential in improving HDI.
• Analyze the dataset to find out which of the variables from set of attributes affect the HDI of different countries. Based on the factors affecting we can suggest some opportunities to improve the HDI of the countries.
• Created the Basketball League app to analyze the data from the CSV's and identify the key performance indicators as well as do a drill down analysis on each of Players, Teams and Coaches.
• Used Different Graphical representations in Qlikview such as scatterplot, funnel chart, bar chart and other dashboard tools to visualize the KPI of the data and to find out what were the key factors for a team performing better than others, key statistics to evaluate performance of each player etc.

Confidential

BI Developer

Responsibilities:

• As a BI Developer, I have worked with business users to understand business processes, document project requirements and translate them into functional and non-functional specifications for BI reports and applications.
• Involved in design of the templates of SSIS packages to approach the business requirement.
• Formulated and documented the physical ETL process design based on business requirements and system specifications with strong ETL design skills, including source to target mappings, transformations, lookups, aggregations, expressions.
• Maintained the database schema and all project in Team foundation server (TFS) source code control.
• Performed Extraction, Transformation and Loading (ETL) of data flows using SSIS with complex integration of SQL Server tables, oracle, flat files, excel files, comma separated files (.CSV) sources, and MS access files.
• Expert in writing T-SQL, working with DTS (Data transformation services) data cleansing, data scrubbing and data migration.
• Created packages in SSIS with error handling as well as created complex SSIS packages using various data transformations like conditional split, Cache, for each loop, multi cast, Derived column, Data conversions, Merge, OLEDB Command, script task components.
• Created SSIS Packages to load all dimensions and Fact tables.
• Created/updated Stored Procedure, Triggers, User Defined Functions, User defined data type, Scripts and batches.
• Hands on experience in writing SSIS script/script component task using C#, VB script for customized data manipulation of complex SSIS packages.
• Worked on the Reports module of the project as a developer on MS SQL Server 2008 (using SSRS, T-SQL, scripts, stored procedures and views).
• Created reports from OLAP, sub reports, bar charts and matrix reports using SSRS.
• Created report snapshots to improve the performance of SSRS.
• Created reports in SSRS with different type of properties like chart controls, filters, Interactive Sorting, SQL parameters etc.
• Developed Multi-Dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).
• Designed Cubes with Star Schema using SQL Server Analysis Services 2008 (SSAS).
• Created several Dashboards and Scorecards with Key Performance Indicators (KPI) in SQL Server 2008 Analysis Services (SSAS).

Confidential

Jr. BI Developer

Responsibilities:

• Responsible for creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints Views, Stored Procedures & Triggers.
• Tested to optimize the Stored Procedures and Triggers to be used in production.
• Actively involved in Normalization & De-normalization of database.
• Was involved in performance tuning of the Database.
• Created SSIS packages to retrieve data from Legacy sources and to retrieve user data from the Flat files on monthly and weekly basis.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Created Drill-through, Drill-down, Cross-Tab Reports and Sub-Reports.
• Designed SSAS cubes for all the developed DataMart models and identify measures with proper aggregate functions applied.
• Utilizing a variety of SQL based tools, BI tools, and Reporting tools to inform business decisions and actions.
• Generated variety of business reports using MS SQL Server 2008/2012 SSRS including matrix report, parameter report, dashboard with charts and drill down function.
• Create innovative executive dashboards, scorecards, and weekly/monthly reports on the status of key business performance indicators (KPI) using tableau.
• Attending group meeting twice a week to discuss problems occur during someone’s work, trying to improve my technical skills by analyzing data, simplifying SQL codes, and improve the performances of the projects.
• Worked on performance tuning on existing stored procedures and existing reports for the faster processing of reports.
• Performed unit and system testing, troubleshooting and bug fixing in development and QA environments.
• Involved in performing database Backup and Recovery.