PROFESSIONAL SUMMARY:

• 8 years of strong experience in the IT industry as Sr.Business Intelligence Developer in Banking, Insurance, Health Care Domains.
• Excellent experience in MS SQL Server 2005/2008/2012 with Business Intelligence in MS SQL
• Server Reporting Services (SSRS), MS SQL Server Integration Services (SSIS) and MS SQL Server Analysis Services (SSAS).
• Involved in Software Development Life Cycle (SDLC) processes including Analysis, Design, Development, Testing and Implementation.
• Creation of metrics, attributes, filters, reports, and dashboards. Created advanced chart types, visualizations and complex calculations to manipulate the data. Act as a Point of Contact in Data Interoperability, Analytics and BI and Production Support issue resolution.
• Proficiency in integrating, migrating, converting and cleansing data using SQL Server Integration Services (SSIS).
• Experience in RBMS Concepts, Database Management Systems, and Database Physical and Logical design & Data Modeling.
• Expert in creating packages, Jobs, sending alert mails, scheduling and running packages, designing, compiling and testing.
• Around 4 years of Experience in Tableau and extensive knowledge on Qlikview Dashboards in latest Design and Presentation.
• Proficiency in deploying and enhancing SSIS Packages from development to production server and creating Databases based on Functional Requirements and System Design.
• Expertise in merging data from heterogeneous data sources like Excel, MS Access,
• Oracle, and DB2 to MS SQL Server by using import export wizard, DTS, SSIS, and bulk insert utilities.
• Designed and created SQL database, tables, indexes, and views based on user requirements.
• Performance Monitor for Monitoring and Tuning MS SQL Server Performance. Worked on Policy Management.
• Expert in Data Extraction, Transformation and Loading (ETL) between Homogenous and Heterogeneous Systems using SSIS of MS SQL Server 2000/ MS SQL Server 2005 and MS SQL Server 2008 respectively.
• Proficiency in Error and Event Handling: Check Points, Logging in SSIS.
• Hands on experience in Database Installation, Configuration, Maintenance, Monitoring, Backup and Disaster Recovery procedure and Replication.
• Create reports in Power BI preview portal utilizing the SSAS Tabular.
• Created Power BI Dashboards with interactive views, trends and drill downs along with user level security.
• Knowledgeable in various new features of SQL Server 2012 like Big Data Support, Column Store Indexes, compression based backup methodology etc. Related to SQL Server 2008 .
• Experienced in creating Drill Through, Drill Down,Tabular, Matrix reports, Adhoc & created charts, graphs using SQL Server 2014/2012/2008/2005 Reporting Services (SSRS).
• Strong Expertise in Database Design, development of SQL Scripts, Stored Procedures, Functions, Packages, Triggers using Oracle PL/SQL, T - SQL, Tera data SQL, DB2 SQL PL, etc
• Involved in DBA activities such as Backups, Restores, Log-shipping, partitioning the tables, Mirroring and Replication and in resolving performance issues.
• Excellent communication and inter-personal skills with ability to develop creative solutions for challenging client needs using agile methodologies.
• Involved in development of AutoSys JILs.
• Extensive experience on UNIX Shell Scripting.
• Good Understanding of Actimize architecture, AIS Components and Risk Case Manager Functionalities.
• Develop new AIS models, RCM development including Dashboards,, gathering business requirements and data .

TECHNICAL SKILLS:

Operating Systems: MS-DOS, Windows XP/ 2000/2003/2007 Server, UNIX, Linux

Programming Languages: T-SQL, PL/SQL, Dynamic SQL, MDX, C, Visual Basic 6.0, VB Script, C#, VB .NET, ASP .NET, ADO.NET, XML, Angular JS, HTML 5, DHTML, CSS 3, Shell Scripting

RDBMS/Databases: MSSQL Server 2000/2005/2008/2008 R2/2012 MS Access 97/2000/2003, Sybase Server, Teradata V2R5, Big Data, IBM DB2 UDB 8.2/8.0,SQL * Plus, Visual Source Safe 2005

Tools/Database Utilities: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Visual Studio .Net, Microsoft Management Console, Business Intelligence Development Studio (BIDS),Power BI, Toad, IIS 6.0/7.0,Business Objects, Crystal Reports 9.0

Web Services, XML, SOAP, WSDL, UDDI, Clear Case, Clear Quest

BI Tools: SQL Server Reporting Services (SSRS), SQL Server Integrating Services (SSIS), SQL Server Analytical Services (SSAS), Yellowfin, Data Transformation Services (DTS), Visual Studio, BIDS, Cosmos, Tableau 8.0/8.2/ 8.3/ 9.0

Application Packages: : MS Office, Microsoft SharePoint Server (MOSS) 2007, Microsoft Performance Point Server 2007

Methodologies: Agile, Scrum, Waterfall ACTIMIZE,RCM,AIS Modeler

WORK EXPERIENCE:

Confidential, Charlotte, NC

Sr. Microsoft Business Intelligence Developer/ Sr. SQL Analyst/Actimize developer

