SUMMARY:

• Having 8 plus Years of IT experience in Microsoft Database Technologies with various Industry like IT-Hardware/Networking, IT-Software, Insurance, Mining and Manufacturing as a SQL Server BI Developer in MS SQL SERVER 2012/2008/2005 Databases in Windows environment
• Over 7 years of rich experience in information technology as SQL BI developer involving in all phases of SDLC, using Agile and Waterfall methodologies.
• Extensive knowledge in T-SQL queries DDL and DML .
• Extensively worked on Business Intelligence technologies like SSIS, SSRS, and SSAS of MS SQL server 2005/2008/2012.
• Good understanding in Normalization and Relational Database Management Systems.
• Experienced in creating Tables, Views, Indexes and other SQL joins and query writing.
• Good understanding in database and data warehousing concepts OLTP OLAP . Experience with logical and physical data modeling and database design using Erwin.
• Transformed data from various data sources using OLE DB / MS AS connection by creating various DTS packages.
• Created Reports with complex formulas and to query the database for Business Intelligence.
• Experience in ETL implementation using SSIS for loading the data from Various Data sources to using Variables, Parameters and Configurations to Other destinations
• Extensively used various SSIS Objects such as Dataflow Components, Control Flow Elements tools like Import Export Wizard, BCP for developing the Packages.
• Experience in Data Warehouse Modeling with SQL Server Analysis Service SSAS
• Extensively used Report Wizard, Report Builder and Report Manager for developing reports and deploying reports in SSRS
• Proficient in creating different types of reports such as drill down, sub reports, parameterized reports, interactive reports, ad-hoc reports, custom reports and formatting them using SSRS.
• Involved in creating stored procedures, triggers, functions, Indexes, tables, views and other T-SQL code and SQL joins for applications by maintaining best standards to perform efficiently.
• Expertise in Analyzing and Optimizing the slow-running queries, cost-based queries using SET operations, Query plans, Statistics and Indexes
• Involved up gradation and migration from MS SQL Server 2005 to MS SQL Server 2008.
• Expertise in migrating data from MS-Access, MS-EXCEL and other external data sources
• Storing all the database objects and respective scripts in Collaborated Platform using Visual Studio Team Foundation Server TFS .
• Excellent communication skills, analytical skills, understand business requirements in various domains, self-learning ability and leadership quality.

TECHNICAL EXPERIENCE:

PROFESSIONAL EXPERIENCE:

Confidential

Sr. SQL BI/Tableau Developer

Responsibilities:

• Involved in daily Scrum meetings and managing the user stories in providing an efficient work plan.
• Developed complex T-SQL queries using joins, stored procedures, used defined functions to verify the data from the database to generate reports based on the business requirement
• Implemented T-SQL scripts, triggers, procedures, packages.
• Involved in performance tuning and monitoring of T-SQL blocks.
• Developed Dynamic packages using SSIS and Implemented Incremental Data Loading
• Performed data mapping and transferred data from staging tables to database tables using SSIS transformations.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Created SSIS packages to pull data from SQL Server and exported to Excel Spreadsheets and vice versa.
• Tested queries to optimize the procedures and triggers to be used in production.
• Involved in designing ETL as a part of Data warehousing and loaded data in to Fact tables using SSIS
• Worked on Tableau Dashboards in Tableau 8.1. Demonstrated knowledge in dealing with various functionalities like context filters, global filters, guided navigation, customization, conditional formatting of reports to satisfy the end users.
• Developed dashboards, reports as per the requirements with appropriate guided navigation.
• Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization.
• Extensively worked on creating calculated fields and Analysis depending on the user requirements.
• Extensively used advanced filtering capabilities for creating Dashboards.
• Extensively worked with SQL Server and Oracle databases for running different queries.
• Find ways 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.
• Actively participated in clarification meeting with the Clients.
• Responsible to facilitate load testing and benchmarking the developed product with the set performance standards.
• Involved in testing the database using complex SQL scripts and handled the performance issues effectively.
• Involved in Onsite Offshore coordination to ensure the completeness of Deliverables.

Environment: Tableau, SQL Server 2012/2008/R2, SSRS, SQL, PL/SQL, SQL Developer Oracle, MS Project.

Confidential

Sr. SQL BI/Tableau Developer

Responsibilities:

• Involved in reviewing business requirements and analyzing data sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Created Heat Map showing current service subscribers by color that were broken into regions allowing business user to understand where we have most users vs. least users.
• Created dashboard using parameters, sets, groups and calculations.
• Created drill down and drill up in worksheets.
• Involved in creating a dual-axis bar chart with multiple measures.
• Created report schedules on Tableau server.
• Projected and forecasted future growth in terms of number of subscribers based on upgrading to LTE by developing Area Maps to show details on which states were connected the most.
• Converted charts into Crosstabs for further underlying data analysis in MS Excel.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel.
• Blended data from multiple databases into one report by selecting primary key's from each database for data validation.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• Created OLAP cubes on top of the data warehouse basing various fact and dimension tables for analysis purposes using SQL Server Analysis Services SSAS 2008.
• Designed and reviewed the new report standards in order to ensure optimized performance under the new reporting service SSRS 2008.
• Involved in setting up and implementation of the 2008 reporting server.
• Created complex reports using SSRS 2008 from the OLAP cubes for end user analysis.
• Migrated reports from MS SQL Server Reporting Services 2005 to 2008.
• Created/modified a variety of parameterized, drill down, click through, chart, matrix, sub reports using SSRS 2008 using data from a variety of sources.
• Ran and tested required queries and reports before publishing.
• Published the reports and scheduled the reports in different formats Email, Public, folder
• Scheduled the reports on capacity levels of different servers to run on daily/weekly monthly basis and email the results to the business users in the required format.
• Created a number of complex formulas to find the capacity levels of different servers.
• Scheduled tasks to run every day to update changes in the base tables.
• Added/modified Users, Groups, folders and rights.

