SUMMARY

• Having 8+ years of IT Experience as a Business Intelligence Developer and Analyst in development of business applications, Database Design, Development and business intelligence in Banking, Finance and Healthcare domains.
• Strong Business Intelligence with the ability to understand the operational aspects of product line and manage projects from a business perspective and ability to conceptualize creative and innovative solutions for new product development.
• Experience in Database Development, Data Warehousing, Design and Technical Management.
• Worked closely with various external stakeholders to understand and document Business, Functional and Software requirements.
• Experience in creating views, complex stored procedures, effective triggers and useful functions to facilitate efficient data manipulation and consistent data storage.
• Strong analytical, and problem - solving skills with emphasis on clear, detailed business requirements and functional specifications, as well as reports for management.
• Created Reports with complex formulas and to query the database for Business Intelligence.
• Excellent knowledge in creating Databases, Tables, Stored Procedure, DDL/DML Triggers, Views using T-SQL.
• Skilled in implementing initial data loading by Bulk Insert Task, Fast Load, and Bulk Copy Program as well as incremental data loading by techniques such as Slowly Changing Dimensions and Change Data Capture.
• Developed and modified drill-down, drill-through, linked reports, subreport, charts, Formulas, parameterized reports, Navigation reports and dynamic reports using Tableau and Power BI.
• Profound understanding of Enterprise Data Warehouse including OLTP/OLAP, Dimension/Fact tables, Top-down/Bottom-up models, Star/Snowflake Schemas
• Experience in enhancing and deploying the SSIS Packages from a development server to production server.
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server.
• Expertise in migrating data from MS-Access, MS-EXCEL, SQL Server, Oracle and other external data sources.
• Experience in Functional, Regression andSystemIntegration testing using Manual and Automated testing tools.
• Experience in Executing Test Cases for Functional andSystemIntegrationtesting forInformation in Portal.
• Expert in interfacing with clients, business analysts, developers, QA, project managers and various cross-functional teams to execute projects successfully.
• Extensive knowledge of various reporting objects like attributes, hierarchies, transformations, filters, prompts calculated fields, sets, groups,and parameters.
• Strong advanced tableau developer skills such as nested calculation, table calculations, parameters, geographic mapping, data blending, and extract optimization
• Well versed in implementing Data blending, Replace references, customized queries and advanced visualizations in Tableau
• Outstanding analytical and problem-solving skills communicating effectively to accomplish all project deliverables in a fast-paced environment
• Very Good Understanding and Experience in SQL Server Integration Services(SSIS) and SQL Server Reporting Services(SSRS)
• Experience in Tuning SQL queries and T-SQL queries & improving the performance of the queries.
• Experience in using variables, expressions and functions and defining Query for generating drill down reports in SSRS.
• Experience in writing complex SQL queries involving multiple tables inner and outer joins, stored procedures.
• Experience in Power BI scripting working with DAX and building visualizations as per requirements from business users from time to time.
• Experience in developing Custom Report, Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Sound Experience and understanding of SSAS, OLAP and OLTPcube, Data mining,andArchitecture.

TECHNICAL SKILLS

RDBMS: MS SQL Server 2012/2008R2/2008/2005, MySQL, Oracle 11g/10g/9i, MS Access

ETL: Server Integration Service (SSIS), Data Transformation Services (DTS), SQL Server Data Tools (SSDT), Data Quality Services

Languages: T-SQL, PL/SQL, Python.

Development Platforms: Visual Studio 2015/2010/2008 , SharePoint 2013/2010

ETL Tools: Data Transformation Services (DTS) - Export/Import, SQL Server Integration Service (SSIS), Power BI, Talend.

Reporting Tools: SSRS, Crystal Reports, Business Objects,Excel 2016/2013/2007 , Tableau 7/8/9/10.

Development Platforms: Visual Studio 2015/2010/2008 , SharePoint 2013/2010

Project Management: JIRA, Team Track, Microsoft Project

