SUMMARY

• Senior application programmer with over 7 years of experience in complete software life - cycle development including analysis, design, and development of application software.
• Experience in Data Warehousing and Business Intelligence applications in Financialand CPG domains.
• Have knowledge in financial statements, budgeting, forecasting, and planning process. Created processes to generate accruals, balance sheet and consolidations and send them to Ledger and reconciling reporting applications.
• Expertise in Client-Server application development using Oracle 12c/11g/10g.
• Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques and design techniques.
• Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views.
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL. Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
• Strong experience in writing large queries using with clause, rank and connect by concepts.Worked extensively on Ref Cursor, External Tables and Collections.
• Good knowledge of key Oracle performance related features such asQuery Optimizer, Execution PlansandIndexes.
• Experience withPerformance Tuningfor Oracle RDBMS usingExplain PlanandHINTS.
• Created NDM connections and send files to target systems using the NDM node and mainframes file transfer script from Unix.
• Created Shell Scripts for invoking SQL scripts and scheduled those using Autosys. Created file watcher jobs, calendars, and conditional jobs in Autosys.
• Hands on experience in Microsoft SQL Server database, SSMS, MSBI (SSIS, SSRS, SSAS) and Power BI.
• Worked with Meta-Data Driven SSIS Packages to pull the data from different Sources and load to Data mart.
• Deployed reports created report schedules and subscriptions. Managing and securing reports using SSRS.
• Designed and developed OLAP Cubes and Dimensions using SQL Server Analysis Services (SSAS).
• Modified and maintained Hyperion Essbase applications and databases to in corporate new business requirements.
• Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.
• Experience in Extraction, Transformation and Loading (ETL) process in SQL Server database, SQL Server 2012, 2015 and 2016 versions.
• Working with SQL server Job scheduling to execute Integration Services packages and send report to the client.
• Writing stored procedures, functions and creating indexes if necessary.
• Created different transformations for loading data into SQL database which includes (Derived column, Lookup, Data Conversion, Conditional Split, Merge, Merge Join, Union ALL)
• Optimizing the complex Stored Procedures and tuning Queries.
• Experienced in developing all types of reports like Tabular, Matrix, and charts and used various features like Drill down, Drill-through, Sub Reports, using SSRS.
• Used visualizations like Column Chart, Pie Chart, Slicers, Donut Charts, Line Chart and
• KPI’s.
• Full Life Cycle Experience in Model, Design, Development of Data warehouse/ETL/BI solutions.
• Hands on experience to automate the SSIS packages

TECHNICAL SKILLS

Languages: SQL, PL/SQL, T-SQL, MaxL, MDX,Core Java/J2EE, Shell Scripting, HTML Scripting

Operating System: Windows XP, WIN NT, Unix

Design Methodologies: SDLC, Waterfall, Agile and SCRUM

Databases: Oracle Database 10g/11g/12c, MS SQL Server 2008, 2012

Management Tools: JIRA, Rally

Version Control Tools: Clear Case, Star Team, TFS, Bitbucket

Engagement Experience: Applications Development, Data Integration, Data Warehouse, Data Mining, Data Visualization, Documentation, Testing, Configuration and Setup, Application Maintenance and Support

Other Tools: TOAD, SQL Developer, Microsoft Visual Studio, SQL Server Management Studio, SQL*Plus, SQL Loader, Teradata SQL Assistant, Tableau, Power BI, Oracle Data Integrator, Essbase Administration Services, Essbase Studio, Hyperion Planning, Eclipse Tool, J Developer, Microsoft Teams, Putty, Autosys, ITSM Tools

PROFESSIONAL EXPERIENCE

Confidential - Minneapolis MN

Business Intelligence - Senior Data Engineer

Responsibilities:

• Developing and implementing personalized client solutions using Business Intelligence and Cloud Database Technologies.
• Coordinated with the front-end design team to provide them with the necessary tables, views, stored procedures, packages, and the necessary insight into the data.
• Involved in the continuous enhancements and fixing of production problems.
• Performance testing and rewriting of production code/SQL statements & procedures performing badly, identified by database administrators.
• Creation of database objects liketables, views, materialized views, procedures, and packagesusing oracle tools likeToad, PL/SQL Developer,andSQL* plus.
• Partitionedthe fact tables andmaterialized viewsto enhance the performance.
• Createdindexes on the tables for faster retrieval of the data to enhance databaseperformance.
• Strong experience in writing large queries using with clause, rank and connect by concepts.Worked extensively on Ref Cursor, External Tables and Collections.
• Involved in data loading usingPL/SQLandSQL*Loadercalling UNIX scripts to download and manipulate files.
• PerformedSQL and PL/SQL tuningand Application tuning using various tools likeEXPLAIN PLAN, SQL*TRACE, TKPROFandAUTOTRACE.
• Extensively involved in usinghints to direct the optimizerto choose an optimumquery execution plan.
• UsedBulk Collectionsforbetter performanceand easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• CreatedPL/SQL scriptsto extract the data from the operational database into simple flat text files usingUTL FILEpackage.
• Implementing Agile Practices in SDLC (Software Development Life Cycle). Strong experience in using Jira tool.
• Advanced skills in creating Reports, Dashboard and perform Data Visualization using Tableau Desktop.
• Generated Tableau Dashboard with quick/context/global filters, parameters, and calculated fields on Tableau reports.
• Created Tableau Dashboards with interactive views, trends, and drill downs along with user level security.
• Designed and implemented data warehouse architecture for finance data warehouses. Subsequent data marts, extracts and reports were sourced from the architecture of conformed facts and dimensions.
• Working with different functional units to understand reporting needs and translate business needs into actionable reporting.
• Involved in administrative activities such as setting up users, security groups and access filters to set the security policy and to ensure maximum security.

