SUMMARY:

• Over 6 years of IT experience in the Business Analysis, Design, Implementation and Testing of Applications using wide range of Technologies including Data Warehousing, Database and reporting systems for Energy, Sales & Distribution, Telecom Industries and banking with a focus on Database development (Teradata/Oracle/SQL Server/Vertica/Amazon Redshift) and Business Intelligence MSBI SSRS, Tableau, Cognos, Power BI and Database Administration (Oracle/SQL Server) and ETL (SSIS, Pentaho)
• Expertise in Database design and development of applications using SQL Server 2014/2012/2010/2008, Integration Services (SSIS), Reporting Services (SSRS), SQL Server Analysis Services (SSAS), OLAP Cubes, Star schema and Snowflake schema
• Strong background in Database development, Business Intelligence (MSBI, Tableau, Cognos) and Data Warehousing and in designing and developing Business Intelligence solutions in Data Warehousing/Decision Support Systems.
• Comfortable with both technical and functional applications of RDBMS, Data Mapping, Data management, Data transportation and Data Staging.
• Design and build multi - terabyte, end-to-end Data Warehouse infrastructure using Redshift for large scale data handling Millions of records on daily basis.
• Optimizing and tuning the Redshift environment, enabling queries to perform faster for Tableau and BI Reports Analytics
• Expertise in Performance Tuning & Query Optimization of SQL statements using EXPLAIN PLAN, SQLTRACE, table partitions, index, and optimizer hints, and multi-table inserts.
• Expertise in SQL and PL/SQL programming, developing complex code units, database triggers and using the latest features to optimize performance (Bulk Binds, Bulk collect, Materialized views, Inline views, Global Temporary Tables and Save Exceptions
• Strong working knowledge of development tools like Aquastudio, Toad, SQL Workbench, and SQL Developer and PL/SQL developer.
• Expertise in SQL and PL/SQL programming, developing complex code units, database triggers and using the latest features to optimize performance (Bulk Binds, Bulk collect, Materialized views, Inline views, Global Temporary Tables and Save Exceptions.
• Developed Tableau visualizations and dashboards using Tableau Desktop. Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Extensive experience in implementation of ETL methodology in Data Extraction, Transformation and Loading using SSIS, PLSQL and PDI (Pentaho Data Integration)
• Extensively used ETL methodology for performing Data Migration, Extraction, Transformation and Loading using SSIS /Informatica and designed data conversions from wide variety of source system
• Experienced in coding SQL, SQL plus, UNIX Shell Scripting, Java Scripting, PL/SQL, Procedures, functions and triggers with different databases like Oracle 10g/11g, SQL server and Efficient in Optimizing, Debugging and testing SQL queries.
• Involved in Implementations, Version Upgrades, Data Conversions, Data Analysis, and Customization of Reports.
• Designed different types of reports like drill down, drill through, sub reports, parameterized reports.
• Experience in reporting services, Power BI (Dashboard reports).
• Extensive experience in creating several reports such as Drilldown Reports, Parameterized Reports, Linked Reports, Sub Reports, Matrix Reports and Chart reports using SQL Server Reporting Services
• Excellent T-SQL Developer skills including Stored Procedures, Indexed Views, User Defined Functions, Triggers, and Distributed Transactions.
• Experience in controlling the User Privileges, Monitoring the Security and Audit Issues as per Standards
• Experience working in Agile Methodology and Sprint system.
• Experience in creating Stories and Tickets and follow-ups using Jira.
• Energetic self-starter with excellent analytical and problem-solving skills. Good verbal, written, and presentation skill. Effective team worker.

TECHNICAL SKILLS:

Operating Systems:: Windows (2012 Server 64 Bit, 2008/R2 Server, 2003 Server 64/32 Bit, 2000, NT), UNIX (RedHat, SUSE, CENTOS)

RDBMS:: Oracle 10G/11G/12C, Microsoft SQL Server 2008/2008R2/2 /32 bit) - Standard/Developer and Enterprise Edition, My-SQL, Teradata 13/14, IBM DB2

Cloud Platform and Virtualization Services: Amazon Web Services (AWS), VMware ESX

Web Server s: IIS 6.0/7.0/8.0, Tomcat Apache 5.5/6.0/7.0/8.0

Reporting: SSRS, Business Objects, IBM Cognos 8.x/10.X, OBIEE 10G/11G.

ETL & OLAP: SSIS, Informatica, Pentaho, Ab Initio, SSAS

Other Software & Tools:: Windows PowerShell, Ruby, JSON, ERWIN, ASP.NET, Citrix XenApp

PROFESSIONAL EXPERIENCE:

Confidential, Washington D.C

SQL BI Developer III

Responsibilities:

• Worked on projects for Confidential involving Data modeling, ETL design, Development, Testing, Documentation, and Report and Cube Development.
• As part of LI project, developed reports using Pentaho Report Designer. Some of the features used are: Report Design Wizard, Parameters to add to the report, Parameters to call the prompts and modified Attributes and Styles according to user requirements.
• As part of RHC project, analyzed the transactional database, gathered requirements from the user and created the Data Model, developed ETL jobs for Dimension and Fact loads, Created Pentaho Cube for Analysis reporting through Pentaho Schema workbench and tested the ETL and Cube.
• Developed performance tuning strategies with business model-level calculations versus Data warehouse level pre-computations & aggregations, aggregate navigation, cache management, Oracle materialized views.
• Developed performance tuning strategies with business model-level calculations versus Data warehouse level pre-computations & aggregations, aggregate navigation, cache management, Oracle materialized views.
• Created Daily, Weekly, Monthly, Quarterly, Yearly Reports and Several Complex Reports for several program subject areas.
• Extensively used T-SQL in constructing user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
• Developed and debugged many Tableau Dashboards / Reports with different Analytics Views (Pivot Table, Chart, Tabular and View Selector, Drill Through, Drilldown Reporting).
• Created Stored Procedures and Business Views in ORACLE 11G and SQL Server required for reporting requirements and created and supported several reports in Tableau, Pentaho Reporting and SSRS reporting tools.
• Working on modifying /Creating various Business Views, Stored procedures, Calculations, functions and triggers according to the new business requirements.
• Involved in Migration and testing of several SSRS reports upgrades to Pentaho PRD reports.
• Creating of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, SQL Server.
• Involved in EDW (Enterprise Data Warehouse project) as ETL developer for all SL and RHC programs, migrated data from multiple programs sourced at different source systems Oracle, SQL Server to Vertica.
• Using Pentaho data Integration tool migrated data from SQL Server to Vertica.
• Involved in day-to-day validation of ETL loads in EDW project, monitoring ETL Jobs and created alerts and monitoring mechanism to handle ETL failures and Validations after the ETL load.
• Involved in performance tuning of long running SSRS, Tableau reports ETL Processes created and worked with DBA’s to handle the performance issues.
• Worked closed with Database DBA
• Generated Metadata SQL using and Dynamic ETL Template, to migrate the data with in short period of time.
• Worked effectively under pressure, effectively delivering highly time-sensitive reports for executive users, regulators, and business unit managers
• Involved in application testing, deployment and production support
• Involved in the continuous enhancements and fixing of production problems
• Involved in application testing, deployment and production support
• Working in Agile Methodology and Sprint system and Experience in creating Stories and Tickets and follow-ups using Jira.

Environment: Oracle 11G/12C, PENTAHO 8.2, SQL Server 2012/2014, SSIS, SSAS, SSRS, T-SQL, Microsoft Visual C#, SQL Profiler, MS Office, Teradata 13/14, Tableau 2019.3, UNIX, Vertica 3.9.1

Confidential, Providence, RI

SQL BI Developer

Responsibilities:

• Involved in acquiring business requirements, functional and technical specifications, development, testing and deployment of various commercial reports
• Developed SSIS Packages and Stored Procedures to load/transform/cleanse data from SQL Server, Oracle and Excel Files to Facts and Dimension Tables in the Data Warehouse.
• Improved Stored Procedures and SQL Queries performance by analyzing execution plans and creating proper Indexes using SQL Profiler and Database Tuning Advisor.
• Created complex SQL Queries, Stored Procedures, Functions, Indexes, CTE's, Views, Joins and Triggers.
• Participated in the design and development of the Data Warehouse using Star Schema and Snowflake Schema.
• Created SSRS reports - tabular, matrix, charts, dashboard and sub-reports using SSRS 2012/2008 R2.
• Developed and deployed SSIS packages for ETL from OLTP and various sources to staging and staging to Data warehouse using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term, Slowly Changing Dimension and more.
• Created Script tasks and components with C# and VB.NET in SSIS as part of ETL load.
• Maintained Data Warehouse by loading dimensions and facts as part of Project. Also worked for different enhancements in FACT tables.
• Developed various transformations based on customer last name, zip code, SSN/TIN, Phone Number for internal business analytical purposes, loaded warehouse based on customer credit card number with dynamic data re-partitioning.
• Actively involved in testing of a new reporting tool, as well as Datamart elements, identified and documented multiple defects and effectively communicated resolution with TSA partners. In this regard, participated in multiple meetings and discussions
• Developed Stored procedures, User Defined Functions, Triggers, Views, Cursors, CTE’s, T-SQL scripts, schemas, permissions and performance issues
• Extensively used Joins and Common Table Expressions (CTE) to simplify complex queries involving multiple tables
• Worked on several transformations like Merge join, Look up, Conditional Split, Union all, Script Component, Aggregate, Data Conversion etc
• Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder. Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Applied various SSIS data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column etc.
• Extensively used Script Tasks for testing the output and Visual C#, Visual basic languages in writing the scripts
• Developed SQL scripts to Insert, Update, Delete and Merge data in the database tables along with SQL Joins.
• Created Report Subscription and Data Driven Subscription and Job Scheduling using SSRS.
• Created complex drill down reports, Parameterized reports, dropdowns and images, charts, cascaded, Sub-Reports, Matrix, Drill-down, Drill-through, Charts, and web receiving reports using SSRS 2014/2012 and MS Excel for analyzing the data at an enterprise level.
• Generated and formatted Reports using Global Variables, Expressions and Functions, designed and implemented stylish report layouts.
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS)
• Took over a full responsibility and successfully managed a process of advancing newly-developed AFS reports from Dev region to UAT and further to CMOD/Production, effectively communicating with TSA partners
• Unit tested and debugged dashboard reports verifying that data matches as expected.
• Implemented security by identifying the groups and their permissions and privileges as per business needs.
• Involved in application testing, deployment and production support.

