Sr. Business Systems Analyst Resume
O Fallon, MO
SUMMARY
- Around 9 years of experience in Design, Development, Integration, Implementation and Maintenance of Business Intelligence and Data Warehousing Platforms.
- Experience working on Tableau 2020.x/2019.x/2018.x/10.x/9.x tools includes Tableau Desktop, Tableau Reader, Tableau Public, and Tableau Server.
- Skilled Tableau front - end BI developer integrated with multiple back-end databases and other various data sources.
- Experience in Business Writing, Business messaging, Business Analysis and Testing various complex data driven methodologies including rendering the ACORD Forms for commercial lines integration with Documentum.
- Insurance experience includes Personal Property Casualty and Commercial Automobile Product knowledge, Reinsurance for Commercial Property Casualty, Group and Life Insurance Systems, Health Insurance, Auto Insurance Home Owner Insurance and Crop Insurance.
- Extensive knowledge in various reporting objects such as Dimensions, Measures, Hierarchies, Filters, Actions, Calculated Fields, Sets, Groups, Bins, and Parameters etc.
- Experience in creating workbooks and dashboards using Tableau that includes tools like Tableau Desktop, Tableau Server, and Tableau Reader.
- Excellent understanding of Business Requirements Gathering, Translating Requirements into Specifications and Application Design.
- Used the Web Data Connector JavaScript library for enabling the app to interface with the Tableau API
- Developed dashboards with rich Graphic visualizations, Drill Down and Drop-down menu options, parameterized using Tableau.
- Experience in installing, upgrading, and administrating Alteryx server and Tableau Servers.
- Proficient in migrating workbooks between different environments in Tableau server using Tab cmd.
- Experience in Tableau Projects (involved in the complete lifecycle from requirement gathering, data modeling - scripting, developing, and testing dashboards using Tableau).
- Experience with utilizing scripting languages to leverage Tableau's APIs (JavaScript API, Data Extract API, REST API).
- Create required shell or python scripts for data push from Tableau.
- Design and maintain databases using Python and developed Python-based API (RESTful Web Service).
- Writing python script to automate the data from Teradata to cloud Environment.
- Figured build failure which is due using multiple data frames used by developers & override those by adding test cases.
- Conducted meeting with business stakeholders, clients and director level members for requirement gatherings and presented various solutions using best practices.
- Developed entire frontend and backend modules using Python on Django Web Framework.
- Experience with utilizing Tableau Prep (2018.1.x) for fast and efficient data cleansing and creating hyper extracts.
- Experience in using Viz in Tooltip, Tableau Bridge, Nested Sorting and Dashboard Grid.
- Good understanding in AWS solutions like EC2, S3, RDS, EBS, Elastic Load Balancer, Auto scaling groups.
- Worked on AWS EC2 Instances Provisioning, VPC setup, Auto Scaling for availability of EC2Instances and availability of applications.
- Having good Knowledge ofWeb services, XML Data Mapping, Filed mapping for source to target systems, Data analysis, Data processing for multiple interfaces, Reports, XSLT, WPF, WWF, WCF, LINQ, KML, SharePoint, JavaScript, JAVA.
- Understanding ofSOA, WebService, HTTP, XSD, XSLTandJSON.
- In depth knowledge of SDLC phases such as Requirement analysis, design, development, implementation, deployment, and maintenance with strong understanding of methodologies like Waterfall, Iterative& Incremental, Evolutionary prototyping and Agile.
- Extensive knowledge in dealing with Relational Database Management Systems, including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers, Cursors.
- Used R functions and models in Tableau by creating new calculated fields that dynamically invoke the R engine and pass values to R.
- Was able to access any R package or function that has been installed in an R server and take advantage of all the visualization capabilities in Tableau to further analyze and understand data without having to manipulate data in R.
- Leveraged tools like JIRA, JIRA Zephyr for Issue tracking, User Stories, Test Cases and Traceability Matrix.
- Possess strong knowledge of database management in writing SQL queries using complex joins, grouping, aggregation, nested sub queries, and resolving key performance issues.
- Excellent interpersonal and customer relational skills. Proven communication, presentation skills and leadership qualities.
- Extensive experience in implementation, upgrade and customization of Oracle e - Business Suite Applications. This includes system study, design, Analysis, post implementation maintenance and support of Oracle EBS. (R12.1.3).
- Ability to handle multiple tasks and work independently as well as in a team.
- Created a Star Schema (Facts & Dimensions) using Extract, Transform, Load process (SSIS).
- Developed & loaded a dimensional model Data warehouse which is useful for OLAP purposes.
- Wrote complex SQL queries and generated different reports and graphs.
TECHNICAL SKILLS
Business Intelligence: Tableau7.x, 8.x, 9.x, 10.x, 2018. Tableau Desktop, Tableau Reader, Tableau Server, Tableau Online, Tableau Public, Power BI Desktop, OBIEE, Alteryx, Zephyr
Languages: Oracle SQL, SQL-queries, C, C++, C#, PL/SQL
Other ETL/Reporting Tools: SSIS, DTS, RStudio, Microsoft Azure ML, JMP, SQL Server Reporting Services (SSRS), Crystal Reports, Zephyr
Databases: Oracle 8i/9i/10g/11g, Oracle ebs, SQL Server 2000/2005/2008 , DB2, MySQL
Operating Systems: Windows 98/XP/7, Vista,7, Unix, Linux
Tools: Toad, SQL Plus, SQL Developer, SQL Server Management Studio, SQL Workbench, SAS/ES, Anaconda, Oracle, SQL Server
FTP Tools: FileZilla, CuteFTP, Putty, FTP Commander
Applications: Advanced MS Excel, MS Visio, MS Access, Adobe Dreamweaver, Microsoft Office, XML, Javascript
PROFESSIONAL EXPERIENCE
Confidential, O'Fallon, MO
Sr. Business Systems Analyst
Responsibilities:
- Scrupulously involved with AML Investigators, Analysts, and Auditors in identifying the process flows and improving the workflow to develop a Case Management Tool.
- Working with Business/UX Producers/AEM architects/Experience Leads/APO's on Component decomposition for various experiences in KP.org.
- Worked on requirement for AEM integration with Adobe Test and Target for Confidential.
- Maintained compliances by studying and ensuring that the organization’s regulations, policies, procedures comply with work including Bank Secrecy Act(BSA), Anti Money laundering (AML), Know your Customer(KYC), Enhanced Due Diligence(EDD), Customer Due Diligence(CDD),SOX Compliance and Customer Identification Program(CIP).
- User-friendly UI Dashboardthat enablesusers to real- time view of collateral positions, margin calls discrepancies, collateral surplus, collateral deficit, daily Mark-to-Market, and transactions.
- The proposed system would calculate excess/deficit of collateral in order to mitigate credit default risk and generate reports mainly for internal credit risk monitoring.
- Collaborated with the Project Manager and created Project Management Plan, Project Charter, WBS, BRD and FRD for the project.
- Strong exposure in store and process credit card / Debit Card accounts and process transactions (Visa, Confidential, American Express, Europay, private label transactions).
- Having strong domain knowledge in application catering to banking/Credit cards / mortgage business. Familiar with full life cycle of credit cards applications for different banking systems.
- Assisted data analysts to develop logical data models, source data cleansing and data profiling. Essentially applied business rules in the transform phase.
- Focused on the SAR auto-filing process and continuous improvement of core metrics through automation and workflow.
- Followed ITIL 4’s 9 guiding principles along with focusing on feedback and managing risks, standards and governance.
- Performed GAP Analysis reviewing the existing As-Is process and recommending possible areas of improvements in the future To-Be system.
- Facilitated JAD sessions, interviews with SMEs & PO to better understand requirements of AML Process starting from false positives and alerts to filing the SAR reports.
- Conducted market research on features that could add weightage in the future and can be used by the AML Investigators.
- Provided operational oversight and subject matter expertise on payment gateway processing, contribute thought leadership to overall product strategies.
- Assigned Gateway Services to remain in compliance with other network rules and pricing changes, manage network related changes.
- Involved in working on interfaces, xml data mapping, web services, integration on multiple interfaces.
- Wrote user Stories, set acceptance criteria, and checked if they passed the criteria of INVEST rule.
- Used the KANBAN board for the visual flow of the process.
- Used Zephyr to provide multiple deployments inn JIRA cloud and data center.
- Assisted in doing test management for JIRA using Zephyr.
- New report programs for direct debit, direct credit transactions have been developed. New interface developed to route all Automatic Clearing House (ACH) transactions into the existing system.
- Created UML diagrams for Use Case, Sequence, Activity diagrams, Process flow diagrams by leveraging MS Visio.
- Created Data Mapping artifacts for the source and target data fields that are being populated automatically by the system like alerts, tables, SARs, CTRs, lists, transaction reports, KYC information, and applying transformation logic where required and was responsible for assessing the cross impacts as a part of project support.
- Worked as Oracle R12 EBS Functional Consultant with expertise implementing, upgrading and supporting OAB.Procure to Pay support for Go to Live group and Oracle EBS End Users.
- Implementing the OBIEE dashboards and KPI’s as per the requirements.
- Installed and configured OBIEE 11g, BI Apps 7.9.6.4
- Designed and customized OBIEE rpd as per HRMS and Financial modules.
- Integrated OBIEE11g, Informatica 901, DAC service components, High availability architecture, custom development.
- Executed SQL queries by leveraging MySQL on large data sets for exploratory analysis, research analysis, and extracting data and ad-hoc reporting using SSRS.
- Fine-tuned the stored procedures in PL/SQL for optimum performance that saved the users a lot of delay time in accessing data from the front end.
- Developed packages in PL/SQL that implemented the company's business rules on the Electronic Data Interchange (EDI) Project.
- Programmed in Unix Shell scripts to run the PL/SQL packages and schedule them.
- Used Balsamiq mockups for making high and low fidelity wireframes and mockups for features like Link Analysis and visualization tools being implemented in the application.
- Assisted in SOA by determining along with the team how the best requirements and Business Rules can be crafted and grouped for maximum efficiency and visibility during SOA.
- Instigated communication using Rest with data type JSON and then documented API and web service requests and responses using Postman.
- New Payment method options are introduced into Payment application for Credit management Systems.
- New interface program (file path) has been introduces for the transactions coming from external (Ex Confidential /Visa network) source into Vision Plus System.
- Used FIX and SWIFT protocols for many trading activities and trade settlement processes.
- Acted as a through leader for data-informed initiatives and piloted the team’s direction overall.
- Create invoices to bill for the company’s services, meets all billing deadlines and analyze all billing procedures.
- Review company’s financial transactions, sales contract, and business practices.
- Identified revenue control risk and implemented revenue control plans.
- Knowledge in Agile techniques such as Test-Driven Development (TDD), Continuous Integration and assisted QA Team in testing the application during Smoke Testing, Black Box Testing, Regression and User Acceptance Testing and improving, altering, running Test Scripts using Jira-Zephyr, created training, and testing material and documenting.
- Collaborate with IT, Order Management Teams, System Improvement Teams and Change Management Teams to ensure the proper flow of user issues.
- Develop and manage the integration of various ERP systems with Oracle EBS.
- Used Confluence as a collaboration tool for Knowledge sharing, Artifacts sharing, and as a communication tool.
- Acted as help desk for issues and queries for Charles River, Fidessa and Black Mountain Everest.
- Primary responsibilities included functional and technical support for Oracle GL, PA, AR, AP, Inventory, Discoverer Administration, Fixed Assets, and Cash Management.
- Used Excel VBA for creating Macros and automating Excel tasks like Project Status Reporting.
- Leveraged Tableau, V-lookups and Pivot Tables, VBA for ad-hoc reporting, automating Project Status and get insights from data for business needs.
- Reviewed test scripts for each EBS module and make improvement for better test experience.
- Worked along with the business leaders and management in determining the system recovery priorities, dependencies, and artifact them along with prioritizing the recovery efforts.
- Documented an ERT team and their roles and responsibilities as they handle the disaster recovery.
- Worked along with ITIL specialist to create, deliver and Support along with driving the stakeholder value by following the ITIL framework to create management standards.
Environment: Agile (Scrum), JIRAv7.0, MS Visio, OBIEE 11g, ODI 11g, Discoverer, Oracle DB, Oracle 11G, 10G Balsamiq Mockups, Tableau 10.0, Postman v4.1.1, MySQL.
Confidential, Scottsdale, AZ
BI Consultant/ Business analyst
Responsibilities:
- Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
- Created Relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections, and in-memory in both tableau and excel.
- Worked on Commercial lines Property and Casualty Insurance including both policy and claim processing and reinsurance.
- Created customized reports using various chart types like, text tables, bar, pie, tree maps, heat maps, line charts, pivot tables, combination charts in excel and tableau.
- Analyzed and documented Reinsurance Claims, Billing Collections, and Accounting modules of the application.
- Over 6 Months experience in Adobe Test and Target / AEM Target.
- Communicate with Customer Service on ACORD Forms design and other technical problems.
- Worked on motion chart, Bubble chart, drill down analysis using tableau desktop for Amazon.
- Involved in created stored procedures, views, and custom SQL queries to import data from SQL server to tableau.
- SAP FI submodules (GL, AP, AR & AA) knowledge in CO sub modules like CEA, CC, IO & PCA and integration with FI. Knowledge and experience in migration of different FICO objects like GR/IR, Asset, AR & AP (master data and transactional data) including cutover. Working knowledge in integration of FI with other modules like MM, PP & SD.
- Expertise in Business Intelligence Applications using Siebel Analytics / Oracle Business Intelligence OBIEE/OBIA in Marketing, Sales, Procurement modules.
- Worked closely with Users, Developers and Administrators to resolve ongoing Production Problems by reviewing design changes made to production systems and made corresponding changes to OBIEE Repository.
- Involved in migrating to the latest version of Oracle EBS suite - R12.1.3 from 11.5.10.2
- Involved in configuration of Oracle EBS R12 Financial Modules on CRP2, SIT, UAT Instances & Production Instance.
- Supported the Equity and Fixed Income Trading desks. Worked with business users and stakeholders to define needed business requirements, budgeting and the project scope. Developed UAT test plans, use cases and test scenarios for front to back testing. Monitored the end-to-end lifecycle operation for execution, settlement, custody and post settlement process.
- Working with Business/UX Producers/AEM architects/Experience Leads/APO’s on component decomposition for various experiences in KP.org.
- Writing python script to automate the data from Teradata to cloud Environment.
- Requirements of migrating of Content from legacy system toAdobe AEMand functionalities including Multi-site management and multi channel management and Digital Asset Management.
- Worked on workflows, scalability and capacity panning requirements for Adobe AEM authors and publishers as Confidential is the largest retail website in Canada.
- Worked on requirement for AEM integration with Adobe Test and Target for Confidential ’s
- Used the Web Data Connector JavaScript library for enabling the app to interface with the Tableau API.
- Used JavaScript API for integration of Tableau dashboards and portal environments.
- Conducted meeting with business stakeholders, clients and director level members for requirement gatherings and presented various solutions using best practices.
- D3.JS JavaScript library integration with Tableau dashboards to get additional visual functionality in Tableau workbooks.
- Wrote conversion document (CV60) to convert data from legacy system into Oracle EBS 11i system.
- Customized standard Oracle Applications (EBS) reports and developed custom reports on financials (AR, AP, GL, FA) modules.
- Developed entire frontend and backend modules using Python on Django Web Framework.
- Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.
- Tested reports and uploaded tableau dashboards on to server and provided production support for tableau users.
- Created and scheduled Alteryx workflows.
- Experience in integrating Alteryx and tableau, publishing data extracts from Alteryx to tableau server, Pulling data from Alteryx App on server though Web data connector into tableau Desktop.
- Experience in working with unstructured data developing workflows in Alteryx Designer with documentation and implementation of the processed data.
- Data Manipulation and Extraction using Alteryx from various data sources, which in turn is used to feed data into Tableau.
- Translated business logic and rules from the existing system (SQL) to Alteryx.
- Performed ETL and data staging from multiple data sources using Alteryx.
- Ability to work quickly and under tight delivery deadlines with focus on details.
- Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
- Defined and created procedures to install Tableau desktop in silent mode and best practices for Tableau report development.
- Provided fixed income financial solutions to financial advisors.
- Created Data Integrator mappings to load the data warehouse, the mappings involved extensive use of simple and complex transformations like Key Generator, SQL Query Transform, Table Comparison, Case, Validation, Merge, lookup etc. in Data flows.
- Fine-tuned the existing PL/ SQL procedures for optimum performance that helped the company serve its users effectively and efficiently.
- Wrote PL/SQL packages to pull data from mainframe and legacy applications to populate the custom databases.
- Created Metrics, Analytics, Rules, Goals for the Corporate Dashboard.
- Created mockup dashboards and presented to the higher-level end users to have them a look and feel of the dashboards.
- Develop and maintain reporting and analytical tools, including Business Objects.
Environment: Tableau Server, Tableau Desktop, Acord, Reinsurance, ETL, SQL Server, JavaScript, Python, Django, Teradata, Oracle 11G, 10G, OBIEE 10.1.3.2/ 10.1.3.3 / 10.1.3.4/11 g
Confidential - San Jose, CA
Business Intelligence/Power BI Developer
Responsibilities:
- Interacting with business stakeholders to understand their decision-making parameters, analyzing the available data to build Tableau Dashboards, and managing the delivery.
- Provided BSC to the management analyzing KPI from Financial, Customer, Internal process.
- Embedded live dashboards on PowerPoint presentations, keeping the slides always updated.
- Delivered dashboards tracking viewership, HUT and Advertising sales.
- Developed Dashboards and Reports with Excel, SQL Server, SharePoint List and Report Server data sources usingPower BI Service Desktop tool.
- EmbeddedPower BIreports on SharePoint portal page and managed access of reports and data for individual users using Roles.
- Project Monitored performance and optimized SQL queries for maximum efficiency.
- Responsible for Creating and Modifying T-SQL stored procedures/triggers for validating the integrity of the data.
- Created indexed views, and appropriate indexes to reduce the running time for complex queries.
- Participated in gathering User Requirements and System Specifications.
- Responsible for monitoring Cognos software and logging statistical results.
- Developed presentations for personnel on Cognos and its various business applications.
- Responsible for creating weekly and monthly reports for management based on Cognos Data.
- Participated in regular Technical Reviews, Defect review and walkthrough meetings with important project & business stakeholders throughout the project life cycle.
- Worked on Azure B2C and AWS instances for setting up authentication and integration between the applications.
- Developed Stored Procedures, Functions, Packages and SQL Scripts using MSSQL.
- Designed and developed various SSIS packages (ETL) to extract and transform data and involved in Scheduling SSIS Packages.
- Created SSIS Packages/projects to move data from source to destination by using Visual Studio 2012
- Developed and reviewed custom SQL queries with use of joins clauses (inner, left, right, full) in Tableau desktop to validate and reconcile data.
- Worked with PL/SQL to create tables, create database constraints and load data.
- Created various complex SQL Queries, Stored Procedures, CLR Procedures, Views, Cursors and User Defined Functions to implement the business logic.
- Analyzed the consumer market, latest trends, new technologies, worked on social media sites to do the market survey, and designed the solution to fit B2 and B2C consumer markets, worked on Digital asset transcoding, media asset management.
- Identified patterns between variables for churn prediction using Python.
- Worked on REST API to automate many Server administration tasks.
- Participated in regular Technical Reviews, Defect review and walkthrough meetings with important project & business stakeholders throughout the project life cycle.
- Worked on Azure B2C and AWS instances for setting up authentication and integration between the applications.
- Developed Stored Procedures, Functions, Packages and SQL Scripts using MSSQL.
- Designed and developed various SSIS packages (ETL) to extract and transform data and involved in Scheduling SSIS Packages.
- Created SSIS Packages/projects to move data from source to destination by using Visual Studio 2012
- Developed and reviewed custom SQL queries with use of joins clauses (inner, left, right, full) in Tableau desktop to validate and reconcile data.
- Worked with PL/SQL to create tables, create database constraints and load data.
- Created various complex SQL Queries, Stored Procedures, CLR Procedures, Views, Cursors and User Defined Functions to implement the business logic.
Environment: Power BI Desktop, Oracle DB, MySQL Server, Microsoft Office
Confidential
Business Intelligence (BI)/ Business Analyst
Responsibilities:
- Extensively involved in the modeling and development of Reporting Data Warehousing System.
- Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process.
- Reviewed the data model and reporting requirements for Cognos Reports with the Data warehouse/ETL and Reporting team.
- Lead Business Intelligence reports development efforts by working closely with Microstrategy, Teradata, and ETL teams
- Excellent knowledge of Health Insurance Portability Accountability ActHIPAAstandards,Electronic Data Interchange EDI,and Implementation and knowledge ofHIPAA code sets, ICD-9, ICD-10 coding, and HL7.
- Extensive experience withBusiness Process ManagementBPM system.
- Interacted with other Business Analysts for designing and implementation of Use Cases and Test Plans.
- Gathered requirements from JAD/JAR sections with developers and business clients.
- Designed the business requirement collection approach based on the project scope and SDLC methodology.
- Designs and develops the logical and physical data models to support the Data Marts and the Data Warehouse.
- Expert on OBIEE 11G reports design and development including RPD, Metadata development with OBIEE 11G Map viewer OBIEE Publisher with HIPPA rules.
- Converted CSVflat files into HL7 messages.
- Involved in formatting data stores and generate UML diagrams of logical and physical data.
- Developed project plans and managed project scope.
- Experience in designing and development of Tableau visualization solutions and Created Business requirement documents and plans for creating dashboards.
- Understand, implement, and automate security controls, governance processes, and compliance validation.
- Consulted on Tableau server performance enhancements; upgrades from different versions and server reconfiguration based on workbook complexity and data extraction.
- Customized the Tableau landing page with site listing as icons and descriptions.
- Constructed the reports page for internal strategy group with standardized custom right and left side sections within Tableau.
- Worked with SEI Levels 2 3 CM, CMM/SQA, SCM, Project control, Project Tracking. ISO 9002 QA.
- Used Tableau API to customize the views, selects, filters, date, and time.
- Generated tableau dashboards with combination charts for clear understanding.
- Implement systems that are highly available, scalable, and self-healing on the AWS platform.
- Created lot of custom reports for using complex stored procedures and Crystal reports.
- Created Standard, Crosstab and Sub reports.
- Created Batch Stored Procedures in the Report Scheduler according to the monthly, weekly, or daily.
- Involved in ETL architecture enhancements to increase the performance using query optimizer.
- Generated Reports using Global Variables, Expressions and Functions for the reports.
- Deployed the generated reports directly on the client's workstation.
- Created action filters, parameters, and calculated sets for preparing dashboards and worksheets in Tableau.
- Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
- Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.
- Trend Lines, Statistics, and Log Axes. Groups, hierarchies, sets to create detail level summary report and Dashboard using KPI's.
- Interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets.
- Defined best practices for Tableau report development and effectively used data blending feature in tableau.
- Create, customize & share interactive web dashboards in minutes with simple drag & drop method and access dashboards from any browser or tablet.
- Connect to Oracle directly, created the dimensions, hierarchies, and levels on Tableau desktop.
- Creating users, groups, projects, Data connections, settings as a tableau administrator.
- Involved in creating dashboards and reports in Tableau 8.1 and Maintaining server activities, user activity, and customized views on Server Analysis.
- Good SQL reporting skills with the ability to create SQL views and write SQL queries highly recommended.
Environment: Tableau Desktop, AWS, Tableau Server, Crystal Reports, MS Visio, SQL, T-SQL, OBIEE 10.1.3.2/ 10.1.3.3
Confidential
Software Developer / Power BI Consultant
Responsibilities:
- Worked on multiple Mobile applications, games, and simulations.
- Built, Tested and Deployed projects.
- Worked as part of the team for gathering and analyzing the requirements.
- Handled projects individually and independently.
- Involved in the complete lifecycle of projects from requirement gathering, designing, developing, and testing the application.
- Experience adding various plugins, ads etc., for the application.
- Performed optimization to improve speed, size, and efficiency of the application.
- Used C# and JavaScript within Unity to develop the application.
- Performed debugging and testing on several projects to meet the deadline and align with the firm’s need.
- Handled Game Play Programming to improve the design and game play of the application.
- Worked on multiple projects at the same time within the team and handled multiple tasks.
- Involved in the development of custom stored procedures, functions.
- Involved in the optimization of SQL queries which resulted in substantial performance improvement for the conversion processes.
- Developed SSIS Packages for migrating data from different Staging Area.
- Implemented the Master Child Package Model for easier maintenance and better performance of SSIS Packages.
- Handled Full load and refresh load via staging tables in the ETL Layer.
- Build reports usingPower BI usingPower BIdesktop and deployed toPower BI Service in cloud and deployed to deployed to Internal & external client& workspaces.
- Designed and implemented SSAS Tabular Cube as the reporting layer. And Used DAX scripting to access data from Tabular Model.
- Designed Data Model inPower BIDesigner according to the Structure and Hierarchy of Data.
- Worked on KPI (Key Performance Indicators) inPower BI to track the progress & reach goals.
- Deployed Dashboards Reports and Data sources in thePower BIService.
- Familiar with Direct/Import Query connection inPower BIDesktop.
- Installed and administered Microsoft SQL Server, SQL Server Integration Services, SQL Server Reporting Services, and Team Foundation Server.
Environment: Unity3D, C#, JavaScript, C++, Microsoft Visual Studio, Notepad++, UDK, Asset Control DW Solution, Oracle DB, MySQL DB, Unix, MS Excel, Power BI Desktop