SUMMARY

• Over 2 years of IT experience in Software Design, Development, Integration, Implementation and Maintenance of Business Intelligence and the related Database Platforms.
• Worked in all phases of BW/BI full life cycles including analysis, design, development, testing, deployment, post - production support/maintenance, documentation and end-user training.
• Strong understanding of project life cycle, SDLC methodologies of Waterfall and Agile.
• Over 1 Years of experience working on Tableau (Desktop, Server).
• Good understanding of Data ware housing, Data modeling (Dimensional & Relational) on concepts like Star-schema, Snowflake schema using fact and dimension tables and relational databases.
• Strong hands on experience implementing dash boarding, data visualizations, and analytics using Tableau desktop and Server.
• Provided Production support to Tableau users and Wrote Custom SQL to support business requirements. Proficient with MS SQL Server, SSIS, SSRS, SSAS.
• Experience in Data Extraction and Transforming and Loading (ETL) using SSIS packages to manage SQL Server databases and SQL Server objects between instances of SQLServer.
• Extensive experience in Tableau and SSRS for creating Dashboards, stories and published.
• Expertise in generating reports using SQL Server Reporting Services (SSRS) and MS Excel spreadsheets.
• Programming in SQL Server - Using the stored procedures, Triggers, User-defined functions and Views, etc.
• Strong SQL Server DDL, DML skills with understanding of writing efficient queries and troubleshooting complex queries.
• Experience in tuning the performance of stored procedures, database activities like maintenance and performance monitoring and tuning using SQL Profiler and other troubleshooting and monitoring tools.
• Expertise in Enterprise Reporting includes generating reports using linked reports, sub reports and filters, charts in SQL server reporting services (SSRS).
• Experience in developing management reports using SSRS (SQL Server Reporting Services)
• Good understanding of technical trends, architectures and highly motivated to know more about latest technology, new software and products.
• Team player with good communication and interpersonal skills.
• Experience in Query Optimization,Database Consistency Checks using DBCC Utilities and analyzing the execution plan and index management for better Query Optimization.
• Written Complex Stored procedures as well as analyzing and debugging existing complex stored procedures, suggested creating Clustered and Non-Clustered indexes on tables.
• Exquisite skills in Creating and scheduling jobs, alerts and operators with SQL Server Agent, handling native Backup/Recovery of databases, Database Maintenance Planning.
• Excellent backend skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, Rules, Defaults, user defined data types and functions
• Deployed and Debugged SSIS packages for import, export and bulk insert data with transformations from various data sources

TECHNICAL SKILLS

Programming Languages: T-SQL, PL/SQL, R Script, Python, Javascript .

RDBMS/Databases: MS SQL Server, MY SQL, PostGreSQL, MONGO DB

BI Tools: SQL Server Reporting Services (SSRS), SQL Server Integrating Services (SSIS), SQL Server Analytical Services (SSAS),Visual Studio, BIDS,Tableau 9x/10.0

Version controll system: GIT

Issue track system: JIRA

SDLC: Agile, Scrum

PROFESSIONAL EXPERIENCE

Confidential

Jr. SQL Server Developer

Responsibilities:

• Created ER diagrams to the proposed data base.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Worked on development of data ware houses.
• Implemented the Error handling in the Stored Procedures and also Modified existing stored procedures according to the requirement.
• Created data base objects such as tables, views, stored procedures, triggered etc.
• Designed SSIS packages, extracted data from OLTP to OLAP.Creation of SSIS packages to load into data marts.
• Identified and included report parameters.
• Good knowledge on OLTP databases.
• Worked on drill-down, drill-through, parameterized, chart, gauges, data driven reports using SSRS and successfully deployed on report manager.
• Strong in writing calculated fields, publishing customized interactive reports and dashboards using Tableau server.
• Created bar charts, scatter plots, pie charts & parameters as per the desired functionality.
• Developed Tableau data visualization using Pareto's, Combo charts, Heat maps, Box and Whisker Charts, Scatter Plots, Geographic Map, Cross tabs, Histograms etc.
• Generated Tableau dashboards for sales with forecast and reference lines.
• Performed various tasks like creating cubes, task processing and update using SSAS.
• Used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Developed monthly reports using SSRS to generate drill down, drill through reports.
• Performed data extraction from various data sources (SQL server) and Data loading into target sources using SSIS.
• Created reports using SQL Reporting Services (SSRS) for Customized and Ad-hoc Queries.
• Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.
• Performed database and BI (ETL, OLTP, OLAP, and Reporting) services for various applications.
• Design, deployment, and maintenance of various SSRS Reports in SQL Server.
• Queried against Heterogeneous Data Sources to retrieve records for data loads using SSRS.
• Created Triggers to enforce data and Referential Integrity.
• Worked on SSRS to generate drill-down, drill-through, parameterized and ad-hoc reports.

Environment: SSMS, SSIS, SSRS, SSAS, MS SQL SERVER 2008 R2, Windows Server .

Confidential

SQL software development Summer Intern

Responsibilities:

• Created ER diagrams to the proposed data base.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Worked on development of data ware houses.
• Implemented the Error handling in the Stored Procedures and also Modified existing stored procedures according to the requirement.
• Created data base objects such as tables, views, stored procedures, triggered etc.
• Designed SSIS packages, extracted data from OLTP to OLAP.
• Performed various tasks like creating cubes, task processing and update using SSAS.
• Used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Developed monthly reports using SSRS to generate drill down, drill through reports.
• Performed data extraction from various data sources (SQL server) and Data loading into target sources using SSIS.
• Created reports using SQL Reporting Services (SSRS) for Customized and Ad-hoc Queries.
• Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.
• Performed database and BI (ETL, OLTP, OLAP, and Reporting) services for various applications.
• Design, deployment, and maintenance of variousSSRSReports in SQL Server.
• Queried against Heterogeneous Data Sources to retrieve records for data loads using SSRS.
• Created Triggers to enforce data and Referential Integrity.
• Worked on SSRS to generate drill-down, drill-through, parameterized and ad-hoc reports.

Environment: SSMS, MS SQL SERVER 2008 R2, Windows Server .