Environment: Oracle 10g/11G,PL/SQL, UNIX Scripting (BASH, CSH),SQL Server 2012/2014, SSAS, SSRS, Power BI,T-SQL, MySQL, Microsoft Visual C#, SQL Profiler, MS Office, Teradata 13/14, OBIEE 10g/11G.

Confidential, Houston, TX

SQL BI Developer

Responsibilities:

• Involved in acquiring requirements from Business Requirement Document (BRD), functional and technical specification, development, deploying and testing by business analysts, UAT, and developers.
• Involved in design and data modeling using Star schema, Snowflake Schema.
• Identified various data sources, formulated data dictionaries, design and develop data models (physical/logical data models) based on the given specs and requirements.
• Involved in designing and implementing database applications using ORACLE 11G and MS SQL Server 2012/2008 and Business Intelligence (BI) tools to support transactions and business decision-making.
• Developed performance tuning strategies with business model-level calculations versus Data warehouse level pre-computations & aggregations, aggregate navigation, cache management, materialized views.
• Created Stored Procedures, Triggers, User defined Functions, Constraints etc on various database objects to obtain the required results.
• Created various database objects such as tables, indexes and views based on the requirement.
• Coding of several database Triggers, Stored Procedures, and Creating Views and indexed views and maintaining Integrity Constraints
• Designed Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints Views, Rules and Defaults
• Created SSIS packages to get data from different sources, consolidate and cleanse the data and merge it into one single source.
• Developed and deployed SSIS packages for ETL from OLTP and various sources to staging and staging to Data warehouse using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term, Slowly Changing Dimension and more.
• Designed and developed SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL server 2012 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Published Power BI Reports in the required originations and made Dashboards available to Web clients and mobile apps.
• Used Power BI Gateways to keep the dashboards and reports up to date.
• Installed and Configured Enterprise Gateway and Personal Gateway in Power BI Services.
• Creating Row level securities and integrating with Power BI service portal.
• Designed different types of reports like drill down, drill through, sub reports, parameterized reports.
• Experience in reporting services, Power BI (Dashboard reports).
• Designed Linked, cascaded, parameterized, sub reports and Worked on Drill Down and Drill-through Reports, Tabular, Matrix and Tablix Reports
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel format using SSRS 2012 and 2014
• Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.
• Created SSIS packages to retrieve data from Legacy sources, retrieve user data from the Flat files on monthly and weekly basis, File Transfer from one location to the other using FTP task.
• Worked on Sub Reports, Graphing, Data Drill-Down, and Data sorting/grouping, Crystal Report Design.
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
• Enhancing performance using optimization techniques-normalization, indexing and Transaction Isolation levels, monitoring logs to ensure the completeness of batch processes, scripts and processes. Created Linked Servers to connect OLE DB data sources and providers.
• Collaborated with fellow team members through Team Foundation Server for effective project management which includes work issues and track on the update of versions.
• Involved in application testing, deployment and production support.

