TECHNOLOGY:

• MS Visual Studio

• Oracle
• SQL Server
• MS Access

• SSIS
• MS Office Suite

• SQL

• Tableau
• OBIEE
• MS Excel
• SSRS

PROFESSIONAL EXPERIENCE:

Confidential, Minneapolis, MN

Apps Systems Engineer/Obiee Developer

Responsibilities:

• Providing consulting and oversight to application development for data solutions and usage of tools and capabilities for effective data management.
• Responsible for providing and driving direction for key technology, best practices, develop common patterns/components and establish repeatable, consistent and reusable solutions across development team(s)
• Works closely with business and technical leadership, serving as an expert resource for the technology domain, bringing forth opportunities to better the business and influencing decisions regarding technology changes.
• Coordinating/working extensively with various business and technical partners.
• Develop new documentation, departmental technical procedures and user guides, allocate and manage resources and manages the work of less experienced staff.
• Documenting solution design documents & patterns catalog
• Partner with other developers to review the business requirements and to determine whether an existing solution/pattern can be leveraged or need to create new.
• Participate in FSD review to ensure compliance with application architecture and Solution Standards/Best Practices
• Expert in presenting the designs to business and in getting signoff's with some report mockups (without actual developing the reports)
• Designed the metadata (repository) which involves Physical, BMM and the Presentation Layers. Designed hierarchies to support level based metric/navigation/drill - down, created functionalities in the BMM layer in order to suffice business needs.
• Responsible for performance tuning of the existing subject areas - with the help of aggregate tables, caching strategy, indexes, view and other techniques
• Developed Ad-hoc and standard Reports/Dashboards with different Analytics Views (Drill-Down, Cascading Style Sheets, Pivot Table, Chart, Column Selector and Tabular with prompts, global and local Filters), contextual navigation, business rules with user identity and roles within OBIEE.
• Analyzed and validated the business model in OBIEE Administration Tool by performing consistency check, validating logical source tables, logical columns, and also validating repository level calculations done in the business model layer.
• Creation of page/dashboard/reports prompts in UI to provide dynamic filter condition to the Business user.
• Responsible for Managing OBIEE technical, infrastructure related queries from client and offshore team and guiding the development team.

Confidential, League City, TX

Tableau/OBIEE Developer (Business Intelligence Analyst)

Responsibilities:

• Creating the Tableau dashboards with relational and multi-dimensional databases including Oracle, SQL, MS Access, and Excel at gathering and manipulating data.
• Good knowledge of various reporting objects like Facts, Attributes, Hierarchies, Transformations, Filters, Prompts, Actions, Calculated fields, Sets, Groups, Parameters, etc., in Tableau
• Design and Deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parametererized using Tableau
• End to End experience in designing and deploying data visualizations using Tableau
• Analysis, design, development, deployment, and support of "Small to Large" project efforts for dashboards, reports, and integration
• Expertise in building Repositories, developing Subject Areas, and applying Security at object and data level in Administration Tool.
• Conducted GAP analysis in requirement analysis. Ensured that the GAPs were communicated with the team and business user. Documented the GAPs in Functional Requirement Document.
• Expert in creation and customization of the repository using OBIEE Administration Tool.
• Expertise in analyzing and designing customized analytical reports and creating Interactive Dashboards with drill-down capabilities using OBIEE Answers.
• Expertise in creating complex reports in Answers using various views.
• Good understanding of object oriented programming principles, SQL, standardized markup languages and a strong customer focus
• Conducted and facilitated UAT sessions with business users. Ensured that all the issues are addressed.
• Ensuring quality of work output by displaying a keen attention to detail

Environment: OBIEE, Oracle EBS (AP. AR, GL), Windows XP, Windows 10, HP ALM, Microsoft Word, ODI, Tableau

Confidential, League City, TX

SQL Report Writer/ Data Analyst

Responsibilities:

• Generated daily, weekly, monthly, subscription reports for the analysis of managers & end-users using SSRS
• Develop ad hoc and complex SQL script to extract desired data and metrics
• Wrote user requirement documents, created technical specs and design documents for various projects.
• Generated complex T-SQL queries, sub-queries, co-related sub queries, dynamic SQL queries etc. Programming in SQL server using stored procedures, triggers, views and user-defined functions.
• Involved in query tuning by creating cluster and non-cluster indexes on tables, and used index tuning wizard
• Worked with several control flow tasks, data flow tasks, transformations (derived column, lookup, merge join, conditional split, slowly changing dimensions, data conversion etc.) in SSIS packages.
• Build effective queries for high performance reporting and rendered them to html, xml, PDF, MS word and excel formats using SSRS (2015)
• Involved in developing parameterized reports using single values, multi values and cascading parameters.
• Provide internal customer service to various departments by translating business needs into technical information to non-technical audiences and translating business needs into technical specifications
• Interact directly with internal customers to develop report parameters, suggesting appropriate content fields and design where the appropriate
• Participated in the installation of SQL server. Installed SQL server enterprise manager tools using SQL Setup
• Develop and maintain business procedures, work instructions, and process flow mapping
• Design and implement data collection and compilation from multiple data systems to meet business needs
• Design reports in a sensible and presentable form
• Perform analysis of data sources and processes to ensure data integrity, completeness and accuracy
• Independently track down data elements and relationships between multiple disparate data sets.
• Optimize and improve performance and design of reports when necessary
• Provide reporting system administrative and configuration system (non-network).
• Monitor and verify accuracy of data submission to State and Authority Agency.

