SUMMARY

• Over 7 years of professional experience in client requirement Analysis, Physical and Logical design, Resource Planning, Coding, Debugging, Testing, Deployment, Support and Maintenance of business applications using SQL Server 2008/2005/2000/7.0, DTS, SSIS,SSRS and SSAS.
• Expert in Data Extraction, Transformation and Loading (ETL) using SQL Server Integration Services SSIS/DTS.
• Experience in developing different types of Tabular Reports, Matrix Reports, Drill - Down, Cross Tab Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS) using SSRS.
• Proficient in Tableau data visualization tool to analyze and obtain insights into large datasets,create visually compelling and actionable interactive reports and dashboards.
• Highly Proficient in Agile, Test Driven, Iterative, Scrum and Waterfall software development life cycle.
• Extensive experience on building Analytic Dashboards using Tableau.
• Mastered the ability to design and deploy rich Graphic visualizations using Tableau.
• Involved inTrouble Shooting, Performance tuning SQL Serverand resolving issues withinTableau ServerandReports.
• Good knowledge of Big Data.
• Experience in Data Conversion and Data Migration from earlier versions to current SQL server using SSIS and DTS services across different databases like Oracle, MS access and flat files.
• Experienced with SQL Server and T-SQL in constructing triggers, tables, views, stored procedures, user defined functions, indexes, user profiles and relational database models with data integrity.
• Experienced in working with different data sources like OLE-DB, flat files and Excel to source data in SSIS and proficient in creating SSIS packages from scratch and deploying them.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule ETL Packages.
• Experience in PL/SQL and SQL and in performance tuning SQL queries in TOAD.
• Excellent verbal and written communication skills combined with strong interpersonal and conflict resolution skills and possess strong analytical skills.

TECHNICAL SKILLS

Databases & Related Technologies: SQL Server 2008/2005, Oracle 11g/10g/, MS Access, DB2 MS excel 2010, MS Share point

Operating Systems: Windows 8/7/XP/2003

ETL/BI Tools: SSIS (SQL server integration services), DTS

Modeling Tools: MS-Visio

Reporting Tools: SQL Server Reporting Services

Languages: T-SQL, SQL, PL/SQL, C, C++, JAVA, VB, MS ACCES

Office Tools: Microsoft Office / and XP

PROFESSIONAL EXPERIENCE

Confidential, San Francisco, CA

Tableau Developer

Responsibilities:

• Experience with the design and development ofTableauvisualization solutions.
• Worked in developing strategy and technical specifications for implementing reporting portal/semantic layer in conjunction with data layer.
• Involved in creating dashboards and reports inTableau6.1. Created report schedules onTableau server.
• Installed and upgradeTableauserverformTableau6.0 toTableau6.1and experienced in server performance tuning for optimization.
• Administered user, user groups, and scheduled instances for reports inTableau.
• Extracting data from different sources connecting them and used the same to create dashboard
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets forTableauserver logons and security checks.
• PreparingDashboardsusing calculations, parameters, calculatedfields,groups, sets and hierarchies in Tableau.
• Creating data blending in case of merging two different datasets.
• The ability to interact professionally with a diverse group including executives, managers.
• Excellentanalytical, problem solving and debugging skills, with strong ability to quickly learn and comprehend business processes and problems in order to effectively develop technical solutions to their requirement.
• Excellent experience and expertise in creatingTableauWorkbook's, Publishing workbooks and Dashboard.
• Findefficientways to make graphs and tables visually exciting, and aesthetically pleasing, while at the same time maintaining the accuracy of the core information content that is being communicated.
• Develop, organize, manage and maintain graph, table, slide and document templates that will allow for efficient creation of reports.
• Proof-read all documents and maintain accuracy of information and preparingSOP.
• Responsible for Developing aDashboardand preparingad-Hock Reporting.
• Working knowledge onTableau Server / Administration.

Environment: Tableau Desktop 6.02,7.0,8.0 Tableauserver / Administrator, Oracle 10g, Microsoft Excel 2007,MS Access, Microsoft office 2007.

Confidential, Bismarck, ND

SQL /BI developer

Responsibilities:

• Analyzed available data from MS Excel, MS Access, SQL server 2000/2005.
• Designed new database on SQL server 2008R2.
• Normalized the data, created different tables, views, indexes, triggers and efficient stored procedures and Functions.
• Checked Performance Tuning of the Database by optimizing the queries with modification in T-SQL queries. Normalized tables, established joins and created indexes wherever necessary.
• Building query execution plans and making sure each and every query is using appropriate indexes.
• Involved in backup and recovery strategies.
• Designed new SSIS packages to extract data from various sources, transformed it based on Business needs and loaded it to OLAP servers for further analysis.
• Exported and imported data from text files and Excel to SQL Server database using bulk insert.
• Worked on developing Reports and managing reporting services.
• Developed Reports in SSRS to send the reports directly to the respective E-mails using Subscriptions.
• Used Tableau to design Reports and Interactive Dashboards.
• Built complex formulas in Tableau for various business calculations.
• Created and assisted users in Tableau dashboard development.

Environment: SQL Server 2000/2005/2008 R2 Enterprise Edition,.NET, T-SQL, MS Access,MSBI, MS Excel, & Windows 2003 server, TFS, Business Intelligence technologies like SSIS,SSRS, VSTS2008,BIDS, Tableau.

Confidential, Columbus, OH

SQL /BI developer

Responsibilities:

• Created Complex Reports like Cascaded Reports, Drill Through, Tabular Reports, Matrix Reports, Drill-down, and Cross Tab Reports IN SSRS.
• Developed Report Models, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Designed and developed various Service management reports, utilizing cascading Prompts, sub-reports, charts, Formulas, parameterized rep and dynamic reports using SSRS.
• Effectively Used Report Manger and Report Builder in SSRS.
• Used the SSIS to migrate Databases such as Oracle and Access database, flat file, SQL Server 2000 to SQL server 2005.
• Efficiently Migrated packages from DTS to SSIS.
• Responsible for Developing, Monitoring and Deploying SSIS packages.
• Implemented Batch Logging, Error Logging for the SSIS packages.
• Used C # and VB in SSIS to design customized tasks.
• Developed Cubes and done Dimensional Modeling in SSAS.
• Efficiently implemented OLAP/MOLAP with the effective MDX scripting.
• Efficiently designed KPI’s, Partitioning in the Cube development.
• Developed multiple reports from SSAS.
• Developed cubes using SSAS with effective Dimensions and Facts.
• Managed and Supported Complex reports like Drill Through, Parameterized using SSRS 2005.
• Designed complex reports like Cascaded Reports.
• Effectively implemented changes in the .Net changes accordingly with the SQL Server migration and business enhancements.
• Created Crystal Reports using Visual Studio 2005.
• Effectively designed the Star schema and Snow Flake schema according to the Business requirements.
• Developed Complex Queries in T-SQL, Stored Procedures, and Views with best Execution plan.
• Experience in conducting Performance Tuning by using SQL Profiler, Data Engine Tuning Advisor, and Execution Plan.
• Responsible for Monitoring and making recommendations for performance improvement in hosted databases.
• Best in Index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and Update Statistics in databases.

Environment: MS SQL Server 2008, Erwin, SSIS, SSRS,MSBI, ProClarity, Visual Studio, MOSS 2007

Confidential, Gainesville, FL

SQL / BI Developer

Responsibilities:

• Interaction with clients for Business Requirements during design & implementation phases.
• Migrated databases from SQL Server 2005 & various other sources into SQL Server 2008.
• Extensively used various SSIS Objects such as Dataflow Components, Control Flow Elements, Connections Managers, & import/export wizard while developing packages.
• Design, develop & test the ETL processes according to industries best practices using SSIS.
• All data were migrated to the staging server and then that data were later populated to the OLAP (Online Analytical Processing) Server.
• Involved in implementing different types of reports & schedule them for reporting purposes using SSRS.
• Generating on-demand, ad-hoc, custom reports for business analysis or management decision using SQL Server Reporting Services (SSRS).
• Involved in writing T-SQL, stored procedures, views, triggers, used indexes, constraints & business rules wherever applicable.
• Used SQL profiler for performance tuning & debugging issue whenever necessary.

Environment: SQL Server 2000/2005/2008 R2 Enterprise Edition,.NET, Visual Studio, SQL, T-SQL, MS Access, MSBI, MS Excel, & Windows 2003 server, Business Intelligent technologies like SSIS,SSRS.

Confidential

SQL Server Developer

Responsibilities:

• Oversaw installations, upgrades of SQL 2008, SQL 2005 to SQL 2008.
• Involved in Database design, creation and maintenance of Databases.
• Managing the use of disk space, memory & connections by monitoring.
• Created tables and views.
• Created functions, stored procedures, triggers and constraints using T-SQL.
• Monitoring & tuning SQL scripts by performance monitoring. Creating upgrade scripts for production Database and supporting it.
• Server & Application fine-tuning & trouble shooting.
• Wrote maintenance plans and code optimization. Worked on database designing, logical and physical data modeling, worked on large scale data migration using SQL Scripts, stored procedures, triggers, views, etc.
• Monitoring MS SQL Server performance and network issues.
• Performance monitoring and tuning of SQL servers.

Environment: MS SQL Server 2008/2005, Windows XP Server, MS Access.

Confidential 

MSSQL DEVELOPER

Responsibilities:

• Carried out a Developer’s role on MS SQL Server 2005, MS Access Databases (using DTS, Stored Procedures and Views.
• Involved in developing the SQL code for the application.
• Solved various T-SQL issues using Query Analyzer.
• Created and managed schema objects such as Tables, Views, Indexes, Procedures and Triggers.
• Created ad hoc T-SQL Queries.
• Used BCP utilities, Data Transformation Services (DTS), Extract Transform Loading tool (SSIS) to populate data from various data sources, created packages for different data loading operations for application.
• Created configuration Tables, Stored Procedure, User Defined Function in SQL Server Management Studio to support the whole SSIS process workflow.
• Designed, Developed and Deployed reports in MSSQL Serverenvironment using SSRS.
• Involved in designing and implementing the Stored Procedures and Triggers for automating tasks.
• Worked on MS SQL Server tasks such as Data Loading, Batch Jobs, BCP, DTS and Indexes.
• Analyzed the Reports, Tables and ETL process.
• Created and automated regular Jobs such as Daily/Weekly Report Generations.
• Used SQL Server profiler for auditing and analyzing the events which occurred during a particular time horizon.
• Managed and Monitored System Utilization. Managed Backup and Disaster Recovery of the systems. Managed the security of the servers as a part of administration duties.

Environment: T-SQL, MS SQL Server 2005, SSRS, SSIS, XML, Windows 2000/2003/NT/XP, MS-Excel.