SUMMARY:

• IT professional with 7 years of extensive experience as a Business Intelligence Developer, Data Analyst, Data Base Developer and Data Modeler especially in Enterprise Data Warehousing and Business Intelligence applications in Health Care and Financial industries.
• Possess strong knowledge of database management, writing complex SQL queries, Stored procedures, database tuning, query optimization.
• Expertise in Writing and optimizing SQL queries to develop and maintain data for Analytics and Reporting.
• Good working knowledge of Relational database concepts and possess strong knowledge in writing SQL & PL/SQL queries in Oracle, Teradata and MS SQL Server.
• Experience in 3NF and dimensional data models.
• Administers all database objects, including tables, clusters, indexes, views, Triggers, Table spaces and procedures for Oracle and DB2 databases.
• Experience in SDLC that included duties like providing documentation on design, testing and migration from development to production.
• Conducted Gap Analysis, created data flows and Power Point presentations for the Various Applications.
• Proficient in developing Entity - Relationship diagrams, Star/Snow Flake Schema Designs, and Expert in modeling Transactional Databases and Data Warehouse.
• Outstanding Data analysis skills including Data mapping from source to target database schemas, Data Cleansing and processing, writing data extract scripts/programming of data conversion and researching complex data problems.
• Proficient in Star Schema dimensional modeling, which include understanding business processes, modeling dimensions, hierarchies and facts.
• Adept in analyzing bugs, interacting with team members in fixing errors and UAT.
• Experience in working with Various Reporting tools like Tableau, Qlikview/Qliksense, Cognos & SSRS.
• Extensive experience in preparing dashboards using actions, groups, sets and hierarchies in Tableau Desktop & Qlikview/Qliksense.
• Creating dashboards in line with the analytical uniformity using the Advanced Analysis of Tableau Desktop, and organizing Dashboard views and objects.
• Experience in designing and deploying rich Graphic visualizations with Drilldown and Drop down menu option, Quick Filters and Parameters using Tableau.
• Highly organized with proven ability to prioritize, manage multiple tasks, and meet deadlines.
• Strong understanding of BI Software development methodologies; both Waterfall and Agile.
• Strong analytical/problem solving skills with attention to detail.
• Highly motivated team player with excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation Skills, and Leadership Qualities.

TECHNICAL SKILLS:

Databases: Microsoft SQL Server, DB2, Sybase, MS Access, Teradata, Oracle,etcScripting Languages: C, C++, C#, XML, SQL, PL/SQL,Python & R

Document management: Visual Source Safe 6.0, Share point, Ultra Edit, Documentum

Methodologies: Data Modeling - Logical/Physical/Dimensional, Star/Snow flake Schema, Complete Software Development Lifecycle, CMMI Compliance, Waterfall, Agile, Iterative

BI Tools: TableauDesktop/Server 8/9/10 versions, Qlikview/Qliksense, SSRS

ETL Tools: Informatica, DataStage, SSIS

Requirements Management: Requisite Pro, Microsoft Office (Word & Excel)

Front End Tools: Visual studio(TFS), Microsoft Project, Microsoft Office, Visible Analyst

PROFESSIONAL EXPERIENCE:

SQL BI Developer/BI Analyst

Confidential, Jersey City, NJ

Responsibilities:

• As a software developer working at Confidential Global Risk and Investment technology team Extensively Involved in development of Reconciliations In various work streams like Market risk, Credit Risk, Counterparty Risk, Corp Treasury, International Treasury & Prime Brokerage.
• Extensively working on developing new Reconciliations which involves Dealing with Millions of records from both master and subledger sides and complex Sql server Views, Stored Procedures, Functions, Indexes to implement various Pre-match Exclusions, Post-match Filters & Categories and the matching process
• Have been Designing Various data models & data base objects to translate complex business requirements to real time Reconciliations with Accuracy.
• Have been Organizing meetings with Users to gather business requirements and translate them into technically to my fellow team members.
• Have worked On Automating the Extract Transform Load(ETL) using Sql Server configurations and AutoSys Using BCP Bulk data load and SSIS Packages.
• Have been working on SSIS (sql Server Integration Services) to build SSIS Packages Which Supports Bulk Data Involving Various Millions of Records.
• Developing SSRS Reports involving Complex Stored procedures to Report Monthly, Quarterly & Annual trend analysis & Database object dependencies reports.
• Developed various Admin reports that shows the statistics of server performance and drive utilization reports Which In Turn Helped in improving the Infrastructure and its performance.
• Extensively worked with Autosys to Automate the Execution of various complex Stored Procedures as and when required by the business.
• Extensively Working with Rapid JiraS which basically Serves as Enhancements for Some of the existing Reconciliations and some Infrastructure enhancements.
• Extensively Working on Fixing the User Interface Issues which Involves .net Framework with C# Coding
• Extensively Worked on Microsoft Visual Studio to Program C# objects to Improve the UI Performance and eliminating the timeouts which is a longstanding issue.
• Extensively Involved in Testing the code in various programing languages at Various levels of development cycle.
• Improved the infrastructure’s Ability to support multiple dropdowns in a UI report which added a new dimension to the infrastructure capabilities.
• Have been working on Production support to provide emergency fixes as part of escalations and emergency releases.
• Automated various Production support activities like renaming the files, converting the files into required format and sending over automated emails to the users on daily basis as and when required by the business
• Working on automating the lower lane server maintenance jobs Using Complex Stored Procedures and Designed the Dimensions and Objects that are needed for this automation.
• Worked On developing POC's Determining the matching logics and approved filters logics for various upcoming reconciliations.
• Have been working with DMA. In deploying the codes to different servers as part of deployments and Releases.
• Have been Interacting with the users to develop Various Ad-Hoc Reports using Various Reporting tools like Tableau, Qlikview/QlikSense & SSRS.
• Have been working on production support activities.
• Have been working with XML Scripts to translate the data base reports on to a user interface as required by the business.
• Have developed scripts which serves as Cache Clean up tools to avoid discrepancies in the UI.
• Have been working on database performance tuning scripts by using SSMS & AutoSys to automate the weekend & Month-end cleanup jobs.
• Have been working with business analysts & users technically to provide them with scripts that will be useful for their analysis while finalizing the requirements.
• Have been planning and prioritizing the duties to keep the deliverables & deadlines intact.

Environment: SQL Server2014, Oracle 11 g, PL/SQL, T-SQL, MS Access, Tableau Desktop 10 .x, Tableau server10.x, Oracle SQL developer, Autosys, DMA, Microsoft Visual Studio, MS Office

BI Developer/ Admin

Confidential, Annapolis, MD

Responsibilities:

• Involved in complete end-end Tableau Implementation from Design, Development and implementation of Tableau Reports .
• Built worksheets and data visualization dashboards for business users.
• Designed dashboard templates and content, including complex tabular reports.
• Utilized capabilities of Tableau such as Data extracts, Data blending, Forecasting, Dash board actions and Table calculations.
• Executed PL/SQL blocks using cursors, REF cursors, exception handling, Collections -Nested tables and Index of Table and Dynamic SQL.
• Wrote PL/SQL Stored Procedures, Functions and Packages.
• Worked on creating various dashboards in Tableau Desktop by querying various ODBC connections such as Teradata, Oracle SQL Developer, and SQL Server.
• Created SQL scripts for testing and validating data on various reports and dashboards and handled performance issues effectively in Tableau
• Involved in creating a dual-axis bar charts with multiple measures, box plots, heat maps and background maps, trend lines statistics.
• Worked with the advanced Tableau features including calculated fields, parameters, table calculations, joins and dashboard actions.
• Restricted data for Particular users using Row Level Security and user Filters.
• Involved in creating data blending while merging data from different sources.
• Extensively Involved in Optimizing DB2 and Oracle SQL Views for the Data load and Dimensions Build.
• Created custom complex SQL Queries to generate the data from data base and use it for making Innovate Dashboards for easy Data Visualization and Forecasting in Tableau.
• Performed extensive GAP analysis in the project to accommodate numerous 'As-Is' and 'To-Be' scenarios.
• Involved in installation and maintenance of Tableau Server and administering users, user groups, projects and scheduling instances for dashboards in Tableau.
• Involved in creation of workbooks and the appropriate permission sets for Tableau server logons and security check.
• Designed and developed various applications artifacts including dimensions, data forms, business rules, reports, books, workflow, security etc.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Developed proof of concept on new requirements and suggested best practices for Tableau development & deployment, and ad-hoc reporting.
• Used relational database structures, theories, principles, and practices.
• Involved in DBA Activities such as creating Tables and Indexes to Improve the Retrieval Performance of the Data views in DB2 and Oracle databases
• Responsible for migrating the web catalog and RPD from DEV, UAT and Production environments.