Responsibilities:

• Created new database objects like stored procedures, Functions, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2014
• Migrated DTS packages from SQL Server 2012 to SQL Server 2014 as SSIS Packages.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
• Created efficient, robust SSIS packages for data movement and loading with error checking and well documented code.
• Created SSIS Packages to integrate data coming from Text files and Excel files.
• Migrated old data from MS Access into SQL Server 2012 using SSIS Packages in Business Intelligence Development Studio.
• Deployed 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.
• Data management and data processing solutions using SSIS, this includes Error Handling and Slowly Changing Dimensions.
• Wrote many stored procedures for cleaning, manipulating and processing data between the databases.
• Scheduled the Packages in SQL Server Agent on daily/weekly/monthly basis.
• Document new SSIS packages and Train Senior Analyst on basic SSIS concepts.
• Created SSAS tabular semantic model in Direct Query mode with multiple partitions, KPI's, hierarchies and calculated measures using DAX as per business requirements.
• Understanding the OLAP processing for changing and maintaining the Data Warehouse, Optimizing Dimensions and adding new Aggregations to the Cube.
• Working with Calculations, Key Performance Indicators and Aggregations on SSAS Cubes.
• Responsible for creating and changing the visualizations in Power BI reports and Dashboards on client requests
• Responsible for building reports in Power BI from the Scratch.
• Worked with Application Developers to design DB Schema and tables to support
• Created stored procedures to build the Fact tables in the data mart for Multi-Dimensional analysis using (SSAS) and produced ad-hoc, standard and super user reports using SSRS.
• Used TFS as the source control repository. Checked-in/checked out all the report projects from TFS.
• Performance tuning for efficient report generation
• Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Extensive experience on UNIX Shell Scripting.

Environment: SQL Server 2012/2014, Windows 2007, SQL 2012,SSIS, SSAS, SSRS, Visual studio 2013, Team Foundation Server, Crystal Reports 2008, Microsoft Excel 2012, Microsoft office 2013,RCM, ACTIMIZE,AIS MODELER

Sr. Microsoft Business Intelligence/ Sr. Data Analyst/Actimize developer

Responsibilities:

• Build the SSIS packages to load the Data into Staging, ODS and dimensional model.
• Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system to SQL server.
• Creating promotion request plan documents, ETL standards templates to resolve issues for SSIS jobs.
• Formulated and documented ETL process design based on business requirements and system specifications with strong ETL design skills, including source to target mappings, transformations, lookups, aggregations and expressions.
• Analyzed source data to determine the data model and ETL solution that will meet business requirements.
• Created packages in SSIS with error handling as well as created complex SSIS packages using various transformations and tasks like Sequence Containers, Script, For loop and For Each Loop Container, Execute SQL, Execute Package, Send Mail, File System, Conditional Split, Data Conversion, Derived Column, Lookup, Merge, Merge Join, Row Count, Sort, Union All, flat file source and destination, OLE DB source and destination, excel source and destination etc.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, Data mart databases.
• Designed Complex SSIS packages interfacing SQL with Oracle 10g.
• Developed ETL process using SSIS to transfer data from heterogeneous data sources.
• Generated and Deployed ETL SSIS packages both design and code to process data to target databases. .
• Designed and developed SSIS packages using various control flow and data flow items to transform and load the data from various databases and into server integrations services (SSIS) Build customized SSIS Packages using c# script tasks and component.
• Create packages in SSIS with error handling as well as created complex SSIS package using various data transformations like conditional split, lookup, for each container, Multi cast, data conversion, script components.
• Writing T-SQL statements for retrieval of data and Involved in performance tuning of TSQL
• Tuned the SQL queries using SQL profiler and involved in tuning the database
• Configured package with checkpoints, package logging, error handling and event handling to redirect error rows and fix the error in SSIS
• Worked on managing ETL process by pulling large volume of data from OLTP to a staging Database Using SSIS for Data transformation.
• Design, review and implement production SQL Server database objects, models and DB schema.
• Creating new Documentation, DB Schema designing, creating new ERD's using Visio.
• Used Team Foundation Server and Visual Source Safe as a version control tool.
• Decent understanding of Yellow-fin reporting suite.
• Developed Tableau visualizations and dashboards using Tableau Desktop.
• Wrote extensive SQL (multi-table join queries and sub-queries)for backend testing.
• Experience in creation of Tabular model in SSAS for creating Power pivots, Power View reports and Dashboards.
• Created different Power Pivot reports as per the client requirement.
• Extensively involved in the SSAS storage and partitions, and aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Involved in creating Cubes using SQL Analysis Services (SSAS).
• Good Understanding of Actimize architecture, AIS Components and Risk Case Manager Functionalities.
• Responsible for the design and development in the Market Trading Surveillance, develop new custom models, integrate and support standard models.
• Develop new AIS models, RCM development including Dashboards,, gathering business requirements and data . Environment: SQL Server 2012, T-SQL, Oracle 10g,Windows 7 and Linux, SSIS,SSAS, Yellowfin,Visual Studio 2012,MS-Excel, SQL Server 2014, TFS, Tera data, SharePoint, Microsoft office 2013, SQL-PLUS, C++, Visual Basic,ACTIMIZE,AIS MODELLER,RCM