Environment: Oracle PL/SQL, Hyperion Essbase, Hyperion Planning, Tableau, JIRA and MSSQL.

Confidential, Sanjose-CA

Power BI Business Intelligence Developer/Analyst

Responsibilities:

• Participated in end to end Project transition activities.
• Gather business requirements, collaborate with cross functional teams to achieve maximum customer satisfaction and precise outcome.
• Develop and implement various BI projects, apply ETL, use SQL to query database and PowerBI to visualize, and analyse the data.
• Build tables and views using SQL and SSMS to use for PowerBI.
• Develop data visualizations, including Reports, Dashboards, and Analysis in PowerBI to distribute data.
• Develop automatic scripts to provide executive teams and other important stakeholders with real-time data.
• Design scorecards and different dashboards with slicers utilizing Power BI.
• Analyse, design and develop Data Warehouse (Star Schema/ Snowflake dimensional data model).
• Implemented Power BI PowerPivot for data analysis by developing various aggregation and calculations.
• Leverage languages such as DAX, PowerQuery and SQL to effectively query large datasets.
• Extensively used SSIS transformations such as Lookup, Merge, Merge Join, Derived Column, Data conversion, Conditional Split and Aggregate for creating SSIS ETL Solution
• Develop complex SQL Queries using common table expressions (CTE), temporary tables to ETL process and Power BI reporting.
• Implemented OLAP Cubes, Snowflake, Facts, and Dimensions for providing summarized and aggregate views of large database sets.
• Efficiently identify and fill gaps in model datasets to increase data accuracy.
• Reverse engineer the backend ERP database and create documentation of other data science projects.
• Wrote T-SQL (DDL and DML) queries, Store Procedures and used them to build packages and handled slowly changing dimensions to maintain the history of the data.
• Created different data visualizations using Lines, Pies, Histograms, Maps, Scatter, and Bullets using Power BI.
• Wrote calculated columns, measures in Power BI desktop to show good data analysis techniques.Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.
• Developed dashboards and ad-hoc reports using MS Power BI and SSRS for the senior management team for analysis.
• Using SSIS Package identified the Up-streams and imported the required tables into intake-database, Stored Procedures are created in the staging database using the intake-database tables, views.
• Created complex SQL stored procedures, Triggers, Functions, Views, Indexes in SQL Server.
• Built MDX queries and Data Mining Expression (DMX) queries for Analysis Services also used Snowflake/ Star Schema.
• Collaborated with analysts and department leaders to design, build and customize reports using SQL Server, and Power BI.
• Worked on all types of transformations that are available in Power BI query editor.
• Worked on all kind of reportssuch as Yearly, Quarterly, Monthly, and Daily.
• Created Reports using Charts, Gauges, Tables, matrix visuals.
• Created Drill Down Reports, Drill Through Report by Region.
• Designed and implemented dashboards to analyse the Key Performance Indicator metrics over the time using various Power BI.
• Bi-weekly Power Point presentation to the business users about the newly developed Power BI reports and changes made to the existing reports.
• Explore data in a Variety of ways and across multiple visualizations using Power BI.
• Environment: Windows, Power BI, Power Pivot, SQL, ETL, Star Schema/ Snowflake, DWH, Power View, Power Map, DAX, MDX, DMX, PowerQuery, SSIS, OLAP, T-SQL (DDL, DML), SSRS, Windows, Agile/ Scrum SSAS

Confidential

Sr. Software Engineer

Responsibilities:

• Gathered business requirements from the customer and collaborated with offshore teams for the delivery of the artifacts in time.
• Translated business requirements into technical specifications to build the Enterprise Data Warehouse.
• Good knowledge of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables using Analysis Services.
• Creation of database objects liketables, views, materialized views, procedures, and packagesusing oracle tools likeToad, PL/SQL Developer,andSQL* plus.
• Partitionedthe fact tables andmaterialized viewsto enhance the performance.
• Createdindexes on the tables for faster retrieval of the data to enhance databaseperformance.
• Strong experience in writing large queries using with clause, rank and connect by concepts.Worked extensively on Ref Cursor, External Tables and Collections.
• Involved in data loading usingPL/SQLandSQL*Loadercalling UNIX scripts to download and manipulate files.
• PerformedSQL and PL/SQL tuningand Application tuning using various tools likeEXPLAIN PLAN, SQL*TRACE, TKPROFandAUTOTRACE.
• Extensive experience in using analytic functions, application contexts, hierarchical queries and implemented them in many ETL packages.
• Used ODI Designer to develop complex interfaces (mappings) to load the data from the various sources into dimensions and facts.
• Used Topology Manager to define data servers and physical schemas for various sources and target databases.
• Experience in creation and maintenance of finance, ledger, planning, and reporting cubes across Block Storage (BSO) and Aggregate Storage (ASO).
• Proficient in Designing and developing Essbase cubes with excellent balance of dense and sparse dimensions, developed various OLAP Models & Meta-Outlines across BSO and ASO.
• Expertise in administrative tasks of Essbase: Managing applications and databases, Essbase architecture, data and dimension loading, Calc Scripts, Business Rules, MaxL, MDX Querying, Report Scripting, User security and Performance tuning.
• Involved in implementation, migration, and validation for Hyperion Essbase upgrades.
• Developed UNIX scripts for transmitting files from secure server to customer specified server using various FTP batch processes.
• Implemented code check-in/check-out and managed multiple versions of complicated code within TFS.
• Hands on experience in using Toad, SQL Developer, Microsoft Visual Studio, ODI, Essbase Administration Services, Essbase Studio, OBIEE, Excel Addin.

Environment: Oracle PL/SQL, Hyperion Essbase, Hyperion Planning, Oracle Data Integrator, MSSQL Data Tools, RALLY.

Confidential

Data Warehouse Developer

Responsibilities:

• Aided in the design and development of the logical and physical data models, business rules and data mapping for the Enterprise Data Warehouse system.
• Extensive experience in extraction, transformation, and loading (ETL) of data directly from different heterogeneous source systems like flat files, Excel, Oracle, SQL Server.
• Creation of database objects liketables, views, materialized views, procedures, and packagesusing oracle tools likeToad, PL/SQL Developer,andSQL* plus.
• Partitionedthe fact tables andmaterialized viewsto enhance the performance.
• Createdindexes on the tables for faster retrieval of the data to enhance databaseperformance.
• Strong experience in writing large queries using with clause, rank and connect by concepts.Worked extensively on Ref Cursor, External Tables and Collections.
• Involved in data loading usingPL/SQLandSQL*Loadercalling UNIX scripts to download and manipulate files.
• PerformedSQL and PL/SQL tuningand Application tuning using various tools likeEXPLAIN PLAN, SQL*TRACE, TKPROFandAUTOTRACE.
• Experience in using advanced PL/SQL concepts like Global temporary tables, bulk loading, data partitioning to load the data in Oracle Database.
• Written dynamic sql statements and user defined exceptions in stored procedures.
• Developed reconciliation reports in Excel to effectively monitor the data movement.
• Performance Tuning using HINTS to improve performance of the Oracle database.
• Hands on experience on Toad, SQL Developer, Microsoft Visual Studio, Oracle Data Integrator, Putty and Autosys tools.

Environment: Oracle PL/SQL, Hyperion Essbase, Hyperion Planning, Oracle Data Integrator, MSSQL Data Tools

Confidential

Oracle Developer

Responsibilities:

• Managed requirements gathering, system analysis and design, documentation, coding, testing, implementation.
• Created new custom reports, forms and modified existing reports according to the requirement using Oracle Forms 10g/9i/6i and Oracle Reports 10g/9i/6i.
• Good knowledge in creating master-detail blocks, form triggers, system variables, multiple form applications, menus, alerts and LOV's.
• Good expertise in Database scripting. Creation of database objects liketables, views, materialized views, procedures, and packagesusing oracle tools likeToad, PL/SQL Developer,andSQL* plus.
• Partitionedthe fact tables andmaterialized viewsto enhance the performance.
• Createdindexes on the tables for faster retrieval of the data to enhance databaseperformance.
• Strong experience in writing large queries using with clause, rank and connect by concepts.Worked extensively on Ref Cursor, External Tables and Collections.
• Worked on IBM ClearCase to stage the source code and manage it throughout the SDLC.
• Hands on experience in Toad, Sql Developer, JDeveloper and ITSM tools.

Environment: Oracle PL/SQL, Oracle E-Business Suite CRM, Oracle Forms, Oracle Reports and Oracle Workflows