A grown up enthusiastic kid with dreams sky high
Created, maintained, modified, and optimized SQL Server databases, database security and auditing. Worked in SQL Server 2008 R2 and 2012 versions. Created scripts and SQL jobs to facilitate database backup and recovery, server and data processing monitoring and alerting
Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL. Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, and Analytical functions.
Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau 10. Developed Tableau workbooks from multiple data sources using DataBlending. Created storyboard to paint a broader picture. Hosted developed dashboards from Tableau Desktop to Tableau Server for the use of other stakeholders within the organization
Integrated Custom Visuals based on business requirements using Power BI desktop. Created reports and dashboards by connecting to different excels and csv's. Developed Power BI reports using query logic based on business rules, and visuals based on the end-user. Migrated existing self-service reports and adhoc reports to Power BI.
Extracted data from SQL server databases and Datawarehouses to represent data in reports in SSRS. Created Drill down, linked and sub reports in SSRS for various end users. Develop reports using complex formulas, expressions and to query the database to generate different types of ad-hoc reports using SSRS.
Developed the classes using C#, which incorporate N-tier architecture and database connectivity. Developed a complete event registration unit using C# form application that registers students for the events. Developed classes in Business Layer and in Data Access Layer in C#
Created vectors, matrices, data frames and functions. Implemented machine learning algorithms in R to predict dependent variables using independent variables. Used GGPLOT2 to visualize the outcomes. Used other packages like caTools, e1071 amd other various packages to predict the outcomes with regression techniques.
Have created complex queries, stored procedures, views and functions. Wrote complete business logic in the backend that involves populating data tables and audit tables using triggers and functions.
Experience in developing, monitoring, extracting and transforming data using DTS/SSIS, Import Export Wizard, and Bulk Insert. Excellent in High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert , Merge and union all.
Expert in creating Star schema cubes using SSAS. Extensively worked on OLAP cubes using SSAS. Created and Managed OLAP Cubes using SSAS. Involved in creating calculated members, named set, advanced KPI’S for the SSAS cubes. Designed Dimensional Modeling using SSAS packages for End-User. Created Hierarchies in Dimensional Modeling.
Created S3 buckets and stored files with IAM User Control lists. This entire profile site is hosted in AWS S3 bucket with domain name registered in Route 53. Created and maintainted EC2 instances within various available regions. Created EC2 instances within cloud across regions and implemented Load Balancers to control the traffic.
Created SQL Server Database in the Azure cloud and consumed it through applications locally.