Environment: ORACLE 10G/11G,MS SQL Server Management Studio 2008, 2012 SQL Profiler, SSIS,SSRS, C#, XML, MS Access, ER Studio, T-SQL, Crystal Reports, ERWIN.

Confidential

SQL Server Developer

Responsibilities:

• As a Team member interacted with Business Analysts and client representatives for requirements gathering, research and solving client specific data issues.
• Involved in database design, development of database, tables and views.
• Designed and developed SSIS (ETL) packages to Validate, Extract, Transform and Load data from OLTP system to the Data warehouse
• Created several reports using SSRS like drill down, drill through, parameterized, linked and sub reports.
• Created indexes, Views, complex Stored Procedures, user defined functions, cursors, derived tables, common table expressions (CTEs) and Triggers to facilitate efficient data manipulation and data consistency.
• Performed complex SSIS ETL operations to validate, cleanse, transform and load data to data warehouses
• Worked with SSIS Variables, Scripting, event-handlers, package configurations and deployment.
• Developed Stored Procedures for parameterized, drill-down and drill-through reports in SSRS 2008.
• Formatted reports using Global Variables, Expressions and Functions for the reports.
• Deployed the created reports into Share Point Server and Report Manager, created data driven subscriptions for different users in desired format.
• Created Report Models for developing ad-hoc reports by the end-users.
• Involved in SSAS Cubes design by creating measure groups, dimensions, aggregations, Actions, Partitions and Perspective from huge dataset using SQL Server 2008 Analysis Services (SSAS).
• Designed Star schema (identification of facts, measures and dimensions) and Snowflake schema.
• Implemented site information architecture utilizing various Share Point resources including Document Libraries, Lists, Form Libraries, Content Types, Column, Information Management Policies and Version Controlling.
• Aided in efficiency of team development by Working with Visual Source Safe as the source for version control and project / issue management.
• Automate and enhance daily administrative tasks, including space management, object alteration, backup & recovery and performance monitoring.
• Involved in Performance tuning of SQL queries and stored procedures using SQL Profiler and Database Engine Tuning Advisor.
• Assisted in the application development, debugging, configuration, and optimization from database perspective.
• Designed logical and physical data models using Erwin.
• Provided 24 X 7 on-calls/ remote support for any Outages.

Environment: Oracle 10G/11G, Windows Server 2008,.NET 2.0, T-SQL, SSIS, SSRS, SSAS, MDX,MS SharePoint, C#, ASP.NET, VSS(Visual Source Safe), VB.NET, ERwin 4.0, MS Access, XML, Excel