SQL Server Developer/ Microsoft Business Intelligence Developer

Responsibilities:

• Involved in the Requirement Analysis, Design phase and Development phase of SDLC model system.
• Worked closely with Business Analysts to produce all required documentation.
• Create packages in SSIS with error handling as well as created complex SSIS package using various data transformations like conditional split, lookup, for each container, Multi cast, data conversion, script components.
• Worked with Product Development Team to architect Database Design and strategy.
• Worked with Business Users to architect Data Warehouse strategy based on reporting, analytical and dishoarding requirements
• Developed and maintained ETL (Extract, Transformation and Loading) mappings to extract the data from Oracle, SQL server, DB2 and Flat files and loaded into Oracle.
• Developed database objects such as Stored Procedures, Functions, Tables, Triggers and Indexes using T-SQL and SQL Analyzer.
• Created, insert, update and delete triggers on some tables in order to capture any DML activities happening on some crucial and confidential data.
• Experienced on creating multiple kind of Report in Power BI and present it using Story Points.
• Migrate existing data into the Power BI.
• Creating the OLAP cubes using various dimensions and creating SQL Server Analysis Projects using SSAS 2008. Adept in defining referenced relationships and calculated members in SSAS, creating OLAP structures from OLTP database.
• Developed SSIS package to Export and Import data from SQL Server to Access, Text and EXCEL files and Configured SQL mail agent for sending automatic mails.
• Involved in deploying, configuring and managing reports using Report Manager and Report Builder.
• Working on MS SQL Server 2008 R2 (Fast track Data Warehouse) Oracle10g, in Windows Server 2008 and Linux ( redhat) environments.
• Increased query performance, necessary for statistical reporting by more than 25% after performance monitoring, tuning, and optimizing indexes using Performance Monitor, Profiler, and Index Tuning Wizard.
• Migrated data from various sources into SQL Server 2008 using SQL Server Integration Services 2008.
• Created OLAP models based on Dimension and Facts for efficient loads of data based on Star Schema structure.
• Developed SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Used AngularJS as framework to create a Single Page Application (SPA), which can bind data to specific views and synchronize data with server.
• Implemented & managed database clustering, failover and load balance technologies as per client requirement.
• Developed, tested & implemented a robust database backup and recovery strategy with client assistance.
• Worked on the Reports module of the project as a developer on MS SQL Server 2008 (using SSRS, T-SQL, scripts, stored procedures and views)
• Reviewed and fine-tuned stored procedures and triggers before production migration.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis.
• Developed entity-relationship diagram and data dictionary for project coordination; created SQL create, alter, and insert scripts.

Tools: &Technologies : MS SQL Server 2012/2008R2, SSAS, SSIS, SSRS,T-SQL, Oracle 10g,C#, .NET, Visual Basic 6.0, ASP, Performance Point, Data Analyzer, Visual Studio 2010, VB Script, MS Access, Excel, SQL Profiler, Windows 2007.

SQL/SSRS/SSIS/SSAS Developer

Responsibilities:

• Closely worked with end-users to analyse, understand, and gather report requirements.
• Extensively involved in ETL Processes development, support and
• Involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs
• Wrote T- SQL code/Stored procedures to create datasets for SSRS reports.
• Created Views to store aggregated values for reporting purpose.
• Designed a report using the appropriate data regions and data items.
• Configuration and Deployment of all the Reports(RDL,RDS) across various SDLC environments
• Used various types of report layout options like charts (bars, lines, pie etc...), images, graphs, sub reports, hyperlinks etc to make them more attractive and understandable.
• Created OLAP cubes and dimensions for the analysis of sales in different locations using SSAS.
• Analyzed and test data in the cube using SSAS.
• Identified and included report parameters.
• Developed Webi reporting and modifications to existing reports .
• Developed webi reporting for customer data surveys
• Formatted the reports using Global variables and expressions
• Deployed reports on the company’s remote report server.
• Worked with various Delivery mechanisms of Reports including Email /PDF/Schedules etc
• Created subscriptions to provide a daily basis reports.
• Scheduled the reports to refresh and run on daily, weekly and monthly basis in the report manager
• Managed and troubleshoot report server related issues. Involved in extensive data validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.
• Migrated some Crystal reports to SSRS reports
• Involved in developing/Deploying SSIS packages using BIDS for Data loads required for Reports.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities

Environment: SQL Server 2008R2/2005, T-SQL, Windows XP/2003, Visual Studio 2008/2005, Oracle, Report Builder 2.0, SQL Profiler, Erwin, SQL Server Integration services, SQL Server Reporting services, SQL Server Analysis Services, Visio, Share-Point, Microsoft-Office 2003/2007, MS-Excel 2003/2007