Environment: Tableau Desktop 9.x, Tableau server9.x, Oracle SQL developer, SQL Server2012, Oracle 11 g, PL/SQL, T-SQL, MS Access, Windows server, Teradata, MS Office

MSBI Developer

Confidential, Rosville, CA

Responsibilities:

• Created oracle objects (Tables, Views, Indexes)
• Used various report items like tables, sub report and charts to develop the reports in SSRS.
• Experience in Developing and Extending SSAS Cubes, Dimensions and data source views SSAS-Data Mining Models and Deploying and Processing SSAS objects.
• Automated SSIS Execution using Windows Scheduler using DTExec Command.
• Worked on automating process by creating jobs and error reporting using Alerts, SQL Mail Agent, FTP and SMTP.
• Created linked servers between different SQL Servers and created linked server with different access files used across various Used Data departments.
• Created parameterized reports and adhoc reports using Report builder.
• Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
• Executed PL/SQL blocks using cursors, REF cursors, exception handling, Collections - Nested tables and Index of Table and Dynamic SQL.
• Designed and developed reports to support Claims Reporting and Business Intelligence strategy
• Created calculated fields for trending reports such as year-over-year and month-over-month claims.
• Created various Metrics, enabling users to build customized reports: creating their own templates & Filters.
• Involved in report tuning, caching, specifying query governing thresholds, and report optimizations.
• Responsible for the testing, fixing the bugs and troubleshooting the technical problems.
• Creating and developing test strategies, test cases and test plans.

Environment: Oracle SQL developer, SQL Server, Oracle 10g, PL/SQL, T-SQL, MS Access, Windows server, Teradata, MS Office, TFS

Sql Data Analyst

Confidential

Responsibilities:

• Extensively worked with Dynamic SQL, Composite data types, Local & Global Temporary Tables.
• Worked extensively with Advance Analysis Actions, Calculations, Parameters, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, sets to create detail level summary reports.
• Involved in migrating client's reports from excel (static) based solution to an interactive service.
• Optimized stored procedures in to extract, transform and load (ETL) data to ensure reporting infrastructure was maintained according to current service level agreements.
• Established the connection between legacy system and Discuz forum software using MySQL and SQL Server
• Participated in meetings and Database Analysis with Developers, Project Managers and Quality Analysts to discuss business requirements, test planning, resource utilization, and defect tracking.
• Extensively worked with ETL Processes such source, mapping, transformation, staging areas and created various ETL documents such as ETL Mapping documents, Data Mapping documents

Environment: SQL developer, SQL 2012, Oracle 10g, DB2,Informatica JavaScript API, Microsoft Excel 2007, MS Access, Windows 2007 server, Microsoft office 2007.

Sql Developer

Confidential

Responsibilities:

• Developed procedures, functions, packages.
• Used PL/SQL Tables and Records in transaction processing using the Oracle features.
• Implemented the Case Statement Logic in SQL statements to reduce the PL/SQL code using Oracles 9i.
• Extensively used IMP and EXP for data transfer from source systems to new application.
• Implemented the concept of Clusters to reduce the time of Data retrieval.
• Implemented Materialized view for faster processing.
• Worked with Clear case to track versions release control, to assign bugs to relevant developers and update status across the lifecycle.
• Wrote PL/SQL Stored Procedures, Functions and Packages.
• Created Database tables with complex constraints applicable to the business rules.
• Performed SQL Tuning within applications for optimized database access.
• Optimized database code using EXPLAIN PLAN.
• Created oracle objects (Tables, Views, Indexes).

Environment: Oracle 9i/10g, Oracle Data Integrator (ODI), Rapid SQL 7.6.4, SQL Server Management Studio 2008, PL/SQL, TOAD, SQL developer, SQL * Loader, SQL, UNIX shell scripting, MS Excel.