Tools Technologies: MS SQL Server 2005/2008/R2/2012, SSAS 2008, SSMS, Tableau Reporting tool admin/developer, Crystal reports XI, T-SQL, Oracle 10g, Access and Excel.

Confidential

MS SQL Server / SSIS / SSRS Developer

Responsibilities:

• Deploy SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups using SSIS tasks.
• Imported data from text files and excel spread sheets into SQL Server 2008 database using SSIS package.
• Designed data models using Erwin. Developed physical data models and created DDL scripts to create database schema and database objects
• Worked with T-SQL to create Tables, Views, and triggers and stored Procedures
• Used Script task for Data Flow and Error Handling in SSIS.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Created/Updated database objects like tables, views, stored procedures, function, packages,
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Generated Drill down, Drill through, Ad-hoc, Matrix Reports, parameterized reports using SSRS.
• Designed and developed monthly, quarterly and yearly reports.
• Involved in table and index partitioning for performance and Manageability.
• Identified, tested, and resolved database performance issues monitoring and tuning to ensure database optimization.
• Monitored the overall performance of the database to recommend and initiate actions to improve/optimize Performance.
• Used SQL Server Profiler to trace the slow running queries and the server activity.
• Automated and enhanced daily administrative tasks including database backup and recovery.
• Involved in setting up SQL Server Agent Jobs for periodic Backups with backup devices, database maintenance plans and recovery.

Tools Technologies: Microsoft SQL Server 2008, T-SQL, SSIS, SSRS, SSAS, Erwin, Windows server 2008, Visual Source Safe, SQL Profiler, Visual Studio 2008, Oracle 10g, C .

Confidential

SQL Server Developer/ SSIS/ SSAS Developer

Responsibilities:

• Gathered data and documented it for further reference and designed Database using Erwin data modeler.
• Planned, Defined, and Designed data based on business requirement and provided documentation.
• Created SSIS package to load data from Flat Files and SQL Server 2005 to SQL Server 2008 a using Lookup, Fuzzy Lookup, Derived Columns, Conditional Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
• Developed Unit Test Plans for SSIS packages for checking the functionality of each component.
• Modified the existing SSIS packages to meet the changes specified by the users.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis using SQL Server Agent.
• Involved in creating alerts for successful or unsuccessful completion of scheduled jobs.
• Worked in setup logging environment to track the status of the events like error raise, task fail.
• Generated parameterized reports, sub reports, tabular reports using SSRS 2008.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008.
• Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and Parameterized reports using SSRS 2008
• Created reports to retrieve data using Stored Procedures that accept parameters.
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard
• Responsible for Monitoring and Tuning Report performance.
• Created various database object like stored procedures, functions, tables, views
• Configured the report viewing security for various users at various levels using Report Manager.
• Scheduled report and exported in PDF format.
• Fine-tuned SQL Queries for maximum efficiency and performance using SQL Profiler and Database Engine Tuning Advisor.
• Provided documentation for all kinds of reports and SSIS packages.
• Designed and implemented Stored Procedures and Triggers for automating tasks.

Tools Technologies: MS SQL Server 2008/2005, SSRS, T-SQL, SSIS, Win 2003 Advanced Server, Erwin v7.3

Confidential

MS SQL BI Developer

Responsibilities:

• Extracted data using SSIS packages ETL from different server locations and data sources.
• Created packages to validate, extract, transform and load data to a centralized SQL server using OLEDB providers from the existing diversified data sources. .
• Worked with integration services for transferring and reviewing data from heterogeneous sources like Excel, CSV, flat file, Text Format Data.
• Designed high level SSIS architecture for overall data transfer from the source server to the Enterprise Services Warehouse.
• Analyzed designed the business rules for data cleansing that are required by the staging OLAP and OLTP databases.
• Implemented the Data Cleansing using various transformations such as Lookup, Fuzzy Lookup and Derived Column.
• Involved in maintaining batch log tables and error logging tables to handle errors using event handlers.
• Migrated packages from development server to production server using package configuration.
• Created Parameterized, Linked, Snapshot, Cached, Ad hoc, Click through, Drill down, Drill through, Sub reports using SSRS.
• Designed and implemented Parameterized and Cascading Parameterized reports using SSRS.
• Deployed generated reports onto the Report Server to access it through browser.
• Created various geographical and time dimension reports of fiscal year, quarter, month, week and daily reports for all domains and published through Report Server.
• Designed and developed various reports by comparing the growth of company based on each quarter by using bar charts.
• Responsible for generating annual reports based on the growth of company with respect to customers.
• Created calculated measures and dimension members using multi-dimensional expression MDX , mathematical formulas, and user-defined functions.
• Used Visual Source safe for repository and maintaining versions.
• Worked as a developer in creating Complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Improved Performance of the database by creating Clustered and non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
• Conducted user training sections and supported the requests for enhancements, modifications and new reports.

Tools Technologies: MS SQL Server 2005 Analysis Services SSAS , Reporting Services SSRS , Integration Services SSIS , Microsoft Performance Point Server 2007, Microsoft Share Point Server, T-SQL, NET, C MS Access and Excel.