Confidential, Fort Worth, TX

Obiee Developer / Data Analyst

Responsibilities:

• Obtained business requirements from functional managers and end users through interviews and operation observation
• Worked closely with DBAs, Analysts and other Developers to define requirements, mappings, gap analysis and business transformation rules
• Having good experience in Data Warehousing concepts such as Dimensional Modeling, Star Schema, Snowflake Schema, Data Marts, Dimensions and Facts
• Experience in Full life Cycle Implementation of Data Warehouse
• Wrote business requirement documents, functional and technical specification documents for data warehouse development, ETL/ELT (Extract, Transform, Load) development, building metadata repository and creation of reports and dashboards
• Created dimensions, dimension hierarchies, aggregates and keys in the BMM layer
• Used the expression builder utility to create new logical columns in the BMM layer and created various calculation measures
• Built repositories from scratch performed business modeling and mapping, created variables, and sent them for testing when the Administrator deployed them to production.
• Created drillable and guided navigation reports based on business requirements, dashboards, Agents, prompts, and set permissions
• Worked on various reports/Dashboards in BI Answers with different analytics views (drill down, dynamic narrative views, charts, pivot tables, column selector and local filters
• Worked extensively on performance tuning including creating aggregate tables, caching and event polling tables
• Created groups in the repository and added users to the groups and granted privileges explicitly through group inheritance
• Took part in the preparation of project plans and user acceptance testing
• Took part in the meetings with Sr. Business Analysts and managers and understood various process plans, business processes, and functionality in detail
• Train End users and pilot users about OBIEE tools
• Adding calculated measures that included Time Series calculations like AGO and To Date, and Period Rolling.
• Deploying the RPD and catalogue from Development to Production
• Provided support to other team members on Repository, Reports and Dashboards Issues.
• Created test data and imported into schema tables.
• Scheduled reports delivered to users' emails and dashboards.
• IT Production Support
• Extensive knowledge in Remedy for IT production Support

Confidential, Irving, TX

Obiee Developer

Responsibilities:

• Closely worked with users, Business Analyst, Program manager to get requirements and clarifications about new changes to the current reports, business objectives and user requirements
• Created different lookup reports like Account lookup, Single Deal look up reports for debugging issues for manager, Analyst and users as well
• Created connection pools, Physical tables, defined joins and implement authorizations in the physical layer of the repository.
• Used the expression builder utility to create new logical columns in the BMM layer and create various calculation measures.
• Created Catalog Groups and set permissions for items in the presentation catalog and privileges and rights to users and groups
• Worked closely with all levels of user community, technical staff and application development software staff to ensure successful project implementation
• Designed and developed the OBIEE Metadata Repository using OBIEE Server Admin tool by importing the required objects (Dimensions, Facts & Aggregates) with Referential Integrity constraints into Physical layer using connection pool, developing multiple dimensions (Drill-down Hierarchies) & Logical & Facts. Measure objects in Business Model Layer, and creating Presentation Catalog in Presentation Layer
• Developed Dashboards reports for Core Banking system, Accounting, Audit, Risk, Controlling, Derivatives and other different departments of Banking
• Contribute to the technical architectural planning, data modeling, process flow documentation and the design & development
• Enhance the functionality of the reports and the dashboards and also made sure reports run on time and data is ready for business users
• Created Action Links generated navigational reports with conditional formatting of columns
• Created groups for different users to provide suitable securities for different dashboards and reports
• Designed layout for different dashboards and reports
• Managed day-to-day RPD, Scheduler & agents
• Use the expression builder utility to create new logical columns in the BMM layer and create various calculation measures
• Trained End users and pilot users about OBIEE tools
• Created reports in BI Publisher and sending those reports to users using bursting definitions
• Analyzed data issues reported by production team and provided solutions.
• Created Catalog Groups and set permissions for items in the presentation catalog and privileges and rights to users and groups
• Performed and document best practices and standards for the RPD, report development and security
• Worked with manager to ensure that assigned work is completed efficiently, meets business requirements, stays within scope, and is delivered on time
• IT Production Support
• Extensive knowledge in Remedy for IT production Support