PROFILE

• A Microsoft Certified Professional with a career spanning over 7 years as a Business Intelligence analyst, Solutions Technology developer with Strong technical and analytic skills.
• In my career, I've specialized in database design efficient ETL architecture and have built reporting solutions automated business processes across a variety of Domains including Oil and gas, HealthCare, Insurance, Banking sector and Telecom industries.
• Proficient in database development building custom reporting solutions and dashboards with a variety of tools: complex T-SQL queries, stored procedures, and functions, SQL Server Integration Services SSIS , SQL Server Reporting Services SSRS , multidimensional and tabular OLAP cubes in SQL Server Analysis Services, Visual Studio Team Foundation Server, Excel PowerPivot/Power View or VBA, Power BI SharePoint, Tableau, Business Objects, and ASP.NET.

Technical SKILL SET

• Languages: T-SQL, Pl/SQL, MDX, C , C , Asp .Net , VBScript,Activex.Xml, Html, DHtml, Http, Shell Scripting.
• Relational Databases: SQL server 2014, SQL server DENALI 2012 , 2008R2, 2008, 2005, Oracle 10g/9i/8i, MS-Access 2008/2005/2000, DB2, Sybase ASE 15.0,Teradata, Visual Source Safe 2005.
• DWH/BI Tools: SQL server integration services SSIS , Informatica 6.x/7.x/8,SQL server reporting services SSRS , SQL server analysis services SSAS , BIDS, Visual Studio, DTS, Tableau, Crystal reports 9/10/xi, Pro clarity server, SSMS,SQL Server Profiler, Import Export Wizard, Excel Power Pivot/Power View, MS Visio, Erwin 4.5/4.0,
• Packages: Microsoft Office 365 Suite, Microsoft Office Share Point Server MOSS 2007, Microsoft Performance Point Server 2007.

eXPERIENCE SUMMARY

Senior BI/SQL Developer SQL/SSIS/SSAS/SSRS

Roles and Responsibilities:

• Dynamically supported business users for given requirements and developed ETL Reports accordingly.
• Developed various T-SQL stored procedures, functions, views, and adding/changing tables for data extraction, data load and transformations.
• Created various database objects such as tables, indexes and views based on the requirements.
• Created ETL packages with different data sources SQL Server, Flat Files, Excel source files, XML files etc. and loaded data into destination tables by performing different kinds of transformations using SSIS/DTS packages.
• Developed SSIS packages with monitoring features and custom logging, loading audit information and execution results into audit tables.
• Created database maintenance planner jobs for performance of SQL Server, which covers Database integrity checks and re-indexing.
• Generated various reports with drilldowns, calculated members, dropdowns from the cubes by connecting to analysis server from SSRS 2005/2008 .
• Created data sources, connection strings and defined datasets for Report generations.
• Designed and written the queries in the query builder for retrieving the data.
• Created and worked with drill down reports and identified the report parameters.
• Used various report items like tables, sub report and charts to develop the reports in SSRS.
• Deployed and generated reports on to the server using the Reporting Services Report Manager.
• Worked with various Delivery mechanisms of Reports including Email /PDF/Schedules etc.
• Extensively involved in SSAS storage and partitions, and aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Refreshing the cube to get the latest information updated and deployment of Cubes to the production server.
• Created subscriptions to provide a daily basis reports and Managed and troubleshoot report server related issues.
• Migrated Crystal reports to SSRS reports.

Confidential

SQL BI Developer/Analyst

Roles and Responsibilities:

• Worked for Loan-Processing, Claims and Reporting systems involving in working on Claims Reporting research solutions and Appeals Processes.
• Worked with end-users to analyze, understand, and gather requirements for BI Solutions.
• Involved in designing of the data bases and altering schemas of the existing data bases.
• Created new schema objects like stored procedure, Functions, Views and did the performance tuning on the existing Objects.
• Created the Dynamic ETL's to Load different Source systems like Excel, Flat file, and Oracle data bases using SSIS 2012.
• Involved in writing C scripts for Custom script component tasks in SSIS.
• Created Type2 historical tables for the Data warehouse and created SSIS Packages to Load them.
• Implemented Error logging, log tables and Event handlers for the existing packages.
• Worked with installation, configuration and deployment of SQL Server Reporting Services SSRS , developed various enterprise reports, drill thru reports, drill down reports and multi-Valued parameter reports.
• Created Tablix, Chart and ad-hoc reports using SSRS 2012, and deployed them to share point services.
• Tuned SQL queries and Stored procedures to improve the performance of the existing reports.
• Created Report Subscriptions, Report models and Snapshot reports as per the User's requirement.
• Used TFS 2010 to check in SQL scripts, reports and Integration packages. Involved in documenting the entire technical process.
• Supported technical teams and users involved with MS SQL issues and operations.
• Worked with Change Control Deployment teams in code reviews and deployment.

Environment:

MS SQL Server 2008R2/2012, SSIS SSIS 2008R2/2012 ,SSRS SSRS/2008/2012 , BIDS, MS Excel 2003/2007,SSDT 2012,Team Foundation Server TFS 2010 , VBScript, ProClarity Server, Asp .Net, C .

Confidential

MS SQL/BI Developer

Roles and Responsibilities:

• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• Involved in performance tuning using indexing Clustered Index, Non Clustered Index tables.
• Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse.
• Involved in creating complex Stored Procedures, SSIS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Designed ETL packages dealing with different data sources SQL Server, Flat Files, and XMLs etc. and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services SSIS .
• Proficient in usage of SSIS Control Flow items For Loop, Execute package/SQL tasks, Script task, send mail task and SSIS Data Flow items Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping, Pivot .
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Experience in Designing, Building the Dimensions, cubes with star schema using SQL Server Analysis Services SSAS for analyzing purpose.
• Experience in creating Jobs, Alerts, SQL Server Mail Agent, and schedule using DTS/SSIS Packages.
• Created calculated measures and dimension members using multi-dimensional expression MDX .
• Created DSV, Cubes, and Dimensions, DMX/MDX for SSAS Reports.
• Interacting with the users and troubleshooting the problems involved with the development of stored Procedures, triggers and problems related to the privileges.
• Created Views to reduce database complexities for the end users.
• Migrated and resolved conversion errors for Performance Point Server reports to SharePoint 2010 Business Intelligence platform.
• Worked with Business Analysts, Developers and customers to resolve and escalate project issues.
• Worked closely with the team in meeting the deadlines pertaining to design and development deliverables.

Environment:

Windows2003 Advanced Server, ASP.Net, MS SQL Server 2005/2008/2012, TSQL, Visual Studio 2008,Oracle, SSRS, SSIS, Erwin.

Confidential

SQL Server Developer

Roles and Responsibilities:

• Interacted with Team in Analysis, Design and Develop database using ER Diagram, Involved in Design, Development and testing of the system.
• Developed SQL Server Stored Procedures, Tuned SQL Queries using Indexes .
• Created Views to facilitate easy user interface implementation and Triggers on them to facilitate consistent data entry into the database.
• Implemented Exceptional Handling.
• Worked on client requirement and wrote Complex SQL Queries to generate Crystal Reports.
• Rebuilding Indexes and Tables as part of Performance Tuning Exercise.
• Worked on Documentation using MS word.

Environment:

Windows 2000 Server, SQL Server 2005, DTS, Query Analyzer, Enterprise Manager, SQL Profiler.