SQL Server Tools: SQL Server Enterprise Manager, T-SQL, Data Transformation, Services (DTS), SQL Server Query Analyzer, Query Profiler, SQL Server Agent, SQL Jobs, SQL Alert, SQL Mail, SQL Server Management Studio, BIDS (Business Intelligence Development Studio), Visual studio (VS), SQL Server Integration Services (SSIS), SQL Server Reporting Services(SSRS), SQL Server Analysis Services (SSAS), SQL Server Profiler, Power BI.

PROFESSIONAL EXPERIENCE

Business Intelligence Developer/Analyst

Confidential, Dallas,Tx

Responsibilities:

• Developed and maintained ETL (Data Extraction, Transformation,and Loading) mappings using SSIS to extract the data from multiple source systems that comprise databases like Oracle 11g, SQL Server 7.2, flat files to the Staging area, EDW and then to the Data Marts.
• Designed and implemented stored procedures, views and other application database code objects to aid complex mappings.
• Extensively involved in designing the SSIS packages to export data from various sources like Oracle, SQL Server, MS Access etc. to the SQLServer database.
• Used Power BI with DAX for developing reports, data marts, KPI's and charts for the organization and departments.
• Used Power BI Power Pivot to develop data analysis prototype and used Power View and Power Map to visualize reports.
• Build KPI, Power BI dashboards,and ad hoc reports as needed.
• Provide maintenance and development of bug fixes for the existing and new Power BI reports and DAX calculations.
• Designed and implemented indexing to optimize transactional and reporting performance
• Generated Tableau Dashboards with quick/context/global filters, parameters and calculated fields on Tableau reports
• Developed meaningful tableau dashboards with advanced data visualization, calculation, and user-friendly interactions to support decision making
• Provided Production support to Tableau users and wrote customized SQL query to support business requirements.
• Worked to create, develop and deploy multiple Drill down, Drill through, Sub-report and Parameterized reports by using Tableau 10.X.
• Reviewed documents with QA team, clarified any questions or issues and presented to the project manager for approval and implementation
• Resolved conflicts between development and implementation teams. User Acceptance Testing (UAT) testing was performed to ensure proper compliance of goals was met.
• Troubleshooting performance issues and fine-tuning queries and stored procedures
• Worked on OLAP Data warehouse, Model, Design, and Implementation.
• Sound Experience and understanding of OLAP and OLTP cube, Data mining and Architecture.
• Created multiple reports with drop-down menu option having complex groupings within the report.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Generated matrix reports, drill down, drill through, subreports, chart reports, multi parameterized reports.
• Worked very closely with Business Customers, End Users and resolved any business process related issues.
• Responsible for designing and developing a Drill Down, Cross-tab, and Tabular Report using Report Server in SSRS to draw data from the Data Warehouse. Periodically developed a Report to be used by the Senior Management utilizing SSRS.
• Identifying business needs, evaluated business and technical alternatives, recommended solutions and participating in their implementation.
• Actively worked on Business requirement gathering, analysis,and Data Analysis.

Environment: Windows Server 2003, IIS 6.0,Tableau, MS SQL Server- 2016/ 2014/2012/2010/2008/2005 Enterprise Edition, SSIS, SSRS, T-SQL, DTS, SQL Profiler, OLAP, OLTP, Erwin, Oracle 10g/11g/12c.

Business Intelligence Developer

Confidential, Tampa,FL

Responsibilities:

• Gather and document project requirements and translated them into the functional and non-functional specification for BI reports and applications.
• Responsible for creating database objects based on business requirements such as User Defined Functions (UDFs), Views, Stored Procedures, etc.
• Responsible for creating database objects like Views, Stored Procedure, Triggers, User-Defined Functions(UDFs) etc. using Transact-SQL(T-SQL) 2008 to store data and to maintain database efficiently
• Designed the new Credit Risk report using Transact-SQL(T-SQL) and SSRS, illustrated by interactive dashboards, linked reports, sub-reports, parameterized reports and drill-down, drill-through reports using Tableau.
• Migrated portfolio data from different data sources to centralized SQL Server database related to different kinds of financial products using SQL Server Integration Services (SSIS)
• Designed and implemented complex SSIS package to migrate data from multiple data sources for data analysis and front-end display
• Monitored project status to meet milestones and resolved issues with data quality or the ability to deliver to timescales or estimates
• Involved in incremental loading task by implementing the Slowly Changing Dimension to maintain historical data in the data warehouse. Applied different types of transformations like Data Conversion, Multicasting, Conditional Split, Derived Column in SSIS.
• Debugged and troubleshot the ETL packages by using a breakpoint, analyzing progress, catching error information by SQL command in SSIS.
• Worked with production control team to deploy code and for schedule run in both stagings while testing and production. Responsible for providing on-call production support for daily job and ETL loads.
• Developed SSIS packages using different types of the event handler to clean up temporary data storage when a package or task finishes running, send an e-mail message when an error or a warning occurs or when a task fails.
• Implemented solutions using actions filters to navigate between various dashboards by using Tableau
• Automated and enhanced daily administrative tasks including database backup and recovery
• Assisted DBA in implementing Data and Database Security using various Default Database and Server roles and by creating User-defined as well as Application Roles
• Dealt with data cleansing such as data type conversion, format changing, missing value handling. And generated documents for data validation to ensure data consistency in the staging area.
• Developed many Tabular reports, Matrix reports, created many Cascaded parameters to achieve Drill-down reports, Drill-through reports in SSRS 2008.
• Achieved data visualization, Reporting, and Analysis. Created Dashboards with Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts.

Environment: MS SQL Server 2008 (T-SQL), SQL Server Management Studio, SQL Server Integration Service, SQL Server Reporting Service, MS Office Suite 2010. Tableau 6.x.

Business Intelligence Developer

Confidential - Charlotte, NC

Responsibilities:

• Assisted in designing and development of complex ETL structures for the transformation of data sources into data warehouses.
• Prioritized requirement deliverables documented in the requirement document to meet the crucial deadlines to complete the project according to schedule.
• Developed and maintained the product backlog by tracking the progress pertaining to all the user stories.
• Designed the navigation flow and user interface for the full-featured reporting functionality.
• Trained the user's groups to use the new functionalities of the developed system.
• Extensively involved in designing the SSIS packages to export data from flat file source to SQL Server database.
• Proven experience in utilizing databases such as Oracle 10g/11g.
• Strong experience in writing complex SQL, Oracle queries, joins, tables, etc.
• Excellent communication and organizational skills, including a wide range of architectures and technologies
• Designed SSRS 2008 reports with Cascaded Parameters, Gauges,and Interactive Charts, etc.
• Excellent report creation skills using Microsoft SQL Server 2012/2008 Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
• Highly responsible for development and management of SSRS and SSIS projects.
• Developed Complex Stored Procedures, Views and Temporary Tables as per the requirement.
• Created and embedded web reports using Report Definition Language Client-side(RDLC) reports in ASP.NET.
• Worked with script component in SSIS using C# for capturing values at runtime, file operations and debugging SSIS packages.
• Created complex reports which involve a number of groupings and multi-value parameters
• Using SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting so creates reports that draw content from a variety of data sources.
• Design and create report models based on users' requirements, explain and train users to use report builder to generate their own personalized reports.
• Worked very closely with Business Customers, End Users and resolved any business process related issues.

Environment: Windows server 2003, IIS 6.0, MS SQL Server-2012/2008 R2/2005 Enterprise Edition, SSIS, SSRS, T-SQL, MS Excel, Azure, ASP.NET, C#, Oracle 10g/11g.

Business Intelligence Analyst

Confidential - Chevy Chase, MD

Responsibilities:

• Interacted with third-party vendors and identified different external and internal homogenous and heterogeneous sources and extracted and integrated data from flat files, Oracle, SQL Server sources and loaded to the staging area and database/Datamart tables.
• Excellent report creation skills using Microsoft SQL Server 2014 Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
• Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel and created SSIS packages to load excel sheets intothe database.
• Familiarity with data warehousing solutions in an Oracle 10g environment
• Worked on OLAP Data warehouse, Model, Design, and Implementation.
• Involved in relational database modeling like, designing the tables, algorithmic diagrams for the input data (entity diagrams), indexes etc.
• Created complex SSIS packages using appropriate control and data flow elements with SSIS Standards like error handling, logging and working with package config files.
• Sound Experience and understanding of OLAP and OLTPcube, Data mining and Architecture.
• Created multiple reports with drop-down menu option having complex groupings within the report.
• Involved in developing Web Service classes using SOAP to communicate with legacy systems and deployed web services as per business requirement in ASP.NET
• Integrated custom visuals based on business requirements using Power BI desktop
• Designed, Built the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Generated matrix reports, drill down, drill through, subreports, chart reports, multi parameterized reports.
• Used Power BI Power Pivot to develop data analysis prototype and used Power View and Power Map to visualize reports.
• Build KPI, Power BI dashboards,and ad hoc reports as needed.
• Provide maintenance and development of bug fixes for the existing and new Power BI reports
• Worked very closely with Business Customers, End Users and resolved any business process related issues.
• Responsible for designing and developing a Drill Down, Cross-tab, and Tabular Report using Report Server in SSRS to draw data from the Data Warehouse. Periodically developed a Report to be used by the Senior Management utilizing SSRS and Power BI

Environment: Windows Server 2003, IIS 6.0, MS SQL Server- 2014/2012/2010/2008/2005 Enterprise Edition, SSIS, SSRS, T-SQL, Office-2007, MS Excel, Azure, ASP.NET, C#, Power BI, Oracle 10g/11g.

SQL Developer

Confidential

Responsibilities:

• Performed data migration (import & export) from text to SQL Server. Used scripts, variables, and email notifications for ETL process via Data Integrator in SSIS and SSAS.
• Optimized stored procedures and queries for faster execution and server efficiency in SSAS and SSIS.
• Performed performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard in SSAS and SSIS.
• Designed, implemented and maintained database schema, entity relationship diagrams, data modeling, tables, stored procedures, functions and triggers, constraints, indexes, schemas, functions, views, rules and complex SQL statements.
• Generated various reports like the matrix, tabular, chart, link, and drill-down reports.
• Utilized Snapshot Replication to synchronize the data between different stores.
• Performed SQL Server mirroring and database optimization.
• Created and configured OLAP Cubes (Star and Snowflake Schema) using SQL Server 2008 Analysis Services (SSAS).
• Generated reports using global variables, expressions,and functions using SSRS 2008.
• Created technical and functional documents including detailed description and screenshots specifying the application’s functionality.

Environment: SQL Server 2005/2008, SSIS, SSRS 2008 R2, SSAS, SQL, Visual Studio 2008/2010, Windows XP, MS Office, Windows Server 2003, Crystal Reports.

SQL Developer

Confidential

Responsibilities:

• Communicated with the Business Users to understand the requirements.
• Created Drill reports for the Clean-up Activity followed in the company
• Created reports for calculating the number of hours scheduled and the calculations made for the payment.
• Generated periodic reports from the cube based on the statistical analysis of the data using SQLServer Reporting Services (SSRS).
• Created Drill-through, Drill-down, Cross-Tab Reports and Sub-Report using Report Definition Language (RDL).
• Wrote queries using MDX
• Deployed and configured the reports in the Report Server.
• Experienced in designing the OLAP systems for data mart applications using SQL Server Analysis Services 2008
• Used stored procedures and user-defined functions for different Reports.
• Wrote complex correlated subqueries to generate reports.
• Wrote User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secure and extensible.

Environment: SQL Server 2008, SSRS 2008, SSAS, Visual Studio 2008, XML, XSLT, MS Office and Visual Source Safe.