OBJECTIVE

• To work for a leading and aspiring organization in a highly motivating and competitive environment that provides great opportunities to grow and use my potential to the fullest to achieve the organization goals as well as my goals.

SUMMARY

• Over 8 years of strong experience in the IT industry as a MS SQL Server 2014/2012/2008 R2/2008/2005 Developer/BI Development, Client Analysis, Database Design, and Presentation using SQL Server 2014/2012/2008 R 2/2008/2005.
• Good knowledge of Normalization/De - normalization, data design methodology and building Referential Integrity.
• Expert knowledge of all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Designing using Angular JS, JQuery, HTML 5, CSS.
• Experienced in T-SQL (DDL, DML), documenting, coding, programming, modifying and Implementing Business Intelligence
• Experienced in designing prominent level ETL architecture, creating, configuring and fine tuning workflows designed in DTS for data transfer from the OLTP to OLAP with the help of SSIS.
• Experience in SQL Server Analysis Services (SSAS) OLAP Cubes, and Mining, Implemented Snow Flakes Schema and Star Schema.
• Experience in Importing/Exporting Data from various Heterogeneous source like MS Access, Excel, Oracle, DB2, and Flat file using SSIS.
• Highly proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Tables, User Defined Functions, Relational DB models and Data integrity, and SQL joins.
• Creation and maintenance of Databases, creating Roles and managing user permissions, resolving deadlocks.
• Experienced in transforming complex business logic into Database design and maintaining it by using SQL tools such as Stored Procedures, User Defined Functions, Views, and Transformation services.
• Experienced in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SQL tools like SSRS, SSIS, Data Transformation Services (DTS), Bulk Insert, BCP, and XML.
• Experienced in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, Defining Data Source and subtotals for the reports using SSRS 2014/2 R2/2005.
• Expert in developing Drill through/Drill down reports, Cross-Tab, Cascading parameterized reports using MS SQL Server Reporting Services (SSRS) and deploying onto Dashboards, SharePoint server, web applications and web servers.
• Experienced in generating On-demand and Scheduled reports for Business Analysis or Management decisions using MS SQL Server Reporting Services 2005/2008/2012/2014.
• Monitored and Tuned MS SQL Server databases with tools like Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for optimal Performance.
• Expertise in creating Cell Level Security in cubes using SSAS.
• Specialized in Data Loss prevention and mediation of SQL Injections.
• General knowledge of security technical implementation guidelines regarding security of databases.
• Involved in all phases of software development life cycle: design, implementation and testing.
• Hands on experience in production/staging/test/development database administrative, Installation, Configuration, Maintenance, Monitoring, Backup and Disaster Recovery procedure and Replication.
• In-depth knowledge of working and implementation of Crystal Reports, converting Crystal reports to SSRS Reports and in upgrading crystal reports 8.5/9.0/10 to XI.
• Strong understanding of project life cycle and SDLC methodologies including Waterfall and Agile.
• Tuning SQL query for better performance using SQL Profiler and Normalization and De-Normalization of existing tables for faster query retrieval.

TECHNICAL SKILLS

Languages: Java, Html, CSS, .Net, C, C++, RDBMS, HTML5, CSS3, JavaScript, Restful services, D3.js, PIG, Hive, Map Reducing.

Scripting Languages and Platforms: Sql, SSRS, SSIS, SSAS, IoT platform (AWS, IBM Bluemix, and Azure IoT),R scripting, Cloud Computing, VB script, Python, OLTP, and OLAP.

Tools: Eclipse, Oracle Databases, Sql Server, Oracle server, Visual Studio, Tableau, MSBI, Intel XDK, LDAP server Manager, Raspberry OS, MicroStrategy, and powerBI.

PROFESSIONAL EXPERIENCE

MSBI developer/Power BI

Confidential, Columbus, OH

Responsibilities:

• Played an active role during the requirements gathering, analyzing and designing of the system
• Created reports using SQL Reporting Service (SSRS) for Customized and Ad-hoc Quires
• Converted Data Transformation Services (DTS) applications to SQL Server Integrated Services (SSIS)
• Created Packages in SSIS with Error handling
• Created SSIS Packages to pull data from SQL Server to Excel Spreadsheets and vice versa
• Performance Tuning in SQL Server 2014 using SQL Profiler and Data Loading.
• Loading data from various sources like OLEDB, Flat files to SQL Server database using SSIS packages and created data mapping to load the data from source to destination.
• Performed reverse engineering for complex data systems, for further development on automated and reusable solutions.
• Designed BI applications, solutions, and reports following IDT's standards of development lifecycle, testing and validation, and security.
• Hosted knowledge transfer session for relational database design and BI architectures with best practice.
• We used Power BI for data modelling, data exploration, designed cubes and deployed on cloud and given it to client.
• Assisted in Production support to help with users access and verification.
• Successfully migrated data between different heterogeneous sources such as flat files, Excel and SQL Server 2008 using SSIS, BCP and Bulk insert
• Extensively used SSIS Import/Export Wizard for performing the ETL operations
• Used Various ETL tools like SSIS/DTS for data flow from source files like XML, Tables and Views to other databases or files with proper mapping
• Enhancing and deploying the SSIS Packages from development server to production server
• Extensively used SSIS transformations such as Lookup, Derived Column, Data Conversion, Aggregate, Conditional Split, SQL task, Script task and Send Mail task
• Designed, Developed and Deployed Reports in MS SQL environment using SSRS-2008
• Created Parameterized Reports and Linked Reports with thorough knowledge of report serving architecture (Table, Chart and Matrix Report)
• Involved in creating multiple parameterized stored procedures which were used by the reports to get the data.
• Developed Reports for business end users using Report Builder with updating status
• Developed different kind of reports such as Sub Reports, Charts, Matrix Reports, Linked Reports
• Develop reports using complex formulas and to query the database to generate different types of ad-hoc reports using SSRS
• Involved in writing heavy T-SQL stored procedures, complex joins.

Environment: MS SQL Server 2012/2014/2016 , SQL Server Integration Services (SSIS),Azure,SQL Profiler,Power BI, SQL Server Reporting Services (SSRS), MS Visual Studio, Windows 2008 Server, DTS, BIDS, MS,HTML5,CSS,Anuglar JS, Restful Services, Excel.

SQL BI Developer

Confidential, Nashville, Tennessee

Responsibilities:

• Understanding the Existing system.
• As a part of Migration installed and configured Microsoft SQL Server and related products.
• Worked on setting up the CBI environment in both Dev and QA servers.
• Installing and configuring the BIMS tool.
• Publish the report to CBI Portal using BIMS (Business intelligence management studio)
• Assist the customers for onboarding the reports on to the CBI portal and provide support.
• Performed unit testing and fixed the bugs raised during the testing phase.
• Created reports using SSRS based on the requirements.
• Developed complex queries to fetch the data related to the usage of the reports in CBI portal.

Environment: MS SQL Server 2005/2012, SSRS, Microsoft Access,Azure, Visual Studio,, Excel Power BI, Oracle 11g, Amazon Redshift, IBM DB2, Adobe Omniture, Python

Sql BI developer

Confidential

Responsibilities:

• Creating Worker area for customer.
• Preparing the decommission scripts for worker area and metadata.
• Installation, configuration and upgrading of Microsoft SQL Server software and related products.
• Attended business conference call with client team to understand the changes to the system.
• Created jobs for taking automatic backup of Databases.
• Worked on Restore database and recovery models and Database Shrinks.

Environment: MS SQL Server 2005/2012, SSRS 2016, SSAS Tabular 2012,Azure, Microsoft Team Foundation Server, Visual Studio, Performance point server, Excel, Power BI Desktop, Tivoli, Google Analytics, DAX Studio, Guidewire Claim Center, Guidewire Policy Center, R

Sql developer (internship)

Confidential

Responsibilities:

• Actively involved in Normalization of database.
• Designed DDL and DML for MS SQL Server 2000
• Create rules, defaults, tables, views, clustered & non-clustered index, user defined data types, and user defined functions.
• Optimize query performance by creating indexes.
• Involved in writing SQL batch scripts.
• Write T-SQL statements for retrieval of data and Involved in performance tuning of T-SQL
• Involved in merging existing databases and designed new data models to meet the requirements and perform daily database backup & restoration and monitor the performance of Database Server.
• Created joins and sub-queries for complex queries involving multiple tables.
• Use DDL and DML for writing triggers, stored procedures, and data manipulation.
• Install and Configured SQL Server 2000 on development server for designing and testing.

Environment: MS SQL Server7.0/ 2000, T-SQL, DTS, SQL Server Enterprise Manager,Azure,Power BI, SQL Profiler.